Financial analysis with microsoft excel

Assignment Help Finance Basics
Reference no: EM131478504

Financial Analysis with Microsoft Excel 7th Edition

Internet Problem 1

  1. Go to http://www.microsoft.com/Investor/EarningsandFinancials/TrendedHistory/AnnualStatements.aspx and download Microsoft's annual income statements from 1994 to the most recent year available. There is a direct link to the Excel file on that page.
  2. Reformat the worksheet so that it is suitable for a pivot table. This will require changing the year headings to actual dates, deleting any blank rows or columns, and then transposing the data.
  3. Create a pivot table that shows the net profit margin for each year and format it appropriately. This will require you to create a calculated field.
  4. Add a pivot chart that displays the results from part b over time.
  5. Filter the dates so that only the last five years area displayed in the pivot table and pivot chart. This will require a custom date filter using this "is after or equal to" option.
  6. How does Microsoft's net profit margin compare to the average of the company's in the S&P 500 Index? (  Hint: Use the date file from problem 5 to calculate this answer using the S&P 500 company date.xlsx workbook from the official website.)

 Please use a compatible excel workbook and include and linked formulas for each cell.

Reference no: EM131478504

Previous Q& A

  Shares of commonwealth bank of australia

Invest $4000 in the shares of Commonwealth Bank of Australia (listing code: CBA.AX) and $6000 in the shares of Myer Holdings Ltd (listing code: MYR.AX).

  Does your state lean republican or democrat

Describe your state. What are its major cities? Is it predominantly rural or urban? Does your state have important industry, finance, and tourist centers?

  Describe how credit risk embedded in corporate debt

Summarize three measures that the ISDA undertook to mitigate the credit risk inherent in OTC derivatives.

  Identify and assess the type of evidence

Identify and explain one argument (pro or con) related to the chosen issue; either summarize an existing argument or construct an original one.

  Describe the determinants of cva for both counter parties

Using a vanilla interest-rate swap, describe the determinants of CVA for both counter parties.

  Explain roles and responsibilities for compliance

Explain Roles and Responsibilities for Compliance. Analyze the various ethical issues a financial manager could potentially face and how these could be handled.

  Write a letter to your congressional representitive

Write a letter to your congressional representitive regarding a specific piece of legislative policy constituent service.

  Describe the circumstances leading to including cva

Describe the circumstances leading to including CVA in the Basel III Accord and how the CVA requirement might be expected to alleviate future problems.

  Analyze the major effects that relative interest

"Exchange Rate and Transaction and Translation Exposure"- Analyze major effects that relative interest and inflation rates could have on a country's currency.

  How the appraisal mechanism is tied to a job analysis

Performance management is a systematic process that entails planning work, setting expectations, monitoring outcomes, developing capability.

Reviews

Write a Review

 

Similar Q& A

  Prepare the cash budget for the specific

The business will continue to allow all of its customers one month's credit. It plans to increase inventories from the 30 June level by £1,000 each month until, and including, September. During the following three months, inventories levels will b..

  Good management information system

An organization does not have a good Management Information System (MIS) in place to help manage all of their data. What are some of the possible problems this could cause for decision makers?

  What is the firm market capitalization

What is the firm's Market Capitalization? What is the cost of the preferred stock?

  What were bertin total long-term debt in 2010

How much new long-term debt financing will be needed in 2011? (Hint: AFN - New stock = New long-term debt.) Round your answer to the nearest dollar.

  Explain how your selected company manages its portfolio of

1.discuss the types of real estate holdings your selected company selected company is coca cola has listed on its

  Amount of funds-lockbox arrangement

J-Mart, the nationwide department store chain, processes all its credit sales payments at its suburban Detroit headquarters.

  Objective type questions on payback period, npv and irr

Objective type questions on payback period, NPV and IRR and what is the internal rate of return on this project

  Discuss current strategy used by company and investments

Discuss current strategy (ies) used by the company/competitor and any relevant future investments required to support the business unit (s) strategy(ies) to achieve higher ROI and market position.

  Explain fannie mae

Explain Fannie Mae

  What would be the increase in the firm’s average balance

Dexter Instrument Company’s sales average $3 million per day. If Dexter could reduce the time between customers’ mailing their payments and the funds becoming collected balances by 2.5 days, what would be the increase in the firm’s average cash balan..

  Describe the forces of globalization

Describe the forces of globalization and its implications for the multinational firm. Interpret the operation of the international financial system, its current state, and challenges for the future.

  What is the expected return to a portfolio

What is diversification? - What is the expected return to a portfolio that is composed of a variety of financial assets?

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