How to use the feature
- Open Calculations, choose New calculation, then Mortgage payment estimate.
- Enter the amount borrowed after your down payment, an annual interest rate, and an amortization period in whole years.
- Choose semiannual or monthly interest compounding to match the assumption you want to model.
- Review the estimate and choose Use estimate. Save the resulting calculation to keep the snapshot.
Example
With a loan amount of 100,000, an annual rate of 4%, a 30-year amortization, and monthly compounding, estimated monthly principal and interest is 477.42. This does not include taxes, insurance, or fees.
Read the assumptions
The estimate assumes monthly payments and an unchanged rate for the full amortization period. It excludes property taxes, insurance, fees, and changes at renewal. Total paid and interest are estimated using unrounded payments; lender rounding and the final payment can differ.
A snapshot, not a live mortgage account
Use estimate writes the inputs, assumptions, and result into calculation rows. Editing the saved text does not rerun the mortgage formula. To calculate a different loan scenario, create a new mortgage estimate with the new inputs. The template does not connect to a lender or track actual repayments.
Frequently asked questions
Is amortization the same as a mortgage term?
The input here is the number of years over which the estimate pays off the loan. The calculation does not model a separate rate-renewal term.
Are taxes and insurance included?
No. The output is principal and interest only. Include other housing costs separately when planning your budget.