Question: 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

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 the stock paid dividends of $4.93 per share. What is Sarahs holding period return? Round the answers to two decimal places in percentage form. (Write the percentage sign in the "units" box) Answer: 3.52 %

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!

PLEASE ANSWER ALL QUESTIONS! Sarah purchased 100 shares of General Electric stock at a price of \$ \\$ 60.52 \$ three months ago. She sold all stocks today for \$ \\$ 62.60 \$. During the year...

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) Sarah purchased 100 shares of General Electric stock at a price of $51.40 three months ago. She sold all stocks today for $62.59. During the year the stock paid dividends of $4.54 per share. What...

Sarah purchased 100 shares of General Electric stock of at a price of $66.44 three months ago. She sold all stocks today for $58.08. During the year the stock paid dividends of $2.50 per share. What...

5b Digging Deep Company's common stock is currently selling for $178.96 per share. Next year, the company dividend is expected to be $14.66 per share. The projected growth at a rate of dividends for...

5c Jack holds a portfolio with the following securities: Security Investment Return Stock A 239,557 -6.0% Stock B 663,861 7.8% Stock C 180,279 8.8% Calculate the expected return of portfolio. Round...

C Find the modified internal rate of return (MIRR) for the following series of future cash flows if the company is able to reinvest cash flows received from the project at an annual rate of 12.25...

TranscribedText: Sarah purchased 100 shares of General Electric stock at a price of $61.80 three months ago. She sold all stocks today for $61.35. During the year the stock paid dividends of $2.81...

Next Page Page 3 of 8 Question 3 (1 point) Sarah purchased 100 shares of General Electric stock at a price of $55.27 three months ago. She sold all stocks today for $69.07. During the year the stock...

Question 3 (1 point) Sarah purchased 100 shares of General Electric stock at a price of $55.68 three months ago. She sold all stocks today for $57.12. During the year the stock paid dividends of...

Consider a large population of families that have exactly three children, and suppose that it is desired to test the null hypothesis H0 that the Distribution of the number of boys in each family is a...

You throw a ball vertically from an apartment balcony to the ground 14.7 m below. Find the ball's initial velocity if it hits the ground 1.10 s after you release it. magnitude ?

What is your risk tolerance, either as an investor in a company or if you were an owner of a company? Risk Adverse or Risk Tolerant. What factors would impact your risk tolerance? How would you...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...