i - X Data Table (Click the icon 2 to import the table to a spreadsheet.) 3 Loan Principal Interest rate Maturity (years) 0 Payments 1 2 4 5 6 $220,000,000 Interest (26,954,400) (23,653,992) (19,949,218) (15,790,535) (11,122,330) (5,882,177) 12.252% Principal (26,937,709) (30,238,117) (33,942,891) (38,101,574) (42,769,779) (48,009,932) 6 Total (53,892,109) (53,892,109) (53,892,109) (53,892,109) (53,892,109) (53,892,109) Print Done Score: 0 of 10 pts 2 of 2 (0 complete) HW Score: 0%, 0 of 61 pts Problem 8-16 (algorithmic) A Question Help Falcor (US). Falcor is the U.S.-based automotive parts supplier that was spun-off from General Motors in 2000. With annual sales of over $26 billion, the company has expanded its markets far beyond traditional automobile manufacturers in the pursuit of a more diversified sales base. As part of the general diversification effort, the company wishes to diversify the currency of denomination of its debt portfolio as well. Assume Falcor enters into a $48 million 7-year cross-currency interest rate swap to do just that-pay euros and receive dollars. Using the data in this table , solve the following: a. Calculate all principal and interest payments in both currencies for the life of the swap. b. Assume that three years later Falcor decides to unwind the swap agreement. If 4-year fixed rates of interest in euros have now risen to 5.31%, 4-year fixed-rate dollars have fallen to 4.41%, and the current spot exchange rate is $1.03 / , what is the net present value of the swap agreement? Explain the payment obligations of the two parties precisely. a. Calculate all principal and interest payments in both currencies for the life of the swap. The annual cash inflow for years one through six is $ (Round to the nearest dollar.) i - X Data Table (Click the icon 2 to import the table to a spreadsheet.) 3 Loan Principal Interest rate Maturity (years) 0 Payments 1 2 4 5 6 $220,000,000 Interest (26,954,400) (23,653,992) (19,949,218) (15,790,535) (11,122,330) (5,882,177) 12.252% Principal (26,937,709) (30,238,117) (33,942,891) (38,101,574) (42,769,779) (48,009,932) 6 Total (53,892,109) (53,892,109) (53,892,109) (53,892,109) (53,892,109) (53,892,109) Print Done Score: 0 of 10 pts 2 of 2 (0 complete) HW Score: 0%, 0 of 61 pts Problem 8-16 (algorithmic) A Question Help Falcor (US). Falcor is the U.S.-based automotive parts supplier that was spun-off from General Motors in 2000. With annual sales of over $26 billion, the company has expanded its markets far beyond traditional automobile manufacturers in the pursuit of a more diversified sales base. As part of the general diversification effort, the company wishes to diversify the currency of denomination of its debt portfolio as well. Assume Falcor enters into a $48 million 7-year cross-currency interest rate swap to do just that-pay euros and receive dollars. Using the data in this table , solve the following: a. Calculate all principal and interest payments in both currencies for the life of the swap. b. Assume that three years later Falcor decides to unwind the swap agreement. If 4-year fixed rates of interest in euros have now risen to 5.31%, 4-year fixed-rate dollars have fallen to 4.41%, and the current spot exchange rate is $1.03 / , what is the net present value of the swap agreement? Explain the payment obligations of the two parties precisely. a. Calculate all principal and interest payments in both currencies for the life of the swap. The annual cash inflow for years one through six is $ (Round to the nearest dollar.)