This tools requires you to input the summarised historical and forecast P&L and Balance sheet data of a company and will automatically calculate a statement of net cash flow, Free Cash Flow, and will allow you to get a proper Discounted Cash Flow analysis based on the different parameters you are invited to enter. It also encourages you to conduct a valuation based on comparable transaction multiples and offer a summarized aggregated view of your valuation range.
After inputting your summarised P&L data ( Revenue, COGS, Opex, D&A, Interest costs and corporate tax) both for historical and for forecast period, the following tab of this best practice generates a graph that should help you assess the consistency of your forecast vs. historical.
You are then invited to input your balance sheet numbers on a historical and forecast basis which will allows this best practice to generate in the following tab a statement of Net Cash Flow (checking that Net Cash Flow is equal to your movement in Cash as per your balance sheet)
The following tab contains an automatically generated Free Cash Flow to the Firm (FCFF) statement that will be used in the Discounted Cash Flow (DCF) analysis.
Next, going to the Valuation part of this best practice, you will be presented with a Discounted Cash Flow model. You will be invited to look for unlevered beta of public comparable companies. You will also be asked to input a risk free rate, a tax rate, a target Debt / Equity structure that will allow to automatically calculate levered beta.
You will also need to input a market risk premium and a liquidity & Smaller cap premium to account for additional risk related to the size of your business and whether it is privately own (hence less liquid)
Finally you will indicate the cost of debt and a WACC for your business will be automatically calculated. I have included some links to online resources to help you out with some of these inputs.
After deciding on a terminal growth, the DCF model will automatically calculate a Firm value. A small table is also included to assess this DCF valuation in terms of revenue, EBITDA and EBIT multiples
The last three tabs are template to encourage you to look for comparable online (some online references are also included). They will both help you come up with a valuation range and cross check your valuation with market practice.
After everything has been completed, you can come back to the beginning of the model to see a summarised view of valuation based on different techniques used.
Similar Products
Other customers were also interested in...
Due Diligence P&L – Exhaustive Revenue a...
Model for in depth understanding of high level profit and loss and revenue analysis. Big-4 like chec... Read more
Multiple rounds Cap Table including Safe, pro-rata...
Multiple rounds cap table including SAFE conversion, Management option pool and investment performan... Read more
Price Volume Mix Charts and Analysis – On re...
Best practice model for a complete Price Volume Mix (PVM) analysis on revenue and on gross profit by... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
Advanced Financial Model with DCF & Valuation
General Overview Advanced Financial Model suitable for any type of business/industry and fully cu... Read more
3 Statement Financial Modeling with DCF & Rel...
Financial Modeling Tutorial guides user via step by step approach on how to build financial models w... Read more
Cap Tables & Investor Returns Model
User-friendly Cap Table Model for a startup company or early-stage venture including multiple rounds... Read more
You must log in to submit a review.