Question: please do not use excel 3. [14 Points] A stock has had the following year-end prices and dividends: Year Price Dividend 1 $85.18 2 $92.35

please do not use excel please do not use excel 3. [14 Points] A stock has had

3. [14 Points] A stock has had the following year-end prices and dividends: Year Price Dividend 1 $85.18 2 $92.35 $0.55 3 $90.49 $0.75 4 $100.05 $0.90 1) What were percentage rate of returns for Year 2, Year 3, and Year 4? 2) What is the arithmetic average return for the stock over Year 2 to Year 4? 3) What is the geometric average return for the stock over Year 2 to Year 4

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!

Assume arithmetic average annual returns are as follows: Large corporate stocks: 10.1% Long-term corporate bonds: 6.6% Long-term government bonds: 5.9% US T-Bills: 3.8% Inflation: 3.1%. Given the...

A stock that has had the following year - end prices and dividends: Year Price Dividend 0 $ 8 5 . 1 8 - - - 1 $ 9 0 . 3 5 $ 0 . 5 5 2 $ 8 8 . 4 9 $ 0 . 7 5 3 $ 9 2 . 0 5 $ 0 . 9 0 Compute ( i ) the...

1. Define risk premium in your own words. What is the historical risk premium of large company stocks in U.S.? What is the historical risk premium of long-term government bonds? Refer to Chapter 1....

Attached are financial problems I'm having some trouble with. Please assist with the 4 questions in the attachment. Request work be shown in excel to also see how to perform the functions in a...

3 . A stock has had the following year - end prices and dividends: Year Price Dividend 1 $ 6 2 . 2 8 _ 2 7 1 . 6 6 $ 0 . 6 0 3 9 2 . 5 8 0 . 6 2 4 8 9 . 3 5 0 . 6 4 5 8 2 . 4 9 0 . 6 4 6 9 4 . 0 5 0...

please help A stock has had the following year-end prices and dividends: Year Price Dividend 1 $43.23 N $48.21 $0.39 3 3 4 $57.13 $0.42 $45.21 $0.55 5 $52.13 $0.60 6 $61.21 $0.68 What is the total...

PLEASE SHOW WORK FOR ALL, IF YOU'RE ONLY GOING TO DO ONE OF THESE AND NOT ALL, DONT ANSWER 12. P. Rose, Inc. is considering a new four-year expansion project that requires an initial fixed asset...

A stock has had the following year-end prices and dividends. Calculate the capital gains yield, dividend yield, and total return for each year. What are the arithmetic and geometric mean returns over...

Please answer in excel and display the formulas used. Thanks! 21. Arithmetic and Geometric Returns A stock has had the following year-end prices and dividends: Year Price Dividend - NM LOO 1 2 3 4 5...

Michael Zhang is employed in the accounting department of Sunshine Build Group Ltd which is one of Australias largest suspension bridge builders. He lives in a large architect designed house in an...

Describe how debits and credits affect temporary owners' equity accounts.

Which of the following is correct about functions in Python: Return values accept argument all of the above

A firm estimates that the fixed cost of producing a line of shoes is $70,000, the marketing team charges a $3.5 variable cost for each pair to sell. Consider the selling price is $40 each pair to...

9. Imagine that you have achieved the goal you set for yourself in task 8. a. What do you see in the past? b. How do you feel? c. What do you hear? d. How does this change your roles? e. How does...

8. Set a goal that you really want to achieve in the near future, lets say 12 years. How does this goal fit in relation to the form roles and values above? What role and what value was it that...

7. Fill out the form below. Only the most important roles and your basic values are to be filled.