Find historical stock prices for each firm

Assignment Help Accounting Basics

Reference no: EM132211169

Question: You have been asked to analyze two companies whether or not the companies are in the same industry. By performing the tasks listed below, select the company which you believe has had the strongest historical performance.

1. Download the annual income statements, balance sheets, and cash flow statements for the last three fiscal years. Enter each company's stock symbol and then go to financials.

2. Find historical stock prices for each firm from Yahoo! Finance or another source. Use the closing stock prices (not the adjusted close).

3. For each of the three years of statements, compute or show the following information for each firm: Valuation Ratios: Price-Earnings Ratio (for EPS use Diluted EPS Total), Market Cap (for current period only), EPS, Closing stock price

Profitability Ratios: Gross profit on net sales, Operating income on net sales, Return on shareholder's equity, Return on average assets, Net Income,Comprehensive income Financial Strength Ratios: Current Ratio,Acid-test Ratio, Debt to equity ratio, Accounts receivable turnover, Inventory turnover, Equity multiplier

Requirements: Part Ia: Based on your calculations of the above requirements, prepare a report to management (Senior Vice President â€" Equity Investments) in which you identify the corporation which has had the strongest historical performance. Make any assumptions to support your decision. Also, use any outside information to support your decision. You may also be creative and develop one or many alternative ratios to value the companies to support your decision.

Part Ib: Based on current events related to the corporation(s), the industry and the overall national or international economy, state whether you believe the current level of performance will (a) continue, (b) improve or (c) worsen. Also, if you cannot come to conclusion, state why. Make any assumptions to support your decision. Also, use any outside information to support your decision. You may also be creative and develop one or many alternative ratios to value the companies to support your decision. you may create your own template. You may wish to perform a horizontal analysis to assess the movement of the ratios. Please use excel or word so I can see a summary of your calculations The 2 companies you can use are Under armour and Nike. You can find the statements on www.nasdaq.com, yahoo or where ever else will work best.

Reference no: EM132211169

Questions Cloud

Write a program which prompts a user for 5 2-d : Write a second program to open the same file , read the two vectors (10 numbers) back in.

Prepare an unclassified balance sheet in proper form : Prepare an unclassified balance sheet at December 31, 2017 in proper form. Prepare the journal entry for each January transaction.

Prompt and read the number of discs in each peg : Write a program for playing the game of NIM. Our version of the game starts with up to 20 pegs and up to 10 discs in each peg.

We planned to deliver and what we actually delivered : Using this data, what can we say about the relationship between what we planned to deliver and what we actually delivered?

Find historical stock prices for each firm : Find historical stock prices for each firm from Yahoo! Finance or another source. Use the closing stock prices (not the adjusted close).

Supporting core competencies in employees : When do you think HR professionals should focus on identifying, developing, or supporting core competencies in employees?

Benefits of blogs : Some topics already state a definite position/stance and some are more general where you can pick your own position.

Draw the flowchart for the program on the back of this paper : Write a program to prompt for inputting 5 numbers (a loop is needed) and find the maximum number.

Determine the facts of the case : This assignment is a research-based essay where you are required to relate a real-world case study to accounting theory. Below you will find links to news.

User Account

All Pages