template Soed x] Excel File Home Insert Formulas Data Review View Help Tell me what you want to do 23 Wrap Ten Merge Center - 1 Conditional Formur BIUDEE.A. $ % Format Painter Cybed 9 U10 - 1 Foreign capital budgeting 3 Investment (US Dollars) 4 Yew bow (US Dollars) 5 a ed cord of capital 6 Spotrade, Number Swiss francs per US Dollar 7 Yield 1 yr US securities 8 Yield, 17. Swiss securities 2000 2400 14 005 084 600% 300 Formas 10 US NPV 11 US rate of retum 13 1-Yr forward rate, Sviss francs per US Dollar VA BRUA 15 Intalinvestment (Swiss francs) Year 1 now (Swiss francs) 18 NPV (Swiss francs) Swade of return 9888 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 14%. Currently, I U.S. dollar will buy 0.84 Swiss franc. In addition, 1-year risk-free securities in the United States are yielding 6%, while similar securities in Switzerland are yielding 3%. 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. open spreadshee a. 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 return 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 net present value and rate of return of the project for Sandrine? Do not found intermediate calculations. Round your answers to two decimal places NPV- Swiss Frang Rate of return