Swaps calculation question, answered with excel. Please provide a link or document to access it, screenshots of the excel file don't work unless the Equations applied are detailed. Thanks,

6. Consider a Mexican company that has a debt of 100,000 dollars at a LIBOR rate +1.60%, for a term of 140 days (5 periods of 28 days), with which it faces risks of an increase in the rate and in the type of change. To avoid them, go to the Bank "BNK" to quote a currency swap, to change the LIBOR rate for a fixed rate in pesos, based on the following market information: rate timespan LIBOR (%) TIIE (%) (days) 28 1.2 6.4 56 1.3 6.7 84 1.35 6.85 112 1.38 7.10 140 1.40 7.50 The spot exchange rate is 21 pesos per dollar and the rate spread is .1244%. Calculate the fixed rate in pesos and the corresponding monthly amount that the company would have to pay to change the debt agreed in dollars to a debt in pesos. Consider 360 days in the year. Calculate the net cash flows from the point of view of the company that is the one that would pay the flows at a fixed rate. + 6. Consider a Mexican company that has a debt of 100,000 dollars at a LIBOR rate +1.60%, for a term of 140 days (5 periods of 28 days), with which it faces risks of an increase in the rate and in the type of change. To avoid them, go to the Bank "BNK" to quote a currency swap, to change the LIBOR rate for a fixed rate in pesos, based on the following market information: rate timespan LIBOR (%) TIIE (%) (days) 28 1.2 6.4 56 1.3 6.7 84 1.35 6.85 112 1.38 7.10 140 1.40 7.50 The spot exchange rate is 21 pesos per dollar and the rate spread is .1244%. Calculate the fixed rate in pesos and the corresponding monthly amount that the company would have to pay to change the debt agreed in dollars to a debt in pesos. Consider 360 days in the year. Calculate the net cash flows from the point of view of the company that is the one that would pay the flows at a fixed rate. +