I need the following problems completed on an Excel worksheet showing work and/or formulas.

Chapter 4

11. Calculating Present Values. You have just received notification that you have won the $1 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th birthday (assuming youre around to collect), 80 years from now. What is the present value of your windfall if the appropriate discount rate is 7.25 percent?

13. Calculating Growth Rates and Future Values. In 1895, the first U.S. Open Golf Championship was held. The winners prize money was $150. In 2014, the winners check was $1,620,000. What was the annual percentage increase in the winners check over this period? If the winners prize increases at the same rate, what will it be in 2045?

15. Calculating Rates of Return. Although appealing to more refined tastes, art as a collectible has not always performed so profitably. During 2003, Sothebys sold the Edgar Degas bronze sculpture Petite Danseuse de Quatorze Ans at auction for a price of $10,311,500. Unfortunately for the previous owner, he had purchased it in 1999 at a price of $12,377,500. What was his annual rate of return on this sculpture?

19. Calculating Future Values. You are scheduled to receive $13,000 in two years. When you receive it, you will invest it for six more years at 7.5 percent per year. How much will you have in eight years?

25. Calculating Present Values. You have decided that you want to be a millionaire when you retire in 45 years. If you can earn an annual return of 11 percent, how much do you have to invest today? What if you can earn 5.5 percent?

Chapter 5

26. Calculating Annuity Present Values. Beginning three months from now, you want to be able to withdraw $2,500 each quarter from your bank account to cover college expenses over the next four years. If the account pays .38 percent interest per quarter, how much do you need to have in your bank account today to meet your expense needs over the next four years?

35. Comparing Cash Flow Streams. Youve just joined the investment banking firm of Dewey, Cheatum, and Howe. Theyve offered you two different salary arrangements. You can have $6,700 per month for the next two years, or you can have $5,400 per month for the next two years, along with a $25,000 signing bonus today. If the interest rate is 7 percent compounded monthly, which do you prefer?

58. Calculating Annuity Values. You are serving on a jury. A plaintiff is suing the city for injuries sustained after a freak street sweeper accident. In the trial, doctors testified that it will be five years before the plaintiff is able to return to work. The jury has already decided in favor of the plaintiff. You are the foreperson of the jury and propose that the jury give the plaintiff an Page 162award to cover the following: (a) The present value of two years back pay. The plaintiffs annual salary for the last two years would have been $43,000 and $46,000, respectively. (b) The present value of five years future salary. You assume the salary will be $49,000 per year. (c) $200,000 for pain and suffering. (d) $25,000 for court costs. Assume that the salary payments are equal amounts paid at the end of each month. If the interest rate you choose is an EAR of 7 percent, what is the size of the settlement? If you were the plaintiff, would you like to see a higher or lower interest rate?

Chapter 6

5. Coupon Rates. Barnes Enterprises has bonds on the market making annual payments, with 12 years to maturity, a par value of $1,000, and a price of $963. At this price, the bonds yield 6.14 percent. What must the coupon rate be on the bonds?

23. Accrued Interest. You purchase a bond with an invoice price of $1,043. The bond has a coupon rate of 5.7 percent, semiannual coupons, a $1,000 par value, and there are 5 months to the next coupon date. What is the clean price of the bond?