Real Estate
Real Estate articles
Guides and examples for solving real estate calculations with more context.
Real Estate · 5 min read
Mortgage payment formula in Excel and Google Sheets
Use the PMT function with a monthly rate and total payment count, then validate the result.
Read articleReal Estate · 6 min read
15-, 20-, 25- or 30-year mortgage: which term fits?
Compare payment and lifetime interest across common mortgage terms using the same principal and rate.
Read articleReal Estate · 5 min read
Apoyo Infonavit with a bank mortgage
Understand how Apoyo Infonavit may interact with bank financing and which current terms require official confirmation.
Read articleReal Estate · 6 min read
Bank mortgage vs. Infonavit credit
Compare the general structure of a Mexican bank mortgage with Infonavit housing credit.
Read articleReal Estate · 5 min read
Mortgage prepayment: reduce the term or the payment?
Compare shortening a mortgage with lowering its monthly payment after an early principal payment.
Read articleReal Estate · 5 min read
How to convert an annual mortgage rate to a monthly rate
Convert a nominal annual mortgage rate for monthly payment and amortization calculations.
Read articleReal Estate · 5 min read
Fixed vs. variable mortgage rates
Compare payment certainty under a fixed rate with the potential increases and decreases of a variable-rate mortgage.
Read articleReal Estate · 6 min read
How to calculate total mortgage interest
Estimate lifetime mortgage interest and see how rate, term and extra principal payments change it.
Read articleReal Estate · 6 min read
How to build a mortgage amortization schedule in Excel
Create monthly payment, interest, principal and balance formulas in Excel or Google Sheets.
Read articleReal Estate · 6 min read
Extra mortgage payments: how they can save interest
See how additional principal payments can shorten a mortgage and reduce lifetime interest.
Read articleReal Estate · 5 min read
Notary, appraisal and tax costs on a Mexican mortgage
Identify notary, appraisal, tax, registration, insurance and lender costs that sit outside principal and interest.
Read articleReal Estate · 5 min read
How much can I borrow for a home?
Estimate mortgage principal from a target payment, rate and term without treating the result as lender approval.
Read article