WGU - C268 Spreadsheets - Useful formula guide verified
to pass 2025/2026
1. 1. Calculate the payment amount
PMT=(c13/12,c12,c11)
for the loan in cell C15. Reference
Payment
the cells con- taining the
appropriate loan information as
the arguments for the function
you use. Cells C20-C67 in the
"Payment" col- umn are populated
with the payment amount from
cell C15.
2. Calculate, in cell D20, the interest amount =F19*$C$13/12
for period 1 by multiplying the balance in F19 time absolute values C13
divided by 12.
period 0 (cell F19) by the loan
interest rate (cell C13) divided by
12. Dividing the inter- est rate by
12 results in the monthly in- terest
rate. This formula is reusable. The
interest for a given period is always
the monthly interest rate times the
balance from the previous period.
3. Copy the interest amount in such a way that it can
calculation down to complete the be reused to complete
"Interest" column of the the "principal" column
amortization table. [2 points] of the amortization
table.
4. Calculate, in cell E20, the principal
amount for period 1. The principal
amount is the difference between
the payment amount (cell C20) and
the inter- est amount (cell D20) for
period 1. Con- struct your formula
,Drag D19 down to D67 to complete column
=C20-D20
5. Drag E20 down to E67 to complete
column
, WGU - C268 Spreadsheets - Useful formula guide
Study online at https://quizlet.com/_drc729
Copy the principal amount
calculation down to complete the
"principal" column of the
amortization table.
6. Calculate, in cell F20, the balance 10. To verify that the total
for pe- riod 1. The balance is the interest calcula- tion
difference be- tween the balance from the amortization
for period 0 (cell F19) and the table is cor- rect,
principal amount for period 1 (cell calculate the total
E20). This formula is reusable. The interest paid in cell
balance is always calculated as the G14. This is the
differ- ence between the balance difference between the
from the previ- ous period and the Total Amount Paid over
principal amount for the current the course of
period.
7. Copy the balance amount
calculation down to complete the
"Balance" column of the
amortization table.
8. Calculate, in cell G12, the total
amount paid by multiplying the
payment amount (cell C15) by the
term of the loan (cell C12).
9. Calculate the total interest paid in
cell G13. The total interest paid is
the sum of all interest paid in the
"Interest" column of the
amortization table.
to pass 2025/2026
1. 1. Calculate the payment amount
PMT=(c13/12,c12,c11)
for the loan in cell C15. Reference
Payment
the cells con- taining the
appropriate loan information as
the arguments for the function
you use. Cells C20-C67 in the
"Payment" col- umn are populated
with the payment amount from
cell C15.
2. Calculate, in cell D20, the interest amount =F19*$C$13/12
for period 1 by multiplying the balance in F19 time absolute values C13
divided by 12.
period 0 (cell F19) by the loan
interest rate (cell C13) divided by
12. Dividing the inter- est rate by
12 results in the monthly in- terest
rate. This formula is reusable. The
interest for a given period is always
the monthly interest rate times the
balance from the previous period.
3. Copy the interest amount in such a way that it can
calculation down to complete the be reused to complete
"Interest" column of the the "principal" column
amortization table. [2 points] of the amortization
table.
4. Calculate, in cell E20, the principal
amount for period 1. The principal
amount is the difference between
the payment amount (cell C20) and
the inter- est amount (cell D20) for
period 1. Con- struct your formula
,Drag D19 down to D67 to complete column
=C20-D20
5. Drag E20 down to E67 to complete
column
, WGU - C268 Spreadsheets - Useful formula guide
Study online at https://quizlet.com/_drc729
Copy the principal amount
calculation down to complete the
"principal" column of the
amortization table.
6. Calculate, in cell F20, the balance 10. To verify that the total
for pe- riod 1. The balance is the interest calcula- tion
difference be- tween the balance from the amortization
for period 0 (cell F19) and the table is cor- rect,
principal amount for period 1 (cell calculate the total
E20). This formula is reusable. The interest paid in cell
balance is always calculated as the G14. This is the
differ- ence between the balance difference between the
from the previ- ous period and the Total Amount Paid over
principal amount for the current the course of
period.
7. Copy the balance amount
calculation down to complete the
"Balance" column of the
amortization table.
8. Calculate, in cell G12, the total
amount paid by multiplying the
payment amount (cell C15) by the
term of the loan (cell C12).
9. Calculate the total interest paid in
cell G13. The total interest paid is
the sum of all interest paid in the
"Interest" column of the
amortization table.
