Question

In: Finance

Microsoft is evaluating a potential investment in a new datacenter facility located in Europe. The initial...

  • Microsoft is evaluating a potential investment in a new datacenter facility located in Europe. The initial capital investment in this facility is $10 million with an expected useful life of 5 years.
  • The datacenter is to be depreciated to the book value of $0 over the 5 years and it is expected to be sold for $2 million at the end of project.
  • Microsoft has already is commissioned a consultant firm in order to perform a technical due diligence of the facility. The service fee paid amount is $500000.
  • The gross revenue the Microsoft is planning to generate with the new facility will be $2.8 million per year for the 5 year (starting of the end of year1).
  • The annual variable cost for the datacenter will be 25% of gross revenue for every year.
  • The project requires $500000 of working capital immediately but it will not require any other working capital investment during its life. The working capital will be recovered in the last year of the project.
  • The corporate rate tax is 30% and Microsoft has a weighted average cost of capital of 15%.
  • Microsoft is planning to finance this project using the higher proportion of debt than the one used to finance the company as whole.
  1. Calculate free cash flow for every year and net present value (NPV). Show calculation Should Microsoft under take this project based on your analysis? Explain why or why not?
  2. The Microsoft Company will be financing the project using higher proportion of debt than the one used to finance the company as a whole. What risk is Microsoft incurring by using the company’s WACC as a discount rate? What would happen to WACC and NPV of the project in the case Microsoft would be using the appropriate discount rate?
  3. Under what condition WACC can be used as a discount rate for the cash flow of a specific project?

Solutions

Expert Solution

Given :
Capital Investment $        10,000,000
Useful life in years                              5
SL Depreciation per year              2,000,000
Income Tax rate 30%
Salvage value $          2,000,000
Tax on Capital gain on salvage value                  600,000
Annual Tax shield on Depreciation=$2M*30%=                  600,000
We are ignoring the cost of technical due
diligence for capital project evaluation as it
is a sunk cost.
WACC of Capital 15%
Additional investment in WC $             500,000
After Tax EBIT per year
Annual Revenue $          2,800,000
Annual variable cost @25% $             700,000
Earning Before Tax $          2,100,000
Tax 30% $             630,000
After Tax Income per year $          1,470,000
NPV Calculation
Details Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Initial Investment
Capital Investment $      (10,000,000)
Investment in WC $            (500,000)
a Total Initial Outlay $      (10,500,000)
Cash flow from Operations :
After Tax Operating income $         1,470,000 $           1,470,000 $      1,470,000 $        1,470,000 $       1,470,000
Add: Depreciation Tax Shield $            600,000 $              600,000 $         600,000 $            600,000 $          600,000
b Total Cash flow from oeprations $         2,070,000 $           2,070,000 $      2,070,000 $        2,070,000 $       2,070,000
Terminal Cash flow
Salvage value of Investment $       2,000,000
Less Tax on Capital gain on salvage $         (600,000)
Return of NWC $          500,000
c Total Terminal Cash Flow           1,900,000
d Free Cash Flow from Project=a+b+c= $      (10,500,000) $         2,070,000 $           2,070,000 $      2,070,000 $        2,070,000 $       3,970,000
e PV factor @15%=1/1.15^n=                    1.0000                  0.8696                    0.7561                0.6575                  0.5718                 0.4972
f PV of Free Cash flows =d*e $      (10,500,000) $         1,800,072 $           1,565,127 $      1,361,025 $        1,183,626 $       1,973,884
g NPV=Sum of PV of Free Cash flows $        (2,616,266)
Ans .
As the NPV of the Project is negative , Microsoft should not accept the project.
Ans 2.
As Microsoft is planning to use a higher proportion of Debt than the usual capital structure for financing this project, the WACC of the
capital to be used for funding the project will be different from 15%. Use of higher debt generally reduces the WACC unless the high geraing
increases the cost of equity more than before. The WACC of the fund to be used for this project will also depend on the specific business risk
of the project. Microsoft will face the risk that if the effective WACC of the Project is lower than 15% as used in evaluation, then it may
wrongly turn the NPV negative, when the NPV should be positive due due a lower WACC. So Microsoft bears the risk of rejecting a profitable
investment if it uses a wrong WACC as discount factor.
Ans 3.
WACC can be used as the discount factor for the cash flows of a project when the marginal cost of the capital invested for the project
consdiers the project specific business risks and capital structure related financial risks and the risk adjusted cost of capital absorbs all
risks pertaining to the specific project. I such a case the WACC will be useful for discounting the Cash flows of the project.

Related Solutions

Microsoft is evaluating a potential investment in a new datacenter facility located in Europe. The initial...
Microsoft is evaluating a potential investment in a new datacenter facility located in Europe. The initial capital investment in this facility is $10 million with an expected useful life of 5 years. The datacenter is to be depreciated to the book value of $0 over the 5 years and it is expected to be sold for $2 million at the end of project. Microsoft has already is commissioned a consultant firm in order to perform a technical due diligence of...
A firm is evaluating the purchase of new machinery that requires an initial investment of $10,000....
A firm is evaluating the purchase of new machinery that requires an initial investment of $10,000. The cash flows that will result from this investment are presently valued at $11,500. The net present value of the investment is: A. $0 B. –$1,500 C. $1,500 D. $10,000 E. $11,500 Armstrong Bolts, Inc. is considering the purchase of a new machine that will cost $69.500 with installation. If Armstrong expects the cash inflows to zero in the first year and then $21,500...
Moe’s Tablet Warehouse is evaluating two potential projects. Project A has an initial investment of $800...
Moe’s Tablet Warehouse is evaluating two potential projects. Project A has an initial investment of $800 and yearly cash flows of $500, $600, and $700. Project B has an initial investment of $500 and yearly cash flows of $300, $400, and $500. Moe’s has a rate of return of 8%. Which project has the greater profitability index and what is its PI? Group of answer choices Project A. Its PI is 0.916. Project B. Its PI is 0.823. Project A....
Gaewelyn is considering opening a new business for a long-term care facility. The initial investment for...
Gaewelyn is considering opening a new business for a long-term care facility. The initial investment for the business is $650,000, which includes constructing the housing unit and purchasing other assets. For tax purposes, the projected salvage value of all the assets is $64,000. The government requires depreciating the assets using the straight-line method over the business’s life of 15 years. Gaewelyn is trying to estimate the net cashflows after tax for this business. She has already figured out that the...
CSC is evaluating a new project to produce encapsulators. The initial investment in plant and equipment...
CSC is evaluating a new project to produce encapsulators. The initial investment in plant and equipment is $500,000. Sales of encapsulators in year 1 are forecasted at $200,000 and costs at $100,000. Both are expected to increase by 10% a year in line with inflation. Profits are taxed at 35%. Working capital in each year consists of inventories of raw materials and is forecasted at 20% of sales in the following year. The project will last five years and the...
3M is evaluating a new type of adhesive. The initial investment required is $1,312 million. The...
3M is evaluating a new type of adhesive. The initial investment required is $1,312 million. The company expects to sell 63 million units every year forever, at a net cash flow of $2.83 per unit. Investments with similar risk deliver a rate of return of 14%. a. What is the NPV of the project (in $ million)? b. In fact, there is a 50% chance that annual sales will hit 94.5 million units and a 50% chance that they will...
Firm is evaluating the following project to install a new production facility. The production facility requires...
Firm is evaluating the following project to install a new production facility. The production facility requires an investment in a machine costing 25,000 USD. The machine will be fully depreciated according to the straight-line method. The life of the project is estimated to be 4 years. When the project is over, although the book value of the machine is 0, you expect to sell the machine at a market value of 1,000 USD. The project also requires working capital in...
Le Pew cosmetics is evaluating a new fragrance mixing machine. The machine requires an initial investment...
Le Pew cosmetics is evaluating a new fragrance mixing machine. The machine requires an initial investment of $360,000 and will generate after tax cash flows of $62,650 per year for 8 years. For each of the capital listed, 1) calculate net present value (NPV) 2) indicate whether to accept or reject the machine and why. a)cost of capital is 6% b)cost of capital is 8% c)cost of capital is 10%
Blur Corp. is looking at investing in a production facility that will require an initial investment...
Blur Corp. is looking at investing in a production facility that will require an initial investment of $500,000. The facility will have a three-year useful life, and it will not have any salvage value at the end of the project’s life. If demand is strong, the facility will be able to generate annual cash flows of $265,000, but if demand turns out to be weak, the facility will generate annual cash flows of only $120,000. Blur Corp. thinks that there...
Dernham Inc. is looking at investing in a production facility that will require an initial investment...
Dernham Inc. is looking at investing in a production facility that will require an initial investment of $500,000. The facility will have a three-year useful life, and it will not have any salvage value at the end of the project’s life. If demand is strong, the facility will be able to generate annual cash flows of $260,000, but if demand turns out to be weak, the facility will generate annual cash flows of only $135,000. Dernham Inc. thinks that there...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT