Financial Ratio

Financial Ratio

 

The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions.

Assignment Steps

Use the Fortune 500 Company listed below for this assignment:

  • Retail – Walmart
  •  
  •  
  • STEP 1 (SUBMIT AS AN EXCEL SPREADSHEET)

Review the balance sheet and income statement in the company’s 2015 Annual Report (see links below).

Calculate the following ratios using Microsoft® Excel® . Make sure you show your work as no work equates to no credit.

  • Current Ratio
  • Quick Ratio
  • Debt Equity Ratio
  • Inventory Turnover Ratio
  • Receivables Turnover Ratio
  • Total Assets Turnover Ratio
  • Profit Margin (Net Margin) Ratio
  • Return on Assets Ratio

STEP 2 (SUBMIT AS A WORD DOCUMENT IN APA FORMAT)

Explain why each ratio is important for financial decision making for your chosen company. Make sure you incorporate your final answers within your discussion and include introduction and conclusion paragraphs that are separate from the body of the paper.

Minimum required references include your textbook and your chosen firm’s webpage for their 2015 Annual Report (see below).

The textbook reference is as follows:

Ross, S., Westerfield, R., Jaffe, J. & Jordan, B. (2016). Corporate finance (11th edition). New York, N.Y. McGraw-Hill Education.

The 2015 Annual Report reference is as follows:

Walmart. (2015). Annual Report. Retrieved from https://s2.q4cdn.com/056532643/files/doc_financials/2015/annual/2015-annual-report.pdf

Support