User Account

All Pages

Financial statement analysis project

Assignment Help Financial Management
Reference no: EM13862143

Financial Statement Analysis Project-A Comparative Analysis of Oracle Corporation and Microsoft Corporation

The financial statements for Oracle Corporation for the fiscal year ending 2014. First, select 2014 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.

A sample project template is available for download in Doc Sharing. The sample project compares the ratio performance of Tootsie Roll and Hershey using the 2012 financial statements of Tootsie Roll and Hershey provided at their websites.

Description

This course contains a Course Project.

You will be required to submit one draft of the project at the end of Week 5 and the final, completed project at the end of Week 7.

Using the financial statements for Oracle Corporation and Microsoft Corporation, respectively, you will calculate and compare the financial ratios listed further down this documentfor the fiscal year ending 2014 and prepare your comments about the two companies'performance based on your ratio calculations.

The entire project will be graded by the instructor at the end of the final submission in Week 7, and one grade will be assigned for the entire project.

Overall Requirements

For the Final Submission

Your final Excel workbook submission should contain the following items. You cannot use any software but Excel to complete this project.

1. A completed worksheet title page tab, which is really a coversheet with your name, the course, the date, your instructor's name, and the title for the project.

2. 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.

3. 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.

4. The Summary and Conclusions worksheet tab is an overall comparison of how each company compares in terms of the major category of ratios described in Chapter 13 of your textbook. A nice way to conclude is to state which company you think is the better investment and why.

5. The Bibliography worksheet tab must contain at least your textbook as a reference. Any other information you use to profile the companies should also be cited as a reference.

Required Ratios for Final Project Submission

1. Basic Earnings per Share of Common Stock
2. Current Ratio
3. Gross Profit Margin
4. Rate of Return on Sales (Net Profit Margin)
5. Inventory Turnover
6. Days' Inventory Outstanding (DIO)
7. Accounts Receivable Turnover
8. Days' Sales Outstanding (DSO)
9. AssetTurnover
10. Rate of Return on Total Assets (ROA)
11. Debt Ratio
12. Times Interest Earned Ratio
13. 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.)
14. Rate of Return on Common Stockholders' Equity (ROE)
15. Free Cash Flow
16. Price/Earnings Ratio (Multiple)(For the purpose of this ratio, for Oracle, use the market price per share on May 30, 2015 and for Microsoft, use the market price per share on June 30, 2015.)

Attachment:- Comparing_Tootsie.xlsx

Reference no: EM13862143

Questions Cloud

What did you learn about your peers in the class : What did you learn about yourself through the process of learning about learning? What did you learn about your peers in the class through the process of learning about learning
Perform a variance analysis of the massage chairs : Spine Line and you plan to perform a variance analysis of the massage chairs manufactured to determine if the standards are being met.
Strategies for managing developmental crises in school : Strategies for Managing Developmental Crises in Schools - Transitioning from elementary into middle school, from middle school into high school, and from high school into postsecondary opportunities represents highly stressful and potentially trau..
Hypotheses regarding the relationship between drug use : hypotheses regarding the relationship between drug use and the causes of drug-related crime
Financial statement analysis project : Financial Statement Analysis Project -A Comparative Analysis of Oracle Corporation and Microsoft Corporation
Indicate how and why you think they may be impacted : Choose one of the following scenarios and imagine you have been asked to respond to the crisis with some form of intervention. For your chosen scenario: Identify all of the people who may be impacted by this crisis, whether directly or indirectly. ..
Beaver creek pottery company is a small crafts operation : Beaver Creek Pottery Company is a small crafts operation run by a Native American tribal council. The company employs skilled artisans to produce clay bowls and mugs. The three primary resources used by the company are special pottery clay, dryer mac..
Produce screwdriver handles commercially : Identify three things that could be significantly improved in the sand mold design if our intent was to produce screwdriver handles commercially. Explain what would be improved for each thing you identify.
Summary of the benefits of high-quality programs : A summary of the benefits of high-quality programs for young children and their families. At least three research-based components that contribute to quality programming

Reviews

Write a Review

Financial Management Questions & Answers

  Interest earned on the sinking fund in the third year

Copernicus borrows $L and repays the principal by making ten annual payments at the end of the year into a sinking fund which earns an annual effective rate of 8%. The interest earned on the sinking fund in the third year is $85.57. Determine L.

  What fraction of payment made at end of second year

Your company is planning to borrow $1.5 million on a 7-year, 8%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal?

  Explain bmws claim that under the new bonus program

Explain BMW's claim that under the new bonus program, "upper-level management could potentially lose more money than their lower-level counterparts for bad performance."

  What is the after-tax return on municipal bonds

Municipal bonds are currently offering investors a 6% return and corporate bonds with the same maturity and default risk are offering investors an 8% return. What is the after-tax return on municipal bonds for an investor in the 30% tax bracket?

  Development life-cycle of organizations

Stage 5 of "The Development Life-Cycle of Organizations" is known as

  The first financial statement firm produces

The first financial statement a firm produces is the _____.

  What is the expected return on the mutual fund

Consider the following capital market: a risk-free asset yielding 0.75% per year and a mutual fund consisting of 70% stocks and 30% bonds. The expected return on stocks is 10.75% per year and the expected return on bonds is 3.25% per year. The standa..

  Outstanding student loan with required payments

You have an outstanding student loan with required payments of $600 per month for the next four years. The interest rate on the loan is 9% APR (compounded monthly). Now that you realize your best investment is to prepay your student loan, you decide ..

  Depreciation expense and interest expense

Hamble, Inc., has sales of $19,070, costs of $10,460, depreciation expense of $2,530, and interest expense of $1,600. If the tax rate is 35 percent, what is the operating cash flow, or OCF?

  Research and analyze the global equity and bond markets to

research and analyze the global equity and bond markets to create an faq sheet that could be given to prospective

  Determine which has a higher roi

You will make a variety of decisions. You should consider the financial and nonfinancial aspects while making decisions - evaluate scenarios, you will also use some tools such as net present value (NPV) and return on investment (ROI) that you have d..

  Determine the net present value for the project

Dennison, Texas cell-phone giant Cellular Two is evaluating a proposal to manufacture and sell digital phones in Great Britain. The project will require an initial investment of £200 million to acquire and recondition the manufacturing plant in Manch..

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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