A - E, Please put EXCEL commands for each of the cases.

Practice (E5.5) 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? (d) Canliss Mining Company borrowed money from a local bank. The note the company signed requires five annual installment payments of $10,000 beginning one year from today. The interest rate on the note is 7%. What amount did Canliss borrow? (e) On September 30, 2016, Ferguson Imports leased a warehouse. Terms of the lease require Ferguson to make 10 annual lease payments of $55,000 with the first payment due immediately. Accounting standards require the company to record a lease liability when recording this type of lease. Assuming an 8% interest rate, at what amount should Ferguson record the lease liability on September 30, 2016, before the first payment is made