Stocks investor presentation

Hmndsh
ExcelInvestmentsExample3.xlsx
Home>Business & Finance homework help>Marketing homework help>Stocks investor presentation

Stocks Initial Purchase

Stocks Date of Purchase Company Symbol Purchase price Number of Shares Total of Purchase Shares times price
1 8/4/15 General Motors GM 31.68 100 3168
2 8/4/15 Ford Motor Company F 14.94 100 1494 4662
3 8/4/15 Honda Motor Company HMC 34.64 100 3464 8126
4 8/4/15 Mazda MZDAF 19.11 100 1911 10037
5 8/4/15 Toyota TM 133.18 100 13318 23355
6 8/4/15 Money Market 1645
Totals 25000 23355

Stocks 2nd

Date of Purchase Company Symbol Purchase price Number of Shares Total of Purchase Shares times price Percentage of Portfolio Price Today as of 8-31 $ Gain/loss as of 8-31 % Gain/Loss as of 8-31 Value as of 8-31-2015 Percentage of Portfolio as of 8-31
8/4/15 General Motors GM 31.68 100 3168 12.67% 33 1.32 4.17% 3300 13.20%
8/4/15 Ford Motor Company F 14.94 100 1494 5.98% 16 1.06 7.10% 1600 6.40%
8/4/15 Honda Motor Company HMC 34.64 100 3464 13.86% 32 -2.64 -7.62% 3200 12.80%
8/4/15 Mazda MZDAF 19.11 100 1911 7.64% 18 -1.11 -5.81% 1800 7.20%
8/4/15 Toyota TM 133.18 100 13318 53.27% 131 -2.18 -1.64% 13100 52.40%
8/4/15 Money Market 1645 6.58% 1680 6.72%
25000 100.00% % Portfolio Gain/Loss
25000 24680 -1.28%

Sheet1

Date of Purchase Company Symbol Purchase price Number of Shares Total of Purchase Shares times price Percentage of Portfolio Price Today as of 8-31 $ Gain/loss as of 8-31 % Gain/Loss as of 8-31 Value as of 8-31-2015 Percentage of Portfolio as of 8-31
8/4/15 General Motors GM 31.68 100 3168 12.67% 33 1.32 4.17% 3300 13.20%
8/4/15 Ford Motor Company F 14.94 100 1494 5.98% 16 1.06 7.10% 1600 6.40%
8/4/15 Honda Motor Company HMC 34.64 100 3464 13.86% 32 -2.64 -7.62% 3200 12.80%
8/4/15 Mazda MZDAF 19.11 100 1911 7.64% 18 -1.11 -5.81% 1800 7.20%
8/4/15 Toyota TM 133.18 100 13318 53.27% 131 -2.18 -1.64% 13100 52.40%
8/4/15 Money Market 1645 6.58% 1680 6.72%
25000 100.00% % Portfolio Gain/Loss
25000 24680 -1.28%
Date of Purchase Company Symbol Purchase price Number of Bonds Total of Purchase Bonds times price Percentage of Portfolio Coupon Rate Value of Coupon Bond Value as of 11-18-2015 % Gain/Loss as of 11-18 $ Gain/loss as of 11-18 % Gain/Loss as of 11-18 Value as of 11-18-2015 Coupon Value Total gain or loss Percentage of Portfolio as of 11-18
24-Oct A A 1150 5 5750 19.28% 10%
24-Oct B B 1050 6 6300 21.13% 6%
24-Oct C C 850 7 5950 19.95% 5%
24-Oct D D 960 6 5760 19.32% 3%
24-Oct E E 1010 6 6060 20.32% 3%
29820 100.00%

Sheet2

Date of Purchase Company Symbol Purchase price Number of Shares Current MKTPrice
8/4/15 General Motors GM 31.68 100 33 3300
8/4/15 Ford Motor Company F 14.94 100 16 1600
8/4/15 Honda Motor Company HMC 34.64 100 36 3600
8/4/15 Mazda MZDAF 19.11 100 20 2000
8/4/15 Toyota TM 133.18 100 134 13400
abc 96 100 96 9600
8/4/15 Money Market 33500
Bonds
Date of Purchase Company Purchase price Number of Bonds Total of Purchase Bonds times price
24-Oct A 1150 5 5750 1151 5755
24-Oct B 1050 6 6300 1010 6060
24-Oct C 850 7 5950 860 6020
24-Oct D 960 6 5760 954 5724
24-Oct E 1010 6 6060 1000 6000
29820 29559
Total Orig invest Gain or loss % gain/loss
Portfolio 63059 60000 3059 5.10%