In: Accounting
Need to Prepare Balance sheet and Income Statement
12-31-2017 | 12-31-2018 | ||||||||||||
ACCT | ACCOUNT | POST CLOSING | UNADJUSTED | ADJUSTMENTS | ADJUSTED | INCOME | BALANCE | ||||||
NO. | TITLE | TRIAL BALANCE | TRIAL BALANCE | TRIAL BALANCE | STATEMENT | SHEET | |||||||
DEBIT | CREDIT | DEBIT | CREDIT | DEBIT | CREDIT | DEBIT | CREDIT | DEBIT | CREDIT | DEBIT | CREDIT | ||
ASSETS | |||||||||||||
111000 | General checking account | 21,38,784.99 | 21,50,317.00 | 21,50,317.00 | 21,50,317.00 | ||||||||
112000 | Payroll checking account | 28,726.39 | 1,000.00 | 1,000.00 | 1,000.00 | ||||||||
113000 | Money market account | 7,75,549.73 | 7,82,546.49 | 7,82,546.49 | 7,82,546.49 | ||||||||
114000 | Savings account | 48,876.82 | 51,745.56 | 51,745.56 | 51,745.56 | ||||||||
119000 | Petty cash | 500.00 | 500.00 | 500.00 | 500.00 | ||||||||
121000 | Accounts receivable | 49,13,697.13 | 53,66,569.32 | 53,66,569.32 | 53,66,569.32 | ||||||||
129000 | Allowance for bad debts | 97,459.89 | 95,401.58 | 10,973.45 | 1,06,375.03 | 1,06,375.03 | |||||||
141000 | Inventory - production | 104,07,164.74 | 115,78,434.36 | 115,78,434.36 | 115,78,434.36 | ||||||||
145000 | Inventory - finished goods | 39,02,457.04 | 40,12,626.83 | 40,12,626.83 | 40,12,626.83 | ||||||||
150000 | Prepaid expenses | 84,636.54 | 1,42,465.96 | 1,42,465.96 | 1,42,465.96 | ||||||||
160000 | Land and buildings | 153,50,295.73 | 163,58,487.34 | 163,58,487.34 | 163,58,487.34 | ||||||||
170000 | Equipment | 128,29,549.56 | 138,75,131.10 | 138,75,131.10 | 138,75,131.10 | ||||||||
180000 | Accumulated depreciation | 141,40,830.31 | 153,42,029.47 | 153,42,029.47 | 153,42,029.47 | ||||||||
191000 | Investments | 20,80,764.31 | 30,95,227.56 | 30,95,227.56 | 30,95,227.56 | ||||||||
LIABILITIES | |||||||||||||
210000 | Accounts payable | 36,82,954.12 | 49,87,975.79 | 49,87,975.79 | 49,87,975.79 | ||||||||
222100 | Federal income tax withheld | 64,442.36 | 67,294.17 | 67,294.17 | 67,294.17 | ||||||||
222200 | FICA withheld | 12,407.35 | 12,681.48 | 12,681.48 | 12,681.48 | ||||||||
222300 | Medicare withheld | 2,831.56 | 2,965.82 | 2,965.82 | 2,965.82 | ||||||||
223100 | FICA payable - employer | 12,107.35 | 12,681.48 | 12,681.48 | 12,681.48 | ||||||||
223200 | Medicare payable - employer | 2,831.56 | 2,965.82 | 2,965.82 | 2,965.82 | ||||||||
223300 | Unemployment taxes payable | 846.39 | 943.57 | 943.57 | 943.57 | ||||||||
230000 | Other accrued expenses | 5,68,998.06 | 5,99,411.86 | 5,99,411.86 | 5,99,411.86 | ||||||||
235000 | Federal income taxes payable | 1,57,448.31 | 1,48,925.04 | 1,48,925.04 | 1,48,925.04 | ||||||||
236000 | Property taxes payable | 0.00 | 0.00 | 0.00 | |||||||||
240000 | Mortgages payable | 74,42,445.94 | 76,39,067.73 | 76,39,067.73 | 76,39,067.73 | ||||||||
261000 | Notes payable | 6,54,000.00 | 8,16,500.00 | 8,16,500.00 | 8,16,500.00 | ||||||||
STOCKHOLDERS' EQUITY | |||||||||||||
310000 | Common stock | 90,000.00 | 90,000.00 | 90,000.00 | 90,000.00 | ||||||||
311000 | Paid-in capital in excess of par - common | 35,67,265.00 | 35,67,265.00 | 35,67,265.00 | 35,67,265.00 | ||||||||
312000 | Dividends - common | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||
390000 | Retained earnings | 220,64,134.78 | 220,64,134.78 | 220,64,134.78 | 220,64,134.78 | ||||||||
REVENUE | |||||||||||||
410000 | Sales | 223,10,170.95 | 223,10,170.95 | 223,10,170.95 | |||||||||
420000 | Sales discounts | 3,47,614.00 | 3,47,614.00 | 3,47,614.00 | |||||||||
430000 | Sales returns and allowances | 15,651.33 | 15,651.33 | 15,651.33 | |||||||||
491000 | Dividend income | 4,000.00 | 4,000.00 | 4,000.00 | |||||||||
492000 | Interest income | 24,332.56 | 24,332.56 | 24,332.56 | |||||||||
COST OF GOODS SOLD | |||||||||||||
510000 | Cost of goods sold | 115,45,511.59 | 115,45,511.59 | 115,45,511.59 | |||||||||
EXPENSES | |||||||||||||
601000 | Wages and salaries expense | 19,72,322.74 | 19,72,322.74 | 19,72,322.74 | |||||||||
601500 | Sales commissions expense | 7,71,665.60 | 7,71,665.60 | 7,71,665.60 | |||||||||
602100 | FICA tax expense | 2,44,568.36 | 2,44,568.36 | 2,44,568.36 | |||||||||
602200 | Medicare tax expense | 57,197.43 | 57,197.43 | 57,197.43 | |||||||||
602300 | FUTA expense | 7,392.00 | 7,392.00 | 7,392.00 | |||||||||
602400 | SUTA expense | 22,176.00 | 22,176.00 | 22,176.00 | |||||||||
611000 | Utilities expense | 3,25,954.67 | 3,25,954.67 | 3,25,954.67 | |||||||||
611300 | Irrigation & waste disposal expense | 2,30,910.91 | 2,30,910.91 | 2,30,910.91 | |||||||||
612000 | Landscaping expense | 1,42,475.69 | 1,42,475.69 | 1,42,475.69 | |||||||||
621000 | Advertising expense | 2,96,794.33 | 2,96,794.33 | 2,96,794.33 | |||||||||
623000 | Marketing expense | 1,92,865.67 | 1,92,865.67 | 1,92,865.67 | |||||||||
624000 | Festivals & competitions expense | 2,38,654.75 | 2,38,654.75 | 2,38,654.75 | |||||||||
631000 | Telephone expense | 37,584.73 | 37,584.73 | 37,584.73 | |||||||||
632000 | Internet & computer expense | 14,475.00 | 14,475.00 | 14,475.00 | |||||||||
633000 | Postage & shipping expense | 35,117.66 | 35,117.66 | 35,117.66 | |||||||||
641000 | Legal & accounting fees | 88,425.50 | 88,425.50 | 88,425.50 | |||||||||
643000 | Other consulting fees | 12,500.00 | 12,500.00 | 12,500.00 | |||||||||
651000 | Office supplies expense | 58,689.68 | 58,689.68 | 58,689.68 | |||||||||
660000 | Data processing expense | 9,743.89 | 9,743.89 | 9,743.89 | |||||||||
670000 | Depreciation expense | 12,01,199.16 | 12,01,199.16 | 12,01,199.16 | |||||||||
680000 | Travel and entertainment expense | 1,69,405.86 | 1,69,405.86 | 1,69,405.86 | |||||||||
691000 | Other insurance expense | 1,15,058.55 | 1,15,058.55 | 1,15,058.55 | |||||||||
692000 | Medical insurance | 1,92,154.80 | 1,92,154.80 | 1,92,154.80 | |||||||||
693000 | Workmen's compensation insurance | 1,39,750.00 | 1,39,750.00 | 1,39,750.00 | |||||||||
699000 | Other employee benefits expense | 1,75,643.90 | 1,75,643.90 | 1,75,643.90 | |||||||||
700000 | Dues & subscriptions expense | 32,076.00 | 32,076.00 | 32,076.00 | |||||||||
711000 | Federal income tax expense | 8,57,595.76 | 1,48,925.04 | 10,06,520.80 | 10,06,520.80 | ||||||||
712000 | Property tax expense | 19,875.00 | 19,875.00 | 19,875.00 | |||||||||
721000 | Repairs and maintenance | 71,974.93 | 71,974.93 | 71,974.93 | |||||||||
731000 | Automobile expense | 81,493.45 | 81,493.45 | 81,493.45 | |||||||||
740000 | Lease expense | 1,13,607.56 | 1,13,607.56 | 1,13,607.56 | |||||||||
791000 | Bad debt expense | 10,973.45 | 10,973.45 | 10,973.45 | |||||||||
792000 | Miscellaneous expense | 26,665.63 | 26,665.63 | 26,665.63 | |||||||||
793000 | Interest expense | 3,59,978.41 | 3,59,978.41 | 3,59,978.41 | |||||||||
Sub-totals | 203,84,669.03 | 223,38,503.51 | 574,15,051.52 | 554,61,217.04 | |||||||||
Net Income (Loss) | 19,53,834.48 | 19,53,834.48 | |||||||||||
TOTALS | 525,61,002.98 | 525,61,002.98 | 776,39,822.06 | 776,39,822.06 | 1,59,898.49 | 1,59,898.49 | 777,99,720.55 | 777,99,720.55 | 223,38,503.51 | 223,38,503.51 | 574,15,051.52 | 574,15,051.52 |