Complete an Amortization Schedule You will complete an amortization table detailing payment, principal, interest, cumulative principal, and cumulative interest. s$.$ Ensure that the $2^$nd Location worksheet is active Enter a reference in cell B $12$ to the beginning loan balance. t$.$ Enter a reference in cell C $12$ to the payment amount. u$.$ Enter a function in cell D$12$ based on the payment and loan details that calculates the amount of interest paid on the first payment. Be sure to use the appropriate absolute$,$ relative, or mixed cell references. All results should be formatted as positive numbers. v$.$ Enter a function in cell E$12$ based on the payment and loan details that calculates the amount of principal paid on the first payment. Be sure to use the appropriate absolute$,$ relative, or mixed cell references and ensure the results are positive. w$.$ Enter a formula in cell F$12$ to calculate the remaining balance after the current payment. The remaining balance is calculated by subtracting the principal payment from the balance in column B$.$x$.$ Enter a function in cell G$12$ based on the payment and loan details that calculates the amount of cumulative interest paid on the first payment. Be sure to use the appropriate absolute$,$ relative, or mixed cell references and ensure the results are positive. y$.$ Enter a function in cell H$12$ based on the payment and loan details that calculates the amount of cumulative principal paid on the first payment. Be sure to use the appropriate absolute$,$ relative, or mixed cell references. All results should be formatted as positive numbers. z$.$ Enter a reference to the remaining balance of payment $1$ in cell B$13.$ aa$.$ Use the fill handle to copy the functions created in the prior steps down to complete the amortization table. Expand the width of columns C: H as needed. Save the workbook.Home Insert Draw Page Layout formulas Data Review vieve O Telme $3.$ Secondary Location Amortization Table