2018 Account Balances

Question - Prepare the Income Statement, Balance Sheet, Cash Flow Statement and Statement of Retained Earnings for the Year Ended December 2018. Deliverables must be in Excel format, including all built-in formulas for calculations.

Account Net Cash Provided by Operating Activities Property, Plant & Equipment (PPE) Advertising Expense Accounts Receivable Salaries & Wages Payable Utilities Expense Interest Expense Accounts Payable Capital Stock Office Supplies Expense Retained Earnings Net Cash Used in Financing Activities Accumulated Depreciation Accounts Payable Prepaid Insurance Notes Payable - Long Term Property, Plant & Equipment Cash Net Sales (91% comprises of credit sales) Salaries & Wages Payable Depreciation Expense Income Taxes Net Cash Used in Investing Activities Salaries & Wages Expense Prepaid Insurance Accounts Receivable Balance in Thousands ('000) 1,440,304.00 500,000.00 3,000.00 236,522.00 32,465.00 7,550.00 10,250.00 37,400.00 650,800.00 9,500.00 310,418.30 257,000.00 100,000.00 206,125.00 20,200.00 249,547.00 500,000.00 85,205.00 756,512.00 25,000.00 100,000.00 72,648.15 345,000.00 156,500.00 26,920.00 65,900.00 Period December 31 December 31 December 31 December 31 December 31 December 31 December 31 January 1 December 31 December 31 January 1 December 31 December 31 December 31 January 1 December 31 January 1 January 1 December 31 January 1 December 31 December 31 December 31 December 31 December 31 January 1