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.

  1. Start your free 30-day trial of Macabacus.
  2. In Excel, navigate to: the Macabacus tab > New > Sample Models.
  3. 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.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more