1. Car lease New car price that you will pay APR paid monthly 70000.00 7.00% You may not need this row. You may not need this row. Number of months to lease Residual value of the car you will be returning at the end of the lease (Payments) due at the END of each month: Negative number 60.00 10000.00 2. Number of loan payments required Amount borrowed today APR paid QUARTERLY 30000.00 7.00% You may not need this row. You may not need this row. 928.97 Payments you will make at the END of each QUARTER 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 Payments that you will make at the BEGINNING of each month Residual value of the boat you will be returning at the end of the lease Number of monthly payments required 55000.00 700.00 33000.00 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 Coupon rate: APR paid QUARTERLY Maturity in years Discount rate: Effective annual rate 1000.00 6.00% You may not need this row. You may not need this row. 10.00 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 6. Future value: How much will you have in savings? Amount you will deposit into savings account at the END each MONTH 100.00 You may not need this row. Effective annual rate that the bank is promising you 5.00% You may not need this row. You may not need this row. Number of years for which you will save 20.00 You may not need this row. FV: Future value, the balance you will receive at the end 1. (Payments) due [Negative number.] 2. Number of payments required 3. Implied APR in % 4. EAR in % 5. Bond price you will need to (pay) at the time of issue [Negative number.] 6. FV: Future value, the balance you will have at the end