Day 90 · Sunday, 1 November 2026
A lender quotes a price and asks what the payment will be. A small business usually starts from the other end: this is what we can pay each month, so how big a loan is that? PV answers that question directly, without guessing loan amounts into PMT until one fits.
You do the books for a family bakery that wants a refrigerated delivery van. After going through the cash flow, the owners can commit $850 a month to loan repayments, and the bank has offered 7.2% a year over 5 years, repaid monthly. In B5, use PV to work out the largest loan that $850 a month can repay. In B6, work out how much of everything the bakery pays back over the 5 years is interest.
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.