Analysis of finical statement
VERY SHORT ANSWER AND SHORT ANSWER QUESTIONS
Q.1 Under What heads will you classify the followings:
1) Proposed Dividends
2) Interest Accrued and due on secured loans
3) Interest Accrued and due on unsecured Loans
4) Provision for Taxation
5) Arrears of fixed accumulative dividends
6) Security premium Account
7) Share Forfeiture account.
(Answer any four) – 2 Marks
Q.2 Under What headings will you show the following items in the Balance sheet of a company
1) Securities Premium account
2) Preliminary Expenses
3) Bills Receivable
4) Goodwill
5) Authorised share Capital
(Answer any four) – 2 Marks
Q.3 Prepare a Comparative Income statement with the help of the following information
| Particulars |
2005 |
2006 |
| Sales |
2000000 |
3000000 |
| Gross Profit |
40% |
30% |
| Indirect Expenses |
50% |
40% |
| Income Tax |
50% |
50% |
4 Marks
Q.4 Explain three purposes or objectives of Financial Analysis. 2 Marks.
Q.5 Mention three limitations of financial statement Analysis. 2 Marks
Q.6 From the following Balance Sheets U.K Ltd. on 31st Dec 2006 & 2007.Prepare comparative Balance Sheet.
Balance Sheet
As on 31st Dec 2006 & 2007
| Liabilities |
2006 |
2007 |
Assets |
2006 |
2007 |
| Current Liabilities |
200000 |
400000 |
Current Assets |
500000 |
900000 |
| Reserves |
300000 |
200000 |
Fixed Assets |
1000000 |
1500000 |
| 12% Loan |
500000 |
800000 |
|
|
|
| Share Capital |
500000 |
1000000 |
|
|
|
| |
1500000 |
2400000 |
|
1500000 |
2400000 |
Long Answer Questions 4 Marks
Q.7 (a) The ratio of current Assets (Rs. 600000) to current Liabilities ( Rs. 400000) is 1.5:1.The Accountant of the firm is interested in maintaining a current Ratio be 2:1 by paying off a part of Liabilities. Calculate the amount of Current Liabilities that should be paid.
(b) The Current Assets to Current Liability of a firm is Rs. 800000 to Rs. 300000. The Accountant of the firm wishes that current Ratio be 2:1 by acquiring current assets on credit. Calculate the amount of current Assets.
(3+3) = 6 Marks
Q.8 (a) A business has current Ratio of 4:1 & a Quick Ratio of 1.2:1 . If working capital is Rs. 180000. Calculate total current Assets and Stock
(b) Calculate current Ratio and Quick Ratio from the followings:
Working capital Rs. 150000, Total Debts Rs.400000, Long term debts Rs. 310000, Stock Rs. 110000, Prepaid Expenses Rs. 10000
Q.9 (a) Calculate current Ratio and Quick Ratio from the following information:
Total Assets Rs. 350000
Fixed Assets Rs. 175000
Investment Rs. 70000
Fictitious Assets Rs. 5000
Share holders fund Rs. 200000
Long term Debts Rs. 100000
Inventory Rs. 45000
(b) From the following information calculate the stock turnover ratio.
Sales Rs. 200000, G.P 25% on cost, Opening Stock was 1/3rd of the value of closing stock
Closing stock was 30% of sales
(3 + 3)=6 Marks
Q.10 (a) Determine the amount of gross profit and sales from the followings:
Debtors Turnover Ratio = 4 Times
Loss of goods sold = Rs. 640000
Gross Profit Ratio = 20%
Closing Debtors were Rs. 20000 more than at the beginning.
Cash sales being 33 1/3 % of credit sales.
(3 + 3)=6 Marks
Q.11 (a) If Current Ratio is 2:1 state giving reason of the following transaction would
(i) Improve (ii) Reduce or (iii) Not change Current Ratio
(1) Bills Receivable drawn
(2) Bills Receivable Dishonoured
(3) Bills Receivable endorsed to Creditors
(4) Sales of Goods for cash at par
(5) Sales of Goods for cash at Profit
(6) Sales of Assets for Cash
(7) Bills Payable given to creditors
(Answer any 4 Questions) 2 Marks
(b) If the Liquid ratio is 1:1, find whether the following transactions would
(ii) Improve (ii) Reduce or (iii) Not change Liquid Ratio
1) Purchase of goods for cash
2) Purchase of goods on credit
3) Payment of Tax Provision
4) Sales of short term investment at par
5) Sales of Investment at profit
(Answer any 4 Questions) 2 Marks
Q.12 (a) Calculate and Closing stock from the following information:-
Total sales Rs 600000
Gross Profit 25% on Sales
Stock Turnover Ratio = 5 times
Closing stock is Rs. 12000 more than opening stock
(b) Gross Profit Ratio of a company was 25%. Its cash sales were Rs. 200000 and its credit Sales was 90% of the total sales. If the indirect expenses of the Company were Rs. 20000. Calculate net Profit ratio.
(3 + 3)=6 Marks
Q.13 With the help of the following information. Prepare Comparative Income Statement of XYZ Ltd.
2007 2008
Sales 50000 80000
Cash of Goods Sold 60% of Sales 70% of Sales
Indirect Expenses 10% of Gross profit
Rate of Income Tax 50% of Net profit before tax
4 Marks
Q.14 (a) Calculate Return on Investment from the following
Gross Profit Rs.100000, Office Expenses Rs. 10000, Selling and Distribution expenses Rs. 25000, Interest on Bank Loan Rs. 8000, Income tax Rs. 12000, Fixed Assets Rs. 300000, Current Assets Rs. 150000 & Current Liabilities Rs. 125000
(b) Calculate the earning per share from the following data
15000 Equity Share of Rs. 10 each 150000
10 % Preference Share Capital 100000
Net Profit before Tax 55000
Q.15 The Debt-equity ratio of a company is 1:2, state giving reasons which of the following would improve, reduce or no change the ratio:-
1) Debenture redeemed for cash
2) Issue new equity shares
3) Payment of Proposed dividends
4) Goods Purchased on Credit
5) Goods Purchased on Cash
6) Redemption of Debentures against the Purchase of a Fixed Assets
(Answer any four ) – 2 Marks
CBSE HOTS SOLUTION
Ans 1
1) Provisions :- Proposed Dividend
2) Secured Loans : – Interest Accrued and due on Secured Loans
3) Unsecured Loans:- Interest Accrued and due on unsecured Loans
4) Provision : Provision for Taxation
5) Contingent Liabilities :- Arrears of Fixed Cumulative dividend
6) Reserves & Surplus :- Security Premium Account
7) Share Capital Account: – Share forfeiture Account.
Ans 2
1) Securities Premium Account :- Under Reserves & Surplus, Liabilities side
2) Preliminary Expenses :- Under Miscellaneous Expenditures, Assets side
3) Bills Receivables :- Under Loans & Advance on assets side.
4) Goodwill :- Under Fixed Assets, Assets side
5) Authorised Capital :- Under Share Capital, Liabilities side
Ans 3
Comparative Income Statement
For the year ended 31st Dec, 2006
| Particulars |
Absolute Change |
Change in Percentage |
| 2005 2006 |
Rs. % Changes |
| Sales
Less: Cost of Goods sold |
2000000
1200000 |
3000000
2100000 |
1000000
900000 |
50%
75% |
| Gross Profit
Less : Indirect Exp. |
800000
400000 |
900000
360000 |
100000
(40000) |
12.5%
10% |
| Profit before tax
Less: Tax 50% |
400000
200000 |
540000
270000 |
140000
70000 |
35%
35% |
| Net Profit after tax |
200000 |
270000 |
70000 |
35% |
Ans.4 Following are the purposes of Financial Analysis:
1) Judging earning capacity of business
2) Judging managerial efficiency of business
3) Judging short term long term Solvency
Ans 5 Following are the Limitation of Financial statement Analysis
1) Historical Analysis
2) Ignore price level changes
3) Quantities aspect ignored
Ans.6 Comparative Balance Sheet
For the year ended 31st Dec, 2006 & 2007
| Particulars |
2006 |
2007 |
Increase or
Decreases |
% Increase or
Decrease |
| Fixed Assets
Working Capital
(C.A-C.L) |
1000000
300000 |
1500000
500000 |
500000
200000 |
50%
66.7% |
| Capital Employed
Less 12% Loan |
1300000
500000 |
2000000
800000 |
700000
300000 |
53.8%
60% |
| Shareholders fund |
800000 |
1200000 |
400000 |
50% |
| Represented by share capital
Reserves |
500000
300000 |
1000000
200000 |
500000
(-) 100000 |
100%
-33.3% |
| |
800000 |
1200000 |
400000 |
50% |
Ans 7 A)
a) Let Current Liabilities = X
b)
Current Ratio after making payment of x is 2:1
Current Ratio = Current Assets / Current Liabilities
2 = 6000000-x
1 400000 – x
Rs. 800000-2 x= Rs600000 – x
Rs. 800000-600000=2x-x
Rs. 200000=x
Current Liabilities paid off Rs. 200000
B) Let amount of Current Assets Purchased on credit is = x
Current Ratio = Current Assets
Current Liabilities
2 = 800000+x
1 300000 + x
Rs. 600000 + 2x = Rs 800000 + x
2x-x=800000-600000
X= 200000
Current Assets be purchased Rs. 200000
Ans. 8 A) Current Ratio = Current Assets = 4
Current Liabilities 1
Let C.L = x
C.A= 4x
Working Capital = C.A- C.L
180000= 4x-x
180000=3x
X= 180000 = 60000
3
Current Assets = 4x = 4 * 60000 = Rs. 240000
Quick Ratio = Q.A = 1.2
C.L 1
Since Current Liabilities are = X
Liquid Assets = 1.2x
Liquid Assets = 1.2* 60000= Rs. 72000
Stock = C.A – Q.A
=240000-72000 = Rs. 168000
B) C.R = C.A
C.L
C.L = Total Debts – Long term debts
= 400000-310000= Rs. 90000
Working Capital = C.A – C.L
Rs. 150000 = C.A – 900000
C.A = 150000+ 90000
C.A = 240000
C.R = 240000 = 2.66:1
90000
Q.R = Q.A
C.L
Q.A= C.A – (Stock + Prepaid Expenses)
= 240000 – ( 110000 + 10000)
= 120000
Q.R = 120000 = 1.30:1
900000
Ans.9 A) Total Assets = Fixed Assets + Investment + Current Assets + Fictitious Assets
350000 = 175000+70000+Current Assets +5000
Current Assets = 350000-250000
Current Assets = 100000
Liquid Assets = Current Assets – Inventory
= 100000 – 45000 = 55000
Total Assets = Total Liabilities
Total Assets = Shareholders Fund + Long Term Debts +Current Liabilities
350000 = 200000+100000+Current Liabilities
Current Liabilities = 350000- 300000
Current Liabilities = 50000
Current Ratio = Current Assets
Current Liabilities
= 100000 = 2:1
50000
Quick Ratio = Quick Assets Current Liabilities
= 55000 = 1.1:1
50000
B) Stock Turnover Ratio = Cost of Sale
Average Stock
Sales = 200000
G.P = 25% on Cost
Let Cost of Sale = Rs. 100
G.P = 25
Sales 125
G.P = 200000 * 25 = 40000
125
Cost of Sales= Sales – G.P
= 200000-40000
= 160000
Closing Stock = 30 % of Sale
= 200000 * 30/100 = 60000
Opening Stock = 1/3 of Closing Stock
= 1/3 * 60000
= 20000
Average Stock = Opening Stock + Closing Stock
2
= 20000 + 60000/ 2
= 80000/2 = 40000
Stock Turnover Ratio = 160000 = 4 Times
40000
Ans 10 A) Inventory Turnover Ratio = Cost of Sales
Average Stock
6/1 = Cost of Sales
60000
Cost of Sales = 60000 * 6 = 360000
Case 1)
Let Cost of Sale = 100
G.P = 25 % above Cost
Sales = 125
If Cost of Sale 100 Sale = 125
If Cost of Sale 1 Sale = 125/100
If Cost of Sale 360000 = 125/100 * 360000
= 450000
Gross Profit = 450000 – 360000
= 90000
Case 2)
Let Sales= 100
G.P = -25/75
If Cost of Sale 75 Sales = 100
If Cost of Sale 1 Sale = 100/75
If Cost of Sales 360000 Sales = 100/75 * 360000
= 480000
Gross Profit = 480000 – 360000 = 120000
B) 1) Sales = Cost of Goods Sold – Gross Profit
Let Sales = 100
G.P = -20
Cost of Goods Sold = 80
If Cost of Good Sold 80 G.P = 20
If Cost of Goods Sold 1 G.P = 20/80
If Cost of Goods Sold 640000 G.P = 20/80*640000
= 160000
Thus Sales = 640000-160000 = 800000
2) Let Credit Sale = 100
Cash Sale = 33 1/3 = 100/3
Total Sale = 100 + 100/3 = 400/3
If Sales 400/3 Credit Sales = 100
If Sales 1 Credit Sales = 100* 3/400 = ¾
If Sale 800000 Credit Sales = ¾ * 80000 = 600000
Debtors Turnover Ratio = Net Credit Sales
Average Debtors
4/1= 600000
Average Debtors
Average Debtors = 600000*1 =150000
4
150000 = 2x+20000
2
2x = 300000-20000
X = 280000 = 140000
2
Hence Opening Debtors = 140000
Closing Debtors = 140000 + 20000
= 160000
Ans 11 A) B)
1) Not Change 1) Reduce
2) Not Change 2) Reduce
3) Improve 3) Improve
4) Not Change 4) Not Change
5) Improve 5) Improve
6) Improve
7) Not Change
Ans. 12 A) Sales = 600000
G.P = 600000*25/100 = 150000
Cost of Goods Sold = Sales – G.P
= 600000-150000 = 450000
Stock Turnover Ratio = Cost of Goods Sold
Average Stock
5/1 = 450000
Average Stock
Average Stock = 450000/5 = 90000
Opening Stock = Average Stock – ½ of Rs. 12000
= 90000-6000= 840000
Closing Stock = Average Stock + ½ of Rs 12000
= 90000 + 6000 = 960000
B) Net Profit Ratio = Net Profit * 100
Sales
Let Total Sales = 100
Credit Sales = 90 %
Cash Sales 10 % or 200000
Total Sales = 100/10* 200000
= 20000
G.P = 20000*25/100
= 500000
Net Profit = G.P – Indirect Expenses
= 500000 – 20000 = 480000
Net Profit Ratio = 480000 * 100
2000000
= 24 %
Ans 13 Comparative Income Statement of XYZ Ltd.
For the year ended 31st, Dec 1997 & 1998
| Particulars |
1997 |
1998 |
Absolute
Change |
Percentage
Change |
| A Sales |
50000 |
80000 |
30000 |
60% |
| B Less Cost of Goods Sold |
30000 |
56000 |
26000 |
86.67% |
| C Gross Profit (A-B) |
20000 |
24000 |
4000 |
20% |
| D Less Indirect Expenses |
2000 |
2400 |
400 |
20% |
| E Profit Before Tax (C-D) |
18000 |
21600 |
3600 |
20% |
| F Less Income Tax |
9000 |
10800 |
1800 |
20% |
| |
9000 |
10800 |
1800 |
20% |
Ans. 14 A)
Return on Investment = Profit before Interest & Tax * 100
Capital Employed
Profit before Interest & Tax = 100000-10000-25000= 65000
Capital Employed = 300000+150000-125000= 325000
ROI = 65000 * 100
325000
= 20%
B) E.P.S = Net Profit – Preferential Dividend
No. of Equity Shares
55000 – 10000
15000
45000 = 3 per Share
15000
Ans 15
1) Reduce
2) Increase
3) Decrease
4) Increase
5) Not Change
6) Increase
7) Increase
Recent Comments