ABC company arrangements in the given format of Q1 and then it's entries on B/S sheet of ABC
Balance Sheet for Arrangement as per proforma - Microsoft Excel X Home Insert Page Layout Formulas Data Review View & Cut Cambria - 12 A A Wrap Text General Normal Bad Good E AutoSum - Copy Fill - Paste Format Painter B I Merge & Center % $68 :08 Conditional Format as Neutral Calculation Check Cell Formatting * Table 41 4 Insert Delete Format Clear Sort & Find & Filter * Select Clipboard Font Alignment Number Styles Cells Editing A1 A B C D E F G H J K L M Proforma of Balance Sheet Name of the Company : ABC Limited Balance Sheet as at : Figures as at the end of Current Figures as at the end of the Particulars Note Reporting Period Previous Reporting Period EQUITY AND LIABILITIES 1 Shareholders' Funds (a) Share Capital (b) Reserves & Surplus 10 (c) Money Received against Share Warrants 11 2 Share Application money pending allotment 12 3 Non-Current Liabilities 13 (a) Long Term Borrowings 14 (b) Deferred Tax Liabilities (Net) 15 (c) Other Long Term Liabilities 16 (d) Long Term Provisions 17 4 Current Liabilities 18 (a) Short Term Borrowings 19 (b) Trade Payables 20 (c) Other Current Liabilities 21 (d) Short Term Provisions 22 Total 23 24 II. ASSETS 25 1 Non-Current Assets 26 (a) Fixed Assets 27 (i) Tangible Assets 28 (ii) Intangible Assets A 1 Company Balance Sheet A 2 Company Balance Sheet Ready Average: 2.166666667 Count: 194 Sum: 13 8 100% + O 9 O 7:15 AM 10/10/2020 EBalance Sheet for Arrangement as per proforma - Microsoft Excel X Home Insert Page Layout Formulas Data Review View & Cut Calibri Light - 14 A A Wrap Text General Bad Good E AutoSum - En Copy Normal Fill - Paste Format Painter Merge & Center * % $68 408 Conditional Format as Neutral Calculation Check Cell Insert Delete Format Sort & Find & Formatting * Table 41 4 Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing D11 fix Building A B C D E F G 1 Question 1 Balance Sheet of ABC as on 31.03.2020 in Rs. Lakh 3 Particulars Amount Particulars Amount 4 Capita 400 Land 240 5 Bank Loan 600 Plant 340 6 Profits Earned 250 Sundry Debtors 200 7 Borrowing from friends and relatives 350 Patents 320 Creditors 100 Equipments 245 9 Bills Payable 40 Bills Receivables 41 10 Outstanding Rent for shop 15 Cash 69 11 Overdraft from ICICI bank 245 Building 230 12 Stock 315 13 Total 2000 Total 2000 14 15 Answer 1 16 Arranged Balance Sheet of ABC as on 31.03.2020 Amount in Rs. Lakh 17 Particulars Inner Outer Particulars Inner Outer 18 i) Capital Block i) Fixed Asses Block 19 a) Tangibles 20 21 22 23 24 ii) Long Term Labilities Block b) Intangibles 25 A 2 Company Balance Sheet Ready # 100% + LO O OOM 7:15 AM 10/10/2020
