Social Science Economics Finance
WGU C268 SPREADSHEETS PA QUESTIONS AND
CORRECT DETAILED ANSWERS TOP RATED
VERSION/ALREADY A+ GRADED WITH EXPERT
FEEDBACK | NEW AND REVISED
Save
Students also studied
Flashcard sets Study guides
NFP Exam 2 LearnSmart 11 Fina ch. 2 EXAM NEW
117 terms 79 terms 44 terms
George_Mwaura39 Preview papichulosmasher Preview clement_Ndambiri
Calculate the payment amount =PMT(Rate/#months of term,LoanAmt)
for the loan in cell C15. =PMT(C13/12,C12,C11)
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]
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.
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 total =C15*C12
amount paid by multiplying the
payment amount (cell C15) by
the term of the loan (cell C12).
Calculate the total interest paid =SUM(D20:D67)
in cell G13. The total interest
paid is the sum of all interest
paid in the "Interest" column of
the amortization table.
Check to see if the total interest =G12-ABS(C11)
calculation in the amortization
table is correct. The total interest
paid is also equal to the
difference between the total
amount paid over the course of
the loan and the original loan
amount. Insert a formula into
cell G14 to calculate the
difference between the total
amount paid and the original
loan amount. Notice the
negative sign associated with
the original loan amount. This
value should equal the total
interest calculated using the
amortization table.
WGU C268 SPREADSHEETS PA QUESTIONS AND
CORRECT DETAILED ANSWERS TOP RATED
VERSION/ALREADY A+ GRADED WITH EXPERT
FEEDBACK | NEW AND REVISED
Save
Students also studied
Flashcard sets Study guides
NFP Exam 2 LearnSmart 11 Fina ch. 2 EXAM NEW
117 terms 79 terms 44 terms
George_Mwaura39 Preview papichulosmasher Preview clement_Ndambiri
Calculate the payment amount =PMT(Rate/#months of term,LoanAmt)
for the loan in cell C15. =PMT(C13/12,C12,C11)
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]
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.
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 total =C15*C12
amount paid by multiplying the
payment amount (cell C15) by
the term of the loan (cell C12).
Calculate the total interest paid =SUM(D20:D67)
in cell G13. The total interest
paid is the sum of all interest
paid in the "Interest" column of
the amortization table.
Check to see if the total interest =G12-ABS(C11)
calculation in the amortization
table is correct. The total interest
paid is also equal to the
difference between the total
amount paid over the course of
the loan and the original loan
amount. Insert a formula into
cell G14 to calculate the
difference between the total
amount paid and the original
loan amount. Notice the
negative sign associated with
the original loan amount. This
value should equal the total
interest calculated using the
amortization table.
