Question: How Do I calculate the below correct answer in excel. John purchased 100 shares of Soft Drink Co. stock at a price of $71.47 three

How Do I calculate the below correct answer in excel.

John purchased 100 shares of Soft Drink Co. stock at a price of $71.47 three months ago. He sold all stocks today for $71.38. During that period the stock paid dividends of $4.78 per share. What is Johns effective annual rate? Answer: 29.38 %

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

John purchased 100 shares of Soft Drink Co. stock at a price of $71.81 three months ago. He sold all stocks today for $70.80. During that period the stock paid dividends of $2.85 per share. What is...

Thanks so much yall! Question 14 (1 point) John purchased 100 shares of Soft Drink Co. stock at a price of $71.55 three months ago. He sold all stocks today for $71.99. During that period the stock...

Question 10 (1 point) John purchased 100 shares of Soft Drink Co. stock at a price of $71.60 three months ago. He sold all stocks today for $71.59. During that period the stock paid dividends of...

John purchased 100 shares of Soft Drink Co. stock at a price of $71.25 three months ago. He sold all stocks today for $68.91. During that period the stock paid dividends of $4.00 per share. What is...

How do I calculate the below correct answer in excel. Sarah purchased 100 shares of General Electric stock at a price of $66.44 three months ago. She sold all stocks today for $63.85. During the year...

Please explain. Possibly using excel! John purchased 100 shares of Black Forest Inc. stock at a price of $154.12 three months ago. He sold all stocks today for $160.52. During this period the stock...

Please see the attached. These questions are pretty repetitive. I don't need solutions... I just need answers. Thank you. 1. What is the value of a bond that has a par value of $1,000, a coupon rate...

1. UPS preferred stock pays $14 in annual dividends. If your required rate of return is 15.63 percent, how much would you be willing to pay for one share of this preferred stock? Round the answer to...

1. Garden Tools Inc. has bonds, preferred stock, and common stocks outstanding. The number of securities outstanding, the current market price, and the required rate of return for these securities...

A 95% confidence interval for the lives (in minutes) of Kodak AA batteries is 430

please assist with Schedule L, M-1, and M-2 on Form 1120. Bizrate Electronics, Inc. A "C" Corporation For the Year Ended December 31, 2018 Bizrate Electronics was organized on February 22, 2018, by...

R138. The spool, which has a mass of 4 kg, slides along the rotating rod. At the instant shown, the angular rate of rotation of the rod is u # = 6 rad>s and this rotation is increasing at u $ = 2...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...