Gyan Jyoti Books Private Limited

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 11

Amount in Lakhs

Gyan Jyoti Books Private Limited 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
CMA-Form-II Actual Actual Provisional Estimated Projected Projected Projected

1 Gross Sales (net of returns):


(i). Domestic Sales 366.66 422.92 482.13 549.63 632.07 733.21 857.85
(ii). Export Sales 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(ii). Duty Drawback
Total: 366.66 422.92 482.13 549.63 632.07 733.21 857.85
2 Less: Excise Duty 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Other Items [If any] 0.00 0.00 0.00 0.00 0.00 0.00 0.00
3 Net Sales ( item 1 minus 2 ) 366.66 422.92 482.13 549.63 632.07 733.21 857.85
4 %age rise/fall in Net Sales as compared to previous
years 15.34% 14.00% 14.00% 15.00% 16.00% 17.00%
Add other revenue income - - - - - - -
Total Sales including Rev. Income 366.66 422.92 482.13 549.63 632.07 733.21 857.85
5 Cost of Sales
i Raw Materials(incl. stores and other items used in the
process of mfg )
a. Imported
b. Indigenous 333.44 388.09 442.21 519.09 584.44 671.19 789.52
ii Other Spares
a. Imported
b. Indigenous - - - - - - -
iii Power & Fuel 0.39 0.42 0.55 1.59 1.71 1.85 2.00
iv Factory Wages & Salary 10.11 10.11 11.32 11.43 13.07 14.38 15.82
v Overhead 1.80 2.24 3.76 4.57 5.20 5.91 6.95
vi Depreciation 0.85 0.57 0.59 0.52 0.62 0.65 0.67
vii Sub-total (items i to vi) 346.59 401.43 458.43 537.20 605.05 693.98 814.95
viii Add : Opening Stocks in RM & Process - - 0.00 0.00 0.00 0.00 0.00
Sub-total 346.59 401.43 458.43 537.20 605.05 693.98 814.95
ix Deduct : Closing Stocks in RM & Process - - 0.00 0.00 0.00 0.00 0.00
x Cost of Production 346.59 401.43 458.43 537.20 605.05 693.98 814.95
2 Add : Opening Stocks of Finished Goods 21.03 21.03 24.15 29.46 49.44 62.45 71.10
Sub-total 367.62 422.46 482.58 566.66 654.49 756.43 886.05
xii Deduct : Closing Stocks of Finished Goods 24.15 24.15 29.46 49.44 62.45 71.10 85.99
xiii Sub-total: (Total Cost of Sales) 343.47 398.31 453.12 517.22 592.04 685.33 800.07
6 Selling General & Administrative Expenses 18.75 20.12 25.19 22.78 25.20 27.56 30.30
7 Sub-total : ( 5+6 ) 362.22 418.43 478.31 540.00 617.24 712.89 830.37
8 Operating Profit before interest (3-7) Including
Depreciation 4.44 4.49 3.82 9.63 14.83 20.32 27.48

Operating Profit before interest (3-7) - Cont. from


Page 1 4.44 4.49 3.82 9.63 14.83 20.32 27.48
Interest - Bank - Cash Credit 4.39 3.97 3.20 3.73 8.00 8.00 8.00
Interest - Bank Term Loan - - - - - - -
9 Net Interest 4.39 3.97 3.20 3.73 8.00 8.00 8.00
10 Operating Profit after intrest (8-9) 0.05 0.52 0.62 5.90 6.83 12.32 19.48
11 (i). Add other non-operating income
a. INTEREST (From Bank) 5.5 7.85 8.02 5.42 7.27 7.34 7.42
b. RENTAL INCOME - - - - - - -
c. DUTY DRAWBACK - - - - - - -
d. Others (From IT refund) - - - - - - -
Sub-total (income) 5.50 7.85 8.02 5.42 7.27 7.34 7.42
11 (ii). Deduct other non-operating expenses
a. Exchange loss - - - - - - -
b. Salary Paid - Partners - - - - - - -
c. Interest Paid - Others - - - - - - -
d. Previous year's deferred tax/Others - - - - - - -
Sub-total (expenses) - - - - - - -
(iii). Net of other non-operating income/expenses
11 5.5 7.85 8.02 5.42 7.27 7.34 7.42
12 Profit before tax / Loss [10+11(iii)] 5.55 8.37 8.64 11.31 14.10 19.66 26.90
13 Provision for Taxes 1.66 1.96 2.04 2.58 2.78 3.20 3.56
14 Net Profit /Loss (item 12 - 13) 3.89 6.41 6.60 8.73 11.32 16.46 23.34
a. Equity Dividend paid amount (Already paid + B.S.
Provisions)- Drawings
b. Dividend payable
c. Transferred to General Reserve
15 Retained Profit
16 Retained Profit / Net Profit (%age)
Gyan Jyoti Books Private Limited 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
CMA-Form-III Actual Actual Provisional Estimated Projected Projected Projected
LIABILITIES
Current Liabilities
from Applicant Banks - - - 100.00 100.00 100.00 100.00
From Other Banks 41.07 40.24 40.50 - - - -
Subtotal-STBB 41.07 40.24 40.50 100.00 100.00 100.00 100.00
Sundry creditors Trade 108.85 119.74 83.20 86.53 93.50 102.86 107.37
Sundry creditors expenses 6.04 0.85 1.41 1.49 1.53 1.91 1.89
Advance from customers 18.09 20.15 14.84 5.10 5.71 6.51 7.29
Provision for taxation 1.66 1.96 2.04 2.58 2.78 3.20 3.56
Dividend payable - - - - - - -
Other SL payable in 1 year - - - - - - -
Term Loan Inst 1 year - - - - - - -
Other Cur liabilites & Prov - - - - - - -

OCL 134.64 142.70 101.48 95.69 103.51 114.48 120.11

Total CL (OCL + BB) 175.71 182.94 141.98 195.69 203.51 214.48 220.11

Term Liabilities
Term Loan from our Bank - - - - - - -
TL from Other Banks - - - - - - -
Other Term Loans - - - - - - -
WBIDC - - - - - - -
Unsecured Loan Quasi 36.34 43.21 45.84 36.89 34.00 20.00 12.00
Total Term Loans 36.34 43.21 45.84 36.89 34.00 20.00 12.00

Total Out Side Liabilities 212.05 226.15 187.82 232.58 237.51 234.48 232.11

Net Worth
Authorised Capital 5.00 5.00 5.00 5.00 5.00 5.00 5.00
Paid Up Capital 1.00 1.00 1.00 1.00 1.00 1.00 1.00
General Reserve - - - - - - -
Revaluation Reserve - - - - - - -
Share Appln Money - - - - - - -
Profit & Loss Account 5.63 12.03 20.67 31.98 46.09 65.75 92.65
Security Premium - - - - - - -
Share premium - - - - - - -
Total Net Worth 6.63 13.03 21.67 32.98 47.09 66.75 93.65

Total Liabilities 218.68 239.18 209.49 265.56 284.60 301.23 325.76


Gyan Jyoti Books Private Limited 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
CMA-Form-III Actual Actual Provisional Estimated Projected Projected Projected
Current Assets
Cash & Bank Balance 5.63 2.03 1.99 2.36 2.59 2.87 3.21
Fixed Deposits & RD with Banks - - - - - - -
Sundry Debtors 146.61 165.91 112.68 163.68 175.17 189.19 196.75
Inventory - - - - - - -
Raw Materials - - - - - - -
Indigenious - - - - - - -
Imported - - - - - - -
Stock In Process - - - - - - -
Finished Goods 21.03 24.15 29.46 49.44 62.45 71.10 85.99
Other Spares - - - - - - -
Advance to Suppliers - - - 10.42 10.63 11.48 12.74
Advance Payment of tax - - - - - - -
Other Current Assets 1.53 - 9.91 7.16 5.70 5.14 4.03
Interest receivable on FD - - - - - - -

Total Current Assets 174.80 192.09 154.03 233.06 256.54 279.78 302.72

Fixed Assets
Gross Block 3.00 3.00 6.49 6.49 8.14 9.14 9.94
Depreciation 0.85 1.52 2.11 2.62 3.25 3.90 4.57
Net Block 2.15 1.48 4.39 3.86 4.89 5.24 5.36

Non Current Assets


Pre-operative Expenses - - - - - - -
Security Deposit/ Investments 41.73 45.61 51.08 28.63 23.17 16.22 17.68
Adv for Capital Goods - - - - - - -
Other Advances - - - - - - -
Loan to a Director - - - - - - -
Total Non Current Assets 41.73 45.61 51.08 28.63 23.17 16.22 17.68

Intangible Assets
Preliminary Expenses - - - - - - -
Others - - - - - - -
Total Intangible Assets - - - - - - -

Total Assets 218.68 239.18 209.50 265.56 284.60 301.23 325.77


Total Liabilities 218.68 239.18 209.49 265.56 284.60 301.23 325.76

Check Diffierence - - 0.00 (0.01) (0.00) 0.00 0.00

Tangible Net Worth 6.63 13.03 21.67 32.98 47.09 66.75 93.65

Net Working Capital (0.91) 9.15 12.05 37.37 53.02 65.30 82.61

Current Ratio 0.99 1.05 1.08 1.19 1.26 1.30 1.38

TOL/TNW 31.98 17.36 8.67 7.05 5.04 3.51 2.48

TOL/TNW - Revaluation 31.98 17.36 8.67 7.05 5.04 3.51 2.48

TOL/TNW+QUASI 31.98 17.36 8.67 7.05 5.04 3.51 2.48

TOL/TNW adj 31.98 17.36 8.67 7.05 5.04 3.51 2.48

Term Debt Equity Ratio 5.48 3.32 2.12 1.12 0.72 0.30 0.13
Salient Financial Indicators

Salient Financial Indicators 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Gyan Jyoti Books Private Limited Actual Actual Provisional Estimated Projected Projected Projected
Authorised Capital 5.00 5.00 5.00 5.00 5.00 5.00 5.00
Paid Up Capital 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Net Worth 6.63 13.03 21.67 32.98 47.09 66.75 93.65
TNW excl Revaluation Reser 6.63 13.03 21.67 32.98 47.09 66.75 93.65
TNW less Investments
6.63 13.03 21.67 32.98 47.09 66.75 93.65
in subsidiaries
TNW treating Unsecured
6.63 13.03 21.67 32.98 47.09 66.75 93.65
Loan as quasi Equity
Long Term Secured Loans - - - - - - -
Long Term Un Sec Loans - - - - - - -
Of which from Promoters - - - - - - -
Net Fixed Assets 2.15 1.48 4.39 3.86 4.89 5.24 5.36
Capital Work In Progress
Non current Assets 41.73 45.61 51.08 28.63 23.17 16.22 17.68
Inventories 21.03 24.15 29.46 49.44 62.45 71.10 85.99
Receivables 146.61 165.91 112.68 163.68 175.17 189.19 196.75
Other Current Assets 7.16 2.03 11.89 19.94 18.92 19.49 19.98
Other Current Liabilities
134.64 142.70 101.48 95.69 103.51 114.48 120.11
excluding BB including TL
Bank Borrowings 41.07 40.24 40.50 100.00 100.00 100.00 100.00
Total Current Liabilities 175.71 182.94 141.98 195.69 203.51 214.48 220.11
Net Working Capital (0.91) 9.15 12.05 37.37 53.02 65.30 82.61
Current Ratio 0.99 1.05 1.08 1.19 1.26 1.30 1.38
TL Inst due with in 1 year - - - - - - -
Current Ratio without TL 0.99 1.05 1.08 1.19 1.26 1.30 1.38
Debt Equity Ratio
Considering all Out side
31.98 17.36 8.67 7.05 5.04 3.51 2.48
liabilities TOL/TNW
TOL/Adj TNW 31.98 17.36 8.67 7.05 5.04 3.51 2.48
TOL/TNW + Quasi Equity 31.98 17.36 8.67 7.05 5.04 3.51 2.48
Net Sales 366.66 422.92 482.13 549.63 632.07 733.21 857.85
Operating Profit 0.05 0.52 0.62 5.90 6.83 12.32 19.48
Other Income 5.50 7.85 8.02 5.42 7.27 7.34 7.42
Profit before Depreciation
10.79 12.91 12.43 15.56 22.73 28.31 35.57
Interest & Tax
Depreciation 0.85 0.57 0.59 0.52 0.62 0.65 0.67
Interest 4.39 3.97 3.20 3.73 8.00 8.00 8.00
Tax 1.66 1.96 2.04 2.58 2.78 3.20 3.56
Profit after Tax (PAT) 3.89 6.41 6.60 8.73 11.32 16.46 23.34
Cash Accruals 4.74 6.98 7.19 9.25 11.95 17.11 24.01
% increase in Net sales - 15.34 14.00 14.00 15.00 16.00 17.00
% Op Profit/Net Sales 0.01 0.12 0.13 1.07 1.08 1.68 2.27
% PBDIT/Net Sales 2.94 3.05 2.58 2.83 3.60 3.86 4.15
% PAT /Net Sales 1.06 1.52 1.37 1.59 1.79 2.25 2.72
% Interest /Net Sales 1.20 0.94 0.66 0.68 1.27 1.09 0.93
Return on Capital Employed 0.17 0.19 0.16 0.09 0.13 0.15 0.16
Interest cover Times
Break up of Current Assets
Particulars 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Cash & Bank Balance 5.63 2.03 1.99 2.36 2.59 2.87 3.21
Fixed Deposits with Banks - - - - - - -
Sundry Debtors 146.61 165.91 112.68 163.68 175.17 189.19 196.75
Raw Materials - - - - - - -
Stock In Process - - - - - - -
Finished Goods 21.03 24.15 29.46 49.44 62.45 71.10 85.99
Other Spares - - - - - - -
Advance Payment of tax - - - - - - -
Other Current Assets 1.53 - 9.91 7.16 5.70 5.14 4.03
Advance to Suppliers - - - 10.42 10.63 11.48 12.74
Interest receivable on FD - - - - - - -
Total 174.80 192.09 154.03 233.06 256.54 279.78 302.72

Break up of Current Liabilities


Particulars 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
CC from Applicant Banks - - - 100.00 100.00 100.00 100.00
CC From Other Banks 41.07 40.24 40.50 - - - -
Sundry creditors Trade 108.85 119.74 83.20 86.53 93.50 102.86 107.37
Advance from customers 18.09 20.15 14.84 5.10 5.71 6.51 7.29
Provision for taxation 1.66 1.96 2.04 2.58 2.78 3.20 3.56
Other Cur liabilites & Prov - - - - - - -
Total 169.67 182.09 140.58 194.20 201.98 212.57 218.22
Funding Pattern of Current Assets
31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
NWC To TCA (0.01) 0.05 0.08 0.16 0.21 0.23 0.27
BB to TCA 0.23 0.21 0.26 0.43 0.39 0.36 0.33
Sundry Creditors to TCA 0.62 0.62 0.54 0.37 0.36 0.37 0.35
OCL to TCA 0.15 0.12 0.12 0.04 0.04 0.04 0.04
Total 1.00 1.00 1.00 1.00 1.00 1.00 1.00

Source & Application of Funds


31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Long Term Source 42.97 56.24 67.51 69.87 81.09 86.75 105.65
Long Term Application 43.88 47.09 55.46 32.49 28.06 21.46 23.05
Long Term Surplus/Deficit (0.91) 9.15 12.04 37.38 53.03 65.29 82.60
Short Term Source 175.71 182.94 141.98 195.69 203.51 214.48 220.11
Short Term Application 174.80 192.09 154.03 233.06 256.54 279.78 302.72
Short Term Surplus/Deficit 0.91 (9.15) (12.05) (37.37) (53.02) (65.30) (82.61)
Financial Parameters 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Current Ratio 0.99 1.05 1.08 1.19 1.26 1.30 1.38
TNW ( Rs. in lacs) 6.63 13.03 21.67 32.98 47.09 66.75 93.65
Debt Equity Ratio 31.98 17.36 8.67 7.05 5.04 3.51 2.48
OpProfit/Sales% - % Op Profit/Net Sales 0.01 1.07 1.08 1.68 2.27
Net Working Capital(Rs) (0.91) 9.15 12.05 37.37 53.02 65.30 82.61

31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24


Actual Actual Provisional Estimated Projected Projected Projected
Assumptions
Sales Gross 366.66 422.92 482.13065 549.62894 632.07328 733.205 857.84985
Sales Net 366.66 422.92 482.13 549.63 632.07 733.21 857.85
Cost of Production 346.59 401.43 458.43027 537.19548 605.04982 693.98025 814.95404
Cost of Sales 343.47 398.31 453.120850278 517.2214827222 592.0409323333 685.326258 800.0669691667
Raw Material con 0 0 0 0 0 0 0
% COP/Sales 94.53% 94.92% 95.08% 97.74% 95.72% 94.65% 95.00%
%COS/Sales 93.68% 94.18% 93.98% 94.10% 93.67% 93.47% 93.26%
% RM/COP 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

Level of Holdings 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24


Actual Actual Provisional Estimated Projected Projected Projected
Raw Material
0.00 0.00 0.00 0.00 0.00 0.00 0.00
Imported
0 0 0 0 0 0 0
0 0 0 0 0 0 0
Indegenious
0 0 0 0 0 0 0
0 0 0 0 0 0 0
Conusmable spares

0 0 0 0 0 0 0
Work in Progress
0 0 0 0 0 0 0
21.03 24.15 29.4635397222 49.437537 62.44642466667 71.10041666667 85.9874875
Finished Goods
22 22 24 35 38 38 39
146.61 165.91 112.675845167 163.68099622 175.1718559932 189.1856044727 196.7530307516
Receivables
146 143 85 109 101 94 84
7.16 2.03 11.89181 19.9428816 18.92044 19.4900103 19.9774463
Other Current Assets
4.10% 1.06% 7.72% 8.56% 7.38% 6.97% 6.60%
108.85 119.74 83.1994569 86.527435176 93.49620919008 102.8612933091 107.3725110415
Sundry Creditors
119 113 69 61 58 56 50
Other Current Liabilites 25.79 22.96 18.285 9.16214 10.0183408 11.616821512 12.73885409344
31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Raw Materials 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Working Progress 0 0 0 0 0 0 0
Finished Goods 21.03 24.15 29.4635397222 49.437537 62.44642466667 71.10041666667 85.9874875
Consumable Spares 0 0 0 0 0 0 0
Receivables 146.61 165.91 112.675845167 163.68099622 175.1718559932 189.1856044727 196.7530307516
Advance to Suppliers 0 0 0 10.41964 10.62803 11.47827 12.74088
Cash & Bank Balance 5.63 2.03 1.98551 2.36411 2.58916 2.87017 3.20658
Other current assets -4.1 0 7.92079 7.1591316 5.70325 5.1415703 4.0299863
Total Current Assets 169.17 192.09 152.045684889 233.06141482 256.5387206599 279.7760314393 302.7179645516
Sundry Creditors 108.85 119.74 83.1994569 86.527435176 93.49620919008 102.8612933091 107.3725110415
Other Current Liabilities 25.79 22.96 18.285 4.065 10.0183408 11.616821512 12.73885409344
Working Capital Gap 34.53 49.39 50.5612279889 142.468979644 153.0241706698 165.2979166182 182.6065994167

Computation of Permissible Bank Finance


2nd Method of lending 31.03.21 31.03.22 31.03.23 31.03.24
Estimated Projected Projected Projected
1. Working Capital Gap 142.47 153.02 165.30 182.61
2. Minimum stipulated 58.27 64.13 69.94 75.68
NWC(25% of CA)
3. Actual/Projected NWC 37.37 53.02 65.30 82.61
4. Item (1) - Item (2) 84.20 88.89 95.35 106.93
5. Item (1) - Item (3) 105.10 100.00 100.00 100.00
6. Permissible Bank Finance 84.20 88.89 95.35 100.00

Turnover Method 31.03.21 31.03.22 31.03.23 31.03.24


Estimated Projected Projected Projected
I) 25% of the Sales accepted
137.41 158.02 183.30 214.46
II) 20% of the Sales
109.93 126.41 146.64 171.57
III) Margin Required [ I minus II ]
27.48 31.60 36.66 42.89
IV) Margin (NWC) available
37.37 53.02 65.30 82.61
V) Item [ I ] minus Item [ III ]
109.93 126.41 146.64 171.57
VI) Item [ I ] minus Item [ IV ]
100.04 104.99 118.00 131.86
VI) lower of ( V ) or( VI )
100.04 104.99 118.00 131.86
Recommended Bank Finance
100.04 104.99 118.00 131.86
Past Financial Brief 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
TNW 6.63 13.03 21.67 32.98 47.09 66.75 93.65
TOL/TNW 31.98 17.36 8.67 7.05 5.04 3.51 2.48
CURRENT RATIO 0.99 1.05 1.08 1.19 1.26 1.30 1.38
NET SALES 366.66 422.92 482.13 549.63 632.07 733.21 857.85
OPERATING PROFIT 0.05 0.52 0.62 5.90 6.83 12.32 19.48
PBDIT 10.79 12.91 12.43 15.56 22.73 28.31 35.57
NET PROFIT (PAT) 3.89 6.41 6.60 8.73 11.32 16.46 23.34
ROCE - % (PAT + INTT/TNW+
SEC.TL+UNS.TL+BB))
0.17 0.19 0.16 0.09 0.13 0.15 0.16

Total Debt Equit Ratio 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Debt Inclduing BB 212.05 226.15 187.82 232.58 237.51 234.48 232.11
TNW 6.63 13.03 21.67 32.98 47.09 66.75 93.65
Debt Equity Ratio 31.98 17.36 8.67 7.05 5.04 3.51 2.48

Fixed Assets Coverage Ratio


31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Net Fixed Assets 2.15 1.48 4.39 3.86 4.89 5.24 5.36
Secured Term Loan - - - - - - -
FACR #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Interest Coverage Ratio 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Profit After Tax 3.89 6.41 6.60 8.73 11.32 16.46 23.34
Depreciation + Exp w/o 0.85 0.57 0.59 0.52 0.62 0.65 0.67
Interest 4.39 3.97 3.20 3.73 8.00 8.00 8.00
Total 9.13 10.95 10.39 12.98 19.95 25.11 32.01
Interest 4.39 3.97 3.20 3.73 8.00 8.00 8.00
Interest Coverage Ratio 2.08 2.76 3.25 3.48 2.49 3.14 4.00

Debt Service Coverage Ratio


31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Profit After Tax 3.89 6.41 6.60 8.73 11.32 16.46 23.34
Depreciation 0.85 0.57 0.59 0.52 0.62 0.65 0.67
Interest 4.39 3.97 3.20 3.73 8.00 8.00 8.00
Total (A) 9.13 10.95 10.39 12.98 19.95 25.11 32.01
Repayment of Term loan - - - - - - -
Interest 4.39 3.97 3.20 3.73 8.00 8.00 8.00
Total (B) 4.39 3.97 3.20 3.73 8.00 8.00 8.00
DSCR 2.08 2.76 3.25 3.48 2.49 3.14 4.00
Break Even Analysis

31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24


Actual Actual Provisional Estimated Projected Projected Projected

sales 366.66 422.92 482.13 549.63 632.07 733.21 857.85

vairable Expenses 342.62 397.74 452.53 516.71 591.42 684.68 799.40

Contribution 24.04 25.18 29.60 32.92 40.66 48.53 58.45

Fixed Expenses 23.99 24.66 28.97 27.03 33.82 36.21 38.97

PV Ratio 1.00 1.02 1.02 1.22 1.20 1.34 1.50

BEP Sales 365.90 414.19 471.96 451.18 525.85 547.09 571.92

% BEP Sales 99.79 97.93 97.89 82.09 83.20 74.62 66.67


Financial High Lights
31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Particulars
Actual Actual Provisional Estimated Projected Projected Projected
Equity/Preference share Capital 1.00 1.00 1.00 1.00 1.00 1.00 1.00

TNW Including unsecured loan 6.63 13.03 21.67 32.98 47.09 66.75 93.65
Secured Term Loan 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Unsecured Loan 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Bank Borrowings 41.07 40.24 40.50 100.00 100.00 100.00 100.00
Current Assets 174.80 192.09 154.03 233.06 256.54 279.78 302.72
Other Current Liabilities 134.64 142.70 101.48 95.69 103.51 114.48 120.11
Current Ratio (incl : TL) 0.99 1.05 1.08 1.19 1.26 1.30 1.38
Term debt equity ratio 5.48 3.32 2.12 1.12 0.72 0.30 0.13
TOL/TNW 31.98 17.36 8.67 7.05 5.04 3.51 2.48

Profitability Projections
FY 31.03.18 31.03.19 31.03.20 31.03.21 31.03.22 31.03.23 31.03.24
Actual Actual Provisional Estimated Projected Projected Projected
Installed Capacity Tpa
Capacity Utilisation%
Net Sales 366.66 422.92 482.13 549.63 632.07 733.21 857.85
Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Revenue 366.66 549.63 632.07 733.21 857.85
Raw Material - - - - - - -
Consumable Stores 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Salary & wages 10.11 10.11 11.32 11.43 13.07 14.38 15.82
Power 0.39 0.42 0.55 1.59 1.71 1.85 2.00
Other Expenses 1.80 2.24 3.76 4.57 5.20 5.91 6.95
Cost of Production 346.59 401.43 458.43 537.20 605.05 693.98 814.95
Cost of Sales 343.47 398.31 453.12 517.22 592.04 685.33 800.07
Amortization 0 0 0 0 0 0 0
PBDIT 10.79 12.91 12.43 15.56 22.73 28.31 35.57
Depreciation 0.85 0.57 0.59 0.52 0.62 0.65 0.67
Interest 4.39 3.97 3.20 3.73 8.00 8.00 8.00
Profit Before ax 5.55 8.37 8.64 11.31 14.10 19.66 26.90
Provision for Tax 1.66 1.96 2.04 2.58 2.78 3.2 3.56
Proftit after Tax 3.89 6.41 6.60 8.73 11.32 16.46 23.34
PBDIT Margin% 2.94% 3.05% 2.58% 2.83% 3.60% 3.86% 4.15%
PAT/Sales% 1.06% 1.52% 1.37% 1.59% 1.79% 2.25% 2.72%

You might also like