You have two financing options from a car dealer: financing and leasing. The details are given in the table below. If your earning interest rate is 6%. Which financing option is better?

You need to represent BOTH in your spreadsheet

Item Price Down payment APR Monthly payment Length (months) Fees Disposition Purchase option at end Cash due at beginning Finance $14,695 $2,000 3.6% $372.55 36 $0 $2,000 Lease $14,695 $0 $236.45 36 $495 $300 $8.673.1 $731.45 $2,000 $731.45 Months 35 36 A-$372.55 Months 35 36 $8,673.1 A-$236.45 Finance $300 Lease