Set up an amortization schedule for the following. You will need to compute the payment first.

B c D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Set up an amortization schedule for the following. You will need to compute the payment first. Annual Payment Amount borrowed from the bank: Annual Interest rate: Payments per year Length of loan Annual Payment Put your amortization schedule here: NOTE: Compute 2 schedule on this sheet. $60,000 6.25% 1 3 years $22,550.49 Format all amortization schedules for 2 decimals. Use appropriate formulas, functions & cell references PmtNo. 1 2 3 Payment Interest Principal Ending Balance