Last Year Credit 0.00 350.00 250,000.00 20,000.00 250,000.00 5,600.00 40,000.00 23,400.00 250,000.00 30,000.00 150,000.00 Adjusted Trial Balance For Years Ended December 31 Current Debit Credit Cash 157,000.00 Petty Cash 350.00 Accounts Receivable 250,000.00 Allowance for Doubtful Accounts 20,000.00 Notes Receivable (due in 6 months) 2,500.00 Merchandise Inventory 325,000.00 Supplies 5,030.00 Equipment 50,000.00 Accumulated Depreciation - Equip 24,500.00 Building 250,000.00 Accumulated Depreciation - Bldg 36,000.00 Land 100,000.00 Accounts payable 102,300.00 Salaries payable 33,750.00 FICA Taxes payable 10,364.00 Federal Income Tax Withheld Payable 41,130.00 Bonds payable (due 2030) 80,000.00 Discount on Bonds payable 5,000.00 Notes Payable (due in 2 years) 50,000.00 Common Stock, $2 par 80,000.00 Paid in capital in excess of par, Common Stock 600,000.00 Retained Earnings 123,370.00 Dividends 70,500.00 Sales 750,000.00 Cost of goods sold 450,000.00 Bank service fees 4,970.00 Cash Over and Short 50.00 Credit Card Expense 15,000.00 180,000.00 30,000.00 9,180.00 10,000.00 75,000.00 70,000.00 525,000.00 123,370.00 Delivery Expense Depreciation Expense - Bldg Depreciation Expense - Equip Insurance Expense Payroll Tax Expense Supplies Expense Wage and Salaries Expense Gain on sale of Equipment Loss on sale of Land TOTALS 22,500.00 6,000.00 9,800.00 12,000.00 5,164.00 8,750.00 202,500.00 1,200.00 500.00 1,952,614.00 1,952,614.00 1,095,950.00 1,095,950.00 Multi-step Income Statement For Current Year Ended December 31 750,000.00 Sales this section has been completed for you Income from operations Gain on sale of Equipment Loss on sale of Land Total Other Income / Loss NET INCOME 1,200.00 (500.00) 700.00 Analyze your company's Income Statement, Statement of Retained Earnings For Current Year Ended December 31 Retained Earnings, Last Year Ending Retained Earnings CLASSIFIED Balance Sheet For Years Ended December 31 Current Year Last Year Dollar Change Percent Change Current Assets: Total Current Assets Property, Plant and Equipment (Fixed Assets): Total Property, plant and Equipment TOTAL ASSETS Current Liabilities: Total Current Liabilities Long Term Liabilities: Total Long Term Liabilities Total Liabilities Paid in capital: Total Paid in Capital Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES AND EQUITY Statement of Cash Flows For Current Year Ended December 31 Cash flows from Operating activities: Net Cash provided (or used) by Operating activities Cash flows from Investing activities: Net Cash provided (or used) by Investing activities Cash flows from Financing activities: Net Cash provided for used) by Financing activities Cash flows from Financing activities: Net Cash provided (or used) by Financing activities ENDING CASH BALANCE, CURRENT YEAR Analyze your company's Statement of Cash Flows Ratio Analysis for Current Year Only (use and show formulas from our chapter and all work): Current Ratio = Inventory Turnover Ratio = ENDING CASH BALANCE, CURRENT YEAR Analyze your company's Statement of Cash Flows Ratio Analysis for Current Year Only (use and show formulas from our chapter and all work): Current Ratio = Inventory Turnover Ratio = Days Sales in Inventory Ratio = Accounts Receivable Turnover = Days Sales in Inventory Ratio = Accounts Receivable Turnover = Days Sales Uncollected ratio = Explain what the ratios tell you about your company's performance: What are the 5 different account types we have learned? List and explain each type. Explain the Debit and Credit Theory (do not refer to contra-accounts here). 1 What is a contra-account? Provide 3 specific account examples we learned. Required: 1. Prepare a multi-step Income Statement and show the common-size percents. You will analyze this statement. 2. Prepare a statement of Retained Earnings. 3. Prepare a classified Balance Sheet showing amounts for current, prior year and the dollar amount and percent of change. The common stock had 100,000 shares authorized and 95,000 shares issued and outstanding at the end of this year. 4. Prepare the Statement of Cash Flows using the indirect method (do not include non-cash investing and financing section) and explain what it tells you about the company. You will use your financial statements as well as the following additional information for the current year: a. Sold $20,000 of old equipment for $9,500 cash providing a gain on sale of equipment. b. Purchased new equipment for $30,000 cash. c. Sold $50,000 plot of land for $49,500 cash providing a loss on sale of land. d. Bonds were issued for $75,000 cash. e. Notes payable payment of $25,000 was made in cash. No new notes were issued this year. f. Common stock was issued for $85,000 cash. g. Dividends of $67,500 were paid in cash the remaining dividends were stock dividends.. 5. Prepare the following ratios for the current year and explain what each means for your company (note: only use formulas as provided in the textbook): a. Current Ratio b. Inventory Turnover ratio c. Days sales in Inventory d. Accounts Receivable Turnover ratio e. Days sales Uncollected ratio 6. Complete the accounting theory questions provided in your Google drive file
