The calculations have to be using Excel.

1)You are looking at five different banks offering the following rates: (make sure you show at least 2 decimal places in your answers)

Bank 1. 8% with semiannual compounding

Bank 2. 7.91% with monthly compounding

Bank 3. 7.89% with continuous compounding

a. Which bank would you borrow from and why?

b. Which bank would you invest in and why?

2)You owe $63,000 at 4.8%. You decided to pay off the loan over 10 years of monthly payments.

a. What is the size of your monthly payments?

b. What is the interest portion of your 70th payment?

c. What is the principle portion of your 50^th payment?

d. What will your outstanding balance be after 7 years?

BONUS QUESTION:

Referring to problem 1: What APR rate does bank 1 have to offer you so you would be indifferent between bank 1 and bank 2? (Use two decimal places for your rates) You can use solver or trial and error.