Loan mathematics, amortisation mathematics and mortgage mathematics turn principal, interest rates, repayment schedules, fees and time into a complete cash-flow system. The same present-value equation explains personal loans, car loans, student loans, mortgages, refinancing, balloon loans, fixed-rate periods, floating-rate resets and outstanding balances. What changes from product to product is not the foundation but the contract: when interest accrues, how principal is reduced, what benchmark is used, when rates reset and what fees or penalties alter the cash flows.
This Banking And Finance Mathematics flagship covers loan payment formulas, amortisation schedules, reducing balance and monthly rest, flat-rate versus effective interest rate, principal and interest allocation, prospective and retrospective balances, prepayments, partial prepayments, early repayment, refinancing, fixed and floating rates, SORA-linked mortgages, rate resets, grace periods, interest-only phases, balloon payments, mortgage affordability mathematics, tenure effects, total interest, fee-adjusted borrowing cost, scenario analysis, rounding, reconciliation and spreadsheet verification. It is educational mathematics, not personal financial advice.
The central proposition is that a loan is an exchange of dated cash flows, and every loan metric should be recoverable from that exchange. The borrower receives value at origination and returns value through repayments and charges. If the timeline is explicit, the instalment, effective cost, outstanding balance and refinancing value can all be derived and checked. This page builds directly on Annuities and Equations of Value, Interest Rates and Time Value of Money.
The 50-Second Router
- Level-payment loan: principal equals the present value of repayments.
- Monthly payment: match the periodic rate to the monthly payment interval before applying the annuity formula.
- Amortisation: interest is calculated first on the relevant outstanding balance; the rest of the payment reduces principal.
- Monthly rest: interest is based on the reducing outstanding balance.
- Flat rate: interest may be quoted against original principal, so the effective borrowing cost can be materially higher.
- Outstanding balance: value remaining payments prospectively or reconstruct the balance retrospectively.
- Prepayment: insert the lump sum on its actual date, apply contract rules and recompute the future schedule.
- Floating rate: separate benchmark, spread, reset convention and repayment recalculation.
- Refinancing: compare complete incremental cash flows, including fees and penalties, at one focal date.
- Best check: every amortisation row should satisfy beginning balance + interest − payment = ending balance, subject to stated fee and rounding rules.
A loan schedule is not a table of numbers. It is a conservation system: every dollar must be traceable to principal, interest, fees, cash received or cash repaid.
1. A Loan Is a Two-Sided Cash-Flow Contract
From the borrower’s perspective, loan proceeds are an inflow at origination and repayments are later outflows. From the lender’s perspective, the signs reverse. The economics are the same; the sign convention changes with viewpoint.
A mathematical model begins by deciding whose viewpoint it uses and then applying that sign convention consistently. Many spreadsheet IRR errors come from mixing perspectives halfway through the cash-flow series.
Once the signs and dates are fixed, the loan becomes an equation of value rather than a special mystery.
2. The Standard Level-Payment Loan
For principal L, periodic effective rate i and n end-of-period payments R, the basic equation is L=R(1−v^n)/i, with v=1/(1+i). Solving for R gives the level payment.
The formula is the present value of an annuity-immediate. It assumes a fixed periodic rate, equal payment intervals and the specified timing.
Real contracts may add fees, changing rates or irregular dates, but the standard model is the reference point from which complications can be measured.
3. Converting the Rate Before Calculating the Payment
A monthly repayment schedule needs a monthly rate. If the quoted rate is nominal annual convertible monthly, the periodic rate is the nominal rate divided by twelve. If it is annual effective, the exact monthly equivalent is obtained by a twelfth root.
Using the wrong conversion can change every payment and every balance. The error compounds across long tenures.
Rate basis is therefore not a formatting detail; it is part of the loan contract model.
4. The Amortisation Recursion
A simple amortisation row follows B_t=B_{t-1}(1+i)−R for a fixed periodic rate and end-of-period payment. Interest for the period is i times the beginning balance; principal reduction is R minus that interest.
This recursion creates the full schedule from the opening principal. It also explains why early payments often contain more interest: the outstanding balance is initially larger.
Each row should reconcile arithmetically. If it does not, rounding, fees or timing rules need to be identified.
5. Interest Component and Principal Component
A payment is not ‘mostly interest because the bank chooses it that way’ under a standard amortisation formula. The split emerges from applying the contractual rate to the outstanding balance and using the remainder to reduce principal.
As balance falls, the same fixed payment generally allocates less to interest and more to principal. The total payment can stay constant while its composition changes.
Understanding this mechanism helps readers interpret amortisation schedules without treating them as opaque lender tables.
6. Monthly Rest
MoneySense explains monthly rest as interest calculated on the outstanding loan balance. As principal is repaid, the balance used for later interest calculations falls.
This structure is mathematically aligned with standard reducing-balance amortisation. A fixed-rate monthly-rest loan can therefore be represented cleanly with the recurring balance equation.
A floating monthly-rest loan adds a changing periodic rate, so the recursion becomes rate-dependent by period.
7. Flat-Rate Loans
Under a flat-rate quotation, interest can be calculated from original principal throughout the term even though the borrower is gradually repaying principal. The total stated interest can then be distributed across instalments.
Because the borrower does not retain use of the full original principal for the entire term, the cash-flow effective rate is higher than the flat percentage suggests.
MoneySense therefore emphasises Effective Interest Rate for fairer borrowing comparisons.
8. Effective Interest Rate
The effective borrowing cost is a yield on the actual borrower cash flows. Use the net amount received at origination after relevant upfront deductions, then include every repayment and fee on its date and solve for the periodic rate.
This is an internal-rate problem and may require numerical root finding. It is not always obtained by a simple multiple of the advertised rate.
Payment frequency matters because earlier repayments return principal sooner, changing the economic cost even if nominal total repayment is unchanged.
9. Prospective Balance
After k payments, the prospective balance is the present value at time k of remaining repayments under the applicable valuation assumptions.
The method ignores the historical path because the remaining contractual cash flows completely describe the forward obligation in the clean fixed-rate model.
It is especially useful for checking payoff schedules and understanding how much of the loan remains economically unpaid.
10. Retrospective Balance
The retrospective balance accumulates the original principal to time k and subtracts the accumulated value of all payments already made.
It uses past cash flows rather than future cash flows. Under the same fixed-rate assumptions, it should equal the prospective balance.
This duality is one of the strongest reconciliation tests in financial mathematics.
11. Payoff Amount Versus Scheduled Balance
A contractual payoff quote can differ from a simple scheduled principal balance because accrued interest, fees, prepayment charges, suspense amounts or timing conventions may be included.
The mathematical balance is therefore a component of a real payoff amount, not automatically the whole amount due on a chosen date.
Operational definitions matter. A model should distinguish scheduled principal, accrued interest and other settlement items.
12. Partial Prepayment
A partial prepayment inserts an extra principal-reducing cash flow. What happens afterward depends on the contract: tenure may shorten, instalment may change, or the schedule may be recast under specified rules.
Mathematically, the balance immediately after prepayment is the prior balance minus the amount applied to principal, subject to any charges or allocation rules.
The future schedule must then be rebuilt from that new state rather than pretending the original amortisation path continues unchanged.
13. Full Prepayment
Full prepayment replaces all remaining scheduled cash flows with a settlement amount today. A fair comparison values both alternatives at the same date and includes any penalty or administrative cost.
From a modelling perspective, early repayment is a termination event. It changes the duration and interest exposure of both borrower and lender.
The existence of a lower nominal interest bill after prepayment does not by itself answer a personal financial decision; opportunity cost and contract terms also matter.
14. Refinancing
Refinancing pays off an existing loan and creates a new one. The correct comparison uses incremental cash flows: old remaining payments avoided, new payments incurred, fees, penalties and any cash-out amount.
A lower new rate may save interest but fees can offset the benefit. Remaining tenure is crucial because there may be too little time for savings to recover transaction costs.
Present-value comparison turns the decision into a transparent break-even problem.
15. Fixed-Rate Periods
A mortgage can fix its rate for an initial period and then reset. The first phase is valued and amortised under one rate; the remaining balance at reset becomes the starting principal for the next phase.
A promotional rate therefore should not be extrapolated across the entire tenure unless the contract actually fixes it that long.
MoneySense advises readers to understand what monthly payments may become after promotional periods end.
16. Floating-Rate Loans
A floating-rate loan references a benchmark or lender-determined rate that can change. The cash-flow model must specify reset dates, observation rules, spreads, floors and how instalments are recalculated.
Some loans keep the remaining tenure and recalculate payment; others can have different mechanics. The contract determines the recursion.
Scenario analysis can show how payment and total interest respond to rate changes without pretending to predict future rates.
17. SORA-Linked Mortgages
In Singapore, floating loan structures may reference SORA or compounded SORA plus a spread. MAS administers SORA and publishes benchmark data and methodology; the loan agreement determines how the benchmark becomes a borrower rate.
A model must therefore separate benchmark mechanics from product mechanics. The same SORA observation can lead to different payable rates across products because spreads, reset frequencies and other terms differ.
This is a practical example of why rate source and contract rule are both part of the mathematics.
18. Rate Reset and Re-Amortisation
At a reset date, calculate the outstanding balance immediately before or after the scheduled payment according to the contract, then apply the new periodic rate to the remaining payment count.
Solving the annuity equation again gives a new level payment if the product recasts payment to preserve tenure.
The order of events matters: payment then reset is not always the same as reset then payment.
19. Interest-Only Periods
During an interest-only period, scheduled payments cover interest but do not reduce principal under the simplified model. The balance therefore stays roughly constant absent fees or capitalised items.
When amortisation begins, the original principal may need to be repaid over a shorter remaining period, increasing later instalments.
The low initial payment should therefore be read as a timing feature, not as evidence that the debt is being extinguished rapidly.
20. Grace Periods
A grace period can postpone payments. If interest accrues and is capitalised, the principal used for later amortisation grows during the grace interval.
The calculation has two stages: accumulate through the grace period, then value the repayment stream against the enlarged balance.
If interest is waived or subsidised, the cash-flow rule changes; the contract defines which model applies.
21. Balloon Payments
A balloon loan combines smaller periodic payments with a large final residual. Principal equals the present value of the periodic payments plus the present value of the balloon.
The balance falls more slowly because part of principal is intentionally left for the end.
A payment comparison that ignores the final balloon is incomplete even if the monthly instalment looks attractive.
22. Step-Up and Step-Down Loans
Some repayment schedules change payment amount by phase. The origination value is the sum of present values of each block, shifted to the correct dates.
A step-up structure may match expected income growth; a step-down structure may front-load repayment. The mathematics does not judge suitability—it makes timing explicit.
Piecewise annuity valuation is a reusable technique for many structured loans.
23. Fees and Charges
Processing, legal, valuation, amendment, cancellation, late-payment and early-repayment charges can create cash flows beyond interest and principal. MoneySense explicitly reminds borrowers that such costs can matter.
A complete borrowing-cost model places each relevant charge on its actual date. Upfront fees reduce net proceeds; later fees increase outflows.
Headline rate comparisons that ignore material fees are not complete economic comparisons.
24. Payment Frequency
Two loans with the same nominal principal, total interest and tenure can have different effective costs when repayment timing differs. MoneySense demonstrates that more frequent repayments can raise EIR because cash is returned earlier.
This is pure time value of money: the lender receives value sooner, so the cash-flow yield is higher.
Payment frequency must therefore be part of any effective-rate calculation.
25. Tenure
Longer tenure usually lowers periodic payment for a given principal and rate but increases the number of interest-accruing periods. Total interest can rise substantially.
Shorter tenure raises required payment but can reduce total interest. Neither statement by itself determines affordability or suitability for an individual.
Mathematics can show the trade-off curve between payment size, tenure and total interest.
26. Affordability Mathematics Versus Advice
A payment-to-income ratio, stress-payment calculation or cash-flow budget can quantify constraints. It does not replace personal judgement about job stability, emergency reserves, family obligations or risk tolerance.
This article therefore treats affordability as a modelling exercise: compute payments under scenarios, compare them with available cash-flow capacity, and expose sensitivity.
Individual borrowing decisions belong to the reader and, where appropriate, qualified professionals.
27. Interest Saved by Prepayment
A prepayment usually reduces future contractual interest because principal is lower earlier. The amount saved depends on when the prepayment occurs, the rate path, future schedule and any charges.
The nominal sum of avoided interest is different from the present value of the savings. Both measures can be useful if labelled correctly.
A mathematically careful comparison separates cash-flow savings from decision recommendations.
28. Rounding and the Final Payment
Loan systems often round periodic payments to cents. Repeating a rounded payment can leave a small residual at the end, so the final payment may be adjusted.
Internal calculations should usually retain greater precision than displayed amounts, then reconcile the contractually required final cash flow.
Rounding is not noise when millions of schedules or long tenures are involved; it is an operational rule.
29. Delinquency and Capitalised Charges
Missed payments can create arrears, late charges, additional interest or altered allocation rules. These are contract and jurisdiction dependent and cannot be inferred from the clean amortisation equation alone.
Mathematically, delinquency changes the state of the account and can introduce new cash flows or balance components.
A production model should distinguish scheduled amortisation from servicing rules for exceptions.
30. The Loan as a State Machine
At any date, a loan has a state: outstanding principal, accrued interest, next payment date, current rate, remaining tenure, fees and status. Each event moves the state forward.
Payments reduce components according to allocation rules; rate resets change future accrual; prepayments alter principal; missed payments can create arrears.
This state-machine view connects classroom amortisation to real banking systems while keeping every transition auditable.
31. Worked Loan and Mortgage Studios
Studio 01: Fixed monthly loan
Adrian’s setup. S$120,000 is repaid over 5 years with fixed monthly payments. Adrian begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to convert rate to monthly basis, solve annuity equation. The target is the monthly instalment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 02: Twenty-five-year mortgage
Jo’s setup. S$800,000 is repaid monthly. Jo begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to solve present-value annuity and show rate sensitivity. The target is the monthly instalment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 03: Tenure comparison
Aisha’s setup. same principal and rate use 20 versus 30 years. Aisha begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to compute both payments and total scheduled interest. The target is the tenure trade-off. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 04: Flat-rate car loan
Ryan’s setup. interest is quoted on original principal. Ryan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to build contractual instalments then solve cash-flow EIR. The target is the effective cost. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 05: Monthly-rest loan
Ben’s setup. interest applies to declining balance. Ben begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to recur balance month by month. The target is the amortisation schedule. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 06: Payment split
Mira’s setup. first payment is known. Mira begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to calculate interest on opening balance then principal as residual. The target is the principal-interest allocation. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 07: Balance after 12 payments
Clara’s setup. one year of monthly payments has passed. Clara begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to use prospective remaining-payment PV. The target is the outstanding balance. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 08: Retrospective balance check
Ethan’s setup. same loan after 12 payments. Ethan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to accumulate original principal and subtract accumulated payments. The target is the reconciled balance. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 09: Partial prepayment
Adrian’s setup. S$50,000 is paid against principal at month 36. Adrian begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to reduce balance and recast schedule per chosen rule. The target is the new payment or tenure. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 10: Full payoff
Jo’s setup. borrower settles before next instalment. Jo begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to combine outstanding principal, accrued interest and stated charges. The target is the payoff amount. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 11: Refinancing
Aisha’s setup. new loan rate is lower but has fees. Aisha begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to compare incremental old and new cash flows. The target is the refinancing NPV. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 12: Rate reset
Ryan’s setup. fixed period ends and rate rises. Ryan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to calculate balance then re-amortise remaining tenure. The target is the new instalment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 13: Rate decrease
Ben’s setup. floating benchmark falls. Ben begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to recalculate payment or interest under contract method. The target is the new cash flow. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 14: SORA plus spread
Mira’s setup. product references compounded SORA plus margin. Mira begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to apply official benchmark data according to contract then add spread convention. The target is the period rate. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 15: Interest-only phase
Clara’s setup. two years of interest-only payments precede amortisation. Clara begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to model phase one and remaining annuity. The target is the later instalment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 16: Grace period
Ethan’s setup. six months pass without scheduled payment while interest capitalises. Ethan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to accumulate balance then amortise. The target is the post-grace principal. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 17: Balloon payment
Adrian’s setup. monthly instalments leave S$100,000 at maturity. Adrian begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to value annuity plus discounted balloon. The target is the maximum principal. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 18: Step-up payments
Jo’s setup. payment rises after year three. Jo begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to split schedule into annuity blocks. The target is the origination PV. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 19: Step-down payments
Aisha’s setup. payment falls after year five. Aisha begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to split schedule into blocks. The target is the origination PV. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 20: Biweekly versus monthly
Ryan’s setup. repayment frequencies differ. Ryan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to place actual dates and solve effective cost. The target is the frequency comparison. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 21: Upfront fee
Ben’s setup. 1% processing fee is deducted from proceeds. Ben begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to use net cash received at time zero. The target is the fee-adjusted EIR. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 22: Legal fee
Mira’s setup. cash fee is paid separately at origination. Mira begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to include as borrower outflow. The target is the all-in cash-flow cost. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 23: Early repayment penalty
Clara’s setup. prepayment triggers contract fee. Clara begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to add penalty to settlement cash flow. The target is the net prepayment value. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 24: Promotional first year
Ethan’s setup. introductory rate applies for 12 months. Ethan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to amortise phase one, then reset on remaining balance. The target is the full schedule. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 25: Fixed versus floating scenarios
Adrian’s setup. same principal uses fixed rate or several floating paths. Adrian begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to calculate each scenario without predicting which will occur. The target is the cash-flow comparison. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 26: Stress +1 percentage point
Jo’s setup. rate rises by 1 percentage point at reset. Jo begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to recalculate monthly payment. The target is the payment sensitivity. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 27: Stress +2 percentage points
Aisha’s setup. larger shock is tested. Aisha begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to recalculate and compare with base. The target is the stress payment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 28: Prepayment keeps payment
Ryan’s setup. extra principal is paid but monthly payment stays. Ryan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to solve shortened tenure numerically or iteratively. The target is the new payoff date. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 29: Prepayment keeps tenure
Ben’s setup. extra principal is paid and maturity unchanged. Ben begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to solve annuity for smaller payment. The target is the new instalment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 30: Missed payment
Mira’s setup. one scheduled payment is not made. Mira begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to apply contract assumption to move account state forward. The target is the new balance. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 31: Capitalised fee
Clara’s setup. a financed fee is added to principal. Clara begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to increase initial financed balance. The target is the payment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 32: Cash fee
Ethan’s setup. same fee is paid separately. Ethan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to leave principal unchanged but include time-zero borrower outflow. The target is the EIR. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 33: Loan top-up
Adrian’s setup. additional principal is advanced midterm. Adrian begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to add new inflow at top-up date and re-amortise. The target is the new schedule. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 34: Payment holiday
Jo’s setup. three instalments are postponed. Jo begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to model interest and rescheduling assumptions explicitly. The target is the post-holiday balance. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 35: Variable payment
Aisha’s setup. borrower pays extra each month. Aisha begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to recur balance with actual payment sequence. The target is the payoff date. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 36: Lump-sum every year
Ryan’s setup. annual bonuses reduce principal. Ryan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to insert yearly prepayments. The target is the amortisation path. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 37: Rounding to cents
Ben’s setup. monthly payment is rounded. Ben begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to track residual and final adjusted payment. The target is the reconciled payoff. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 38: Zero-interest instalment
Mira’s setup. advertised 0% loan has an upfront fee. Mira begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to solve yield on net cash flows. The target is the effective cost. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 39: Zero-fee 0% loan
Clara’s setup. cash received equals repayments in nominal sum. Clara begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to verify EIR under actual schedule. The target is the effective rate. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 40: Deferred first payment
Ethan’s setup. repayments start three months after disbursement. Ethan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to accumulate during deferral then value annuity. The target is the payment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 41: Advance first payment
Adrian’s setup. first instalment occurs at origination. Adrian begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to use annuity-due timing. The target is the principal supported. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 42: Weekly loan
Jo’s setup. payments occur weekly. Jo begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to convert rate consistently or use actual-date factors. The target is the weekly payment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 43: Irregular construction draw
Aisha’s setup. loan principal is drawn in stages. Aisha begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to treat each draw as borrower inflow and interest base change. The target is the construction balance. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 44: Interest accrual between payments
Ryan’s setup. payment date shifts. Ryan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to calculate accrual using actual interval convention. The target is the adjusted payment allocation. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 45: Overpayment refund
Ben’s setup. loan ends with small credit due to rounding. Ben begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to reconcile cumulative cash flows. The target is the closing state. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 46: Payment allocation
Mira’s setup. cash is split among interest, principal and fees. Mira begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to apply stated allocation order. The target is the ending balances. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 47: Rate floor
Clara’s setup. floating rate cannot fall below floor. Clara begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to use floored contractual rate. The target is the payment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 48: Rate cap
Ethan’s setup. floating rate cannot rise above cap. Ethan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to use capped rate. The target is the payment. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 49: Spread change
Adrian’s setup. contractual margin changes after a period. Adrian begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to apply new spread at specified reset. The target is the new rate. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 50: Remaining-interest comparison
Jo’s setup. borrower asks how much scheduled interest remains. Jo begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to sum future interest components under the stated fixed-rate schedule. The target is the nominal remaining interest. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 51: PV of remaining payments
Aisha’s setup. same future payments are discounted at comparison rate. Aisha begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to compute economic PV rather than nominal sum. The target is the comparison value. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 52: Break-even refinance month
Ryan’s setup. monthly savings offset upfront costs over time. Ryan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to track cumulative and discounted savings. The target is the break-even timing. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 53: Debt consolidation
Ben’s setup. several loans are replaced by one. Ben begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to pay off old balances and model new loan as one cash-flow package. The target is the consolidated cost. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 54: Currency loan
Mira’s setup. principal and repayments are in another currency. Mira begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to keep currency cash flows separate and model FX explicitly if comparison requires. The target is the currency-aware value. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 55: Income stress
Clara’s setup. monthly payment is compared with several income scenarios. Clara begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to compute ratios without turning them into personalised advice. The target is the cash-flow stress. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 56: Rate-and-tenure grid
Ethan’s setup. payment is computed across rates and maturities. Ethan begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to build a two-dimensional sensitivity table. The target is the payment surface. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 57: Total-interest grid
Adrian’s setup. same scenarios are compared by nominal total interest. Adrian begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to sum payment minus principal under each fixed-rate scenario. The target is the interest surface. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 58: Effective-cost grid
Jo’s setup. fees vary across otherwise similar loans. Jo begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to solve cash-flow EIR for each package. The target is the comparable cost. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
Studio 59: Audit row
Aisha’s setup. one amortisation row is independently recomputed. Aisha begins with the borrower cash-flow timeline and the account state immediately before the event being modelled. That prevents principal, interest and fees from being blended into one unexplained balance.
Method. The disciplined move is to check beginning balance + interest − payment = ending balance. The target is the row reconciliation. For a schedule calculation, the periodic rate and event order are written explicitly: accrue interest, apply fees if the model requires them, receive the payment, allocate the payment, then determine the ending state. A different contract may specify a different order, so assumptions are labelled rather than hidden.
Verification. Reconcile the balance, compare a prospective and retrospective value where possible, and test a simple boundary such as zero fee, one payment or no rate change. The result should also move sensibly when the rate, prepayment or tenure changes. A loan model that cannot explain its state transition is not yet auditable.
92. The Amortisation Audit Checklist
- Confirm borrower or lender sign convention.
- Confirm net proceeds at origination, not just face principal.
- Match periodic rate to payment interval.
- Check whether rate is fixed, floating, nominal, effective or flat.
- Identify benchmark, spread, floor, cap and reset dates for floating products.
- Apply the correct event order within each payment period.
- Separate principal, accrued interest and fees.
- Reconcile every row to the next beginning balance.
- Check prospective and retrospective balances.
- Include prepayment penalties and transaction costs when modelling settlement.
- Carry adequate precision and reconcile the final payment.
- State that scenario results are conditional calculations, not predictions.
93. Singapore Mortgage Mathematics
Singapore home-loan mathematics uses the same amortisation foundation as mortgages elsewhere, but the relevant benchmarks, disclosure conventions and product structures are local. MoneySense explains monthly reducing balance as a common home-loan method and warns that promotional rates can expire, changing later monthly payments.
For SORA-linked products, MAS is the authoritative benchmark administrator. The mathematical model should read the relevant compounded-SORA observation according to the product terms, apply the contractual spread and then calculate the borrower’s interest and repayment mechanics.
A reader should therefore separate three questions: what does the official benchmark measure, how does the contract transform it into a loan rate, and how does that loan rate transform the outstanding balance into a payment.
94. Parent and Student Route
Loan mathematics is an unusually rich application of school algebra, percentages, geometric sequences, exponentials and graph interpretation. A student who can derive the payment formula from a present-value annuity sees why the method works rather than treating mortgages as a specialist black box.
A useful diagnostic is to ask the student to explain one amortisation row without using a memorised table: starting balance, interest, payment, principal reduction, ending balance. If those five objects are clear, the larger schedule becomes a repeated process.
95. University Route
University finance and actuarial mathematics extend the clean loan model into varying rates, irregular cash flows, stochastic prepayment, credit risk, securitisation and asset-liability management. Yet the deterministic schedule remains the base case against which these complications are measured.
The best preparation is therefore not more formulas but more control over cash-flow timing, rate conversion and state transitions.
96. Banking Route
At bank scale, individual loans become portfolios. Payment schedules feed cash-flow forecasts, interest income, liquidity projections, credit exposure and interest-rate risk. Prepayment behaviour changes both expected maturity and reinvestment needs.
This is where a household loan becomes a banking-system object. The same monthly amortisation equation feeds later pages on bank balance sheets, net interest margin, capital, liquidity, stress testing and mortgage-backed securities.
97. Authoritative References
- MoneySense — Costs of borrowing: Flat rate, monthly rest, and Effective Interest Rate
- MoneySense — How home loans work
- MoneySense — Effects of compounding interest
- MAS — SORA Key Features and Calculation Methodology
- MAS — Domestic Interest Rates and SORA data
- OpenStax Principles of Finance 2e — Loan Amortization
- Institute and Faculty of Actuaries — Actuarial Mathematics
98. Formula Map
- Level-payment loan: L=R(1−v^n)/i.
- Payment: R=L i/(1−v^n).
- Balance recursion: B_t=B_(t−1)(1+i)−R under the clean fixed-rate end-of-period model.
- Interest component: i×beginning balance.
- Principal component: payment−interest, before considering separate fees or charges.
- Prospective balance: present value of remaining payments at the balance date.
- Retrospective balance: accumulated original principal minus accumulated past repayments.
- Refinancing NPV: value avoided old-loan cash flows minus new-loan cash flows and transaction costs at one focal date.
99. Final Principle
Loan mathematics becomes transparent when the contract is translated into state transitions and dated cash flows. Principal is not interest, a headline rate is not an effective cost, and a low payment is not the same thing as a low total or present-value cost.
Trace the cash. Reconcile the balance. Then interpret the rate.
100. Deepening Study: Payment sensitivity
For a fixed principal and tenure, the payment rises as the periodic rate rises. The relationship is nonlinear because the rate appears both outside and inside the annuity factor. A payment surface across rate and tenure makes that nonlinearity visible.
A model should pass directional checks: higher rate should not reduce the payment in a standard fixed-principal, fixed-tenure amortising loan; longer tenure should generally reduce periodic payment while increasing the number of payments. These are simple but powerful diagnostics.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
101. Deepening Study: Balance convexity through time
Outstanding principal does not usually decline in a straight line under a level-payment loan. Early interest consumes more of each payment, so principal reduction accelerates later as the balance falls.
Plotting balance against time helps readers see why a loan can be many years old yet still have substantial principal outstanding. The curve is a consequence of compound interest and fixed payment, not a hidden fee.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
102. Deepening Study: Effective-cost reconstruction
A robust EIR calculation starts from net borrower proceeds and the exact repayment schedule. Changing an upfront fee, repayment date or payment frequency changes the solved yield even if the advertised rate stays fixed.
This makes EIR a cash-flow metric rather than a label. It is useful for comparison, but the reader should still inspect other contract features such as prepayment flexibility and rate-reset risk.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
103. Deepening Study: Prepayment optionality
A borrower who can prepay has an option embedded in the loan contract. In simple household mathematics, this appears as the ability to replace future scheduled cash flows with an earlier lump sum subject to contract terms.
At portfolio scale, prepayment uncertainty changes lender duration and reinvestment risk. This links mortgage mathematics to later quantitative-finance topics without changing the basic fact that prepayment alters timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
104. Deepening Study: Floating-rate path dependence
When a loan rate resets through time, total interest and future payments depend on the realised path of rates, not only an average rate. Two rate paths with the same average can produce different balances if resets and payments occur at different times.
Scenario analysis should therefore preserve the sequence of rates and event dates. Collapsing the path into one arithmetic average can erase the timing that drives the loan state.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
105. Deepening Study: Contract-event ordering
Interest accrual, payment application, rate reset, fee assessment and prepayment may occur in a defined sequence. Reversing the order can change balances even when all numeric inputs are the same.
A production-grade model treats event order as part of the contract. A classroom model can use a simpler order, but it should still state whether payment occurs before or after interest for the period.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
106. Deepening Study: Arrears versus clean schedule
A standard amortisation table assumes scheduled payments arrive as expected. Once a payment is missed, the clean recursion may no longer describe the account because arrears, fees or special allocation rules enter.
This is a useful modelling boundary. The clean schedule is not ‘wrong’; it is the baseline state. Exception servicing requires additional rules.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
107. Deepening Study: Benchmark governance
A SORA-linked loan draws one input from an official benchmark methodology and other inputs from the loan contract. Keeping those sources distinct makes the model easier to audit.
If the benchmark source changes or a contract spread is amended, the modeller can identify which layer changed instead of treating the final payable rate as an unexplained number.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
108. Deepening Study: Portfolio aggregation
Thousands of individual loan schedules can be aggregated into projected principal, interest and cash collections. But aggregation should preserve key dimensions such as rate type, maturity, reset date and prepayment behaviour.
Otherwise the bank can lose information needed for liquidity and interest-rate risk. The individual amortisation equation is therefore a building block of asset-liability management.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
109. Deepening Study: Scenario discipline
A stress calculation is conditional: if the rate rises by a stated amount at a stated date and all other assumptions follow the scenario, then payment or value changes accordingly. It is not a forecast that the rate will rise.
Separating scenario from prediction protects reader agency and keeps the mathematics focused on sensitivity rather than market timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
110. Deepening Study: Payment sensitivity
For a fixed principal and tenure, the payment rises as the periodic rate rises. The relationship is nonlinear because the rate appears both outside and inside the annuity factor. A payment surface across rate and tenure makes that nonlinearity visible.
A model should pass directional checks: higher rate should not reduce the payment in a standard fixed-principal, fixed-tenure amortising loan; longer tenure should generally reduce periodic payment while increasing the number of payments. These are simple but powerful diagnostics.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
111. Deepening Study: Balance convexity through time
Outstanding principal does not usually decline in a straight line under a level-payment loan. Early interest consumes more of each payment, so principal reduction accelerates later as the balance falls.
Plotting balance against time helps readers see why a loan can be many years old yet still have substantial principal outstanding. The curve is a consequence of compound interest and fixed payment, not a hidden fee.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
112. Deepening Study: Effective-cost reconstruction
A robust EIR calculation starts from net borrower proceeds and the exact repayment schedule. Changing an upfront fee, repayment date or payment frequency changes the solved yield even if the advertised rate stays fixed.
This makes EIR a cash-flow metric rather than a label. It is useful for comparison, but the reader should still inspect other contract features such as prepayment flexibility and rate-reset risk.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
113. Deepening Study: Prepayment optionality
A borrower who can prepay has an option embedded in the loan contract. In simple household mathematics, this appears as the ability to replace future scheduled cash flows with an earlier lump sum subject to contract terms.
At portfolio scale, prepayment uncertainty changes lender duration and reinvestment risk. This links mortgage mathematics to later quantitative-finance topics without changing the basic fact that prepayment alters timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
114. Deepening Study: Floating-rate path dependence
When a loan rate resets through time, total interest and future payments depend on the realised path of rates, not only an average rate. Two rate paths with the same average can produce different balances if resets and payments occur at different times.
Scenario analysis should therefore preserve the sequence of rates and event dates. Collapsing the path into one arithmetic average can erase the timing that drives the loan state.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
115. Deepening Study: Contract-event ordering
Interest accrual, payment application, rate reset, fee assessment and prepayment may occur in a defined sequence. Reversing the order can change balances even when all numeric inputs are the same.
A production-grade model treats event order as part of the contract. A classroom model can use a simpler order, but it should still state whether payment occurs before or after interest for the period.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
116. Deepening Study: Arrears versus clean schedule
A standard amortisation table assumes scheduled payments arrive as expected. Once a payment is missed, the clean recursion may no longer describe the account because arrears, fees or special allocation rules enter.
This is a useful modelling boundary. The clean schedule is not ‘wrong’; it is the baseline state. Exception servicing requires additional rules.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
117. Deepening Study: Benchmark governance
A SORA-linked loan draws one input from an official benchmark methodology and other inputs from the loan contract. Keeping those sources distinct makes the model easier to audit.
If the benchmark source changes or a contract spread is amended, the modeller can identify which layer changed instead of treating the final payable rate as an unexplained number.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
118. Deepening Study: Portfolio aggregation
Thousands of individual loan schedules can be aggregated into projected principal, interest and cash collections. But aggregation should preserve key dimensions such as rate type, maturity, reset date and prepayment behaviour.
Otherwise the bank can lose information needed for liquidity and interest-rate risk. The individual amortisation equation is therefore a building block of asset-liability management.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
119. Deepening Study: Scenario discipline
A stress calculation is conditional: if the rate rises by a stated amount at a stated date and all other assumptions follow the scenario, then payment or value changes accordingly. It is not a forecast that the rate will rise.
Separating scenario from prediction protects reader agency and keeps the mathematics focused on sensitivity rather than market timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
120. Deepening Study: Payment sensitivity
For a fixed principal and tenure, the payment rises as the periodic rate rises. The relationship is nonlinear because the rate appears both outside and inside the annuity factor. A payment surface across rate and tenure makes that nonlinearity visible.
A model should pass directional checks: higher rate should not reduce the payment in a standard fixed-principal, fixed-tenure amortising loan; longer tenure should generally reduce periodic payment while increasing the number of payments. These are simple but powerful diagnostics.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
121. Deepening Study: Balance convexity through time
Outstanding principal does not usually decline in a straight line under a level-payment loan. Early interest consumes more of each payment, so principal reduction accelerates later as the balance falls.
Plotting balance against time helps readers see why a loan can be many years old yet still have substantial principal outstanding. The curve is a consequence of compound interest and fixed payment, not a hidden fee.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
122. Deepening Study: Effective-cost reconstruction
A robust EIR calculation starts from net borrower proceeds and the exact repayment schedule. Changing an upfront fee, repayment date or payment frequency changes the solved yield even if the advertised rate stays fixed.
This makes EIR a cash-flow metric rather than a label. It is useful for comparison, but the reader should still inspect other contract features such as prepayment flexibility and rate-reset risk.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
123. Deepening Study: Prepayment optionality
A borrower who can prepay has an option embedded in the loan contract. In simple household mathematics, this appears as the ability to replace future scheduled cash flows with an earlier lump sum subject to contract terms.
At portfolio scale, prepayment uncertainty changes lender duration and reinvestment risk. This links mortgage mathematics to later quantitative-finance topics without changing the basic fact that prepayment alters timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
124. Deepening Study: Floating-rate path dependence
When a loan rate resets through time, total interest and future payments depend on the realised path of rates, not only an average rate. Two rate paths with the same average can produce different balances if resets and payments occur at different times.
Scenario analysis should therefore preserve the sequence of rates and event dates. Collapsing the path into one arithmetic average can erase the timing that drives the loan state.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
125. Deepening Study: Contract-event ordering
Interest accrual, payment application, rate reset, fee assessment and prepayment may occur in a defined sequence. Reversing the order can change balances even when all numeric inputs are the same.
A production-grade model treats event order as part of the contract. A classroom model can use a simpler order, but it should still state whether payment occurs before or after interest for the period.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
126. Deepening Study: Arrears versus clean schedule
A standard amortisation table assumes scheduled payments arrive as expected. Once a payment is missed, the clean recursion may no longer describe the account because arrears, fees or special allocation rules enter.
This is a useful modelling boundary. The clean schedule is not ‘wrong’; it is the baseline state. Exception servicing requires additional rules.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
127. Deepening Study: Benchmark governance
A SORA-linked loan draws one input from an official benchmark methodology and other inputs from the loan contract. Keeping those sources distinct makes the model easier to audit.
If the benchmark source changes or a contract spread is amended, the modeller can identify which layer changed instead of treating the final payable rate as an unexplained number.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
128. Deepening Study: Portfolio aggregation
Thousands of individual loan schedules can be aggregated into projected principal, interest and cash collections. But aggregation should preserve key dimensions such as rate type, maturity, reset date and prepayment behaviour.
Otherwise the bank can lose information needed for liquidity and interest-rate risk. The individual amortisation equation is therefore a building block of asset-liability management.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
129. Deepening Study: Scenario discipline
A stress calculation is conditional: if the rate rises by a stated amount at a stated date and all other assumptions follow the scenario, then payment or value changes accordingly. It is not a forecast that the rate will rise.
Separating scenario from prediction protects reader agency and keeps the mathematics focused on sensitivity rather than market timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
130. Deepening Study: Payment sensitivity
For a fixed principal and tenure, the payment rises as the periodic rate rises. The relationship is nonlinear because the rate appears both outside and inside the annuity factor. A payment surface across rate and tenure makes that nonlinearity visible.
A model should pass directional checks: higher rate should not reduce the payment in a standard fixed-principal, fixed-tenure amortising loan; longer tenure should generally reduce periodic payment while increasing the number of payments. These are simple but powerful diagnostics.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
131. Deepening Study: Balance convexity through time
Outstanding principal does not usually decline in a straight line under a level-payment loan. Early interest consumes more of each payment, so principal reduction accelerates later as the balance falls.
Plotting balance against time helps readers see why a loan can be many years old yet still have substantial principal outstanding. The curve is a consequence of compound interest and fixed payment, not a hidden fee.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
132. Deepening Study: Effective-cost reconstruction
A robust EIR calculation starts from net borrower proceeds and the exact repayment schedule. Changing an upfront fee, repayment date or payment frequency changes the solved yield even if the advertised rate stays fixed.
This makes EIR a cash-flow metric rather than a label. It is useful for comparison, but the reader should still inspect other contract features such as prepayment flexibility and rate-reset risk.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
133. Deepening Study: Prepayment optionality
A borrower who can prepay has an option embedded in the loan contract. In simple household mathematics, this appears as the ability to replace future scheduled cash flows with an earlier lump sum subject to contract terms.
At portfolio scale, prepayment uncertainty changes lender duration and reinvestment risk. This links mortgage mathematics to later quantitative-finance topics without changing the basic fact that prepayment alters timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
134. Deepening Study: Floating-rate path dependence
When a loan rate resets through time, total interest and future payments depend on the realised path of rates, not only an average rate. Two rate paths with the same average can produce different balances if resets and payments occur at different times.
Scenario analysis should therefore preserve the sequence of rates and event dates. Collapsing the path into one arithmetic average can erase the timing that drives the loan state.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
135. Deepening Study: Contract-event ordering
Interest accrual, payment application, rate reset, fee assessment and prepayment may occur in a defined sequence. Reversing the order can change balances even when all numeric inputs are the same.
A production-grade model treats event order as part of the contract. A classroom model can use a simpler order, but it should still state whether payment occurs before or after interest for the period.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
136. Deepening Study: Arrears versus clean schedule
A standard amortisation table assumes scheduled payments arrive as expected. Once a payment is missed, the clean recursion may no longer describe the account because arrears, fees or special allocation rules enter.
This is a useful modelling boundary. The clean schedule is not ‘wrong’; it is the baseline state. Exception servicing requires additional rules.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
137. Deepening Study: Benchmark governance
A SORA-linked loan draws one input from an official benchmark methodology and other inputs from the loan contract. Keeping those sources distinct makes the model easier to audit.
If the benchmark source changes or a contract spread is amended, the modeller can identify which layer changed instead of treating the final payable rate as an unexplained number.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
138. Deepening Study: Portfolio aggregation
Thousands of individual loan schedules can be aggregated into projected principal, interest and cash collections. But aggregation should preserve key dimensions such as rate type, maturity, reset date and prepayment behaviour.
Otherwise the bank can lose information needed for liquidity and interest-rate risk. The individual amortisation equation is therefore a building block of asset-liability management.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
139. Deepening Study: Scenario discipline
A stress calculation is conditional: if the rate rises by a stated amount at a stated date and all other assumptions follow the scenario, then payment or value changes accordingly. It is not a forecast that the rate will rise.
Separating scenario from prediction protects reader agency and keeps the mathematics focused on sensitivity rather than market timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
140. Deepening Study: Payment sensitivity
For a fixed principal and tenure, the payment rises as the periodic rate rises. The relationship is nonlinear because the rate appears both outside and inside the annuity factor. A payment surface across rate and tenure makes that nonlinearity visible.
A model should pass directional checks: higher rate should not reduce the payment in a standard fixed-principal, fixed-tenure amortising loan; longer tenure should generally reduce periodic payment while increasing the number of payments. These are simple but powerful diagnostics.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
141. Deepening Study: Balance convexity through time
Outstanding principal does not usually decline in a straight line under a level-payment loan. Early interest consumes more of each payment, so principal reduction accelerates later as the balance falls.
Plotting balance against time helps readers see why a loan can be many years old yet still have substantial principal outstanding. The curve is a consequence of compound interest and fixed payment, not a hidden fee.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
142. Deepening Study: Effective-cost reconstruction
A robust EIR calculation starts from net borrower proceeds and the exact repayment schedule. Changing an upfront fee, repayment date or payment frequency changes the solved yield even if the advertised rate stays fixed.
This makes EIR a cash-flow metric rather than a label. It is useful for comparison, but the reader should still inspect other contract features such as prepayment flexibility and rate-reset risk.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
143. Deepening Study: Prepayment optionality
A borrower who can prepay has an option embedded in the loan contract. In simple household mathematics, this appears as the ability to replace future scheduled cash flows with an earlier lump sum subject to contract terms.
At portfolio scale, prepayment uncertainty changes lender duration and reinvestment risk. This links mortgage mathematics to later quantitative-finance topics without changing the basic fact that prepayment alters timing.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
144. Deepening Study: Floating-rate path dependence
When a loan rate resets through time, total interest and future payments depend on the realised path of rates, not only an average rate. Two rate paths with the same average can produce different balances if resets and payments occur at different times.
Scenario analysis should therefore preserve the sequence of rates and event dates. Collapsing the path into one arithmetic average can erase the timing that drives the loan state.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
145. Deepening Study: Contract-event ordering
Interest accrual, payment application, rate reset, fee assessment and prepayment may occur in a defined sequence. Reversing the order can change balances even when all numeric inputs are the same.
A production-grade model treats event order as part of the contract. A classroom model can use a simpler order, but it should still state whether payment occurs before or after interest for the period.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.
146. Deepening Study: Arrears versus clean schedule
A standard amortisation table assumes scheduled payments arrive as expected. Once a payment is missed, the clean recursion may no longer describe the account because arrears, fees or special allocation rules enter.
This is a useful modelling boundary. The clean schedule is not ‘wrong’; it is the baseline state. Exception servicing requires additional rules.
A useful worked extension is to take one loan, change only this feature, and compare the revised schedule with the base case. Holding the other assumptions fixed makes causality visible: the reader can see whether the change affects payment size, total interest, timing, outstanding balance or effective cost.
For spreadsheet validation, build a synthetic case small enough to solve manually. Then reconcile every row, compare the terminal balance with zero or the stated balloon, and recompute the same outstanding balance from both future and past cash flows. Agreement across those routes is stronger evidence than a visually plausible schedule.