Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
  • Digital News Media Pro Forma Excel Model Template
Originally published: 08/01/2019 14:10
Publication number: ELQ-55033-1
View all versions & Certificate
certified

Digital News Media Pro Forma Excel Model Template

This is a high quality, detailed pro forma, providing many important tabs for a digital news media organisation to use.

assumptionsbalance sheetcash flowsdigital newsincome projectionmediap&lpro formaprofit/losssales forecast

Description
This is an incredibly detailed pro forma Excel spreadsheet provided by Mahender Punhani for a digital news media organisation.

Included in this tool, which is available to download instantly and is ready to use, are a range of different templates to help the modeling and running of your organisation.

Included in this spreadsheet is:

- Assumptions: The first tab tackles assumptions such as:

Revenue, Cost of Revenue
Investment in Assets
Life of Fixed Assets
Amortization of Intangible Assets
Accounts Receivable and Accounts Payable days
Prepaid Insurance
Bank Term Loan
Income Tax

- Startup Expenses: Including fixed assets, other assets. Rent and Business Licenses, for example.

- Cash Flows, up to the end of Year 5

- Profit and Loss Statement: budget vs. actual, includes controllable expenses (i.e. salaries / wages) and fixed expenses (rent and insurance).

- 5-year forecast: This includes two easy-to-understand graphics one displaying a forecast of revenue, gross profit and net profit after taxes, and the other giving the profitability ratios in gross and net form.

- Income Projection Statement: Including controllable expenses, and fixed expenses.

- Balance Sheet: Recording current assets and current liabilities.

- Sales Forecast: Subscription revenue, Advertising revenue, Total Revenue - with accompanying graphs for clearer visualization of data.

- Milestones

- Break-even calculation with line chart

- Staffing: includes salary and additional costs, such as healthcare and tax

- Bank Term Loan

- Assets Schedule

- Accounts Receivable and Account Payable

If you have any queries regarding this detailed spreadsheet, do not hesitate to start a discussion below, or message privately.

This business tool includes
1 Excel Spreadsheet

Acquire business license for $89.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Mahender K. Punhani

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Digital News Media Pro Forma Excel Model Template?

The user community and author are here to help. Go ahead!

please wait...