SaaS Excel Recurring Revenue Spreadsheet

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
I need an excel spreadsheet that can tell me the estimated new customers and the estimated revenue for months in the future. I have already completed 80% of this (see attached) but need some help finishing.

The excel spreadsheet needs to have the following inputs:

1) Number of current monthly customers
2) Customers that cancelled this month
3) Monthly product price
4) Average new customers per month
5) Current date

I would like the spreadsheet to output the following information:

1) Customers signed up
2) Churn rate (number of customers cancelled as a percentage)
3) CMRR (Contracted Monthly Recurring Revenue)
4) Average Customer lifetime (in months)
5) Average Customer lifetime value
6) Future revenue estimates each month

As you can see in the attached example, I have already created the first 1-5 outputs. However I would like it to output the revenue for the future months.

For example, if I had 100 customers, 1 cancellations on average per month, average monthly customer price of £10, and on average 20 new customers per month. I would like to know the estimated number of customers on month 1, 2, 3, 4, 5, 6, 7 etc etc. I would also like to know the estimated monthly recurring revenue taking into account the average cancellation rate.

Please DO NOT bid if you do not really know Excel or know what CMMR or churn rate is. I have completed 80% of this project myself but just need some help with the last part.

Thank you!

Skills required:
Accounting, Excel, Mathematics
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: SAAS Worksheet.xlsx
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 105
in 3 days
$ 80
in 1 days
$ 210
in 3 days
$ 100
in 2 days
Hire wsh2
$ 250
in 8 days
$ 103
in 5 days
$ 45
in 3 days
$ 60
in 2 days
$ 90
in 3 days
$ 40
in 2 days