Create Excel Spreadsheet for Revenue Projectsions

I need an Excel spreadsheet created that projects revenue from customers over twelve months, where I specify the following variables:

- Number of new customers each month

- Amount of first sale with us

- Amount of all subsequent sales with us

- Number of months between orders (e.g., they order every two months)

So for example, a new customer spends $100K on the first order and $150K on all subsequent orders. One new customer starts in Feb so we will get $100K in Feb, $150K 90 days after that, $150K 90 days after that, etc. But since some customers won't start until later in the year, we will see fewer sales of the course of the year.

So this is the challenge. How to build formulas so I can plug different numbers in the variables above to calculate revenue for the year from all of those customers. And then I have three different customer types (whales, sharks and minnows) so need to have the spreadsheet calculate each customer type and then total for total revenue for the year.

I'm attaching a spreadsheet where I've placed our initial assumptions to help you get started and make sense of it. I need it turned around fast (e.g., 24 hours). Hoping this is super easy for someone proficient in Excel (which I am not!).

Please only bid if you have the expertise to do this and turn it around in 24 hours or less.

Skills: Excel, Microsoft Office, Visual Basic

See more: revenue chart template, how to calculate projected revenue for a new business, what is revenue projection, revenue forecasting excel templates, projected revenue formula excel, how to forecast revenue growth in excel, revenue forecast formula, projected revenue calculator, create excel spreadsheet stock trader, create excel spreadsheet inventory, create excel spreadsheet inventory sales, create excel spreadsheet birthdays famous people sorted birthday, create excel spreadsheet business cards, create excel spreadsheet iphone app, create excel spreadsheet 651, create excel spreadsheet 651 events, create excel spreadsheet track certifications, create excel spreadsheet adds subtracts money, create excel spreadsheet jobs, create excel spreadsheet contacts

About the Employer:
( 322 reviews ) Chandler, United States

Project ID: #15815969

2 freelancers are bidding on average $15 for this job


okay got it ..hi i am interested in your project .. and i would like to work with you .. i will do this job for you ... Stay tuned, I'm still working on this proposal.

$15 USD in 1 day
(13 Reviews)

Hi sir after reading the project description I am offering my services of excel sheet on urgent basis. Sir I have completed 25 plus project successfully . Relevant Skills and Experience Sir I have a expertise of excel More

$15 USD in 1 day
(31 Reviews)