A 5-year of $50,000,000 was made to a Borrower at an annual rate of 5.5% payable monthly based on a 30-year repayment. The loan documents stipulate that the Borrower can repay the loan at any time subsequent to the first 24 months after it was funded, in whole, and only if accompanied by the appropriate prepayment premium (no partial prepayments). The prepayment premiums are as follows: 5% of the O/S loan amount between the months of 25-36 4% of the O/S loan amount between the months of 37-48 3% of the O/S loan amount between the months of 49-57 No premium due during the last three months. Solve and answer the following questions: The borrower wishes to prepay the loan one and half years after the loan was funded. What is the amount due? The borrower wishes to prepay the loan after month 41. What is the amount due? The borrower wishes to prepay the loan 60 days prior to its maturity. What is the amount due?

Please do this in Excel sheet and show the formula and steps .... please