I am working on a project for class. I'm stuck on "Ensure the formulas for Year 1 can be copied correctly. Then copy each formula to the subsequent rows in the table. HINT: Your formulas are correct if the ending balance for year 30 is $0. " I did follow all the steps but when it came to copy the formulas for each row, I'm getting errors and #VALUE! and "A value used in the formula is of the wrong data type." Please help. Thanks.

The steps are as follow which I followed

7. Setup an Amortization table on your worksheet similar to the one shown on the sample worksheet.

8. Enter the formulas below for the beginning balance row and year 1 row of the table.

Beginning Balance Row: Enter a formula in the Ending Balance cell to copy the Loan Amount value.

NOTE: The remaining cells on the Beginning Balance row should remain empty.

Interest Pymt for Year 1: Enter a formula to multiply the Ending Balance value on the previous row by the Annual Interest Rate value.

Principal Pymt for Year 1: Enter a formula to subtract the Annual Mortgage Payment value and the Interest Pymt value for year 1.

Ending Balance for Year 1: Enter a formula to subtract the Ending Balance value on the previous row and the Principal Pymt value for year 1.