Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Module 02 Course Project - Setting Up Your Portfolio Module 02Content A portfolio is a grouping of financial assets such as stocks, bonds, and mutual

Module 02 Course Project - Setting Up Your Portfolio

Module 02Content

  1. A portfolio is a grouping of financial assets such as stocks, bonds, and mutual funds. In general, a portfolio is made up of diverse investments to ensure proper allocation between risk and return. For our project, we will be focusing on stocks and tracking their performance within an Excel workbook that we will be building and formatting.
  2. build a portfolio of 10 stocks using information from the Web.
  3. To start:
  • Conduct research to determine which 10 stocks you will be analyzing in your portfolio and how many shares you will purchase. The amount invested can be anything over $1,000, and since this is all imaginary, the amount invested can be set very high.
  • Determine which data sources you will use in your portfolio workbook.
  • Think about the format your workbook will use for upcoming analysis.
  1. An example of how to get started is shown below.
  2. We will use Microsoft as our stock and Yahoo! Finance as the source website.
  3. Go tofinance.yahoo.com.
  4. In the search box at the top of the page, type in Microsoft.
  5. The Microsoft page shows the following information.
  • Ticker symbol is MSFT.
  • Purchase price (see the Ask price).
  • Current stock price (in bold; use the at close price).
  • Note today's date.
  1. Other possible web sources to find stocks and associated data:
  2. Bankrate
  3. Google Finance
  4. AOL Finance
  5. Marketwatch
  6. Bloomberg
  7. Nasdaq
  8. Follow the example above, worksheet that lists your ten stocks with the following criteria:
  9. Your column headings should include a minimum of the following information.
  10. Stock Name
  11. Ticker Symbol
  12. Purchase Date
  13. # of Shares Purchased
  14. Purchase Price
  15. Total Paid
  16. Add the following column headings. These columns will be used in later assignments.
  17. Current Stock Price
  18. Current Stock Value
  19. Money Made/Lost
  20. Add a title row to your worksheet and center it at the top of the table.
  21. Use 11 pt. font for all other data.
  22. Add data to the name, ticker symbol, date of purchase (today's date), number of stocks purchased, purchase price, and total price paid for each stock (use a formula when appropriate).
  23. Your spreadsheet should look similar to this example portfolio below.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An Introduction

Authors: Pauline Weetman

4th Edition

0273703404, 978-0273703402

More Books

Students also viewed these Accounting questions