<\/span><\/h2>\nFinding terminal value in Excel involves using a combination of formulas and assumptions. The most commonly used method is the Gordon Growth Model, which assumes a constant growth rate. Here are the steps to follow:<\/p>\n
1. **Determine the expected cash flow for the final year** \u2013 Estimate the cash flow for the last year of the investment period.<\/p>\n
2. **Determine the expected growth rate** \u2013 Assess the expected growth rate of the investment beyond the forecast period.<\/p>\n
3. **Determine the discount rate** \u2013 Calculate the discount rate, which helps determine the present value of future cash flows.<\/p>\n
4. **Construct the formula for terminal value** \u2013 Use the Gordon Growth Model to calculate terminal value using the following formula:<\/p>\n
Terminal Value = (Cash Flow x (1 + Growth Rate)) \/ (Discount Rate – Growth Rate)<\/p>\n
5. **Enter the values into Excel** \u2013 Once the formula is constructed, input the relevant values into Excel cells. Assign appropriate cell references to ensure flexibility in recalculations.<\/p>\n
6. **Calculate the terminal value** \u2013 Apply the constructed formula using the values in step 5 to calculate the terminal value.<\/p>\n
7. **Interpret the result** \u2013 The calculated terminal value represents the estimated value of the investment at the end of the forecast period.<\/p>\n
8. **Compare with current valuation** \u2013 Compare the terminal value with the current valuation to assess the potential profitability of the investment.<\/p>\n
9. **Review and adjust assumptions** \u2013 If the calculated terminal value appears unlikely or not aligned with expectations, review and adjust the assumptions made for the growth rate and discount rate.<\/p>\n
10. **Re-evaluate the terminal value** \u2013 Recalculate the terminal value based on the adjusted assumptions to obtain a more accurate estimate.<\/p>\n
11. **Repeat for sensitivity analysis** \u2013 Perform sensitivity analysis by adjusting different factors such as the growth rate and discount rate to understand the potential impact on the terminal value.<\/p>\n
12. **Update the analysis as needed** \u2013 As new data becomes available or circumstances change, make necessary updates to the analysis to ensure the terminal value remains meaningful and relevant.<\/p>\n