USA MRR Rollforward Calculation


Joined
Apr 30, 2022
Messages
1
Reaction score
0
Country
United States
I am not sure how to tackle this exercise. Based on the Company A information how should I fill out the second table? Can you please share formula?


#Client NameJan 17Feb 17Mar 17Apr 17May 17Jun 17Jul 17Aug 17Sep 17TOTAL
1B6,536.006,536.006,080.006,080.005,955.005,955.005,423.005,423.005,423.0053,411.00
2C2,276.002,276.002,276.002,276.002,276.002,276.002,276.002,276.002,276.0020,484.00
3G48.0048.0048.0048.0048.0048.0048.0048.0026.50410.50
4H0.000.000.000.000.005,000.005,000.005,000.005,000.0020,000.00
5I1,359.001,318.001,337.501,337.501,335.000.000.000.000.006,687.00
TOTAL17,668.8110,178.0023,354.509,741.509,614.0013,279.0012,747.0012,747.0012,725.50122,055.31


How to compete the formulas in BOP, Increases, Decreases, Lost, and new?

MRRJan-17Feb-17Mar-17
BOP
Increases
Decreases
Lost
New
EOP 0 0 0
Increased/ (Decreased) MRR0%0%0%
Lost Customer MRR Churn0%0%0%
Revenue Retention0%0%0%
New Customer MRR Growth0%0%0%
Total MRR Change0%0%0%
CustomersJan-17Feb-17Mar-17
BOP
Lost
New
EOP 0 0 0
Customer Retention0%0%0%
New Customer Growth0%0%0%
Total Customer Change0%0%0%
Average MRR/CustomerJan-17Feb-17Mar-17
BOP 0 0 0
Lost 0 0 0
New 0 0 0
EOP 0 0 0
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top