Question 1
Delta Company, a U.S. MNC is contemplating making a foreign capital expenditure in Mexico. The initial cost of the project is MP 28,000. The annual cash flows over the five-year economic life of the project in MP are estimated to be 5,000, 6,000, 8,000, 9,000 and 9,800. The parent company’s cost of capital is dollars is 6.5%. Long-run inflation is forecasted to be 3% per annum in the U.S. and 4.5% in Mexico. The current spot rate is MP/USD = 19.45. Determine the following things:
Year 0: MP/USD = 19.45
Year 1 : MP/USD = 21.20
Year 2 : MP/USD = 22.15
Year 3 : MP/USD = 23.63
Year 4 : MP/USD = 24.32
Year 5 : MP/USD = 25.19
a. As per fisher effect, MP equivalent cost of capital = (1+US cost of capital)*(1+Mexico inflation rate)/(1+US inflation rate)
= (1+6.5%)*(1+4.5%)/(1+3%)
= 8.051%
Using the above cost of capital, calculating PV for all years using the formula PV = FV/(1+R%)^N
| Year | Cashflows | PV of cash flows (at MP cost of capital) | PV of cash flows (at MP cost of capital) converted to USD at spot rate (A) | PV of cashflows with PPP EXCHANGE RATES (B) | PV of cashflows at provided rates (D) |
| Year 0 | -28000 | -28000 | -1439.588689 | -1439.588689 | -1439.588689 |
| Year 1 | 5000 | 4627.445695 | 237.9149458 | 237.9149458 | 221.4545132 |
| Year 2 | 6000 | 5139.180878 | 264.225238 | 264.225238 | 238.8241849 |
| Year 3 | 8000 | 6341.674781 | 326.0501173 | 326.0501173 | 280.2705347 |
| Year 4 | 9000 | 6602.795025 | 339.4753226 | 339.4753226 | 287.6606833 |
| Year 5 | 9800 | 6653.998645 | 342.1078995 | 342.1078995 | 283.9552282 |
| NPV(MP) | 1365.095025 | ||||
| NPV(USD) | 70.18483417 | 70.18483417 | -127.4235446 | ||
So NPV(MP) = 1365.095
Converting this to USD at spot rate, NPV = $70.185
(b) CALCULATION of purchasing power parity exchange rates
Puchasing power parity exchange rate (MP/USD) = spot rate *[(1+ Mexico inflation rate)/(1+ US inflation rate)]^t
Calculating for all years, below are the PPP exchange rates
| MP/USD (1) | 19.73325243 |
| MP/USD (2) | 20.02062989 |
| MP/USD (3) | 20.31219246 |
| MP/USD (4) | 20.60800109 |
| MP/USD (5) | 20.90811761 |
Using the above rates, if you calculate the PV of cash flows in USD,
| Year | Cashflows | PV of cashflows with PPP EXCHANGE RATES |
| Year 0 | -28000 | -1439.588689 |
| Year 1 | 5000 | 237.9149458 |
| Year 2 | 6000 | 264.225238 |
| Year 3 | 8000 | 326.0501173 |
| Year 4 | 9000 | 339.4753226 |
| Year 5 | 9800 | 342.1078995 |
| NPV(MP) | ||
| NPV(USD) | 70.18483417 | |
(c) So both NPVs are the same. This is because of the fact that fisher effect and PPP concepts hold good and we have accounted both counties'inflation rates in the calculations.
(d)Using the PROVIDED rates, if you calculate the PV of cash flows in USD,
| Year | Cashflows | PV of cashflows at provided rates |
| Year 0 | -28000 | -1439.588689 |
| Year 1 | 5000 | 221.4545132 |
| Year 2 | 6000 | 238.8241849 |
| Year 3 | 8000 | 280.2705347 |
| Year 4 | 9000 | 287.6606833 |
| Year 5 | 9800 | 283.9552282 |
| NPV(MP) | ||
| NPV(USD) | -127.4235446 | |
NPV is negative at -$127.42, as the actual rates dont follow the PPP rates trend
Question 1 Delta Company, a U.S. MNC is contemplating making a foreign capital expenditure in Mexico....
Your company is looking at a new project in Mexico. The project will cost 900,000 pesos. The cash flows are expected to be 400,000 pesos per year for 5 years. The current spot exchange rate is 19.07 pesos per dollar. The risk-free rate in the US is 4%, and the risk-free rate in Mexico 8%. The dollar required return is 10%. What is the net present value of this investment in U.S. Dollars? PLEASE SHOW IN EXCEL
Sacramone Products Co. is a U.S.-based firm evaluating a project in Mexico. You have the following information about the project: • The project requires a 150,000 peso investment today and is expected to generate cash flows of 61,500 pesos at the end of the next three years. • The current U.S. exchange rate with the Mexican peso is 11.567 pesos per U.S. dollar, and the exchange rate is expected to remain constant. • The firm's cost of capital is 9%,...
Question 3 Financing Subsidy. Needles Corporation, a Dutch MNC, is considering a project in the United States. The initial investment is EUR 25,000. The firm raises 75 percent of this funding in the United States through its subsidiary. This funding is through a term loan at a cost of 6 percent. Needles uses a cost of capital of 12 percent to discount the cash flows of its projects in the United States. This is a four- year project with annual...
Q.1 You are planning a few trips, A.)Your company is looking at a new project in Mexico. The project will cost 1,075,000 pesos. The cash flows are expected to be 325,000 pesos per year for 5 years. The current spot exchange rate is 19.07 pesos per dollar. The risk-free rate in the US is 4%, and the risk-free rate in Mexico 8%. The dollar required return is 10%. What is the net present value of this investment in U.S. Dollars?...
please show solution through excel!
Question 5 0 / 1 point Your company is looking at a new project in Mexico. The project will cost 900,000 pesos. The cash flows are expected to be 400,000 pesos per year for 5 years. The current spot exchange rate is 19.07 pesos per dollar. The risk-free rate in the US is 4%, and the risk-free rate in Mexico 8%. The dollar required return is 10%. What is the net present value of this...
please show solution in Excel. The answer should be
24,129.
Question 5 0 / 1 point Your company is looking at a new project in Mexico. The project will cost 900,000 pesos. The cash flows are expected to be 400,000 pesos per year for 5 years. The current spot exchange rate is 19.07 pesos per dollar. The risk-free rate in the US is 4%, and the risk-free rate in Mexico 8%. The dollar required return is 10%. What is the...
1.) Roming Enterprises, a U.S- based firm, is considering a project in China to produce and sell compressors. It is a four-year project with an initial investment of USD 500,000. Each year, it would produce 800 units of the product at a direct cost of CNY 600 and sales price of CNY 2,000. Indirect expenses, not including depreciation, are expected to be CNY 120,000. Depreciation is straight line to zero. Taxes are 30 percent. Calculate USD cash flows and the...
10 points Lakonishok Equipment has an investment opportunity in Europe. The project costs €12 million and is expected to produce cash flows of €2 million in Year 1, €2.4 million in Year 2, and €3.5 million in Year 3. The current spot exchange rate is $1.35/€; and the current risk-free rate in the United States is 2.0 percent, compared to that in Europe of 2.8 percent. The appropriate discount rate for the project is estimated to be 14 percent, the...
Lakonishok Equipment has an investment opportunity in Europe. The project costs €10 million and is expected to produce cash flows of €1.1 million in Year 1, €1.5 million in Year 2, and €2.6 million in Year 3. The current spot exchange rate is $1.26 / €; and the current risk-free rate in the United States is 1.9 percent, compared to that in Europe of 1.1 percent. The appropriate discount rate for the project is estimated to be 11 percent, the...
tivity: Foreign capital budgeting a Search this cour Excel Online Structured Activity: Foreign capital budgeting Sandrine Machinery is a Swiss multinational manufacturing company. Currently, Sandrine's financial planners are considering undertaking a 1-year project in the United States. The project's expected dollar denominated cash flows consist of an initial investment of $2000 and a cash inflow the following year of $2400. Sandrine estimates that its risk-adjusted cost of capital is 13%. Currently, 1 U.S. dollar will buy 0.75 Swiss franc. In...