One contract modification has three possible accounting answers, and the one you land on is decided by a ratio most workbooks never calculate. Here's the classic build that derives the classification instead of asking for it, the Excel 365 LET that spills all three treatments side by side, and a free workbook that ties every one of them back to total consideration.
New Excel and data write-ups, free workbooks and product notes. No spam, unsubscribe anytime.
subscribers and counting
Buy once with Dodo Payments. Instant delivery, global tax handled.
Stop matching by hand. Nine patterns, a working model, and an answer you can defend.
Fresh Excel, data and analytics write-ups — most with a free workbook.
A mid-lease renewal moves two balances by two different amounts, and almost every Excel lease template on the internet only ever tracks one of them. Here's the classic PV + INDEX build, the Excel 365 SCAN engine that spills both schedules from three cells, and a free workbook that ties them to the cent.
Most amortization tables are a fragile ladder of copy-down formulas that shatter the moment you insert a row. Here's the classic PMT/IPMT/PPMT build that never chains off the row above, the Excel 365 spill that produces all 360 rows from one cell, and a free workbook that also prices what an overpayment actually buys you.
Excel's NPV function quietly assumes your first cash flow lands one full period in the future, so it discounts the whole project by an extra period and hands you a number that is 9% light. Here's the classic fix, the XNPV/XIRR way for real dates, and a free workbook that reproduces every answer from first principles.
The most-read pieces right now.
Excel 365
Build an ASC 842 Lease Modification Tracker That Auto-Remeasures Liabilities and ROU Assets
18 min read
Excel 365
Build an ASC 606 Contract Modification Engine That Auto-Classifies and Calculates Catch-Up Adjustments
14 min read
Excel 365
Build a Loan Amortization Schedule in One Formula (No Helper Columns)
10 min read
