Create an Excel file for the amortization schedule for a 30-year fixed-rate Mortgage loan

read carefully “Guidelines for Excel Project – FIN3403 – Summer B 2024.pdf” inside the above-mentioned page.

Third, download and study carefully the excel file “FIN 3403 – Demo – Amortization Schedule of 15-year Fixed Rate Loan – Dr. Wei Guan.xlsx” inside the above-mentioned page.

For this project, you are not asked to create a new excel file from the scratch. Instead, you only need to modify and expand this downloaded Excel file (for a 15-year loan) to make it work for the required Excel project (for a 30-year loan). The purpose of this Excel project is for you to learn and fully understand this practical tool, so that you can take it with you to manage your own home loans or auto loans in the future. Good luck and best wishes!Students are required in a group of students assigned randomly by the instructor