0% found this document useful (0 votes)
20 views22 pages

Operating Statement and Balance Sheet Analysis

This document contains operating statements and balance sheet information for a company from 2004-2005 to 2007-2008 with projections for 2008-2009. It shows income, expenses, profits, assets and liabilities. Key line items include net sales, costs of sales, operating profit, current and fixed assets, current and long term liabilities. Ratios such as current ratio and debt-equity are also presented. A cash flow statement provides details on sources and uses of funds over the years.

Uploaded by

Anupam Bali
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
20 views22 pages

Operating Statement and Balance Sheet Analysis

This document contains operating statements and balance sheet information for a company from 2004-2005 to 2007-2008 with projections for 2008-2009. It shows income, expenses, profits, assets and liabilities. Key line items include net sales, costs of sales, operating profit, current and fixed assets, current and long term liabilities. Ratios such as current ratio and debt-equity are also presented. A cash flow statement provides details on sources and uses of funds over the years.

Uploaded by

Anupam Bali
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

FORM II - OPERATING STATEMENT

(1) (2) (3) (4)


2004-05 2005-06 2006-07 2007-08
1 Operating Income - - -
i) Domestic Sales
ii) Exports
iii) Other Operating Income
Total - - - -
2 Less: Excise
3 Net Sales (Item 1 - Item 2) - - - -
% rise in net sales as compared to #DIV/0! #DIV/0! #DIV/0! #DIV/0!
previous year
4 Cost Of Sales
i) Raw Materials (incl. Stores and other
items used in the process of mfg)
(a) imported -
(b) indigenous -
ii) Other Spares
(a) imported
(b) indigenous
iii) Power and Fuel
iv) Direct Labour
v) Repairs and Maintenance
vi) Other Manufacturing
vii) Depreciation
viii) Sub Total (Item i to Item vi) - - -
ix) Add: Opening Stocks in process
Sub Total - - -
Last Years actuals as per
the Audited Accounts
Current
Years
Estimates
Following Years
Projections
(1) (2) (3) (4)
2004-05 2005-06 2006-07 2007-08
x) Deduct : Closing Stocks in process
xi) Sub Total (Cost of Production) - - -
xii) Add: Opening Stocks of Finished Goods
Sub - Total - - -
xiii) Deduct : Closing Stocks of Finished Goods
xiv) Sub Total (Cost of Sales)
5 Gross Profit (3-4) - - -
6 Interest
7 Selling & Administrative Expenses
8 Operating Profit ( 5-6-7) - - -
9 Other Income
10 Other Expenses
11 Profit Before Tax - - -
% to Net Sales #DIV/0! #DIV/0! #DIV/0!
12 Provision for tax
13 Net Profit (10-11) - -
% to Net Sales #DIV/0! #DIV/0!
14 (a) Equity dividend paid/payable
(b) Dividend Rate - %
15 Retained Profit (14-15) - -
16 Retained Profit/Net Profit (%) #DIV/0! #DIV/0!
Last Years actuals as per
the Audited Accounts
Current
Years
Estimates
Following Years
Projections
(5)
2008-09
-
-
#DIV/0!
Following Years
Projections
(5)
2008-09
Following Years
Projections
III . ANALYSIS OF BALANCE SHEET
PART A- BALANCE SHEET SPREAD
(1) (2) (3) (4)
2004-05 2005-06 2006-07 2007-08
CURRENT LIABILITIES
1 Short term borrowings from banks ( incl bills
purchased and discounted and excess borrowings
placed on repayment basis)
I) From applicant bank
ii) From other banks
iii) (of which BP and BD)
Sub Total (A) - -
2 Short term borrowings from others - -
3 Deposits maturing within a year
4 Sundry Creditors
5 Unsecured Loans
6 Advance/progress payments from Customers/
Deposits from Dealers, selling agents, etc)
7 Interest and other charges accrued but not due
8 Provision for taxation
9 Dividend Payable
10 Other Statutory Liabilities
11 Instalments of term loans /deferred payments,
etc (due within one year)
12 Other Current Liabilities
Sub Total (B) - -
13 Total Current Liabilities (1 to 12) - -
Last Years actuals
as per the Audited
Accounts
Current
Years
Estimate
Following Years
Projections
III . ANALYSIS OF BALANCE SHEET
PART A- BALANCE SHEET SPREAD (Contd)
(1) (2) (3) (4)
2004-05 2005-06 2006-07 2007-08
Term Liabilities
14 Debentures (not maturing within 1 year) - -
15 Redeemable Preference Shares (not maturing - -
within 1 year but maturity exceeding 2 years)
16 Term Loans (exclusive of installments payable
within 1 year)
17 Deferred Payment credits (excl. instalments
payable within 1 year)
18 Term Deposits (repayable after 1 year)
19 Other Term Liabilities -
20 Total Term Liabilities - -
21 Total Outside Liabilities - -
22 Ordinary Share Capital
23 Share Premium A/c
24 General Reserve
25 Investment Allowance Reserve
26 Other Reserves
27 Surplus (+) or deficit (-) in profit and loss
account
28 Net Worth (22 to 27) - -
28 a Revaluation Reserve
29 Total Liabilities (21 + 28 + 28 a) - -
Last Years actuals as
per the Audited
Accounts
Current
Years
Estimates
Following Years
Projections
III . ANALYSIS OF BALANCE SHEET
PART A- BALANCE SHEET SPREAD (Contd)
(1) (2) (3) (4)
2004-05 2005-06 2006-07 2007-08
CURRENT ASSETS
30 Cash and Bank Balances
31 Investments
(i) Govt. and other trustee securities -
(ii) Fixed Deposits with Banks
32 Receivables
(i) Other than Exports
(ii) Export Receivables
33 Instalment of deferred Receivables -
34 Inventory
(i) Raw Materials
a) Imported
b) Indegenous
(ii) Stock - in - process/WIP -
(iii) Finished Goods -
(iv) Other consumable spares
a) Imported
b) Indegenous
35 Advance to suppliers of raw Materials/spares/
consumables
36 Stocks on Hire (Net of UFMC) -
37 Other current assets
38 Total Current Assets (30 to 37) - -
Last Years actuals as
per the Audited
Accounts
Current
Years
Estimates
Following Years
Projections
III . ANALYSIS OF BALANCE SHEET
PART A- BALANCE SHEET SPREAD (Contd)
(1) (2) (3) (4)
2004-05 2005-06 2006-07 2007-08
Fixed Assets
39 Gross Block
40 Depreciation till date
41 Net Block (39 - 40) - -
Other Non Current Assets
42 (i) a) Investment in subsidiary Companies
b) Others
(ii) Deferred Receivables (over one year)
(iii) Others -
43 Non consumable stores/spares -
44 Other non current assets incl dues from directors -
45 Total Non Current Assets (42 to 44) - -
46 Intangible Assets
47 Total Assets (38+41+45=46) - -
48 Tangible Net Worth (28 - 46) - -
49 Net Working Capital ( 38 - 13) - -
50 Current Ratio (Item 38/13) #DIV/0! #DIV/0!
51 Total Outside Liabilities/Tangible Net Worth (21/48) #DIV/0! #DIV/0!
Last Years actuals as
per the Audited
Accounts
Current
Years
Estimates
Following Years
Projections
(5)
2008-09
Following Years
Projections
(5)
2008-09
Following Years
Projections
(5)
2008-09
Following Years
Projections
(5)
2008-09
Following Years
Projections
CASH FLOW STATEMENT
S O U R C E S
(1) (2) (3) (4) (5)
2004-05 2005-06 2006-07 2007-08 2008-09
Profit Before Tax - -
(item 10 part A of Form II)
Add: Depreciation - -
(Item 4 (vii) of Form II)
Add: Employee Stock Options
Add: Increase in Deferred Tax Asset
Gross Funds Generated - -
Less: Taxes paid/payable -
(relating to the year)
Less : Dividend paid/payable -
(relating to the year)
A. Sub Total - Net Funds Generated - -
Increase in capital and premium #REF!
Increase in Opening Deferred tax Assets 0 -
Decrease in Fixed Assets 0
Decrease in Intangible Assets #REF!
Increase in term loans/Debentures 0 #REF!
Increase in Public Deposits 0 #REF!
Increase in other term liabilities 0 #REF!
B. Sub Total 0 #REF!
Increase in short term bank borrowings (incl. Bills #REF!
purchased and discounted by bankers)
Increase in Currrent Liabilities #REF!
Increase in other current liabilities 0 #REF!
Decrease in Inventory 0 #REF!
Decrease in Receivables (incl. Bills purchased and 0 #REF!
discounted by bankers)
Decrease in other Current Assets #REF!
(incl. Cash and bank balances)
Decrease in other non - current assets #REF!
C: Sub Total 0 #REF!
Total Funds Available (A + B + C) - #REF!
Last Years actuals
as per the Audited
Accounts
Current
Years
Estimate
Following Years
Projections
U S E S
(1) (2) (3) (4) (5)
2004-05 2005-06 2006-07 2007-08 2008-09
Increase in fixed assets
Decrease in term loans/Debentures #REF!
Decrease in Public deposits #REF!
Decrease in other term liabilities 0 #REF!
Increase in Intangible assets, etc 0 #REF!
Increase in other non current assets 0 #REF!
D : Sub Total 0 #REF!
Decrease in short term bank borrowings(including 0 #REF!
bills purchased/discounted by bankers)
Decrease in Current liabilities 0 #REF!
Decrease in Other Current Liabilities #REF!
Increase in Inventory #REF!
Increase in Receivables (incl. Bills purchased/ #REF!
discounted by bankers)
Increase in Other Current Assets (incl. Cash and 0 #REF!
bank balances)
E: Sub Total 0 #REF!
S U M M A R Y
Long term sources ( A + B) - #REF!
Long term uses ( D) 0 #REF!
Surplus (+) /Shortfall (-) - #REF!
Short term sources ( C ) 0 #REF!
Less: Short term uses ( E ) 0 #REF!
Surplus (+) /Shortfall (-) 0 #REF!
Difference (not to be printed) - #REF!
Last Years actuals as
per the Audited
Accounts
Current
Years
Estimates
Following Years
Projections
POSITION REGARDING CURRENT ASSETS AND CURRENT LIABILITIES
PART A (1) (2) (3) (4)
2004-05 2005-06 2006-07 2007-08
I CURRENT ASSETS
1 Total Inventory
Raw Materials
i) Raw Materials
a) Imported - -
( Months consumption) #DIV/0!
b) Indegenous - -
( Months consumption) #DIV/0!
ii) Other Consumable Spares - -
( % of Inventory) #DIV/0!
iii) Stock - In - Process - -
(Months cost of production) #DIV/0!
iv) Finished Goods - -
(Months cost of sales) #DIV/0!
v) Stock On Hire - -
vi) Receivables (other than exports) - -
(Months Domestic sales) #DIV/0!
vii) Export Receivables - -
(including bills purchased and discounted) #DIV/0!
viii) Advance to suppliers of raw materials, etc - -
viii) Other Current Assets - -
(incl. Cash and bank balances)
Total Current Assets - -
Last Years actuals as
per the Audited
Accounts
Current
Years
Estimate
Following Years
Projections
PART B (1) (2) (3) (4)
2004-05 2005-06 2006-07 2007-08
II CURRENT LIABILITIES
(Other than bank borrowings for working capital)
x Creditors for purchases of materials - -
No. of months #DIV/0!
xi Advance from Customers - -
xii Accrued Expenses - -
xiii Statutory Liabilities - -
xiv Other Current Liabilities - -
Sub Total #DIV/0! -
III Working Capital Gap (I - II ) #DIV/0! -
IV Actual/Projected Bank Borrowings for Working - -
Capital (including bills purchased/discounted)
V Total Current Liabilities (III + IV) #DIV/0! -
VI Net Working Capital (I - V) #DIV/0! -
Last Years actuals as
per the Audited
Accounts
Current
Years
Estimates
Following Years
Projections
(5)
2008-09
Following Years
Projections
(5)
2008-09
Following Years
Projections
PART C
COMPUTATION OF MPBF FOR WORKING CAPITAL
(1) (2) (3) (4)
2004-05 2005-06 2006-07 2007-08
I Working Capital Gap #DIV/0! -
(Item III of Part B)
2 Minimum stipulated working capital ( 25% of total - -
current assets ie Item I of Part B)
3 Actual Projected net working capital - -
4 Item 1 - Item 2 #DIV/0! -
5 Item 1 - Item 3 #DIV/0! -
6 Maximum Permissible Bank Finance (Item 4 or #DIV/0! -
5 whichever is earlier)
7 Excess/ (Short) borrowings - -
(representing shortfall in net working capital)
Item 2 - Item 3
Last Years actuals
as per the Audited
Accounts
Current
Years
Estimate
Following Years
Projections
(5)
2008-09
Following Years
Projections
ANALYTICAL AND COMPARITIVE RATIOS
(1) (2) (3) (4) (5)
2004-05 2005-06 2006-07 2007-08 2008-09
1 Net Sales - -
(Item 3 in Form II A)
2 % rise (+) or fall (-) in net sales during the year #DIV/0! #DIV/0!
3 Profit before tax (+) or loss (-) - -
(Item 10 in Form II A)
4 Net Profit /(loss) after tax - -
(Item 12 in Form II A)
5 Equity Dividend declared - -
6 Retained Profit - -
7 Retained Profit %/Net Profit #DIV/0! #DIV/0!
8 Raw Materials (incl. Stores and other items used
in process of manufacture)
a) Imported ( Item 34 (I) a) in Form III A - -
No of months consumption #DIV/0! -
b) Indegenous ( Item 34 (I) b) in Form III A - -
No of months consumption #DIV/0! -
9 Stocks in Process (Item 34 (ii) in Form III A) - -
No of months consumption #DIV/0! -
Finished Goods (Item 34 (iii) in Form III A) - -
No of months consumption #DIV/0! -
Spares (Item 34 (iv) in Form III A) - -
% to total Inventory #DIV/0! -
Last Years actuals as
per the Audited
Accounts
Current
Years
Estimate
Following Years
Projections
(1) (2) (3) (4) (5)
2004-05 2005-06 2006-07 2007-08 2008-09
12 a) Receivables other than deferred and export - -
receivables.. (Incl. Bills purchased/discounted)
(Item 32 (I) in Form III A)
No of months consumption #DIV/0! -
b) Export Receivables - -
(Item 32 (I) in Form III A) #DIV/0! -
No of months consumption
13 Sundry Creditors - trade - -
(Item 4 in Form III A) #DIV/0! -
No of months consumption
14 Net Working Capital #DIV/0! -
(Item 49 in Form III A)
15 Current Ratio #DIV/0! #DIV/0!
(Item 38/Item 15 in Form IIIA)
16 Tangible Net Worth - -
(Item 48 in Form III A)
17 a) Total Outside Liabilities/tangible net worth #DIV/0! #DIV/0!
(Item 21/item 48 in Form III A)
b) Total term Liabilities/tangible net worth #DIV/0! #DIV/0!
(Item 20/item 48 in Form III A)
18 a) Bank Borrowings/Total Outside liabilities #DIV/0! #DIV/0!
(Item 1/item 21 in Form III A)
b) Net Sales/Total Tangible assets #DIV/0! #DIV/0!
(Item 3 in Form II)
Last Years actuals as
per the Audited
Accounts
Current
Years
Estimates
Following Years
Projections

You might also like