Ending Wealth Over Time
Scenario Comparison
In future’s money, each scenario at the end of its own term.
Amortization Schedule
In future’s money, as the lender schedules it.
What this assumes
Questions
At what loan rate does financing beat paying cash?
When the loan costs less than the cash would earn, after fees. The tool invests the money financing frees up at the Risk-Free Rate, untaxed, and Net Benefit vs Cash is the difference in ending wealth. In the car Quick Start, the 3 year loan at 8.4% with 10% down and a $400 fee loses by $3,059 against a 4.5% Risk-Free Rate. It only draws level at about 3.81%, below 4.5%, because the fee also has to be earned back.
Does having more cash change whether financing is worth it?
No. Available Cash must cover the purchase, but any surplus is invested at the same Risk-Free Rate whether you pay cash or finance, so it cancels out of Net Benefit. In the car Quick Start, moving Available Cash from $60,000 to $54,000 or $66,000 changes the result by $0. What matters is the gap between the Finance Rate and the Risk-Free Rate, the term, the fees and the down payment.
Does a longer loan term make financing look better or worse?
Worse whenever the loan costs more than the cash earns. A longer term means paying that gap for more years. In the car Quick Start the 3 year loan scores a Net Benefit of about -$3.1k. Stretched to 48 months it falls to about -$4.1k, and shortened to 24 months it improves to about -$2.1k. Term moved the result more than any other input, ahead of the Finance Rate, the Risk-Free Rate and the fee.
How does it compare a store plan that only quotes the instalment?
It solves for the rate hidden in the payments, using the Known repayment, solve rate loan type, and then scores that loan like any other. On an $1,800 phone, 24 payments of $82 works out to about 9.1% a year, and so does 36 payments of $57. Both lose to cash at a 4.5% Risk-Free Rate, and the longer plan loses more. 12 payments of $150 is exactly 0% and beats cash.
Why is a flat rate loan so much dearer than the same rate on a declining balance?
A flat rate charges interest on the original amount for the whole term, even after you have repaid part of it. In the motorbike Quick Start, Rp 28 million is borrowed over 36 months at 0.9% a month. Flat, the instalment is about Rp 1,029,778, against Rp 914,034 on a declining balance, roughly Rp 4.2 million more in total. Its effective rate is about 19% a year, not 10.8%. Set Rate Convention to Nominal (APR) for a rate quoted per month.
What does the comparison leave out?
Tax, risk and the item itself. Cash earns the Risk-Free Rate untaxed and loan interest is never deducted, so enter an after-tax Risk-Free Rate if yours is taxed. What the item is later worth is left out of both paths. Early repayment penalties, break costs and a 0% promotion that charges interest back are not modelled. Only fees you enter in Origination Fee or Admin Fee count.