Description
Complete an excel worksheet to show calculations. All of the final answers are provided. The assignment is to create an excel worksheet that shows calculations to achieve the final answers.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hey, I have submitted the answer, kindly confirm. Thank you
Questions 1
Number of shares
100
$ 4,439.00
$
49.67
$ 4,967.00
$ 528.00
11.89%
Initial value of shares
Shares price
sell value
Capital gain
Percentage gain
Question 2
Dividents
Dividentd yield
Rate of return
165
3.72%
15.61%
Year
1
2
3
4
5
6
7
8
9
10
Return
3.50%
13.30...