In: Finance
The table below shows your stock positions at the beginning of the year, the dividends that each stock paid during the year, and the stock prices at the end of the year. Company Shares Beginning of Year Price Dividend per Share End of Year Price Johnson Controls 300 $ 73.21 $ 1.23 $ 86.07 Medtronic 500 57.87 0.47 53.81 Direct TV 800 25.24 24.69 Qualcomm 300 43.38 0.42 39.22 What is your portfolio dollar return and percentage return? (Round your answers to 2 decimal places.) Portfolio Return Dollar return $ Percentage return %
Company | Shares | Beginning of year price | Dividend Per share | End of Year price | ||||
Johnson Controls | 300 | $ 73.21 | $ 1.23 | $ 86.07 | ||||
Medronic | 500 | $ 57.87 | $ 0.47 | $ 53.81 | ||||
Direct TV | 800 | $ 25.24 | $ 24.69 | |||||
Qualcomm | 300 | $ 43.38 | $ 0.42 | $ 39.22 | ||||
Shares*Beginning of Year Price | Beginning Value/Total of beginning value | (End of year price-Beginning of year price)*shares | Dividend Per shares* shares | Capital Gain+Income | Total Return/Beginning Value | |||
Company | Beginning Value | Portfolio Weight | Capital Gain | Income | Total Return | Percent Return | ||
Johnson Controls | $ 21,963.00 | 26.11% | 3858 | $ 369.00 | 4227 | 19.25% | ||
Medronic | $ 28,935.00 | 34.40% | -2030 | $ 235.00 | -1795 | -6.20% | ||
Direct TV | $ 20,192.00 | 24.01% | -440 | $ - | -440 | -2.18% | ||
Qualcomm | $ 13,014.00 | 15.47% | -1248 | $ 126.00 | -1122 | -8.62% | ||
Total | $ 84,104.00 | 870 | 1.03% | |||||
Working | ||||||||
Beginning Balance | Portfolio Weight | Capital Gain | Income | Total Return | Percent Return | |||
Company | ||||||||
Johnson Controls | (300*73.21) | ($21963/$84104) | ($86.07-$73.21)*300 | 300*$1.23 | ($3858+$369) | ($4227/$21963)*100 | ||
Medronic | (500*57.87) | ($28935/$84104) | ($53.81-$57.87)*500 | 500*.47 | (-$2030+$235) | (-$1795/$28935)*100 | ||
Direct TV | (800*25.24) | ($20192/$84104) | ($24.69-$25.24)*800 | ($440) | (-$440/$20192)*100 | |||
Qualcomm | (300*43.38) | ($13014/$84104) | ($39.22-$43.38)*300 | 300*.42 | (-$1248+$126) | (-$1122/$13014)*100 | ||