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.

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 Payment Amount Interest Paid b) Sinking fund method with 5% sinking fund rate Principal Outstanding Paid Loan Balance 0.00 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 Interest Paid Sinking Fund Deposit with 5% sinking fund rate c) Sinking fund method with 10% sinking fund rate Total Sinking Fund Net Loan payment Balance Amount 0.00 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 Interest Paid Sinking Fund Total Sinking Fund Deposit payment Balance Net Loan Amount 0.00