MRR Projection Calculator
Project monthly recurring revenue forward month by month: start from your current MRR, add a fixed amount of new MRR each month, and subtract a fixed monthly churn percentage, then see the final MRR, the implied annual run rate, the total revenue collected over the period, and a month-by-month breakdown. All four inputs are your own assumptions, so the result is a scenario, not a forecast or financial advice.
Real-time Results
Monthly Breakdown
View details (24)
| Item | Value |
|---|---|
| Month 1 +¥2000.00 New | -¥300.00 Churn | Net: +¥1700.00 | ¥11700.00 |
| Month 2 +¥2000.00 New | -¥351.00 Churn | Net: +¥1649.00 | ¥13349.00 |
| Month 3 +¥2000.00 New | -¥400.47 Churn | Net: +¥1599.53 | ¥14948.53 |
| Month 4 +¥2000.00 New | -¥448.46 Churn | Net: +¥1551.54 | ¥16500.07 |
| Month 5 +¥2000.00 New | -¥495.00 Churn | Net: +¥1505.00 | ¥18005.07 |
| Month 6 +¥2000.00 New | -¥540.15 Churn | Net: +¥1459.85 | ¥19464.92 |
| Month 7 +¥2000.00 New | -¥583.95 Churn | Net: +¥1416.05 | ¥20880.97 |
| Month 8 +¥2000.00 New | -¥626.43 Churn | Net: +¥1373.57 | ¥22254.54 |
| Month 9 +¥2000.00 New | -¥667.64 Churn | Net: +¥1332.36 | ¥23586.91 |
| Month 10 +¥2000.00 New | -¥707.61 Churn | Net: +¥1292.39 | ¥24879.30 |
| Month 11 +¥2000.00 New | -¥746.38 Churn | Net: +¥1253.62 | ¥26132.92 |
| Month 12 +¥2000.00 New | -¥783.99 Churn | Net: +¥1216.01 | ¥27348.93 |
| Month 13 +¥2000.00 New | -¥820.47 Churn | Net: +¥1179.53 | ¥28528.46 |
| Month 14 +¥2000.00 New | -¥855.85 Churn | Net: +¥1144.15 | ¥29672.61 |
| Month 15 +¥2000.00 New | -¥890.18 Churn | Net: +¥1109.82 | ¥30782.43 |
| Month 16 +¥2000.00 New | -¥923.47 Churn | Net: +¥1076.53 | ¥31858.96 |
| Month 17 +¥2000.00 New | -¥955.77 Churn | Net: +¥1044.23 | ¥32903.19 |
| Month 18 +¥2000.00 New | -¥987.10 Churn | Net: +¥1012.90 | ¥33916.10 |
| Month 19 +¥2000.00 New | -¥1017.48 Churn | Net: +¥982.52 | ¥34898.61 |
| Month 20 +¥2000.00 New | -¥1046.96 Churn | Net: +¥953.04 | ¥35851.65 |
| Month 21 +¥2000.00 New | -¥1075.55 Churn | Net: +¥924.45 | ¥36776.10 |
| Month 22 +¥2000.00 New | -¥1103.28 Churn | Net: +¥896.72 | ¥37672.82 |
| Month 23 +¥2000.00 New | -¥1130.18 Churn | Net: +¥869.82 | ¥38542.64 |
| Month 24 +¥2000.00 New | -¥1156.28 Churn | Net: +¥843.72 | ¥39386.36 |
MRR Growth Chart
Disclaimer
The calculation results of this financial tool are for estimation and research reference only and do not constitute any investment advice or commitment. Actual rates and yields are subject to the final contract with the financial institution.
How it works
This MRR projection calculator rolls a starting monthly recurring revenue forward over a period you choose. Every month it removes a fixed percentage of the current balance as churn and adds a fixed amount of new MRR, then reports the final MRR, the final ARR (the last month's MRR multiplied by 12), the total revenue collected across the whole period, a month-by-month breakdown with the new, churned and net amounts for each month, and a growth chart. Amounts are displayed with a fixed ¥ symbol and there is no currency setting. Because the addition is fixed while churn scales with the balance, growth gradually slows and the balance levels off where monthly churn equals the monthly addition.
How the month-by-month projection loop works
The projection is a simple loop repeated once per month. It takes the current MRR, removes the monthly churn rate as a percentage of that balance, and then adds the fixed amount of new MRR for the month. The result becomes the starting balance of the next month, and the loop runs for exactly the number of months you enter.
Two consequences follow from that order of operations. First, churn is charged on the balance at the start of the month, before the new revenue arrives, so new MRR is never churned in the month it is added. Second, because churn is proportional while the addition is fixed, the net gain shrinks month by month and the balance approaches a ceiling at new MRR per month divided by the churn rate, where the churn removed exactly equals the amount added.
Reading the final MRR, the ARR and the total revenue
The final MRR is the balance at the end of the last projected month. The final ARR multiplies that single month by 12, so it is a run rate: it says what a year would look like if the final month repeated unchanged, and it is not money that has been collected. The total revenue collected is the opposite kind of figure: it adds up the MRR at the end of every projected month, so it reflects the whole path, including the smaller early months.
The monthly breakdown shows that path in detail. Each row gives the month-end balance together with the new MRR added, the amount churned away and the net change for that month, and the chart plots the same balances so the curve's flattening or decline is easy to see. When the net change turns negative, churn is removing more than the fixed addition brings in, and the balance falls until the two balance out.
Assumptions and limits of the projection
Every number in the projection comes from your four assumptions, and the model holds two of them rigidly constant: the same amount of new MRR arrives every month, and the churn rate never changes. Real subscription businesses see expansion and contraction revenue from existing customers, seasonal sign-ups, price changes and churn that varies with the customer mix; none of that is represented here, and the output is a scenario to reason with, not a forecast or financial advice.
A few practical limits are worth knowing. All results are displayed with a fixed ¥ symbol and there is no currency option, so read the figures as amounts in whatever currency your inputs use. The form rejects negative amounts and a period shorter than one month, but it does not cap the churn rate: a rate above 100% is accepted and can push the projected balance below zero, which is an input mistake rather than a meaningful scenario.
Examples and interpretation(5)
How does MRR grow over 6 months from 5000 with 1000 of new MRR a month and 5% monthly churn?
- Monthly Churn Rate (%)
- 5 %
- Initial MRR
- 5000
- Projection Period (Months)
- 6 months
- New MRR per Month
- 1000
- Enter an initial MRR of 5000, new MRR per month of 1000, a monthly churn rate of 5%, and a period of 6 months.
- Month 1 removes 5% of 5000 = 250 in churn and adds 1000, ending at 5750.
- Repeating the same step gives 6462.50, 7139.38, 7782.41 and 8393.29 in months 2 to 5, and 8973.62 in month 6.
- Adding the six month-end balances gives total revenue collected of 44501.19.
- Final MRR
- 8973.62
- Total Revenue Collected
- 44501.19
Growth decelerates because the 5% churn is taken from a growing balance: the monthly net gain shrinks from 750 toward zero as the balance approaches the level where churn alone would remove 1000 a month.
What MRR and ARR result after 12 months from 20000 with 3000 of new MRR a month and 2% churn?
- Monthly Churn Rate (%)
- 2 %
- Initial MRR
- 20000
- Projection Period (Months)
- 12 months
- New MRR per Month
- 3000
- Enter an initial MRR of 20000, new MRR per month of 3000, a monthly churn rate of 2%, and a period of 12 months.
- Each month the balance keeps 98% of itself and gains 3000: month 1 ends at 22600 and month 2 at 25148.
- Continuing the same step for 12 months gives a final MRR of 47986.83.
- The final ARR is 47986.83 x 12 = 575841.91.
- Final MRR
- 47986.83
- Final ARR
- 575841.91
A low 2% churn lets most of the fixed monthly addition survive, so the balance more than doubles in a year. The annual figure is just the final month scaled by 12, not a sum of what was collected.
Can a small subscription business with 1000 of MRR still grow when monthly churn is 10% and it adds 500 a month?
- Monthly Churn Rate (%)
- 10 %
- Initial MRR
- 1000
- Projection Period (Months)
- 6 months
- New MRR per Month
- 500
- Enter an initial MRR of 1000, new MRR per month of 500, a monthly churn rate of 10%, and a period of 6 months.
- Month 1 removes 10% of 1000 = 100 and adds 500, ending at 1400.
- Months 2 to 6 give 1760, 2084, 2375.60, 2638.04 and 2874.24.
- The final MRR after 6 months is 2874.24.
- Final MRR
- 2874.24
- Monthly Breakdown: Month 1
- ¥1400.00
Even at 10% monthly churn the balance grows, because the fixed addition of 500 is larger than the churn removed from a small base. Growth would stall only when the balance reaches 500 / 0.10 = 5000, where churn removes the full 500 added each month.
How fast does MRR fall from 50000 over 6 months if nothing new is added and churn is 4% a month?
- Monthly Churn Rate (%)
- 4 %
- Initial MRR
- 50000
- Projection Period (Months)
- 6 months
- New MRR per Month
- 0
- Enter an initial MRR of 50000, new MRR per month of 0, a monthly churn rate of 4%, and a period of 6 months.
- Each month multiplies the balance by 0.96: 48000, then 46080, then 44236.80.
- After 6 months the balance is 50000 x 0.96^6 = 39137.89.
- Final MRR
- 39137.89
- Monthly Breakdown: Month 6
- ¥39137.89
This is pure decay: without new revenue, a 4% monthly churn removes about 22% of the starting balance in half a year. The breakdown makes the shrinking monthly losses visible, since each month's churn is 4% of a smaller base.
What happens over 12 months from 8000 with 2000 of new MRR a month and no churn at all?
- Monthly Churn Rate (%)
- 0 %
- Initial MRR
- 8000
- Projection Period (Months)
- 12 months
- New MRR per Month
- 2000
- Enter an initial MRR of 8000, new MRR per month of 2000, a monthly churn rate of 0%, and a period of 12 months.
- With no churn, each month adds the full 2000, so month 1 ends at 10000 and month 12 at 32000.
- The final MRR is 8000 + 12 x 2000 = 32000.
- The total revenue collected is 10000 + 12000 + ... + 32000 = 252000.
- Final MRR
- 32000.00
- Total Revenue Collected
- 252000.00
Zero churn turns the projection into a straight line: the balance rises by exactly the monthly addition, and the total collected is the average of the first and last balances multiplied by the number of months.
Formula
The projection repeats one step for every month: churned revenue = current MRR x monthly churn rate; next MRR = current MRR + new MRR per month - churned revenue. Final ARR = final MRR x 12. Total revenue collected = the sum of the MRR at the end of each projected month.
How to use
- Enter your current monthly recurring revenue as the initial MRR.
- Enter the fixed amount of new MRR you expect to add each month; use 0 to model a business that adds nothing.
- Enter the monthly churn rate as a percentage of the current balance that is lost each month.
- Enter the projection period in months.
- Read the final MRR and final ARR for the end of the period, the total revenue collected for the whole path, and the monthly breakdown for the month-by-month balances, churn and net change.
Frequently asked questions
Why does the projected growth slow down over time even though the same new revenue is added every month?
Churn is a percentage of the current balance, so the amount removed grows as the balance grows, while the amount added stays fixed. Growth continues only while the monthly addition is larger than the churn removed; the balance levels off where the two are equal, at an MRR of new MRR per month divided by the churn rate (for example 1000 / 5% = 20000).
Is the final ARR the same as the total revenue collected?
No. Final ARR is the final month's MRR multiplied by 12: a run rate that assumes the last month repeats for a year. Total revenue collected is the sum of the MRR at the end of every projected month, so it counts what the model actually accumulates during the period.
What does each row of the monthly breakdown show besides the balance?
Each row shows the MRR at the end of that month, and in its detail line the fixed amount of new MRR added, the amount removed by churn that month, and the net change. Reading down the rows shows whether the net change is growing, shrinking or negative.
Which currency are the results shown in, and can I change it?
No. The amounts in the cards and in the breakdown are displayed with a fixed yen-style symbol (¥), and there is no currency setting anywhere in this calculator. Treat the numbers as amounts in the same currency as your own inputs and ignore the symbol if you track revenue in a different currency; no conversion is performed.
What happens if I enter a monthly churn rate above 100%?
The form only rejects missing values, negative amounts, a negative churn rate and a projection period below one month. A churn rate above 100% is accepted and can drive the projected balance below zero, which no real subscription business can do, so keep the churn rate between 0% and 100% for a meaningful scenario.
Does the projection account for expansion revenue, seasonality or changing growth?
No. The model holds the new MRR per month and the churn rate constant for the whole period and knows nothing about expansion revenue from existing customers, one-off sales, seasonality or price changes. It is a simple what-if scenario built from your four assumptions, not a forecast and not financial advice.
Related Calculators
More calculators selected by category and topic.
