3 articles
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.
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.
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.