In January 2021, your bank intends to make a loan of $25m with interest paid quarterly based on LIBOR at the beginning of each quarter. Assume LIBOR = 5% on Jan 1^st2021; 4.85% on April 1^st 2021; 4.6% on July 1^st2021; and 5.05% on Sept 1^st2021. As an elite MSF graduate who is working in the bank, you proposed an interest rate floor instrument to curb the interest rate risk on your banks future cash flows related to the loan. The strike price of the floor instrument is 5% while the floor instrument premium is $45,000.

You need to tabulatethe cash flows associated with the loan based on the information above. (hint: assume the year has 360 days and each quarter has 90 days)