NPV
$118,225
IRR (approx.)
15%
Profitability index
1.2
Capital Budgeting NPV and Payback Analysis
Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.
SpreadsheetBusiness FinanceFree
Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.
Shown with sample data
Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.
Latest: $281,700
Investors read a SaaS business through its MRR bridge. Enter new, expansion, contraction and churned MRR each month; the tracker builds starting and ending MRR, gross churn, net revenue retention and the SaaS quick ratio for every month, shows current ARR and growth, and keeps a customer list that classifies each account as expanded, contracted, flat or churned.
Gross MRR churn = (contraction + churned MRR) ÷ starting MRR for the month. Customer (logo) churn counts accounts instead of revenue.
NRR = (starting MRR + expansion − contraction − churn) ÷ starting MRR. Above 100% means existing customers grow even without new sales. The annual figure here compounds the monthly rates as an estimate; a true cohort NRR compares the same customers 12 months apart.
(New MRR + expansion MRR) ÷ (contraction MRR + churned MRR). It shows how much revenue you add for every dollar you lose.
ARR = MRR × 12, using recurring revenue only.
Download a copy
Downloads need a free account.