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

Anonymous
timer Asked: May 22nd, 2018
account_balance_wallet $10

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.

Tutor Answer

Nyctutor
School: Rice University

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

flag Report DMCA
Review

Anonymous
Excellent job

Similar Questions
Related Tags

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