Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please solve excel (20pts) The last 5 years' results of Niccair Corporation are given below. Value the company's stock based on a FCFF model. This
please solve excel
(20pts) The last 5 years' results of Niccair Corporation are given below. Value the company's stock based on a FCFF model. This means you will need to use the values below to estimate the future growth of Niccair's free cash flows to the firm, then discount those cash flows buck to the present using the formula to value a growng perpetutity. You may assume your entimate of Niccair's growth rate remains constant throughout the life of the firm. You with also need to estimate the WACC for Niccair in order to. discount your cash flows. Consider that Niccair's 2015 year-end debt is 5750MM. Niccali's 2015 year-end cash is \$50MM. The company has a cost of debt of 5.2. The company has 44,080,000 shares outstanding. The year end share priok is $37. Niccair's beta is 2 , the risk. free rate is 3%, the expected retum on the market is 12% Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started