A Plus Writer

roebob7l6g
milestone1spreadsheetfinal.xlsx

Trial Balance

Chester, Inc.
Trial Balances for years ending December 31, 2013, 2014 and 2015
Account Description 2,013 2014 2015
Cash on Hand $2,483 $2,459 $2,511
Checking Account - Operating 247,646 252,858 243,892
MMKT Accounts 806,288 983,161 1,205,563
Investments - Trading 6,935,712 6,850,198 6,978,923
Accounts Receivable 20,513,628 56,472,091 49,042,528
Allowance for Doubtful Accounts (1,578,525) (2,387,691) (2,942,552)
Other Receivables 0 1,400,000 1,200,000
Inventory 23,531,507 75,351,471 65,990,780
Reserve for Inventory Obsolescence (3,765,000) (12,136,103) (10,558,525)
Prepaid Insurance 1,829,143 2,830,474 2,667,722
Prepaid Rent 250,000 - 0 - 0
Office Supplies 9,259 9,565 9,182
Land 146,250 131,040 131,040
Buildings and Land Improvements 779,882 698,775 833,775
Machinery, Equipment, Office Furniture 541,522 3,280,589 3,280,589
Accum. Depreciation (205,000) (786,102) (1,403,257)
Other Noncurrent Assets 67,301 - 0 - 0
Accounts Payable (8,934,591) (19,488,866) (12,850,648)
Wages Payable (36,838) (264,513) (198,384)
FICA Employee Withholding (1,648) (9,452) (7,089)
Medicare Withholding (730) (12,785) (9,589)
Federal Payroll Taxes Payable (7,541) (132,256) (99,192)
State Payroll Taxes Payable (3,519) (61,630) (46,200)
FICA Employer Withholding (1,648) (9,452) (7,089)
Medicare Employer Withholding (730) (12,785) (9,589)
Income Taxes Receivable/Payable 0 (3,205,440) (6,011,540)
Line of Credit (12,500,000) (52,231,360) (47,481,737)
Current Portion LT Note Payable 0 (677,640) (721,480)
Interest payable 0 (470,311) (568,429)
Bonuses payable 0 (504,000) (459,000)
Dividend payable (6,000,000) (15,250,000) (15,000,000)
Long-Term Note Payable (12,762,360) (12,040,880)
Common Stock (10,131,250) (10,131,250) (10,131,250)
Paid-in Capital (9,278,750) (9,278,750) (9,278,750)
Retained Earnings (Beginning Balance) (2,773,900) ???? ????
Dividends 6,000,000 15,250,000 15,000,000
Sales (307,716,148) (271,839,067) (288,876,206)
Sales Returns 5,621,979 12,432,247 23,110,096
Income from Investments (665,079) (658,672) (549,387)
Unrealized (Gains) and Losses - Investments 64,288 85,514 (128,725)
Interest Income (255,379) (147,707) (142,168)
Cost of Goods Sold 176,961,437 161,029,981 179,103,248
Administrative Wages Expense 21,094,132 18,344,399 19,706,506
Advertising Expense 1,121,425 1,161,276 1,058,391
Auto Expenses 261,218 235,763 214,001
Bad Debt Expense 2,028,032 5,875,403 13,900,800
Bonus Expense 0 504,000 459,000
Depreciation Expense 166,250 581,102 617,155
Freight 5,378,689 4,749,095 4,325,068
Insurance Expense 1,067,428 1,045,085 951,774
Legal and Professional Expense 4,506,417 11,037,039 8,987,069
Maintenance Expense 76,420 96,020 87,641
Miscellaneous Office Expense 21,279 27,803 25,390
Payroll Tax Expense 1,938,736 1,767,149 1,609,342
Pension/Profit-Sharing Plan Ex 3,750,000 3,696,000 3,366,000
Phone 95,467 57,911 53,651
Postal 160,042 87,140 79,360
Property Tax Expense 100,619 110,252 101,319
Rent or Lease Expense 3,254,357 1,370,273 2,230,615
Research and Development 38,639,554 532,425 3,080,313
Utilities 169,554 170,765 155,600
Warehouse Salaries 5,791,730 5,848,120 5,270,689
Warranty Expense 1,375,352 1,297,104 1,422,381
Interest Expense 1,093,750 3,373,056 2,942,147
Income Tax Expense - Federal 2,956,250 14,142,240 7,269,540
Income Tax Expense - State 536,250 2,503,200 1,258,000
Loss on Legal Settlement 23,965,000 - 0 - 0

Income Statement

Use this worksheet to prepare a Multi-step Income Statement to include EPS
Check Figures:
2015 Net Income $ 8,311,390
2014 Gross Profit $ 98,376,839
2013 Total Expenses $ 90,996,701
Chester, Inc.
Income statementfor years ending December 31, 2013, 2014 and 2015
2015 2014 2013 One of the differences that would arise in using the IFRS instead of the U.S GAAP in preparing the income statement is the non-segregation of the unusual or extraordinary items as reflected in the income statement that has been prepared. Similarly, the revenue recogntion would be different under the IFRS since revenue is recognized once ownership risks and rewards ar transferred to the owner. In contrast, the GAAP recognizes revenue once the goods are delivered under definitive agreement for a determinable consideration.
Revenues
Sales 288,876,206 271,839,067 307,716,148
Sales Returns (23,110,096) (12,432,247) (5,621,979)
Net-sales 265,766,110 259,406,820 302,094,169
Cost of Goods Sold (179,103,248) (161,029,981) (176,961,437)
Gross profit 86,662,862 98,376,839 125,132,732
Operating expenses
Administrative Wages Expense 19,706,506 18,344,399 21,094,132
Advertising Expense 1,058,391 1,161,276 1,121,425
Auto Expenses 214,001 235,763 261,218
Bad Debt Expense 13,900,800 5,875,403 2,028,032
Bonus Expense 459,000 504,000 0
Depreciation Expense 617,155 581,102 166,250
Freight 4,325,068 4,749,095 5,378,689
Insurance Expense 951,774 1,045,085 1,067,428
Legal and Professional Expense 8,987,069 11,037,039 4,506,417
Maintenance Expense 87,641 96,020 76,420
Miscellaneous Office Expense 25,390 27,803 21,279
Payroll Tax Expense 1,609,342 1,767,149 1,938,736
Pension/Profit-Sharing Plan Ex 3,366,000 3,696,000 3,750,000
Phone 53,651 57,911 95,467
Postal 79,360 87,140 160,042
Property Tax Expense 101,319 110,252 100,619
Rent or Lease Expense 2,230,615 1,370,273 3,254,357
Research and Development 3,080,313 532,425 38,639,554
Utilities 155,600 170,765 169,554
Warehouse Salaries 5,270,689 5,848,120 5,791,730
Warranty Expense 1,422,381 1,297,104 1,375,352
Total operating expenses 67,702,065 58,594,124 90,996,701
Operating profit 18,960,797 39,782,715 34,136,031
Other income(expenses):
Income from Investments 549,387 658,672 665,079
Unrealized Gains and (Losses) - Investments 128,725 (85,514) (64,288)
Interest Income 142,168 147,707 255,379
Interest expense (2,942,147) (3,373,056) (1,093,750)
Total other income(losses) (2,121,867) (2,652,191) (237,580)
Taxable income 16,838,930 37,130,524 33,898,451
Income Tax Expense - Federal (7,269,540) (14,142,240) (2,956,250)
Income Tax Expense - State (1,258,000) (2,503,200) (536,250)
Loss on Legal Settlement - 0 - 0 (23,965,000)
Net-income 8,311,390 20,485,084 6,440,951
EPS 2.23 2.56 2.17

Statement of Retained Earnings

Use this worksheet to complete a Statement of Retained Earnings
Check Figures:
2015 Shareholders' Equity $ 21,171,325
2014 Shareholders' Equity $ 27,859,935
2013 Shareholders' Equity $ 22,624,851
Chester, Inc.
Statement of Retained Earnings for years ending December 31, 2013, 2014 and 2015
2015 2014 2013
Beginning retained earnings 8,449,935 3,214,851 2,773,900
Net income 8,311,390 20,485,084 6,440,951
Dividend Paid (15,000,000) (15,250,000) (6,000,000)
Ending Retained earnings 1,761,325 8,449,935 3,214,851

Balance Sheet

Use this worksheet to complete a Classified Balance Sheet
Check Figures:
2015 Total Current Assets $ 113,840,024
2014 Current Liabilities $ 92,330,490
2103 Total Assets $ 50,112,096
Chester, Inc.
Balance Sheet as at December 31, 2013, 2014 and 2015
2015 2014 2013
Current assets:
Cash on Hand $2,511 $2,459 $2,483
Checking Account - Operating 243,892 252,858 247,646
MMKT Accounts 1,205,563 983,161 806,288
Investments - Trading 6,978,923 6,850,198 6,935,712
Accounts Receivable 49,042,528 56,472,091 20,513,628
Allowance for Doubtful Accounts (2,942,552) (2,387,691) (1,578,525)
Other Receivables 1,200,000 1,400,000 0
Inventory 65,990,780 75,351,471 23,531,507
Reserve for Inventory Obsolescence (10,558,525) (12,136,103) (3,765,000)
Prepaid Insurance 2,667,722 2,830,474 1,829,143
Prepaid Rent - 0 - 0 250,000
Office Supplies 9,182 9,565 9,259
Total currrent assets $113,840,024 $129,628,483 $48,782,141
Non-current assets:
Land 131,040 131,040 146,250
Buildings and Land Improvements 833,775 698,775 779,882
Machinery, Equipment, Office Furniture 3,280,589 3,280,589 541,522
Accum. Depreciation (1,403,257) (786,102) (205,000)
Other Noncurrent Assets - 0 - 0 67,301
Total non-current assets 2,842,147 3,324,302 1,329,955
Total assets $116,682,171 $132,952,785 $50,112,096
Liabilities & Equity:
Current liabilities:
Accounts Payable (12,850,648) (19,488,866) (8,934,591)
Wages Payable (198,384) (264,513) (36,838)
FICA Employee Withholding (7,089) (9,452) (1,648)
Medicare Withholding (9,589) (12,785) (730)
Federal Payroll Taxes Payable (99,192) (132,256) (7,541)
State Payroll Taxes Payable (46,200) (61,630) (3,519)
FICA Employer Withholding (7,089) (9,452) (1,648)
Medicare Employer Withholding (9,589) (12,785) (730)
Income Taxes Receivable/Payable (6,011,540) (3,205,440) 0
Line of Credit (47,481,737) (52,231,360) (12,500,000)
Current Portion LT Note Payable (721,480) (677,640) 0
Interest payable (568,429) (470,311) 0
Bonuses payable (459,000) (504,000) 0
Dividend payable (15,000,000) (15,250,000) (6,000,000)
Total current liabilities 83,469,966 92,330,490 27,487,245
Non-current liabilities:
Long-Term Note Payable 12,040,880 12,762,360
Total Liabilities 95,510,846 105,092,850 27,487,245
Common Stock 10,131,250 10,131,250 10,131,250
Paid-in Capital 9,278,750 9,278,750 9,278,750
Retained Earnings 1,761,325 8,449,935 3,214,851
Total shareholders' equity 21,171,325 27,859,935 22,624,851
Total liabilities and equity 116,682,171 132,952,785 50,112,096
One of the differences that will occur if the IFRS is employed instead of the US GAAP is the accounting for the inventories. The inventories will be accounted using only the LIFO method only while the US GAAP alliws for either the LIFO or FIFO approach. Similarly, the IFRS has no differentiation of the liabilities into current and non-current liabilities unlike the US GAAP.

Statement of Cash Flows

Use this Worksheet to complete a Statement of Cash Flows
Check Figures:
2015 Net Cash from Operating Activities $ 20,775,751
2014 Net Cash from Investing Activities $ (2,575,449)
2015 Net Increase (Decrease) in Cash $ 213,488
Chester, Inc.
cash flow statement for years ending December 31, 2013, 2014 and 2015
2015 2014
Net income 8,311,390 20,485,084
Adjustments to reconcile for net income to net cash
Depreciation expense 617,155 581,102
Bad Debt Expense 13,900,800 5,875,403
Decrease (Increase) in accounts receivable 8,184,424 -36,549,297
Decrease (Increase) in inventory 7,783,113 -43,448,861
Decrease(increase) in prepaid insurance 162,752 -1,001,331
Decrease(increase) in prepaid rent 0 250000
Decrease(increase) in office supplies 383 -306
Decrease(increase) Checking Account - Operating 8966 -5212
Decrease(increase) MMKT Accounts -222,402 -176,873
Increase(decrease)Accounts Payable -6,638,218 10,554,275
Increase(decrease)Wages Payable -66,129 227,675
Increase(decrease)FICA Employee Withholding -2,363 7,804
Increase(decrease)Medicare Withholding -3,196 12,055
Increase(decrease)Federal Payroll Taxes Payable -33,064 124,715
Increase(decrease)State Payroll Taxes Payable -15,430 58,111
Increase(decrease)FICA Employer Withholding -2,363 7,804
Increase(decrease)Medicare Employer Withholding -3,196 12,055
Increase(decrease)Income Taxes Receivable/Payable 2,806,100 3,205,440
Increase(decrease)Line of Credit -4,749,623 39,731,360
Increase(decrease)Current Portion LT Note Payable 43,840 677,640
Increase(decrease)Interest payable 98,118 470,311
Increase(decrease)Bonuses payable -45,000 504,000
Increase(decrease)Dividend payable -250,000 9,250,000
Net cash provided by operating activities 29,886,057 10,852,954
Investing activities
Land improvements sold 163,618
New Equipement -2,739,067
Net cash used in investing activities -2,575,449
Financing Activities:
Cash dividend -15250000 -6000000
Net increase(decrease) in cash 14,636,057 2,277,505
Cash at the beginning 2,279,988 $2,483
Cash at the end of year 16,916,045 2,279,988

BS Analysis

BS Horizontal Analysis Vertical Analysis
2015 2014 2013 2015 2014 2013 2015 2014 2013
Current assets:
Cash on Hand $2,511 $2,459 $2,483 1.13% -0.97% 100.00% 0.00% 0.00% 0.00%
Checking Account - Operating 243,892 252,858 247,646 -1.52% 2.10% 100.00% 0.21% 0.19% 0.49%
MMKT Accounts 1,205,563 983,161 806,288 49.52% 21.94% 100.00% 1.03% 0.74% 1.61%
Investments - Trading 6,978,923 6,850,198 6,935,712 0.62% -1.23% 100.00% 5.98% 5.15% 13.84%
Accounts Receivable 49,042,528 56,472,091 20,513,628 139.07% 175.29% 100.00% 42.03% 42.48% 40.94%
Allowance for Doubtful Accounts -2,942,552 -2,387,691 -1,578,525 86.41% 51.26% 100.00% -2.52% -1.80% -3.15%
Other Receivables 1,200,000 1,400,000 0 1.03% 1.05% 0.00%
Inventory 65,990,780 75,351,471 23,531,507 180.44% 220.22% 100.00% 56.56% 56.68% 46.96%
Reserve for Inventory Obsolescence -10,558,525 -12,136,103 -3,765,000 180.44% 222.34% 100.00% -9.05% -9.13% -7.51%
Prepaid Insurance 2,667,722 2,830,474 1,829,143 45.85% 54.74% 100.00% 2.29% 2.13% 3.65%
Prepaid Rent 0 0 250,000 -100.00% -100.00% 100.00% 0.00% 0.00% 0.50%
Office Supplies 9,182 9,565 9,259 -0.83% 3.30% 100.00% 0.01% 0.01% 0.02%
Total currrent assets $113,840,024 $129,628,483 $48,782,141 133.36% 165.73% 100.00% 97.56% 97.50% 97.35%
Non-current assets: 0.00%
Land 131,040 131,040 146,250 -10.40% -10.40% 100.00% 0.11% 0.10% 0.29%
Buildings and Land Improvements 833,775 698,775 779,882 6.91% -10.40% 100.00% 0.71% 0.53% 1.56%
Machinery, Equipment, Office Furniture 3,280,589 3,280,589 541,522 505.81% 505.81% 100.00% 2.81% 2.47% 1.08%
Accum. Depreciation -1,403,257 -786,102 -205,000 584.52% 283.46% 100.00% -1.20% -0.59% -0.41%
Other Noncurrent Assets 0 0 67,301 -100.00% -100.00% 100.00% 0.00% 0.00% 0.13%
Total non-current assets 2,842,147 3,324,302 1,329,955 113.70% 149.96% 100.00% 2.44% 2.50% 2.65%
Total assets $116,682,171 $132,952,785 $50,112,096 132.84% 165.31% 100.00% 100.00% 100.00% 100.00%
Liabilities & Equity:
Current liabilities:
Accounts Payable -12,850,648 -19,488,866 -8,934,591 43.83% 118.13% 100.00% -11.01% -14.66% -17.83%
Wages Payable -198,384 -264,513 -36,838 438.53% 618.04% 100.00% -0.17% -0.20% -0.07%
FICA Employee Withholding -7,089 -9,452 -1,648 330.16% 473.54% 100.00% -0.01% -0.01% -0.00%
Medicare Withholding -9,589 -12,785 -730 1213.56% 1651.37% 100.00% -0.01% -0.01% -0.00%
Federal Payroll Taxes Payable -99,192 -132,256 -7,541 1215.37% 1653.83% 100.00% -0.09% -0.10% -0.02%
State Payroll Taxes Payable -46,200 -61,630 -3,519 1212.87% 1651.35% 100.00% -0.04% -0.05% -0.01%
FICA Employer Withholding -7,089 -9,452 -1,648 330.16% 473.54% 100.00% -0.01% -0.01% -0.00%
Medicare Employer Withholding -9,589 -12,785 -730 1213.56% 1651.37% 100.00% -0.01% -0.01% -0.00%
Income Taxes Receivable/Payable -6,011,540 -3,205,440 0 ERROR:#DIV/0! ERROR:#DIV/0! -5.15% -2.41% 0.00%
Line of Credit -47,481,737 -52,231,360 -12,500,000 279.85% 317.85% 100.00% -40.69% -39.29% -24.94%
Current Portion LT Note Payable -721,480 -677,640 0 ERROR:#DIV/0! ERROR:#DIV/0! -0.62% -0.51% 0.00%
Interest payable -568,429 -470,311 0 ERROR:#DIV/0! ERROR:#DIV/0! -0.49% -0.35% 0.00%
Bonuses payable -459,000 -504,000 0 ERROR:#DIV/0! ERROR:#DIV/0! -0.39% -0.38% 0.00%
Dividend payable -15,000,000 -15,250,000 -6,000,000 150.00% 154.17% 100.00% -12.86% -11.47% -11.97%
Total current liabilities 83,469,966 92,330,490 27,487,245 203.67% 235.90% 100.00% 71.54% 69.45% 54.85%
Non-current liabilities:
Long-Term Note Payable 12,040,880 12,762,360 0 10.32% 9.60% 0.00%
Total Liabilities 95,510,846 105,092,850 27,487,245 247.47% 282.33% 100.00% 81.86% 79.05% 54.85%
Common Stock 10,131,250 10,131,250 10,131,250 0.00% 0.00% 100.00% 8.68% 7.62% 20.22%
Paid-in Capital 9,278,750 9,278,750 9,278,750 0.00% 0.00% 100.00% 7.95% 6.98% 18.52%
Retained Earnings 1,761,325 8,449,935 3,214,851 -45.21% 162.84% 100.00% 1.51% 6.36% 6.42%
Total shareholders' equity 21,171,325 27,859,935 22,624,851 -6.42% 23.14% 100.00% 18.14% 20.95% 45.15%
Total liabilities and equity 116,682,171 132,952,785 50,112,096 132.84% 165.31% 100.00% 100.00% 100.00% 100.00%

IS Analysis

Horizontal Analysis Vertical Analysis
2015 2014 2013 2015 2014 2013 2015 2014 2013
Revenues
Sales 288,876,206 271,839,067 307,716,148 -6.12% -11.66% 100.00% 108.70% 104.79% 101.86%
Sales Returns (23,110,096) (12,432,247) (5,621,979) 311.07% 121.14% 100.00% -8.70% -4.79% -1.86%
Net-sales 265,766,110 259,406,820 302,094,169 -12.03% -14.13% 100.00% 100.00% 100.00% 100.00%
Cost of Goods Sold (179,103,248) (161,029,981) (176,961,437) 1.21% -9.00% 100.00% -67.39% -62.08% -58.58%
Gross profit 86,662,862 98,376,839 125,132,732 -30.74% -21.38% 100.00% 32.61% 37.92% 41.42%
Operating expenses 0.00% 0.00% 0.00%
Administrative Wages Expense 19,706,506 18,344,399 21,094,132 -6.58% -13.04% 100.00% 7.41% 7.07% 6.98%
Advertising Expense 1,058,391 1,161,276 1,121,425 -5.62% 3.55% 100.00% 0.40% 0.45% 0.37%
Auto Expenses 214,001 235,763 261,218 -18.08% -9.74% 100.00% 0.08% 0.09% 0.09%
Bad Debt Expense 13,900,800 5,875,403 2,028,032 585.43% 189.71% 100.00% 5.23% 2.26% 0.67%
Bonus Expense 459,000 504,000 0 0.17% 0.19% 0.00%
Depreciation Expense 617,155 581,102 166,250 271.22% 249.54% 100.00% 0.23% 0.22% 0.06%
Freight 4,325,068 4,749,095 5,378,689 -19.59% -11.71% 100.00% 1.63% 1.83% 1.78%
Insurance Expense 951,774 1,045,085 1,067,428 -10.83% -2.09% 100.00% 0.36% 0.40% 0.35%
Legal and Professional Expense 8,987,069 11,037,039 4,506,417 99.43% 144.92% 100.00% 3.38% 4.25% 1.49%
Maintenance Expense 87,641 96,020 76,420 14.68% 25.65% 100.00% 0.03% 0.04% 0.03%
Miscellaneous Office Expense 25,390 27,803 21,279 19.32% 30.66% 100.00% 0.01% 0.01% 0.01%
Payroll Tax Expense 1,609,342 1,767,149 1,938,736 -16.99% -8.85% 100.00% 0.61% 0.68% 0.64%
Pension/Profit-Sharing Plan Ex 3,366,000 3,696,000 3,750,000 -10.24% -1.44% 100.00% 1.27% 1.42% 1.24%
Phone 53,651 57,911 95,467 -43.80% -39.34% 100.00% 0.02% 0.02% 0.03%
Postal 79,360 87,140 160,042 -50.41% -45.55% 100.00% 0.03% 0.03% 0.05%
Property Tax Expense 101,319 110,252 100,619 0.70% 9.57% 100.00% 0.04% 0.04% 0.03%
Rent or Lease Expense 2,230,615 1,370,273 3,254,357 -31.46% -57.89% 100.00% 0.84% 0.53% 1.08%
Research and Development 3,080,313 532,425 38,639,554 -92.03% -98.62% 100.00% 1.16% 0.21% 12.79%
Utilities 155,600 170,765 169,554 -8.23% 0.71% 100.00% 0.06% 0.07% 0.06%
Warehouse Salaries 5,270,689 5,848,120 5,791,730 -9.00% 0.97% 100.00% 1.98% 2.25% 1.92%
Warranty Expense 1,422,381 1,297,104 1,375,352 3.42% -5.69% 100.00% 0.54% 0.50% 0.46%
Total operating expenses 67,702,065 58,594,124 90,996,701 -25.60% -35.61% 100.00% 25.47% 22.59% 30.12%
Operating profit 18,960,797 39,782,715 34,136,031 -44.46% 16.54% 100.00% 7.13% 15.34% 11.30%
Other income(expenses): 0.00% 0.00% 0.00%
Income from Investments 549,387 658,672 665,079 -17.40% -0.96% 100.00% 0.21% 0.25% 0.22%
Unrealized Gains and (Losses) - Investments 128,725 (85,514) (64,288) -300.23% 33.02% 100.00% 0.05% -0.03% -0.02%
Interest Income 142,168 147,707 255,379 -44.33% -42.16% 100.00% 0.05% 0.06% 0.08%
Interest expense (2,942,147) (3,373,056) (1,093,750) 169.00% 208.39% 100.00% -1.11% -1.30% -0.36%
Total other income(losses) (2,121,867) (2,652,191) (237,580) 793.12% 1016.34% 100.00% -0.80% -1.02% -0.08%
Taxable income 16,838,930 37,130,524 33,898,451 -50.33% 9.53% 100.00% 6.34% 14.31% 11.22%
Income Tax Expense - Federal (7,269,540) (14,142,240) (2,956,250) 145.90% 378.38% 100.00% -2.74% -5.45% -0.98%
Income Tax Expense - State (1,258,000) (2,503,200) (536,250) 134.59% 366.80% 100.00% -0.47% -0.96% -0.18%
Loss on Legal Settlement - 0 - 0 (23,965,000) -100.00% -100.00% 100.00% 0.00% 0.00% -7.93%
Net-income 8,311,390 20,485,084 6,440,951 29.04% 218.04% 100.00% 3.13% 7.90% 2.13%

Ratios

2015 2014 2013 Competitor (Columbia Sportswear Company) Industry
Liquidity ratios:
current ratio = current assets/current liabilities 1.3638441401 1.4039549798 1.7747191834 3.41 1.78
Quick ratio = immediate current assets/current liabilities 0.4467561302 0.4564115669 0.4178532261 2.03 0.67
Cash ratio = cash and cash equivalents/ current liabilities 0.0000300827 0.0000266325 9.033E-05 0.716 0.23
Profitability ratios:
return on equity = net income/shareholders' equity 7.12% 15.41% 28.47% 12.71% 14.72%
profit margin = net income/net sales revenue 3.13% 7.90% 2.13% 7.49% 8.89%
gross-profit margin = gross profit/net sales revenue 33.74% 37.92% 41.42% 41.56% 38.73%
Solvency ratios:
debt ratio = total liabilities/total assets 81.86% 79.05% 54.85% 37.03% 55.49%
debt-equity ratio = total liabilities/total equity 4.5113305851 3.7721857571 1.2149138573 0.01 1.27
interest coverage ratio = EBIT/interest expense 6.4445444092 11.7942646075 31.2100854857 12.17 9.38