Dcf model excel download

Dcf model excel download

Discounted Cash Flow (DCF) Model

Template Description

The Macabacus DCF template implements key concepts and best practices related to DCF modeling. It computes the perpetuity growth rate implied by the terminal multiple method and vice versa, and sensitizes the analysis over a range of assumed terminal multiples and perpetuity growth rates without the use of slow Excel TABLEs. The model computes DCF valuations manually, and uses XNPV formulas to check the calculations.

DOWNLOAD

20kb | created with Macabacus
120,525 downloads since May 14, 2013
Last modified Apr 13, 2020

Financial Modeling Templates

Dcf Model Excel Download
Jump to a Model

Financial Modeling Excel Templates

Financial Modeling is defined as the forecast of financial fundamentals of the company based on its past as well as the expected future. Here you can download 11 Financial Modeling templates for free including Alibaba IPO model, Box IPO Model, Colgate Financial Model, Beta calculation, Free Cash Flow to Firm Model, sensitivity analysis model, comparable company analysis model, PE and PE Band Chart, Scenario Model and Football Field Chart.

Download All IB Templates

#1 – Alibaba IPO Template

In May 2014, Chinese E-commerce biggie Alibaba filed for its IPO in the US. I created its financial model from scratch. Through this template, you will learn Alibaba’s 3 statement forecasts, interlinkages, DCF Model – FCFF and Relative Valuation.

Dcf Model Excel Download
Financial Modeling Templates

#2 – Colgate Financial Model Excel Template

This Colgate Financial model is a part of the Financial Modeling in Excel, where there are two templates – solved and unsolved financial models of Colgate. You can start with Colgate’s unsolved model and follow the tutorial to create a complete financial model.

Dcf Model Excel Download
Discounted Cash Flow (DCF) Excel Template

#3 – Box IPO template

In March 2014 Box filed for registration documents for IPO in the US to raise $250 million. Here I created another template from the start and covered its projection of financial statements of Box, valuations, and target recommendations.

Dcf Model Excel Download

#4 – Beta Calculation Worksheet – MakeMyTrip

Beta measures the sensitivity of stock prices as compared to the larger INDEX. In this excel CAPM model, we calculate the Beta of MakeMyTrip with respect to NASDAQ.

Dcf Model Excel Download

#5 – Terminal Value Calculation – Excel Template

Terminal Value is the value of the company after the forecast period. It is a very important concept as more than 60-80% of the total value is derived from the Terminal value. This excel template provides two ways to calculate the Terminal value – Perpetuity Growth method and Multiple Method.

Dcf Model Excel Download

#6 – Free Cash Flow Excel Template

In simple terms, Free Cash Flow firm is the sum total of Cash flow from Operations and Cash Flow from Financing. FCFF is the foundation of the DCF technique.

Dcf Model Excel Download

#7 – PE Chart Template & PE Band Chart Excel Template

PE Charts and PE Band Charts are very important from an investment banking point of view. They provide a visual glimpse of how valuations have moved over a period of time. PE Band Charts can be a bit tricky to make. Download this excel model to learn how to make this chart step by step.

Dcf Model Excel Download

#8 – Football Field Graph

Football Field Chart is very helpful to visually understand the valuation of the firm under various scenarios as well as valuation methodologies. Download this financial modeling template to learn the Football Field Chart.

Dcf Model Excel Download

#9 – Scenario Graph Template

Scenario graph is one of my favorites when it comes to providing a visual explanation of valuation scenarios. It is a very high impact graph and when included in your pitch book or research report, it can make an excellent impression on your clients. Download this Scenario Graph Template.

Dcf Model Excel Download

#10 – Comparable Company Valuation Model Template

Comparable company analysis is nothing but looking at the competitors of the firm and taking cues from their valuations. We use relative valuation multiples like PE Multiple, EV to EBITDA, Price to Cash Flow ratio. However, there is a way to professionally compare the valuation multiple of competitors and you can download this financial model template to learn awesome valuation techniques.

#11 – Sensitivity Analysis

Sensitivity Analysis is very important when we have to do Discount Cash Flows and want to check the sensitivity of Fair Price when we change variables like Growth Rates of Company and Weighted Average Cost of Capital. We use DATA TABLEs in Excel to do this sensitivity analysis.

Recommended Articles

This has been a guide to Financial Modeling Templates. Here we provide you top 11 financial modeling templates that include Alibaba IPO Template, Box IPO template, etc. You can learn more about from the following articles –

Popular Course in this category
Financial Modeling Course (with 15+ Projects)4.9 (927 ratings)16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion

Discounted Cash Flow (DCF) Excel Template

Discounted cash flow (DCF) is a method used to estimate the value of an investment based on future cash flow. The DCF formula allows you to determine the value of a company today, based on how much money it will likely generate at a future date.

To do this, DCF finds the present value of future cash flows using a discount rate. Once you have the PV it can then be used to evaluate the investment to see whether it is a wise decision.

Dcf Model Excel Download
on
Learn the building blocks of a simple one-page DCF model consistent with the best practices you would find in investment banking. As a side benefit, the DCF is the source of a TON of investment banking interview questions. (Click here for part 2) Wall Street Prep Financial Modeling Quick Lesson -. DCF Model (Discounted Cash Flow Valuation Model) This simple DCF model in Excel allows you to value a company via the Discounted Free Cash Flow (DCF) valuation method. The discounted cash flow valuation model uses a three statement model to derive free cash flows to firm and discounts them to their present value.
Rating: 5