In cell C11, insert a relative reference to the loan amount in C4.
In cell D11, insert an absolute reference to the monthly payment amount in G4.
In cell G11, use relative references to add the values in cells C11 and F11.
Select the range D11:G11, and then use the fill handle to copy the functions to row 12.
In cell C12, insert a relative reference to the ending balance in cell G11.
Select the range A11:B12, and then use the fill handle to complete the columns through row 70. (Note the cells to select here - it is just A11:B12 - not the whole range.)
Solved by O. J. in 24 mins