In: Accounting
Prepare a multi step income statement, statement of retained earnings and classified balance sheet
| NFT Consulting and Sales Inc | |||||||||||
| PARTIALLY ADJUSTED TRIAL BALANCE | |||||||||||
| October 31 2017 | |||||||||||
| Part Adj T/B | October Jes | Trial | Balance | Adj | Jes | Adj T/B | |||||
| DR | CR | DR | CR | DR | CR | DR | CR | DR | CR | ||
| Cash | $332,218 | 332,218 | 332,218 | ||||||||
| Accounts Receivable | 146,800 | 16,275 | 163,075 | 4,109 | 158,966 | ||||||
| Allowance for Uncollectible Accounts | $3,689 | 3,689 | 388 | 4,077 | |||||||
| Supplies | 42,600 | 42,600 | 42,600 | ||||||||
| Inventory | 2,650 | 8,200 | 8,300 | 2,550 | 2,550 | ||||||
| Prepaid Insurance | 16,800 | 16,800 | 16,800 | ||||||||
| Land | 50,000 | 50,000 | 50,000 | ||||||||
| Building | 110,000 | 110,000 | 110,000 | ||||||||
| Accumulated Depr – Building | 5,670 | 5,670 | 5,670 | ||||||||
| Computer equipment | 52,950 | 52,950 | 52,950 | ||||||||
| Accumulated Depr – Comp Equip | 1,750 | 1,750 | 1,750 | ||||||||
| Office Furniture | 45,900 | 45,900 | 45,900 | ||||||||
| Accumulated Depr - Office Furniture | 890 | 890 | 890 | ||||||||
| Accounts Payable | 16,560 | 8,200 | 24,760 | 24,760 | |||||||
| Interest Payable | 3,200 | 3,200 | 3,200 | ||||||||
| Utilities Payable | 8,952 | 8,952 | 8,952 | ||||||||
| Wages Payable | 45,800 | 45,800 | 45,800 | ||||||||
| Long term Note Payable | 90,000 | 90,000 | 90,000 | ||||||||
| Mortgage Payable | 60,000 | 60,000 | 60,000 | ||||||||
| Common Stock | 400,000 | 400,000 | 400,000 | ||||||||
| Retained Earnings | 126,867 | 126,867 | 126,867 | ||||||||
| Dividends | 4,000 | 4,000 | 4,000 | ||||||||
| Service Revenue | 365,400 | 365,400 | 365,400 | ||||||||
| Tablet Sales Revenue | 222,400 | 16,275 | 238,675 | 238,675 | |||||||
| Cost of Goods Sold | 154,500 | 8,300 | 162,800 | 162,800 | |||||||
| Bad Debt Expense | 4,497 | 4,497 | |||||||||
| Depreciation Expense – Building | 1,350 | 1,350 | 1,350 | ||||||||
| Depreciation Expense - Computer Equip | 890 | 890 | 890 | ||||||||
| Depreciation Expense - Office Furn | 650 | 650 | 650 | ||||||||
| Interest Expense | 3560 | 3,560 | 3,560 | ||||||||
| Insurance Expense | 38,950 | 38,950 | 38,950 | ||||||||
| Supplies expense | 72,860 | 72,860 | 72,860 | ||||||||
| Utilities Expense | 75,900 | 75,900 | 75,900 | ||||||||
| Wage Expense | 198,600 | 198,600 | 198,600 | ||||||||
| Subtotals | |||||||||||
| Net Income | |||||||||||
| TOTALS | $1,351,178 | $1,351,178 | 24-Sep-89 | 32,775 | 1,375,653 | 1,375,653 | 1,376,041 | 1,376,041 | |||
| NFT Consulting and Sales Inc | ||||||
| Multi Income Statement for the year ended 2017 | ||||||
| Service Revenue | 365400 | |||||
| Tablet Sale Revenue | 238675 | |||||
| Less : Cost of Goods Sold | -162800 | |||||
| Gross Profit C = (A-B) | 441275 | |||||
| Expenses | ||||||
| Bad Debt | 4497 | |||||
| Depreciation Expense – Building | 1350 | |||||
| Depreciation Expense - Computer Equip | 890 | |||||
| Depreciation Expense - Office Furn | 650 | |||||
| Interest Expense | 3560 | |||||
| Insurance Expense | 38950 | |||||
| Supplies expense | 72860 | |||||
| Utilities Expense | 75900 | |||||
| Wage Expense | 198600 | |||||
| Total Expenses (D) | 397257 | |||||
| Operating Profit (E= C-D) | 44018 | |||||
| Net Income | 44018 | |||||
| Statement of Retained Earnings | ||||||
| Opening Balance | 126867 | |||||
| Add :Net Income | 44018 | |||||
| less: Dividend | 4000 | |||||
| Closing Retained Earnings | 166885 | |||||
| Classified Balance Sheet | ||||||
| Assets | ||||||
| Current Assets | ||||||
| Cash & Cash equivalents | 332218 | |||||
| Account Receivable | 158966 | 154889 | ||||
| Less : Allowance for Uncollectible Accounts | -4077 | |||||
| Supplies | 42600 | |||||
| Inventory | 2550 | |||||
| Prepaid Insurance | 16800 | |||||
| Total Currents Assets (A) | 549057 | |||||
| Non-Current Assets | ||||||
| Land | 50000 | |||||
| Building | 110000 | |||||
| Less: Accumulated Depr – Building | -5670 | 104330 | ||||
| Computer Equipment | 52950 | 51200 | ||||
| less :Accumulated Depr – Comp Equip | -1750 | |||||
| Office Furniture | 45900 | 45010 | ||||
| less :Accumulated Depr – Office Furniture | -890 | |||||
| Total Non Current Assets (B) | 250540 | |||||
| Total Assets (A+B) | 799597 | |||||
| Total Liabilities & Shareholder equity | ||||||
| Current Liabilities | ||||||
| Accounts Payable | 24760 | |||||
| Interest Payable | 3200 | |||||
| Utilities Payable | 8952 | |||||
| Wages Payable | 45800 | |||||
| Total Current liabilities (A) | 82712 | |||||
| Non-Current liabilities | ||||||
| Long term Note Payable | 90000 | |||||
| Mortgage Payable | 60000 | |||||
| Total Current liabilities (B) | 150000 | |||||
| Shareholder equity | ||||||
| Common Stock | 400000 | |||||
| Retained Earnings | 166885 | |||||
| Total Shareholder equity (C ) | 566885 | |||||
| Total Liabilities & Shareholder equity (A+B+C) | 799597 | |||||