WGU C268 Study Guide for EXCEL PA
Calculate the price quantity for the mortgage in mobile C15. Reference the cells containing the
ideal loan statistics because the arguments for the characteristic you use. Cells C20-C67 in the
"Payment" column are populated with the fee quantity from cellular C15.
=PMT(C13/12,C12,C11)
Calculate, in cell D20, the hobby quantity for length 1 by using multiplying the stability in
duration zero (cell F19) by means of the loan hobby charge (mobile C13) divided with the aid of
12. Dividing the hobby rate by way of 12 consequences in the monthly interest fee. This formula
is reusable. The interest for a given duration is usually the month-to-month interest fee times the
balance from the preceding period.
F
=F19*C$thirteen/12
Copy the Interest amount calcualtion down to finish the "hobby" column of the amortization
table.
Paste down column .
Calculate, in mobile E20, the foremost amount for period 1. The predominant amount is the
difference between the fee quantity (cell C20) and the interest quantity (cellular D20) for
duration 1. Construct your components in any such way that it is able to be reused to complete
the "essential" column of the amortization desk.
=C20-D20
Copy the fundamental amount calculation down to complete the "most important" column of the
amortization desk.
Copy and paste down.
Calculate, in mobile F20, the stability for period 1. The stability is the difference between the
stability for period 0 (cell F19) and the main quantity for period 1 (cellular E20). This system is
reusable. The stability is always calculated because the distinction between the balance from
the preceding period and the fundamental quantity for the cutting-edge length.
=F19-E20
, Copy the stability quantity calculation down to complete the stability column of the amortization
table.
Copy and paste down.
Calculate, in mobile G12, the entire amount paid by way of multiplying the fee quantity (mobile
C15) by way of the time period of the loan (mobile C12).
=C15*C12
Calculate the entire hobby paid in cell G13. The overall interest paid is the sum of all hobby paid
in the "Interest" column of the amortization table.
=SUM(D20:D67)
Check to look if the total hobby calculation in the amortization table is accurate. The overall
interest paid is also equal to the distinction among the total amount paid over the course of the
loan and the authentic loan quantity. Insert a method into mobile G14 to calculate the distinction
among the whole quantity paid and the authentic mortgage quantity. Notice the terrible signal
associated with the unique mortgage amount. This fee ought to equal the whole hobby
calculated using the amortization table.
=G12+C11
Assume you have made the primary 36 bills for your mortgage. You need to exchange the
automobile in for a brand new car. You believe that you may promote your automobile for
$4000. Will this cover the balance final on the car in length 36? Answer both "Yes" or "No" in cell
G15 from the drop-down menu.
No
Use the HLOOKUP feature to complete the "Hourly Wage" column of table 1. Use the
"Employee" column of desk 1 as the lookup_value and the "Employee Wage Information" above
table 1 as your reference table.
=HLOOKUP(D16, E$11:H$12, 2,False)
Use the AND function to finish the "Time Bonus?" column of desk 1. An employee earns a time
bonus if the mission's "Hours Worked" are fewer than the "Estimated Hours" and if the paintings
"Quality" is greater than 1.
=AND(E16<C16,H16>1)
Calculate the price quantity for the mortgage in mobile C15. Reference the cells containing the
ideal loan statistics because the arguments for the characteristic you use. Cells C20-C67 in the
"Payment" column are populated with the fee quantity from cellular C15.
=PMT(C13/12,C12,C11)
Calculate, in cell D20, the hobby quantity for length 1 by using multiplying the stability in
duration zero (cell F19) by means of the loan hobby charge (mobile C13) divided with the aid of
12. Dividing the hobby rate by way of 12 consequences in the monthly interest fee. This formula
is reusable. The interest for a given duration is usually the month-to-month interest fee times the
balance from the preceding period.
F
=F19*C$thirteen/12
Copy the Interest amount calcualtion down to finish the "hobby" column of the amortization
table.
Paste down column .
Calculate, in mobile E20, the foremost amount for period 1. The predominant amount is the
difference between the fee quantity (cell C20) and the interest quantity (cellular D20) for
duration 1. Construct your components in any such way that it is able to be reused to complete
the "essential" column of the amortization desk.
=C20-D20
Copy the fundamental amount calculation down to complete the "most important" column of the
amortization desk.
Copy and paste down.
Calculate, in mobile F20, the stability for period 1. The stability is the difference between the
stability for period 0 (cell F19) and the main quantity for period 1 (cellular E20). This system is
reusable. The stability is always calculated because the distinction between the balance from
the preceding period and the fundamental quantity for the cutting-edge length.
=F19-E20
, Copy the stability quantity calculation down to complete the stability column of the amortization
table.
Copy and paste down.
Calculate, in mobile G12, the entire amount paid by way of multiplying the fee quantity (mobile
C15) by way of the time period of the loan (mobile C12).
=C15*C12
Calculate the entire hobby paid in cell G13. The overall interest paid is the sum of all hobby paid
in the "Interest" column of the amortization table.
=SUM(D20:D67)
Check to look if the total hobby calculation in the amortization table is accurate. The overall
interest paid is also equal to the distinction among the total amount paid over the course of the
loan and the authentic loan quantity. Insert a method into mobile G14 to calculate the distinction
among the whole quantity paid and the authentic mortgage quantity. Notice the terrible signal
associated with the unique mortgage amount. This fee ought to equal the whole hobby
calculated using the amortization table.
=G12+C11
Assume you have made the primary 36 bills for your mortgage. You need to exchange the
automobile in for a brand new car. You believe that you may promote your automobile for
$4000. Will this cover the balance final on the car in length 36? Answer both "Yes" or "No" in cell
G15 from the drop-down menu.
No
Use the HLOOKUP feature to complete the "Hourly Wage" column of table 1. Use the
"Employee" column of desk 1 as the lookup_value and the "Employee Wage Information" above
table 1 as your reference table.
=HLOOKUP(D16, E$11:H$12, 2,False)
Use the AND function to finish the "Time Bonus?" column of desk 1. An employee earns a time
bonus if the mission's "Hours Worked" are fewer than the "Estimated Hours" and if the paintings
"Quality" is greater than 1.
=AND(E16<C16,H16>1)
