Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 15 Microsoft Co. has the following projected sales, costs, net investment, and free cash flow in millions. The anticipated growth rate in free cash
QUESTION 15 Microsoft Co. has the following projected sales, costs, net investment, and free cash flow in millions. The anticipated growth rate in free cash flows after year 6 is 5% per year forever. There are 7.43 billion shares outstanding, and investors require a return of 8% on the company's stock and a comparable P/E ratio of 21. Calculate the company stock price using the P/E comparable approach to find the terminal value. (Round to 2 decimals) 2 4 244 269 126 139 42 46 76 84 58 26 ($ in Billions) Sales Costs Taxes OCF (net income) Net investment FCF 1 232 120 40 72 50 22 53 23 3 256 132 44 80 55 25 5 282 146 48 88 61 27 6 296 153 50 92 64 28
please show work in excel
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