Math 4065 Excel Project 1 Template A Amortization Method Period 0 1 2 3 4 5 6 7

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.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"