Can someone show me the formulas needed?

For this homework assignment, you will need to create a loan amortization table in Excel and upload it to Canvas. It should include inputs for an annual rate, payment frequency, the number of years for the loan, and the principal amount. The amortization table should include a table of 360 payments and have monthly values for the payment, portion of the payment for principal and the portion for interest, and the ending balance.

The first several rows should include your name (Last, First), course, date, and the name of the assignment. The formulas used should be a combination of absolute and relative references where applicable. All dollar values in this table should be rounded to two decimal places with a dollar sign in the cell. All percentages should be shown to three places after the decimal point when in percentage form (eg. 6.175%). You can select your own inputsI will update them when grading

To be clear, there should only be four inputs in the spreadsheet. All of the remaining cells with either identify a column/row or will be a formula. In absolutely no case should a number be used in a calculation in the amortization table. For example, to calculate the payment you would reference the cell containing the payment frequency and never simply divide by 12 for monthly payments. All font should be Times New Roman, all cells should have visible values when opened, and it should not be more than one page wide when printedit should not be one page tall. An example of the Excel format is shown below. You should upload the file as 4243_HW_loanamortization_lastname_firstname. Name Course Last Name, First Name FIN 4243 Date Loan Amortization Date HW Principal Term (Years) Rate (APR) Frequency Input Input (number of years) Input (rate per year) Input (# of months in a year) Month Payment 1 formula 2 Principal formula Interest Ending Balance formula formula 3 To be clear, there should only be four inputs in the spreadsheet. All of the remaining cells with either identify a column/row or will be a formula. In absolutely no case should a number be used in a calculation in the amortization table. For example, to calculate the payment you would reference the cell containing the payment frequency and never simply divide by 12 for monthly payments. All font should be Times New Roman, all cells should have visible values when opened, and it should not be more than one page wide when printedit should not be one page tall. An example of the Excel format is shown below. You should upload the file as 4243_HW_loanamortization_lastname_firstname. Name Course Last Name, First Name FIN 4243 Date Loan Amortization Date HW Principal Term (Years) Rate (APR) Frequency Input Input (number of years) Input (rate per year) Input (# of months in a year) Month Payment 1 formula 2 Principal formula Interest Ending Balance formula formula 3