must be done in excel

Problem 3. Company X wishes to borrow U.S. dollars at a fixed rate of interest. Company Y wishes to borrow Japanese yen at a fixed rate of interest. The amounts required by the two companies are roughly the same at the current exchange rate. The companies have been quoted the following interest rates, which have been adjusted for the impact of taxes: Company X Company Y Yen 4.8% 5.6% Dollars 7.4% 8.2% Design a swap that will net a bank, acting as intermediary, 30 basis points per annum. Make the swap equally attractive to the two companies and ensure that all foreign exchange risk is assumed by the bank