Reference no: EM131386091
ASSIGNMENT
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
1) Select a Fortune 500 Company from one of the following industries:
• Pharmaceutical
• Energy
• Retail
• Automotive
• Computer Hardware
2) Reviewthe balance sheet and income statement in the company's 2015 Annual Report.
3) 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
4) Analyze in 1,050 words why each ratio is important for financial decision making.
Each type of ratio should have its own section in the paper: Section headings are required by APA.
Look at the ratios and make sure that they're appropriate. For example, a service company (e.g. FedEx, Yahoo) doesn't produce a product, so there is no inventory, thus an inventory turnover ratio would be meaningless, so that is why the list above is restricted. A company with little or no debt would have a debt-to-equity ratio that might not change much from year to year.
Put small tables for each category in the paper and discuss each set.
Like this:
|
Ratios
|
2015
|
|
|
|
X ratio
|
1.6
|
1.6
|
|
y ratio
|
1.94
|
1.94
|
|
z ratio
|
2.55
|
2.55
|
|
|
1.57
|
1.57
|
|
|
1.91
|
1.91
|
Or this:
Liquidity ratios
|
|
2015
|
|
Current ratio
|
Current Assets / Current liabilities
|
1.43
|
|
Quick ratio
|
Current asset - inventories / Current liabilities
|
1.37
|
DO NOT put huge tables in your paper as it is too hard to read and will cause you to lose points.
Here's a list of the ratios from the textbook:
SHORT-TERM SOLVENCY RATIOS
Current ratio = Current assets ÷ Current liabilities
Quick ratio = (Current assets - Inventory) ÷ Current liabilities
Cash ratio = Cash ÷ Current liabilities
FINANCIAL LEVERAGE RATIOS
Total debt ratio = Total debt ÷ Total assets = (Total assets - Total equity) ÷ Total assets
Debt-equity ratio = Total debt ÷ Total equity
Equity multiplier = Total assets ÷ Total equity = 1 + debt-equity ratio
Times interest earned = Earnings before interest and taxes ÷ Interest
Cash coverage = (Earnings before interest and taxes + depreciation + amortization) ÷ Interest
TURNOVER RATIOS
Inventory turnover = Cost of goods sold ÷ Inventory
Days sales in inventory = 365 ÷ Inventory turnover
Receivables turnover = Sales ÷ Receivables
Days' sales in receivables= 365 ÷ Receivables turnover
Total asset turnover = Sales ÷ Total assets
Days in inventory = Days in period ÷ Inventory turnover
PROFITABILITY MEASURES
Profit margin = Net income ÷ Sales
Return on assets = Net income ÷ Total assets
Return on equity = Net income ÷ Total equity
EBITDA margin = EBITDA ÷ Sales
MARKET VALUE RATIOS
Price-to-earnings ratio = Market price per share ÷ Earnings per share
Market-to-book ratio = Market price per share ÷ Book value per share
Market capitalization = Market price per share x Shares Outstanding
Enterprise Value (EV) = Market capitalization + Market value of interest bearing debt - cash
EV Multiple = EV ÷ EBITDA
|
Differences between the outsourcing phenomena
: What is "skill premium"? What happened to the size of the skill premium over the last 30 years in the U.S.? Is the trend related to production outsourcing? Justify your answers.
|
|
What influences the impact on expenditure
: How do matching categorical grants compare with categorical lump sum grants? Which type of grant has the greatest impact on expenditure? What influences the impact on expenditure? Be sure to draw the appropriate graphs and give examples.
|
|
Give the answer of muliple choice question
: Which of the following statements is true about scenario planning?The purely rational model of decision making is rarely practiced in reality because it: Which of the following is an observation from organizational behavior that contradicts the rati..
|
|
Calculate cost of goods sold gross profit and total expenses
: Calculate Cost of goods sold, Gross profit, Total expenses, Net profit and Average inventory at cost, assuming that sales are distributed evenly over the year, and that each month is of the same length.
|
|
Why given ratio is important for financial decision making
: Analyze in 1,050 words why each ratio is important for financial decision making. Each type of ratio should have its own section in the paper: Section headings are required by APA.
|
|
What are the equilibrium quantities in this market
: (a) What are the equilibrium quantities in this market? (b) What is the equilibrium price? (c) Suppose Firm 2 is shut down. What will Firm 1's new quantity be?
|
|
How many literals appear in your minimized solutions
: (Boolean Simplification) Use Karnaugh maps (K-maps) to simplify the following functions in sum-of-products form. How many literals appear in your minimized solutions?
|
|
Economies of scale in production of government goods
: “Unless there are economies of scale in the production of government goods and services, they should always be provided by the smallest available government units (that is, the lowest-level government in a federal hierarchy.)”
|
|
Give the answer of muliple choice question
: When an inexperienced and unskilled employee is placed in work environment, he learns and acquired new knowledge and skill. In this situation one of the SECI processes has implemented that process is:Arrange the 7-tier technical layers in ascending..
|