Answer To: The attache excel is only an sample - I worked the current ratio and gross profit rates for both...
Nitish Lath answered on Apr 09 2023
Title Page
Complete your Title page on this tab.
Please include the names of your team members, the course, the date, your instructor's name, and the title for the project.
Profiles
Complete one paragraph, profiling each company's business, including information such as brief histories, where each company is located, number of employees, the products each company sells, and so forth. Please reference any websites that you used for the profiles on the Bibliography tab.
NIKE, Inc. designs, develops, markets, and sells athletic apparel, footwear, equipment, and accessories. NIKE's headquarters are in Beaverton, Oregon. They were founded in 1964 as Blue Ribbon Sports, Inc. but, in 1971, they changed their name to NIKE, Inc. According to Yahoo! Finance, NIKE has 76,700 full-time employees. NIKE is known for their celebrity endorsements including basketball icon, Michael Jordan. NIKE had 2014 net product sales of $27.8 billion.
Under Armour, Inc. develops, markets, and distributes performance apparel, footwear, and accessories. Under Armour was founded in 1996 and is headquartered in Baltimore, Maryland. According to Yahoo! Finance, Under Armour has 7,000 full-time employees. Under Armour was founded by Kevin Plank, a former University of Maryland college football player. Under Armour had net product sales of $3.1 billion for 2014.
Ratios
Use this Excel spreadsheet to compute ratios; show your computations for all ratios on this tab, and also include your commentary.
Apple Microsoft Interpretation and comparison between the two companies' ratios (reading Chapter 13 will help you prepare the commentary)
9/24/22 6/30/22 The comparison of the ratios is an important part of the project. A good approach is to briefly explain what the ratio tells us. Indicate whether a higher or lower ratio is better. Then compare the two companies on this basis. Remember that each ratio below requires a comparison.
Earnings per Share of Common Stock (basic - common) As given in the income statement $ 6.15 $9.70 EPS ratio helps to analyze the earnings available for shareholders after meeting all expenses. Higher the ratio, better will be the financial performane from investor point of view. In the case, Microsoft is having higher EPS of $9.70 per share as compared to EPS of $6.15 per share of Apple Inc and the shareholders of Microsoft are getting higher amount per share.
Current Ratio Current assets $135,405 = 0.88 $169,684 = 1.78 Current ratio explains the liquidity position of an organization is short-term and higher the ratio better will be the liquidity position. In case of Microsoft is having current ratio of 1.78 times whereas Apple is having 0.88 times and it indicates that the Apple is not having enough liquid assets to settle its current obligations whereas Microsoft is having 0.78 times excess current assets for current liabilities which is a good financial position indicator.
Current liabilities $153,982 $95,082
Gross Profit Rate Gross...