Day 98 · Monday, 9 November 2026

From the archive

Intermediate

Find the Real Interest Rate Behind a Flat-Rate Quote with RATE

A finance quote that says "5% flat" sounds cheaper than one that says 7.9% a year, but a flat rate charges interest on the whole amount for the whole term, even after most of it has been paid back. RATE works backwards from the payment to the rate you are really paying, so two quotes written in different languages can be compared on the same footing.

Task:

You manage the finances of a print shop that is financing a $15,000 wide-format printer over 4 years. Two lenders have quoted, and their offers are in B2:C5: Northgate Finance at 5% flat and Harbour Bank at 7.9% a year, both repaid monthly. In B6, use RATE to work out the true annual interest rate of Northgate's quote, and copy it across to C6 for Harbour's. Then in B7, work out the total interest each quote costs, and copy that across to C7.

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.