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

Free

50.1K

Verified Solution

Question

Finance

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

Question: In pesos, what is the NPV of theMegaWash expansion?

Answer & Explanation Solved by verified expert
3.7 Ratings (567 Votes)

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

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

NPV can be calculated using the same function in excel or calculator given the above cash flows with 15% discount rate.


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students