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 c. 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? M N O BP Q WS 112 Inventory of investments (1).xlsx File Edit Insert Format Help Qa Calien 11 - BIUSA .. Workshoot 112 A B D E G H 1 1 Worksheet 112 2 AN INVENTORY OF INVESTMENT HOLDINGS 3 Names: Date 4 5 Type of Name of Number Dace Cumulative investment Investment of units archased Amount of Istock symbol shoes Annual 6 or other Income from Amount of Dividends, Latest Investment Interest, Market Value Quotes Amount) Quotes Amount) 7 0 Return Comments Planned Actions: Buy Sell, Hold 10 mo 0% ON ON ON ON 10 11 12 1 14 15 16 SESSES