Tim knows the cost of leasing will vary with the interest rate charged. He decides to create a chart like the one below. Column C = Column Ax Column B
Column D = Column C +255
Column E = Column D + (Column D x 7%)
Column F = Column E + $300.00
Column G = the payment required to purchase the car.
A
с
D
F
G
B
Monthly rate
Sm
Result
add $255
add 7% of ColumnD add $300
$30,800 0.0033
$
$
$
$67100
V
$30,800 0.0025
$
$
$
V
$
$67100
$
$30 800 0.0038
$
v
$
$
$67100
$30,800 0.0027
$
$
$
$
$67100
$30,800 0.0003
$
$
$
$
$67100