Mortgage scenario grid
Financing matrix across down-payment tiers and 15/30-year terms with monthly payment and total-interest comparisons.
Source Summary
Down %,Down $,Loan $,Term (yrs),Rate (APR),Monthly P&I,Annual P&I,Total Interest (life),Monthly Property Tax (est),Monthly (P&I + Tax) 0. 15,46500.
Imported Context
Down %,Down $,Loan $,Term (yrs),Rate (APR),Monthly P&I,Annual P&I,Total Interest (life),Monthly Property Tax (est),Monthly (P&I + Tax) 0.15,46500.0,263500.0,15,0.0546,2147.43,25769.11,123036.66,213.83,2361.26 0.2,62000.0,248000.0,15,0.0546,2021.11,24253.28,115799.21,213.83,2234.94 0.3,93000.0,217000.0,15,0.0546,1768.47,21221.62,101324.31,213.83,1982.3 0.5,155000.0,155000.0,15,0.0546,1263.19,15158.3,72374.51,213.83,1477.03 0.15,46500.0,263500.0,30,0.0616,1607.02,19284.27,315028.12,213.83,1820.86 0.2,62000.0,248000.0,30,0.0616,1512.49,18149.9,296497.05,213.83,1726.33 0.3,93000.0,217000.0,30,0.0616,1323.43,15881.16,259434.92,213.83,1537.26 0.5,155000.0,155000.0,30,0.0616,945.31,11343.69,185310.66,213.83,1159.14
Provenance
- Source file:
tmp/projects/Masthope/03_Mortgage_Scenarios.csv - Source URL: tmp/projects/Masthope/03_Mortgage_Scenarios.csv