{"text_format":"1","workbook":"xls","n_sheets":1,"sheets":["Mortgage Qualification"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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","formulas":"cached_only"}

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