Calculate and compare the financial ratios

Assignment Help Accounting Basics
Reference no: EM13853073

Using the financial statements for Oracle Corporation and 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 two companies' performance based on your ratio calculations.

A completed worksheet profiles tab that contains a one-paragraph description regarding each company with information about their histories, what products they sell, where they are located, and so on.

All 16 ratios for each company, with the supporting calculations and commentary on your worksheet ratio tab. Supporting calculations must be shown either as a formula or as text typed into a different cell. The ratios are listed further down this document. 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 Conclusions worksheet tab is an overall comparison of how each company compares in terms of the major category of ratios described. A nice way to conclude is to state which company you think is the better investment and why.

The Bibliography worksheet tab must contain any other information you use to profile the companies should also be cited as a reference.

Here is the link for the financial statements for Oracle Corporation for the fiscal year ending 2011. First, select 2011 using the drop-down arrow labeled Year on the right-hand side of the page, and then select Annual Reports using the drop-down arrow labeled Filing Type on the left-hand side of the page.

You should select the 10k dated 6/28/2011 and choose to download in PDF, Word, or Excel format.

https://www.oracle.com/us/corporate/investor-relations/sec/index.html

Here is the link for the financial statements for Microsoft Corporation for the fiscal year ending 2011. You need to press the word Go on the left-hand side of the page. Then you should select the 10k dated 7/28/2011 and choose to download in Word or Excel format.

https://www.microsoft.com/investor/SEC/default.aspx?&


Required Ratios for the Project

Earnings per Share of Common Stock

Current Ratio

Gross Profit Margin

Rate of Return on Sales (Net Profit Margin)

Inventory Turnover

Days' Inventory Outstanding (DIO)

Accounts Receivable Turnover

Days' Sales Outstanding (DSO)

Asset Turnover

Rate of Return on Total Assets (ROA)

Debt Ratio

Times Interest Earned Ratio

Dividend Yield (For the purposes of this ratio, use Yahoo Finance to look up current dividend yield and stock price; just note the date that you looked up this information.)

Rate of Return on Common Stockholders' Equity (ROE)

Free Cash Flow

Price/Earnings Ratio (Multiple) (For the purpose of this ratio, for Oracle, use the market price per share on May 30, 2011 and for Microsoft, use the market price per share on June 30, 2011.)

Reference no: EM13853073

Questions Cloud

Phases of the database design process : The requirements collection and analysis phases of the database design process have provided the following data requirements for Big City Rentals, which rents out vehicles. Big City Rentals has several rental outlets. Each outlet has an outlet num..
Analyze changes in family relationships : This week, analyze changes in family relationships over the last 150 years. Consider the following aspects and their impact on adult careers and parenting: Variations in the types of families considered acceptable by society
Course is energy value chain : The course is Energy Value Chain. You are a consultant working for an advisory company that prepares concise reports for clients to "educate" senior managers in the respective clients' organizations about topics with which they are not familiar.
Start with an action-packed description of an experience : Start with an action-packed description of an experience that happened to you in the past several months. Maybe it happened this morning.
Calculate and compare the financial ratios : Calculate and compare the financial ratios listed further down this document for the fiscal year ending 2011 and prepare your comments about the two companies' performance based on your ratio calculations.
How would you investigate this situation to assess claims : In your essay, determine whether your aunt's and uncle's explanation, or your own suspicions, are valid. How would you investigate this situation to assess these claims
How acquisition relates to the strategic business goals : The decision to perform an acquisition is heavily influenced by how it relates to the strategic business goals of an organization.
Sequential search question : Derive an exact formula in n (not big O) for the average number of target-to-element comparisons for successful searches on an array of size n, assuming that all possibilities of successful match are equally like.Show your work
Linux-support skills : After completing the activities, take a screenshot of the following and copy onto this report. Linux+ Support skills: Editing Files in Linux

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd