Details You must create, from scratch, an amortization table. DO NOT use a spreadsheet created by someone else - you wall lase at least 50k on your grade. The loan term is 30 years and payments are made monthly. The loan amount is equal to your Student ID (The 6 numbers, not your NetiD with the letters). For example, if your student iD is 619577 , then your ioan amount is $619.577 The interest rate is the last 3 digits of your Student ID times 0.01%. For example, if your student ID is 619577 , then your interest rate would be 577.01% * 5.779 The amortization table should have beginning balance, payment, interest, principal and ending balance for all 360 periods and should be formula driven and use cell references. Besides your inputs (loan amount, interest rate, number of periods), nothing else should be a number typed in. Upload your spreadsheet in Canvas when done. It must be an Excel file (not a google sheet). Details You must create, from scratch, an amortization table. DO NOT use a spreadsheet created by someone else - you wall lase at least 50k on your grade. The loan term is 30 years and payments are made monthly. The loan amount is equal to your Student ID (The 6 numbers, not your NetiD with the letters). For example, if your student iD is 619577 , then your ioan amount is $619.577 The interest rate is the last 3 digits of your Student ID times 0.01%. For example, if your student ID is 619577 , then your interest rate would be 577.01% * 5.779 The amortization table should have beginning balance, payment, interest, principal and ending balance for all 360 periods and should be formula driven and use cell references. Besides your inputs (loan amount, interest rate, number of periods), nothing else should be a number typed in. Upload your spreadsheet in Canvas when done. It must be an Excel file (not a google sheet)