Description
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.
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
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
See attached:)
a. Current ratio
FY 2015
Current assets
Current liabilities
Current ratio
17.936.397
16.431.496
1,09
b. Quick ratio
Current assets
Inventory
Current liabilities
Quick ratio
FY 2015
17.936.397,00
2.137.618
16.431.496,00
0,96
c. Debt equity ratio
FY 2015
30.082.501
17.647.329
1,70
Total debt
Shareholder's equity
Debt Equity ratio
d. Inventory turnover ratio
FY 2015
Cost of goods sold
Inventory
Inventory turnover ratio
21.841.676
2.137.618,00
10,22
e. Receivables turnover
FY 2015
27.234.521
Net credit sales
Acc. Receivables
Receivables turnover
2.529.368
10,77
f. Total asset turnover ratio
Net sales
Total assets
Asset turnover
FY 2015
27.234.521,00
47.729.830
0,57
g. Net profit margin
FY 2015
Net income
Net sales
2.307.904
27.234.521,00
Net margin
8,47%
h. Return on assets
Net income
Total assets
ROA
FY 2015
2.307.904,00
47.729.830,00
4,84%
Running head: FINANCIAL RATIOS IN BUSINESS DECISIONS
Financial Ratios in Business Decisions
Student’s Name
Institution
Date
1
FINANCIAL RATIOS IN BUSINESS DECISIONS
2
Financial Ratio Analysis
Introduction
Toyota Motor Corporation is an automotive manufacturer that assembles, manufactures,
models, and sells passenger vehicles, commercial vehicles, minivans, and related accessories and
parts. The company has its headquarters at Toyota City, Japan. Toyota was the first automobile
manufacturer globally to produce over 10 million vehicles annually. Toyota Motor Corporation
offers hybrid vehicles under Vitz, Corolla Sedan, Spade, Aygo, Porte, Voxy/Noah, RC300h,
NX300h, Fielder, Siena, Auris, Vellfire, Esquire, and Alphard among other widely known
brands. The company has its operations in Africa, Central, and South America, Asia, Japan,
Middle East, Oceania, Europe, and North America (Yahoo Finance, 2019). The purpose of this
paper is to analyze critical financial ratios using the company’s 2015 Annual Report and
establish why each ratio is significant in decision making.
Financial Ratios
i.
Current Ratio
This can be defined as a liquidity ratio that helps measure the ability of a company to
settle its short-term bills, debt obligations and those due within a year using the prevailing assets
of the company (R...