34 35 36 37 38 39 40 40 A 41 42 43 43 44 45 46...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
34 35 36 37 38 39 40 40 A₁ 41 42 43 43 44 45 46 47 48 49 50 51 52 53 SA 54 EE 55 56 57 58 59 60 61 62 A 01/08/19 01/09/19 01/10/19 01/11/19 01/12/19 01/01/20 01/02/20 01/02/20 01/02/20 01/03/20 01/04/20 01/04/20 01/05/20 01/06/20 01/07/20 01/08/20 01/09/20 01/10/20 CATATAN 01/11/20 et habe 01/12/20 01/01/21 6103.61 01/02/21 ***** 01/03/21 men 01/04/21 01/05/21 01/06/21 01/07/21 01/08/21 01/09/21 01/10/21 01/11/21 B 134.620514 2816.290039 136.215118 140.467209 2901.52002 2913.97998 148.315048 2711.73999 155.032852 2760.169922 2506.850098 167.350937 $50 360058 159.269958 155.466187 176.660278 180.642792 201.173248 202.656052 222.940445 222:340443 208.417557 EVONATOS 200.629028 EWIVERVED 212.12355 414:44333 220.97464 230.452652 2976.73999 €370:19999 3037.560059 ********** 3140.97998 230.869934 3230.780029 3225.52002 2954.219971 2584.590088 248.628799 2912.429932 234.777374 251.118286 270.382385 3044.310050 284.365601 301.303192 281.920013 331.619995 2704 100008 2704.100098 334 2784.48999 2834.399902 2945.830078 2752.060059 2941.76001 2980.379883 €300:973009 2926.459961 wwwwwwwww 3100.290039 3271.120117 3500.310059 3363 3269.959961 Exercise 2 The first part of this assignment asks you to estimate the weighted average cost of capital (WACC) for Microsoft Corporation. As a starting point, use the "MSFT.xlsx" file I created (which you will find as attachment on Digiex). Assume that Microsoft's optimal debt ratio is 40%, tax rate is 30% and its cost of debt is 6%. In your calculation of the required rate of return (i.e. return on equity) using the CAPM formula, assume the risk-free rate to be 3%. 1) (10 points) Compute the annual Beta of Microsoft (use two decimals only). Use the annual log-return for your analysis. What is the interpretation of the Beta you just computed? 2) (2 points) Plot the trendline (Characteristic line) 3) (2 points) Compute the return on the market portfolio. 4) (2 points) Compute the required rate of return (i.e. log-return on equity, re). Use two decimals. 5) (4 points) Compute the WACC (round it to the closest integer). Microsoft Corporation just constructed a manufacturing plant in the Philippines. The construction costs 6 billion Philippine pesos (PHP). Microsoft intends to leave the plant open for three years. At the end of the first year, the revenues are expected to be 5 billion pesos and the costs of 2 billion pesos. For the remaining 2 years, revenues are expected to grow at 5%, while costs at 3%. At the end of the third year, Microsoft expects to sell the plant for 1 billion pesos. Additionally, the plant has to be depreciated at 25% in year 1 and 2, and at 50% in year 3. Microsoft has a required rate of return (i.e. wacc) that you computed in (5). Assume that the tax rate in the Philippines is 35% and in the US is 30%. Lastly, inflation rates in the US and Philippines are 10% and 3%, respectively. 6) (15 points) Compute the NPV in Philippine peso by using the WACC as appropriate discount rate. Would Microsoft build the plant? 7) (10 points) Compute the NPV of the project in US dollars by using the WACC and by converting all the cash flows from Philippine peso to US dollars. The CEO expects you to use an internal model that offers better estimates of future spot exchange rates compared to the PPP. This model forecasts that the peso is expected to depreciate by 15 percent per year. Currently, it takes 8,700 Philippine pesos to buy 1 US dollar. Would Microsoft build the plant? 8) (8 points) Re-do the analysis of the previous task, but using the PPP to estimate future spot exchange rates. Are the two NPVs different or the same? Why? Explain. 9) (7points)Compute theNPV of the project in US dollars by converting the NPV in Philippine pesos into US dollars using the current spot exchange rate. Compare the NPV you get in this task with the ones computed in the two previous tasks. 10) (10 points) Determine the APV of the project in US dollars considering an all-equity required rate of return, Ku, for Microsoft of 10%. Use the internal model to estimate future spot exchange rates. Would the decision of Microsoft change? 34 35 36 37 38 39 40 40 A₁ 41 42 43 43 44 45 46 47 48 49 50 51 52 53 SA 54 EE 55 56 57 58 59 60 61 62 A 01/08/19 01/09/19 01/10/19 01/11/19 01/12/19 01/01/20 01/02/20 01/02/20 01/02/20 01/03/20 01/04/20 01/04/20 01/05/20 01/06/20 01/07/20 01/08/20 01/09/20 01/10/20 CATATAN 01/11/20 et habe 01/12/20 01/01/21 6103.61 01/02/21 ***** 01/03/21 men 01/04/21 01/05/21 01/06/21 01/07/21 01/08/21 01/09/21 01/10/21 01/11/21 B 134.620514 2816.290039 136.215118 140.467209 2901.52002 2913.97998 148.315048 2711.73999 155.032852 2760.169922 2506.850098 167.350937 $50 360058 159.269958 155.466187 176.660278 180.642792 201.173248 202.656052 222.940445 222:340443 208.417557 EVONATOS 200.629028 EWIVERVED 212.12355 414:44333 220.97464 230.452652 2976.73999 €370:19999 3037.560059 ********** 3140.97998 230.869934 3230.780029 3225.52002 2954.219971 2584.590088 248.628799 2912.429932 234.777374 251.118286 270.382385 3044.310050 284.365601 301.303192 281.920013 331.619995 2704 100008 2704.100098 334 2784.48999 2834.399902 2945.830078 2752.060059 2941.76001 2980.379883 €300:973009 2926.459961 wwwwwwwww 3100.290039 3271.120117 3500.310059 3363 3269.959961 Exercise 2 The first part of this assignment asks you to estimate the weighted average cost of capital (WACC) for Microsoft Corporation. As a starting point, use the "MSFT.xlsx" file I created (which you will find as attachment on Digiex). Assume that Microsoft's optimal debt ratio is 40%, tax rate is 30% and its cost of debt is 6%. In your calculation of the required rate of return (i.e. return on equity) using the CAPM formula, assume the risk-free rate to be 3%. 1) (10 points) Compute the annual Beta of Microsoft (use two decimals only). Use the annual log-return for your analysis. What is the interpretation of the Beta you just computed? 2) (2 points) Plot the trendline (Characteristic line) 3) (2 points) Compute the return on the market portfolio. 4) (2 points) Compute the required rate of return (i.e. log-return on equity, re). Use two decimals. 5) (4 points) Compute the WACC (round it to the closest integer). Microsoft Corporation just constructed a manufacturing plant in the Philippines. The construction costs 6 billion Philippine pesos (PHP). Microsoft intends to leave the plant open for three years. At the end of the first year, the revenues are expected to be 5 billion pesos and the costs of 2 billion pesos. For the remaining 2 years, revenues are expected to grow at 5%, while costs at 3%. At the end of the third year, Microsoft expects to sell the plant for 1 billion pesos. Additionally, the plant has to be depreciated at 25% in year 1 and 2, and at 50% in year 3. Microsoft has a required rate of return (i.e. wacc) that you computed in (5). Assume that the tax rate in the Philippines is 35% and in the US is 30%. Lastly, inflation rates in the US and Philippines are 10% and 3%, respectively. 6) (15 points) Compute the NPV in Philippine peso by using the WACC as appropriate discount rate. Would Microsoft build the plant? 7) (10 points) Compute the NPV of the project in US dollars by using the WACC and by converting all the cash flows from Philippine peso to US dollars. The CEO expects you to use an internal model that offers better estimates of future spot exchange rates compared to the PPP. This model forecasts that the peso is expected to depreciate by 15 percent per year. Currently, it takes 8,700 Philippine pesos to buy 1 US dollar. Would Microsoft build the plant? 8) (8 points) Re-do the analysis of the previous task, but using the PPP to estimate future spot exchange rates. Are the two NPVs different or the same? Why? Explain. 9) (7points)Compute theNPV of the project in US dollars by converting the NPV in Philippine pesos into US dollars using the current spot exchange rate. Compare the NPV you get in this task with the ones computed in the two previous tasks. 10) (10 points) Determine the APV of the project in US dollars considering an all-equity required rate of return, Ku, for Microsoft of 10%. Use the internal model to estimate future spot exchange rates. Would the decision of Microsoft change?
Expert Answer:
Answer rating: 100% (QA)
Answer 1 The annual Beta of Microsoft Corporation is 084 Beta is a measure of a stocks volatility re... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 A 4) a) b) c) d) B D E F G Billy Bob would like to purchase a new truck. The salesman has given BB 2 options for financing his...
-
? ????????? 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 50 Use your 44 use is 45 46 47 48 49 Made sales of product Cost for the inventory that was sold Amount of the invoice (above) that returns and...
-
A questionnaire provides 58 Yes, 42 No, and 20 no-opinion answers. a. In the construction of a pie chart, how many degrees would be in the section of the pie showing the Yes answers? b. How many...
-
As mentioned in Section 5.6, Sainte-Venants principle will allow particular boundary conditions to be replaced by their statically equivalent resultant. For problems (b), (c), (d),and (f) in Exercise...
-
The National Safety Council reported that 52% of American turnpike drivers are men. A sample of 300 cars traveling southbound on the New Jersey Turnpike yesterday revealed that 170 were driven by...
-
If 60 C of charge pass through an electric conductor in 30 seconds, determine the current in the conductor.
-
Jupiter's is considering an investment in time and administrative expense on an effort that promises one large payoff in the future, followed by additional expenses over a 10-year horizon. The cash...
-
Clark Kent, Inc., buys crypton for $0.80 a gallon. At the end of processing in Dept. 1, crypton splits off into products A, B, and C. Product A is sold at the split-off point with no further...
-
Assess any asymmetric information issues that the apple experienced during the previous five years. What were the adverse selection and the moral hazard problems that the company encountered?
-
When an investor uses the equity method to account for investments in common stock, the investors share of cash dividends from the investee should be recorded as a. A deduction from the investors...
-
Part of the information released in the Employment Situation Summary concerns how long individuals have been unemployed. Go to www.bls.gov to find the latest report. Use the same technique as in...
-
A balanced die is rolled 180 times. Let be the number of cases when die shows the number 4 on its top face. (a) Find #x (b) Find o (c) Use normal approximation to binomial to approximate P(35 x 40).
-
Ms. Moth dies on February 1, 2024. All of her income is from employment activities and she does not have a spouse or common-law partner. What is the latest date for filing her 2023 income tax return...
-
Let x, J, J, J IR 21 a) Prove that x (J (U U )) = (x J ) - ( 3) J3 U3 Hint: Use cofactor development arguments b) Prove that: (x x J) (J x Js) = det J X X. J J J 1
-
Communities at the margin, minority groups, underserved areas and other groups as integral parts of any city and place of residence should be benefactors of development activities and aspirations...
-
Suppose the following is a possible distribution of the number of crashes a driver will have over the course of their lifetime. X P(X = x) 0 0.01 1 2 (b) Find P(X < ) or P(X> ). P(x < )= P(x > )=...
-
How many units of Product Excellence would have to be sold in October 2021 in order to generate an net income after tax of P22,500? * Nat NUBD reported the following results from sales of 5,000 units...
-
What are some of the various ways to implement an awareness program?
-
Carry out a one-way analysis of variance on the data shown above. Follow these steps: 1. Present the null and alternative hypotheses. 2. Calculate df between 3. Calculate df within 4. Identify the...
-
The national norms for youth fitness tests are available on a website, http://www.exrx.net/Testing/YouthNorms.html. Lets say that a physical education teacher wants to test null hypotheses related to...
-
Which of the following would be considered hypothetical populations? a. Persons who received a flu shot at a local hospital last October b. Married couples who will still be married to each other in...
-
Management is considering three alternatives to satisfy an urgent need. Each of the alternatives will completely satisfy the need, so no combinations have to be considered. The first costs, operating...
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/year. a. Determine the MIRR for this project. b. Is this project economically attractive?...
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/ year. a. Determine the MIRR for this project. b. Is this project economically...
Study smarter with the SolutionInn App