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

User Generated

NQZ0525

Mathematics

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

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


Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags