Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help with this ASAP 4 5 6 7 You recently won $10,000 in your class project competition. Your financial advisor recommends that you

i need help with this ASAP
image text in transcribed
4 5 6 7 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 S stocks that have all the features listed in the Table below. Note: N/A and are not acceptable Step 4. Pretend you use the $10,000 to purchase the stocks you pick. Allocate the $10,000 among the 5 stocks 9 10 11 12 12 14 15 36 17 Section B: Use Microsoft Word Step 5. (a) Say why you purchased these stocks. For example, I use the product or 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 10 19 Selection Selection Selection 20 21 22 23 Part 1: Make your investment decision Step 3 Selection Selection Company Name Company Symbol Ticker) Website visited 25 2 29 Stock Features Price to Earnings Ratio (PE Ratio) Current Dividend ($) Dividend Yield Earnings per Share (EPS Beta Market Capitalization 31 12 33 34 Step 4: Allocate your cash among the stocks Stocks Purchased: Only small change may be unspent Company Ticker/symbol Date Purchased # of Share o Price/Sharep Total Costinxel

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

Entrepreneurial Finance Strategy, Valuation, And Deal Structure

Authors: Janet Smith, Richard Smith, Richard Bliss

1st Edition

0804770913, 9780804770910

More Books

Students also viewed these Finance questions