Using the financial statements for Oracle Corporationand Microsoft Corporation, respectively, you will calculate and compare the financial ratios listed further down this document
for the fiscal year ending 2011 and prepare your comments about the liquidity, solvency and profitability of the two companies based on your ratio calculations
1.69 1.97 73535 2.2089215980775005 1385434 1.5214050084117774 33290 910628 24982 0.33972938056707691 2053137 0.38748172182140872 73535 5298668 8574 0.11659753858706738 435994 8.22836984691247E 2 73535 5298668 3523 6.2927007885970471E 2 3245531 5.8360159030139123 55985.5 556121 365 5800.3711325574795 365 62.542667132127228 6.2927007885970471E 2 5.8360159030139123 495592 14.422466351400509 5298668 12.243569643564792 34362.5 432771.5 365 365 25.30773801836995 365 29.811567265584483 14.422466351400509 12.243569643564792 495592 0.60007313358017933 5298668 1.4497535483429667 825886 3654875 53475 6.4748645696863727E 2 435994 0.11929108382639625 825886 3654875 185762 0.22160771228528106 2914692 0.79310677923533157 838247 3675031 64422 265.11111111111109 761590 8.4191733271426834 243 90459 17825 0.33333333333333331 263403 0.60414363500415147 53475 435994 53475 8.3083771280748564E 2 435994 0.78537453964439696 643627.5 555141.5 36625 36625 676022 0 676022 75281 1.3128079032497144 1065749 0.97737477302323872 57343.5 1090420 75281 0.41304520776808762 1065749 0.34381955739098213 182258.5 3099733.5 27.38 28.821052631578947 35.79 18.167512690355331 0.95 1.97 As given in the income statement Current ratio Current assets Current liabilities = Gross Profit Ratio Profit margin ratio Net income Inventory Turnover Average Inventory Days in Inventory 365 days Inventory turnover days Receivable Turnover Ratio Average Collection Period Assets Turnover Ratio Return on Assets Ratio Debt to Total Assets Ratio Times Interest Earned Ratio Net credit sales Average Net Receivables Net Income Average Total Assets Net Sales Total Liabilities Total Assets Interest Expense Net Income + Int Expense + Tax Expense Payout ratio Return on Common Stockholders’ Equity Free cash flow Cash debt coverage ratio Price/Earnings ratio Current cash debt coverage ratio Cash dividend declared on common stock Net income Preferred stock…
Attachments:
Project Templ….xlsx