{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Debt Ratio"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Debt Ratio","index":0,"n_rows":48,"n_cols":14,"rows_kept":48,"merged":[[0,3,1,11],[4,13,6,21]]}
[{"$nulls":3},"TheMortgageGeek.com"]
[]
[]
[{"$nulls":3},"Mortgage Details"]
[{"$nulls":3},"Purchase",{"v":500000,"d":"$500,000"},null,{"$f":"(E5-E7)/E5","v":{"v":0.2,"d":"20%"}},{"$nulls":6},"This calculator is meant to be used as an estimate. Various banks / entities may use different algorithms to calculate the debt ratio."]
[{"$nulls":3},"Down Pmt",{"v":0.2,"d":"20%"},null,{"$f":"E5-E7","v":{"v":100000,"d":"$100,000"}}]
[{"$nulls":3},"Loan Amt",{"$f":"IF(E6<1,E5*(1-E6),E5-E6)","v":{"v":400000,"d":"$400,000"}}]
[{"$nulls":3},"Rate",{"v":0.07,"d":"7.000%"},{"$nulls":3},"Housing Debt Ratio",null,{"$f":"K19/F23","v":{"v":0.35689679845733857,"d":"35.69%"}}]
[{"$nulls":3},"Term",30,{"$nulls":3},"Total Debt Ratio",null,{"$f":"(K19+E48)/F23","v":{"v":0.35689679845733857,"d":"35.69%"}}]
[]
[{"$nulls":3},"INCOME:",{"$nulls":9},"Notes:"]
[{"$nulls":4},"Annual","Monthly",null,null,"Mortgage PMT",null,{"$f":"-PMT(E8/12,E9*12,E7)","v":{"v":2661.209980716733,"d":"$2,661.21"}},null,null,"Use a 30 Year term for all Amortizing ARMs"]
[{"$nulls":3},"B1 Base Salary",{"v":100000,"d":"$100,000"},{"$f":"E13/12","v":{"v":8333.333333333334,"d":"$8,333.33"}},false,null,"RE Taxes",null,{"v":1500,"d":"$1,500"},null,null,"Use a 20 Year term for all Interest Only ARMs"]
[{"$nulls":3},"B1 Bonus",{"v":0,"d":"$0"},{"$f":"E14/12","v":{"v":0,"d":"$0.00"}},false,null,"Hazzard Insurance",null,{"v":300,"d":"$300"},null,null,"ARMS are qualified at the \"Fully Indexed Rate\"; not the note rate."]
[{"$nulls":3},"B2 Base Salary",{"v":50000,"d":"$50,000"},{"v":4166.666666666667,"d":"$4,166.67"},false,null,"HOA Dues",null,{"v":0,"d":"$0"},null,null,"If you are not sure of the fully indexed rate; add 2 points to the rate as an estimate."]
[{"$nulls":3},"Income 4",{"v":0,"d":"$0"},{"v":0,"d":"$0.00"},false,null,"Flood Ins",null,{"v":0,"d":"$0"}]
[{"$nulls":3},"Income 5",{"v":0,"d":"$0"},{"v":0,"d":"$0.00"},false,null,"PMI",null,{"v":0,"d":"$0"}]
[{"$nulls":3},"Income 6",{"v":0,"d":"$0"},{"v":0,"d":"$0.00"},false,null,"Other",null,{"v":0,"d":"$0"}]
[{"$nulls":3},"Income 7",{"v":0,"d":"$0"},{"v":0,"d":"$0.00"},false,null,"Housing Payment",null,{"$f":"SUM(K12:K18)","v":{"v":4461.209980716732,"d":"$4,461"}}]
[{"$nulls":3},"Income 8",{"v":0,"d":"$0"},{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Income 9",{"v":0,"d":"$0"},{"v":0,"d":"$0.00"},false,null,"Other Monthly Debt",null,{"$f":"SUM(_xlfn._xlws.FILTER(CCBalance,CCIgnore=FALSE))","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Income 10",{"v":0,"d":"$0"},{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Total Income",{"$f":"SUM(_xlfn._xlws.FILTER(AIncome,IncIgnore=FALSE))","v":{"v":150000,"d":"$150,000"}},{"$f":"SUM(_xlfn._xlws.FILTER(MIncome,IncIgnore=FALSE))","v":{"v":12500,"d":"$12,500.00"}},null,null,"Total Monthly Debt",null,{"$f":"K19+E48","v":{"v":4461.209980716732,"d":"$4,461"}}]
[]
[{"$nulls":4},"Monthly"]
[{"$nulls":3},"LIABILITIES:","Payment"]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Credit Card",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Car Payment",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Car Payment",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"Car Payment",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"OTHER",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"OTHER",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"OTHER",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"OTHER",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"OTHER",{"v":0,"d":"$0.00"},false]
[{"$nulls":3},"OTHER",{"v":0,"d":"$0.00"},false]
[]
[{"$nulls":3},"Monthly Debt",{"$f":"SUM(_xlfn._xlws.FILTER(CCBalance,CCIgnore=FALSE))","v":{"v":0,"d":"$0"}}]