Discounted Cash Flow (DCF) Model

1 minutes read

Last updated: June 7, 2023

The Macabacus Discounted Cash Flow 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.

Excel Template Preview

To access this free Discounted Cash Flow (DCF) Analysis template, see the instructions below the preview.

Unlock Access to Exclusive Templates

Gain instant access to our library of professionally designed templates.

Start your free 30-day trial of Macabacus.
In Excel, navigate to: the Macabacus tab > New > Sample Models.
Browse and select your desired template from our extensive library.

Start Free Trial to Access Template

Discover more topics

Build an operating model

In this tutorial, we will walk through how to build a general industry business operating model.

Build an M&A model

In this section, we demonstrate how to model a merger of two public companies in Excel.

Build an LBO model

In this tutorial, we will walk you through building an LBO model in Excel.

Asset and Stock Deals

The first step in purchase price allocation, or PPA, is to determine the purchase price.