Day 90 · Sunday, 1 November 2026

From the archive

Beginner

Work Out How Much a Monthly Budget Can Borrow with PV

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.

Task:

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.

The daily challenge is part of Pro

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.