1. Car lease New car price that you will pay 70000.00 APR paid monthly 7.00% You may not need this row. You may not need this row. Number of months to lease 60.00 Residual value of the car you will be returning at the end of the lease 10000.00 (Payments) due at the END of each month: Negative number 2. Number of loan payments required Amount borrowed today 30000.00 APR paid QUARTERLY 7.00% You may not need this row. You may not need this row. Payments you will make at the END of each QUARTER 928.97 Number of quarterly payments required to pay off the loan in full 3. Implied rate Cash price of a boat that you will receive today 55000.00 Payments that you will make at the BEGINNING of each month 700.00 Residual value of the boat you will be returning at the end of the lease 33000.00 Number of monthly payments required 60.00 You may not need this row. You may not need this row. Implied APR paid monthly 4. Effective Annual Rate APR paid monthly 19.00% You may not need this row. Effective annual rate 5. Using the PV formula to price a bond Face value you will receive at maturity 1000.00 Coupon rate: APR paid QUARTERLY 6.00% You may not need this row. You may not need this row. Maturity in years 10.00 Discount rate: Effective annual rate 6.00% You may not need this row. You may not need this row. Pmt: Periodic coupon received You may not need this row. Bond price you will need to (pay) at the time of issue: Negative number