Question: Please show equation you would put into excel Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per

Please show equation you would put into excel

Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $71. What was the total return? What was the dividend yield? The capital gains yield? 79 Initial price Dividend paid Ending share price 1.45 $ 71 Complete the following analysis. Do not hard code values in your calculations. Total return Dividend yield Capital gains yield

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!

Suppose a stock had an initial price $86 per share, paid a dividend of 1.79 per share during the year, and had an ending share price of $94. what is the percentage return?

PLEASE SHOW EXCEL FORMULAS USED TO SOLVE Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. What was the...

Can you please help me with this problem. I'm stuck! Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88....

Must show the equations on excel!!! Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. What was the...

Must enter formula on excel!!!! Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. Compute the percentage...

can you tell how you would answe on a Texas Instrument Ba II If you can Wash bought a 16.5% bond price at 90% of par that had 34 years until it matures. (1 year later the yield to maturity on this...

please slove step by step 1. Calculating Returns Suppose a stock had an initial price of $76 per share, paid a dividend of $1.95 per share during the year, and had an ending share price of $84....

1. 1. Calculating returns [LO 12.1] Suppose a share had an initial price of $65 per share, paid a dividend of $1.45 per share during the year and had an ending share price of $71. Compute the...

PLEASE TYPE IT OUT DONT WRITE IT 1A) Suppose a stock had an initial price of $72 per share, paid a dividend of $2.40 per share during the year, and had an ending share price of $84. The percentage...

Calculating Returns Suppose a stock had initial price of $84 per share, paid a dividend of $2.05 per share du4ng the year, and had an ending share price of $97. Compute the percentage total return.

On January 1, 2011, Pueblo Corporation purchased a 75% interest in Sanchez Company for $900,000. A summary of Sanchez Companys balance sheet at date of purchase follows: The equipment had an original...

Will global trade make all capitalists in the U.S. exports capital-intensive good?

A high credit score means you present a low risk to lenders.

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...