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

  Aretha has an agi of less than 100000 and a 25 percent

aretha has an agi of less than 100000 and a 25 percent marginal tax rate. during the year she reports a 36000 loss from

  What is the purpose and benefits of clustering data in a

a what is the purpose and benefits of clustering data in a file?b what is the code for creating a cluster and

  Describe amp explain three characteristics of payroll

describe amp explain three characteristics of payroll related taxes that make accounting for them so time consuming for

  Asset retirement obligation journal entries

Prepare the journal entries to record the depot (consider a plant asset) and the asset retirement obligation for the depot on Jan 1, 2012. Based on an effectieve-interest rate of 6% the fair value of the asset retirement obligation on Jan 1, 2012 ..

  Prepare classified statement of financial performance

Provide a Report to Management of X Limited Company giving advice based on your results from the ratios - Prepare classified Statement of Financial Performance

  Hope kessler would like to buy a new house and is saving up

hope kessler would like to buy a new house and is saving up money for a down payment. her savings account earns

  Everett miguel and ramona are partners sharing income 123

everett miguel and ramona are partners sharing income 123. after selling all of the assets for cash dividing losses on

  Calculate the effect on 2012 net profit

The general manager was confused because the company had a $9,000 profit, yet seemed, as noted above, $10,000 worse off in its cash position. Explain briefly how, in general, this difference between profit and cash change can happen.

  The net income reported on the income statement for the

the net income reported on the income statement for the current year was 210000. depreciation was 52000. accounts

  Ed koehler started great southern furniture five years ago

ed koehler started great southern furniture five years ago to assemble prefabricated bedroom furniture for large hotel

  If inventory costs are rising which method fifo lifo or

if inventory costs are rising which method fifo lifo or weighted average cost results in the highest net income? which

  Video toys manufacturers and sells arcade games dividends

video toys manufacturers and sells arcade games. dividends are currently 1.50 per share and are expected to grow at a

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