NEED THE *********** FORMULA ****************AS THE ANSWER. Thank you Calculatin
ID: 2741559 • Letter: N
Question
NEED THE ***********FORMULA ****************AS THE ANSWER. Thank you
Calculating Returns and Yields Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW B I u EE A Alignment Number Conditional Format as Cell Cells Editing Paste Formatting Table Styles Font Styles Clipboard A1 A C D E F G H 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? Initial price 79 Dividend paid 1.45 Ending share price 71 Complete the following analysis. Do not hard code values in your calculations. Total return 14 Dividend yield 15 Capital gains yield 17 20 Sheet1 100%Explanation / Answer
Total return = Dividend Yield + Capital gain Yield
Dividend Yield = Dividend/ Initital Price * 100 = 1.45/79*100 = 1.84%
Capital Gain Yield = Ending Price - Initial Price/ Initial Price * 100 = 71-79/79*100 = -10.13%
Total return = 1.84 - 10.13 = -8.29%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.