fbpx

Microsoft Versus Google (Top Class) | Online Assignment Help

 Perform a financial statement comparative analysis between Microsoft and Google. Answers should show all calculations using Excel and be thoroughly discussed.

Don't use plagiarized sources. Get Your Assignment on
Microsoft Versus Google (Top Class) | Online Assignment Help
Just from $13/Page
Order Now

 

Required Reading:

2016 R June Financial Statement Analysis Power Point with notes

2016 July DMBA R Sample Week 3 Answer

*”Research Starters: Financial Ratios” posted in this week’s Content Module

Required Multimedia:

The Cash Flow Statement http://www.youtube.com/watch?v=-eietCf5nNI&feature=related

Cash Flow Ratios http://www.youtube.com/watch?v=vzdNgaPhBMQ&feature=PlayList&p=84588A1A1F1F96D1&index=15

Market Ratios  http://www.youtube.com/watch?v=K1WmGQLIwTY&feature=related

Recommended Support Materials:

For a “how to” explanation of Financial Statement Analysis: see the attached Power Point file 2016 R June Financial Statement Analysis and the Word file, “Diagram of Financial Ratios.”

Assignment Financial Statement Analysis:

Your team has been assigned to the CEO of a major company.  The CEO keeps an eye on the competition, and asks your team to do the following:  Following the 2016 R DMBA Sample Week 3 Answer, research current year data for two selected firms, and use ratio analysis to compare these two major competitors in the same industry and compare them to the most current data for industry ratios.  The sample compares Southwest Airlines Company with Jet Blue Airline Company.

Instructions:

  • Pick any two U.S. public companies in the same industry.
  • One of the two companies can be the same company someone on the team used in Week 2.
  • Select the 10 most important financial ratios for the two companies and calculate each for the last 2 fiscal years using Excel.
  • Follow the format of the example 2016 July DMBA R Sample Week 3 Answer for 2 airlines.  This is also separately posted in this week’s content module. Use the “Compare” worksheet. Note: It is not necessary to complete all ratios
  • Explain how each ratio was calculated in your own words
  • Explain the significance of the answers found.
  1. Create a single Excel file for your entire assignment.
  2. The team may obtain financial information and the companies’ latest annual reports on the web directly from the Securities and Exchange Commission for the company website.  MSN Money or Yahoo Finance also have information but in some situations it may be incomplete.  Current stock price information is not available from the SEC web site.
  3. The team should calculate, and comment upon, at least 10 financial ratios for the last 2 fiscal years.
  4. All calculations should be shown, and all answers should be thoroughly explained.
  5. It is useful to compare financial ratios for a company with financial ratios of its industry. Industry financial ratios can be found on Morningstar.com, Yahoo Finance and MSN Money and http://www.bizstats.com/corporations.asp?profType=ratios
  6. Whenever the team uses balance sheet items to calculate ratios, it is more accurate to average the beginning-of-year and end-of-year amounts to get the average for that year.  Dec 31, 2014 and Dec 31, 2015 would be beginning and end of year for 2015.  Note: Averaging is NOT required.  For some students taking averages leads to calculation mistakes.  The example answer does not use averaging and includes most if not all possible ratios.
  7. What can the team tell from the analysis?  What are the strengths and weaknesses of each company?   Which is the stronger competitor? Give reasons.
  8. Show  that you have read and understood the required readings, links and attached files – cite and reference them where appropriate.
  9. The final Excel file should be submitted by one  team member into the Group Assignment folder.

The 2016 R DMBA Week 3 sample answer file contains a comprehensive analysis of  the financial statements of two large airline companies. It illustrates and explains how different companies succeed by focusing on different key ratios like Net Income/Sales, or Sales/Total Assets (asset turnover) or Total Assets/Common Equity (leverage).  Also, it further explains how these different strategies are revealed through DuPont Analysis (a powerful technique that many companies use to devise, implement, and monitor their business strategies. It shows the source for every number on every Excel worksheet: just click on any number in any Excel worksheet and you will see where it comes from. Showing the source for every number on every Excel worksheet is very important and helpful to readers, and you should do this on all of your Excel spreadsheets.

All of the data in the example comes from SEC interactive data.  Under the company name in interactive data is a small red link that says view excel document.  All numbers in this document are easy to use in calculations.  Data copied from some other sources may not calculate correctly in Excel.

These assignments are designed to help you to develop your analytical ability and your ability to explain your analysis in words. There are many uses for financial statement ratio analysis, especially in business strategy – for an example, see the “Strategic Control Map” developed by McKinsey & Company, the well-known international strategy consulting firm by clicking here:

http://www.mckinsey.com/business-functions/strategy-and-corporate-finance/our-insights/enduring-ideas-the-strategic-control-map

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

At Myhomeworkwriters.com, we always aim at 100% customer satisfaction. As such, we never compromise o the quality of our homework services. Our homework helpers ensure that they craft each paper carefully to match the requirements of the instruction form.

Professional Academic Writers

With Myhomeworkwriters.com, every student is guaranteed high-quality, professionally written papers. We ensure that we hire individuals with high academic qualifications who can maintain our quality policy. These writers undergo further training to sharpen their writing skills, making them more competent in writing academic papers.

Affordable Prices

Our company maintains a fair pricing system for all academic writing services to ensure affordability. Our pricing system generates quotations based on the properties of individual papers.

On-Time delivery

My Homework Writers guarantees all students of swift delivery of papers. We understand that time is an essential factor in the academic world. Therefore, we ensure that we deliver the paper on or before the agreed date to give students ample time for reviewing.

100% Originality

Myhomeworkwriters.com maintains a zero-plagiarism policy in all papers. As such, My Homework Writers professional academic writers ensure that they use the students’ instructions to deliver plagiarism-free papers. We are very keen on avoiding any chance of similarities with previous papers.

Customer Support 24/7

Our customer support works around the clock to provide students with assistance or guidance at any time of the day. Students can always communicate with us through our live chat system or our email and receive instant responses. Feel free to contact us via the Chat window or support email: support@myhomeworkwriters.com.

Try it now!

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Homework Writing Services

My Homework Writers holds a reputation for being a platform that provides high-quality homework writing services. All you need to do is provide us with all the necessary requirements of the paper and wait for quality results.

Essays

Essay Writing Services

At My Homework Writers, we have highly qualified academic gurus who will offer great assistance towards completing your essays. Our homework writing service providers are well-versed with all the aspects of developing high-quality and relevant essays.

Admissions

Admission and Business Papers

With Myhomeworkwriters.com, we will help you secure a position at your desired institution. Our essay writing services include the crafting of admissions papers. We will still help you climb your career ladder by helping you write the official papers that will help you secure a job. We will guide you on how to write an outstanding portfolio or resume.

Editing

Editing and Proofreading

Myhomeworkwriters.com has a professional editorial team that will help you organize your paper, paraphrase it, and eliminate any possible mistakes. Also, we will help you check on plagiarism to ensure that your final paper posses quality and originality.

Coursework

Technical papers

My Homework Writers harbors professional academic writers from diverse academic disciplines. As such, we can develop homework writing services in all academic areas. The simplicity or complexity of the paper does not affect the quality of homework writing services.