Use Excel work sheet to build two Mortgage Amortization Tables Itentructions: 1 Open the "Mortgage Project" Excol fite. In the "Student ID" worksheet, please put in your First and Last Name, Student iD (9-digit number) and CRN. 2. Check the "Loan intormation" worksheat, you will find your unique loan information. You can build your mortgage amorizabors table using the information provided 3 Creale a new worksheet "Original Loan Amortization Table". Use the "Loan Amount", "Original Interest Rate" and "Loan Term" to bulid a morigage amorization table (from Month 1-300) like shown below. 4. Assume aner X months (given in the information sheet), interest rates drop, you can get a better loan rate to refinance your loan Your fiew loain amount should equal to your original loan's remaining balance after X months of payments. Create another woikstioet Refinance Loan Amortization Table'. Use the 'New Loan Amount' (from your first amortization table). 'Refinance Lown interest Rate (APR)' and 'Now Loan Term" to build a mortgage amortization table (from Month 1-360) like shown below 5. Click on "Mortgage and Retinance Project' and submit your Excel file. (55\% of project grade) Example: Mortgage Amortization Table