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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!