Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Calculate the following ratios for the past 5 years using the information below. Company Growth Sales Revenue Total Profits Liquidity Ratios: Current Ratio Quick Ratio

Calculate the following ratios for the past 5 years using the information below. image text in transcribed
image text in transcribed
image text in transcribed
Company Growth Sales Revenue Total Profits Liquidity Ratios: Current Ratio Quick Ratio Asset Management Ratios: Inventory Turnover Days Sales in Inventory Days Sales In Receivables Debt Management Ratio: Total Debt Ratio Times Interest Earned Ratio Profitability Ratios: Net Profit Margin Return on Assets Return on Equity (635,765) 10,717,160 1.4 (350.918) 7,980,789 1.4 (249.694) 7,571,885 1.4 (142.674) 7.204,189 1.5 (36372) 6,676,684 15 252.082 6,532.083 1.4 430,832 6,057,895 1.4 478,093 5,741.241 1.4 1,028 330 5.494,174 15 1,029,861 5,031,950 104.6 % 105.7% 106.0 % 105.7% 99.1 % 94.6 % 86,6% 84.7% 64.4 % 443 % SELECT BALANCE SHEET AND CASH FLOW DATA: Working capital ($) (1) Total assets ($)() Inventory turnover (cyk) Accounts payable to inventory (CD) Current portion of long-term debt and short-term debt ($) Long-term debt, less current portion (S ) Shareholders' equity $)a) Cash provided by operating activities (m) Capital expenditures (S) Free cash flow ($) ( m n ) 25 67 222 662 1,431 3.890,527 397340 3,417,1222,978,390 3 53.667 653,046 1,887,019 1.627.136 1.390,018 1.961.314 1,388,397 2018,418 1,386,828 1,087,789 1.9663212.108 307 7 90,585 2.844.851 357,273 3.209,685 1,708,479 628,057 1.0206-19 1,727,555 504,268 1.188.584 1,403,687 465,940 8 89,059 1.510,713 476,344 978375 1,345,488 414,020 868 390 1,190,430 429,987 761.443 908,026 395.881 S12145 1.251.355 300,719 950.836 1.118.991 328,319 7 90.672 703,687 365,419 338 268 10,149,985 9,536,28 8,977,726 8.593,096 7966,674 7216,081 6,649.237 6,182,184 9.788.816 5,397,525 4.755.2944496,462 5,394,691 5,039,966 4.257,043 4,720,683 4,084,085 4.509,011 3.804,0313.507,180 4.162.683 3,708,901 3,280,236 3,369,001 3,084,766 3,097,418 2.951.467 2.837349 2.776,533 2,620,992 3,473,966 3.224,782 2.995.283 2.809,805 2,648,622 2,438,527 2.265,516 2.120,025 1,973,381 1,887,316 2,798) 1.920,726 1,815,184 1,725,400 1,699,206 1,514,021 1.270,374 1,103,485 977,393 866,766 20,900 712,776 (21,626) (4.237) INCOME STATEMENT DATA: Sales ($) Cost of goods sold, including warehouse and distribution expenses Gross profit Sellingeneral and administrative expenses Fort CSK otticer clawback Legacy CSK Department of Justice investigation charge Operating income Write florasset-based revolving credit agreement debt issuance costs Termination of interest rate swap agrements Gain on settlement of note receivable Other income (expense), net Total other income (expense) Income before income taxes Provision for income taxes lab Net income (S) (b) Basic aming per C OR share: Famines per share-basic $) Weighted average common shares outstanding-basic Earnings per C R Share S ing dition: (a) (b) Earnings per shere- assuming dilation (S) Weichted average common shares outstanding- assuming dilution (130,397) (1.30,397) 1,790,329 (121,097) (121,097) 1,694,087 (87,596) (87,596) 1.637,804 (62.015) (62.015) 1.637,191 (53.655) (53,655) 1.460,366 (48,192) (48,192) 1.222.182 (44,543) (44,5-3) 1.058.942 (35.872) (35,872) 941.521 (25.130) (50,993) 815,773 11 639 35.042) (23.403) 689,373 399,287 369,600 1.391.0-421.324,487 504.000 1.133.804 599 500 1,037,691 529,150 9 31,216 444,000 7 78,182 388,650 670,292 355,775 $85.746 308,100 507.673 270,000 419,373 18.07 1627 1282 1 082 9 22 2 46 614 483 377 302 76985 81.406 88,426 95,447 99 965 104.262 109.244 121.182 134.667 138.654 1788 16.10 12.67 10.73 9.17 734 6.03 4 .75 3.71 2.95 77.788 2280 89.502 96,720 101.514 106,041 111101 123.314 136,983 141.992 81,223 78.882 75.552 74.580 71,621 67.569 61,909 53,063 49.324 46,858 5460 5.2195 ,019 4,829 4,571 4.366 4.166 3,570 3,976 3,976 3.740 3,740 5.09 52195,019 4,829 4.571 4366 4,166 3.570 SELECTED OPERATING DATA: Number of Team Members al year end is) Total number of stores at year end (de) Number of US stores a year end (d) Number of Mexico stores al year end (e) Store square footage at year end (CHI) Sales per weighted average store ($)(X) Sales per weighted average square foot (S) (XD) (h) Percentage increase in comparable store sales (ci) 40,227 38,455 36,685 31.591 30,077 28.628 33,148 1,769 1881 1.842 251 38% 35,123 1,826 251 4.8% 1,807 248 1.4% 285 1.678 232 6.0% 1,614 224 46% 26,530 1.566 221 46% 1.590 224 35% 25,315 1,527 216 88% 40% 75% Company Growth Sales Revenue Total Profits Liquidity Ratios: Current Ratio Quick Ratio Asset Management Ratios: Inventory Turnover Days Sales in Inventory Days Sales In Receivables Debt Management Ratio: Total Debt Ratio Times Interest Earned Ratio Profitability Ratios: Net Profit Margin Return on Assets Return on Equity (635,765) 10,717,160 1.4 (350.918) 7,980,789 1.4 (249.694) 7,571,885 1.4 (142.674) 7.204,189 1.5 (36372) 6,676,684 15 252.082 6,532.083 1.4 430,832 6,057,895 1.4 478,093 5,741.241 1.4 1,028 330 5.494,174 15 1,029,861 5,031,950 104.6 % 105.7% 106.0 % 105.7% 99.1 % 94.6 % 86,6% 84.7% 64.4 % 443 % SELECT BALANCE SHEET AND CASH FLOW DATA: Working capital ($) (1) Total assets ($)() Inventory turnover (cyk) Accounts payable to inventory (CD) Current portion of long-term debt and short-term debt ($) Long-term debt, less current portion (S ) Shareholders' equity $)a) Cash provided by operating activities (m) Capital expenditures (S) Free cash flow ($) ( m n ) 25 67 222 662 1,431 3.890,527 397340 3,417,1222,978,390 3 53.667 653,046 1,887,019 1.627.136 1.390,018 1.961.314 1,388,397 2018,418 1,386,828 1,087,789 1.9663212.108 307 7 90,585 2.844.851 357,273 3.209,685 1,708,479 628,057 1.0206-19 1,727,555 504,268 1.188.584 1,403,687 465,940 8 89,059 1.510,713 476,344 978375 1,345,488 414,020 868 390 1,190,430 429,987 761.443 908,026 395.881 S12145 1.251.355 300,719 950.836 1.118.991 328,319 7 90.672 703,687 365,419 338 268 10,149,985 9,536,28 8,977,726 8.593,096 7966,674 7216,081 6,649.237 6,182,184 9.788.816 5,397,525 4.755.2944496,462 5,394,691 5,039,966 4.257,043 4,720,683 4,084,085 4.509,011 3.804,0313.507,180 4.162.683 3,708,901 3,280,236 3,369,001 3,084,766 3,097,418 2.951.467 2.837349 2.776,533 2,620,992 3,473,966 3.224,782 2.995.283 2.809,805 2,648,622 2,438,527 2.265,516 2.120,025 1,973,381 1,887,316 2,798) 1.920,726 1,815,184 1,725,400 1,699,206 1,514,021 1.270,374 1,103,485 977,393 866,766 20,900 712,776 (21,626) (4.237) INCOME STATEMENT DATA: Sales ($) Cost of goods sold, including warehouse and distribution expenses Gross profit Sellingeneral and administrative expenses Fort CSK otticer clawback Legacy CSK Department of Justice investigation charge Operating income Write florasset-based revolving credit agreement debt issuance costs Termination of interest rate swap agrements Gain on settlement of note receivable Other income (expense), net Total other income (expense) Income before income taxes Provision for income taxes lab Net income (S) (b) Basic aming per C OR share: Famines per share-basic $) Weighted average common shares outstanding-basic Earnings per C R Share S ing dition: (a) (b) Earnings per shere- assuming dilation (S) Weichted average common shares outstanding- assuming dilution (130,397) (1.30,397) 1,790,329 (121,097) (121,097) 1,694,087 (87,596) (87,596) 1.637,804 (62.015) (62.015) 1.637,191 (53.655) (53,655) 1.460,366 (48,192) (48,192) 1.222.182 (44,543) (44,5-3) 1.058.942 (35.872) (35,872) 941.521 (25.130) (50,993) 815,773 11 639 35.042) (23.403) 689,373 399,287 369,600 1.391.0-421.324,487 504.000 1.133.804 599 500 1,037,691 529,150 9 31,216 444,000 7 78,182 388,650 670,292 355,775 $85.746 308,100 507.673 270,000 419,373 18.07 1627 1282 1 082 9 22 2 46 614 483 377 302 76985 81.406 88,426 95,447 99 965 104.262 109.244 121.182 134.667 138.654 1788 16.10 12.67 10.73 9.17 734 6.03 4 .75 3.71 2.95 77.788 2280 89.502 96,720 101.514 106,041 111101 123.314 136,983 141.992 81,223 78.882 75.552 74.580 71,621 67.569 61,909 53,063 49.324 46,858 5460 5.2195 ,019 4,829 4,571 4.366 4.166 3,570 3,976 3,976 3.740 3,740 5.09 52195,019 4,829 4.571 4366 4,166 3.570 SELECTED OPERATING DATA: Number of Team Members al year end is) Total number of stores at year end (de) Number of US stores a year end (d) Number of Mexico stores al year end (e) Store square footage at year end (CHI) Sales per weighted average store ($)(X) Sales per weighted average square foot (S) (XD) (h) Percentage increase in comparable store sales (ci) 40,227 38,455 36,685 31.591 30,077 28.628 33,148 1,769 1881 1.842 251 38% 35,123 1,826 251 4.8% 1,807 248 1.4% 285 1.678 232 6.0% 1,614 224 46% 26,530 1.566 221 46% 1.590 224 35% 25,315 1,527 216 88% 40% 75%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

9781266566899

Students also viewed these Accounting questions