USA MRR 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