A. Using Excel and page 534 in your textbook as a guide, develop a complete Amortization Table for the following problem.Use proper Excel cell referencing to set up your table (this will allow you to easily produce other amortization tables with differing loan amounts, payments per year, interest etc.)

A $75 000 loan is repaid with end-of-quarter payments over a period of ten years. Interest rate is 5% compounded semi-annually.

Set up your Excel spreadsheet similar to below:

CoursHeroTranscribedText