I need help creating a full set of financial statements for 2016, with 2015 presented for comparison purposes, based on the trial balances provided. The statements I need are the balance sheet, income statement, statement of stockholder's equity, and a cash flow statement (indirect method). The completed financial statements must be created in Excel using a format that is acceptable under GAAP.

Additional information pertaining to CLC, Inc.

• The issuance of the 10 shares of no par common stock was made in the previous year (2015).
• 2015 was the first year of operations for CLC, Inc.
• Accounts receivable is presented at its net value in the trial balance. The allowance for doubtful accounts was $12,793 at 12/31/16. There was no allowance at 12/31/15.
• Note that credits are negative amounts and debits are positive amounts in the trial balance.
• Retained earnings in the trial balance includes the net income for the year as well as the prior year's RE balance.

10000 Operating Checking 10001 Payroll Checking 11000 Accounts Receivable, Net 11500 Prepaid Expenses 18000 Deferred Tax Asset 15000 Furniture and Equipment 15100 Computer Equipment 15200 Software 17000 Accumulated Depreciation 20500 Other Liabilities 21000 Income Tax Payable 22000 Deferred Revenue 24600 Deferred Tax Liability ST 24000 Payroll Liabilities 24700 Deferred Tax Liability LT 30100 Capital Stock 32000 Retained Earnings 40000 Research and Development Services 43200 Professional Services 44000 Reimbursable Expenses 66900 Reconciliation Discrepancies 60010 Wages 60020 Incentive 60030 Accrued Wages 60040 Accrued Incentive 60110 Benefits - Medical 60120 Benefits - Dental, Vision, Life Insurance 60130 Benefits - STD, LTD 60140 Benefits - 401k ER Match 60150 Benefits - Social Security and Medicare 60160 Benefits - Unemployment Insurance 60200 Benefits - Accrued Benefits 60500 Professional Fees - Consulting 60555 Professional Fees - Outside Legal 60560 Professional Fees - Accounting & Tax 60565 Professional Fees - Payroll & Human Resources 60570 Professional Fees - Business Consulting 60575 Professional Fees - Other 60580 Professional Fees - BOD Fees 60300 Advertising and Promotion 60400 Bank Service Charges 62000 Continuing Education 62200 Seminars and Conferences 62300 Memberships and Sponsorships 62400 Depreciation Expense 62500 Dues and Subscriptions 62600 Equipment Rental 31-Dec-16 737,021.60 2,558.40 77,659.43 13,718.11 21,177.50 1,644.05 53,885.62 31,993.68 (24,952.10) (38,760.17) (87,827.50) (165,729.16) (5,267.50) (73,106.96) (24,187.50) (2,000.00) (517,827.50) (2,983,125.00) (443,036.51) (36,491.57) (32.25) 1,677,395.19 (48,673.40) 135,480.55 21,347.51 8,900.89 116,942.96 89,016.11 3,624.84 (19,873.31) 232,357.43 37,679.34 28,634.60 13,332.82 78,036.16 47,510.85 1,612.50 10,569.32 1,621.29 3,884.50 14,454.61 26,336.12 21,368.74 20,026.22 236.84 31-Dec-15 930,292.48 1,108.03 31,299.12 20,958.28 26,875.00 52,786.16 31,993.68 (3,583.36) (141,308.92) (99,928.78) (7,632.50) (612,285.16) (31,497.50) (2,000.00) (197,076.53) (3,977,499.97) (101,777.17) (114.70) 1,776,315.47 13,437.50 89,837.50 441,944.77 119,352.80 20,509.26 9,440.56 83,368.91 130,838.23 12,548.61 80,502.89 39,439.01 48,711.65 28,084.38 16,784.81 203,816.19 66,198.85 6,100.63 622.89 1,855.39 18,192.73 49,511.87 3,583.36 3,364.00 - 63300 Business Insurance Expense 64700 Miscellaneous Expense 64900 Office Supplies 65000 Research & Development 67100 Rent Expense 68100 Telephone Expense 68410 Travel - Hotel 68420 Travel - Airfair 68430 Travel - Auto Rental 68435 Travel - Fuel 68440 Travel - Auto Personal Use 68450 Travel - Parking & Tolls 68460 Travel - Meals and Entertainment Subject to 50% 68470 Travel - Meals and Entertainment Subject to 100% 68480 Other Travel and Entertainment Expense 68400 Recruitment and Relocation 68500 Employee Welfare 68625 Bad Debt Expense 68700 Other Expense 69960 Income Tax Federal 69970 Income Tax New York 69995 Income Tax Penalty 69990 Deferred Tax Expense 55,285.82 5,816.87 14,406.89 58,773.87 63,855.00 26,940.55 26,675.27 29,884.37 4,217.13 327.23 4,415.00 7,728.69 6,823.91 1,872.60 1,959.91 20,285.25 5,018.07 12,792.50 114,693.14 150,331.23 11,986.25 (3,977.50) 50,589.07 12,905.47 14,444.56 57,258.48 68,837.03 23,648.33 37,837.94 37,834.84 5,628.87 666.26 14,379.10 8,972.30 13,473.74 5,802.47 3,418.39 3,194.51 2,984.30 143,893.90 78,749.13 18,486.78 2,692.88 12,255.00