finance

finance

create an imaginary investment portfolio of four companies of your choice. You will be investing a total of $20,000 in imaginary money, with $5,000 invested in each of these four companies. We will track the progress of your portfolio over Modules 1-4, and also take a closer look at various aspects of these four companies.
To start with, choose your four companies. Don’t worry, you don’t have to use any fancy methods to pick them. The only restrictions are A) they need to be publicly traded companies with data available on web pages such as Investing.com or Morningstar.com, and B) they need to be from four different industries – don’t pick four companies all from the same industry. Your choice of companies can be made based on a variety of factors. For example, you may want to invest in a company simply because you like its products and personally use them. You can also apply some of the criteria from the background readings such as the P/E ratio, or you can search the internet and see what different analysts are saying about this company.
In addition to choosing four companies, review the links on Microsoft Excel in the background readings if you are new to using Excel. To get full credit you need to submit some information in the form of an Excel spreadsheet. But if you are struggling with Excel you can submit the information in a Word table and get partial credit for this assignment.
Once you have chosen your four companies, complete the following two sections of this assignment:
Write a short description of each of your four companies and why you chose it. Be specific for your reasons – is it based on research, your gut feelings, your own experience with the company, etc. Also, explain whether you think each is a growth stock, a value stock, or an income stock using the definitions of these types of stocks from the background readings as well as the information you find about each company. Have at least one paragraph for each company, and about one and a half pages total for this section of the assignment in a Word document.
Go to a web page that has stock quotes and financial information about publicly traded stocks and find information about stock prices and P/E ratios for your four companies. There are many such webpages, such as Investing.com’s stock quote page. In an Excel file, create a table with the following items:
The name of each company
The current stock price
The stock price one year ago
The percentage change in stock price from one year ago (the capital gain). Use the tutorial in the background page on the use of formulas in Excel to calculate this for each company
The P/E ratio for each company

        $10 per 275 words - Purchase Now