DCF Model Template with IRR
Originally published: 12/11/2018 11:11
Last version published: 16/01/2019 09:20
Publication number: ELQ-67023-2
View all versions & Certificate

DCF Model Template with IRR

This DCF Model Template from CFI is an effective tool for creating your own DCF Model with customised assumptions.

Discounted Cash Flow (DCF) models are among the most popular tools used for valuing a business. They produce a forecast of a business’ unlevered free cash flow discounted back to today’s value. This is known as the Net Present Value (NPV). This DCF template is derived from the 3 statement financial model, combining the business’ financials into a single output.

The DCF model is comprised of the following tabs:

1. Assumptions
The assumptions include the income statement and balance sheet summaries.

2. Income Statement
This comprises the revenue, gross profit, expenses and taxes that must be included.

3. Balance Sheet
Here we find the assets and liabilities, as well as the shareholders’ equity, that the company owns.

4. Cash Flow Statement
Cash from operations, investing, and financing are included here.

5. Supporting Schedules
Supporting schedules show material information that is in addition to assets and liabilities on the balance sheet.

6. DCF Model
The DCF Model then brings together these inputs and breaks it down into time periods. Intrinsic value, market value and rate of return are included.

7. Charts and Graphs
The charts and graphs produced here present the information in a more digestible fashion.

Attached to this download is a PDF guide that will explain in more depth the features of the DCF model. In addition, there is also an accompanying tutorial video.

This Best Practice includes
1 Excel Spreadsheet, 1 PDF, 1 Tutorial Video

Acquire business license for $97.00

Add to cart

Add to bookmarks


0.0 / 5 (0 votes)

please wait...