1. Business
  2. Finance
  3. need excel solution please excel formula only calculating returns in...

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
Blurred Solution
This question has been solved
Subscribe to see this solution