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.

Taidot: Excel, Microsoft Office, Visual Basic

Näytä lisää: 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, create excel spreadsheet, need create excel spreadsheet, create excel spreadsheet word visual basic

Tietoa työnantajasta:
( 314 arvostelua ) Chandler, United States

Projektin tunnus: #15815969

Myönnetty käyttäjälle:


Please review my profile as i have relevant skills and experience. I can show you a recently prepared forecast model. Relevant Skills and Experience Excel, Microsoft Office, Visual Basic Proposed Milestones $30 USD - Lisää

30 $ USD 1 päivässä
(33 arvostelua)

3 freelanceria on tarjonnut keskimäärin 20 $ tähän työhön


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 Lisää

15 $ USD 1 päivässä
(20 arvostelua)

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 1 päivässä
(4 arvostelua)