Particular
|
P.Y amount
|
C.Y. amount
|
Change in amount
|
Change in Percentage
|
Gross sales
Less: Sales return
|
Xxx
xxx
|
Xxx
Xxx
|
C.Y –P.Y.
|
C.Y-P.Y X
100
P.Y.
|
Net Sales
Less: C.O.G.S.
|
Xxx
xxx
|
Xxx
Xxx
|
do
|
do
|
Gross Profit
Less:
Indirect Expenses/
Operating expense
|
Xxx
xxx
|
Xxx
xxx
|
do
|
do
|
Operating Profit
Add:
Non-operating income
Less:
non-operating expenses
|
Xxx
Xxx
xxx
|
Xxx
Xxx
xxx
|
do
|
do
|
Profit before tax
Less: tax
|
Xxx
xxx
|
Xxx
xxx
|
do
|
do
|
Profit after tax
|
xxx
|
xxx
|
do
|
do
|
Particular
|
P.Y. amount
|
C.Y. Amount
|
Change in amount
|
Change in Percentage
|
1. Share Capital
|
xxx
|
Xxx
|
C.Y –P.Y
|
C.Y-P.Y X 100
P.Y.
|
2. Reserve and surplus
|
Xxx
|
xxx
|
do
|
do
|
3.Secured loan
|
Xxx
|
xxx
|
do
|
do
|
4. Unsecured Loan
|
Xxx
|
Xxx
|
do
|
do
|
5. Current liabilities
& Provision
|
Xxx
|
Xxx
|
do
|
do
|
Total
|
Xxx
|
Xxx
|
C.Y –P.Y
|
C.Y-P.Y X 100
P.Y.
|
1. Fixed Assets
|
Xxx
|
Xxx
|
do
|
do
|
2. Investments
|
Xxx
|
Xxx
|
do
|
do
|
3. Current assets and Loans
& Advances
|
Xxx
|
Xxx
|
do
|
do
|
4. Miscellaneous
Expenditure
|
Xxx
|
Xxx
|
do
|
do
|
5. P&L(Debit balance)
|
Xxx
|
Xxx
|
do
|
do
|
Total
|
xxx
|
Xxx
|
C.Y –P.Y
|
C.Y-P.Y X 100
P.Y.
|
Particular
|
P.Y
amt.
|
C.Y. amt.
|
Percentage of Net sales in
P.Y.
|
Percentage of Net sales in
C.Y.
|
Gross sales
Less: Sales return
|
Xxx
xxx
|
Xxx
Xxx
|
P.Y. Amount X 100
P.Y. net sales
|
C.Y. Amount X 100
C.Y. net sales
|
Net Sales
Less: C.O.G.S.
|
Xxx
xxx
|
Xxx
Xxx
|
100%
P.Y. Amount X 100
P.Y. net sales
|
100%
C.Y. Amount X 100
C.Y. net sales
|
Gross Profit
Less:
Indirect Expense/
Operating expense
|
Xxx
xxx
|
Xxx
xxx
|
do
|
do
|
Operating Profit
Add:
Non-operating income
Less:
non-operating expenses
|
Xxx
Xxx
xxx
|
Xxx
Xxx
xxx
|
do
|
do
|
Profit before tax
Less: tax
|
Xxx
xxx
|
Xxx
xxx
|
do
|
do
|
Profit after tax
|
xxx
|
xxx
|
do
|
do
|
Particular
|
P.Y. amount
|
C.Y. Amount
|
% of total in P.Y.
|
% of total in C.Y.
|
1. Share Capital
|
xxx
|
Xxx
|
P.Y amount X 100
Total of P.Y.
|
C.Y. amount X 100
Total of C.Y.
|
2. Reserve and surplus
|
Xxx
|
xxx
|
do
|
do
|
3.Secured loan
|
Xxx
|
xxx
|
do
|
do
|
4. Unsecured Loan
|
Xxx
|
Xxx
|
do
|
do
|
5. Current liabilities
& Provision
|
Xxx
|
Xxx
|
do
|
do
|
Total
|
Xxx
|
Xxx
|
100 %
|
100%
|
1. Fixed Assets
|
Xxx
|
Xxx
|
P.Y amount X 100
Total of P.Y.
|
C.Y. amount X 100
Total of C.Y.
|
2. Investments
|
Xxx
|
Xxx
|
do
|
do
|
3. Current assets and Loans
& Advances
|
Xxx
|
Xxx
|
do
|
do
|
4. Miscellaneous
Expenditure
|
Xxx
|
Xxx
|
do
|
do
|
5. P&L(Debit balance)
|
Xxx
|
Xxx
|
do
|
do
|
Total
|
xxx
|
Xxx
|
100%
|
100%
|
Liabilities
|
Amount
(Rs.)
|
Assets
|
Amount
(Rs.)
|
1. Share Capital
2. Reserve & Surplus:
Securities Premium
3. Secured Loan:
9% Debentures
4. Unsecured Loan:
5. Current Liabilities
& Provisions:
A. Current Liabilities:
Creditors
B. Provisions:
Proposed Dividend
|
10,00,000
1,00,000
5,00,000
2,00,000
50,000
|
1. Fixed Assets:
Freehold property
2. Investment:
share of Reliance
Industries
3. Current Assets, Loans
& Advances:
A. Current Assets:
Work-in- Progress
B. Loans & Advances:
4. Miscellaneous Expenditure:
Discount on Issue of
Debentures
5. P&L A/c(Dr. Balance)
|
9,00,000
4,50,000
4,00,000
----------
1,00,000
-------------
|
Total
|
18,50,000
|
|
18,50,000
|
Particulars
|
2008(Rs.)
|
2009(Rs.)
|
1.Net Sales
2.Cost of Goods Sold
3.Indirect Expenses
4.Income Tax rate
|
8,00,000
60% of sales
10% of Gross profit
50%
|
10,00,000
60% of sales
10% of Gross Profit
60%
|
Particular
|
2008 amount
|
2009
amount
|
Change in amount
|
Change in Percentage
|
Net Sales
Less: C.O.G.S.
|
8,00,000
4,80,000
|
10,00,000
6,00,000
|
2,00,000
1,20,000
|
25%
25%
|
Gross Profit
Less: Indirect Expenses
|
3,20,000
32,000
|
4,00,000
40,000
|
80,000
8,000
|
25%
25%
|
Operating Profit/ PBT
Less: tax
|
2,88,000
1,44,000
|
3,60,000
2,16,000
|
72,000
72,000
|
25%
50%
|
Profit after tax
|
1,44,.000
|
1,44,000
|
----------
|
------------
|
Particular
|
2008 amount
|
2009
amount
|
Percentage of Net sales in
P.Y.
|
Percentage of Net sales in
C.Y.
|
Net Sales
Less: C.O.G.S.
|
8,00,000
4,80,000
|
10,00,000
6,00,000
|
100%
60%
|
100%
60%
|
Gross Profit
Less: Indirect Expenses
|
3,20,000
32,000
|
4,00,000
40,000
|
40%
4%
|
40%
4%
|
Operating Profit/ PBT
Less: tax
|
2,88,000
1,44,000
|
3,60,000
2,16,000
|
36%
18%
|
36%
21.6%
|
Profit after tax
|
1,44,.000
|
1,44,000
|
18%
|
14.4%
|
3
|
Operating
Ratio=
|
(Cost of
goods sold + Operating expenses) x 100
|
||||||||
Net Sales
|
||||||||||
4
|
Return on
investment ( ROI)= Net Profit before interest,tax and dividend X 100
|
|||||||||
Capital
Employed
|
||||||||||
Capital
employed= Share Capital+Undistributed profit+long term loans-
|
||||||||||
(fictitious
assets like underwriting commission, preliminary expenses,
|
||||||||||
discount or loss on issue of shares and
non-operating assets like Investments).
|
||||||||||
or
|
||||||||||
Net fixed
assets+Working capital
|
||||||||||
working
capital= Current assets-current liabilities.
|
||||||||||
5
|
Earning per
share= Net Profit-Preference dividend
|
|||||||||
No.of Equity shares
|
||||||||||
6
|
Dividend per
share=Net Profit after interest, taxes and preference dividend
|
|||||||||
Number of equity shares
|
||||||||||
7
|
Price Earning
Ratio=Market price of a share
|
|||||||||
Earning per share
|
(B)
|
TURNOVER OR ACTIVITY OR PERFORMANCE RATIOS:
|
||||||||
1
|
Working capital
turnover ratio=Net Sales
|
||||||||
working capital
|
|||||||||
Working
Capital= Current assets- current Liabilities
|
|||||||||
3
|
Debtors
turnover ratio= Net credit sales
|
||||||||
Average Debtors
|
|||||||||
Average
Debtors=Debtorsin the beginning+Debtors at the end
|
|||||||||
2
|
|||||||||
Receivables=
Debtors+Bills receivable
|
|||||||||
4
|
Payable
turnover ratio= Net credit purchases
|
||||||||
Account Payable
|
|||||||||
5
|
Fixed Assets
Turnover ratio= Sales or cost of goods sold
|
||||||||
Net fixed assets
|
|||||||||
6
|
Current assets Turnover Ratio=Net sales or cost
of goods sold
|
||||||||
current Assets
|
|||||||||
LIQUIDITY RATIOS:
|
|||||||||
1
|
Current ratio= current
Assets
|
||||||||
current liabilities
|
|||||||||
2
|
Liquid or quick
or acid test ratio= liquid assets
|
||||||||
current
liabilities
|
|||||||||
Solvency ratios
|
|||||||||
1
|
Debt to equity
ratio= Long term loans
|
||||||||
Shareholder's
funds
|
|||||||||
2
|
Total assets to
debt ratio= Total assets
|
||||||||
Long term debts
|
|||||||||
3
|
Proprietary
ratio= Proprietors fund or shareholders fund
|
||||||||
Total Assets
|
|||||||||
4
|
Current asset
turnover ratio= Net sales/cost of goods sold
|
||||||||
current assets
|
|||||||||
5
|
Fixed assets
turnover ratio= Net sales
|
||||||||
Net fixed
assets
|