Forecasting projections for the upcoming year.

Budget

$22.00HOURLY

Client

Walker W.Germany

Status

OpenFeb 7, 2019
Need a forecasting projection ready for our board meeting. We mainly need help with an excel template where we can edit CAC, LTV, Churn, etc. Will share current financials after signing an NDA.

These projections are meant to help our investors understand our burn, revenue growth, when we'll need a cash injection and how much that injection is. When building this model, please keep the below bullet points in mind.

- We sell reports (product 1) to our customers at $99. This is a one time fee. (In the model, we should be able to change that $99 to whatever price we want)
- It costs us $135 to get that product 1 sale. We should also be able to change that cost number to whatever we want as it might go down as we optimize our ads and funnel.
- There's a percentage of customers that ask for a refund on those reports. You can set that percentage at 10% with the ability for us to change it.
- To all customers that purchase our reports (product 1), we try to sell them our supplement subscription (product 2) with a 14-day free trial.
- About 25% of our customers opt-in for that offer. We need to be able to change that percentage in the model as well.

- For the customers that take this upsell, we send them their first box for free (estimate COGS at 45% of the price of the box, which in this case is $99).
- If the customer cancels their subscription PRIOR to the 14 day period, they don't get charged and we lose money. We're estimating cancelation rates to be 20% (but again, that number needs to be able to be changed in the model)
- If the customer does not cancel before the 14 day period ends, they will be charged for a 3 months supply at the price of $99*3=$297. We ship them 3 boxes so our COGS will need to reflect that.
- We estimate about 20% of our subscription customers to cancel after that first 3 months (again, this number can be set to whatever we want)

So to summarize, the inputs that we need to be able to control are the following:
- Price of the reports
- The cost to get a customer to purchase the reports
- % of report customers asking for a refund on the reports
- % of report customers that take the supplement upsell
- 14-day trial (We can change it from 14 days to whatever we want)
- Price of the trial. Right now it's free, but we might have it at 50% off.
% of trial customers that cancel before the trial is over
- Price of the supplements (right now it's $99)
- COGS relative to the percentage of the sale price for supplements. (Default to be set at 40%)
% of customers that cancel after every pay period.

Skills & Expertise Required

Accounting Financial Analysis Financial Forecasting Financial Modeling Microsoft Excel 

Offer to work on this project closes in 105 days!

Submit A Proposal

Share this project with your friends



Freelancers You May Hire


Here are our top professional picks for you to hire



Similar Projects

Tableau Dashboard For Marketing Ana...

I need someone competent in Tableau to create and manage a dashboard visualization for one of our SAAS clients.

We specialise in facebook ads, so the exported data will be provided for you. T...read more

Hourly, $28.00

Bookkeeping for my business and fil...

I need someone to do my bookkeeping online through quickbooks and get everything i need in order to be ready to file my taxes

Fixed, $100.00

I need help to polish my profile/Im...

I need someone to help me build/polish my personal brand reputation or an upcoming C-Level Executive job search. I am an entrepreneur and CFO/Managing Partner of a small IT company. I am working on my...read more

Hourly, $26.00

Data extraction and research needed...

I need someone to scrape 30 profiles and get about 15 pieces of data from each one. This should be very straight forward and will lead to more work down the line.

Hourly, $18.00

Take data from a website, interpret...

I need someone to take information from a website, and add it to an excell sheet.
Once you get the information you would look up the commute time from the address of one place to another.
read more

Fixed, $25.00