Forecasting projections for the upcoming year.

Budget

$22.00HOURLY

Client

Walker WaGermany

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 192 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

Reverse engineer an excel spreadshe...

Looking for someone who can take an excel sheet with pre-populated fields, assess an existing output and re create it.

Fixed, $50.00

Senior BI Consultant, Contract

Looking for two BI Consultants, working with Microsoft's Power BI, with DAX and M queries. This will have a focus on reporting and dashboards - visualizations. This is a 12 month contract, located in...read more

Hourly, $28.00

Mail Parser Project

Looking to create a model for extracting information from email (gmail and outlook) and update various spread sheets. Happy to use existing apps currently on the market like zappier or microsoft mail...read more

Fixed, $200.00

Am looking to create an automated a...

Looking to design an algo to trade a MACD indicator. The algo is already written in Python and I need someone to hook up the data and to my Interactive Brokers account. Want to be able to back test...read more

Hourly, $36.00

Excel Graphs

My team uses a simple excel sheet to show people net proceeds from a sale. I'd love to have someone create a page two of this same form or modify the form to include some more visuals of graphs and c...read more

Hourly, $36.00