Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The file I will attach was not answered as I had asked. Can you please help me with this because I am submitting it as

image text in transcribed

The file I will attach was not answered as I had asked. Can you please help me with this because I am submitting it as a late assignment due to computer issues.

Finance 100 is my course. It was not explained to us how to do this or taught how to use Xcel. See attached documents.

image text in transcribed PLEASE HELP ME WITH THIS FINANCE 100 WORK BELOWDONE IN EXCEL AND I NEED IT BY SATURDAY, DEC. 3, ABOUT 9:00 PM. I Must submit by Sunday 9:00 AM or Monday at 9 am. I just do not understand any of this! PLEASE DO IN a MS WORD doc, it is easier for me! THANK YOU SO VERY MUCH. Professor wants me to Complete the following homework scenario: Select one (1) U.S. publicly traded company and review its most recent Annual Report. You may use one (1) of the three (3) companies you selected for your Stock Journal assignment. (I did the below information in Excel) Not a good project for me! (done in WEEK 3 as a chart) Stock McDonald s Price $ 113.93 Invest $10,000 Shell Oil $50.82 $10,000 Comcast $64.06 $ 5,000.00 $ 25,000.00 Can buy 87.773194 1 196.77292 4 78.051826 4 Actually buy 3.36% Total bought 3.83 $ 0.33% 0.17 $ 0.33% 0.21 $ 4.21 o Use the Income Statement and Balance Sheet to determine the changes in: assets, liabilities, and equity total revenue and net income o o Briefly describe the change from the current and prior years in each of these key areas and determine if the changes would be positive or negative from an investor / stockholder's view. o Record the current price of the stock for each company you selected in Week 3's Stock Journal. (LISTED ABOVE) You may use any price during this week (e.g., day one price, the opening, the low, the high, the close, or any price you find when you check it during the day). Using MS Excel spreadsheet or MS Word document, put your Week 3 and Week 8 (current day) stock prices side-by-side, to show your comparison. Determine the current value of your total investment. Do not make any changes to your investment at this time. Calculate your total based on the number of shares and the new price per share, for each company. Provide your opinion / assessment of your investments. Evaluate the results of your current investment. Are you happy with the result and the trend? Are you upset because you're investment is worth less than $25,000. Feel free to speculate / guess at why you believe the stock increased, decreased, or remained static

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

Foundations Of Finance

Authors: Arthur J. Keown, John H. Martin, J. William Petty

10th Edition

0135160618, 978-0135160619

More Books

Students also viewed these Finance questions

Question

Define the concept of functional autonomy as employed by Allport.

Answered: 1 week ago