You are ready to start working on the Loan worksheet. Your first task is to calculate all the loan information using the Input Information in B$2$:B$6.$

Display the Loan sheet, In D$2,$ enter a formula to calculate the Amount Financed.

In D$3,$ enter a formula to calculate the Monthly Rate. Be sure to set the decimal places to $2$ places.

In D$4,$ enter a formula to calculate the Number of Periods in the Loan.

In D$5,$ enter a financial function to calculate the monthly payment. Be sure your result is positive.

In cell A$9,$ enter $1$ and use Fill Series to fill the remaining number of paryents of the Amortization Table.

In cell B$9,$ reference the $1$st Payment Date. In B$10,$ insert a Date function to add one month to the date in cell B$9.$ Format the cell with Short Date number format. Copy the function down the column to fill out the remaining dates of the Loan Amortization table.