=('Data Entry'!D13-'Data Entry'!D12)/'Data Entry'!D12
Takes this month's MRR, subtracts last month, divides by last month.
Format as percentage. And you are done.
=('Data Entry'!D13-'Data Entry'!D12)/'Data Entry'!D12
Takes this month's MRR, subtracts last month, divides by last month.
Format as percentage. And you are done.
- Total Customers
- MRR
- MRR Growth Rate
- Churn Rate
- Average Revenue Per Customer
Everything else is noise until you hit scale.
- Total Customers
- MRR
- MRR Growth Rate
- Churn Rate
- Average Revenue Per Customer
Everything else is noise until you hit scale.
1. Data Entry - raw numbers only, no formulas
2. Dashboard - all the calculations
Why separate them? Because if you accidentally screw up a formula, you won't delete 3 months of revenue data.
1. Data Entry - raw numbers only, no formulas
2. Dashboard - all the calculations
Why separate them? Because if you accidentally screw up a formula, you won't delete 3 months of revenue data.