Are you building an advertising-supported business and need to forecast your operations and financials? Are you looking to estimate your revenue, CPMs, traffic acquisition costs, unique visitors, page views, hiring plan, breakeven point and unit economics? Are you looking to raise capital? Have you met with investors and learned you need to understand your financials better? Build a complete set of financial projections for your business in under an hour using this model.
The Advertising Financial Model is a fully-functioning financial model for Excel (.xlsx) that:
- Forecasts the potential future of your advertising business. This is a fit for companies that are building a predominantly advertising-supported business. If this is for an app that has in-app advertising, the App Financial Model is a better fit: http://gum.co/appmodel
- Demonstrates to investors, executives, and yourself that the fundamentals of your business are solid using key operational and financial metrics: the model automatically computes key advertising metrics based on a set of flexible inputs around customers and projects, staffing, resource allocation, utilization, margins, and other inputs necessary to forecast revenues and costs for a services business.
- Creates estimates of acquisition and based on paid and organic acquisition strategies, and models costs to acquire traffic.
- Creates estimates of unique visitors, pageviews, new v. repeat visitors, and other measures of user activity.
- Creates revenue forecasts easily with a simple set of assumptions, but with more powerful inputs available for extensive fine-tuning of forecasts. Calculates metrics such as ad impressions, sell through, revenue per page, (RPM), average revenue per visitor, long-term value (LTV), and acquisition costs (CAC).
- Creates detailed expense forecasts broken down by cost of goods sold (COGS) and selling, general and administrative (SG&A) costs.
- Create full financial statements, including income statement, balance sheet and statement of cash flows.
- Creates funding estimates and capitalization table to estimate ownership structure, and a waterfall analysis of proceeds distribution at exit.
- Works for any currency; Foresight models have been used by entrepreneurs from over 71 countries.
The model uses a mix of assumptions to estimate all revenue and cost line-items monthly over a flexible five year period, and then sums the monthly results into quarters and years for an easy view into the various time periods. For all inputs, you can easily set the start date and year for key decisions and the model adjusts automatically.
All formulas and sheets are open for editing, anything is open for editing. I don't believe that models should be locked, everything should be open for you to edit so that you can model your business exactly as you want.
Packages
The model can be purchased alone or as a part of two packages:
- Model. The base model, downloadable immediately, and created to be able to be used by anybody to create a powerful set of projections in less than an hour. Email customer support about how to use the model is included in all model purchases.
- Model + Video Course. Targeted for beginners to financial modeling that want to learn the concepts of how to create a financial model, the video course is not a "how-to" for the model, but a deep dive into the fundamentals of building a financial model for startups in general. The video course is for beginners to financial modeling that want to learn the concepts of how to create a financial model. It is not a "how-to" for the model, but a deep dive into the concepts in how to build a model. People inexperienced with financial modeling that want to fully leverage and edit the template should consider taking the Video Course. You will get a separate email after purchase to access the course, which is at http://learn.foresight.is
- Model + Get Started. 3 Hours of assistance in completing the model, customization and review. Focus is on structuring and adjusting inputs for your business, and refining unit economics, cost budget, financial statements, and financing strategy. Additional customization may be necessary depending on your business; to be determined and billed separately. More details at http://foresight.is/services , or contact taylor@foresight.is
For questions about coaching and additional custom model services, contact taylor@foresight.is
Details and Terms and Conditions
- Model is one .xlsx Excel file and is downloaded immediately.
- More details at http://foresight.is
- Enter your license key in the Inputs - Revenues sheet
- By purchasing or downloading, I hereby accept the Terms of Service at http://foresight.is/terms and the Privacy Policy at http://foresight.is/privacy
You'll need an account to access this in our app. Please create a password to continue.
Download from the App Store or text yourself a link to the app
Thank you for purchasing the Advertising Financial Model.
If you purchased the Video Course or Coaching package, you will shortly get an email from me with additional details on accessing the course or scheduling the first Coaching call.
Save this email: you can download the latest version of the model anytime through the download link above.
And thank you!
Taylor Davidson
@foresighthq
+1 646 770 0052
Looking to create an account?
Did you mean to login?