NEED IN VERTICAL PLEASE

Total Marks: 20 The following Trial Balance was extracted from the books of Mr. George Britto's, a trader at December 31, 2011 DEBIT CREDIT 22,501 12,103 46,500 42,502 12,500 DETAILS Debtors and Creditors Plant and Machinery Purchases and Sales Drawings and Capital (January 1) Premises & Mortgage Cash in Hand Cash at Bank Discount Allowed & Received Bad Debts 145,000 111,500 38,500 55,000 2,502 37,500 1,252 2,002 1,200 10,500 Motor Vehicles Commission 6,500 Insurance Premiums 550 Office Furniture 2,500 22,500 Stock 4,500 750 2,302 12,150 Rent & Rates Returns Inwards and Outwards Office Salaries Wages Lighting & Heating Expense TOTAL 27.500 2,500 311,407 311,407 The following matters are to be taken into account:- (a) Stock-in-Trade, December 31, 2011 $18,950. (b) Wages accrued, December 31, 2011 $2,500 (c) Rates paid in advance, December 31, 2011 $500, d (d) The provision for bad debts is to be created by $400. (e) Provide for depreciation on the Motor Car on the basis that it will be in service for four (4) years and will then be traded in for $500. (f) Net profit for the period $41,450. Required:- Prepare Mr. George Britto's Balance Sheet as at December 31, 2011. (Trading and Profit & Loss account is not required) You must use Vertical Presentation Format for preparing the Balance Sheet