Question: Tracking portfolio performance. Use Worksheet 11.2 to help Destiny and Robert Payne, a married couple in their late 40s, evaluate their securities portfolio, which includes

Tracking portfolio performance. Use Worksheet 11.2 to help Destiny and Robert Payne, a married couple in their late 40s, evaluate their securities portfolio, which includes these holdings.

a) IBM (NYSE; symbol IBM): 100 shares bought in 2011 for $170.40 per share.

b) Verizon (NYSE; symbol VZ): 250 shares purchased in 2007 for $40.62 per share.

c) Procter & Gamble (NYSE; symbol PG): 150 shares purchased in 2010 at $61.85 per share.

d) Google, which is now Alphabet (Nasdaq symbol, GOOG): 200 shares purchased in 2014 at $519.98 per share.

e) The Paynes also have $8,000 in a bank savings account that pays 1.25 percent annual interest.

1) Based on the latest quotes and portfolio tracking tools obtained from the Internet, complete Worksheet 11.2.

2) Whats the total amount the Paynes have invested in these securities, the annual income they now receive, and the latest market value of their investments?

Worksheet 11.2
AN INVENTORY OF INVESTMENT HOLDINGS
Name(s): Date:
Type of Investment Name of investment [stock symbol] Number of units [shares or other] Date Purchased Amount of Investment (Quote$ Amount) Cumulative Amount of Annual Income from Dividends, Interest, etc. Latest Market Value (Quote$ Amount) Return Comments/ Planned Actions: Buy, Sell, Hold
$ - $ - 0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
$ - $ - $ - 0%
Instructions: List number of shares of common and preferred stock purchased in Column C and the purchase price per unit in Column E. The total purchase price is calculated in Column G. For real estate, enter total market value of property under Marrket value Quote column I and amount actually invested (purchase price less balance of dbebt) under amount of investment quote column E. Number of units for real estate is 1 for each property. Under Latest Market Value, enter market price as of the date of this report (for instance, in December 2020, Pall Corp. was trading at 18.50). The latest market value for real estate is entered as an estimate of what the property would likely sell for (under market value Quote). To print with Column M, select "Fit to Page"as the scaling option. The return is computed as the (gain + annual income) divided by purchase price.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!