SaaS Excel Recurring Revenue Spreadsheet

Closed

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: Accounting, Excel, Mathematics

See more: excel recurring revenue, monthly recurring revenue, recurring revenue spreadsheet, recurring spreadsheet, attached spreadsheet revenue, excel recurring, spreadsheet accounting, lifetime account, future of accounting, needs of accounting, need help excel, need excel help, spreadsheet excel and accounting, spreadsheet (excel) and accounting, excel accounting, customer spreadsheet, accounting spreadsheet, accounting saas, account spreadsheet, excel inputs, customer churn, churn, customer spreadsheet example, need accounting help, future accounting

Project ID: #4841581

20 freelancers are bidding on average $125 for this job

ZeusMan

Looking forward to working with you....

$105 USD in 3 days
(62 Reviews)
5.8
Teloquence

Consider it done. Check your PM for my bid details.

$80 USD in 1 day
(91 Reviews)
5.8
uumairkhalid

Let me to do this. Please share details with me. Thanks

$210 USD in 3 days
(21 Reviews)
5.1
priyal1997

Dear Sir. Please check PM. ;-)) You will be amazed. Thanks - Priyal

$100 USD in 2 days
(58 Reviews)
5.0
wsh2

Highly skilled [20+ years] MsExcel programming expert. Degreed Accountant with many years of Accounting experience. FAST and ACCURATE results. Confidentiality guaranteed. American English is my only language.

$250 USD in 8 days
(10 Reviews)
4.9
funnyhoney

Let me help you with this.

$103 USD in 5 days
(9 Reviews)
4.6
parsermonster

Dear Project Manager, Let's get #6 done! Please check my qualifications and read the message in your inbox. Regards, Mitchell Allen

$45 USD in 3 days
(8 Reviews)
4.0
caabdul

Dear Sir, Let me serve for the best solution, thank you

$60 USD in 2 days
(5 Reviews)
3.3
gitapodder1989

I can do it nicely.

$90 USD in 3 days
(3 Reviews)
2.8
sambestsolutions

Hi I can help you. please check pm

$40 USD in 2 days
(4 Reviews)
2.4
szymszteinsl

Ready, sir!

$250 USD in 3 days
(1 Review)
2.0
SharjeelSohail

I'm very good with mathematics and Excell Formulas formation. I can do this work for you.

$40 USD in 3 days
(6 Reviews)
1.8
ChrisLuHeng

Hi, I am glad to help on this project! Please check PM

$100 USD in 3 days
(0 Reviews)
0.0
wuiz8606

I understood the nature of this project and ready to do it .

$155 USD in 3 days
(0 Reviews)
0.0
raymccormick

Hi, I would be happy to assist with this project.

$277 USD in 3 days
(0 Reviews)
0.0
edenventures

i am a chartered accountant, and can deliver with accuracy and on time...

$111 USD in 3 days
(0 Reviews)
0.0
snoopy1310

I have a lot of experience in Excel and am very confident of being able to do this work to your satisfaction. I have been using Excel for the last 16 years in my work (I was working in HR in a Software Company) to More

$40 USD in 1 day
(0 Reviews)
0.0
keyworks

Hello, I have experience in doing similar tasks. Please check PM for bid details. Thanks

$155 USD in 3 days
(0 Reviews)
0.0
swetapadma

We can submit in an hour. Excel Experts here.

$30 USD in 0 days
(0 Reviews)
0.0
leachla

I have experience and have retired from a secretarial position. I would like to work in my home as Freelancer. I have the US English and Math test.

$155 USD in 3 days
(0 Reviews)
0.0