Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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
image text in transcribed
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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

android application development assignments

Answered: 1 week ago