Financial Ratio Worksheet

# Financial Ratio Worksheet - 15% 1158/7731.5 (9) Return on...

This preview shows page 1. Sign up to view the full content.

Ratios to Compute Calculations #1 Calculations #2 (1) Current 1.554368.5/2824.7 .942313.0/2448.0 (2) Receivables turnover 21.5 24074.6/1119.75 4.58 11343.0/2475.0 (3) Average collection 16.98 365/21.5 79.7 365/4.58 period (in days) (4) Inventory turnover 219.06 24074.6/109.9 60.02 11343.0/189.0 (5) Days in inventory 1.67 365/219.06 6.08 365/60.02 (6) Profit margin 43.44% (24074.6-13616.1)/24074.6 33.60% (11343-7531)/11343 (7) Asset turnover 0.77 24074.6/(31975.2+30224.9)/2 1.47 11343.0/(8316.0+7147.0)/2 (8) Return on assets 16% 4946.3/31100.05
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 15% 1158/7731.5 (9) Return on common 33.80% 4946.3/14634.2 73.50% 1158/1576.0 stockholders equity (10) Debt to total assets 54% 17341.0/31975.2 81% 6740.0/8316.0 (11) Times interest earned 16.53 7451.2/450.9 9.17 1789/195 (12) Current cash debt 1.81 5365.5/(2924.7+2988.7)/2 0.83 1703/(2448.0+1653)/2 coverage (13) Cash debt coverage 0.31 5365.5/17341 0.25 1703/6740 (14) Free cash flow N/A N/A McDonalds (MCD) Calculated Ratios Yum! Brands Inc. (YUM) Calculated Ratios...
View Full Document

## This note was uploaded on 02/06/2012 for the course ACCTG 230 taught by Professor Pearson during the Fall '07 term at Washington State University .

Ask a homework question - tutors are online