Financial Projections Excel Model Driven by Account Executive Performance/New Hires

Description
This is a full pro-forma. The revenue logic is completely driven by the amount of account executives you plan on hiring over time, their expected annual quotas, and the % to quota you think they will achieve over time. For example, 10% in their first 3 months, 20% for the next 3 months and so on to 100%.

You can set a fixed % bonus as well as have up to 3 different types of account executives that all have their own variables attached.

The value here is that based on adding new account executives over time and them achieving annual quotas, a monthly revenue projection is derived. Typically, this would be difficult to figure out on paper or in your head especially when you have various AE's starting at different months based on whatever ramping plan you have.

Outside of that logic, you are going to be able to populate running monthly cost assumptions with variable start months for each line-item as well as a separate section for CapEx and startup costs.

After all the assumptions are built, the template will give you a clean monthly, quarterly and annual P&L + cash flow (5 years) and plenty of visuals on an executive summary. This means granular and high level analysis of your projected plan.

There are plenty of visuals to see how you are doing on revenue per account executive, total head counts of AE's, margins, and running cash flow. Additional charts were added to visualize your break even (based on variable and fixed costs as they change each year).
 
A discounted cash flow valuation has also been done on a non-leveraged basis.

This template is also included in two bundles:
- All Models Bundle: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic
- SaaS / Subscription Models: https://www.eloquens.com/tool/wmyQI0eE/finance/venture-capital/the-complete-venture-capital-bundle
Note, this is not a SaaS model, but it does have some similar pieces of logic and that is why I've included it in the SaaS / Subscription bundle.