-------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------

Please download this Excel file to answer some of the questions in the exam. DCF - Qualified Assessment (Template).xIsx 2 Time Quantity of Money As an analyst, it's important to understand how invested cash flows compound into the future, as well as calculate the present value of a future cash inflow. - Open the attached Excel file and go to the worksheet labeled: 1-PV and FV Calculate the present value and future value, respectively. $29,175;$51,875$51,875;$29,175$47,159;$31,508$31,508;$47,159 7 Preferred Model Layout Please sort the below choices according to our recommended model-building structure. Given the below choices, sort the order we feel that DCF models should be designed, from first last. Revenue Build Dashboards DCF Income Statement Present Value of the Terminal Value All figures in USD thousands unless stated Fiscal Year End Cash Flow Timing 1 Assume the Cash Flow Timing occurs at the Fiscal Year End. (1) 5 Present Value of the Terminal Value Although there are two different ways of deriving terminal value, either method must be discounted back to the valuation date. - Open the attached Excel file and go to the worksheet labeled: 2-PV of Terminal Using the perpetuity growth rate, calculate the present value of the terminal value. $313,590 $312,281 $304,247 $313,375 Present Value of the Terminal Value All figures in USD thousands unless stated Fiscal Year End Cash Flow Timing 1 Assume the Cash Flow Timing occurs at the Fiscal Year End. (1)