Share an example of how a stock price excel assignment help

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.

Order a Similar Paper Order a Different Paper

1.Share an example of how a stock price was impacted by the increase or decrease in the demand for that stock due to good news, national event, etc.

2.You can use Excel to calculate the future value of an annuity using the FV function. To use this function, you input:

a. Rate

b. Periods

C. Payment – if you are saving money, this is a negative number

d. Present value

Type (payment at the beginning (annuity due) or at the end of the period (ordinary annuity))

The following video from (Frye, 2016) demonstrates how to use this function.…

Ref: Frye, Curtis (2016). FV: Calculating the future value of an investment. Retrieved from on May 24, 2017.

3. Major online newspapers publish this information but as an MBA and an investor it is important to understand how these numbers are calculated.

Please go to (or another similar site) and select a publicly traded stock (such as Walmart, Amazon, GM) different from your classmates. Please calculate and interpret the following:

Current Yield

P/E Ratio

Note – in the stock listing the current ratio and the P/E ratio are provided. I want you to show the math so that you understand the calculations behind the numbers.

Please see my example. Also, please include a screen shot of your source information.

** Analysis of GE **

Current Yield = (Dividend Per Share)/(Closing Price per Share) * 100%

CY = $0.96/$27.83 * 100% = 3.45% (this matches what is provided from Barron’s)

Therefore, 3.45% is the return on your investment through dividends.

P/E Ratio = (Current Price Per Share)/(Net Income per Share)

Note: EPS = Earnings Per Share = Net Income Per Share

P/E = $27.83/$1.08 = $25.77 (this is close but not exact because the EPS is for the TTM – trailing 12 months).

Therefore, investors are willing to pay $25.77 for $1 of earnings when the price of stock is $27.83.

** I have attached the screen shot in a Word document. **

4. When you purchase a home your monthly payment is typically composed of PITI (principal, interest, taxes & insurance). The taxes and insurance are not included in this spreadsheet since they are a function of where you live. For a fixed rate loan, the principal and interest part of the loan are fixed; however, the property taxes and insurance more than likely will increase over time (our taxes increased recently).

Let me know what you think. Experiment with the spreadsheet. Look at things such as:

How big of a difference is there for a 1% change in interest rate?

At what point are you paying more principal than interest?

What happens if you take a 20-year loan instead of a 30-year loan?

5. Share a specific example of each of the 3 tiers of investing. Discuss the risks and potential return.

Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.

Order a Similar Paper Order a Different Paper