The attache excel is only an sample - I worked the current ratio and gross profit rates for both companies . please help me with the ratios profit margin to the price earnings ratio. Input the amounts...

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
ief 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 Ri
on 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 cele
ity 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
iefly 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.
    Cu
ent Ratio    Cu
ent assets    $135,405    =    0.88    $169,684    =    1.78    Cu
ent 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 cu
ent 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 cu
ent obligations whereas Microsoft is having 0.78 times excess cu
ent assets for cu
ent liabilities which is a good financial position indicator.
        Cu
ent liabilities    $153,982            $95,082
    Gross Profit Rate    Gross...