Organic Online Marketing Model

SEO Organic Online Marketing

The Organic Online Marketing Model derives the expected revenues and profits from SEO initiatives over the next 5 years and calculates IRR and NPV.

The template provides the following:

  • Executive Summary section with charts and key financials
  • Key assumptions sheet specific to organic online marketing initiatives
  • Monthly financial projections (impact on Income Statement) over 5 years
    • Operational metrics such as website traffic, conversion rates, new customers acquired, average order value and orders received
    • Monthly impact on profits
    • Payback period and breakeven month
  • Yearly financial projections (impact on Income Statement)
  • Calculation of  Net Present Value (NPV) via the Discounted Free Cash Flow (DCF) method and Project IRR
  • Reader and print-friendly layout including charts and graphs

The Organic Online Marketing Model provides a financial model template to estimate the financial impact of organic marketing activities such as SEO on the company’s financials and DCF value.

The model is available in two versions:

  • DEMO Version with only the input cells editable and formulas hidden
  • FULL VERSION with all cells editable and all formulas visible

Also the author offers to review and discuss the financial model for the specific case of the user during a 1/2 hour Skype call.

Filetype: .xlsx (Microsoft Excel 2008 for Mac)

Add to wish list
Purchase Excluding 7.7% tax

 

ROI of Organic Marketing Campaigns
ROI of Organic Marketing Campaigns
Users who purchased Organic Online Marketing Model, also purchased:
Employee Performance Tracking: Service Hours
manag5
Add to wish list
Purchase Excluding 7.7% tax
Paid Online Marketing Model
Paid Advertising
Add to wish list
Purchase Excluding 7.7% tax
eCommerce Valuation Model
eCommerce Financial Model
Add to wish list
Purchase Excluding 7.7% tax
Industry , ,
Summary The Organic Online Marketing Model derives the expected revenues and profits from SEO initiatives over the next 5 years and calculates IRR and NPV.
Screenshots / Pictures
Use Cases , , , , , , , ,

You must log in to submit a review.