Actuals Actuals Estimated Projected Projectionsprojection 2007 2008 2009 2010 2011 2012

Name: Manju Agarwal
Actuals Actuals Estimated Projected ProjectionsProjection

Financial Year ended / ending 2007 2008 2009 2010 2011 2012
No.of months 12 12 12 12 12 12
% of Depn
Written-down value B.F.D.
Building 10.00 9.21 8.29 7.46 6.71 6.04

Plant and Machinery 8.00 7.05 5.99 5.09 4.33 3.68
Electrical Installation 2.00 1.76 1.50 1.27 1.08 0.92
Misc Assets 2.00 1.68 1.35 1.08 0.86 0.69
others 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
Total 22.00 19.70 17.12 14.90 12.99 11.33
Additions during the year

Building 0.00 0.00 0.00 0.00 0.00 0.00
Misc Assets 0.00 0.00 0.00 0.00 0.00 0.00
others 0.00 0.00 0.00 0.00 0.00 0.00
0 0.00 0.00 0.00 0.00 0.00 0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00
Depreciation for the year

Building 10% 0.79 0.92 0.83 0.75 0.67 0.60
Plant and Machinery 15% 0.95 1.06 0.90 0.76 0.65 0.37
Electrical Installation 15% 0.24 0.26 0.22 0.19 0.16 0.23
Misc Assets 20% 0.32 0.34 0.27 0.22 0.17 0.07
others 0.00 0.00 0.00 0.00 0.00 0.00
0 0.00 0.00 0.00 0.00 0.00 0.00
Total 2.30 2.58 2.22 1.92 1.66 1.27
W.D.V carried forward

Building 9.21 8.29 7.46 6.71 6.04 5.44
Misc Assets 1.68 1.35 1.08 0.86 0.69 0.62
others 0.00 0.00 0.00 0.00 0.00 0.00
0 0.00 0.00 0.00 0.00 0.00 0.00
Net Fixed Assets 19.70 17.12 14.90 12.99 11.33 10.06
Projection Projection Projection Projection
2013 2014 2015 2016
12 12 12 12
5.44 4.89 4.40 3.96

3.31 2.98 2.68 2.41
0.69 0.52 0.39 0.29
0.62 0.56 0.50 0.45
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
10.06 8.95 7.98 7.12
0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.54 0.49 0.44 0.00

0.33 0.30 0.27 0.00
0.17 0.13 0.10 0.00
0.06 0.06 0.05 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
1.11 0.97 0.86 0.00
4.89 4.40 3.96 3.96

2.98 2.68 2.41 2.41
0.52 0.39 0.29 0.29
0.56 0.50 0.45 0.45
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
8.95 7.98 7.12 7.12
MONTH PRICE TOTAL
SALES OF VEHICLES LCV 4 700000 2800000
HCV 6 1200000 7200000
10000000 120000000
SPARES @ 5 % 6000000
126000000
COMMISSION LCV 4 21000 84000
HCV 6 36000 216000
300000 3600000
PURCHASE PRICE LCV 4 2716000

HCV 6 6984000
9700000 116400000
SPARE @ 90 % 5400000
TOTAL PURCHASE 121800000
SALARY
MANAGER 1 12000 144000

SERVICE BOYS 9 4500 486000
WATCH MAN 3 3500 126000
MANAGER 1 8000 96000

SALES BOYS 5 4750 285000
ACCOUNTS 1 5250 63000
1200000 900000
RENT 1 40000 480000 480000

TELEPHONE 1 5000 60000 45000
OFFICE STATIONERY 1 5000 60000 45000

ADVERTISEMENT 1 40000 480000 360000
OTHER MISC 200000 150000
SELLING AND DISTRIBUTION EXPENSES 2480000 1980000
94500000
91350000
INSTRUCTIONS
WHILE OPENING THIS FILE, IF YOU GET A MESSAGE ASKING YOU WHETHER TO
'Disable Macros' OR 'Enable Macros', SELECT "Disable Macros".
This File should be saved separately in any Computer. To use it for an analysis, a copy
(named as, say, "CMA-XYZ LTD") should be taken out and all data entry should be made
ONLY in this new File. This would ensure that the Mother File ("CMA-MAIN") remains
untouched and uncorrupted for ready reference and copying.
1 Name of the Borrower must be entered only once in Cell No.C4 of FORM-II.
Enter the YEARS in FORM-II. In case the number of months covered in any period(s) is(are)
NOT 12, then change the "No. of Months" appropriately under the said YEAR(S) in FORM-II only.
2 Cell No.G6 of Form-II should be filled in to indicate whether the Amounts incorporated
in the ENTIRE WORKSHEET are in LACS or CRORES.
Modify the column-head labels "Actuals", "Estimates" and "Projections"
as may be required for your analysis. TAKE AS MANY YEARS FROM THE LEFT AS YOU
NEED. YOU NEED NOT FILL DATA IN THE COLUMNS BEYOND THE LAST YEAR YOU REQUIRE
FOR YOUR ANALYSIS. WHILE TAKING PRINT-OUTS, JUST SELECT THE COLUMNS AND
ROWS CONTAINING THE DATA YOU REQUIRE IN EACH FORM.
While printing, select "Gridlines" in Page Set Up (Sheet) Menu, for easy reading.
3 You need NOT enter or change the NAME, Lacs/Crores,YEAR or NO. OF MONTHS cells in any
other Worksheet. These would be auto-generated from what have been entered in FORM-II.
4 Fill in all data in FORM-II and FORM-III. DO NOT ENTER ANY DATA IN THE CELLS
COLOURED IN YELLOW. These cells contain Formulae, which would be auto-generated.
All yellow cells have been protected to avoid corruption of standard Format & Formulae.
5 YOU NEED NOT ENTER ANY DATA IN THE REMAINING WORKSHEETS ( "FORM-IV"
to "ANALYSIS"). All these data would be automatically extracted from what you have entered
in FORM-II and FORM-III. Accordingly the LAST SIX WORKSHEETS HAVE BEEN TOTALLY
PROTECTED TO AVOID ANY CORRUPTION OF STANDARD FORMULAE.
6 Depreciation for any specific year may be different in FORM-II and FORM-III (owing to
sale of assets, etc.). If so, a difference would appear in the Worksheet "CHECK". This is not an
error, but you should reconcile the difference separately and keep it for record. Please note
that the Depreciation for the Year, as appearing in FORM-VI, is auto-extracted from FORM-III
(by computing the incremental cumulative depreciation during any year) and NOT from FORM-II.
7 If there is any Capital Works in Progress, it should be added manually to Gross Block.
8 Cell E69 of Form-IV is UNPROTECTED. Please fill in the data manually.
This is a Beta version. In case you come across any error / inconsistency / difficulty
OR if you have any suggestions for imrpoving this Spreadsheet, please refer back to the
appropriate person. This will help us to gradually perfect this Spreadsheet for the
benefit of all concerned.
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
FORM II - OPERATING STATEMENT
Name: Manju Agarwal
Amounts in Rs. Lacs
Estimated Projected Projected

Financial Year ended / ending 2019 2020 2021
No.of months 12 12 12
1. Gross Sales
i. Domestic Sales 752.00 789.60 829.08
ii. Export Sales 0.00 0.00 0.00
Total 752.00 789.60 829.08
2. Less Excise Duty 0.00 0.00 0.00
3. Net Sales (1 - 2) 752.00 789.60 829.08
4. % age rise (+) or fall (-) in net sales
as compared to previous year (annualised) N/A 5.00% 5.00%
5. Cost of Sales
i. Raw materials (including stores and
other items used in the process of
manufacture) 682.67 620.69 655.87
a. Imported 0.00 0.00 0.00
b. Indigenous 682.67 620.69 655.87
ii. Other Spares 0.00 0.00 0.00
a. Imported 0.00 0.00 0.00
b. Indigenous 0.00 0.00 0.00
iii. Power and Fuel 25.00 27.50 28.60
iv. Direct Labour (Factory wages & salaries) 28.00 29.40 30.00
v. Other manufacturing expenses 25.50 26.16 27.67
vi. Depreciation 17.99 15.46 13.29
vii. Sub-total (i to vi) 779.16 719.21 755.43
viii. Add: Opening Stock-in-process 0.00 0.00 0.00

Sub-total (vii + viii) 779.16 719.21 755.43
ix. Deduct: Closing Stock-in-process 0.00 0.00 0.00
x. Cost of Production 779.16 719.21 755.43
xi. Add: Opening Stock of finished goods 0.00 92.71 97.35
Sub-total (x + xi) 779.16 811.92 852.78
xii. Deduct: Closing Stock of finished goods 92.71 97.35 102.22
xiii. Sub-total (Total Cost of Sales) 686.45 714.57 750.56
6. Selling, general and administrative expenses 26.50 27.83 28.66

7. Sub-total (5 + 6) 712.95 742.40 779.22
8. Operating Profit before Interest (3 - 7) 39.05 47.20 49.86
9. Interest 10.65 15.98 15.98
10. Operating Profit after Interest (8 - 9) 28.40 31.22 33.88

11. i. Add: Other non-operating Income
a. Sale of Fixed Assets 0.00 0.00 0.00
b. Others 0.00 0.00 0.00
c. 0.00 0.00 0.00
d. 0.00 0.00 0.00
Sub-total (Income) 0.00 0.00 0.00
ii. Deduct: Other non-operating expenses 0.00 0.00 0.00
a. Miscellaneous Expenses 0.00 0.00 0.00
b.
c.
d.
Sub-total (Expenses) 0.00 0.00 0.00
iii. Net of other non-operating income /
expenses [net of 11(i) & 11(ii)] 0.00 0.00 0.00
12. Profit before tax/loss [10 + 11(iii)] 28.40 31.22 33.88
13. a) Provision for taxes 8.78 9.65 10.47
b) Deferred for Tax Liability(-) Assets(+) 0.00 0.00 0.00
14. Net Profit / Loss (12 -13) 19.62 21.57 23.41
15. a. Equity dividend paid-amount
(Already paid + B.S. provision) 0.00 0.00 0.00
b. Dividend Rate (% age) 0.0% 0.0% 0.0%
c. Other Appropriations
16. Retained Profit (14 - 15) 19.62 21.57 23.41
17. Retained Profit / Net Profit (% age) 100.00% 100.00% 100.00%
CASH ACCRUAL 37.61 37.03 36.70

FORM III - ANALYSIS OF BALANCE SHEET
LIABILITIES
Name: Manju Agarwal
Amounts in Rs.

CURRENT LIABILITIES
1. Short-term borrowing from banks (including
bills purchased, discounted & excess
borrowing placed on repayment basis)
i. State Bank of India 0.00 0.00 0.00
ii. Others 150.00 150.00 150.00
iii. (of which BP & BD) 0.00 0.00 0.00
Sub-total [i + ii] (A) 150.00 150.00 150.00
2. Short term borrowings from others 0.00 0.00 0.00
3. Sundry Creditors (Trade) 28.56 30.77 32.50
4. Advance payments from customers /
deposits from dealers 0.00 0.00 0.00
5. Provision for taxation 8.78 9.65 10.48
6. Dividend payable
7. Other statutory liabilities (due within 1 year)
8. Deposits / instalments of term loans /
DPGs / debentures etc. (due within 1 year) 0.00 0.00 0.00
9. Other current liabilities & provisions
(due within 1 year) - specify major items 4.00 5.00 5.00
a. Other Outstanding Liabilities payable 0.00 0.00 0.00
b. Other Liabilities 4.00 5.00 5.00
c.
d.
Sub total [2 to 9] (B) 41.34 45.42 47.98
10. Total current liabilities [A + B] 191.34 195.42 197.98
TERM LIABILITIES
11. Debentures (not maturing within 1 year) 0.00 0.00 0.00
12. Preference Shares (redeemable after 1 year) 0.00 0.00 0.00
13. Term loans (excluding instalments
payable within 1 year) 0.00 0.00 0.00
14. Deferred Payment Credits (excluding
instalments due within 1 year) 0.00 0.00 0.00
15. Term deposits (repayable after 1 year)
16. Other term liabilities 60.00 45.00 30.00
17. Total Term Liabilities [11 to 16] 60.00 45.00 30.00
18. Total Outside Liabilities [10 + 17] 251.34 240.42 227.98
NET WORTH
19. Ordinary Share Capital 120.00 120.00 120.00
20. General Reserve 0.00 0.00 0.00
21. Revaluation Reserve 0.00 0.00 0.00
22. Other Reserves (excluding Provisions) 0.00 0.00 0.00
23. Surplus (+) or deficit (-) in Profit & Loss a/c 19.62 41.19 64.60
23. a. Share Application money 0.00 0.00 0.00
b. Share Premium Account 0.00 0.00 0.00
c. Deferred Tax Liability A/c 0.00 0.00 0.00
d. Others 0.00 0.00 0.00
e. Drawings -3.00 -21.00 -41.00
24. Net Worth 136.62 140.19 143.60
25. TOTAL LIABILITIES [18 + 24] 387.96 380.61 371.58

FORM III - ANALYSIS OF BALANCE SHEET (Continued)
ASSETS
Amounts in Rs. Lacs
Name: Manju Agarwal

CURRENT ASSETS
26. Cash and Bank Balances 17.26 16.91 9.82
27. Investments (other than long term) 0.00 0.00 0.00
i. Govt. and other trustee securities 0.00 0.00 0.00
ii. Fixed Deposits with banks 0.00 0.00 0.00
28. i. Receivables other than deferred &
exports (incldg. bills purchased and
discounted by banks) 74.17 64.90 68.14
ii. Export receivables (incldg. bills
purchased/discounted by banks) 0.00 0.00 0.00
29. Instalments of deferred receivables
(due within 1 year) 0.00 0.00 0.00
30. Inventory: 154.52 162.25 170.36
manufacture) 61.81 64.90 68.14
a. Imported 0.00 0.00 0.00
b. Indigenous 61.81 64.90 68.14
ii. Stocks-in-process 0.00 0.00 0.00
iii. Finished goods 92.71 97.35 102.22
iv. Other consumable spares 0.00 0.00 0.00
a. Imported 0.00 0.00 0.00
b. Indigenous 0.00 0.00 0.00
31. Advances to suppliers of raw materials
and stores/spares 10.00 20.00 20.00
32. Advance payment of taxes 0.00 0.00 0.00
33. Other current assets (specify major items) 0.00 0.00 0.00
a. 0.00 0.00 0.00
b. 0.00 0.00 0.00
c. 0.00 0.00 0.00
d. 0.00 0.00 0.00
34. Total Current Assets (26 to 33) 255.95 264.06 268.32
FIXED ASSETS
35 Gross Block (land, building, machinery,
work-in-progress) 150.00 150.00 150.00
36 Depreciation to date 17.99 33.45 46.74
37 Net Block (35 - 36) 132.01 116.55 103.26
OTHER NON-CURRENT ASSETS

38 Investments/book debts/advances/deposits
which are not current assets 0.00 0.00 0.00
i. a. Investments in subsidiary
companies / affiliates 0.00 0.00 0.00
b. Others 0.00 0.00 0.00
ii. Advances to suppliers of capital goods
and contractors 0.00 0.00 0.00
iii. Deferred receivables (maturity
exceeding 1 year) 0.00 0.00 0.00
iv. Others 0.00 0.00 0.00
a. Security Deposit 0.00 0.00 0.00
b. Sales Tax under Appeal 0.00 0.00
c. Tax Deducted at Source 0.00 0.00 0.00
d. Others 0.00 0.00 0.00
39 Non-consumable stores and spares 0.00 0.00
40 Other non-current assets including
dues from directors 0.00 0.00 0.00
41 Total Other Non-current Assets (38 to 40) 0.00 0.00 0.00
42 Intangible Assets (patents, good will,
prelim.expenses, bad / doubtful debts not
provided for, etc. 0.00 0.00 0.00
43 Total Assets (34+37+41+42) 387.96 380.61 371.58
44 Tangible Net Worth (24 - 42) 136.62 140.19 143.60
45 Net Working Capital (34 - 10) 64.61 68.64 70.34
46 Current Ratio (34 / 10) 1.34 1.35 1.36

47 Total OUTSIDE Liabilities / Tangible
Net Worth (18 / 44) 1.84 1.71 1.59
48 Total TERM Liabilities / Tangible
Net Worth (17 / 44) 0.44 0.32 0.21
RATIOS NET OF REVALUATION

RESERVES
49 TANGIBLE NET WORTH (24-21-42) 136.62 140.19 143.60
50 TOTAL OUTSIDE LIAB/TNW 1.84 1.71 1.59
51 TOTAL TERM LIAB/TNW 0.44 0.32 0.21
ADDITIONAL INFORMATION
A. Arrears of depreciation 0.00 0.00 0.00
B. Contingent Liabilities:
i. Arrears of cumulative dividends 0.00 0.00 0.00
ii. Gratuity liability not provided for 0.00 0.00 0.00
iii. Disputed excise / customs /
tax liabilities 0.00 0.00 0.00
iv. Other liabilities not provided for 0.00 0.00 0.00
FORM IV
COMPARATIVE STATEMENT OF CURRENT ASSETS AND CURRENT LIABILITIES
Name: Manju Agarwal
Amounts in Rs.

A. CURRENT ASSETS
1. Raw materials (incl. stores & other items
used in the process of manufacture)
a. Imported 0.00 0.00 0.00
Month's Consumption
b. Indigenous 61.81 64.90 68.14
Month's Consumption (1.09) (1.25) (1.25)
2. Other Consumable spares, excluding
those included in 1 above
a. Imported 0.00 0.00 0.00
Month's Consumption
b. Indigenous 0.00 0.00 0.00
Month's Consumption
3. Stock-in-process 0.00 0.00 0.00
Month's cost of production
4. Finished goods 92.71 97.35 102.22
Month's cost of sales (1.62) (1.63) (1.63)
5. Receivables other than export & deferred
receivables (incl. bills purchased &
discounted by bankers) 74.17 64.90 68.14
Month's domestic sales: excluding
deferred payment sales (1.18) (0.99) (0.99)
6. Export receivables (incl. bills purchased
and discounted) 0.00 0.00 0.00
Month's export sales
7. Advances to suppliers of raw materials &
stores / spares, consumables 10.00 20.00 20.00
8. Other current assets incl. cash & bank
balances & deferred receivables due
within one year 17.26 16.91 9.82
Cash and Bank Balances 17.26 16.91 9.82
Investments (other than long term): 0.00 0.00 0.00
i. Govt. and other trustee securities 0.00 0.00 0.00
ii. Fixed Deposits with banks 0.00 0.00 0.00
Instalments of deferred receivables
(due within 1 year) 0.00 0.00 0.00
Advance payment of taxes 0.00 0.00 0.00
Other current assets 0.00 0.00 0.00
9. Total Current Assets 255.95 264.06 268.32
(To agree with item 34 in Form III)
FORM IV
COMPARATIVE STATEMENT OF CURRENT ASSETS AND CURRENT LIABILITIES
Name: Manju Agarwal
Amounts in Rs.

B. CURRENT LIABILITIES
(Other than bank borrowings for working capital)
10. Creditors for purchase of raw materials,

stores & consumable spares 28.56 30.77 32.50
Month's purchases (0.60) (0.60)
11. Advances from customers 0.00 0.00 0.00
12. Statutory liabilities 0.00 0.00 0.00
13 Other current liabilities: 12.78 14.65 15.48
Short term borrowings from others 0.00 0.00 0.00
Provision for taxation 8.78 9.65 10.48
Dividend payable 0.00 0.00 0.00
Deposits / instalments of term loans / DPGs
/ debentures etc. (due within 1 year) 0.00 0.00 0.00
Other current liabilities & provisions
(due within 1 year) 4.00 5.00 5.00
14. Total (To agree with total B of Form-III) 41.34 45.42 47.98
DATA ANALYSIS
Name: Manju Agarwal

OPERATING STATEMENT
Amounts in Rs. Lacs

Excise Duty : Gross Sales 0.00% 0.00% 0.00%

Annual Growth in Net Sales 5.00% 5.00%
1 RATIO OF NET SALES TO :

manufacture) 90.78% 78.61% 79.11%
a. Imported 0.00% 0.00% 0.00%
b. Indigenous 90.78% 78.61% 79.11%
ii. Other Spares 0.00% 0.00% 0.00%
a. Imported 0.00% 0.00% 0.00%
b. Indigenous 0.00% 0.00% 0.00%
iii. Power and Fuel 3.32% 3.48% 3.45%
iv. Direct Labour (Factory wages & salaries) 3.72% 3.72% 3.62%
v. Other manufacturing expenses 3.39% 3.31% 3.34%
vi. Depreciation 2.39% 1.96% 1.60%
vii. Selling, general and administrative expenses 0.13% 0.13% 0.12%
viii. Interest 1.42% 2.02% 1.93%
2 COMPOSITION OF COST OF SALES : 2019 2020 2021

manufacture) 99.45% 86.86% 87.38%
a. Imported 0.00% 0.00% 0.00%
b. Indigenous 99.45% 86.86% 87.38%
ii. Other Spares 0.00% 0.00% 0.00%
a. Imported 0.00% 0.00% 0.00%
b. Indigenous 0.00% 0.00% 0.00%
iii. Power and Fuel 3.64% 3.85% 3.81%
iv. Direct Labour (Factory wages & salaries) 4.08% 4.11% 4.00%
v. Other manufacturing expenses 3.71% 3.66% 3.69%
vi. Depreciation 2.62% 2.16% 1.77%
vii. Accretion/Depletion in SIP & FG Stocks -13.51% -0.65% -0.65%
CHECK TOTAL 100.00% 100.00% 100.00%
3 PERCENTAGE GROWTHS : 2019 2020 2021
i. Gross Sales 5.00% 5.00%

ii. Gross Domestic Sales 5.00% 5.00%
iii. Gross Exports
iv. Net Sales 5.00% 5.00%
v. Total Raw Materials -9.08% 5.67%
vi. Imported Raw Materials
vii. Indegenous Raw Materials -9.08% 5.67%
viii. Other Spares
ix. Imported Spares
x. Indegenous Spares
xi. Power and Fuel 10.00% 4.00%
xii. Direct Labour (Factory wages & salaries) 5.00% 2.04%
xiii. Other manufacturing expenses 2.59% 5.77%
xiv. Depreciation -14.06% -14.04%
xv. Selling, general and administrative expenses 5.02% 2.98%
xvi. Interest 50.05% 0.00%
4 Non-Operating Income / Net Sales 0.00% 0.00% 0.00%

5 Non-Operating Income / PBT 0.00% 0.00% 0.00%
6 Net Profit / PBT 69.08% 69.09% 69.10%
7 Retained Profit / Net Profit 100.00% 100.00% 100.00%
8 Cash Accrual / Net Sales 5.00% 4.69% 4.43%
9 Average Cost of Borrowings 7.10% 10.65% 10.65%
BALANCE SHEET

1 COMPOSITION OF CURRENT LIABILITIES

i. Short-term borrowing from banks 78.39% 76.76% 75.77%
ii. Short term borrowings from others 0.00% 0.00% 0.00%
iii. Sundry Creditors (Trade) 14.93% 15.75% 16.42%
iv. Advance payments from customers 0.00% 0.00% 0.00%
v. Provision for taxation 4.59% 4.94% 5.29%
vi. Dividend payable 0.00% 0.00% 0.00%
vii. Other statutory liabilities (due within 1 year) 0.00% 0.00% 0.00%
viii. Instalments payable within 1 year 0.00% 0.00% 0.00%
ix. Other current liabilities & provisions 2.09% 2.56% 2.53%
CHECK TOTAL 100.00% 100.00% 100.00%
2 ANNUAL GROWTH : LIABILITIES 2019 2020 2021
i. Short-term borrowing from banks 0.00% 0.00%

ii. Short term borrowings from others
iii. Sundry Creditors (Trade) 7.74% 5.62%
iv. Advance payments from customers
v. Provision for taxation 9.95% 8.56%
vi. Dividend payable
vii. Other statutory liabilities (due within 1 year)
viii. Instalments payable within 1 year #DIV/0! #DIV/0!
ix. Other current liabilities & provisions 9.87% 5.64%
x. Total Current Liabilities 2.13% 1.31%
xi. Total Term Liabilities -25.00% -33.33%
xii. Total Outside Liabilities -4.34% -5.17%
xiii. Net Worth 2.61% 2.43%
xiv. Tangible Net Worth 2.61% 2.43%
3 COMPOSITION OF CURRENT ASSETS 2019 2020 2021
i. Cash and Bank Balances 6.74% 6.40% 3.66%

ii. Investments (other than long term) 0.00% 0.00% 0.00%
iii. Receivables 28.98% 24.58% 25.40%
iv. Instalments of deferred receivables 0.00% 0.00% 0.00%
v. Inventory: 60.37% 61.44% 63.49%
vi. Raw materials 24.15% 24.58% 25.40%
vii. Stocks-in-process 0.00% 0.00% 0.00%
viii. Finished goods 36.22% 36.87% 38.10%
ix. Other consumable spares 0.00% 0.00% 0.00%
x. Advances to suppliers of raw materials 3.91% 7.57% 7.45%
xi. Advance payment of taxes 0.00% 0.00% 0.00%
xii. Other current assets 0.00% 0.00% 0.00%
CHECK TOTAL 100.00% 100.00% 100.00%
4 ANNUAL GROWTH : ASSETS 2019 2020 2021
i. Cash and Bank Balances -2.03% -41.93%

ii. Investments (other than long term)
iii. Receivables -12.50% 4.99%
iv. Instalments of deferred receivables
v. Inventory: 5.00% 5.00%
vi. Raw materials 5.00% 4.99%
vii. Stocks-in-process
viii. Finished goods 5.00% 5.00%
ix. Other consumable spares
x. Advances to suppliers of raw materials 100.00% 0.00%
xi. Advance payment of taxes
xii. Other current assets
xiii. Total Current Assets 3.17% 1.61%
xiv. Gross Block 0.00% 0.00%
xv. Net Block -11.71% -11.40%
xvi. Total Other Non-current Assets
xvii. Intangible Assets #DIV/0! #DIV/0!
xviii. Net Working Capital 6.24% 2.48%
2019 2020 2021

5 TOL / TNW 1.84 1.71 1.59
6 (TL + Net Worth) : Net Block 148.94% 158.89% 168.12%
7 (TL + TNW) : Tangible Non Current Assets 148.94% 158.89% 168.12%
8 Net Block : TL #DIV/0! #DIV/0! #DIV/0!
9 (Inventories + Rec) : S.T. Bank Borrowings 152.46% 151.43% 159.00%
10 Current Assets : S.T. Bank Borrowings 170.63% 176.04% 178.88%
11 PL Depreciation : Average Gross Block 11.99% 10.31% 8.86%
FORM VI
FUNDS FLOW STATEMENT
Name: Manju Agarwal
Amounts in Rs.
Projected Projected
Financial Year ended / ending 2020 2021
No.of months 12 12
1. SOURCES
a. Net Profit 21.57 23.41
b. Depreciation 15.46 13.29
c. Increase in Capital 0.00 0.00
d. Increase in Term Liabilities
(including Public Deposits) 0.00 0.00
e. Decrease in
i. Fixed Assets
ii. Other non-current Assets
f. Others
g. TOTAL 37.03 36.70
2. USES
a. Net loss
b. Decrease in Term Liabilities
(including Public Deposits) 15.00 15.00
c. Increase in
i. Fixed Assets 0.00 0.00
ii. Other non-current Assets 0.00 0.00
d. Dividend Payments 0.00 0.00
e. Others 18.00 20.00
f. TOTAL 33.00 35.00
3. Long Term Surplus (+) / Deficit (-) [1-2] 4.03 1.70

4. Increase/decrease in current assets
* (as per details given below) 8.11 4.26
5. Increase/decrease in current liabilities
other than bank borrowings 4.08 2.56
6. Increase/decrease in working capital gap 4.03 1.70
7. Net Surplus / Deficit (-) [3-6] 0.00 0.00
8. Increase/decrease in bank borrowings 0.00 0.00
9. Increase/decrease in NET SALES 37.60 39.48
* Break up of item-4
i. Increase/decrease in Raw Materials 3.09 3.24
ii. Increase/decrease in Stocks-in-Process 0.00 0.00
iii. Increase/decrease in Finished Goods 4.64 4.87
iv. Increase/decrease in Receivables
a) Domestic -9.27 3.24
b) Export 0.00 0.00
v. Increase/decrease in Stores & Spares 0.00 0.00
vi. Increase/decrease in other current assets 9.65 -7.09
TOTAL 8.11 4.26
ASSESSED BANK FINANCE
Name: Manju Agarwal
Amounts in Rs.
Total Current Assets 255.95 264.06 268.32

Current Liabilities (Other than Bank
Borrowing) 41.34 45.42 47.98
Working Capital Gap 214.61 218.64 220.34
Net Working Capital (Actual /Projected) 64.61 68.64 70.34
Assessed Bank Finance (ABF) 150.00 150.00 150.00
NWC/TCA (%) 25.24% 25.99% 26.21%
Bank Finance to TCA (%) 58.61% 56.81% 55.90%
Other CL/TCA (%) 16.15% 17.20% 17.88%
S. Creditors /TCA (%) 11.16% 11.65% 12.11%
Inv./NS (Days) 75.00 75.00 75.00
Rec./ Gross Sales (Days) 36.00 30.00 30.00
S. Creditors /Purchase (Days) 16.79 18.18 18.18
ASSESSED BANK FINANCE
Name: Manju Agarwal
Amounts in Rs.
Projected Projected
Financial Year ended / ending 2020 2021
No.of months 12 12
Total Current Assets 264.06 268.32

Current Liabilities (Other than Bank
Borrowing) 45.42 47.98
Working Capital Gap 218.64 220.34
Net Working Capital (Actual /Projected) 68.64 70.34
Assessed Bank Finance (ABF) 150.00 150.00
NWC/TCA (%) 25.99% 26.21%
Bank Finance to TCA (%) 56.81% 55.90%
Other CL/TCA (%) 17.20% 17.88%
S. Creditors /TCA (%) 11.65% 12.11%
Inv./NS (Days) 75.00 75.00
Rec./ Gross Sales (Days) 30.00 30.00
S. Creditors /Purchase (Days) 18.18 18.18
CHECK
Name:Manju Agarwal

1. Closing Stock in Process
of Operating Stament tallies Yes Yes Yes
with that of Balance Sheet
2. Closing Stock of F.G.

of Operating Stament tallies Yes Yes Yes
3. Net Profit 19.62 21.57 23.41
4. Depreciation Reported in
Operating Statement tallies Yes Yes
a. As per Op Statement 15.46 13.29
b. As per Form-III 15.46 13.29
c. Difference 0.00 0.00
5. Balance Sheet Assets is Yes Yes Yes

equal to Liabilities
a. Total Assets 387.96 380.61 371.58

b. Total Liabilities 387.96 380.61 371.58
c. Difference - - -
PERFORMANCE & FINANCIAL INDICATORS
Name: Manju Agarwal

Amounts in Rs.
Net sales 752.00 789.60 829.08

Operating Profit 39.05 47.20 49.86
Net Other Income 0.00 0.00 0.00
Profit Before Tax 28.40 31.22 33.88
PBT/NS (%) 3.78% 3.95% 4.09%
Profit After Tax 19.62 21.57 23.41
Cash Accruals 37.61 37.03 36.70
Paid Up Capital 120.00 120.00 120.00
Tangible Net Worth 136.62 140.19 143.60
Adj TNW (Excl. Invest/Loans in Subsidiaries) 136.62 140.19 143.60
TOL/TNW 1.84 1.71 1.59
Total Term Lia./TNW 0.44 0.32 0.21
Current Ratio 1.34 1.35 1.36
Total Tangible Assets (TTA) 387.96 380.61 371.58
EFFICIENCY RATIOS : 2019 2020 2021

Net Sales/TTA (Times) 1.94 2.07 2.23
PBT/TTA (%) 7.32% 8.20% 9.12%
Operating Cost/NS (%) 94.81% 94.02% 93.99%
Bank Fin./Curr. Assets (%) 58.61% 56.81% 55.90%
Inv. +Rec./NS (Days) 111 105 105
LIQUIDITY RATIOS 2019 2020 2021

Current Ratio 1.34 1.35 1.36
Acid Test Ratio 0.53 0.52 0.49
Bank Finance to WCG (%) 69.89% 68.61% 68.08%
LEVERAGE RATIOS 2019 2020 2021

Debt : Equity Ratio 0.44 0.32 0.21
TOL/TNW 1.84 1.71 1.59
Debt : Assets Ratio 0.15 0.12 0.08
Fixed Assets Coverage Ratio 0.45 0.39 0.29
Interest Coverage Ratio 5.36 3.92 3.95
TURNOVER RATIOS 2019 2020 2021

Inventory Turnover Period (DAYS) 75 75 75
Average Collection Period (DAYS) 36 30 30
Total Assets Turnover (TIMES) 1.94 2.07 2.23
Average Credit Period (DAYS) 18 18
Bank Finance Turnover 5.01 5.26 5.53
Current Assets Turnover 2.94 2.99 3.09
PROFITABILITY RATIOS 2019 2020 2021

Net Profit Margin (%) 2.61% 2.73% 2.82%
Net Income : Assets Ratio (%) 5.06% 5.67% 6.30%
Return on Investment (ROCE)(%) 14.70% 16.46% 16.99%
Return on Equity (%) 16.35% 17.98% 19.51%
Operating Profitability (%) 5.19% 5.98% 6.01%
Pre-Tax Profitability (%) 3.78% 3.95% 4.09%
PBT/TTA (%) 7.32% 8.20% 9.12%
STRUCTURAL RATIOS 2019 2020 2021

Retained Profit (%) 100.00% 100.00% 100.00%
Raw Material Content (%) 87.62% 86.30% 86.82%
Operating Cost/Sales (%) 94.81% 94.02% 93.99%
FINANCIAL SUMMARY
Name: Manju Agarwal
Amounts in Rs.
2019 2020 2021
1. Gross Sales - Domestic 752.00 789.60 829.08
- Exports 0.00 0.00 0.00
2. Less Excise Duty 0.00 0.00 0.00
3. Net Sales (1 - 2) 752.00 789.60 829.08
4. Depreciation 17.99 15.46 13.29
5. Operating Profit (before Interest) 39.05 47.20 49.86
6. Interest 10.65 15.98 15.98
7. PBT 28.40 31.22 33.88
8. Tax 8.78 9.65 10.47
9. PAT 19.62 21.57 23.41
10. PBDIT (4+6+7) 57.04 62.66 63.15
11. Paid Up Capital (PUC) 120.00 120.00 120.00
12. Total Outside Liabilities (TOL) 251.34 240.42 227.98
13. Tangible Net Worth (TNW) 136.62 140.19 143.60
14. Adjusted TNW 136.62 140.19 143.60
15. Total Assets 387.96 380.61 371.58
16.. Intangible Assets 0.00 0.00 0.00
17. TTA (15-16) 387.96 380.61 371.58
18. PBDIT/INT (10/6) 5.36 3.92 3.95
19. PBT/Net Sales 3.78% 3.95% 4.09%
20. PAT/Net Sales 2.61% 2.73% 2.82%
21. ROCE (PBDIT/TTA) 14.70% 16.46% 16.99%
22. (INV+RECV)/NET SALES (Days) 111 105 105
24. Current Ratio 1.34 1.35 1.36
25. TOL/TNW 1.84 1.71 1.59
26. TOL/TNW (Adjusted) 1.84 1.71 1.59
27. Cash Accrual 37.61 37.03 36.70
FUNDS FLOW ANALYSIS
2020 2021
1. Long Term Sources 37.03 36.70
2. Long Term Uses 33.00 35.00
3. Surplus/Deficit 4.03 1.70
CALCULATION OF BREAK-EVEN ANALYSIS
FORM VII
Name: Manju Agarwal
Amounts in Rs. Lacs
Audited Estimated Projected

Capacity Utilisation % 100 100 100
1 Sales 752.00 789.60 829.08
2 Less Opening Stock of SIP 0.00 0.00 0.00

Add Closing Stock of SIP 0.00 0.00 0.00
Less Opening Stock of Finished Good 0.00 92.71 97.35
Add Closing Stock of Finished Goods 92.71 97.35 102.22
Net Sales for Break-even calculation 844.71 794.24 833.95
3 Variable cost: 766.07 713.45 751.73
3.1 Raw Material consumed 682.67 620.69 655.87

3.2 Other Spares 0.00 0.00 0.00
3.3 Power and Fuel 80 20 22.00 22.88
3.4 Salary and Wages 50 14.00 14.70 15.00
3.5 Other Manufacturing Expenses 100 25.50 26.16 27.67
3.6 Interest on Cash Credit Loan 10.65 15.98 15.98
3.7 Selling and Administrative 50 13.25 13.92 14.33
4 Fixed Cost 50.24 49.58 48.34
4.1 Power and Fuel 20 5.00 5.50 5.72

4.2 Salary and Wages 50 14.00 14.70 15.00
4.3 Depreciation 17.99 15.46 13.29
4.4 Selling and Administrative Exp. 50 13.25 13.92 14.33
4.5 Interest on Term Loan 0.00 0.00 0.00
4.6 Non-Operatiting Expenses 0.00 0.00 0.00
5 Contribution 78.64 80.80 82.22
6 Break-Even Sales 480.42 484.49 487.44
7 Break-Even at Installed capacity 63.89 61.36 58.79

Actuals Actuals Estimated Projected Projectionsprojection 2007 2008 2009 2010 2011 2012

Uploaded by

Copyright:

Available Formats

Actuals Actuals Estimated Projected Projectionsprojection 2007 2008 2009 2010 2011 2012

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Actuals Actuals Estimated Projected Projectionsprojection 2007 2008 2009 2010 2011 2012

Uploaded by

Copyright:

Available Formats

Name: Manju Agarwal