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 $2000. Sandrine estimates that is risk-adjusted cost of capital is 11%. Currently, 1 U.S. dollar will buy 07 Swiss Franc. In addition, 1-year risk-free securities in the United States are yielding 7.75%, while similar securities in Switzerland are vielding 3.5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations TH x Open spreadsheet a. If this project was instead undertaken by a similar U.S.-based company with the same risk adjusted cost of capital, what would be the niet present value and rate of return generated by this project Round your answers to two decimal places NPV- Rate of retum b. What is the expected forward exchange rate 1 year from now? Round your answer to two decimal places SF Der U.S. c. If Sandrine undertakes the project. What is the net present value and rate of return of the project for Sandrine? Do not round Intermediate calculations, Round vour answer to two decimal places Swiss France rate of retum- 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 flow consist of an initial investment of $2000 and a cash intlow the following year of $2400. Sandrine estimates that its risk-adjusted cost of capital is 11%. Currently, 1 U.S. dollar will buy 0.2 Swiss frane. In addition, 1-year risk free securities in the United States are yielding 7.25%, while similar securities in Switzerland are yielding 3.5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Do not round Intermediate calculations Open spreadsheet If this project was instead undertaken by a similar us.based company with the same risk adjusted cost of capital, what would be the net present value and rate of return generated by this project Round your answers to two decimal places. NPV- Rate of notum - b. What is the expected forward exchange rate 1 year from now Round your answer to two decimal places SF per U.S. c. If Sandrine undertakes the project, what is the not present value and rate of return of the project for Sandrine? Do not round intermediate calculations. Round your answers to two decimal places NP- Swiss Francs Foto of return $2,000 $2,400 11.00% 0.7 7.75% 3.50% Formulas #N/A #NIA 1 Foreign capital budgeting 2 3 Initial investment (U.S. Dollars) 4 Year 1 Inflow (U.S. Dollars) 5 Risk-adjusted cost of capital 6 Spot rate, Number Swiss francs per US Dollar 7 Yield, 1-yr. U.S. securities Yield, 1-yr. Swiss securities 9 10 JU.S. NPV 11 US rate of return 12 131-ye forward rate, Swiss francs per US Dollar 14 15 Initial investment (Swiss francs) 16 Year 1 Inflow (Swiss francs) 17 18 NPV (Swiss francs) 19 Swiss rate of return 20 2 22 #N/A #NIA #N/A #NIA #N/A
