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.


20kb | created with Macabacus
142,643 downloads since May 14, 2013
Last modified Aug 1, 2020