1
answer
0
watching
81
views
olivepug595Lv1
28 Sep 2019
NEED EXCEL SOLUTION PLEASE: EXCEL FORMULA ONLY
Calculating returns in Excel is a relatively simple matter sincewe only need to input basic equations. Consider the informationfrom the Video Concepts Company:
Shares: 100 Beginning price: $ 37.00 Ending price: $ 40.33 Dividend per share: $ 1.85
With this information, we can calculate the dollar returns andpercentage returns as:
Total dollar capital gains: Dividend income: Total dollar return: Capital gains return: Dividend yield: Total return:
NEED EXCEL SOLUTION PLEASE: EXCEL FORMULA ONLY
Calculating returns in Excel is a relatively simple matter sincewe only need to input basic equations. Consider the informationfrom the Video Concepts Company:
| Shares: | 100 | |
| Beginning price: | $ 37.00 | |
| Ending price: | $ 40.33 | |
| Dividend per share: | $ 1.85 |
With this information, we can calculate the dollar returns andpercentage returns as:
| Total dollar capital gains: | |
| Dividend income: | |
| Total dollar return: | |
| Capital gains return: | |
| Dividend yield: | |
| Total return: | |
Trinidad TremblayLv2
28 Sep 2019