Soft Metric Cos prior to the commencement of trading were as follows. NEWBEGIN TOOLS STATEMENT OF FINANCIAL POSITION AS AT 1 January 2020 $ $ Non-current assets Motor vehicle 20,000 Shop fittings 15,000 35,000 Current assets Receivable 3,000 Inventories 12,000 Cash 13,000 63,000 Capital 43,000 Current liabilities Bank overdraft 11,000 Trade payables 9,000 20,000 63,000 During 12 months the business had made the following transactions. (a) Goods were purchased on credit at a list price of $15,000. (b) Trade discount received was 3% on list price and there was a settlement discount received of 5% on settling debts to suppliers of $11,000. These were the only payments to suppliers in the period. Closing inventories of goods were valued at $6,000. (c) All sales were on credit and amounted to $45,700. (d) Outstanding receivables balances at 31 December 2020 amounted to $4,500, of which $400 were to be written off. An allowance for receivables is to be made amounting to 3% of the remaining outstanding receivables. (e) Cash payments were made in respect of the following expenses. $ (i) Stationery, postage and wrapping 700 (ii) Telephone charges 300 (iii) Electricity 400 (iv) Cleaning and refreshments 260 (f) Cash drawings by the proprietor, of Soft Metric Co, amounted to $4,500. (g) The outstanding overdraft balance as at 1 January 2020 was paid off. Interest charges and bank charges on the overdraft amounted to $80. (h) Accumulated depreciation of Motor vehicle and Shop Fittings as at 1 January 2020 was respectfully 10,000 and 5,000. Figures above on non-current assets are net numbers. For example Motor Vehicles Historical cost 30,000, accumulated depreciation 10,000 therefore net number is 20,000 shown in statement above. Depreciation is to be provided for the year as follows: Motor vehicles: 20% on cost Fixtures and fittings: 10% reducing balance method Prepare the statement of profit or loss of Soft Metric Co Tools for the year end 31 December 2020 and a statement of financial position as at that date. Dont ignore depreciation.

( i want to see the working in excel or atleast see the details of how cash and other things are found)