Please show your work so I can follow and understand how this was solved. Thank you!

It is Sunday afternoon, Feb 14, 2021. You, Assistant Treasurer, are thinking about how to hedge against foreign exchange fluctuations.

You have two things to take care of: Dividend & upcoming payment.

• Dividend is due on September 15th, 2021. The dividend is from your subsidiary company in Germany. The amount is 3,000,000, considered as receivables.
• Upcoming payment to your supplier in Japan. The current trend is that Yen is around $78 and increasing. The price per unit is 8,000. And, you agreed to buy 300,000 units. The payment is due on June 10th, 2021.
• When your company borrow in the EURO currency, it typically borrows at LIBOR + 1%
• When your company lend in the EURO currency, it typically lends at LIBID
• Use the following tables to assess alternative ways of hedging.

EURO receivable (Dividend) in 214 days:

1. How much do you have in Accounts Receivable and Accounts Payable?
2. What is the spot rate?
3. What is the forward exchange rate?
4. What is the USD interest rate: Bid & Ask?