Overview

 This is a full 5-year monthly, quarterly and annual financial model that uses unique quota attainment revenue logic to drive potential revenues. The use case here is any business that primarily earns revenue based on the performance of account executives.
Report tabs include:

  • Monthly, Quarterly and Annual pro forma
  • Annual break-even analysis and break even monthly/year for operations
  • Valuation
  • High level financial summary with IRR (leveraged / non-leveraged)
  • DCF Analysis
  • Visualizations of primary financial results

The primary advanced forecasting logic this template has deals with AE (account executive) performance. The user can define up to 3 types of AEs and for each, the user defines:

  • Count added per month
  • Base Salary
  • Flat Bonus %
  • Annual Quota
  • % of Quota attained in first 3/6/9/12 months of the life of an AE by type

The amount of revenue will dynamically be calculated based on inputs for the above and the goal of this logic is to model out human behavior (performance) dynamically and get a resulting amount of revenue brought in based on this performance.
Operating cost schedule is simply defined by the cost description item, start month, and the monthly cost of each can be defined in each year. There are also multiple slots to account for cost of goods sold and/or any costs not already accounted for that are defined by a percentage of total revenue.
Note, the base salary for Account Executives is defined on the ‘AE’ tab and not in the ‘Operating Costs’ tab.
More pieces of logic included are the potential for an exit (and that is used for valuation purposes as well) and is based on either a multiple of EBITDA or Revenue (optional for users to choose). Also, debt can be a funding source as well as investor and any remaining would fall to the owners/operators. Any debt that exists upon exit is reduced from the exit proceeds.
Most summary output data is shown per leveraged and unleveraged.
The monthly and annual pro forma shows EBITDA and cash flow before tax per period as well as cumulative cash position (leveraged/unleveraged).

Reviews Add a review
No reviews yet

More From smarthelping

Browse our top rated business templates. See All
Manufacturing Pricing Model
28
0
 This is a pricing tool for any type of manufacturing operation, no matter how big or small. The goal seek…
General Use Cash Flow Waterfall with 3 IRR Hurdles
24
0
 This is a great template for anyone involved in joint venture deals, wants to learn how IRR Hurdles work (the…
SaaS Rolling Revenue Forecasting Template
126
0
 Performing regular revenue and customer count forecasts for a SaaS company can be difficult and chaotic. This is for a…
Gordon Growth Valuation Model
350
0
This template is designed for valuation. It uses DCF Analysis but without a terminal value. Oftentimes you will see a…
Driving Range: Startup Financial Model
407
0
 This is a bottom-up financial model that goes up to a period of 10 years. It is for anyone that…
DCF Analysis with Sensitivity Analysis
396
0
 DCF Analysis templates are very useful for those trying to figure out the present value of future cash flows, the…
See All