Day 98 · Monday, 9 November 2026
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.
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.
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.