You are an intern at a wealth management company, which has tasked you with monitoring a key client's portfolio and provide periodic updates to the Financial Advisor that manages the relationship. Below is the summary of the investments:

Investment Shares/units

Apple Inc. 500 shares

U.S. Treasury Bond (10 year) 100,000 PV

Vanguard S&P 500 Index Fund Admiral Shares 500 shares

Vanguard Total Bond Market ETF 2,000 shares

Coca-Cola Co 3,000 shares

Vanguard Money Market Prime Fund 50,000 shares

NYSE / NASDAQ stock of your choice $100,000 value

Portfolio Total: ????

You must also track several market indexes to determine the relative performance of client's portfolio:

• Dow Jones Industrial Average
• Standard & Poors 500
• NASDAQ Composite
• MSCI-EAFE
• 10 Year U.S. Treasury Bond rate
• Gold (per oz)
• Yen
• Euro

You must track each investment as of the end of week 5/13 through 6/17. Your employer would like you to structure your tracking spreadsheet as follows:

Table #1: Per unit price of each investment and index

• Date
• Investment Item
• Market Index

Table #2: Market value of each investment and total market value of the portfolio

• Date
• Investment Item
• Total Portfolio Market Value

You must submit periodic tracking spreadsheets with additional detail each time, noted below, and then by the end of six weeks, submit a written analysis recapping and explaining the performance of the client's portfolio.