Current MRR
$281,700
ARR
$3,380,400
MRR growth, last month
5%
Subscription Revenue (MRR) Tracker
Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.
SpreadsheetBusiness FinanceFree
Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.
Shown with sample data
Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.
Latest: $376,750
Latest: -$169,112.88
Should you buy the machine, build the warehouse or upgrade the system? Enter the investment, the cash it brings in and costs each year; the model works out depreciation, tax and after-tax cash flow, discounts every year at your hurdle rate, and gives NPV, an approximate IRR from a rate sensitivity table, the profitability index, and simple and discounted payback, then ranks the project against your other proposals.
Each year’s net cash flow is multiplied by a discount factor of 1 ÷ (1 + rate)^year, and the present values are summed with SUMPRODUCT. A positive NPV means the project earns more than your hurdle rate.
The Rate sensitivity sheet calculates NPV at every rate from 0% to 30% and interpolates between the two rates where NPV changes from positive to negative. It is accurate to within a small fraction of a percent for normal projects.
It depends on the risk and life of the asset. Many companies want three to five years for equipment; technology projects often need less. Payback ignores the time value of money and later cash flows, so use it alongside NPV.
Present value of future cash flows ÷ initial investment. Above 1.0 means positive NPV; when capital is limited, rank projects by PI to get the most value per dollar invested.
Download a copy
Downloads need a free account.