11. Max created a spreadsheet for installment purchase calculations.
1
2
3
4
5
A
Purchase
Price
$1,200
$1,750
$1,340
$980
B
Down Payment
Percentage as a
Decimal
0.20
0.10
0.15
0.10
C
Down
Payment
f.
g.
h.
1.
D
Monthly
Payment
$97.01
$71.12
$77.23
$165.51
E
Time in
Years
1
2
1.5
0.5
F
Time in
Months
d. Write the spreadsheet formula to compute the finance charge in cell H2.
e. Use your answers to a-d to fill in the missing entries f-v.
J.
k.
1.
m.
a. Write a spreadsheet formula to compute the down payment in cell C2.
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.
G
Total of
Monthly
Payments
n.
p.
9.
r.
H
Finance
Charge
(Interest)
S.
t.
U.
V.