Answered step by step
Verified Expert Solution
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
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.
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 staticStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started