Mortgage Calculation Template (Sheet): Parameter Name · Value · Description · Home Price · 450000 USD · The total purchase price of the home · Down Payment ·…
| A | B | C |
|---|---|---|
| Parameter Name | Value | Description |
| Home Price | 450000 USD | The total purchase price of the home |
| Down Payment | 90000 USD | The down payment amount (e.g., 20% of purchase price) |
| Loan Amount | =B2 - B3 | The total loan amount after down payment |
| Interest Rate | 3.8 % | The annual interest rate in percent |
| Loan Term | 30 years | The duration of the mortgage loan |
| Monthly Interest Rate | =B5 / 12 | The interest rate divided by 12 months |
| Total Months | =B6 to month | The total number of monthly payments |
| Monthly Payment | =B4 * (B7 * (1 + B7)^(B8 / 1 month)) / ((1 + B7)^(B8 / 1 month) - 1) | The calculated monthly principal and interest payment |