Question: O 1 2 3 4 5 6 4) Now let's work on calculating the Terminal Value. Hint: Use the yellow input boxes in the area
O 1 2 3 4 5 6 4) Now let's work on calculating the Terminal Value. Hint: Use the yellow input boxes in the area designationd DCF Calculations in the Discounted Cash Flow Sheet. Discount Rate Weighted Average Cost of Capital Long-term Unlevered FCF Growth What is the Equity Value per Share targeted by your Discounted Cash Flow model generate for 2021E? Hint: Refer to Row 60 in the DISCOUNTED CASH FLOW Sheet. What is the upside potential given the current share price? $276.95 Hint: "Upside Potential" is the common vernacular used by investors to look at the percent increase from the current price to the c B 9 What percentage of the projected Factbook Equity Value for 2021E is due to the Terminal Value? 1 2 3 4 5) Let's consider sensitivity analysis using the What If capabilities of Excel's Data Table functionality. 5 Note the Data Table in L45 of the Discounted Cash Flow in SFAM. 5 The Data Table varies the assumptions we used for the Discount Rate (row 45 in SFAM) and the Implied Terminal Multiple (row 50 in 7
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
