Excel can find the internal rate of return (IRR) and use that as the discount rate for an NPV of zero. Let’s begin by examining each step of NPV in order. The formula is: NPV = ∑ {After-Tax ...

This includes your bills, bank statements, paychecks, tax ... formula to find out your deficit or surplus savings for the rest of the months. You've successfully created a personal budget in Excel.