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.