10/20/24, 4:19 PM WGU C268 Spreadsheets/WGU C268 Spreadsheets 2024-2025 UPDATE /COMPREHENSIVE FREQUENTLY TESTED QU…
WGU C268 Spreadsheets/WGU C268
Spreadsheets 2024-2025 UPDATE
/COMPREHENSIVE FREQUENTLY TESTED
QUESTIONS AND VERIFIED ANSWERS/ GET IT
100% ACCURATE
Terms in this set (74)
Calculate the payment =PMT(Rate/#months of term,LoanAmt)
amount for the loan in =PMT(C13/12,C12,C11)
cell C15. Reference the
cells containing the
appropriate loan
information as the
arguments for the
function you use. Cells
C20-C67 in the "Payment"
column are populated
with the payment amount
from cell C15. [34 Points]
https://quizlet.com/959743133/wgu-c268-spreadsheetswgu-c268-spreadsheets-2024-2025-update-comprehensive-frequently-tested-questions-a… 1/27
,10/20/24, 4:19 PM WGU C268 Spreadsheets/WGU C268 Spreadsheets 2024-2025 UPDATE /COMPREHENSIVE FREQUENTLY TESTED QU…
Calculate, in cell D20, the =F19*$C$13/12
interest amount for
period 1 by multiplying
the balance in period 0
(cell F19) by the loan
interest rate (cell C13)
divided by 12. Dividing
the interest rate by 12
results in the monthly
interest rate. This formula
is reusable. The interest
for a given period is
always the monthly
interest rate times the
balance from the
previous period.
Calculate, in cell E20, the =C20-D20
principal amount for
period 1. The principal
amount is the difference
between the payment
amount (cell C20) and
the interest amount (cell
D20) for period 1.
Construct your formula in
such a way that it can be
reused to complete the
"principal" column of the
amortization table.
https://quizlet.com/959743133/wgu-c268-spreadsheetswgu-c268-spreadsheets-2024-2025-update-comprehensive-frequently-tested-questions-a… 2/27
, 10/20/24, 4:19 PM WGU C268 Spreadsheets/WGU C268 Spreadsheets 2024-2025 UPDATE /COMPREHENSIVE FREQUENTLY TESTED QU…
Calculate, in cell F20, the =F19-E20
balance for period 1. The
balance is the difference
between the balance for
period 0 (cell F19) and
the principal amount for
period 1 (cell E20). This
formula is reusable. The
balance is always
calculated as the
difference between the
balance from the
previous period and the
principal amount for the
current period.
Calculate, in cell G12, the =C15*C12
total amount paid by
multiplying the payment
amount (cell C15) by the
term of the loan (cell
C12).
Calculate the total =SUM(D20:D67)
interest paid in cell G13.
The total interest paid is
the sum of all interest
paid in the "Interest"
column of the
amortization table.
https://quizlet.com/959743133/wgu-c268-spreadsheetswgu-c268-spreadsheets-2024-2025-update-comprehensive-frequently-tested-questions-a… 3/27
WGU C268 Spreadsheets/WGU C268
Spreadsheets 2024-2025 UPDATE
/COMPREHENSIVE FREQUENTLY TESTED
QUESTIONS AND VERIFIED ANSWERS/ GET IT
100% ACCURATE
Terms in this set (74)
Calculate the payment =PMT(Rate/#months of term,LoanAmt)
amount for the loan in =PMT(C13/12,C12,C11)
cell C15. Reference the
cells containing the
appropriate loan
information as the
arguments for the
function you use. Cells
C20-C67 in the "Payment"
column are populated
with the payment amount
from cell C15. [34 Points]
https://quizlet.com/959743133/wgu-c268-spreadsheetswgu-c268-spreadsheets-2024-2025-update-comprehensive-frequently-tested-questions-a… 1/27
,10/20/24, 4:19 PM WGU C268 Spreadsheets/WGU C268 Spreadsheets 2024-2025 UPDATE /COMPREHENSIVE FREQUENTLY TESTED QU…
Calculate, in cell D20, the =F19*$C$13/12
interest amount for
period 1 by multiplying
the balance in period 0
(cell F19) by the loan
interest rate (cell C13)
divided by 12. Dividing
the interest rate by 12
results in the monthly
interest rate. This formula
is reusable. The interest
for a given period is
always the monthly
interest rate times the
balance from the
previous period.
Calculate, in cell E20, the =C20-D20
principal amount for
period 1. The principal
amount is the difference
between the payment
amount (cell C20) and
the interest amount (cell
D20) for period 1.
Construct your formula in
such a way that it can be
reused to complete the
"principal" column of the
amortization table.
https://quizlet.com/959743133/wgu-c268-spreadsheetswgu-c268-spreadsheets-2024-2025-update-comprehensive-frequently-tested-questions-a… 2/27
, 10/20/24, 4:19 PM WGU C268 Spreadsheets/WGU C268 Spreadsheets 2024-2025 UPDATE /COMPREHENSIVE FREQUENTLY TESTED QU…
Calculate, in cell F20, the =F19-E20
balance for period 1. The
balance is the difference
between the balance for
period 0 (cell F19) and
the principal amount for
period 1 (cell E20). This
formula is reusable. The
balance is always
calculated as the
difference between the
balance from the
previous period and the
principal amount for the
current period.
Calculate, in cell G12, the =C15*C12
total amount paid by
multiplying the payment
amount (cell C15) by the
term of the loan (cell
C12).
Calculate the total =SUM(D20:D67)
interest paid in cell G13.
The total interest paid is
the sum of all interest
paid in the "Interest"
column of the
amortization table.
https://quizlet.com/959743133/wgu-c268-spreadsheetswgu-c268-spreadsheets-2024-2025-update-comprehensive-frequently-tested-questions-a… 3/27
