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
Identify the cash flow periods
This task is crucial in the discounted cash flow analysis as it determines the time periods for which the cash flows will be analyzed. By identifying the cash flow periods, you can accurately calculate the future cash flows and determine the net present value. Consider the historical data, financial statements, and business projections to identify the appropriate time periods.
Calculate the Free Cash Flows (FCF)
The Free Cash Flows (FCF) are a crucial component of the discounted cash flow analysis. By calculating the FCF, you can determine the amount of cash generated by the business that is available to be distributed to investors and reinvested. Consider the net income, depreciation, capital expenditures, and changes in working capital to accurately calculate the FCF.
Estimate the growth rate for the FCFs
The growth rate for the Free Cash Flows (FCFs) is an important parameter in the discounted cash flow analysis. By estimating the growth rate, you can project the future cash flows and determine the net present value. Consider historical growth rates, industry trends, and business prospects to estimate the appropriate growth rate for the FCFs.
Determine the discount rate using WACC
The discount rate is a crucial factor in the discounted cash flow analysis, as it determines the present value of future cash flows. By calculating the Weighted Average Cost of Capital (WACC), you can determine the appropriate discount rate. Consider the cost of equity, cost of debt, and the business's capital structure to calculate the WACC.
Approval: Discount Rate
Will be submitted for approval:
Determine the discount rate using WACC
Will be submitted
Discount the FCFs to net present value
Discounting the Free Cash Flows (FCFs) to their net present value is a critical step in the discounted cash flow analysis. By applying the discount rate, you can determine the present value of the future cash flows. Consider the cash flow periods, FCFs, and discount rate to accurately discount the FCFs to their net present value.
Calculate the terminal value of the business
Calculating the terminal value of the business is an important step in the discounted cash flow analysis. By estimating the value of the business beyond the projected cash flow periods, you can determine the overall value of the business. Consider the growth rate, last period FCF, and discount rate to calculate the terminal value of the business.
Approval: Terminal Value
Will be submitted for approval:
Calculate the terminal value of the business
Will be submitted
Discount the terminal value to net present value
Discounting the terminal value of the business to its net present value is a crucial step in the discounted cash flow analysis. By applying the discount rate, you can determine the present value of the terminal value. Consider the terminal value, cash flow periods, and discount rate to accurately discount the terminal value to its net present value.
Sum up the discounted FCFs and terminal value
Summing up the discounted Free Cash Flows (FCFs) and the terminal value is a vital step in the discounted cash flow analysis. By adding the discounted FCFs and the discounted terminal value, you can determine the total present value of the cash flows. Consider the discounted FCFs and the discounted terminal value to accurately sum up the present value.
Subtract net debt from the business valuation
Subtracting net debt from the business valuation is an essential step in the discounted cash flow analysis. By subtracting the net debt, you can determine the equity value of the business. Consider the business valuation and the net debt to accurately calculate the equity value.
Convert the equity value into equity value per share
Converting the equity value into equity value per share is an important task in the discounted cash flow analysis. By dividing the equity value by the number of shares outstanding, you can determine the value of each share. Consider the equity value and the number of shares outstanding to accurately convert the equity value into equity value per share.
Approval: Final Equity Value per Share
Will be submitted for approval:
Convert the equity value into equity value per share
Will be submitted
Finalize and document the DCF Analysis Template
Finalizing and documenting the DCF Analysis Template is a crucial step in the discounted cash flow analysis. By reviewing and editing the template, you can ensure its accuracy and completeness. Consider the calculations, formatting, and clarity of the template to finalize and document the DCF Analysis Template.
1
Yes
2
No
Present the DCF analysis to the stakeholders
Presenting the DCF analysis to the stakeholders is a significant step in the discounted cash flow analysis. By sharing the analysis results, you can gather feedback and insights from the stakeholders. Consider the audience, presentation format, and clarity of the analysis to effectively present the DCF analysis to the stakeholders.
Receive feedback from stakeholders
Receiving feedback from stakeholders is a crucial step in the discounted cash flow analysis. By actively listening to the stakeholders' opinions and suggestions, you can refine and improve the analysis. Consider their feedback, concerns, and recommendations to effectively receive feedback from stakeholders.
Approval: Stakeholder Feedback
Will be submitted for approval:
Present the DCF analysis to the stakeholders
Will be submitted
Revise and finalize the DCF analysis based on feedback
Revising and finalizing the DCF analysis based on feedback is an important step in the discounted cash flow analysis. By incorporating the stakeholders' feedback, you can refine and improve the analysis. Consider the feedback received, areas of improvement, and the impact on the analysis to successfully revise and finalize the DCF analysis.
1
Yes
2
No
Implement the findings in business decision making
Implementing the findings of the discounted cash flow analysis in business decision making is a critical step. By using the analysis results, you can make informed decisions regarding investments, acquisitions, or strategic initiatives. Consider the analysis outcomes, business strategy, and decision-making process to successfully implement the findings in business decision making.
Monitor the results and outcomes
Monitoring the results and outcomes of the discounted cash flow analysis is an important task. By tracking the actual performance against the projected cash flows, you can assess the accuracy of the analysis and make adjustments if necessary. Consider the performance metrics, variance analysis, and reporting frequency to effectively monitor the results and outcomes.