14. LG3 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. What's 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 112 AN INVENTORY OF INVESTMENT HOLDINGS Date Name(s) Type of Investment Name of investment [stock symbol Number of units (shares or other Date Purchased Amount of Investment (Quotes Amount) Cumulative Amount of Annual Income from Dividends, Interest, et Latest Market Value (Quotes Amount) Rehim Comments Planned Action Buy Sell, Hold $0.00 $0.00 0% ON 0% 04 0. 05 09 0 08 0 09 02 02 0% O 09 06 09 08 0% 50.00 50.00 $0.00 Instructions: List number of shares of common and preferred stock purchased in Column Cand 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 debt 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