Bob Wag is in the Market trying to get a Mortgage Loan to purchase a property at 20 Lees Flat Boulevard, Kingston 50. Bob approached two Financial Institutions NBC Bank and GHB Bank.

The Loan Manager at NBC informed Bob that he can borrows 10 million for 15 years at an interest rate of 7.75% and GHB Bank told him he could borrow the 10 million for 20 years at an interest rate of 6.5%.

Use the PMT Function to inform Bob how much he would pay monthly and annually at both Banks.