1. You borrow $100,000 today and will repay the loan in equal installments at the end of the next 5 years. How much is your annual payment if the interest rate is 9.5%? Please prepare the schedule below. Please find the values in the 'green' cells using appropriate 'formula' and 'cell reference $100,000 Loan amount= Time to repay= Interest rate= 5 years Year Beg. Balance Annual Pmt Interest Pmt Principal Pmt End. Balance 1 2 9.50% TITI Annual payment 3 4 5