Comparison of Oracle and Microsoft (Ratio Analysis)

Oracle logo at the Oracle headquarters.

For Parts 1 and 2:

Create an Excel spreadsheet to show your computations for the six ratios listed under each part.

For Part 3:

Create an Excel spreadsheet to show your computations for the six ratios listed under this part and also to include (copy and paste) the ratio calculations from the first two parts. In this part, you will calculate the last six ratios as well as comment on all of the ratios calculated so far, including the first twelve ratios calculated under the first two parts. Your comments for each ratio should include more than just a definition of the ratio. You should focus on interpreting each ratio number for each company and support your comments with the numbers found in the ratios.

The summary and conclusion should discuss the liquidity, solvency and profitability of each company.

Part 1

Prepare a four-column worksheet in Excel, with the left-most column (column 1) to write the ratio names, the second column from the left (column 2) to show the calculation of each ratio for Oracle Corporation, the second column from the right (column 3) to show the calculation of each ratio for Microsoft Corporation, and the right-most column (column 4) to include your DETAILED comments about each ratio and what the ratio tells you about each company under study. Calculate each of the following six ratios. Earnings per Share Current Ratio, Gross Profit Rate, Profit Margin Ratio, Inventory Turnover Ratio, and Days in Inventory (Average Age of Inventory).

Part 2

Prepare a four-column worksheet in Excel, column 1 to write the ratio names, column 2 to show the calculation of each ratio for Oracle Corporation, column 3 to show the calculation of each ratio for Microsoft Corporation, and column 4 to include your DETAILED comments about each ratio and what the ratio tells you about each company under study. Calculate each of the following six ratios. Receivable Turnover Ratio, Average Collection Period, Assets Turnover Ratio, Return on Assets, Ratio Debt to Total Assets Ratio, and Times Interest Earned Ratio

Part 3

Prepare a four-column worksheet in Excel, column 1 to write the ratio names, column 2 to show the calculation of each ratio for Oracle Corporation, column 3 to show the calculation of each ratio for Microsoft Corporation, and column 4 to include your DETAILED comments about each ratio and what the ratio tells you about each company under study. Remember to copy and paste the ratio calculations and interpretations from the first two parts of the project in this worksheet, in addition to calculating the following six ratios. Payout ratio, Return on Common Stockholders’ Equity Ratio, Free Cash Flow Current, Cash Debt Coverage ratio, Cash Debt Coverage ratio, and Price/Earnings Ratio [For the purpose of this ratio, use the market price per share on June 1, 2007 for each company].

ANSWERS AVAILABLE. 

Price of Answer: Just US$ 24 only (Instant Download)

ANSWERS PREVIEW: 

Buy Now

Need Assistance !! email us at caresolvemyquestion.com 

If you need any other type of help regarding Homework, Assignments, Projects,  Case study, Essay writing then email us at [email protected]solvemyquestion.com  We will get back to you very soon.

Ratio Analysis and Comparison for Exxon Mobil Corporation and Royal Dutch Shell plc

Ratio Analysis and Comparison for Exxon Mobil Corporation and Royal Dutch Shell plc in $15 Only
1) Need to choose two firms within the same industryRatio Analysis and Comparison

 

2) Go to each firm’s Web site, and then access and download their annual reports (financial statements).

3) Using the accounting data from the firms’ financial statements, calculate all ratios for each firm (liquidity ratios, activity ratios, profitability ratios, leverage ratios, and coverage ratio)

Liquidity Ratios

Current Ratio = Current Assets/Current Liabilities

Quick Ratio = Current Assets – Inventory/Current Liabilities