Overview

Discounted Cash Flow Model, or popularly known as the DCF Model, is one of the more widely used equity valuation models in the investment industry. The underlying principle behind the DCF valuation model is that a business is worth the present value of its expected future cash flows.

 

 

Valuation is both an art and a science. The purpose of the template is to facilitate the user to consider multiple ways to value a business in order to triangulate a reasonable valuation. Don't know much about valuation? Don't worry, this template will guide you through all the factors to consider - just enter your assumptions into the yellow cells and the model will do the rest.

 

Outputs – contains a summary of valuation results including transaction/M&A (mergers and acquisitions) comparables, Listed company comparables, Net present value, Gordon’s growth model and Balance Sheet valuations. Valuations consider both historical and forecast data as well as demonstrating the valuation in using both annual or monthly data. Also contains a summary of average assumptions for each valuation type. There is also an output that triangulates an average of all methodologies used.

Assumptions – In general settings set up the valuation template by entering the name, units, model timeline start date and forecast date. Tick the boxes to determine which valuation methodologies to consider. We recommend using as many as possible. In 1.2 enter your P&L and Balance Sheet data. You can select to enter both historical and forecast data, and also choose to enter data annually, monthly, or both (as determined by your settings in 1.1). 1.3 enter your comparable transaction data that relates to the company you’re valuing. 1.4 enter your comparable listed company data. We also recommend applying a liquidity discount as your company will likely be privately owned.

Reviews Add a review
No reviews yet

More From TheExcelExpert

Browse our top rated business templates. See All
Collection of Canva Investor Pitch Deck Templates Fully Editable PPT
210
0
These Investment Pitch Deck PowerPoint Template is perfect for startup companies or small businesses which are looking for potential investors…
Real Estate Full Graphical Property Calculator BTS and BTL all Expenses Analysis
211
0
Free Cash Flow Real Estate Valuation Template The Free Cash Flow Real Estate Valuation Template helps to create a business…
Real Estate Re Investment and Refinancing Modelling Excel Sheet Template
219
0
The model has multiple house analysis database through which you can set the expense, mortgage expense, refinacing expense details and…
Complete Merger Analysis Sheet for Start Ups Businesses and Presentation
218
1
A 3 statement model template connects the income statement, balance sheet, and cash flow statement into one dynamically linked financial model. This model has…
Complete Merger and Acquisition Investor and Business Owner Analysis Sheet
190
0
Overview Overview A 3 statement model template connects the income statement, balance sheet, and cash flow statement into one dynamically linked financial model. This…
Project management Gantt Chart business excel model template
176
0
A gantt chart is a project management tool used to arrange the schedule of a project. It is built with…
See All