Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Apologies for the screenshot , I couldnt upload xcel sheet I did much of the work so I want to know how to calculate the
Apologies for the screenshot , I couldnt upload xcel sheet
I did much of the work so I want to know how to calculate the following
Income Statement
Operating profit and net-what to add and subtract
Balance Sheet
Net assets and net liabilities- how to find out each
What does it mean by accrued liabilites? Everything is paid up in advance apart from utilites(energy and staff on costs which are paid in arrears)
There is no inventory as it has been used up. I assume its zero? Do i subtract depreciation expense from the assets?
Thats all. Thanks
CASH IN 269 210 100.000 18,000 Equity - self & family Long term debt Cash - direct from homeoners Cash - from other retailers Cash - large clients Total cash in 19,800 26,325 21,800 28,958 23 6251 74,383 23.9601 31 883 28.958 84,800 26,360 35,042 31,883 93,284 29,000 38,552 35,042 102,593 31,8801 42,413 38,552 112,844 35,0801 46,625 42,413 124,117 269.210 200.000 205,880 249.795 200,471 1,125,356 369,210 0 100.000 18.000 46.125 CASH OUT 37,500 9,000 29.025 30,000 7.2001 9.375 2.250 1.200 31,928 30,000 7,200 7,500 1,800 1.200 250 35.153 37,500 9.000 7.500 1,800 4,500 500 38,636 30,000 7 200 9,375 2.250 4,950 42.506 30,000 7,200 7,500 1,800 5,450 500 46,763 37,500 9,000 7,500 1,800 5.990 500 51,407 30,000 7.2001 9,375 2.250 6,590 625 19,500 56,567 30,000 7,200 7,500 1,800 7.250 500 37,500 9,000 7,500 1,800 7,970 500 2501 100 2501 Cash to suppliers Staff pay - workshop Staff pay - showroom Staff on-costs - workshop Staff on-costs-showroom Energy & water - workshop Energy & water - showroom Premises - deposit & rent Shop fittings Rates Capital - plant Capital - van Marketing Interest on Long-term loan Total cash out 625 19,500 19,500 331,982 330.000 79.2001 73,125 17.550 45,600 4.450 78,000 50.000 32.400 260.000 20,000 28,000 10.500 1,360,807 16,667 3,600 3.600 3,600 3.600 3 ,600 3,600 3.600 19,500 16 667 3,600 260.000 20.000 10.000 1.000 410,067 3,600 500 20,000 500 17,517 10,000 500 74,017 1,000 1.000 85,478 1.000 1.000 101,553 1.000 1.000 118,136 1.000 1.000 100,556 1.000 1.000 114,653 1.000 1.000 132,547 1.000 1.000 116 417 1.000 1.000 69,870 Cash surplus/deficit for month Opening balance bought forwards Closing balance carried forwards 349,210 0 349,210 -17517 349,210 331,693 -74,017 331,693 257,677 -310,067 257,677 -52,390 -67.478 52,390 - 119,868 -55,428 - 119,868 -175.295 43,753 - 175,295 219,048 -15,756 -219.048 234,804 -21,369 234,804 -256,172 -29,954 - 256,172 -286,126 -3,573 286,126 -289,698 54,247 2 89,698 -235,451 -235,451 235,451 Income Statement January - December Revenues less COGS (raw mats) 656,146 331.982 324,164 Staff - workshop - wages Staff - workshop-on-costs Staff - showroom - wages Staff - showroom - on-costs Energy etc. - Workshop Energy etc - showroom Rent Rates Depreciation - equipment Depreciation - van Depreciation - Fittings Marketing exes Total Expenses Operating Profit linterest on long term loan Net profit before tax Tax @ 20% 330.000 73125 79.200 17.550 45.600 4.450 78,000 50.000 26,000 4,000 6.143 28.000 742.068 -85 922 10.500 -96.422 Profit after tax Balance Sheet @ 31st December | Possible Marks 234.000 16.000 43.857 293.857 1 1 1 Non-current assets Equipment Van Fixtures & Fittings Sub-total Current Assets Inventory Receivables - retailers Receivables - corproates Prepaid deposit Rent Rates Cash in bank (if applicable) Sub-total 0.25 0.25 0.25 51,305 97,929 50,000 78,000 32,400 - 150.000 159,634 3 0.5 Current Liabilities Accruals Staff an-costs Energy - workshop Energy - showroom Sub-total 9,300 7.970 500 17,770 0.5 Non-current liabilities Bank loan long-term) 189.500 0.5 Net Assets 246,221 2.5 Equity Retained profit/loss Owners Equity Total Equity -100,000 269,210 169.210 0 75 2.5Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started