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

  Steve and karen are partners sharing profits and losses in

steve and karen are partners sharing profits and losses in ratio of 21.from april 12008they decided to share the

  Access the internet to acquire a copy of the most recent

access the internet to acquire a copy of the most recent annual report for the publicly traded company used to complete

  Management at breaker corp expects an accounts receivable

management at breaker corp. expects an accounts receivable collection pattern of 80 percent in the month of sale 15

  Kristen deposits 5000 in the bank today shewill be earning

kristen deposits 5000 in the bank today. shewill be earning 6 interest annually on her deposit. how much moneywill she

  Debit to ordinary share dividends distributable

Debit to Ordinary Share Dividends Distributable

  Benton company bc has one owner who is in the 35 federal

benton company bc has one owner who is in the 35 federal income tax bracket. bcs gross income is 320000 and its

  Natural hair company supplies wigs and hair care products

natural hair company supplies wigs and hair care products to beauty salons throughout texas and the southwest. the

  Calculate the time value of money

In today's world, there are many ways to calculate the time value of money. Your assignment is to search the internet to find a website that provides a financial calculator which allows you to calculate present value and future value.

  Abbey is much more creditworthy and has various line

Abbey is much more creditworthy and has various line

  Manning co manufactures and sells trophies for winners of

manning co. manufactures and sells trophies for winners of athletic and other events. its manufacturing plant has the

  Suppose that the annual costs of hosptial for aids patients

suppose that the annual costs of hosptial for aids patients is as follow a single payment of 10 thousand for materials

  Assume that all sales are made on a credit basis that the

search for avon products inc. access the 10-k filing for the most recent fiscal year. search or scroll to find the

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