tables=({name="Table 1";categories=({name="Mortgage Items";nodes=({name="Amount Down";}, {name="Yearly Income";}, {name="Monthly Income";}, {name="House Price";}, {name="Mortgage Rate";}, {name=Term;}, {name="Monthly Payment";});}, {name=Scenarios;nodes=({name="Enter Salary";}, {name="Enter Price";}, {name="Enter Rate";}, {name="Enter Term";}, {name="Enter Payment";});});dataspace=(20000,65000,5416.66666666667,277674.4753334,.095,30,2166.66666666667,20000,65000,5416.66666666667,250000,.095,30,1933.96467651112,20000,65000,5416.66666666667,250000,.095,30,1933.96467651112,20000,65000,5416.66666666667,250000,.095,30,1933.96467651112,20000,81000,6750,341102.038492391,.095,30,2700);formulaspace={formulae=({formula="// Enter sample values in the white space, above, to see how changes in underlying data affect mortgage payments, term, rates, etc. See comments, below, for more information.";}, {formula="Monthly Income=Yearly Income/12 ";}, {formula="In Amount Down, Enter Price .. Enter Payment = Enter Salary";}, {formula="In Enter Price, Monthly Payment = pmt(House Price - Amount Down, Mortgage Rate/12, Term*12) ";}, {formula="In Enter Rate, Monthly Payment = pmt(House Price - Amount Down, Mortgage Rate/12, Term*12)";}, {formula="In Enter Payment, House Price = pv(Monthly Payment, Mortgage Rate/12, Term*12) + Amount Down";}, {formula="In Enter Term, Monthly Payment = pmt(House Price -Amount Down, Mortgage Rate/12, Term*12)";}, {formula="In Enter Salary, Monthly Payment = Yearly Income/12*.4 ";}, {formula="In Enter Salary, House Price = pv(Monthly Payment, Mortgage Rate/12, Term*12)+Amount Down ";}, {formula="Yearly Income = 65000 skip Enter Payment, Enter Salary // Assumes $65K a year ";}, {formula="// Use the first house price as the price for all homes, except for Enter Payment, where the allowable price is derived from a monthly payment value.";}, {formula="House Price = Enter Price:House Price skip Enter Salary, Enter Price";}, {formula="Mortgage Rate = .095 skip Enter Rate";}, {formula="// Lenders like to see your mortgage payment be no more than 40% of your gross compensation...";}, {formula="In Enter Payment, Yearly Income = Monthly Payment/.4*12 ";}, {formula="Term = 30 Skip Enter Term";});};});
