Financial Statement Analysis Guide
Financial Statement Analysis Guide
[Link] which heads and subheads following items will appear in the balance sheet of a
company as per schedule III of the companies act 2013?
a) Premium on redemption of debentures
b) Loose tools
c) Balances with banks
d) Tax reserves
e) Interest on calls in advance
f) Stores and spares
2. Prepare a Comparative Statement of Profit & Loss from following information:
Particulars 2013 2014
Revenue from operations 500% of other income 500% of other income
Other incomes 1,00,000 1,50,000
Cost of Material Consumed 50% of operating revenue 60% of operating revenue
Other Expenses 10% of Material Consumed 10% of Material Consumed
Tax 30% 30%
3. Calculate Gross profit Ratio and Operating Ratio from the following:
Particulars Rs.
Opening Stock 20,000
Closing Stock 30,000
Gross Profit 29,000
Interest from Securities 4,000
Loss by Theft 13,000
Administration Expenses 9,000
Selling Expenses 12,000
Office Expenses 6,000
Sales 70,000
[Link] the following information of Jag Jivan Ltd, prepare cash flow statement as on 31 st
March 2013:
Particulars Note 31st March 31st March
No. 2013 2012
I. Equity & Liabilities
1. Shareholders Funds
a) Share Capital 65,000 45,000
b) Reserve & Surplus 1 42,500 24,000
2. Current Liabilities
Trade Payables 11,000 8,700
Total 1,18,500 77,700
II. Assets
1. Non Current Assets
Fixed Assets 83,000 46,700
2. Current Assets
a) Inventories 13,000 11,000
b) Trade Receivables 19,500 18,000
c) Cash in Hand 3,000 2,000
Total 1,18,500 77,700
Notes to Accounts
Particulars 31st March 31st March
2013 2012
1. Reserve & Surplus
General Reserves 27,500 15,000
Surplus in P & L A/c 15,000 9,000
Additional Information: Depreciation on Fixed Assets for the year 2012-13 was Rs. 14,700 .An
Interim Dividend paid Rs.7,000.
Analysis of financial statement (sheet-9)
1. Under which heads and subheads following items will appear in the balance sheet of a
company as per schedule III of the companies act 2013?
a) Mining rights
b) Encashment of employees earned leave payable on retirement
c) Vehicles
d) Subsidy reserve
e) Provision for doubtful debts
f) Debentures
2. From the following statement prepare common size income statement of VK Limited
for the years ended 31st March 2010 and 2009.
3. Working capital Rs. 2,50,000; Cost of Revenue from operation Rs. 10,00,000; Gross profit on sale
25% . Calculate working capital turnover ratio from the above information.
Additional Information: Depreciation on Fixed Assets for the year 2012-13 was Rs.
20,000 .Income Tax paid in advance Rs.5,000.
[Link] which heads and subheads following items will appear in the balance sheet of a
company as per schedule III of the companies act 2013?
a) Calls in advance
b) Proposed dividend
c) Computer software
d) Capital reserve
e) Bank overdraft
f) Securities premium reserve
2. From the following information, prepare Comparative Statement of Profit & Loss:
Particulars 2012 2013
Revenue from Operations 500% of other income 500% of other income
Other income 40,000 50,000
Cost of Material Consumed 60% of Revenue from operations 50% of Revenue from operations
Other Expenses 2.5% of Cost of Material Consumed 2.5 % of Cost of Material Consumed
Tax 30% 30%
3. Opening Trade payable Rs. 1,00,000, Opening Bills Payable Rs. 1,50,000, Closing Trade payable Rs.
2,00,000, Closing Bills Payable Rs. 50,000; Purchases Rs. 16,00,000 Cash Purchases Rs. 5,00,000. Out
of Total Credit Purchases, Purchases return Rs. 1,00,000. Calculate Trade payable Turnover Ratio.
4. From the following Balance Sheet of XY Ltd., as on 31-3-2018 and 31-3-2019, prepare a Cash Flow
statement:
Particulars Note 2019 2018
No.
I. EQUITY & LIABILITIES (₹) (₹)
(1) Shareholders Fund
a. Share Capital 1 8,50,000 4,60,000
b. Reserve & Surplus 2 1,70,000 2,40,000
(2) Non-Current Liabilities
Long term Borrowings 3 1,80,000 2,00,000
Total 12,00,000 9,00,000
II. ASSETS
(1) Non-Current Assets
Fixed assets
i. Tangible assets 4 6,70,000 4,60,000
ii. Intangible assets 5 30,000 40,000
(2) Current assets
a. Current Investments 20,000 15,000
b. Inventories 2,50,000 2,10,000
c. Trade Receivables 1,90,000 1,40,000
d. Cash & Cash Equivalents 40,000 35,000
Total 12,00,000 9,00,000
NOTES TO ACCOUNTS: -
31.3.2019 31.3.2018
(₹) (₹)
1: Share Capital
Equity Share Capital 7,50,000 4,00,000
8% Preference Share Capital 1,00,000 60,000
8,50,000 4,60,000
2: Reserve & surplus
General Reserve
Balance in Statement of Profit and Loss 50,000 70,000
1,20,000 1,70,000
3: Long-term Borrowings 1,70,000 2,40,000
10% Debentures
1,80,000 2,00,000
4. Fixed Assets-Tangible Assets
Machinery
Computer 5,45,000 3,20,000
Furniture 90,000 1,00,000
35,000 40,000
5. Fixed Assets-Intangible Assets 6,70,000 4,60,000
Computer Software
30,000 40,000
Additional Information:
1. During the year, machine costing Rs. 90,000 (Book value Rs. 80,000) was sold for Rs. 50,000.
2. Depreciation charged during the year on machine was Rs. 30,000.
3. 10% Debentures were converted into Equity shares.
4. Dividend paid was s. 80,000.
[Link] which heads and subheads following items will appear in the balance sheet of a
company as per schedule III of the companies act 2013?
Balances with bank
Term loan from Bank
Goods in transit
Loan repayable on demand
Unpaid dividend
Cash in hand
2. Prepare Common income statement from the following information for the years ended march
31,2003 and 2004.
Particulars 2017(Rs.) 2018(Rs.)
3. From the following information, calculate Opening and closing trade receivables , If trade
receivable Turnover ratio is 3 Times:
a) Cash Revenue from operation is 1/3 rd of credit revenue from operation.
b) Cost of revenue from operation is Rs. 3,00,000
c) Gross profit is 25% of the Revenue from operation.
d) Trade receivable at the end 3 times more than that of in the beginning.
4. From the following Balance Sheet of Vishva Ltd., prepare a cash flow statement as per AS-3
(Revised) for the year ending 31st March, 2018:
Particulars Note 31.3.18 31.3.17
No.
I. EQUITY & LIABILITIES (₹) (₹)
(3) Shareholders fund
c. Share capital 1,02,000 84,000
d. Reserve & surplus 1 36,000 22,560
(4) Non-Current Liabilities
Long –term Borrowings 2 60,000 48,000
(5) Current Liabilities
a. Short-term Borrowings 3 10,000 5,000
b. Trade payables 28,800 36,000
c. Short-term Provisions 4 16,800 18,000
II. ASSETS
(3) Non-Current Assets
a. Fixed assets
Tangible assets 5 1,18,800 1,32,000
(4) Current assets
e. Inventories 61,800 45,600
f. Trade Receivables 6 33,600 27,600
g. Cash & cash 39,400 8,360
Equivalents 2,53,600 2,13,560
Total
NOTES TO ACCOUNTS: -
31.3.2018 31.3.2017
(Rs.) (Rs.)
2. Prepare Comparative income statement from the following information for the years ended march
31,2003 and 2004.
Particulars 2017(Rs.) 2018(Rs.)
Additional Information: During the year a building having book value Rs. 50,000 was sold at a
loss of Rs. 2,000 and depreciation charged on Building was Rs. 4,000.
Analysis of financial statement (sheet-5)
[Link] which heads and subheads following items will appear in the balance sheet of a
company as per schedule III of the companies act 2013?
a) Long term provisions
b) Long term loans
c) Trademark
d) Draft in hand
e) Bonds
f) Capital reserve
2. From the following balance sheet of Vikas Ltd. As on 31.3.12 and 31.3.13, prepare a
comparative balance sheet
Particulars Note 31.3.12 (Rs) 31.3.13(Rs.)
no.
[Link] & LIABILITIES
Shareholders fund
Share capital 90,000 1,30,000
Reserve & surplus 50,000 85,000
Current Liabilities
Trade payables 17,400 22,000
Total 1,57,400 2,37,000
II. ASSETS
Non current assets
Fixed assets
Tangible assets 93,400 1,66,000
Current assets
Inventories 22,000 26,000
Trade Receivables 36,000 39,000
Cash & cash Equivalents 5,000 6,000
Other current assets 1,000 -
Total 1,57,400 2,37,000
[Link] the following information of Reliance Ltd, prepare cash flow statement as on 31 st
March 2013:
Particulars Note 31st March 31st March
No. 2013 2012
I. Equity & Liabilities
1. Shareholders Funds
a) Equity Share Capital 9,00,000 6,00,000
b) Reserve & Surplus 3,00,000 1,50,000
2. Non Current Liabilities
Bank Loan 1,50,000 3,00,000
3. Current Liabilities
a) Trade Payables 67,500 90,000
b) Short Term Provisions 1 1,95,000 1,80,000
Total 16,12,500 13,20,000
II. Assets
1. Non Current Assets
a) Fixed Assets
iii) Tangible: Building 9,00,000 9,00,000
iv) Intangible: Patents 62,500 75,000
b) Non Current Investments 1,12,500 -------
2. Current Assets
a) Inventories 22,500 15,000
b) Trade Receivables 3,82,500 3,00,000
c) Cash & Cash Eq. 1,32,500 30,000
Total 16,12,500 13,20,000
Notes to Accounts
Particulars 31st March 2013 31st March 2012
1. Short Term Provisions
Provision for Tax 1,05,000 60,000
Proposed Divedend 90,000 1,20,000
Additional Information: During the year a building having book value Rs. 1,25,000 was sold at
a loss of Rs.8,000 and depreciation charged on Building was Rs. 20,000.
[Link] the following information of HCL Ltd, prepare cash flow statement as on 31 st March
2013:
Particulars Note 31st March 31st March
No. 2013 2012
I. Equity & Liabilities
1. Shareholders Funds
a) Equity Share Capital 3,00,000 2,00,000
b) Reserve & Surplus 1 (5,000) 35,000
2. Non Current Liabilities
12% Debentures 1,20,000 1,40,000
3. Current Liabilities 45,000 15,000
Additional Information:
1. Debentures were redeemed on 1St April 2012
2. During the year a machine included in fixed assets costing Rs. 60,000 was purchased and
another machine having book value Rs. 18,000 was sold at a loss of Rs. 2,000.
Analysis of financial statement (sheet-2)
[Link] which heads and subheads following items will appear in the balance sheet of a
company as per schedule III of the companies act 2013?
a) Patents
b) General reserve
c) Bills receivable
d) Tax reserve
e) Subsidy reserve
f) Provision for doubtful debts
2. From the following balance sheet, Prepare common size balance sheet
Equity and Liabilities 31.12.2009 31.12.2010
Shareholders fund:
Equity Share capital 80,000 80,000
12%Preference share capital 20,000 -
Reserve and Surplus:
P&L 2,400 2,000
General Reserve 4,000 4,000
Noncurrent liabilities:
15%debentures 14,000 12,000
Current liabilities:
Creditors 22,000 24,000
Provision for Taxation 8,400 6,000
Proposed Dividend 11,600 10,000
Total
1,62,400 1,38,000
Assets 31.12.2009 31.12.2010
Noncurrent assets:
Fixed assets 80,000 82,000
Less: Accumulated Depreciation 30,000 22,000
50,000 60,000
Current assets:
Stock 70,000 60,000
Debtors 48,000 40,000
Bank 7,000 2,400
Bank overdraft (13,600) (25,000)
Prepaid expenses 1,000 600
Total 1,62,400 1,38,000
3. Calculate Debt Equity Ratio from the following. Total Assets 1,25,000; Total Debts 1,00,000;
Current liabilities 50,000
[Link] the following information of Vishesh Ltd, prepare cash flow statement as on 31 st
March 2013:
Particulars Note 31st March 31st March
No. 2014 2013
I. Equity & Liabilities
1. Shareholders Funds
a) Equity Share Capital 8,00,000 6,00,000
b) Reserve & Surplus 1 5,00,000 4,00,000
2. Non Current Liabilities
12% Public Deposits 1,20,000 80,000
3. Current Liabilities
Trade Payables 50,000 70,000
Additional Information: During the year Building costing Rs. 75,000 was purchased. Loss on
sale of Building amounted to Rs. 5,000. Rs. 12,000 depreciation was charged on Building.