b) 0 1 $3.55 $ 3.91 $ Calculate the price of MSFT using the PE Ratio to calculate the Terminal Value.(assume Net Income per share of $5.93 on year 3) Year FCFE 3 2 4.30 $ 4.42 F101*(1+G102) Growth Rate 10% 10% Terminal Value Cash Flows $ 3.91 $4.30 $69.53 =G101+G103 Share Price 3.0% $65.10 G101*(1+G102)/(C82-G102) $59.34 =NPV(C82,E104:G104)

b) 0 1 $3.55 $ 3.91 $ Calculate the price of MSFT using the PE Ratio to calculate the Terminal Value.(assume Net Income per share of $5.93 on year 3) Year FCFE 3 2 4.30 $ 4.42 F101(1+G102) Growth Rate 10% 10% Terminal Value Cash Flows $ 3.91 $4.30 $69.53 =G101+G103 Share Price 3.0% $65.10 G101(1+G102)/(C82-G102) $59.34 =NPV(C82,E104:G104)

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter15: Capital Investment Analysis

Section: Chapter Questions

Problem 15.1.1MBA

See similar textbooks

Similar questions

Based on the information above, the capital gains yield for the coming year is closest to A. 9.08%. B. 6.85%. C. 4.28%. D. 2.14%.
man.1
Subject :- Accountinig
Please give me answer
Inputs Annual Coupon Rate 3.70% Number of Years 6 Face Value (PAR) $1,000 Price $1,100.27 In Excel: a. What is the YTM? b. Calculate convexity using Excel
Assume the following ratios are constant. Total asset turnover Profit margin Equity multiplier Payout ratio = Sustainable growth rate |||||||| 2.22 5.0% 1.69 What is the sustainable growth rate? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. 47% %
Aa 15.
Use the table for the question(s) below. FCF Forecast ($ million) Year Sales 1 270 12.5% 32.40 Less: Income Tax (37%) (6.48) Less Increase in NWC (12% of Change in Sales) 3,60 Free Cash Flow 22.32 Growth versus Prior Year EBIT (10% of Sales) 0 240 OA. $4.27 OB. $7.47 OC. $12.8 OD. $5.12 2 290 7.4% 34.80 (6.96) 2.40 25.44 ACCE 3 310 6.9% 37.20 (7.44) 2.40 27.36 Banco Industries expect sales to grow at a rapid rate over the next 3 years, but settle to an industry growth rate of 4% in year 4. The spreadsheet above shows a simplified pro forma for Banco Industries. Banco industries has a weighted average cost of capital of 10%, $30 million in cash, $60 million in debt, and 18 million shares outstanding. If Banco Industries can reduce its operating expenses so that EBIT becomes 12% of sales, by how much will its stock price increase? 4 325.5 5.0% 39.06 (7.81) 1.86 29.388
Financial leverage MicrosoCortrepotied (MSFT) reported the following data (in millions) for a tern year Compute the profit margin, asset turnover, and financial leverage metrics using the expandedDuPont formula. Round profit margin, asset turnover, and financial leverage to two decimalplaces.Round return on stockholders’ equity to one decimal place.
Use the information below to calculate WACC given the Market Capitalization of the company: Market Cap = 193.2 Million EBIT = 17.2 Million Depreciation = 4.2 Million Capital Expenditures = - 3.8 Million Change in W/C = 2.1 Million growth = 7% FCF = ? WACC = ?
Use the table for the question(s) below FCF Forecast (5 million) Year Sales Growth vs. Prior Year EBIT (10% of Sales) Less: Income Tax (37%) 0 240 Less: Increase in NWC (12% of Change in Sales). Free Cash Flow OA. $8.64 OB. $17.28 OC. $9.60 OD. $4.80 1 270 12.5% 27,00 (0.99) 3.6. 13.41 2 290 7.4% 29,00 10.73 2.4. 15.87 3 310 ETTE 6.9% 31.00 11.47 24 17.13 325.5 5.0% 32.55 12.44 Banco Industries expect sales to grow at a rapid rate over the next three years, but settle to an industry growth rate of 4% in year 4. The spreadsheet above shows a simplified pro forma for Banco Industries. If Banco industries has a weighted average cost of capital of 12%, $30 million in cash, $60 million in debt, and 18 milion shares outstanding, which of the following is the best estimate of Banco's stock price at the start of year 17 1.86 18.65
Give typing answer with explanation and conclusion