Using Excel to Calculate Compound Interest

First, calculate the monthly interest rate. Monthly Interest Rate = 0.12 / 12 = 0.01 . Then set the PV of the lease payments equal to $4,000, the retail price of the equipment. Since the first payment is due immediately, value all payments except the payment made today using the standard annuity formula. ................
................