Posted: November 25th, 2022




Don't use plagiarized sources. Get Your Custom Essay on
Just from $13/Page
Order Essay

Financial Ratio Analysis Grading Guide

· Microsoft® Excel®

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

· 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

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

Submit your analysis as well as your calculations. 



Center for Writing Excellence


Reference and Citation Generator


Grammar and Writing Guides

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:

Order your essay today and save 30% with the discount code ESSAYHELP