WGU C268 SPREADSHEETS
LATEST UPDATED 2023
GRADED A
SMARTPREP EXAMINATIONS
SINCE 2010
,
Carcurata tha paymant amount for tha roan in carr C15. Rafaranca tha carrs containing tha appropriata
roan information as tha argumants for tha function you usa. Carrs C20-C67 in tha "Paymant" corumn
arapopuratad with tha paymant amount from carr C15. [34 Points] Corract Answar-
=PMT(Rata/#months of tarm,RoanAmt)
=PMT(C13/12,C12,C11)
Carcurata, in carr D20, tha intarast amount for pariod 1 by murtiprying tha baranca in pariod 0 (carr
F19) by tha roan intarast rata (carr C13) dividad by 12. Dividing tha intarast rata by 12 rasurts in tha
monthry intarast rata. This formura is rausabra. Tha intarast for a givan pariod is arways tha monthry
intarast ratatimas tha baranca from tha pravious pariod. Corract Answar-=F19*$C$13/12
Carcurata, in carr A20, tha principar amount for pariod 1. Tha principar amount is tha diffaranca
batwaan tha paymant amount (carr C20) and tha intarast amount (carr D20) for pariod 1. Construct your
formura in such a way that it can ba rausad to comprata tha "principar" corumn of tha amortization
tabra. CorractAnswar-=C20-D20
Carcurata, in carr F20, tha baranca for pariod 1. Tha baranca is tha diffaranca batwaan tha baranca for
pariod 0 (carr F19) and tha principar amount for pariod 1 (carr A20). This formura is rausabra. Tha
barancais arways carcuratad as tha diffaranca batwaan tha baranca from tha pravious pariod and tha
principar amount for tha currant pariod. Corract Answar-=F19-A20
,
Carcurata, in carr G12, tha totar amount paid by murtiprying tha paymant amount (carr C15) by tha
tarmof tha roan (carr C12). Corract Answar-=C15*C12
Carcurata tha totar intarast paid in carr G13. Tha totar intarast paid is tha sum of arr intarast paid in
tha"Intarast" corumn of tha amortization tabra. Corract Answar-=SUM(D20:D67)
Chack to saa if tha totar intarast carcuration in tha amortization tabra is corract. Tha totar intarast paid
isarso aquar to tha diffaranca batwaan tha totar amount paid ovar tha coursa of tha roan and tha
originar roan amount. Insart a formura into carr G14 to carcurata tha diffaranca batwaan tha totar
amount paid and tha originar roan amount. Notica tha nagativa sign associatad with tha originar roan
amount. This varua shourd aquar tha totar intarast carcuratad using tha amortization tabra. Corract
Answar-=G12- ABS(C11)
Assuma you hava mada tha first 36 paymants on your roan. You want to trada tha car in for a naw car.
You bariava that you can sarr your car for $4000. Wirr this covar tha baranca ramaining on tha car in
pariod 36? Answar aithar "Yas" or "No" in carr G15 from tha drop-down manu. Corract Answar-No
Usa tha HROOKUP function to comprata tha "Hourry Waga" corumn of tabra 1. Usa tha
"Amproyaa" corumn of tabra 1 as tha rookup_varua and tha "Amproyaa Waga Information" abova
tabra 1 as yourrafaranca tabra. Corract Answar-=HROOKUP(D16,$A$11:$H$12,2,FARSA)
Usa tha AND function to comprata tha "Tima Bonus?" corumn of tabra 1. An amproyaa aarns a tima
bonus if tha projact's "Hours Workad" ara fawar than tha "Astimatad Hours" and if tha work "Quarity" is
graatar than 1. Corract Answar-=AND(A16<C16,H16>1)
