Math 4065 Excel Project #3: Loans 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. 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%. b. 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%. c. All projects must be submitted using the template posted on Moodle (Excel_3_Template.xls). You may work in groups, but your final submission must be your own work. Submit projects on Moodle by 11/1