10/18/24, 9:13 AM C268 Spreadsheets/WGU C268 Spreadsheets C268: Final OA Study Guide with complete solution| get it right!! Flashcards | …
C268 Spreadsheets/WGU C268 Spreadsheets
C268: Final OA Study Guide with complete
solution| get it right!!
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]
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.
,10/18/24, 9:13 AM C268 Spreadsheets/WGU C268 Spreadsheets C268: Final OA Study Guide with complete solution| get it right!! Flashcards | …
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 =C15*C12
total amount paid by
multiplying the payment
amount (cell C15) by the
term of the loan (cell
C12).
, 10/18/24, 9:13 AM C268 Spreadsheets/WGU C268 Spreadsheets C268: Final OA Study Guide with complete solution| get it right!! Flashcards | …
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.
Check to see if the total =G12-ABS(C11)
interest 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.
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller CodedNurse. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
