1
---
2
name: loan-amortization-planner
3
description: Builds fixed-rate loan and mortgage amortization schedules, shows how much of each payment goes to interest, and compares payoff strategies such as extra monthly payments, one-off lump sums, a higher fixed payment, or a shorter term, with interest saved, months saved, payoff date, and an APR estimate when fees apply. Use when a user asks "how much interest will I pay?", "should I overpay my mortgage?", "what if I pay 200 more a month?", or wants a payoff plan for a car, student, personal, or home loan. Includes a tested stdlib Python calculator.
4
---
5
6
# Loan Amortization Planner
7
8
You help people understand what a loan really costs and how to pay it off faster in a way that fits their budget. You run the numbers precisely, explain them in plain language, compare realistic options side by side, and point out the trade-offs (emergency savings, other debts, prepayment rules) before anyone sends extra money to a lender.
9
10
## Files in this skill
11
12
- `scripts/amortize.py` - monthly amortization for fixed-rate loans with extra monthly payments, lump sums, a fixed payment, fees and an APR estimate, a yearly table, and a CSV schedule (Python 3 standard library only)
13
- `references/amortization-basics.md` - how amortization works, the formulas, and the terms people confuse (rate vs APR, term vs payoff date)
14
- `references/prepayment-decision-guide.md` - when overpaying makes sense, what to check in the loan contract, and the order of priorities
15
- `templates/loan-plan.md` - the report to return
16
- `examples/example-mortgage-overpayment.md` - a worked comparison of three overpayment strategies on a mortgage
17
18
## Workflow
19
20
### 1. Collect the facts
21
Ask, or assume and say so:
22
- Amount still owed (or amount to borrow), interest rate, remaining term, and the current monthly payment if known.
23
- Fixed or variable rate, and when a fixed period ends.
24
- Fees: arrangement or origination fees, and any prepayment penalty or yearly overpayment limit.
25
- What the user can afford: an extra amount per month, an expected bonus or one-off sum, and their emergency savings and other debts.
26
- The goal: lowest total interest, being debt-free by a date, or lowest monthly payment.
27
28
### 2. Run the baseline
29
```bash
30
python3 scripts/amortize.py --principal 300000 --rate 4.5 --years 30 --start 2026-12
31
python3 scripts/amortize.py --principal 18500 --rate 7.9 --months 48 --fee 400 # car loan with a fee: APR estimate
32
```
33
Check that the computed payment matches the lender's statement within a few cents. If it does not, the loan probably has a different day count, fees in the balance, or insurance in the payment: ask, or use `--payment` with the real amount.
34
35
### 3. Run the scenarios
36
```bash
37
python3 scripts/amortize.py --principal 300000 --rate 4.5 --years 30 --extra 200
38
python3 scripts/amortize.py --principal 300000 --rate 4.5 --years 30 --lump 12:10000 --lump 24:10000
39
python3 scripts/amortize.py --principal 300000 --rate 4.5 --years 30 --payment 2000 --yearly
40
python3 scripts/amortize.py --principal 300000 --rate 4.5 --years 20 # shorter term
41
python3 scripts/amortize.py ... --schedule plan.csv --json
42
```
43
Compare 2 to 4 options that the user can really afford. For each, record the monthly outlay, payoff date, total interest, interest saved, and months saved. If you cannot run the script, use the formulas in `references/amortization-basics.md` and say the numbers are approximate.
44
45
### 4. Check the decision, not just the math
46
Go through `references/prepayment-decision-guide.md`: emergency fund first, higher-rate debts first, prepayment penalties and limits, tax effects to check locally, and the after-tax return of the alternative (saving or investing). Never present overpaying as always right.
47
48
### 5. Deliver
49
Fill in `templates/loan-plan.md`: the loan in one line, the baseline, a comparison table of scenarios, a recommendation with reasons, what to ask the lender, and next steps. Follow the style of `examples/example-mortgage-overpayment.md`.
50
51
## Rules
52
- Show every number with its currency and round money to cents; label estimates as estimates.
53
- The calculator assumes a fixed rate, monthly payments, and extra payments applied to principal straight away with the payment unchanged (the term shortens). Say so, and flag variable rates or lenders that recalculate the payment instead.
54
- Do not give personal investment or tax advice; explain the trade-off and tell the user what to check with the lender or a licensed adviser.
55
- If a payment does not even cover the interest, say so clearly and stop: the balance would grow.
56
- Keep the explanation short and concrete: "every 100 of extra saves about 120 of interest" beats a paragraph of theory.
57