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 of L.S. Starrett Company (NYSE: SCX)

Research the company L.S. Starrett Company and search its corporate website and find its financial  statements then calculate the past three year’s worth of financial ratios. You will need to calculate all of the  Liquidity and Asset Management ratios, Total debt to total assets ratio, all of the Profitability ratios, the P/E and M/B ratio.

Answer available.

Price of Answer: Just US$10 only
Buy Now

Need Assistance…??  email us at [email protected].

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or any thing else then just email us at [email protected]solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

FIN200

Final Project Overview in $50 Only

FIN200

As students of finance and potential investors, you can estimate the financial health and profitability of a company using financial ratios and other industry tools. The tools and skills practiced in this course can be used to help you determine whether or not to invest money in a company. Research into the financial health of the company can help make the decision.

In the final project, you compute corporate performance ratios and compare them to industry averages. You also study portions of the company’s annual report to analyze the company’s operating and cash cycles, long-term debt, and cost of capital. Finally, you summarize your conclusions in an analysis from an investor perspective. Please summarize and explain the project listed in the syllabus here.

Final Project Timeline

Financial Management: Unit 3 Individual Project

Assignment Name:               Unit 3 Individual Project
Deliverable Length:              2 pages

By walking through a set of financial data for XYZ, this assignment will help you better understand how theoretical stock prices are calculated and how prices may react to market forces such as risk and interest rates. You will use both the CAPM (capital asset pricing model) and the constant growth model (CGM) to arrive at XYZ’s stock price.

To receive full credit on this assignment, please show all work, including formulae and calculations used to arrive at financial values.

Assignment Guidelines:

  • Find an estimate of the risk-free rate of interest (krf). To obtain this value, go to Bloomberg.com: Market Data and use the “U.S. 10-year Treasury” bond rate (middle column) as the risk-free rate. In addition, you also need a value for the market risk premium. Use an assumed market risk premium of 7.5%.
  • Download the XYZ Stock Information by clicking the link.
  • Using the information from the XYZ Stock Information document, record the following values:
    • XYZ’s beta (ß)
    • XYZ’s current annual dividend
    • XYZ’s 3-year dividend growth rate (g)
    • Industry P/E
    • XYZ’s EPS