Financial Ratio Analysis Two Parts Assignment Consisting of Excel Calculations and Word Document Report No Plagiarism
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.