Basic accounts_complete the missing work in my excel
sharadgreen
to_edit.xlsxincome statement
| Gross profit | 1150000 | |||
| Expenses | ||||
| Plant manager salary and benefit | 43050 | |||
| employees salary and benefit | 187500 | |||
| Lease expenses | 60000 | |||
| utilities | 12000 | |||
| repairs and maintainance | 6000 | |||
| supplies | 2400 | |||
| delivery expenses | 70000 | |||
| miscellanous | 3000 | |||
| depreciation | 16000 | |||
| operating lease | 10000 | |||
| sales personnel salary and benefits | 116000 | |||
| commission | 5000 | |||
| auto expenses | 24000 | |||
| sales representative | 50000 | |||
| office supply | 36000 | |||
| insurance | 36000 | |||
| legal fees | 6000 | |||
| admin expenses | 6000 | |||
| interest | 56000 | |||
| promotions and adverts | 50000 | |||
| bad debts | 25000 | |||
| office salary | 82350 | |||
| travel and entertainment | 24000 | |||
| 926300 | -926300 | |||
| Operating profit | 223700 | |||
| profit share with employees(5% 0f 223700) | 11185 | |||
| Tax(25% of 223700) | 55925 | |||
| 67110 | -67110 | |||
| Net profit | 156590 |
balance sheet one
| Assets | Capital and Liabilities | |||
| Current asets | ||||
| Inventory | 600000 | |||
| cash | 920000 | |||
| bank | 600000 | |||
| fixed assets | ||||
| machinery and equipment | 80000 | |||
| Current liability | ||||
| creditors | 600000 | |||
| bank overdraft | 200000 | |||
| Long term liabilities | ||||
| Bank Loan | 400000 | |||
| Capital | 1000000 | |||
| 2200000 | 2200000 |
balance sheet two
| Finding cost of sales | |||||
| Sales | 5000000 | ||||
| Gross profit | -1150000 | ||||
| Cost of goods sold | 3850000 | ||||
| Assets | Capital and Liabilities | ||||
| Current assets | |||||
| Cash | 20000 | ||||
| Debtors | 571757 | ||||
| bank | 600000 | ||||
| inventory | 641666 | ||||
| Fixed asset | |||||
| Equipment and machinery | 64000 | ||||
| Liabilities | |||||
| Accrued Liabilities | 20000 | ||||
| Loan | 400000 | ||||
| Creditors | 320833 | ||||
| Capital | 1000000 | ||||
| profit | 156590 | ||||
| 1897423 | 1897423 | ||||
Cash flow
| Cash flow from operating Activities | ||||
| Net Profit | 156590 | |||
| Depreciation | 16000 | |||
| Receivable | 571757 | |||
| inventories | -641666 | |||
| creditors | -320833 | |||
| accrued liabilities | 20000 | |||
| -198152 | ||||
| Cashflow from investing activities | ||||
| purchase of machinery | -80000 | -80000 | ||
| Cashflow from financing activities | ||||
| Net change in short-term loan | -200000 | |||
| payment of long term loan | -80000 | |||
| Purchases | -3808334 | |||
| Net decrease in cash | -900000 | |||
| Cash at the beginning | 920000 | |||
| bank | 600000 | |||
| -3468334 | -3468334 | |||
| Cash and cash equivalent of the period that ended | -3746486 |
