Ten Principles of Economics and the Data of Macroeconomics
September 16, 2020
Module 2: Critical Thinking
September 16, 2020

Corporate Finance

Excluding the reference and the excel file, word count cannot exceed 1050,

Assignment Steps

Select a Fortune 500 Company from one of the following industries:

  • Pharmaceutical
  • Energy
  • Retail
  • Automotive
  • Computer Hardware

Review the balance sheet and income statement in the company’s 2015 Annual Report.

Calculate the following ratios using Microsoft® Excel®:

  • 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

Note: All ratios must be calculated using Excel. Show all data inputs. Show all calculations. You will not receive grading points for ratios not calculated in your Excel worksheet(s). Do not submit more than one Excel file. The best approach is to use one or more tabs for input financial statements and a separate tab for the ratios.

Analyze in 1,050 words why each ratio is important for financial decision making.

Submit your analysis as well as your calculations.

 

"Is this question part of your assignment? We Can Help!"