Apollo Medical Clinic has borrowed $60 million from a bank under the following terms: Payments are to be made end of every quarter for next 15 years. Interest rate is 9.00 percent compounded quarterly. After signing the loan, the firm decides to pay extra money towards the principal at the end of each year for first 5 years it is paid once a year at the end the year. The amount paid each time is $3.5 million. Prepare and show the amortization table (done best in Excel. Answer questions listed below.

1. How much interest did you pay over the term of the loan?
2. What is the outstanding balance at the end of 6^th year?
3. What is the total interest paid for the term of the loan?
4. When will the loan end? Provide year number and quarter number.