Advertising Pro Forma Excel Financial Model Template
Originally published: 08/01/2019 14:10
Last version published: 26/04/2019 15:17
Publication number: ELQ-94964-2
View all versions & Certificate
certified

Advertising Pro Forma Excel Financial Model Template

This is a an extremely detailed and high quality pro-forma spreadsheet for your advertising start-up business.

Description
This is an extremely well-presented and detailed pro forma for an advertising start-up to use when recording and modeling their financials.

There are an array of tabs within this spreadsheet, which is available to download instantly, and which are ready to input the specific data relating to your business.

The Excel spreadsheet includes the following tabs (these are preceded by an 'Instructions' tab giving a clear guide on how to effectively use the spreadsheet for your advertising start-up):

- Quick Summary: Overview of finances with line chart

- Assumptions: This section includes general assumptions, revenue assumptions, cost of revenue assumptions, working capital assumptions, taxes assumptions, sensitivity analysis assumptions, long-term debt assumptions.

- Capital Assumptions

- Human Resources: Contract costs and Office Space Lease

- Operations: inc. rent, travel, IT, supplies

- Marketing: General Marketing Program and Promotion Programs

- Income Statement: Revenue, Operating Expenses, EBIT, Net Profit

- Balance Sheet

- Cash Flow Forecast: Operations, Investing, Financing

- Income Statement Quarterly

- Balance Sheet Quarterly

- Income Statement - Worst Case

- Income Statement - Best Case

- Ratio Analysis: Return on Equity, Earnings per share, Acid test, Book value per share, Debt ratio.

- Investor Cap Table: With Investment Input and summary, and Market Valuation Scenario.

- Sales Forecast: Pricing, Advertisers, Revenue Summary.

- Long term loan: With month wise interest payments, principle payments, and loan outstanding.

- Fixed Assets

- Cost of Revenue Forecasts

- Industry Costs

- Chart 2: Net revenues, COGS, Net Profit

- J Curve Data

If you have any questions regarding the tool, do not hesitate to start a discussion below, or message me privately via my author channel.

This Best Practice includes
1 excel spreadsheet

Acquire business license for $29.00

Add to cart

Add to bookmarks

Discuss


0.0 / 5 (0 votes)

please wait...