Math 4065 Excel project #1 template a) Amortization method Period 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30...

Using the template, fill out an amortization schedule/sinking fund schedule for the following:

A $100,000 loan with level payments made at the end of each year for 30-years.  Assume an annual effective interest rate on the loan of 5% and that the loan is repaid with the amortization method.A $100,000 loan with level payments made at the end of each year for 30-years.  Assume an annual effective interest rate on the loan of 5% and that the loan is repaid with the sinking fund method.  Assume the sinking fund earns an annual effective rate of 5%.A $100,000 loan with level payments made at the end of each year for 30-years.  Assume an annual effective interest rate on the loan of 5% and that the loan is repaid with the sinking fund method.  Assume the sinking fund earns an annual effective rate of 10%.

All projects must be submitted using the template posted on Moodle (Excel Project 1 Template.xls).  You may work in groups, but your final submission must be your own work.