USAMRR Rollforward Calculation

Arinoum

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 Name Jan 17 Feb 17 Mar 17 Apr 17 May 17 Jun 17 Jul 17 Aug 17 Sep 17 TOTAL 1 B 6,536.00 6,536.00 6,080.00 6,080.00 5,955.00 5,955.00 5,423.00 5,423.00 5,423.00 53,411.00 2 C 2,276.00 2,276.00 2,276.00 2,276.00 2,276.00 2,276.00 2,276.00 2,276.00 2,276.00 20,484.00 3 G 48.00 48.00 48.00 48.00 48.00 48.00 48.00 48.00 26.50 410.50 4 H 0.00 0.00 0.00 0.00 0.00 5,000.00 5,000.00 5,000.00 5,000.00 20,000.00 5 I 1,359.00 1,318.00 1,337.50 1,337.50 1,335.00 0.00 0.00 0.00 0.00 6,687.00 TOTAL 17,668.81 10,178.00 23,354.50 9,741.50 9,614.00 13,279.00 12,747.00 12,747.00 12,725.50 122,055.31

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

 MRR Jan-17 Feb-17 Mar-17 BOP Increases Decreases Lost New EOP 0 0 0 Increased/ (Decreased) MRR 0% 0% 0% Lost Customer MRR Churn 0% 0% 0% Revenue Retention 0% 0% 0% New Customer MRR Growth 0% 0% 0% Total MRR Change 0% 0% 0% Customers Jan-17 Feb-17 Mar-17 BOP Lost New EOP 0 0 0 Customer Retention 0% 0% 0% New Customer Growth 0% 0% 0% Total Customer Change 0% 0% 0% Average MRR/Customer Jan-17 Feb-17 Mar-17 BOP 0 0 0 Lost 0 0 0 New 0 0 0 EOP 0 0 0