Question: Construct the data table in cells C16 to C18. Your aim is to find the sensitivity of price per share (in cell B11) to the
Construct the data table in cells C16 to C18. Your aim is to find the sensitivity of price per share (in cell B11) to the WACC and Long Term FCF growth rate. Enter the value you found in cell C18 as the answer to this question. Use two significant figures. For example, if you answer was $65.7814578 you would answer 65.78.

= M1 Data Table setup for Quiz - Excel (Product Activation Failed) ? XI 5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW POWERPIVOT Calibri - 11 - AR A z Wrap Text General FA HH LO Insert Delete Format WE ! Apoorva Agrawal - AutoSum- , A Fill - Sort & Find & Clear Filter - Select Editing Paste BIU Merge & Center - $ - % 8.09 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells E11 : X fx A B D E F G H 1 J K L
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
