Question: need excel solution please excel formula only calculating returns in...
Question details
NEED EXCEL SOLUTION PLEASE: EXCEL FORMULA ONLY
Calculating returns in Excel is a relatively simple matter since we only need to input basic equations. Consider the information from 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 and percentage returns as:
| Total dollar capital gains: | |
| Dividend income: | |
| Total dollar return: | |
| Capital gains return: | |
| Dividend yield: | |
| Total return: | |
Solution by an expert tutor
