10. 11.
А
G
H
12
13
Finance
Charge
(Interest)
S.
14.
1
n.
2
k.
t.
h
9.
u.
© Max created a spreadsheet for installment purchase calculations.
B
C
D
E
Down Payment
Total of
Purchase Percentage as a Down
ND
Monthly
Time in Time in Monthly
Price
Decimal Payment Payment
Years Months Payments
2 $1,200
0.20
f.
$97.01
j
3 $1,750
0.10
9. $71.12
P.
4 $1.340
0.15
$77123 1,5
5 $980
0.10
$165.51 0.5
a. Write a spreadsheet formula to compute the down payment in cell 02.
b. Write a spreadsheet formula to compute the time in months in cell F2.
c. Write a spreadsheet formula to compute the total of monthly payments in cell G2.
d. write the spreadsheet formule to compute the finance charge in cell H2.
e. Use your answers to a-d to fill in the missing entries f-v.
f
i.
m
r.
V.
S