Answered step by step
Verified Expert Solution
Link Copied!

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
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 to Expert-Tailored 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

Recommended Textbook for

The Bank Credit Analysis Handbook

Authors: Jonathan Golin, Philippe Delhaise

2nd Edition

0470821574, 978-0470821572

More Books

Students also viewed these Finance questions

Question

android application development assignments

Answered: 1 week ago

Question

1. Organize and support your main points

Answered: 1 week ago

Question

3. Move smoothly from point to point

Answered: 1 week ago

Question

5. Develop a strong introduction, a crucial part of all speeches

Answered: 1 week ago