BEFA - Unit-5 Notes
BEFA - Unit-5 Notes
Analysts rely on current and past financial statements to obtain data to evaluate the financial performance of a
company. They use the data to determine if a company’s financial health is on an upward or downward trend and to
draw comparisons to other competing firms.
Ratio analysis is a quantitative method of gaining insight into a company's liquidity, operational efficiency, and
profitability by studying its financial statements such as the balance sheet and income statement. Ratio analysis is a
cornerstone of fundamental equity analysis.
Investors and analysts employ ratio analysis to evaluate the financial health of companies by scrutinizing past and
current financial statements. Comparative data can demonstrate how a company is performing over time and can be
used to estimate likely future performance. This data can also compare a company's financial standing with industry
averages while measuring how a company stacks up against others within the same sector.
Investors can use ratio analysis easily, and every figure needed to calculate the ratios is found on a company's financial
statements.
Ratios are comparison points for companies. They evaluate stocks within an industry. Likewise, they measure a company
today against its historical numbers. In most cases, it is also important to understand the variables driving ratios as
management has the flexibility to, at times, alter its strategy to make its stock and company ratios more attractive.
Generally, ratios are typically not used in isolation but rather in combination with other ratios. Having a good idea of the
ratios in each of the four previously mentioned categories will give you a comprehensive view of the company from
different angles and help you spot potential red flags.
Limitations of Ratio Analysis
While ratios are very important tools of financial analysis, they do have some limitations, such as
The firm can make some year-end changes to their financial statements, to improve their ratios. Then the ratios
end up being nothing but window dressing.
Ratios ignore the price level changes due to inflation. Many ratios are calculated using historical costs, and they
overlook the changes in price level between the periods. This does not reflect the correct financial situation.
Accounting ratios completely ignore the qualitative aspects of the firm. They only take into consideration the
monetary aspects (quantitative)
There are no standard definitions of the ratios. So firms may be using different formulas for the ratios. One such
example is Current Ratio, where some firms take into consideration all current liabilities but others ignore bank
overdrafts from current liabilities while calculating current ratio
And finally, accounting ratios do not resolve any financial problems of the company. They are a means to the
end, not the actual solution.
TYPES OF
RATIO’S
1. Liquidity Ratios
This type of ratio helps in measuring the ability of a company to take care of its short-term debt obligations. A higher
liquidity ratio represents that the company is highly rich in cash.
The types of liquidity ratios are: – a. Current Ratio or Working Capital Ratio
a. Current Ratio: The current ratio is the ratio between the current assets and current liabilities of a company.
The current ratio is used to indicate the liquidity of an organization in being able to meet its debt obligations in
the upcoming twelve months. A higher current ratio will indicate that the organization is highly capable of
repaying its short-term debt obligations.
b. Quick Ratio: The quick ratio is used to ascertain information pertaining to the capability of a company in paying
off its current liabilities on an immediate basis.
Example 1:
From the Balance Sheet of XYZ Co. Ltd., calculate liquidity ratios.
Land and
Preference share capital 100 225
Buildings
Furniture and
General reserve 250 100
Fixtures
1500 1500
Solution:
Current assets = Stock + Debtors + Cash at Bank + Cash in hand + Prepaid expenses + Marketable securities.
= 200+ 50 + 50 = 300
Quick assets = Debtors + Cash at Bank + Cash in hand + Marketable securities. = 125 + 250 + 125 + 125 = 625
Formula
Note 1. When cost of goods sold is not given, sales amount should be taken into account.
2. When opening stock is not given, closing stock is considered as ‘average stock’.
Example:
A firm sold goods worth Rs. 5,00,000 and its gross profit is 20% of sales value. The inventory at the
beginning of the year was Rs. 16,000 and at end of the year was 14,000. Compute inventory turnover ratio and
also the inventory holding period.
Solution:
Cost of goods sold = Sales – Gross profit = 5,00,000 – (5,00,000 x 20%) = 4,00,000.
opening stock +closingstock 16000+14000
Average stock= = =15000
2 2
365 days 365
b ¿ Inventory Holding Period= = =14 days
Inventory Turnover Ratio 26.66
Net Credit Sales = Credit sales – Sales Returns (or) Total sales – cash sales – sales return
Note: When credit sales are not given, total sales are taken.
Example:
A firm’s sales during the year were Rs. 400000 of which 60% were credit sales. The balance of debtors at the
beginning and ending year were 25000 and 15000 respectively. Calculate debtor’s turnover ratio of the firm
and also find out debt collection period.
Solution:
Net Credit Purchases = Credit Purchases – Purchase Returns (or) Total purchases – cash Purchases – Purchase
Returns
Note: 1. When credit purchases are not given, total purchases are taken.
Example:
A firm’s purchases during the year was Rs. 400000 of which 50% were credit purchases. The balance of
creditors at the beginning and ending year were 30000 and 10000 respectively. Calculate creditors turnover
ratio of the firm. Also find out creditors payment period.
Solution:
Example:
Calculate Debt – Equity ratio from the following data.
Debentures Rs. 4,00,000, Long term loans Rs. 2,00,000, Preference share capital Rs. 1,00,000, Equity share
capital Rs. 1,50,000, General reserve Rs. 2,50,000, Profit & Loss account Rs. 1,00,000.
Solution:
Debt = 4,00,000 + 2,00,000 = 6,00,000
Equity = 1,00,000 + 1,50,000 + 2,50,000 + 1,00,000 = 6,00,000
Debt 6 , 00,000 1
Debt −Equity= = = =1 :1
Equity 6 , 00,000 1
Example:
EBIT of a company is Rs. 560000. Its fixed commitments include payment of 10 percent on 7000 debentures of
Rs. 100 each. It is subject to tax of 30 percent per annum. Calculate interest coverage ratio.
Solution:
3. Proprietary Ratio:
The proprietary ratio is the proportion of shareholders' equity to total assets, and as such provides a rough
estimate of the amount of capitalization currently used to support a business.
If the ratio is high, this indicates that a company has a sufficient amount of equity to support the functions of
the business, and probably has room in its financial structure to take on additional debt, if necessary.
Thus, the equity ratio is a general indicator of financial stability.
Proprietors’ Funds = Equity share capital + Preference share capital + General reserve + Employee Provident
Fund + profit and loss account.
Total Assets = Tangible assets and Current assets
Example 1:
From the Balance Sheet of XYZ Co. Ltd., calculate liquidity ratios.
Solution:
Proprietors’ Funds = 100+150+250+100=600
Total assets = 225+250+100+250+125+250+125+50+125=1500
Example:
Net sales is Rs. 50,000 for a firm and cost of goods sold is Rs. 20,000.
Calculate gross profit ratio.
Solution:
Gross profit = Net sales – Cost of goods sold = 50000-20000 = 30000
Example: Particulars Rs Rs
Solution: 22000
Example:
Calculate operating ratio from the following data.
Net sales Rs. 50000
Cost of goods sold Rs. 20000
Administration Expenses Rs. 3000
Selling and Distribution expenses Rs 4000
Loss on sale of fixed assets Rs. 3000
Interest on investment received Rs. 2000
Tax 20%
Profit Before Interest and Tax (PBIT) = Gross profit – All expenses and losses + All incomes
Capital employed = Equity share capital + Preference share capital + Reserves + Long term loans + Debentures
– Intangible assets
(or) = Fixed assets + Current assets – Current liabilities
EPS is the relationship between net profit and the number of equity shares outstanding at eth end of the given
period.
Example
Given that the number of share is 10000 and the net profit after taxes for a given period is Rs. 450000, the
EPS can be calculated as follows
Solution:
Example:
Given that current market price of a share Rs. 300; face value of the share is Rs. 100; percentage of dividend
declared is 20%, the yield is;
Solution:
Example: Given that market price of a share is Rs. 340 and EPS is 10, calculate P/E ratio. Solution:
Problem 1:
The following an extract of a balance sheet of a company during the last year. Compute current ratio and
quick ratio.
Given the following data, calculate Debt-equity ratio, Interest coverage ratio and
Proprietary funds to total assets ratio.
The term FLOW refers to change or transfer. The term „Fund flow‟ or „Flow of funds‟ may thus mean
transport of:
“Fund” is considered as working capital while preparing “Funds flow statement”. Fund flow means change in
the working capital. In other words, any increase or decrease in working capital means
“Flow of funds”. Any transaction which has one current account and the other non-current account results in
change in the working capital.
Current accounts: - Current assets accounts and current liabilities accounts are called current accounts.
Assets which are converted into cash within a year are called current assets. Liabilities which are to be paid
within a year are called current liabilities.
Non-current account: - Accounts which are not current accounts are called non-current accounts. For
example, fixed assets accounts long term liabilities accounts, and capital & reserves accounts.
Funds flow statement is prepared by observing the items taken place during the periods of two balance sheets
along with the adjustments into consideration.
I. Statement of changes in working capital: - this statement reveals the net change in the working capital
(CA – CL). Current assets and current liabilities are as follows.
2. By observing balance sheets and accounts for adjustments, non-Operating expenses and non-cash
payment items (debit items of profit and loss account) are to be added to given net profit and all non-
operating incomes & non-cash received items (credit items of profit and loss A/C) are to be deducted
from given net profit to find the funds from operations.
Note:- When tax paid is not given, it is considered that the tax provided in the previous
year is paid in the current year.
Note: - When dividend paid is not given, it is considered that the dividend proposed in the previous year is
paid in the present year.
Note: - It can be found even if any one of the items is not given in the above said accounts.
2.In case provision for tax and proposed dividend are taken as current liabilities, there is no need to
prepare those accounts. These should be shown in the “statement of changes in working capital” only.
If these both are taken as an appropriation of profit (unlike current liabilities), there is a need to
prepare their accounts to know the hidden information. Provision for tax and proposed dividend are to
be added to the net profit to know the funds from operations and tax paid & dividend paid are shown
on the applications‟ side in the funds flow statement.
1. By examining the non-current assets and liabilities, show as a source if cash comes and as an
application if cash goes out.
2. Show non-operating income as a source and non-operating expenses as an application.
3. Through adjustment items, if cash comes in show as a source and if cash goes out show as an
application.
4. If goodwill shows increase, take on the applications‟ side.
Note: - In order to say in single sentence, except the items taken in the “statements of changes in
working capital and funds from operations”, take as a source when cash comes through all other items
and take as an application when cash goes out through all other items.
PRACTICE PROBLEMS
1. Prepare:
1. Statement of changes in working capital and
2. Funds flow statement from following balance sheets of Vijaya Mitra Ltd., as on 31-03-2016 and 31-03-
2017:
Adjustments:
1. Dividend declared and paid Rs. 25000
2. Additional plant purchased Rs. 5000
3. Tax paid during the year Rs. 45000
Solution:
Working notes:
Plant and Machinery A/C
Particulars Amount Particulars Amount
To Opening By P&L A/C (Depn.)
balance 90000 b/f 20000
To Bank
(purchase) 50000 By Closing balance 120000
140000 140000
Dividend A/C
Particulars Amount Particulars Amount
By P&L A/C (provi.)
To Bank A/C 25000 b/f 25000
25000 25000
Tax A/C
Particulars Amount Particulars Amount
By P&L A/C (provi.)
To Bank A/C 45000 b/f 45000
45000 45000
Solution:
STATEMENT OF CHANGES IN WORKING CAPITAL
Previous Current Working capital
Particulars year year Increase Decrease
A. Current Assets
Cash 415000 1023000 608000
A 415000 1023000
B. Current Liabilities
Credotors 80000 200000 120000
Bills payables 20000 30000 10000
Working Notes:
Machinery A/C
Particulars Amount Particulars Amount
To Opening balance 120000 By P&L A/C (Depn.) 15000
To Bank (purchase)
b/f 55000 By Closing balance 160000
175000 175000
Furniture A/C
Particulars Amount Particulars Amount
To Opening balance 240000 By P&L A/C (Depn.) 12000
By Bank (Sale) b/f 88000
By Closing balance 140000
240000 240000
Dividend A/C
Particulars Amount Particulars Amount
By P&L A/C (provi.)
To Bank A/C 18000 b/f 18000
18000 18000
3. Balance sheets of M/s. Divya as on 1st January 2016 and 1st January 2017 were as follows:
Liabilities 2016 2017 Assets 2016 2017
Creditors 40000 44000 Cash 12000 27000
Overdraft 2000 3000 Debtors 30000 50000
Long term loan 40000 50000 Stock 35000 25000
Capital 125000 150000 Machinery 80000 55000
Reserves 10000 10000 Land building 40000 50000
P& L 15000 30000 35000 80000
Solution:
STATEMENT OF CHANGES IN WORKING CAPITAL
Particulars Previous Current Working capital
year year Increase Decrease
A. Current Assets
Cash 12000 27000 15000
Debtors 30000 50000 20000
Stock A 35000 25000 10000
77000 102000
B. Current Liabilities
Credotors 40000 44000 4000
Overdraft 2000 3000 1000
42000 47000
B
Working capital (A – B) 35000 55000
Increase in working capital B/F 20000 20000
55000 55000 35000 35000
Working Notes:
Machinery A/C
Particulars Amount Particulars Amount
To Opening
balance 80000 By P&L A/C (Depn.) 3000
By P&L A/C (loss on 2000
sale)
By Bank (sale) 5000
By Closing balance 55000
By P&L A/C (Depn.) b/f 15000
80000 80000
Solution:
STATEMENT OF CHANGES IN WORKING CAPITAL
Previous Current Working capital
Particulars year year Increase Decrease
A. Current Assets
Cash 30000 47000 17000
Debtors 120000 115000 5000
Stock 80000 90000 10000
A 230000 252000
B. Current Liabilities
Creditors 70000 45000 25000
B Working capital (A – B) 70000 45000
160000 207000
Increase in working capital B/F 47000 - 47000
207000 207000 52000 52000
13000
Building A/C
Particulars Amount Particulars Amount
To Opening balance 240000 By P&L A/C (Depn.) 42000
By Bank (Sale) b/f 3000
By Closing balance 195000
240000 240000
1. Funds flow statement reveals the net result of Business operations done by the company during the year.
2. In addition to the balance sheet, it serves as an additional reference for many interested parties like
analysts, creditors, suppliers, government to look into financial position of the company.
3. The Fund Flow Statement shows how the funds were raised from various sources and also how those
funds were deployed by a company.
4. It reveals the causes for the changes in liabilities and assets between the two balance sheet dates.
5. Funds flow statement helps the management in deciding its future course of plans and also it acts as a
control tool for the management.
1. Funds Flow statement has to be used along with balance sheet and profit and loss account for inference of
financial strengths and weakness of a company it cannot be used alone.
2. Fund Flow Statement does not reveal the cash position of the company, and that is why company has to
prepare cash flow statement in addition to funds flow statement.
3. Funds flow statement only rearranges the data which is there in the books of account and therefore it lacks
originality.
4. Funds flow statement is basically historic in nature, that is it indicates what happened in the past and it
does not communicate anything about the future, only estimates can be made based on the past data and
therefore it cannot be used the management for taking decision related to future.
INTRODUCTION
A Cash Flow Statement is a statement showing changes in cash position of the firm from one period to
another. It explains the inflows (receipts) and outflows (disbursements) of cash over a period of time. The
inflows of cash may occur from sale of goods, sale of assets, receipts from debtors, interest, dividend, rent,
issue of new shares and debentures, raising of loans, short-term borrowing, etc. The cash outflows may occur
on account of purchase of goods, purchase of assets, payment of loans loss on operations, payment of tax and
dividend, etc
The cash shows how much cash comes in and goes out of the company over thr ee-quarter the year. At first
glance, that sounds a lot like the income in that it records financial performance over a specified period. But
there is a big difference between the two.
What distinguishes the two is accrual which is found on the income statement. Accrual accounting requires
companies to record revenues and expenses when transactions occur, not when cash is exchanged. At the
same time, the income statement, on the other hand, often includes non-cash revenues or expenses, which the
statement of cash flows does not include.
Just because the income statement shows net income of Rs.10 does not mean that ca.10 net cash inflow, that's
exactly what it means. The company has Rs.10 more in cash than at the end of the last financial period. You
may want to think of net cash from operations as the company's "true" cash profit.
Because it shows how much actual cash a company has generated, the statement of cash flows is critical to
understanding a company's fundamentals. It shows how the company is able to pay for its operations and
future growth.
Indeed, one of the most important features you should look for in a potential investment is the company's
ability to produce cash. Just because a company shows a profit on the income statement doesn't mean it
cannot get into trouble later because of insufficient cash flows. A close examination of the cash flow
statement can give investors a better sense of how the company will fare.
The general rules that develop from the above discussion are:
Cash flow statements have three distinct sections, each of which relates to a particular component –
operations, investing and financing – of a company's business activities.
The indirect method of presentation is very popular, because the information required for it is relatively easily
assembled from the accounts that a business normally maintains in its chart of accounts. The indirect method
is less favored by the standard-setting bodies, since it does not give a clear view of how cash flows through a
business. The alternative reporting method is the direct method.
1. Operating Activities: Operating activities include cash flows from all standard business operations. Cash
receipts from selling goods and services represent the inflows. The revenues from interest and dividends
are also included here. The operational expenditures are considered as outflows for this section. Although
interest expenses fall under this section but the dividends are not included. Dividends are considered as a
part of financing activity in financial accounting terms.
2. Investing Activities: Investing activities include transactions with assets, marketable securities and credit
instruments. The sale of property, plant and equipment or marketable securities is a cash inflow.
Purchasing property, plant and equipment or marketable securities are considered as cash outflows. Loans
made to borrowers for long-term use is another cash outflow. Collections from these loans, however, are
cash inflows.
3. Financing Activities: Financing activities on the statement of cash flows are much more defined in
nature. The receipts come from borrowing money or issuing stock. The outflows occur when a company
repays loans, purchases treasury stock or pays dividends to stockholders. As the case with other activities
on the statement of cash flows depend on activities rather than actual general ledger accounts.
Cash Flow Statement of -------------- Company for the year ended -------
Particulars Rs. Rs.
A. Cash Flow from Operating Activities
Net Profit xxx
Adjustments: (to convert net profit to cash provided by
operating activities)
Good will written off xxx
Loss on sale of investments xxx
Loss on sale of fixed assets xxx
Preliminary expenses written off xxx
Discount on issue of debentures xxx
Provision for tax xxx
Patents written off xxx
Transfer to reserve xxx
Provision for dividend xxx
Loss on sale of fixed assets/investments xxx
Profit on sale of fixed assets/investments (xxx)
Profit from investments (xxx)
Increase in current liabilities xxx
Decrease in current liabilities (xxx)
Increase in current assets (xxx)
Decrease in current assets xxx
Cash from operations xxx
B. Cash Flows from Investing Activities
Purchase of fixed assets (xxx)
Proceeds from sale of fixed assets xxx
Purchase of long-term investments (xxx)
Proceeds from sale of long-term investments xxx
Cash from investing activities xxx
C. Cash Flows from Financing Activities
Issue of shares xxx
Issue of debentures xxx
Share capital repaid (xxx)
Debentures repaid (xxx)
Cash from financing activities xxx
Net increase/decrease in cash
xxx
Cash at the beginning of the year xxx
Cash at the end of the year xxx
1. It shows the actual cash position available with the company between the two balance sheet dates which
funds flow and profit and loss account are unable to show. So, it is important to make a cash flow report if
one wants to know about the liquidity position of the company.
2. It helps the company in accurately projecting the future liquidity position of the company enabling it
arrange for any shortfall in money by arranging finance in advance and if there is excess than it can help
the company in earning extra return by deploying excess funds.
3. It acts like a filter and is used by many analysts and investors to judge whether company has prepared the
financial statements properly or not because if there is any discrepancy in the cash position as shown by
balance sheet and the cash flow statement, it means that statements are incorrect.
1. Since it shows only cash position, it is not possible to deduce actual profit and loss of the company by just
looking at this statement.
2. In isolation this is of no use and it requires other financial statements like balance sheet, profit and loss
etc…, and therefore limiting its use.
1. From the following balance sheets as on 31-12-2016 and 31-12-2017. You are required to prepare a
cash flow statement.
Liabilities 31-12-2016 31-12-2017
Share capital 100000 150000
Profit and loss A/C 50000 80000
General reserve 30000 40000
12% Bonds 50000 60000
Sundry creditors 30000 40000
Outstanding expenses 10000 15000
Total 270000 385000
Assets 31-12-2016 31-12-2017
Fixed assets 100000 150000
Goodwill 50000 40000
Inventories 50000 80000
Bank 10000 15000
Bills receivables 10000 20000
Sundry debtors 50000 80000
Total 270000 385000
Solution:
2. Prepare a cash flow statement from the following balance sheets of Kumar Ltd.
Liabilities 2016 2017 Assets 2016 2017
Capital 150000 175000 Land & Building 110000 150000
Loan from bank 160000 100000 Machinery 200000 140000
Creditors 85000 93000 Stock 50000 45000
Outstanding expenses 5000 7000 Debtors 70000 80000
Bills payable 50000 40000 Cash 15000 22000
Long term loan -------- 25000 Pre – paid expenses 5000 3000
450000 440000 450000 440000
Net profit during the year 2017 was Rs/ 60000. During 2017 machinery costing Rs. 25000
(Accumulated depreciation Rs. 10000) was sold for Rs. 25000. The tax payable and dividend payable
were Rs. 50000 and Rs. 35000 respectively during 2017.
Solution:
Working notes:
Note: For working notes given in the problem, accounts are to be prepared to extract the hidden
information.
Machinery Account
Particulars Amount Particulars Amount
To Opening balance 200000 By Bank (Sales) 25000
To P & L A/C (Profit) 10000 By Depreciation B/F 45000
By Closing balance 140000
210000 210000
Tax Account
Particulars Amount Particulars Amount
To Bank Account 50000 By P & L A/C (provided) B/F 50000
50000 50000
Dividend Account
Particulars Amount Particulars Amount
To Bank Account 35000 By P & L A/C (provided) B/F 35000
35000 35000
3. From the following balance sheets of 1993 and 1994, prepare the cash flow statement.
Liabilities 2016 2017 Assets 2016 2017
Equity capital 20000 25000 Plant 46000 45000
Debentures 15000 12000 Debtors 9000 7000
Creditors 16000 18000 Stock 5000 9000
Profit and loss A/C 11000 14000 Cash 2000 8000
62000 69000 62000 69000
Solution:
Cash Flow Statement for the year ended 31-12-2017
Particulars Rs. Rs.
A. Cash Flow from Operating Activities
Net Profit (14000-11000) 3000
Adjustments:
Increase in creditors 2000
Decrease in debtors 2000
Increase in stock (4000)
Cash from operations 3000
4. Prepare a cash flow statement from the following balance sheets as on 31-12-2016 and 31-
122017.
Liabilities 2016 2017 Assets 2016 2017
Share capital 100000 150000 Fixed assets 100000 150000
Profit and loss A/C 50000 80000 Goodwill 50000 40000
General reserve 30000 40000 Inventories 50000 80000
6% bonds 50000 60000 Debtors 50000 80000
Creditors 30000 40000 Bills receivables 10000 20000
Outstanding 10000 15000 Bank 10000 15000
expenses 270000 385000 270000 385000
Solution:
Cash Flow Statement for the year ended 31-12-2017
Particulars Rs. Rs.
A. Cash Flow from Operating Activities
Net Profit (80000-50000) 30000
Adjustments:
General Reserve 10000
Goodwill written off 10000
Interest on bonds (50000x6/100) 3000
Increase in creditors 10000
Increase in outstanding expenses 5000
Increase in inventory (30000)
Increase in debtors (30000)
Icrease in bills receivables (10000)
Cash from operations (2000)
Capital Account
Particulars Amount Particulars Amount
To P & L A/C (loss) By Opening
B/F 116000 balance 731000
To Closing balance 615000
731000 731000
Basis of
Cash Flow Statement Funds Flow Statement
Difference
1. Meaning Funds means only cash which is a Fund means net working capital (i.e.
of component of net current assets. current assets minus current liabilities).
fund
2. Objective Its objective is to know about the Its objective is to know about the
changes occurred in cash position changes occurred in net working capital
between two balance sheet dates. between two balance dates.
3. Basis ofIncrease in current liability or Increase in current liability and
preparation decrease in current asset (except decrease in current asset results in a
cash) results in an increase in cash. decrease in net working
4. Effect ofEffect of a transaction on cash is Effect of a transaction on net working
transaction considered. capital is considered.
5. Utility Cash flow statement is useful for Fund flow statement is useful for long-
short-term analysis. term analysis
6. Statement of No such statement is prepared A separate statement for changes in
changes in separately in cash flow statement. working capital is prepared in fund flow
Working statement or analysis.
Capital
7 Cash Opening and closing balances of Such balances of cash are shown in
Balances cash are shown in this statement statement of changes in working capital.