Finance help please with assignment. Please do in excel file.

Homework 3 Q1. The 6-month, 12-month, 18-month, and 24-month interest rates are 1.50%, 1.75%, 2.00%, and 2.25% with continuous compounding. a. Calculate the present value of $100 in 1.5 years (=18 months). b. Calculate are the equivalent 6-month, 12-month, 18-month, 24-month interest rates with quarterly compounding. c. Calculate the 6-month forward rate between 1.5 years (=18 months) and 2 years (=24 months). Answer the forward rate with continuous compounding. Q2. A short 18-month forward contract on a non-dividend-paying stock was entered into a year ago. The delivery price of the contract is $48. Today, this contract has 6 months to maturity. The risk-free rate with continuous compounding is 2% per annum, the current stock price is $51. Calculate the value of this short forward contract. Hint: value of short forward contract = value of long forward contract * -1 Q3. Suppose a bank needs to borrow (not lend) $20 million for 3 months starting in March 2016. Unfortunately, this position is risky because nobody knows what the interest rates will be next year. The bank wants to lock in this March 2016 3-m interest rate today. a. Devise a plan to lock in the borrowing rate today. Be specific about which futures contract how many contracts futures expiration month whether to take a long or short position of the contract b. Find the 3-m interest rate that the bank can lock in today from www.cmegroup.com Answer the actual interest rate in percentage per annum. Include the screenshot of the source. c. Suppose you are a speculator (not the bank above) and you are certain the interest rate will increase next year. What action should you take today to capitalize your prediction? Q4. Suppose a bank has unmatched asset and liability. Specifically, the bank has fixed rate loans as assets (receiving fixed rate mortgage interests) but has floating rate deposits as liability (paying floating rate interests). This is a risk to the bank because it can suffer a loss, if the floating rate increases over time. What can the bank do with interest rate swaps to eliminate this risk? Be specific