Question

In: Finance

MegaWash, Inc., is considering an expansion of their product line to Mexico. This would require a...

MegaWash, Inc., is considering an expansion of their product line to Mexico. This would require a purchase of equipment with a price of 3,000,000MXN and additional installation of 500,000MXN, to be depreciated straight-line to zero over the 5-year life of the asset. They will not be replacing any existing equipment. Their required rate of return is 15% and they are in the 35% tax bracket. The new product line is expected to increase sales by 800,000MXN per year over current levels for the next 5 years, and expenses will increase by 400,000MXN. Assume the after-tax operating cash flows in years 1-5 are equal, and the terminal value of the project in year 5 may change total after-tax cash flows for that year. The equipment is multipurpose, and the company anticipates that they will sell it at the end of the five years for 600,000MXN. The initial investment also requires an increase in Net Working Capital (NWC) of 150,000MXN (to be recovered at the sale of the equipment at the end of five years). The current spot rate is $0.75/MXN, and the expected inflation rate in the U.S. is 3% per year and 2% per year in Mexico. Please show all work.

Question: What is the NPV of the European expansion if MegaWash first computes the NPV in pesos and then converts that figure to dollars using the current spot rate?

Solutions

Expert Solution

MegaWash 0 1 2 3 4 5
USD/MXN $                 0.750 $      0.757 $      0.765 $         0.772 $      0.780 $      0.787
Investment -3,500,000
NWC -150,000 150,000
Salvage 600,000
Sales 800,000 800,000 800,000 800,000 800,000
Expenses -400,000 -400,000 -400,000 -400,000 -400,000
Depreciation -700,000 -700,000 -700,000 -700,000 -700,000
EBT -300,000 -300,000 -300,000 -300,000 -300,000
Tax (35%) 105,000 105,000 105,000 105,000 105,000
Net Income -195,000 -195,000 -195,000 -195,000 -195,000
CF (MXN) -3,650,000 505,000 505,000 505,000 505,000 1,045,000
NPV (MXN) -1,688,686
NPV (USD) -1,266,515

Cash Flows (CF) = Investment + NWC + Salvage x (1 - tax) + Net Income + Depreciation

NPV can be calculated using the same function on a financial calculator or excel with 15% discount rate.

NPV (MXN) = NPV (USD) x 0.75


Related Solutions

MegaWash, Inc., is considering an expansion of their product line to Mexico. This would require a...
MegaWash, Inc., is considering an expansion of their product line to Mexico. This would require a purchase of equipment with a price of 3,000,000MXN and additional installation of 500,000MXN, to be depreciated straight-line to zero over the 5-year life of the asset. They will not be replacing any existing equipment. Their required rate of return is 15% and they are in the 35% tax bracket. The new product line is expected to increase sales by 800,000MXN per year over current...
MegaWash, Inc., is considering an expansion of their product line to Mexico. This would require a...
MegaWash, Inc., is considering an expansion of their product line to Mexico. This would require a purchase of equipment with a price of 3,000,000MXN and additional installation of 500,000MXN, to be depreciated straight-line to zero over the 5-year life of the asset. They will not be replacing any existing equipment. Their required rate of return is 15% and they are in the 35% tax bracket. The new product line is expected to increase sales by 800,000MXN per year over current...
Management of Lakeside, Inc. is considering an investment in an expansion of the company's                product line....
Management of Lakeside, Inc. is considering an investment in an expansion of the company's                product line. The estimated investment required will be $162,500. You can assume that the full amount will be invested at the beginning of 2013. The estimated cash returns from the new product line are shown in the following table. You should assume that the returns are received at the end of each of the years indicated, and that Lakeside, Inc.’s cost of capital is 12%. Year...
Norister Inc. is considering introducing a new product line. This will require the purchase of new...
Norister Inc. is considering introducing a new product line. This will require the purchase of new fixed assets of $2.4 million. The company estimates that demand for the new product will be approximately 15,000 units per year, with a price per unit of $100. The variable cost of producing each unit of the product is $35, and fixed costs per year will be $100,000. Demand for the product will remain constant for six years, after which both demand and production...
Norister Inc. is considering introducing a new product line. This will require the purchase of new...
Norister Inc. is considering introducing a new product line. This will require the purchase of new fixed assets of $2.4 million. The company estimates that demand for the new product will be approximately 15,000 units per year, with a price per unit of $100. The variable cost of producing each unit of the product is $35, and fixed costs per year will be $100,000. Demand for the product is expected to remain constant for six years, after which both demand...
Fijisawa Inc. is considering a major expansion of its product line and has estimated the following...
Fijisawa Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion, the initial outlay would be $1,900,000 and the project would generate cash flows of $450,000 per year for six years, the appropriate discount rate is 9%. Calculate the net present value. Calculate the profitability index. Calculate the internal rate of return. Should this project be accepted? Why or why not?
Fijisawa, Inc. is considering a major expansion of its product line and has estimated the following...
Fijisawa, Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be ​$11,800,000​, and the project would generate cash flows of ​$1,300,000 per year for 20 years. The appropriate discount rate is 7.4 percent. a. Calculate the NPV. b. Calculate the PI. c. Calculate the IRR. d. Should this project be​ accepted? Why or why​ not?
Fijisawa Inc. is considering a major expansion of its product line and has estimated the following...
Fijisawa Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be ​$1,850,000 and the project would generate incremental free cash flows of ​$700,000 per year for 66 years. The appropriate required rate of return is 88 percent. a. Calculate the NPV. b. Calculate the PI. c. Calculate the IRR.
Fijisawa Inc. is considering a major expansion of its product line and has estimated the following...
Fijisawa Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be ​$1,850,000​, and the project would generate incremental free cash flows of ​$700,000 per year for 6 years. The appropriate required rate of return is 8 percent. a. Calculate the NPV. b. Calculate the PI. c. Calculate the IRR. d. Should this project be​ accepted?
Fijisawa Inc. is considering a major expansion of its product line and has estimated the following...
Fijisawa Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $2,000,000 , and the project would generate incremental free cash flows of $500,000 per year for 6 years. The appropriate required rate of return is 7 percent. a. Calculate the NPV. b. Calculate the PI. c. Calculate the IRR. d. Should this project be accepted? a. What is the project's NPV ?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT