Building a monthly travel page in a financial model

< Back

The ‘Monthly Travel’ page is perhaps the quickest worksheet to put together and simply outlines how the business performs on a monthly basis, taking into account the various costs and revenue models included.

Think of it as a monthly breakdown of the ‘Results Page’, enabling you to see how the business trends during the year. This is especially important for subscription-businesses, where annual subscription sales have to be broken down and recognised on a monthly basis.

Additionally, this page enables you to see if anything odd crops up during the building process. It is great as a sanity checker. Along with the data, I believe it is wise to include a monthly line chart outlining important key numbers such as revenue, OPEX and EBIT this it helps to visualise the forecast performance of the business.

The attributes for this page are slightly different and roll out across the page from month one through to month 60 for a 5-year model.

The attributes include:

  • PERSONAL SUBSCRIPTIONS
  • COMPANY SUBSCRIPTIONS
  • SINGLE COPY REPORT SALES
  • BANNER SALES
  • STOREFRONT SALES
  • LICENSING / PARTNERSHIPS
  • R&D GRANT
  • MONTHLY TOTALS
  • MARKETING SPEND
  • HR COSTS
  • OFFICE AND ADMINISTRATION COSTS
  • FINANCE AND PROFESSIONAL SERVICES COSTS
  • TOTAL OPEX
  • EBIT ($)
  • EBIT (%)
  • MONTHLY GROWTH RATE – REVENUE
  • MONTHLY GROWTH RATE – OPEX
  • MONTHLY GROWTH RATE – MARGIN
  • YoY GROWTH RATE – REVENUE
  • YoY GROWTH RATE – OPEX
  • VISITS
  • PAGE VIEWS
  • PAGE VIEWS PER VISIT
  • BANNER IMPRESSIONS
  • MONTHLY GROWTH – VISITORS
  • YoY GROWTH – VISITORS
  • MONTHLY GROWTH – PAGE VIEWS
  • YoY GROWTH – PAGE VIEWS
  • MONTHLY GROWTH – PAGE VIEWS PER VISIT
  • YoY GROWTH – PAGE VIEWS PER VISIT

Once the budget has been approved, then you can look at generating monthly forecasts and noting actuals (and variances against the forecast) within the model. For informal help on how to best achieve this then please contact us.

Now we have completed this page, lets move on to the next page, which is the first of our commercial business models, the Individual Subscription model:

  • Outline and Results page
  • Monthly Travel
  • Individual Subscriptions Model
  • Corporate Subscriptions Model
  • Report Sales Model
  • Advertising Sales Model
  • Marketing Plan and Model
  • Contributor Payment Model
  • The HR, Assorted Costs and Budget Detail pages
Share This Post