E6-3 (L02,3,4) EXCEL (Computation of Future Values and Present Values) Using the appropriate interest table, answer each of the following questions. (Each case is independent of the others.) (a) What is the future value of $7,000 at the end of 5 periods at 8% compounded interest? (b) What is the present value of $7,000 due 8 periods hence, discounted at 6%? (c) What is the future value of 15 periodic payments of $7,000 each made at the end of each period and compounded at 10%? (d) What is the present value of $7,000 to be received at the end of each of 20 periods, discounted at 5% compound interest? E6-4 (L03,4) (Computation of Future Values and Present Values) Using the appropriate interest table, answer the following questions. (Each case is independent of the others). (a) What is the future value of 20 periodic payments of $4,000 each made at the beginning of each period and compounded at 8%? (b) What is the present value of $2,500 to be received at the beginning of each of 30 periods, discounted at 5% compound interest? (c) What is the future value of 15 deposits of $2,000 each made at the beginning of each period and compounded at 10%? (Future value as of the end of the fifteenth period.) (d) What is the present value of six receipts of $1,000 each received at the beginning of each period, discounted at 9% com- pounded interest? E6-5 (L04) (Computation of Present Value) Using the appropriate interest table, compute the present values of the following periodic amounts due at the end of the designated periods. (a) $30,000 receivable at the end of each period for 8 periods compounded at 12% (b) $30,000 payments to be made at the end of each period for 16 periods at 9%. (c) $30,000 payable at the end of the seventh, eighth, ninth, and tenth periods at 12% E6-6 (L02,3,4) (Future Value and Present Value Problems) Presented below are three unrelated situations. (a) Dwayne Wade Company recently signed a lease for a new office building, for a lease period of 10 years. Under the lease agreement, a security deposit of $12,000 is made, with the deposit to be returned at the expiration of the lease, with interest compounded at 5% per year. What amount will the company receive at the time the lease expires? (b) Serena Williams Corporation, having recently issued a $20 million, 15-year bond issue, is committed to make annual sinking fund deposits of $600,000. The deposits are made on the last day of each year and yield a return of 10% Will the fund at the end of 15 years be sufficient to retire the bonds? If not, what will the deficiency be? (c) Under the terms of his salary agreement, president Rex Walters has an option of receiving either an immediate bonus of $55,000, or a deferred bonus of $70,000 payable in 10 years. Ignoring tax considerations and assuming a relevant interest rate of 4%, which form of settlement should Walters accept?