Question: Please help me solve the below problem, please do it in excel and show how you did it The following is the statement of financial
Please help me solve the below problem, please do it in excel and show how you did it


The following is the statement of financial position of Bender& Brugal at the end of its first year of trading: Statement of financial position as at 31 December 2011 Assets Non-current assets 12,000 Delivery van at cost Depreciation 2,500 9,500 Current assets 65,000 Inventories 9,600 Trade receivables Prepaid utilities (excluding electricity) 300 5,000 Prepaid rent Cash 750 90,650 Total assets 100,150 Liabilities Current liabilities Trade payables 22,000 630 Accrued wages 620 Accrued electricity expense 23,250 Equity 50,000 Original equity Retained earnings 26,900 76,900 Total liabilities and equity 100,150 The following is the statement of financial position of Bender& Brugal at the end of its first year of trading: Statement of financial position as at 31 December 2011 Assets Non-current assets 12,000 Delivery van at cost Depreciation 2,500 9,500 Current assets 65,000 Inventories 9,600 Trade receivables Prepaid utilities (excluding electricity) 300 5,000 Prepaid rent Cash 750 90,650 Total assets 100,150 Liabilities Current liabilities Trade payables 22,000 630 Accrued wages 620 Accrued electricity expense 23,250 Equity 50,000 Original equity Retained earnings 26,900 76,900 Total liabilities and equity 100,150
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
