{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Income Calculation Worksheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Income Calculation Worksheet","index":0,"n_rows":93,"n_cols":25,"rows_kept":93,"cut":false,"hidden":false,"merged":[[92,18,92,22],[92,1,92,17],[4,1,4,11],[4,12,4,22],[22,1,22,2],[23,1,23,2],[38,12,38,13],[90,4,90,6],[72,10,72,11],[80,15,80,17],[15,10,16,11],[15,4,16,5],[18,1,18,2],[19,1,19,2],[8,1,8,2],[9,1,9,2],[5,3,5,9],[5,14,5,20],[7,4,7,6],[8,4,8,6],[7,18,7,19],[8,18,8,19],[7,7,7,8],[8,7,8,8],[35,1,35,2],[34,4,34,6],[34,10,34,11],[59,6,59,8],[59,17,59,19],[66,1,66,11],[35,10,35,11],[14,12,14,13],[15,1,15,2],[15,7,15,8],[14,10,14,11],[29,10,29,11],[31,1,31,2],[32,1,32,2],[31,6,31,8],[32,6,32,8],[34,1,34,2],[46,10,46,11],[8,21,8,22],[9,21,10,22],[1,14,1,22],[3,5,3,11],[3,16,3,22],[8,12,8,13],[9,7,9,8],[10,7,10,8],[8,10,8,11],[12,3,12,9],[12,14,12,20],[9,18,9,19],[10,18,10,19],[91,15,91,17],[37,1,37,2],[38,1,38,2],[37,4,37,6],[37,10,37,11],[38,4,38,6],[38,10,38,11],[40,7,40,9],[86,1,86,2],[90,1,90,2],[91,1,91,2],[80,1,80,2],[81,1,81,2],[80,10,80,11],[81,10,81,11],[80,4,80,6],[91,12,91,13],[91,4,91,6],[49,12,49,13],[46,15,46,17],[90,15,90,17],[9,12,9,13],[9,10,10,11],[9,4,9,6],[10,4,10,6],[1,12,1,13],[15,12,15,13],[34,12,34,13],[37,12,37,13],[80,12,80,13],[77,1,77,11],[14,1,14,2],[14,4,14,5],[14,7,14,8],[70,10,70,11],[72,1,72,2],[72,4,72,6],[42,1,42,11],[42,12,42,22],[44,4,44,6],[44,10,44,11],[44,15,44,17],[44,21,44,22],[46,4,46,6],[46,21,46,22],[48,1,48,2],[48,6,48,8],[15,21,16,22],[23,12,23,13],[35,4,35,6],[34,21,34,22],[35,12,35,13],[35,15,35,17],[35,21,35,22],[34,15,34,17],[22,12,22,13],[17,3,17,9],[17,14,17,20],[18,6,18,8],[18,12,18,13],[18,17,18,19],[19,6,19,8],[19,12,19,13],[19,17,19,19],[21,14,21,20],[27,10,27,11],[27,4,27,6],[29,4,29,6],[80,21,80,22],[68,1,68,11],[70,1,70,2],[70,4,70,6],[31,12,31,13],[21,3,21,9],[31,17,31,19],[32,12,32,13],[32,17,32,19],[25,1,25,11],[25,12,25,22],[57,6,57,8],[57,17,57,19],[55,1,55,2],[55,4,55,6],[55,10,55,11],[55,12,55,13],[55,15,55,17],[22,5,22,7],[22,16,22,18],[48,12,48,13],[48,17,48,19],[49,1,49,2],[49,6,49,8],[81,21,81,22],[85,12,85,13],[86,12,86,13],[90,12,90,13],[74,1,74,2],[74,6,74,8],[75,1,75,2],[75,6,75,8],[27,15,27,17],[27,21,27,22],[29,15,29,17],[29,21,29,22],[40,18,40,20],[37,15,37,17],[37,21,37,22],[38,15,38,17],[38,21,38,22],[81,12,81,13],[81,15,81,17],[77,12,77,22],[81,4,81,6],[85,1,85,2],[54,15,54,17],[54,21,54,22],[14,21,14,22],[15,15,16,16],[14,15,14,16],[14,18,14,19],[15,18,15,19],[66,12,66,22],[49,17,49,19],[51,1,51,2],[51,4,51,6],[51,10,51,11],[51,12,51,13],[51,15,51,17],[51,21,51,22],[52,1,52,2],[52,4,52,6],[52,10,52,11],[52,12,52,13],[52,15,52,17],[52,21,52,22],[55,21,55,22],[54,1,54,2],[54,4,54,6],[54,10,54,11],[54,12,54,13]]}
[]
[null,"Wage Earner Income Calculation Worksheet",null,null,null,null,null,null,null,null,null,null,"Loan #"]
[]
[null,null,null,null,"APPLICANT:",null,null,null,null,null,null,null,null,null,null,"CO-APPLICANT:",null,null,null,null,null,null,null,null,3]
[null,"MONTHLY INCOME",null,null,null,null,null,null,null,null,null,null,"MONTHLY INCOME",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"Full Time Employment",null,null,null,null,null,null,null,null,null,null,"Full Time Employment"]
[]
[null,null,null,null,null,null,null,173.33333333333334,null,null,null,null,null,null,null,null,null,null,173.33333333333334]
[null,null,null,null,null,null,null,{"$f":"52/12","v":4.333333333333333},null,null,{"$f":"IF(B9=\"\",\"\",IF(Y4=\"\",\"\",IF(Y4=1,(B9*H8),IF(Y4=2,(B9*H9),IF(Y4=3,(B9*H10),(B9*H11))))))","v":""},null,null,null,null,null,null,null,{"$f":"52/12","v":4.333333333333333},null,null,{"$f":"IF(M9=\"\",\"\",IF(Y5=\"\",\"\",IF(Y5=1,(M9*S8),IF(Y5=2,(M9*S9),IF(Y5=3,(M9*S10),(M9*S11))))))","v":""}]
[null,"(Base Pay)",null,null,null,null,null,{"$f":"26/12","v":2.1666666666666665},null,null,"(Monthly\nIncome)",null,"(Base Pay)",null,null,null,null,null,{"$f":"26/12","v":2.1666666666666665},null,null,"(Monthly\nIncome)"]
[null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null,null,"Less than 40 Hours",null,null,null,null,null,null,null,null,null,null,"Less than 40 Hours"]
[]
[null,null,null,"X",null,null,"X",{"$f":"52/12","v":4.333333333333333},null,"=",{"$f":"IF(OR(B15=\"\",E15=\"\"),\"\",(B15*E15*H15))","v":""},null,null,null,"X",null,null,"X",{"$f":"52/12","v":4.333333333333333},null,"=",{"$f":"IF(OR(M15=\"\",P15=\"\"),\"\",(M15*P15*S15))","v":""}]
[null,"(Hourly Rate)",null,null,"(Hrs per\nWeek)",null,null,null,null,null,"(Monthly\nIncome)",null,"(Hourly Rate)",null,null,"(Hrs per\nWeek)",null,null,null,null,null,"(Monthly\nIncome)"]
[]
[null,null,null,"Annual Income",null,null,null,null,null,null,null,null,null,null,"Annual Income"]
[null,null,null,"÷",12,"=",{"$f":"IF(B19=\"\",\"\",(B19/E19))","v":""},null,null,null,null,null,null,null,"÷",12,"=",{"$f":"IF(M19=\"\",\"\",(M19/P19))","v":""}]
[null,"(Annual)",null,null,null,null,"(Monthly Income)",null,null,null,null,null,"(Annual)",null,null,null,null,"(Monthly Income)"]
[]
[null,null,null,"Monthly",null,null,null,null,null,null,null,null,null,null,"Monthly"]
[]
[null,null,null,null,null,"(Monthly Income)",null,null,null,null,null,null,null,null,null,null,"(Monthly Income)"]
[]
[null,"BASE SALARY",null,null,null,null,null,null,null,null,null,null,"BASE SALARY"]
[]
[null,2014,"W2","=",null,null,null,"÷",12,"=",{"$f":"IF(E28=\"\",\"\",(E28/I28))","v":""},null,2014,"W2","=",null,null,null,"÷",12,"=",{"$f":"IF(P28=\"\",\"\",(P28/T28))","v":""}]
[]
[null,2013,"W2","=",null,null,null,"÷",12,"=",{"$f":"IF(E30=\"\",\"\",(E30/I30))","v":""},null,2013,"W2","=",null,null,null,"÷",12,"=",{"$f":"IF(P30=\"\",\"\",(P30/T30))","v":""}]
[]
[null,null,null,"÷",null,"=",{"$f":"IF(OR(B32=\"\",E32=\"\"),\"\",B32/E32)","v":""},null,null,null,null,null,null,null,"÷",null,"=",{"$f":"IF(OR(M32=\"\",P32=\"\"),\"\",M32/P32)","v":""}]
[null,"(YTD Paystub)",null,null,"(Mos)",null,"(Monthly Avg.)",null,null,null,null,null,"(YTD Paystub)",null,null,"(Mos)",null,"(Monthly Avg.)"]
[]
[null,{"$f":"IF(B32=\"\",\"\",B32)","v":""},null,"+",{"$f":"IF(E28=\"\",\"\",E28)","v":""},null,null,"÷",{"$f":"+I28+E32","v":12},"=",{"$f":"IF(OR(B35=\"\",E35=\"\",I35=\"\"),\"\",TEXT((B35+E35)/I35,\"$#,##0.00\"))","v":""},null,{"$f":"IF(M32=\"\",\"\",M32)","v":""},null,"+",{"$f":"IF(P28=\"\",\"\",P28)","v":""},null,null,"÷",{"$f":"+T28+P32","v":12},"=",{"$f":"IF(OR(M35=\"\",P35=\"\",T35=\"\"),\"\",TEXT((M35+P35)/T35,\"$#,##0.00\"))","v":""}]
[null,"(YTD Paystub)",null,null,"(Past Yr Income)",null,null,null,"(Mos)",null,"(Total Mo. Inc.)",null,"(YTD Paystub)",null,null,"(Past Yr Income)",null,null,null,"(Mos)",null,"(Total Mo. Inc.)"]
[]
[null,{"$f":"IF(B32=\"\",\"\",B32)","v":""},null,"+",{"$f":"IF(OR(E28=\"\",E30=\"\"),\"\",E28+E30)","v":""},null,null,"÷",{"$f":"+I28+I30+E32","v":24},"=",{"$f":"IF(OR(B38=\"\",E38=\"\",I38=\"\"),\"\",TEXT(((B38+E38)/I38),\"$#,##0.00\"))","v":""},null,{"$f":"IF(M32=\"\",\"\",M32)","v":""},null,"+",{"$f":"IF(OR(P28=\"\",P30=\"\"),\"\",P28+P30)","v":""},null,null,"÷",{"$f":"+T28+T30+P32","v":24},"=",{"$f":"IF(OR(M38=\"\",P38=\"\",T38=\"\"),\"\",TEXT(((M38+P38)/T38),\"$#,##0.00\"))","v":""}]
[null,"(YTD Paystub)",null,null,"(2 Yr Income)",null,null,null,"(Mos)",null,"(Total Mo. Inc.)",null,"(YTD Paystub)",null,null,"(2 Yr Income)",null,null,null,"(Mos)",null,"(Total Mo. Inc.)"]
[]
[null,null,null,null,null,null,"Monthly Base Income = ",null,null,null,null,null,null,null,null,null,null,"Monthly Base Income = "]
[]
[null,"BONUS / COMMISSION / OVERTIME",null,null,null,null,null,null,null,null,null,null,"BONUS / COMMISSION / OVERTIME"]
[]
[null,2014,"W2","=",null,null,null,"÷",12,"=",{"$f":"IF(E45=\"\",\"\",(E45/I45))","v":""},null,2014,"W2","=",null,null,null,"÷",12,"=",{"$f":"IF(P45=\"\",\"\",(P45/T45))","v":""}]
[]
[null,2013,"W2","=",null,null,null,"÷",12,"=",{"$f":"IF(E47=\"\",\"\",(E47/I47))","v":""},null,2013,"W2","=",null,null,null,"÷",12,"=",{"$f":"IF(P47=\"\",\"\",(P47/T47))","v":""}]
[]
[null,null,null,"÷",null,"=",{"$f":"IF(OR(B49=\"\",E49=\"\"),\"\",B49/E49)","v":""},null,null,null,null,null,null,null,"÷",null,"=",{"$f":"IF(OR(M49=\"\",P49=\"\"),\"\",M49/P49)","v":""}]
[null,"(YTD Paystub)",null,null,"(Mos)",null,"(Monthly Avg.)",null,null,null,null,null,"(YTD Paystub)",null,null,"(Mos)",null,"(Monthly Avg.)"]
[]
[null,{"$f":"IF(B49=\"\",\"\",B49)","v":""},null,"+",{"$f":"IF(E45=\"\",\"\",E45)","v":""},null,null,"÷",{"$f":"+I45+E49","v":12},"=",{"$f":"IF(OR(B52=\"\",E52=\"\",I52=\"\"),\"\",TEXT((B52+E52)/I52,\"$#,##0.00\"))","v":""},null,{"$f":"IF(M49=\"\",\"\",M49)","v":""},null,"+",{"$f":"IF(P45=\"\",\"\",P45)","v":""},null,null,"÷",{"$f":"+T45+P49","v":12},"=",{"$f":"IF(OR(M52=\"\",P52=\"\",T52=\"\"),\"\",TEXT((M52+P52)/T52,\"$#,##0.00\"))","v":""}]
[null,"(YTD Paystub)",null,null,"(Past Yr Income)",null,null,null,"(Mos)",null,"(Total Mo. Inc.)",null,"(YTD Paystub)",null,null,"(Past Yr Income)",null,null,null,"(Mos)",null,"(Total Mo. Inc.)"]
[]
[null,{"$f":"IF(B49=\"\",\"\",B49)","v":""},null,"+",{"$f":"IF(OR(E45=\"\",E47=\"\"),\"\",E45+E47)","v":""},null,null,"÷",{"$f":"+I45+I47+E49","v":24},"=",{"$f":"IF(OR(B55=\"\",E55=\"\",I55=\"\"),\"\",TEXT(((B55+E55)/I55),\"$#,##0.00\"))","v":""},null,{"$f":"IF(M49=\"\",\"\",M49)","v":""},null,"+",{"$f":"IF(OR(P45=\"\",P47=\"\"),\"\",P45+P47)","v":""},null,null,"÷",{"$f":"+T45+T47+P49","v":24},"=",{"$f":"IF(OR(M55=\"\",P55=\"\",T55=\"\"),\"\",TEXT(((M55+P55)/T55),\"$#,##0.00\"))","v":""}]
[null,"(YTD Paystub)",null,null,"(2 Yr Income)",null,null,null,"(Mos)",null,"(Total Mo. Inc.)",null,"(YTD Paystub)",null,null,"(2 Yr Income)",null,null,null,"(Mos)",null,"(Total Mo. Inc.)"]
[]
[null,null,null,null,null,"Additional Income = ",null,null,null,null,null,null,null,null,null,null,"Additional Income = "]
[]
[null,null,"TOTAL INCOME =",null,null,null,{"$f":"+H41+G58","v":0},null,null,null,null,null,null,"TOTAL INCOME =",null,null,null,{"$f":"+S41+R58","v":0}]
[]
[null,"Any Excessive increases?",null,null,null,null,null,null,null,null,null,null,"Any Excessive increases?"]
[]
[null,"Any excessive decreases?",null,null,null,null,null,null,null,null,null,null,"Any excessive decreases?"]
[]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,"Comments:"]
[]
[]
[null,"2106 EXPENSES"]
[]
[null,2014,null,"=",null,null,null,"÷",12,"=",{"$f":"IF(E71=\"\",\"\",(E71/I71))","v":""}]
[]
[null,2013,null,"=",null,null,null,"÷",12,"=",{"$f":"IF(E73=\"\",\"\",(E73/I73))","v":""}]
[]
[null,null,null,null,null,"=",{"$f":"+(E71+E73)/E75","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"(Mos)",null,"(Average Used)"]
[]
[null,"FIXED INCOME / ADDITIONAL INCOME",null,null,null,null,null,null,null,null,null,null,"FIXED INCOME / ADDITIONAL INCOME"]
[]
[null,"Retirement / Annuity / Other",null,null,null,null,null,null,null,null,null,null,"Retirement / Annuity / Other"]
[null,null,null,"or",null,null,null,"÷",12,"=",{"$f":"IF(E81=\"\",\"\",(E81/I81))","v":""},null,null,null,"or",null,null,null,"÷",12,"=",{"$f":"IF(P81=\"\",\"\",(P81/T81))","v":""}]
[null,"(Monthly)",null,null,"(Annual)",null,null,null,null,null,"(Monthly)",null,"(Monthly)",null,null,"(Annual)",null,null,null,null,null,"(Monthly)"]
[]
[null,"Child Support / Alimony",null,null,null,null,null,null,null,null,null,null,"Child Support / Alimony"]
[]
[]
[null,"(Monthly)",null,null,null,null,null,null,null,null,null,null,"(Monthly)"]
[]
[null,"Social Security / Disability",null,null,null,null,null,null,null,null,null,null,"Social Security / Disability"]
[]
[null,null,null,null,{"$f":"IF(B91=\"\",\"\",IF(Y91=1,B91,(B91*1.15)))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M91=\"\",\"\",IF(Y92=1,M91,(M91*1.15)))","v":""},null,null,null,null,null,null,null,null,1]
[null,"(Monthly)",null,null,"(Amount to Use)",null,null,null,null,null,null,null,"(Monthly)",null,null,"(Amount to Use)",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Revised 2-26-15"]