Tax- 700 FINAL
Trial Balance
| Chester, Inc. | |||||||
| Trial Balances for years ending December 31, 2013, 2014 and 2015 | |||||||
| Increase /(Decrease) | |||||||
| Account Description | 2,013 | 2014 | 2015 | 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 | (85,514) | 128,725 | ||
| Accounts Receivable | 20,513,628 | 56,472,091 | 49,042,528 | 35,149,297 | (7,984,424) | ||
| Allowance for Doubtful Accounts | (1,578,525) | (2,387,691) | (2,942,552) | ||||
| Other Receivables | 0 | 1,400,000 | 1,200,000 | 1,400,000 | (200,000) | ||
| Inventory | 23,531,507 | 75,351,471 | 65,990,780 | 43,448,861 | (7,783,113) | ||
| Reserve for Inventory Obsolescence | (3,765,000) | (12,136,103) | (10,558,525) | ||||
| Prepaid Insurance | 1,829,143 | 2,830,474 | 2,667,722 | 1,001,331 | (162,752) | ||
| Prepaid Rent | 250,000 | - 0 | - 0 | (250,000) | - 0 | ||
| Office Supplies | 9,259 | 9,565 | 9,182 | 306 | (383) | ||
| 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) | 10,554,275 | (6,638,218) | ||
| Wages Payable | (36,838) | (264,513) | (198,384) | 227,675 | (66,129) | ||
| FICA Employee Withholding | (1,648) | (9,452) | (7,089) | 7,804 | (2,363) | ||
| Medicare Withholding | (730) | (12,785) | (9,589) | 12,055 | (3,196) | ||
| Federal Payroll Taxes Payable | (7,541) | (132,256) | (99,192) | 124,715 | (33,064) | ||
| State Payroll Taxes Payable | (3,519) | (61,630) | (46,200) | 58,111 | (15,430) | ||
| FICA Employer Withholding | (1,648) | (9,452) | (7,089) | 7,804 | (2,363) | ||
| Medicare Employer Withholding | (730) | (12,785) | (9,589) | 12,055 | (3,196) | ||
| Income Taxes Receivable/Payable | 0 | (3,205,440) | (6,011,540) | 3,205,440 | 2,806,100 | ||
| Line of Credit | (12,500,000) | (52,231,360) | (47,481,737) | 39,731,360 | (4,749,623) | ||
| Current Portion LT Note Payable | 0 | (677,640) | (721,480) | 677,640 | 43,840 | ||
| Interest payable | 0 | (470,311) | (568,429) | 470,311 | 98,118 | ||
| Bonuses payable | 0 | (504,000) | (459,000) | 504,000 | (45,000) | ||
| Dividend payable | (6,000,000) | (15,250,000) | (15,000,000) | 9,250,000 | (250,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) | (3,214,851) | (8,449,935) | ||||
| 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 Statement | ||||
| For the Year Ending December 31, | ||||
| 2013 | 2014 | 2015 | ||
| Revenue: | ||||
| Net sales | 302,094,169 | 259,406,820 | 265,766,110 | |
| Less: Cost of Goods Sold | 176,961,437 | 161,029,981 | 179,103,248 | |
| Gross Profit | 125,132,732 | 98,376,839 | 86,662,862 | |
| Less: Expenses | ||||
| 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 | |
| Total Expenses | 90,996,701 | 58,594,124 | 67,702,065 | |
| Net Operating Income | 34,136,031 | 39,782,715 | 18,960,797 | |
| Add: Other Income | ||||
| Income from Investments | 600,791 | 573,158 | 678,112 | |
| Interest Income | 255,379 | 147,707 | 142,168 | |
| Less: Other Expenses | ||||
| Interest Expense | 1,093,750 | 3,373,056 | 2,942,147 | |
| Loss on Legal Settlement | 23,965,000 | - 0 | - 0 | |
| Net Income Before Income Tax | 9,933,451 | 37,130,524 | 16,838,930 | |
| Less: Income Tax Expenses | ||||
| 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 | |
| Net Income | 6,440,951 | 20,485,084 | 8,311,390 |
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 | 2015 | ||
| Opening balance | 2,773,900 | 3,214,851 | 8,449,935 | |
| Add: Net income during the year | 6,440,951 | 20,485,084 | 8,311,390 | |
| Less: Dividend | 6,000,000 | 15,250,000 | 15,000,000 | |
| Closing balance | 3,214,851 | 8,449,935 | 1,761,325 | |
| Chester, Inc. | ||||
| Shareholder's Equity As on December 31, | ||||
| 2013 | 2014 | 2015 | ||
| 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 | 3,214,851 | 8,449,935 | 1,761,325 | |
| Total Stockholder's Equity | 22,624,851 | 27,859,935 | 21,171,325 |
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 | |||
| 2013 Total Assets | $ 50,112,096 | |||
| Chester, Inc. | ||||
| Balance Sheet | ||||
| As on December 31, | ||||
| 2013 | 2014 | 2015 | ||
| Assets | ||||
| Current assets: | ||||
| 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 | |
| Accounts Receivable | 20,513,628 | 56,472,091 | 49,042,528 | |
| Other Receivables | - 0 | 1,400,000 | 1,200,000 | |
| Allowance for Doubtful Accounts | (1,578,525) | (2,387,691) | (2,942,552) | |
| 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 | |
| Investments - Trading | 6,935,712 | 6,850,198 | 6,978,923 | |
| Total current assets | 48,782,141 | 129,628,483 | 113,840,024 | |
| Fixed assets: | ||||
| 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 | |
| Total fixed assets | 1,329,955 | 3,324,302 | 2,842,147 | |
| Total Assets | 50,112,096 | 132,952,785 | 116,682,171 | |
| Liabilities | ||||
| Current liabilities: | ||||
| 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 Long-Term Debt | - 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 | |
| Total current liabilities | 27,487,245 | 92,330,490 | 83,469,966 | |
| Long Term Liabilities: | ||||
| Long Term Notes Payable | - 0 | 12,762,360 | 12,040,880 | |
| Total Long Term Liabilities | - 0 | 12,762,360 | 12,040,880 | |
| Total Liabilities | 27,487,245 | 105,092,850 | 95,510,846 | |
| Stockholder's Equity | ||||
| 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 | 3,214,851 | 8,449,935 | 1,761,325 | |
| Total Stockholder's Equity | 22,624,851 | 27,859,935 | 21,171,325 | |
| Total liabilities and Stockholder's Equity | 50,112,096 | 132,952,785 | 116,682,171 |
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. | |||
| Statement of Cash flows | |||
| For the Year Ending December 31, | |||
| 2014 | 2015 | ||
| Cash flows from operating activities | |||
| Net profit | 20,485,084 | 8,311,390 | |
| Add/Less: | |||
| Depreciation Expense | 581,102 | 617,155 | |
| Investment - Trading | 85,514 | (128,725) | |
| Accounts Receivable | (35,149,297) | 7,984,424 | |
| Other Receivables | (1,400,000) | 200,000 | |
| Inventory | (43,448,861) | 7,783,113 | |
| Prepaid Insurance | (1,001,331) | 162,752 | |
| Prepaid Rent | 250,000 | ||
| Office Supplies | (306) | 383 | |
| Accounts Payable | 10,554,275 | (6,638,218) | |
| Wages Payable | 227,675 | (66,129) | |
| FICA Employee Withholding | 7,804 | (2,363) | |
| Medicare Withholding | 12,055 | (3,196) | |
| Federal Payroll Taxes Payable | 124,715 | (33,064) | |
| State Payroll Taxes Payable | 58,111 | (15,430) | |
| FICA Employer Withholding | 7,804 | (2,363) | |
| Medicare Employer Withholding | 12,055 | (3,196) | |
| Income Taxes Receivable/Payable | 3,205,440 | 2,806,100 | |
| Interest payable | 470,311 | 98,118 | |
| Bonuses payable | 504,000 | (45,000) | |
| Dividend payable | 9,250,000 | (250,000) | |
| Net cash flows from operating activities | (35,163,850) | 20,775,751 | |
| Cash flow from investing activities | |||
| Purchases of Machinery, Equipment, Office Furniture | (2,739,067) | - 0 | |
| Purchases of Buildings and Land Improvements | - 0 | (135,000) | |
| Sale Proceeds of Other Non Current Assets | 67,301 | - 0 | |
| Sale Proceeds of | 81,107 | - 0 | |
| Sale Proceeds of land | 15,210 | - 0 | |
| Net Cash flow from investing activities | (2,575,449) | (135,000) | |
| Cash flows from financing activities | |||
| Dividend Paid | (15,250,000) | (15,000,000) | |
| Long Term Notes Payable | 12,762,360 | - 0 | |
| Repayment of Long Term Notes Payable | - 0 | (721,480) | |
| Line of Credit | 39,731,360 | (4,749,623) | |
| Current Portion LT Note Payable | 677,640 | 43,840 | |
| Net Cash flows from financing activities | 37,921,360 | (20,427,263) | |
| Net changes in cashflows during the year | 182,061 | 213,488 | |
| Opening balance | 1,056,417 | 1,238,478 | |
| Closing balance | 1,238,478 | 1,451,966 | |
BS Analysis
| Vertical Analysis of Balance Sheet | Horizontal Analysis of Balance Sheet | |||||||||
| Chester, Inc. | Chester, Inc. | |||||||||
| Vertical Analysis of Balance Sheet | Horizontal Analysis of Balance Sheet | |||||||||
| As on December 31, 200__ | As on December 31, 200__ | |||||||||
| 2013 | 2014 | 2015 | 2014 | 2015 | ||||||
| Assets | Assets | |||||||||
| Current assets: | Current assets: | |||||||||
| Cash on Hand | 0.00% | 0.00% | 0.00% | Cash on Hand | -0.97% | 2.11% | ||||
| Checking Account - Operating | 0.49% | 0.19% | 0.21% | Checking Account - Operating | 2.10% | -3.55% | ||||
| MMKT Accounts | 1.61% | 0.74% | 1.03% | MMKT Accounts | 21.94% | 22.62% | ||||
| Accounts Receivable | 40.94% | 42.48% | 42.03% | Accounts Receivable | 175.29% | -13.16% | ||||
| Other Receivables | 0.00% | 1.05% | 1.03% | Other Receivables | 0.00% | -14.29% | ||||
| Allowance for Doubtful Accounts | -3.15% | -1.80% | -2.52% | Allowance for Doubtful Accounts | 51.26% | 23.24% | ||||
| Inventory | 46.96% | 56.68% | 56.56% | Inventory | 220.22% | -12.42% | ||||
| Reserve for Inventory Obsolescence | -7.51% | -9.13% | -9.05% | Reserve for Inventory Obsolescence | 222.34% | -13.00% | ||||
| Prepaid Insurance | 3.65% | 2.13% | 2.29% | Prepaid Insurance | 54.74% | -5.75% | ||||
| Prepaid Rent | 0.50% | 0.00% | 0.00% | Prepaid Rent | -100.00% | 0.00% | ||||
| Office Supplies | 0.02% | 0.01% | 0.01% | Office Supplies | 3.30% | -4.00% | ||||
| Investments - Trading | 13.84% | 5.15% | 5.98% | Investments - Trading | -1.23% | 1.88% | ||||
| Total current assets | 97.35% | 97.50% | 97.56% | Total current assets | 165.73% | -12.18% | ||||
| Fixed assets: | Fixed assets: | |||||||||
| Land | 0.29% | 0.10% | 0.11% | Land | -10.40% | 0.00% | ||||
| Buildings and Land Improvements | 1.56% | 0.53% | 0.71% | Buildings and Land Improvements | -10.40% | 19.32% | ||||
| Machinery, Equipment, Office Furniture | 1.08% | 2.47% | 2.81% | Machinery, Equipment, Office Furniture | 505.81% | 0.00% | ||||
| Accum. Depreciation | -0.41% | -0.59% | -1.20% | Accum. Depreciation | 283.46% | 78.51% | ||||
| Other Noncurrent Assets | 0.13% | 0.00% | 0.00% | Other Noncurrent Assets | -100.00% | 0.00% | ||||
| Total fixed assets | 2.65% | 2.50% | 2.44% | Total fixed assets | 149.96% | -14.50% | ||||
| Total Assets | 100.00% | 100.00% | 100.00% | Total Assets | 165.31% | -12.24% | ||||
| Liabilities | Liabilities | |||||||||
| Current liabilities: | Current liabilities: | |||||||||
| Accounts Payable | 17.83% | 14.66% | 11.01% | Accounts Payable | 118.13% | -34.06% | ||||
| Wages Payable | 0.07% | 0.20% | 0.17% | Wages Payable | 618.04% | -25.00% | ||||
| FICA Employee Withholding | 0.00% | 0.01% | 0.01% | FICA Employee Withholding | 473.54% | -25.00% | ||||
| Medicare Withholding | 0.00% | 0.01% | 0.01% | Medicare Withholding | 1651.37% | -25.00% | ||||
| Federal Payroll Taxes Payable | 0.02% | 0.10% | 0.09% | Federal Payroll Taxes Payable | 1653.83% | -25.00% | ||||
| State Payroll Taxes Payable | 0.01% | 0.05% | 0.04% | State Payroll Taxes Payable | 1651.35% | -25.04% | ||||
| FICA Employer Withholding | 0.00% | 0.01% | 0.01% | FICA Employer Withholding | 473.54% | -25.00% | ||||
| Medicare Employer Withholding | 0.00% | 0.01% | 0.01% | Medicare Employer Withholding | 1651.37% | -25.00% | ||||
| Income Taxes Receivable/Payable | 0.00% | 2.41% | 5.15% | Income Taxes Receivable/Payable | 0.00% | 87.54% | ||||
| Line of Credit | 24.94% | 39.29% | 40.69% | Line of Credit | 317.85% | -9.09% | ||||
| Current Portion Long-Term Debt | 0.00% | 0.51% | 0.62% | Current Portion Long-Term Debt | 0.00% | 6.47% | ||||
| Interest payable | 0.00% | 0.35% | 0.49% | Interest payable | 0.00% | 20.86% | ||||
| Bonuses payable | 0.00% | 0.38% | 0.39% | Bonuses payable | 0.00% | -8.93% | ||||
| Dividend payable | 11.97% | 11.47% | 12.86% | Dividend payable | 154.17% | -1.64% | ||||
| Total current liabilities | 54.85% | 69.45% | 71.54% | Total current liabilities | 235.90% | -9.60% | ||||
| Long Term Liabilities: | Long Term Liabilities: | |||||||||
| Long Term Notes Payable | 0.00% | 9.60% | 10.32% | Long Term Notes Payable | 0.00% | -5.65% | ||||
| Total Long Term Liabilities | 0.00% | 9.60% | 10.32% | Total Long Term Liabilities | 0.00% | -5.65% | ||||
| Total Liabilities | 54.85% | 79.05% | 81.86% | Total Liabilities | 282.33% | -9.12% | ||||
| Stockholder's Equity | Stockholder's Equity | |||||||||
| Common Stock | 20.22% | 7.62% | 8.68% | Common Stock | 0.00% | 0.00% | ||||
| Paid-in Capital | 18.52% | 6.98% | 7.95% | Paid-in Capital | 0.00% | 0.00% | ||||
| Retained Earnings | 6.42% | 6.36% | 1.51% | Retained Earnings | 162.84% | -79.16% | ||||
| Total Stockholder's Equity | 45.15% | 20.95% | 18.14% | Total Stockholder's Equity | 23.14% | -24.01% | ||||
| Total liabilities and Stockholder's Equity | 100.00% | 100.00% | 100.00% | Total liabilities and Stockholder's Equity | 165.31% | -12.24% |
IS Analysis
| Complete a Horizontal and Vertical Analysis of the Income Statement in this worksheet. | |||||||||
| Vertical Analysis of Income statement | Horizontal Analysis of Income statement | ||||||||
| Chester, Inc. | Chester, Inc. | ||||||||
| Vertical Analysis of Income statement | Horizontal Analysis of Income statement | ||||||||
| For the Year Ending December 31, 20__ | For the Year Ending December 31,20__ | ||||||||
| 2013 | 2014 | 2015 | 2014 | 2015 | |||||
| Revenue: | Revenue: | ||||||||
| Net sales | 100.00% | 100.00% | 100.00% | Net sales | -14.13% | 2.45% | |||
| Less: Cost of Goods Sold | 58.58% | 62.08% | 67.39% | Less: Cost of Goods Sold | -9.00% | 11.22% | |||
| Gross Profit | 41.42% | 37.92% | 32.61% | Gross Profit | -21.38% | -11.91% | |||
| Less: Expenses | Less: Expenses | ||||||||
| Administrative Wages Expense | 6.98% | 7.07% | 7.41% | Administrative Wages Expense | -13.04% | 7.43% | |||
| Advertising Expense | 0.37% | 0.45% | 0.40% | Advertising Expense | 3.55% | -8.86% | |||
| Auto Expenses | 0.09% | 0.09% | 0.08% | Auto Expenses | -9.74% | -9.23% | |||
| Bad Debt Expense | 0.67% | 2.26% | 5.23% | Bad Debt Expense | 189.71% | 136.59% | |||
| Bonus Expense | 0.00% | 0.19% | 0.17% | Bonus Expense | 0.00% | -8.93% | |||
| Depreciation Expense | 0.06% | 0.22% | 0.23% | Depreciation Expense | 249.54% | 6.20% | |||
| Freight | 1.78% | 1.83% | 1.63% | Freight | -11.71% | -8.93% | |||
| Insurance Expense | 0.35% | 0.40% | 0.36% | Insurance Expense | -2.09% | -8.93% | |||
| Legal and Professional Expense | 1.49% | 4.25% | 3.38% | Legal and Professional Expense | 144.92% | -18.57% | |||
| Maintenance Expense | 0.03% | 0.04% | 0.03% | Maintenance Expense | 25.65% | -8.73% | |||
| Miscellaneous Office Expense | 0.01% | 0.01% | 0.01% | Miscellaneous Office Expense | 30.66% | -8.68% | |||
| Payroll Tax Expense | 0.64% | 0.68% | 0.61% | Payroll Tax Expense | -8.85% | -8.93% | |||
| Pension/Profit-Sharing Plan Ex | 1.24% | 1.42% | 1.27% | Pension/Profit-Sharing Plan Ex | -1.44% | -8.93% | |||
| Phone | 0.03% | 0.02% | 0.02% | Phone | -39.34% | -7.36% | |||
| Postal | 0.05% | 0.03% | 0.03% | Postal | -45.55% | -8.93% | |||
| Property Tax Expense | 0.03% | 0.04% | 0.04% | Property Tax Expense | 9.57% | -8.10% | |||
| Rent or Lease Expense | 1.08% | 0.53% | 0.84% | Rent or Lease Expense | -57.89% | 62.79% | |||
| Research and Development | 12.79% | 0.21% | 1.16% | Research and Development | -98.62% | 478.54% | |||
| Utilities | 0.06% | 0.07% | 0.06% | Utilities | 0.71% | -8.88% | |||
| Warehouse Salaries | 1.92% | 2.25% | 1.98% | Warehouse Salaries | 0.97% | -9.87% | |||
| Warranty Expense | 0.46% | 0.50% | 0.54% | Warranty Expense | -5.69% | 9.66% | |||
| Total Expenses | 30.12% | 22.59% | 25.47% | Total Expenses | -35.61% | 15.54% | |||
| Net Operating Income | 11.30% | 15.34% | 7.13% | Net Operating Income | 16.54% | -52.34% | |||
| Add: Other Income | Add: Other Income | ||||||||
| Income from Investments | 0.20% | 0.22% | 0.26% | Income from Investments | -4.60% | 18.31% | |||
| Interest Income | 0.08% | 0.06% | 0.05% | Interest Income | -42.16% | -3.75% | |||
| Less: Other Expenses | Less: Other Expenses | ||||||||
| Interest Expense | 0.36% | 1.30% | 1.11% | Interest Expense | 208.39% | -12.78% | |||
| Loss on Legal Settlement | 7.93% | 0.00% | 0.00% | Loss on Legal Settlement | -100.00% | ERROR:#DIV/0! | |||
| Net Income Before Income Tax | 3.29% | 14.31% | 6.34% | Net Income Before Income Tax | 273.79% | -54.65% | |||
| Less: Income Tax Expenses | Less: Income Tax Expenses | ||||||||
| Income Tax Expense - Federal | 0.98% | 5.45% | 2.74% | Income Tax Expense - Federal | 378.38% | -48.60% | |||
| Income Tax Expense - State | 0.18% | 0.96% | 0.47% | Income Tax Expense - State | 366.80% | -49.74% | |||
| Net Income | 2.13% | 7.90% | 3.13% | Net Income | 218.04% | -59.43% |
Ratios
| Calculate and Present at least three Liquidity, Solvency and Profitability Ratios in this Worksheet | ||||||||||||||||||||
| 2013 | 2014 | 2015 | Under Amour | Industry Average | ||||||||||||||||
| Amounts (in '000) | Answer | Amounts (in '000) | Answer | Amounts (in '000) | Answer | |||||||||||||||
| Liquidity ratios | ||||||||||||||||||||
| Current Ratio | Current Assets | = | $ 48,782,141.00 | = | 1.77 | $ 129,628,483.00 | = | 1.40 | $ 113,840,024.00 | = | 1.36 | 3.13 | 3.03 | |||||||
| Current Liabilities | $ 27,487,245.00 | $ 92,330,490.00 | $ 83,469,966.00 | |||||||||||||||||
| Quick Ratio | Quick Assets * | $ 26,936,491.00 | = | 0.98 | $ 63,582,641.00 | = | 0.69 | $ 2,792,200.00 | = | 0.03 | 1.18 | 0.46 | ||||||||
| Current Liabilities | $ 27,487,245.00 | $ 92,330,490.00 | $ 83,469,966.00 | |||||||||||||||||
| Working Capital | Current Assets - Current Liabilities | = | $48,782,141 - $27,487,245 | = | $ 21,294,896.00 | $129,628,483 - $92,330,490 | = | $ 37,297,993.00 | $113,840,024 - $83,469,966 | = | $ 30,370,058.00 | |||||||||
| Solvency Ratios | ||||||||||||||||||||
| Equity | Total Equity | $ 22,624,851.00 | 45.1% | $ 27,859,935.00 | 21% | $ 21,171,325.00 | 18% | |||||||||||||
| Ratio | Total Assets | $ 50,112,096.00 | $ 132,952,785.00 | $ 116,682,171.00 | ||||||||||||||||
| Debt to | Total Liabilities | $ 27,487,245.00 | 0.55 | $ 105,092,850.00 | 0.79 | $ 95,510,846.00 | 0.82 | 0.38 | 0.31 | |||||||||||
| Equity | Total Equity | $ 50,112,096.00 | $ 132,952,785.00 | $ 116,682,171.00 | ||||||||||||||||
| Times interest | EBIT* | $ 11,027,201.00 | 10.08 | $ 40,503,580.00 | 12.01 | $ 19,781,077.00 | 6.72 | 27.43 | ||||||||||||
| Earned | Interest expense | $ 1,093,750.00 | $ 3,373,056.00 | $ 2,942,147.00 | ||||||||||||||||
| Profitability Ratios | ||||||||||||||||||||
| Net Profit | Net Income | $ 6,440,951.00 | 2.1% | $ 20,485,084.00 | 7.9% | $ 8,311,390.00 | 3.1% | 5.87% | 8.73% | |||||||||||
| Margin (%) | Sales | $ 302,094,169.00 | $ 259,406,820.00 | $ 265,766,110.00 | ||||||||||||||||
| Gross Profit | Gross Profit | $ 125,132,732.00 | 41.4% | $ 98,376,839.00 | 37.9% | $ 86,662,862.00 | 32.6% | 48.08% | 49.89% | |||||||||||
| on Sales (%) | Sales | $ 302,094,169.00 | $ 259,406,820.00 | $ 265,766,110.00 | ||||||||||||||||
| Return | Net Income | $ 6,440,951.00 | 12.9% | $ 20,485,084.00 | 15.4% | $ 8,311,390.00 | 7.1% | 15.41% | ||||||||||||
| on Equity (%) | Total Equity | $ 50,112,096.00 | $ 132,952,785.00 | $ 116,682,171.00 | ||||||||||||||||