Financial Ratio Analysis Two Parts Assignment Consisting of Excel Calculations and Word Document Report No Plagiarism

Question Description

I am currently in a graduate master's level course in "corporate finance" and since math has never been a strong point for me, was needing some help on a two-part assignment that consists of Excel Calculations to help show how you derive financial ratios and to write up a word document report of it consisting of both an introduction and conclusion in APA format, no plagiarism since it will be checked. Here are the following assignment details:

Purpose of Assignment

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

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

  • Pharmaceutical (This was one I was interested in to find a good Fortune 500 Company on).
  • Energy
  • Retail
  • Automotive
  • Computer Hardware

Review the balance sheet and income statement in the company's 2015 Annual Report. (Please include web links of both these reports).

Calculate the following ratios using Microsoft® Excel®:(Please help show how you derive these ratios step by step and explain on how to obtain the answer).

  • 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

Analyze in 1,050 words or more (excluding cover and reference page wording) why each ratio is important for financial decision making. (Include both an Introduction and a Conclusion) APA format and No Plagiarism...will be checked!

For references please include direct web link sources and use citations APA format.

Submit your analysis as well as your calculations.

Final Answer

Hey there, its me again :-) ...

Nyctutor (644)
Rice University

Thanks for the help.

Outstanding. Studypool always delivers quality work.

Tutor was very helpful and took the time to explain concepts to me. Very responsive, managed to get replies within the hour.


Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors