Join our Financial Modeling Course
Apply before March 18th
Register now
Financial model spreadsheet example

News / Blog website Financial Model Template

Google Sheets & Excel

Google Sheets + Microsoft Excel Template

With our News / Blog Financial Model you'll be able to:
  • Estimate the monthly growth of your website traffic, and video views, based on new content published.
  • Estimate revenue based on four business models: advertising, affiliate revenue, subscriptions, and partnerships.

Flexible + Simple

A financial model for businesses that generate revenue via ad impressions, affiliate links, and content subscriptions.

You can estimate ad revenue based on three main sources:

- Programmatic Ads:
based on CPM or CPC from platforms similar to Google AdSense, or Outbrain.

- Video Ads: assuming you generate CPM-based revenue from your video views.

- Newsletter Sponsorships: based on the amount of subscribers in your newsletter, and the average open rate.

On the Affiliate Revenue revenue line, you can estimate that a given percentage of your Website Visitors or your Video Viewers makes a purchase from one of your affiliate partners.

Assuming that your website has a premium content subscription, you'll be able to estimate subscription revenue.

Using a conversion rate from website to subscriber, you can calculate an MRR (subscription revenue).

Financial Model preview
SG&A
COGS
CAPEX
Revenue

Color-coded sheets that cover the basic expense and revenue categories for any financial model.

Cap table icon
Cap Table

Estimate equity and convertible note rounds of funding, from Pre-Seed to Series C.

Financial Model documentation preview
Book icon
Documentation & Support

A complete knowledge base, and phone support available from our financial analysts.

Financial Model Template for a
Blog / News website

Available in Microsoft Excel
and Google Sheets format

Avatar gesturing toward a finance chart

Need a custom model?

Financial Model Consulting

Our team can help customize your spreadsheet and train you on how to use it to run projections. We've helped hundreds of companies create models, from mobile apps, to crypto and real estate.
Talk to Sales
Slidebean logo
© Copyright 2024 Slidebean Incorporated. All rights reserved.
Made with 💙️ in New York City and San Jose