{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Mortgage Qualification"],"not_rendered":{"images":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Mortgage Qualification","index":0,"n_rows":51,"n_cols":11,"rows_kept":51,"merged":[[3,1,3,3],[4,1,4,3],[4,7,4,10],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,7,9,10],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[26,4,26,9],[27,4,27,9],[28,4,28,9],[42,4,42,9],[43,4,43,9],[44,4,44,9],[45,4,45,9],[46,4,46,9],[47,4,47,9],[48,4,48,9],[50,4,50,9]],"flags":["formulas_cached_only"]}
[null,"Mortgage Qualification Worksheet "]
[]
[null,null,"Income",null,"Annual Income","Monthly Income"]
[null,"Salary or wages",null,null,{"v":65000,"d":"$65,000.00"},{"v":5416.666666666667,"d":"$5,416.67"}]
[null,"Other salary or wages",{"$nulls":3},"",null,"First Qualifying Number"]
[null,"Rental income",{"$nulls":3},"",{"$nulls":4},{"v":65250,"d":"$65,250.00"}]
[null,"Investment income",null,null,{"v":250,"d":"$250.00"},{"v":20.833333333333332,"d":"$20.83"},null,null,"x 0.28","=",{"v":18270,"d":"$18,270.00"}]
[null,"Additional income",{"$nulls":3},"",null,null,"/12","=",{"v":1522.5,"d":"$1,522.50"}]
[null,"Total Income",null,null,{"v":65250,"d":"$65,250.00"},{"v":5437.5,"d":"$5,437.50"}]
[{"$nulls":7},"Second Qualifying Number"]
[null,null,"Long-Term Debts",null,"Monthly Debt","Annual Debt",{"$nulls":4},{"v":65250,"d":"$65,250.00"}]
[null,"Car loan payments",null,null,{"v":250,"d":"$250.00"},{"v":3000,"d":"$3,000.00"},null,null,"x 0.36","=",{"v":23490,"d":"$23,490.00"}]
[null,"Credit card payments",null,null,{"v":200,"d":"$200.00"},{"v":2400,"d":"$2,400.00"},null,null,"/12","=",{"v":1957.5,"d":"$1,957.50"}]
[null,"Other loan payment",{"$nulls":3},"",{"$nulls":4},{"v":1507.5,"d":"$1,507.50"}]
[null,"Other loan payment",{"$nulls":3},""]
[null,"Total Debts",null,null,{"v":450,"d":"$450.00"},{"v":5400,"d":"$5,400.00"}]
{"$rows_empty":10}
[{"$nulls":4},"Housing cost ratio",{"$nulls":5},0.28]
[{"$nulls":4},"Total debt service ratio",{"$nulls":5},0.36]
[{"$nulls":4},"You may qualify for monthly payments of",{"$nulls":5},{"v":1507.5,"d":"$1,507.50"}]
{"$rows_empty":13}
[{"$nulls":4},"Total monthly payment allowed ",{"$nulls":5},{"v":1507.5,"d":"$1,507.50"}]
[{"$nulls":4},"Estimated monthly escrow payment ",{"$nulls":5},{"v":100,"d":"$100.00"}]
[{"$nulls":4},"Homeowner's insurance, if applicable ",{"$nulls":5},{"v":75,"d":"$75.00"}]
[{"$nulls":4},"Homeowner's dues and other fees, if any ",{"$nulls":5},{"v":125,"d":"$125.00"}]
[{"$nulls":4},"Annual interest rate (e.g., 7.125) ",{"$nulls":5},8.25]
[{"$nulls":4},"Duration of loan (in years) ",{"$nulls":5},30]
[{"$nulls":4},"Monthly principal + interest payment ",{"$nulls":5},{"v":1207.5,"d":"$1,207.50"}]
[]
[{"$nulls":4},"Maximum loan amount ",{"$nulls":5},{"v":160728.56073849232,"d":"$160,728.56"}]