Templates
Finance
Discounted Cash Flow Analysis Template

Discounted Cash Flow Analysis Template

This DCF Analysis Template guides through business valuation by estimating & discounting cash flows, terminal value, & equating to share value.
1
Identify the cash flow periods
2
Calculate the Free Cash Flows (FCF)
3
Estimate the growth rate for the FCFs
4
Determine the discount rate using WACC
5
Approval: Discount Rate
6
Discount the FCFs to net present value
7
Calculate the terminal value of the business
8
Approval: Terminal Value
9
Discount the terminal value to net present value
10
Sum up the discounted FCFs and terminal value
11
Subtract net debt from the business valuation
12
Convert the equity value into equity value per share
13
Approval: Final Equity Value per Share
14
Finalize and document the DCF Analysis Template
15
Present the DCF analysis to the stakeholders
16
Receive feedback from stakeholders
17
Approval: Stakeholder Feedback
18
Revise and finalize the DCF analysis based on feedback
19
Implement the findings in business decision making
20
Monitor the results and outcomes