You recently won $10,000 in your class project competition. Your financial advisor recommends that you invest...

You recently won $10,000 in your class project competition. Your financial advisor recommends that you invest it in five stocks in the stock market. Omit all transaction costs Assignment: DUE Wednesday September 9, 11:59 pm Section A: Use Microsoft Excel Step 1: Copy the tables in Part 1 below. They are in Excel Step 2. Go to any financial website (I recommend Yahoo Finance) between August 26 and September 4 . Step 3: Choose 5 stocks that have all the features listed in the Table below. Note: N/A and 0 are not acceptable Step 4. Pretend you use the $10,000 to purchase the 5 stocks you pick. Allocate the $10,000 among the 5 stocks Section B: Use Microsoft Word Step 5. (a) Say why you purchased these stocks. For example, I use the product or I own the stock. Any reason is OK. (b) Write a definition for each of the stock features incluing formulas, if any. For example, P/E is ____.The formula for calculating P/E is ____________ ( c) What is a stock Exchange? What is the Dow Jones Index? What is the S&P 500? What is the NASDAQ? Use any financial website to find your company, its symbol and the features listed below. I recommend Yahoo Finance.

Personal Finance class

Expert Solution

NAME	VALUE
Apple Inc.	120.96	20%	2000
NIO Limited	17.98	20%	2000
Tesla, Inc.	418.32	20%	2000
Bank of America Corporation	26.54	20%	2000
General Electric Company	6.42	20%	2000

These shares are the best priced in the market in addition to having a long and lasting profitability

What is a stock exchange?
A stock exchange is nothing more than an organized place where securities are negotiated, likewise it is where the primary and secondary market are combined to negotiate titles that grant rights over a property value
What is the Dow Jones index?
This index is nothing more than the behavioral indicator of the different companies and securities that are listed on the United States stock market, within this indicator we find other indicators typical of a set of companies that are listed in specific economic sectors
What is the S&P 500?
This is an income indicator of the different and most important companies that are listed in the United States where 500 of these were pigeonholed, due to its structure it is the most relevant index or indicator in the equity market
What is the NASDAQ?
This is a stock exchange where most securities are traded electronically, and it is also a source of sub-benchmark indicators in the market, in very specific sectors of the economy.
Use any financial website to find your business, its symbol, and the features listed below.

jeff jeffy answered 1 year ago

You want to invest in a bond with LOW interest rate risk. Your financial advisor offers...

You want to invest in a bond with LOW interest rate risk. Your financial advisor offers you two choices: Bond A has face value $1,000, YTM=5%, coupon rate 5% and 10 years to maturity; Bond B is a zero coupon bond, the face value is $1,000, YTM=5% and also matures in 10 years. Which bond has less interest rate risk? A) the risk is the same for both bonds B) Bond A C)Bond B D) Not enough information to answer...

As the financial advisor to Beena you are evaluating the following new investment in a project....

As the financial advisor to Beena you are evaluating the following new investment in a project. • The project has a useful life of 12 years. • Land costs $6m and is estimated to have a resale value of $10m at the completion of the project. • Buildings cost $5m, with allowable depreciation of 10% pa reducing balance and a salvage value of $0.9m. • Equipment costs $4m, with allowable depreciation of 20% pa reducing balance and a salvage value...

Your grandfather gives your $10,000 to invest and you must invest every penny. He wants you...

Your grandfather gives your $10,000 to invest and you must invest every penny. He wants you to have an expected return of 12.40% for your portfolio. You can chose between stock J with an expected return of 13% and stock L with an expected return of 8%. How much should you invest in stock J to achieve these results?

You recently learned that you won an online sweepstakes that promises to pay you (or your...

You recently learned that you won an online sweepstakes that promises to pay you (or your designee) $15,000 annually forever. The payments will begin in one year. What is the present value of your winnings if the market rate is 5%

A financial advisor has up to 50,000$ to invest, with the stipulation that at least $15000...

A financial advisor has up to 50,000$ to invest, with the stipulation that at least $15000 is used to purchase Treasury bonds and at most $25,000 in corporate bonds. a) Construct a set of inequalities that describes the relationship between buying corporate vs Treasury bonds, where the total amount invested must be less than or equal to $30,000. ( Let C be the amount of money invested in corporate bonds, and T the amount invested in Treasury bonds) b) construct...

You are an investment advisor for a client with $100,000 to invest in the stock of...

You are an investment advisor for a client with $100,000 to invest in the stock of publicly traded companies. Your client-who has just enough accounting knowledge to be dangerous-has asked you to justify your advice based on the financial statements of the companies you recommend. Your challenge is to: 1) Determine what specific information from each financial statement could best help you make your choice (possibilities include earnings, cash reserves, stock repurchases,level of debt, dividend payments, finacial ratios, etc. 2)...

It is December 10th and you just met with your financial advisor, who suggested that you...

It is December 10th and you just met with your financial advisor, who suggested that you begin putting $5,000 into a Roth RIA at the beginning of each year, starting next month. Your advisor says that, although there is no guarantee, you could average an annual return of 8% over the next twenty (20) years with the right mix of investments. You want to know just how big of a "nest egg" you can create if you take her advide...

You decided to invest your wealth of $10,000 in a portfolio of three stocks. You also...

You decided to invest your wealth of $10,000 in a portfolio of three stocks. You also decided to sell stock 1 short and collect $3,000. After the short sale you will invest $8,000 of your cash in stock 2 and the remainder in stock 3. The expected rate of return of stock 2 is R2 = 18% and of stock 3 is R3 = 22%. What should the rate of return on stock 1 be for the portfolio rate of...

A financial advisor tells you that you can make your child a millionaire if you just...

A financial advisor tells you that you can make your child a millionaire if you just start saving early. You decide to put an equal amount each year into an investment account that earns 8.0% interest per year, starting on the day your child is born until his 39thbirthday. How much would you need to invest each year to accumulate a million for your child by the time he is 40years old? (Your last deposit will be made on his...

You just won the initial school of finance lottery! You have won $10,000 today, $20,000 five...

You just won the initial school of finance lottery! You have won $10,000 today, $20,000 five years from today, and $50,000 ten years from today. As an alternative, you can receive your winnings as a 15 year annuity with the first payment received ten years from today. If you require a 6% return on your investment, how much annuity pay you each for you to select that option?

Question