Question

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.71 Swiss franc. In addition, 1-year risk-free securities in the United States are yielding 7.75%, 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. 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 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 round Intermediate calculations. Round your answers to two decimal places. NPV - Swiss Francs Rate of return

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

ke - Microsoft Excel (Product Activation Failed) Add-Ins View - 2x Dr General File Home Insert Page Layout Formulas Data Review % Cut Calibri -11AA = = = Ea Copy Paste B I U B- A Format Painter Clipboard Font G4 Wrap Text Merge Merge & Center - Center m Find & SF $ -% % 4:0 .00 . Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Σ AutoSum : A Fill 2 Sort & 2 Clear Filter Editing Select Alignment Number Cells А в с Ε H I J K L 1 foreign capital budgeting 2 $ $ 2,000 2,400 13.00% 0.71 7.75% 3.00% $ 123.89 20.00% [=B4/(1+B5) -B3] [=B4/B3-1] 3 INITIAL INVESTMENT 4 YEAR 1 INFLOW 5 RISK ADJUSTED COST OF CAPITAL 6 SPOT RATE, SWISS FRANCS PER US DOLLAR 7 YIELD 1 YR US SECURITY 8 YIELD 1 YR SWISS SECURITY 9 10 US NPV 11 US RATE OF RETURN 12 13 1 YR 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 21 M Convexity DGM betaport future INDEX INTL CAP BUD Rea ferences 0.6787 [=B6*(1+B8)/(1+B7)] 1420.00 1628.88 [=B3*B6] [=B4*B13] 21.49 14.71% (=B16/(1+B5) -B15] [=B16/B15-1] H SANDRINE LEASING PV, FV, ANNUITY DIR right clean YIELD bond portfolio WACC DIV YIELD I- RESI DIV POLICY NAME BOU 120% DO 9 * 4 OENG 24-11-2019