Please submit your solution in an Excel le via Canvas by Monday, June 8th, 2020 before 11pm. The Mexican government has invited Lamps Point Lighting to open a manufacturing plant so that bulbs can be produced and sold in Mexico. If the company makes the investment, it will operate the plant for 5 years and then sell the business and equipment to Mexican investors at a price equal to the book value at the time of sale. The company will be allowed to repatriate all cash to the United States each year, except for a 10% withholding tax. The initial investment would consist of MXP15,000,000 in building and equipment and another MXP15,000,000 in net working capital. The subsidiary will borrow MXP10,000,000 to cover part of the net working capital in Mexico. The loan has a 5% annual interest rate and the principal has to be repaid at the end of 5 years. The building and equipment will be depreciated over 10 years on a straight-line basis. At the end of the 5th year, the net working capital will be liquidated and the proceeds will also be repatriated to the US. The subsidiary estimates to sell 24,000 sets of low-density light bulbs per year in Mexico for the next 5 years. Locally manufactured bulbs will be sold for MXP1,000 per set in the rst year, and then the price will increase each year with the ination rate. The market for this type of bulb in Mexico is stable, neither growing nor shrinking, and the subsidiary will hold the major portion of the market. Materials purchased in Mexico will have a cost of MXP300 per set, and xed costs are MXP2,400,000. All costs will increase yearly with the ination rate. The current exchange rate is USD0.056/MXP. The ination rate is expected to be 3.2% in Mexico and 1.5% in US over the next year; both values are expected to be stable over time. Lamps Point Lighting uses the same discount rate to evaluate all domestic and foreign projects. In US, the company nances its operations with 40% equity and the remainder with debt. It borrows its funds from a U.S. bank at an interest rate of 9% per year. The long-term risk-free rate in the U.S. is 6%. The stock market return in the U.S. is expected to be 13% annually. Lamps Point Lightings stock price typically moves in the same direction and by the same degree as the U.S. stock market. The corporate income tax is 40% in both Mexico and the United States, and a tax treaty is enforced between the two countries such that double taxation is avoided. Should Lamps Point Lighting accept to open a subsidiary in Mexico?