Cma

Name: Manju Agarwal

Financial Year ended / ending No.of months

Actuals 2007 12

Actuals Estimated Projected ProjectionsProjection 2008 2009 2010 2011 2012 12 12 12 12 12

% of Depn Written-down value B.F.D. Building Plant and Machinery Electrical Installation Misc Assets others

10.00 8.00 2.00 2.00 0.00

Total Additions during the year Building Plant and Machinery Electrical Installation Misc Assets others 0 Total Depreciation for the year Building Plant and Machinery Electrical Installation Misc Assets others 0 Total W.D.V carried forward Building Plant and Machinery Electrical Installation Misc Assets others 0 Net Fixed Assets

10% 15% 15% 20%

22.00

9.21 7.05 1.76 1.68 0.00 0.00 19.70

8.29 5.99 1.50 1.35 0.00 0.00 17.12

7.46 5.09 1.27 1.08 0.00 0.00 14.90

6.71 4.33 1.08 0.86 0.00 0.00 12.99

6.04 3.68 0.92 0.69 0.00 0.00 11.33

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.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.79 0.95 0.24 0.32 0.00 0.00 2.30

0.92 1.06 0.26 0.34 0.00 0.00 2.58

0.83 0.90 0.22 0.27 0.00 0.00 2.22

0.75 0.76 0.19 0.22 0.00 0.00 1.92

0.67 0.65 0.16 0.17 0.00 0.00 1.66

0.60 0.37 0.23 0.07 0.00 0.00 1.27

9.21 7.05 1.76 1.68 0.00 0.00 19.70

8.29 5.99 1.50 1.35 0.00 0.00 17.12

7.46 5.09 1.27 1.08 0.00 0.00 14.90

6.71 4.33 1.08 0.86 0.00 0.00 12.99

6.04 3.68 0.92 0.69 0.00 0.00 11.33

5.44 3.31 0.69 0.62 0.00 0.00 10.06

Projection Projection Projection Projection 2013 2014 2015 2016 12 12 12 12

5.44 3.31 0.69 0.62 0.00 0.00 10.06

4.89 2.98 0.52 0.56 0.00 0.00 8.95

4.40 2.68 0.39 0.50 0.00 0.00 7.98

3.96 2.41 0.29 0.45 0.00 0.00 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.33 0.17 0.06 0.00 0.00 1.11

0.49 0.30 0.13 0.06 0.00 0.00 0.97

0.44 0.27 0.10 0.05 0.00 0.00 0.86

0.00 0.00 0.00 0.00 0.00 0.00 0.00

4.89 2.98 0.52 0.56 0.00 0.00 8.95

4.40 2.68 0.39 0.50 0.00 0.00 7.98

3.96 2.41 0.29 0.45 0.00 0.00 7.12

3.96 2.41 0.29 0.45 0.00 0.00 7.12

SALES OF VEHICLES

LCV HCV

MONTH 4 6

PRICE 700000 1200000

TOTAL 2800000 7200000 10000000

SPARES @ 5 % COMMISSION

LCV HCV

4 6

21000 36000

84000 216000 300000

PURCHASE PRICE

LCV HCV

4 6

120000000 6000000 126000000

3600000

2716000 6984000 9700000

SPARE @ 90 % TOTAL PURCHASE

116400000 5400000 121800000

SALARY MANAGER SERVICE BOYS WATCH MAN

1 9 3

12000 4500 3500

144000 486000 126000

MANAGER SALES BOYS ACCOUNTS

1 5 1

8000 4750 5250

96000 285000 63000 1200000

900000

RENT TELEPHONE

1 1

40000 5000

480000 60000

480000 45000

OFFICE STATIONERY ADVERTISEMENT OTHER MISC SELLING AND DISTRIBUTION EXPENSES

1 1

5000 40000

60000 480000 200000 2480000

45000 360000 150000 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 2019 12

Projected 2020 12

Projected 2021 12

752.00 0.00 752.00 0.00 752.00

789.60 0.00 789.60 0.00 789.60

829.08 0.00 829.08 0.00 829.08

N/A

5.00%

5.00%

682.67 0.00 682.67 0.00 0.00 0.00 25.00 28.00 25.50 17.99 779.16

620.69 0.00 620.69 0.00 0.00 0.00 27.50 29.40 26.16 15.46 719.21

655.87 0.00 655.87 0.00 0.00 0.00 28.60 30.00 27.67 13.29 755.43

0.00 779.16 0.00 779.16 0.00 779.16 92.71 686.45

0.00 719.21 0.00 719.21 92.71 811.92 97.35 714.57

0.00 755.43 0.00 755.43 97.35 852.78 102.22 750.56

6. Selling, general and administrative expenses 7. Sub-total (5 + 6) 8. Operating Profit before Interest (3 - 7) 9. Interest

26.50 712.95 39.05 10.65

27.83 742.40 47.20 15.98

28.66 779.22 49.86 15.98

10. Operating Profit after Interest (8 - 9) 11. i. Add: Other non-operating Income a. Sale of Fixed Assets b. Others c. d. Sub-total (Income) ii. Deduct: Other non-operating expenses a. Miscellaneous Expenses b. c. d. Sub-total (Expenses) iii. Net of other non-operating income / expenses [net of 11(i) & 11(ii)] 12. Profit before tax/loss [10 + 11(iii)] 13. a) Provision for taxes b) Deferred for Tax Liability(-) Assets(+) 14. Net Profit / Loss (12 -13) 15. a. Equity dividend paid-amount (Already paid + B.S. provision) b. Dividend Rate (% age) c. Other Appropriations 16. Retained Profit (14 - 15) 17. Retained Profit / Net Profit (% age)

28.40

31.22

33.88

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 28.40 8.78 0.00 19.62

0.00 31.22 9.65 0.00 21.57

0.00 33.88 10.47 0.00 23.41

0.00 0.0%

0.00 0.0%

0.00 0.0%

19.62 100.00%

21.57 100.00%

23.41 100.00%

37.61

37.03

36.70

Financial Year ended / ending No.of months

1. Gross Sales i. Domestic Sales ii. Export Sales Total 2. Less Excise Duty 3. Net Sales (1 - 2) 4. % age rise (+) or fall (-) in net sales as compared to previous year (annualised) 5. Cost of Sales i. Raw materials (including stores and other items used in the process of manufacture) a. Imported b. Indigenous ii. Other Spares a. Imported b. Indigenous iii. Power and Fuel iv. Direct Labour (Factory wages & salaries) v. Other manufacturing expenses vi. Depreciation vii. Sub-total (i to vi) viii. ix. x. xi. xii. xiii.

Add: Opening Stock-in-process Sub-total (vii + viii) Deduct: Closing Stock-in-process Cost of Production Add: Opening Stock of finished goods Sub-total (x + xi) Deduct: Closing Stock of finished goods Sub-total (Total Cost of Sales)

CASH ACCRUAL

FORM III - ANALYSIS OF BALANCE SHEET LIABILITIES Name:

Manju Agarwal Amounts in Rs.

Financial Year ended / ending No.of months

CURRENT LIABILITIES 1. Short-term borrowing from banks (including bills purchased, discounted & excess borrowing placed on repayment basis) i. State Bank of India ii. Others iii. (of which BP & BD) Sub-total [i + ii] (A) 2. Short term borrowings from others 3. Sundry Creditors (Trade) 4. Advance payments from customers / deposits from dealers 5. Provision for taxation 6. Dividend payable 7. Other statutory liabilities (due within 1 year) 8. Deposits / instalments of term loans / DPGs / debentures etc. (due within 1 year) 9. Other current liabilities & provisions (due within 1 year) - specify major items a. Other Outstanding Liabilities payable b. Other Liabilities c. d. Sub total [2 to 9] (B) 10. Total current liabilities [A + B]

Estimated 2019 12

Projected 2020 12

Projected 2021 12

0.00 150.00 0.00 150.00 0.00 28.56

0.00 150.00 0.00 150.00 0.00 30.77

0.00 150.00 0.00 150.00 0.00 32.50

0.00 8.78

0.00 9.65

0.00 10.48

0.00

0.00

0.00

4.00 0.00 4.00

5.00 0.00 5.00

5.00 0.00 5.00

41.34 191.34

45.42 195.42

47.98 197.98

0.00 0.00

0.00 0.00

0.00 0.00

0.00

0.00

0.00

TERM LIABILITIES 11. Debentures (not maturing within 1 year) 12. Preference Shares (redeemable after 1 year) 13. Term loans (excluding instalments payable within 1 year) 14. Deferred Payment Credits (excluding instalments due within 1 year) 15. Term deposits (repayable after 1 year) 16. Other term liabilities 17. Total Term Liabilities [11 to 16] 18. Total Outside Liabilities [10 + 17]

0.00

0.00

0.00

60.00 60.00 251.34

45.00 45.00 240.42

30.00 30.00 227.98

NET WORTH 19. Ordinary Share Capital 20. General Reserve 21. Revaluation Reserve 22. Other Reserves (excluding Provisions) 23. Surplus (+) or deficit (-) in Profit & Loss a/c 23. a. Share Application money b. Share Premium Account c. Deferred Tax Liability A/c d. Others e. Drawings 24. Net Worth

120.00 0.00 0.00 0.00 19.62 0.00 0.00 0.00 0.00 -3.00 136.62

120.00 0.00 0.00 0.00 41.19 0.00 0.00 0.00 0.00 -21.00 140.19

120.00 0.00 0.00 0.00 64.60 0.00 0.00 0.00 0.00 -41.00 143.60

387.96

380.61

371.58

25. TOTAL LIABILITIES [18 + 24]

FORM III - ANALYSIS OF BALANCE SHEET (Continued) ASSETS Amounts in Rs.

Lacs

Estimated 2019 12

Projected 2020 12

Projected 2021 12

17.26 0.00 0.00 0.00

16.91 0.00 0.00 0.00

9.82 0.00 0.00 0.00

74.17

64.90

68.14

0.00

0.00

0.00

0.00 154.52

0.00 162.25

0.00 170.36

61.81 0.00 61.81 0.00 92.71 0.00 0.00 0.00

64.90 0.00 64.90 0.00 97.35 0.00 0.00 0.00

68.14 0.00 68.14 0.00 102.22 0.00 0.00 0.00

10.00 0.00 0.00 0.00 0.00 0.00 0.00 255.95

20.00 0.00 0.00 0.00 0.00 0.00 0.00 264.06

20.00 0.00 0.00 0.00 0.00 0.00 0.00 268.32

150.00 17.99 132.01

150.00 33.45 116.55

150.00 46.74 103.26

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.00 0.00 0.00

0.00

0.00

0.00

Name: Manju Agarwal

Financial Year ended / ending No.of months

CURRENT ASSETS 26. Cash and Bank Balances 27. Investments (other than long term) i. Govt. and other trustee securities ii. Fixed Deposits with banks 28. i. Receivables other than deferred & exports (incldg. bills purchased and discounted by banks) ii. Export receivables (incldg. bills purchased/discounted by banks) 29. Instalments of deferred receivables (due within 1 year) 30. Inventory: i. Raw materials (including stores and other items used in the process of manufacture) a. Imported b. Indigenous ii. Stocks-in-process iii. Finished goods iv. Other consumable spares a. Imported b. Indigenous 31. Advances to suppliers of raw materials and stores/spares 32. Advance payment of taxes 33. Other current assets (specify major items) a. b. c. d. 34. Total Current Assets (26 to 33) FIXED ASSETS 35 Gross Block (land, building, machinery, work-in-progress) 36 Depreciation to date 37 Net Block (35 - 36) OTHER NON-CURRENT ASSETS 38 Investments/book debts/advances/deposits which are not current assets i. a. Investments in subsidiary companies / affiliates b. Others ii. Advances to suppliers of capital goods and contractors iii. Deferred receivables (maturity exceeding 1 year) iv. Others a. Security Deposit b. Sales Tax under Appeal c. Tax Deducted at Source d. Others 39 Non-consumable stores and spares 40 Other non-current assets including dues from directors

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. 43 Total Assets (34+37+41+42) 44 Tangible Net Worth (24 - 42) 45 Net Working Capital (34 - 10) 46 Current Ratio (34 / 10) 47 Total OUTSIDE Liabilities / Tangible Net Worth (18 / 44) 48 Total TERM Liabilities / Tangible Net Worth (17 / 44) RATIOS NET OF REVALUATION RESERVES 49 TANGIBLE NET WORTH (24-21-42) 50 TOTAL OUTSIDE LIAB/TNW 51 TOTAL TERM LIAB/TNW ADDITIONAL INFORMATION A. Arrears of depreciation B. Contingent Liabilities: i. Arrears of cumulative dividends ii. Gratuity liability not provided for iii. Disputed excise / customs / tax liabilities iv. Other liabilities not provided for

0.00 387.96 136.62 64.61

0.00 380.61 140.19 68.64

0.00 371.58 143.60 70.34

1.34

1.35

1.36

1.84

1.71

1.59

0.44

0.32

0.21

136.62 1.84 0.44

140.19 1.71 0.32

143.60 1.59 0.21

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

FORM IV COMPARATIVE STATEMENT OF CURRENT ASSETS AND CURRENT LIABILITIES Name: Manju Agarwal Amounts in Rs.

Financial Year ended / ending No.of months

A. CURRENT ASSETS 1. Raw materials (incl. stores & other items used in the process of manufacture) a. Imported Month's Consumption b. Indigenous Month's Consumption 2. Other Consumable spares, excluding those included in 1 above a. Imported Month's Consumption b. Indigenous Month's Consumption 3. Stock-in-process Month's cost of production 4. Finished goods Month's cost of sales 5. Receivables other than export & deferred receivables (incl. bills purchased & discounted by bankers) Month's domestic sales: excluding deferred payment sales 6. Export receivables (incl. bills purchased and discounted) Month's export sales 7. Advances to suppliers of raw materials & stores / spares, consumables 8. Other current assets incl. cash & bank balances & deferred receivables due within one year Cash and Bank Balances Investments (other than long term): i. Govt. and other trustee securities ii. Fixed Deposits with banks Instalments of deferred receivables (due within 1 year) Advance payment of taxes Other current assets 9. Total Current Assets

Estimated 2019

Projected 2020

Projected 2021

12

12

12

0.00

0.00

0.00

61.81 (1.09)

64.90 (1.25)

68.14 (1.25)

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

92.71 (1.62)

97.35 (1.63)

102.22 (1.63)

74.17

64.90

68.14

(1.18)

(0.99)

(0.99)

0.00

0.00

0.00

10.00

20.00

20.00

17.26 17.26 0.00 0.00 0.00

16.91 16.91 0.00 0.00 0.00

9.82 9.82 0.00 0.00 0.00

0.00 0.00 0.00 255.95

0.00 0.00 0.00 264.06

0.00 0.00 0.00 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.

Financial Year ended / ending No.of months

Estimated 2019 12

Projected 2020 12

Projected 2021 12

28.56 0.00 0.00 12.78 0.00 8.78 0.00

30.77 (0.60) 0.00 0.00 14.65 0.00 9.65 0.00

32.50 (0.60) 0.00 0.00 15.48 0.00 10.48 0.00

0.00

0.00

0.00

4.00 41.34

5.00 45.42

5.00 47.98

B. CURRENT LIABILITIES (Other than bank borrowings for working capital) 10. Creditors for purchase of raw materials, stores & consumable spares Month's purchases 11. Advances from customers 12. Statutory liabilities 13 Other current liabilities: Short term borrowings from others Provision for taxation Dividend payable Deposits / instalments of term loans / DPGs / debentures etc. (due within 1 year) Other current liabilities & provisions (due within 1 year) 14. Total (To agree with total B of Form-III)

DATA ANALYSIS Name: Manju Agarwal OPERATING STATEMENT Amounts in Rs. Estimated Projected Financial Year ended / ending No.of months Excise Duty : Gross Sales

Projected

2019

2020

2021

12

12

12

0.00%

0.00%

0.00%

5.00%

5.00%

Annual Growth in Net Sales

1 i.

Lacs

RATIO OF NET SALES TO : Raw materials (including stores and other items used in the process of manufacture)

ii.

iii. iv. v. vi. vii. viii.

90.78%

78.61%

0.00%

0.00%

0.00%

90.78%

78.61%

79.11%

Other Spares

0.00%

0.00%

0.00%

a.

Imported

0.00%

0.00%

0.00%

b.

Indigenous

0.00%

0.00%

0.00%

Power and Fuel

3.32%

3.48%

3.45%

Direct Labour (Factory wages & salaries)

3.72%

3.72%

3.62%

Other manufacturing expenses

3.39%

3.31%

3.34%

Depreciation

2.39%

1.96%

1.60%

Selling, general and administrative expenses

0.13%

0.13%

0.12%

Interest

1.42%

2.02%

1.93%

a.

Imported

b.

Indigenous

2

COMPOSITION OF COST OF SALES :

i.

Raw materials (including stores and

2019

2020

79.11%

2021

other items used in the process of manufacture)

ii.

iii. iv. v. vi. vii.

99.45%

86.86%

0.00%

0.00%

0.00%

99.45%

86.86%

87.38%

Other Spares

0.00%

0.00%

0.00%

a.

Imported

0.00%

0.00%

0.00%

b.

Indigenous

0.00%

0.00%

0.00%

Power and Fuel

3.64%

3.85%

3.81%

Direct Labour (Factory wages & salaries)

4.08%

4.11%

4.00%

Other manufacturing expenses

3.71%

3.66%

3.69%

Depreciation

2.62%

2.16%

1.77%

-13.51%

-0.65%

-0.65%

100.00%

100.00%

100.00%

a.

Imported

b.

Indigenous

Accretion/Depletion in SIP & FG Stocks CHECK TOTAL

87.38%

3 i. ii. iii. iv. v. vi. vii. viii. ix. x. xi. xii. xiii. xiv. xv. xvi. 4 5 6 7 8 9

PERCENTAGE GROWTHS :

2019

2020

2021

Gross Sales

5.00%

5.00%

Gross Domestic Sales

5.00%

5.00%

Gross Exports Net Sales Total Raw Materials

5.00%

5.00%

-9.08%

5.67%

-9.08%

5.67%

Imported Raw Materials Indegenous Raw Materials Other Spares Imported Spares Indegenous Spares Power and Fuel

10.00%

4.00%

Direct Labour (Factory wages & salaries)

5.00%

2.04%

Other manufacturing expenses

2.59%

5.77%

-14.06%

-14.04%

Depreciation Selling, general and administrative expenses Interest

5.02%

2.98%

50.05%

0.00% 0.00%

Non-Operating Income / Net Sales

0.00%

0.00%

Non-Operating Income / PBT

0.00%

0.00%

0.00%

69.08%

69.09%

69.10% 100.00%

Net Profit / PBT Retained Profit / Net Profit

100.00%

100.00%

Cash Accrual / Net Sales

5.00%

4.69%

4.43%

Average Cost of Borrowings

7.10%

10.65%

10.65%

BALANCE SHEET Estimated Projected Financial Year ended / ending No.of months

1 i. ii. iii. iv. v. vi. vii. viii. ix.

Projected

2019

2020

2021

12

12

12

75.77%

COMPOSITION OF CURRENT LIABILITIES Short-term borrowing from banks

78.39%

76.76%

Short term borrowings from others

0.00%

0.00%

0.00%

14.93%

15.75%

16.42%

Advance payments from customers

0.00%

0.00%

0.00%

Provision for taxation

4.59%

4.94%

5.29%

Dividend payable

0.00%

0.00%

0.00%

Other statutory liabilities (due within 1 year)

0.00%

0.00%

0.00%

Instalments payable within 1 year

0.00%

0.00%

0.00%

Sundry Creditors (Trade)

Other current liabilities & provisions CHECK TOTAL

2.09%

2.56%

2.53%

100.00%

100.00%

100.00%

2 i. ii. iii. iv. v. vi. vii. viii. ix. x. xi. xii. xiii. xiv. 3 i. ii. iii. iv. v. vi. vii. viii. ix. x. xi. xii.

ANNUAL GROWTH : LIABILITIES Short-term borrowing from banks

i. ii. iii. iv. v. vi. vii. viii. ix. x. xi. xii. xiii. xiv. xv. xvi. xvii. xviii.

Sundry Creditors (Trade)

2021

0.00%

0.00%

7.74%

5.62%

9.95%

8.56%

Advance payments from customers Provision for taxation Dividend payable Other statutory liabilities (due within 1 year) Instalments payable within 1 year

#DIV/0!

#DIV/0!

Other current liabilities & provisions

9.87%

5.64%

Total Current Liabilities

2.13%

1.31%

-25.00%

-33.33%

Total Term Liabilities Total Outside Liabilities

-4.34%

-5.17%

Net Worth

2.61%

2.43%

Tangible Net Worth

2.61%

2.43%

COMPOSITION OF CURRENT ASSETS

2019

2020

2021

Cash and Bank Balances

6.74%

6.40%

Investments (other than long term)

0.00%

0.00%

0.00%

28.98%

24.58%

25.40%

Receivables Instalments of deferred receivables

3.66%

0.00%

0.00%

0.00%

Inventory:

60.37%

61.44%

63.49%

Raw materials

24.15%

24.58%

25.40%

0.00%

0.00%

0.00%

36.22%

36.87%

38.10%

Other consumable spares

0.00%

0.00%

0.00%

Advances to suppliers of raw materials

3.91%

7.57%

7.45%

Advance payment of taxes

0.00%

0.00%

0.00%

Other current assets

0.00%

0.00%

0.00%

100.00%

100.00%

100.00%

2020

2021

Stocks-in-process Finished goods

ANNUAL GROWTH : ASSETS

2019

Cash and Bank Balances

-2.03%

-41.93%

-12.50%

4.99%

Inventory:

5.00%

5.00%

Raw materials

5.00%

4.99%

5.00%

5.00%

100.00%

0.00%

Total Current Assets

3.17%

1.61%

Gross Block

0.00%

0.00%

-11.71%

-11.40%

#DIV/0!

#DIV/0!

6.24%

2.48%

Investments (other than long term) Receivables Instalments of deferred receivables

Stocks-in-process Finished goods Other consumable spares Advances to suppliers of raw materials Advance payment of taxes Other current assets

Net Block Total Other Non-current Assets Intangible Assets Net Working Capital

2019

5 6 7 8 9

2020

Short term borrowings from others

CHECK TOTAL

4

2019

TOL / TNW

2020

2021

1.84

1.71

1.59

(TL + Net Worth) : Net Block

148.94%

158.89%

168.12%

(TL + TNW) : Tangible Non Current Assets

148.94%

158.89%

168.12%

#DIV/0!

#DIV/0!

#DIV/0!

152.46%

151.43%

159.00%

Net Block : TL (Inventories + Rec) : S.T. Bank Borrowings

10 11

Current Assets : S.T. Bank Borrowings

170.63%

176.04%

178.88%

PL Depreciation : Average Gross Block

11.99%

10.31%

8.86%

FORM VI FUNDS FLOW STATEMENT Name: Manju Agarwal Amounts in Rs.

Financial Year ended / ending No.of months

1. SOURCES a. Net Profit b. Depreciation c. Increase in Capital d. Increase in Term Liabilities (including Public Deposits) e. Decrease in i. Fixed Assets ii. Other non-current Assets f. Others g. TOTAL 2. USES a. b. c.

d. e. f.

Net loss Decrease in Term Liabilities (including Public Deposits) Increase in i. Fixed Assets ii. Other non-current Assets Dividend Payments Others TOTAL

3. Long Term Surplus (+) / Deficit (-) [1-2] 4. Increase/decrease in current assets * (as per details given below) 5. Increase/decrease in current liabilities other than bank borrowings 6. Increase/decrease in working capital gap 7. Net Surplus / Deficit (-) [3-6] 8. Increase/decrease in bank borrowings 9. Increase/decrease in NET SALES * Break up of item-4 i. Increase/decrease in Raw Materials ii. Increase/decrease in Stocks-in-Process iii. Increase/decrease in Finished Goods iv. Increase/decrease in Receivables a) Domestic b) Export v. Increase/decrease in Stores & Spares vi. Increase/decrease in other current assets TOTAL

Projected 2020 12

Projected 2021 12

21.57 15.46 0.00

23.41 13.29 0.00

0.00

0.00

37.03

36.70

15.00

15.00

0.00 0.00 0.00 18.00 33.00

0.00 0.00 0.00 20.00 35.00

4.03

1.70

8.11

4.26

4.08 4.03 0.00 0.00 37.60

2.56 1.70 0.00 0.00 39.48

3.09 0.00 4.64

3.24 0.00 4.87

-9.27 0.00 0.00 9.65 8.11

3.24 0.00 0.00 -7.09 4.26

ASSESSED BANK FINANCE Name:

Manju Agarwal

Estimated Financial Year ended / ending 2019 No.of months 12 Total Current Assets Current Liabilities (Other than Bank Borrowing) Working Capital Gap Net Working Capital (Actual /Projected) Assessed Bank Finance (ABF) NWC/TCA (%) Bank Finance to TCA (%) Other CL/TCA (%) S. Creditors /TCA (%) Inv./NS (Days) Rec./ Gross Sales (Days) S. Creditors /Purchase (Days)

Amounts in Rs. Projected Projected 2020 2021 12 12

255.95

264.06

268.32

41.34 214.61 64.61 150.00 25.24% 58.61% 16.15% 11.16% 75.00 36.00 16.79

45.42 218.64 68.64 150.00 25.99% 56.81% 17.20% 11.65% 75.00 30.00 18.18

47.98 220.34 70.34 150.00 26.21% 55.90% 17.88% 12.11% 75.00 30.00 18.18

ASSESSED BANK FINANCE Name: Manju Agarwal

Financial Year ended / ending No.of months Total Current Assets Current Liabilities (Other than Bank Borrowing) Working Capital Gap Net Working Capital (Actual /Projected) Assessed Bank Finance (ABF) NWC/TCA (%) Bank Finance to TCA (%) Other CL/TCA (%) S. Creditors /TCA (%) Inv./NS (Days) Rec./ Gross Sales (Days) S. Creditors /Purchase (Days)

Amounts in Rs. Projected Projected 2020 2021 12 12 264.06

268.32

45.42 218.64 68.64 150.00 25.99% 56.81% 17.20% 11.65% 75.00 30.00 18.18

47.98 220.34 70.34 150.00 26.21% 55.90% 17.88% 12.11% 75.00 30.00 18.18

CHECK Name:Manju Agarwal

Financial Year ended / ending No.of months 1. Closing Stock in Process of Operating Stament tallies with that of Balance Sheet 2. Closing Stock of F.G. of Operating Stament tallies with that of Balance Sheet 3. Net Profit

Estimated 2019 12

Projected 2020 12

Projected 2021 12

Yes

Yes

Yes

Yes

Yes

Yes

19.62

21.57

23.41

Yes

Yes

15.46 15.46 0.00

13.29 13.29 0.00

Yes

Yes

Yes

387.96 387.96

380.61 380.61 -

371.58 371.58 -

4. Depreciation Reported in Operating Statement tallies with that of Balance Sheet a. As per Op Statement b. As per Form-III c. Difference 5. Balance Sheet Assets is equal to Liabilities a. Total Assets b. Total Liabilities c. Difference

-

PERFORMANCE & FINANCIAL INDICATORS Name: Manju Agarwal Estimated Financial Year ended / ending 2019 No.of months 12

Amounts in Rs. Projected Projected 2020 2021 12 12

Net sales Operating Profit Net Other Income Profit Before Tax PBT/NS (%) Profit After Tax Cash Accruals Paid Up Capital Tangible Net Worth Adj TNW (Excl. Invest/Loans in Subsidiaries) TOL/TNW Total Term Lia./TNW Current Ratio Total Tangible Assets (TTA)

752.00 39.05 0.00 28.40 3.78% 19.62 37.61 120.00 136.62 136.62 1.84 0.44 1.34 387.96

789.60 47.20 0.00 31.22 3.95% 21.57 37.03 120.00 140.19 140.19 1.71 0.32 1.35 380.61

829.08 49.86 0.00 33.88 4.09% 23.41 36.70 120.00 143.60 143.60 1.59 0.21 1.36 371.58

EFFICIENCY RATIOS : Net Sales/TTA (Times) PBT/TTA (%) Operating Cost/NS (%) Bank Fin./Curr. Assets (%) Inv. +Rec./NS (Days)

2019 1.94 7.32% 94.81% 58.61% 111

2020 2.07 8.20% 94.02% 56.81% 105

2021 2.23 9.12% 93.99% 55.90% 105

LIQUIDITY RATIOS Current Ratio Acid Test Ratio Bank Finance to WCG (%)

2019 1.34 0.53 69.89%

2020 1.35 0.52 68.61%

2021 1.36 0.49 68.08%

LEVERAGE RATIOS Debt : Equity Ratio TOL/TNW Debt : Assets Ratio Fixed Assets Coverage Ratio Interest Coverage Ratio

2019 0.44 1.84 0.15 0.45 5.36

2020 0.32 1.71 0.12 0.39 3.92

2021 0.21 1.59 0.08 0.29 3.95

TURNOVER RATIOS Inventory Turnover Period (DAYS) Average Collection Period (DAYS) Total Assets Turnover (TIMES) Average Credit Period (DAYS) Bank Finance Turnover Current Assets Turnover

2019 75 36 1.94 5.01 2.94

2020 75 30 2.07 18 5.26 2.99

2021 75 30 2.23 18 5.53 3.09

PROFITABILITY RATIOS Net Profit Margin (%) Net Income : Assets Ratio (%) Return on Investment (ROCE)(%) Return on Equity (%) Operating Profitability (%) Pre-Tax Profitability (%) PBT/TTA (%)

2019 2.61% 5.06% 14.70% 16.35% 5.19% 3.78% 7.32%

2020 2.73% 5.67% 16.46% 17.98% 5.98% 3.95% 8.20%

2021 2.82% 6.30% 16.99% 19.51% 6.01% 4.09% 9.12%

STRUCTURAL RATIOS Retained Profit (%) Raw Material Content (%) Operating Cost/Sales (%)

2019 100.00% 87.62% 94.81%

2020 100.00% 86.30% 94.02%

2021 100.00% 86.82% 93.99%

FINANCIAL SUMMARY Name: Manju Agarwal

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16.. 17. 18. 19. 20. 21. 22. 24. 25. 26. 27.

Gross Sales - Domestic - Exports Less Excise Duty Net Sales (1 - 2) Depreciation Operating Profit (before Interest) Interest PBT Tax PAT PBDIT (4+6+7) Paid Up Capital (PUC) Total Outside Liabilities (TOL) Tangible Net Worth (TNW) Adjusted TNW Total Assets Intangible Assets TTA (15-16) PBDIT/INT (10/6) PBT/Net Sales PAT/Net Sales ROCE (PBDIT/TTA) (INV+RECV)/NET SALES (Days) Current Ratio TOL/TNW TOL/TNW (Adjusted) Cash Accrual

2019 752.00 0.00 0.00 752.00 17.99 39.05 10.65 28.40 8.78 19.62 57.04 120.00 251.34 136.62 136.62 387.96 0.00 387.96 5.36 3.78% 2.61% 14.70% 111 1.34 1.84 1.84 37.61

2020 789.60 0.00 0.00 789.60 15.46 47.20 15.98 31.22 9.65 21.57 62.66 120.00 240.42 140.19 140.19 380.61 0.00 380.61 3.92 3.95% 2.73% 16.46% 105 1.35 1.71 1.71 37.03

Amounts in Rs. 2021 829.08 0.00 0.00 829.08 13.29 49.86 15.98 33.88 10.47 23.41 63.15 120.00 227.98 143.60 143.60 371.58 0.00 371.58 3.95 4.09% 2.82% 16.99% 105 1.36 1.59 1.59 36.70

2020 37.03 33.00 4.03

2021 36.70 35.00 1.70

FUNDS FLOW ANALYSIS

1. 2. 3.

Long Term Sources Long Term Uses Surplus/Deficit

CALCULATION OF BREAK-EVEN ANALYSIS FORM VII Name: Manju Agarwal Amounts in Rs.

Financial Year ended / ending No.of months

Capacity Utilisation

%

1 Sales

Lacs

Audited Estimated Projected 2019 2020 2021 12 12 12 100 100 100 752.00 789.60 829.08

2 Less Opening Stock of SIP Add Closing Stock of SIP Less Opening Stock of Finished Good Add Closing Stock of Finished Goods

0.00 0.00 0.00 92.71

0.00 0.00 92.71 97.35

0.00 0.00 97.35 102.22

Net Sales for Break-even calculation

844.71

794.24

833.95

766.07

713.45

751.73

682.67 0.00 20 14.00 25.50 10.65 13.25

620.69 0.00 22.00 14.70 26.16 15.98 13.92

655.87 0.00 22.88 15.00 27.67 15.98 14.33

50.24

49.58

48.34

5.00 14.00 17.99 13.25 0.00 0.00

5.50 14.70 15.46 13.92 0.00 0.00

5.72 15.00 13.29 14.33 0.00 0.00

78.64

80.80

82.22

480.42

484.49

487.44

63.89

61.36

58.79

3 Variable cost: 3.1 3.2 3.3 3.4 3.5 3.6 3.7

Raw Material consumed Other Spares Power and Fuel Salary and Wages Other Manufacturing Expenses Interest on Cash Credit Loan Selling and Administrative

80 50 100 50

4 Fixed Cost 4.1 4.2 4.3 4.4 4.5 4.6

Power and Fuel Salary and Wages Depreciation Selling and Administrative Exp. Interest on Term Loan Non-Operatiting Expenses

5 Contribution 6 Break-Even Sales 7 Break-Even at Installed capacity

20 50 50