Input Section (User variables) | Parameter | Cell | Example | |-----------|------|---------| | Loan Amount | B2 | $250,000 | | Annual Interest Rate | B3 | 4.5% | | Loan Term (years) | B4 | 30 | | Payment Frequency | B5 | Monthly | | Extra Monthly Payment | B6 | $0 | | Start Date | B7 | Jan-2026 | Calculations Monthly Rate = B3/12 Number of Payments = B4*12 Base Payment = PMT(B3/12, B4*12, -B2) Total Payment = Base Payment + Extra Payment 2. Amortization Table (Columns) | A | B | C | D | E | F | G | |---|---|---|---|---|---|---| | Period | Date | Start Balance | Payment | Extra | Interest | Principal | End Balance |
MORTGAGE SIMULATION REPORT ======================================== Loan Amount $250,000 Interest Rate 4.50% Term 30 years Start Date Jan 2026 simulador hipoteca excel
| Metric | Formula | |--------|---------| | Total Payments | SUM(Payment Range) | | Total Interest | SUM(Interest Range) | | Total Principal | Loan Amount | | Payoff Years | MATCH(0, End Balance Range, 0)/12 | | Interest Savings vs. No Extra | Compare Total Interest with extra vs without | Input Section (User variables) | Parameter | Cell
