Key Financial Indicators of the company(Proj

Particulars Year 1 Year 2

Sales 291814339.00 365793100.00
Gross Profit 122725735.60 153633102.00
Total Operating Profit 96400735.60 126317102.00
Net Profit / Loss 82080698.82 111451246.90
Total Current Assets 40000000.00 91300000.00
Net Fixed Assets 124760000.00 194300000.00
Total Assets 164760000.00 285600000.00
Total Current Liabilities 32973053.25 34969577.60
Total Long Term Libilities 80000000.00 80000000.00
Total Liabilities 112973053.25 114969577.60
Net Worth 133867645.57 282281669.30
Total Liabilities & Net Worth 246840698.82 397251246.90

0.843916039375817 0.407286728483

7026946.75 56330422.40

73% 12%
2% 7%

0.235999693440568 230777611.2739
ors of the company(Projected)
Year 3 Year 4 Year 5
509625555.00 600415595.00 757014730.00
219138988.65 270187017.75 333086481.20 42% 42%
190604838.65 240448995.25 302169005.33 33% 35%
173949596.72 222251545.49 281360555.06 28% 30%
141000000.00 236500000.00 333000000.00
178100000.00 161900000.00 145700000.00
319100000.00 398400000.00 478700000.00 50% 39%
42495972.95 47333254.00 55190426.60 17% 22371529121%
80000000.00 80000000.00 80000000.00 34% 46%
122495972.95 127333254.00 135190426.60
370753623.77 493518291.49 625070128.46
493249596.72 620851545.49 760260555.06
12312104.82 16717687.035
0.33039723713346 0.258011214976872 0.216280414700575 0.15 0.15

98504027.05 189166746.00 277809573.40

25% 20% -0.999999998959299 121%

4% 6%

313902722.918033 233585142.582353 242337419.248539

 43% 45% 44% #DIV/0!
37% 40% 40%
34% 37% 37%

55% 56% 59%

44575548686% 40770699963% 50435665088%
72% 92% 116%

26092439.5076 33337731.8231 42204083.2588

0.15 0.15 0.15
Balance Sheet

Particular Year 1
Currrnt Assets:
Cash/Bank Balances/Margin 15,000,000
Sundry Debtors 6,000,000
Inventory (Stock) 12,000,000
Inventory (inTransit) 5,000,000
Investment/FDR
Security Deposit 2,000,000
Advance Deposits & Franchise Fees -
Total Current Assets 40,000,000

Non Current Assets

Fixed Assets
Interior Decoration & Furniture 9,260,000
Server 95,000,000
Server and Network Installation 3,000,000
Computer and Eqipments 17,500,000
Total Fixed Asset 124,760,000
Total Assets 164,760,000
Current Liabilities:
Bank Loan (Short Term) 20,000,000
Sundry Creditors 5,000,000
Outstanding Provision for expenses 7,000,000
Provision for Tax 973,053
Loan Received -
Total Current Liabilities 32,973,053

Long Term Liabilities:

Bank Loan (Long Term) 80,000,000
Total Long Term Libilities 80,000,000

Total Liabilities 112,973,053

Net Worth 51,786,947
Paid Up Capital -
Capital Reserve
Net Profit/Retain Earnings 82,080,699
Net Worth 133,867,646
Total Liabilities & Net Worth 246,840,699
 2.18

Sundry Debtors
 Amount in taka
Year 2 Year 3 Year 4 Year 5

20,000,000 22,000,000 23,000,000 25,000,000

11,300,000 22,000,000 30,000,000 45,000,000
25,000,000 45,000,000 70,000,000 85,000,000
15,000,000 25,000,000 36,000,000 50,000,000 17,000,000
15,000,000 20,000,000 70,000,000 120,000,000 0.697539285355687
5,000,000 7,000,000 7,500,000 8,000,000
- - - -
91,300,000 141,000,000 236,500,000 333,000,000 1

85,000,000 75,000,000 65,000,000 55,000,000

90,000,000 85,000,000 80,000,000 75,000,000
2,800,000 2,600,000 2,400,000 2,200,000
16,500,000 15,500,000 14,500,000 13,500,000
194,300,000 178,100,000 161,900,000 145,700,000
285,600,000 319,100,000 398,400,000 478,700,000

20,000,000 20,000,000 20,000,000 20,000,000

6,000,000 7,500,000 8,700,000 9,250,000
7,500,000 7,500,000 7,500,000 7,500,000
1,469,578 7,495,973 11,133,254 18,440,427
- - - -
34,969,578 42,495,973 47,333,254 55,190,427
5000000

80,000,000 80,000,000 80,000,000 80,000,000

80,000,000 80,000,000 80,000,000 80,000,000

114,969,578 122,495,973 127,333,254 135,190,427

170,630,422 196,604,027 271,066,746 343,509,573
200,000 200,000 200,000 200,000

111,451,247 173,949,597 222,251,545 281,360,555

282,281,669 370,753,624 493,518,291 625,070,128
397,251,247 493,249,597 620,851,545 760,260,555
 0.67 0.62 0.47 0.39

6000000 11300000 22000000 30000000 45000000

 40,000,000 70,000,000 106,000,000 135,000,000
1.466989409675 1.6707465454088 2.75704687448702 3.587578719676

3 3 5 6

6000000 7500000 8700000 9250000

1000000 1500000 1200000 550000
 Income Statement
Particulars
Production Capacity
Sales
Expenses
Gross Profit
Less:Rent
Less:Salary & Allowances
Less: Promotional Expenses
Less: Utility & Other Administrative Expenses
Less: Depreciation
Total Operating Cost
Total Operating Profit
Other Income
Profit Before Interest & Taxes
Financial Expenses with Principal Payments
Profit Before Taxes
Provision for Tax /Income Taxes
Net Profit / Loss
Withdrawal/Dividend
Retained Earnings for the year

75,000,000.00 113211065
53750000
166961065

NOTE:emi and financial expenses has been calculated at the rate of more than 9% as Naztech h
Sources of Revenue and expenses thereagainst :

Revenue from Hardware from Local Market

hardware (PC)
Accessories
Server Rack
Surveillance System Solution
Server

Sub Total
Revenue from all products from Local & Foreign
Markets
Revenue from local market from software
Revenue from Foreign market from software
Development
Revenue from Training from Local Market
Revenue from local market from Hardware

Sub Total

Revenue From Foreign Resource Outsourcing

Revenue from Anti Money Laundering

Sub Total
Grand Total Revenue

5 years Expenses

Expenses for software development for local market

Expenses for software development for Foreign

market
Expenses for training
Expenses for hardware for local market
Investment in infrastructure
Revenue from Foreign Resource Outsourcing
Total Cost

Grand Total Revenue

Total Cost
Gross Profit
Sales
expense
 Projected One
Initial Year 31.12.2021 31.12.2022 31.12.2023 31.12.2024

262,632,905 329,213,790 458,663,000 540,374,036 681,313,257

177,543,034 222,767,998 305,010,895 346,740,006 445,124,661
85,089,872 106,445,792 153,652,105 193,634,029 236,188,596
2,540,000 2,921,000 3,359,150 3,863,023 4,442,476
4,000,000 4,400,000 5,000,000 5,500,000 6,000,000
1,000,000 1,200,000 1,350,000 1,450,000 1,500,000
785,000 795,000 825,000 925,000 975,000
18,000,000 18,000,000 18,000,000 18,000,000 18,000,000
26,325,000 27,316,000 28,534,150 29,738,023 30,917,476
58,764,871.53 79,129,792.10 125,117,954.83 163,896,006.89 205,271,119.89
5,000,000 6,000,000 7,500,000 8,500,000 9,000,000
63,764,872 85,129,792 132,617,955 172,396,007 214,271,120
15,000,000 15,000,000 15,000,000 15,000,000 15,000,000
48,764,872 70,129,792 117,617,955 157,396,007 199,271,120
2438243.5765 3506489.605 5880897.741625 7869800.344375 9963555.99425
46,326,628 66,623,302 111,737,057 149,526,207 189,307,564
6,948,994 9,993,495 16,760,559 22,428,931 28,396,135
39,377,634 56,629,807 94,976,499 127,097,276 160,911,429

3.92 5.28 8.34 10.93 13.68

63,764,872 2 3 4 5
18488011.75 27921974.4 142423486.05 211531826 350368105.4
24.65% 37.23% 189.90% 282.04% 467.16%
lated at the rate of more than 9% as Naztech has a plan to give more to the investors EMI in following chart has calculated at the rate of 9% keeping in
nses thereagainst :

y1 y2 y3 y4 y5
25,000,000 29,500,000 35,000,000 50,000,000 620,000,000
2,500,000 4,950,000 7,500,000 8,000,000 32,000,000
5,000,000 7,500,000 10,000,000 17,500,000
4,500,000 12,000,000 15,000,000 30,000,000 35,000,000
10,000,000 11,000,000 12,100,000 13,310,000 14,641,000

47,000,000 64,950,000 79,600,000 101,310,000 719,141,000

 y1 y2 y3 y4 y5

50,000,000 60,000,000 72,000,000 86,400,000 83,680,000

100,828,765 181,657,530 263,314,975 344,972,505 398,287,480

54,500,000 81,750,000 122,625,000 183,937,500 185,906,250

47,000,000 64,950,000 79,600,000 101,310,000 719,141,000

252,328,765 388,357,530 537,539,975 716,620,005 1,387,014,730

142485574 182485570 222485580 252485590 302485595

1,5000,00 100,00,000 30,000,000 30,000,000 30,000,000

142,485,574 182,485,570 252,485,580 282,485,590 332,485,595
394,814,339 570,843,100 790,025,555 999,105,595 1,719,500,325

1st year 2nd year 3rd year 4th year 5th year

26,000,000 31,200,000 37,440,000 44,928,000 53,913,600

74,229,990 148,459,980 296,919,960 445,380,025 742,299,985

6,500,000 7,150,000 7,865,000 8,651,500 9,516,650
42,300,000 59,220,000 82,908,000 116,071,200 112,499,680
25,260,000 102,750,000 142,675,000 96,055,000 42,005,715
75,103,284 75,026,568 90,013,136 95,069,790 96245568
249,393,274 423,806,548 657,821,096 806,155,515 1,056,481,198

441,814,339 625,793,100 879,625,555 1,119,415,595 1,497,014,730

249,393,274 423,806,548 657,821,096 806,155,515 1,056,481,198
192,421,065 201,986,552 221,804,459 313,260,080 440,533,532
 281814339 365793100 509625555 600415595 757014730
169088603.4 212159998 290486566.35 330228577.25 423928248.8
 Ratio

25% 39% 18% 26%

3.25099143533333 4.675319473333 7.84119698883334 10.4930671258 13.284741326

#DIV/0!
6% 5% 3% 3% 2%
3 5 8 10 13

68211065 77141552 196169459 267915080 413558532

173.23% 195.92% 498.21% 680.42% 1050.31%
at the rate of 9% keeping in mind the loan may b taken from bank in Bangladesh

Net Profit / Loss 18488011.75 27921974.4 142423486.05 2.12E+08

Total Assets 298650000 332950000 365650000 3.81E+08
0.0619052795915 0.08386236492 0.3895076878 0.554983
0.24650682333333 0.372292992 1.898979814 2.820424
NOTE : 0.15 0.25 0.3 0.35
 1497014730
332485595

1,119,415,595
1,100,415,595
19,000,000
 3.5E+08
5.24E+08
0.669088
4.671575
0.5
Cost of the New project & Means of Finance
(Figure in BDT)
Cost Already Incurred Cost to Be Incurred
SL Particulars
Bank Loan Equity Total Equity

1 Advance Against Rent 0 10,000,000.00 10000000 -

Interior Decoration &

2 1,389,000.00
Furniture
3 Server 20,250,000.00
Server and Network
4 450,000.00
Installation
Computer and
5 2,625,000.00
Eqipments
Total - 10,000,000.00 10,000,000.00 24,714,000.00

Present Structure
Proposed Structure:
Particular Amount In % Particular

Equity : Tk. 10,000,000.00 100.00% Equity

Debt : Tk. - 0.00% Debt
 Cost to Be Incurred Total
Grand Total
Bank loan Total Equity Bank loan

- - 10,000,000.00 - 10,000,000.00

7,871,000.00 9,260,000.00 1,389,000.00 7,871,000.00 9,260,000.00

74,750,000.00 95,000,000.00 20,250,000.00 74,750,000.00 95,000,000.00

2,550,000.00 3,000,000.00 450,000.00 2,550,000.00 3,000,000.00

14,875,000.00 17,500,000.00 2,625,000.00 14,875,000.00 17,500,000.00

100,046,000.00 124,760,000.00 34,714,000.00 100,046,000.00 134,760,000.00

Proposed Structure: After Financing

Amount In %

: Tk. 24,714,000.00 20.00%

: Tk. 100,046,000.00 80.00%
Rent Server
Advance 10,000,000.00 15 lac
Yearly 18,480,000.00 50 servers
1540000
Total 28,480,000.00

Computer

Column1 Column2
Rent 10,000,000.00
server 95,000,000.00
Computer 17,500,000.00
Total Decoration 5,260,000.00
Network and Server installtion 3,000,000.00
Total Project Cost 130,760,000.00
 Decoration
1500000 500 ppl 500.00
50 chair -8000 8,000.00
Table-63 20,000.00
75,000,000.00 Chair 4,000,000.00
Table 1,260,000.00
Total Decoration 5,260,000.00
500
35000
17,500,000.00
Network and Server installtion 3,000,000.00
CASH FLOW STATEMENT
Particular Year - I Year - II
Profit Before Tax After Extra Items 101,400,735.60
Add: Interest Expense 15,000,000.00
Add: Depreciation 18,000,000.00
Add/Minus: Change in Deferred Taxes

EBITDA Cash Flow 134,400,735.60

Less: Interest Expense 15,000,000.00
Less: Taxes 4,320,036.78
Less: Dividends 12,312,104.82
Total 31,632,141.60
CF Before Investing Activities 102,768,594.00
Less: Capital Expenditures

CF Before Working Capital Changes 102,768,594.00

Plus/Minus: Change in Accts Receivable (5,300,000.00)
Plus/Minus: Change in Inventory (28,000,000.00)
Plus/Minus: Change in Accounts Payable 1,000,000.00
Plus/Minus: Change in Dividends Payable

Total Working Capital Changes (32,300,000.00)

CF Before Intercompany Transaction 70,468,594.00

Plus/Minus: Inter Trade Rec from/to Affil. -

CF Before Other B/S Movements 70,468,594.00

Plus/Minus: Other B/S Movements

Financing Needs/Surplus 70,468,594.00

Plus/Minus: ST Bank Debt 20,000,000.00
Plus/Minus: LT Bank Debt (26,350,000.00)
Total Financing (6,350,000.00)
CF after Financing 64,118,594.00
Plus/Minus: Change In Cash 64,118,594.00
 (Amount in Million)
Year - III Year - IV Year - V
132,317,102.00 198,104,838.65 248,948,995.25
15,000,000.00 15,000,000.00 15,000,000.00
18,000,000.00 18,000,000.00 18,000,000.00

165,317,102.00 231,104,838.65 281,948,995.25

15,000,000.00 15,000,000.00 15,000,000.00
5,865,855.10 9,155,241.93 11,697,449.76
16,717,687.04 26,092,439.51 33,337,731.82
37,583,542.14 50,247,681.44 60,035,181.59
127,733,559.87 180,857,157.21 221,913,813.66

127,733,559.87 180,857,157.21 221,913,813.66

(10,700,000.00) (8,000,000.00) (15,000,000.00)
(30,000,000.00) (36,000,000.00) (29,000,000.00)
1,500,000.00 1,200,000.00 550,000.00

(39,200,000.00) (42,800,000.00) (43,450,000.00)

88,533,559.87 138,057,157.21 178,463,813.66

- - -

88,533,559.87 138,057,157.21 178,463,813.66

88,533,559.87 138,057,157.21 178,463,813.66

20,000,000.00 20,000,000.00 20,000,000.00
(26,350,000.00) (26,350,000.00) (26,350,000.00)
(6,350,000.00) (6,350,000.00) (6,350,000.00)
82,183,559.87 131,707,157.21 172,113,813.66
82,183,559.87 131,707,157.21 172,113,813.66
Working Capital Assessment: (Amount in Million)
Sl Items Tied up period Calculation
(in days)

i Raw materials- 90 50,400,000.00 X

imported 360

ii Raw materials – 30 28,000,000.00 X

local 360

iii Work –in – 30 16,400,000.00 X

process

360

iv Finished Goods 7 16,400,000.00 X

360

vi Stores & Spares 2% of machine 90,000,000.00 X

vi Receivables 30 11,300,000.00 X

360
vii Cash Lump-Sum
viii Total [i+ii+iii+iv+v+vi+vii]
ix Less Sundry 15 6,000,000.00 X
creditors 360
[Accounts
x Net-working
Payables] Capital Requirement [i+ii+iii+iv+v+vi+vii-viii]

xi. Less Margin 0.20%

xii Net Permissible Working capital
lation Amount

90 12600000.00 % Used Yearly

60 Raw 64% requirement
50400000.00
materials-
30 2333333.33 imported
Raw 36% 28000000.00
60 materials
Total Rawmaterials 78400000.00
–local
30 1366666.67 Work –in – process 16400000.00

60 Finished 16400000.00
Goods

15 683333.33
60

2% 1800000.00
50400000
60 1883333.33

28000000
60 78400000
5000000.00 0.642857 0.3571428571
25666666.67
15 250000.00
60
25416666.67

0% 50833.33
25,365,833.33
IRR Calculation (Proposed Condition):

Cash Outflow

Year Y-0 (Investment year)

Project Cost (134,760,000.00)
Earning After Tax
Depreciation and Amortization
Earning before depreciation and after Tax
Working Capital Requirement (32,300,000)
Written Down Value after Fifth year
Net Cash Flow (167,060,000)
Discounting Factor 10%
Discounted Cash Flow (167,060,000)
NPV 155,299,651
IRR 32%
Net Cash Flow (167,060,000.00)
Present Value (167,060,000.00)
Discount factor (10%) 32%

Production Year: 1st Year

Capacity Utilization 0%
Sales (BDT mil.) 262,632,905.10

Name of Expense Total Expense

Raw Materials 177,543,033.57
Direct Labor -
Factory Overhead -
Depreciation 18,000,000.00
Administrative Expenses and General Expenses 5,785,000.00
Selling and Distribution Expenses (3% on total Sales) -
Financial Expenses 15,000,000.00
Amortization 18,000,000.00
Total 234,328,033.57

Profit/ Volume Ratio 0.28

Break Even Sales BDT (in Tk. Mil.) 163,185,692.99
Break Even Point 62.13%
Pay Back Period Calculation:

Particulars
Year-0
Year-1
Year-2
Year-3
Year-4
Year-5

PBP 3.16
 134,760,000.00

Y-1 Y-2 Y-3 Y-4 Y-5

46,326,628 66,623,302 111,737,057 149,526,207

189,307,564
18,000,000 18,000,000 18,000,000 18,000,000
18,000,000
64,326,628 84,623,302 129,737,057 167,526,207
207,307,564
(39,200,000) (42,800,000) (43,450,000) (64,450,000)
(75,450,000)
77,060,000
25,126,628 41,823,302 86,287,057 103,076,207 208,917,564
0.909090909090909 0.826446280991735 0.751314800901578 0.683013455365071 0.6209213230592
22842389.0486363 34564712.8057851 64828743.1186138 70402435.9969435 129721370.18134

25,126,627.95 41,823,302.50 86,287,057.09 103,076,206.54 208,917,563.89

19,049,216.21 24,038,320.79 37,598,832.73 34,051,012.80 52,322,617.47
0.758128637090426 0.574759030376588 0.435741280354818 0.330347942999435 0.2504462357918

Fixed Cost Variable Cost

- 177,543,033.57
- -
- -
18,000,000.00 -
1,446,250.00 4,338,750.00
- -
9,000,000.00 6,000,000.00
18,000,000.00 -
46,446,250.00 187,881,783.57

Formula
(Sales- Variable Cost)/Sales
(Fixed cost/ PV Ratio)
(Fixed Cost)/(Sales-variable)
 Net Cash Flow Cumu Cashflow
(167,060,000.00) (167,060,000.00)
25,126,627.95 (141,933,372.05)
41,823,302 (100,110,069.55)
86,287,057 (13,823,012.46)
103,076,207 89,253,194.08
208,917,564 298,170,757.97

years
134760000
Input %
If Sales Decrease by 10.00%
Increase in Cost of Production 0..05%
If All together

Sensitivity Analysis
Situation - 1
10% decrease in Sales Amount in
Particular Year - I Year -II
Gross Profit 93,544,302 117,053,792
Operating Profit 67,219,302 89,737,792
Net Profit 54,358,337 76,700,902

Situation - 2
05% decrease in Cost of Production Amount in
Particular Year - I Year -II
Gross Profit 114,271,305 143,025,102
Operating Profit 87,946,305 115,709,102
Net Profit 74048990.1585 101373646.995

Situation - 3 Amount in
If All together Particular Year - I Year -II
Gross Profit 114,271,305 143,025,102
Operating Profit 58,764,872 79,129,792
Net Profit 46,326,628 66,623,302
 Year - I Year -II
Gross Profit 121,180,166 153,633,102
Operating Profit 60,334,302 92,208,792
Net Profit 11,005,087 42,235,852

If Sales Decrease by 10.00%

New sales after 10 %decrease

Income Statement P
Particulars Initial Year 31.12.2021
Production Capacity
Sales 262,632,905 329,213,790
Expenses 169,088,603 212,159,998
Gross Profit 93,544,302 117,053,792
Less:Rent 2,540,000 2,921,000
Less:Salary & Allowances 4,000,000 4,400,000
Less: Promotional Expenses 1,000,000 1,200,000
Less: Utility & Other Administrative Expenses 785,000 795,000
Less: Depreciation 18,000,000 18,000,000
Total Operating Cost 26,325,000 27,316,000
Total Operating Profit 67219301.70 89737792.00
Other Income 5,000,000 6,000,000
Profit Before Interest & Taxes 72,219,301.70 95,737,792
Financial Expenses with Principal Payments 15,000,000.00 15,000,000
Profit Before Taxes 57,219,302 80,737,792
Provision for Tax /Income Taxes 2860965.085 4036889.6
Net Profit / Loss 54,358,337 76,700,902
Withdrawal/Dividend 8,153,750 19,175,226
Retained Earnings for the year 46,204,586 57,525,677

Sales 281814339 365793100

253632905.1 329213790
expense increase by .05percent
Income Statement P
Particulars Initial Year 31.12.2021
Production Capacity
Sales 291,814,339 365,793,100
Expenses 177,543,034 222,767,998
Gross Profit 114,271,305 143,025,102
Less:Rent 2,540,000 2,921,000
Less:Salary & Allowances 4,000,000 4,400,000
Less: Promotional Expenses 1,000,000 1,200,000
Less: Utility & Other Administrative Expenses 785,000 795,000
Less: Depreciation 18,000,000 18,000,000
Total Operating Cost 26,325,000 27,316,000
Total Operating Profit 87946305.43 115709102.10
Other Income 5,000,000 6,000,000
Profit Before Interest & Taxes 92,946,305.43 121,709,102
Financial Expenses with Principal Payments 15,000,000.00 15,000,000
Profit Before Taxes 77,946,305 106,709,102
Provision for Tax /Income Taxes 3897315.2715 5335455.105
Net Profit / Loss 74,048,990 101,373,647
Withdrawal/Dividend 11,107,349 25,343,412
Retained Earnings for the year 62,941,642 76,030,235

Expenses 169088603.4 212159998

177543033.57 222767997.9

Together
Income Statement P
Particulars Initial Year 31.12.2021
Production Capacity
Sales 262,632,905 329,213,790
Expenses 177,543,034 222,767,998
Gross Profit 85,089,872 106,445,792
Less:Rent 2,540,000 2,921,000
Less:Salary & Allowances 4,000,000 4,400,000
Less: Promotional Expenses 1,000,000 1,200,000
Less: Utility & Other Administrative Expenses 785,000 795,000
Less: Depreciation 18,000,000 18,000,000
Total Operating Cost 26,325,000 27,316,000
Total Operating Profit 58764871.53 79129792.10
Other Income 5,000,000 6,000,000
Profit Before Interest & Taxes 63,764,871.53 85,129,792
Financial Expenses with Principal Payments 15,000,000.00 15,000,000
Profit Before Taxes 48,764,872 70,129,792
Provision for Tax /Income Taxes 2438243.5765 3506489.605
Net Profit / Loss 46,326,628 66,623,302
Withdrawal/Dividend 6,948,994 16,655,826
Retained Earnings for the year 39,377,634 49,967,477
Amount in Taka in %
Year - III Year - IV Year -v Year - I Year -II
168,176,433 210,145,458 257,385,008 35.62% 35.56%
139,642,283 180,407,436 226,467,532 25.59% 27.26%
125,535,169 165,212,064 209,444,156 20.70% 23.30%
9

Amount in Taka in %
Year - III Year - IV Year -v Year - I Year -II
204,614,660 253,675,589 311,890,069 43.51% 43.44%
176,080,510 223,937,566 280,972,593 33.49% 35.15%
160151484.8159 206565688.068125 261223963.24075 28.19% 30.79%

Amount in Taka in %
Year - III Year - IV Year -v Year - I Year -II
204,614,660 253,675,589 311,890,069 43.51% 43.44%
125,117,955 163,896,007 205,271,120 22.38% 24.04%
111,737,057 149,526,207 189,307,564 17.64% 20.24%

0.17639308347848
 Year - III Year - IV Year -v Year - I Year -II
219,138,989 270,187,018 333,086,481 26.62%
142,541,433 183,800,458 230,410,008 20.52%
91,476,861 131,622,935 176,377,008 16.95%

Projected One
31.12.2022 31.12.2023 31.12.2024

458,663,000 540,374,036 681,313,257 291814339 365793100

290,486,566 330,228,577 423,928,249 262632905.1 329213790
168,176,433 210,145,458 257,385,008
3,359,150 3,863,023 4,442,476
5,000,000 5,500,000 6,000,000
1,350,000 1,450,000 1,500,000
825,000 925,000 975,000
18,000,000 18,000,000 18,000,000
28,534,150 29,738,023 30,917,476
139642283.15 180407435.75 226467532.33
7,500,000 8,500,000 9,000,000
147,142,283 188,907,436 235,467,532
15,000,000 15,000,000 15,000,000
132,142,283 173,907,436 220,467,532
6607114.1575 8695371.7875 11023376.61625
125,535,169 165,212,064 209,444,156
37,660,551 57,824,222 104,722,078
87,874,618 107,387,842 104,722,078

509625555 600415595 757014730

458662999.5 540374035.5 681313257
 Projected One
31.12.2022 31.12.2023 31.12.2024

509,625,555 600,415,595 757,014,730

305,010,895 346,740,006 445,124,661 169088603.4 212159998
204,614,660 253,675,589 311,890,069 177,543,034 222,767,998
3,359,150 3,863,023 4,442,476
5,000,000 5,500,000 6,000,000
1,350,000 1,450,000 1,500,000
825,000 925,000 975,000
18,000,000 18,000,000 18,000,000
28,534,150 29,738,023 30,917,476
176080510.33 223937566.39 280972592.89
7,500,000 8,500,000 9,000,000
183,580,510 232,437,566 289,972,593
15,000,000 15,000,000 15,000,000
168,580,510 217,437,566 274,972,593
8429025.516625 10871878.319375 13748629.64425
160,151,485 206,565,688 261,223,963
48,045,445 72,297,991 130,611,982
112,106,039 134,267,697 130,611,982

290486566.35 330228577.25 423928248.8

305010894.6675 346740006.1125 445124661.24

Projected One
31.12.2022 31.12.2023 31.12.2024

458,663,000 540,374,036 681,313,257

305,010,895 346,740,006 445,124,661
153,652,105 193,634,029 236,188,596
3,359,150 3,863,023 4,442,476
5,000,000 5,500,000 6,000,000
1,350,000 1,450,000 1,500,000
825,000 925,000 975,000
18,000,000 18,000,000 18,000,000
 28,534,150 29,738,023 30,917,476
125117954.83 163896006.89 205271119.89
7,500,000 8,500,000 9,000,000
132,617,955 172,396,007 214,271,120
15,000,000 15,000,000 15,000,000
117,617,955 157,396,007 199,271,120
5880897.741625 7869800.344375 9963555.99425
111,737,057 149,526,207 189,307,564
33,521,117 52,334,172 94,653,782
78,215,940 97,192,034 94,653,782
in %
Year - III Year - IV Year -v
36.67% 38.89% 37.78%
30.45% 33.39% 33.24%
27.37% 30.57% 30.74%

in %
Year - III Year - IV Year -v
44.61% 46.94% 45.78%
38.39% 41.44% 41.24%
34.92% 38.23% 38.34%

in %
Year - III Year - IV Year -v
44.61% 46.94% 45.78%
27.28% 30.33% 30.13%
24.36% 27.67% 27.79%
Year - III Year - IV Year -v 20 increase 72,401,162
26.62% 26.62% 26.62% Operating Prof 72,401,162
19.83% 19.72% 19.72% 18488011.75 86881394.45
17.28% 16.87% 17.59% 22185614.10 96,944,133
0

net Profit 18488011.75

Net Profit incr 22185614.1
decrease 14790409.4

Operating Prof19105628.64
increase 22926754.37
decrease 15284502.91

gross profit 92421065

509625555 600415595 757014730 increase 110905278
458662999.5 540374035.5 681313257 decrease 73936852
290486566.35 330228577.25 423928248.8
305,010,895 346,740,006 445,124,661
 110,650,550 171,049,720 220,560,550 276,492,010 -
110,650,550 171,049,720 220,560,550
132780660.48 205259663.74 264672659.88
122,906,482 175,311,191 216,149,614 266,469,185

27921974.4 142423486.05 211531826 350368105.4

73936852 81589241.6 177443567.2 235408064 3.52E+08
22337579.52 113938788.84 169225460.8 280294484.32 0

30395462.458 42136949.736 46057209.212245 60052020.28816

36474554.95 50564339.683 55268651.054694 72062424.34579
24316369.966 33709559.789 36845767.369796 48041616.23053

101986552 221804459 294260080 440533532

122383862.4 266165350.8 353112096 528640238.4
81589241.6 177443567.2 235408064 352426825.6
 Amortization Chart

Year OS Loan Principal Interest

 2022 195000000 20948581.16 16699858.84
Jan 195000000 1674870 1462500
Feb 193325130 1687431.53 1449938.47
Mar 191637698.47 1700087.26 1437282.74
Apr 189937611.21 1712837.92 1424532.08
May 188224773.29 1725684.2 1411685.8
Jun 186499089.09 1738626.83 1398743.17
Jul 184760462.26 1751666.53 1385703.47
Aug 183008795.73 1764804.03 1372565.97
Sep 181243991.7 1778040.06 1359329.94
Oct 179465951.64 1791375.36 1345994.64
Nov 177674576.28 1804810.68 1332559.32
Dec 175869765.6 1818346.76 1319023.24
 2023 174051418.84 22913702.57 14734737.43
Jan 174051418.84 1831984.36 1305385.64
Feb 172219434.48 1845724.24 1291645.76
Mar 170373710.24 1859567.17 1277802.83
Apr 168514143.07 1873513.93 1263856.07
May 166640629.14 1887565.28 1249804.72
Jun 164753063.86 1901722.02 1235647.98
Jul 162851341.84 1915984.94 1221385.06
Aug 160935356.9 1930354.82 1207015.18
Sep 159005002.08 1944832.48 1192537.52
Oct 157060169.6 1959418.73 1177951.27
Nov 155100750.87 1974114.37 1163255.63
Dec 153126636.5 1988920.23 1148449.77
 2024 151137716.27 25063165.92 12585274.08
Jan 151137716.27 2003837.13 1133532.87
Feb 149133879.14 2018865.91 1118504.09
Mar 147115013.23 2034007.4 1103362.6
Apr 145081005.83 2049262.46 1088107.54
May 143031743.37 2064631.92 1072738.08
Jun 140967111.45 2080116.66 1057253.34
Jul 138886994.79 2095717.54 1041652.46
Aug 136791277.25 2111435.42 1025934.58
Sep 134679841.83 2127271.19 1010098.81
Oct 132552570.64 2143225.72 994144.28
Nov 130409344.92 2159299.91 978070.09
Dec 128250045.01 2175494.66 961875.34
 2025 126074550.35 27414263.77 10234176.23
Jan 126074550.35 2191810.87 945559.13
Feb 123882739.48 2208249.45 929120.55
Mar 121674490.03 2224811.32 912558.68
Apr 119449678.71 2241497.41 895872.59
May 117208181.3 2258308.64 879061.36
Jun 114949872.66 2275245.96 862124.04
Jul 112674626.7 2292310.3 845059.7
Aug 110382316.4 2309502.63 827867.37
Sep 108072813.77 2326823.9 810546.1
Oct 105745989.87 2344275.08 793094.92
Nov 103401714.79 2361857.14 775512.86
Dec 101039857.65 2379571.07 757798.93
 2026 98660286.58 29985910.8 7662529.2
Jan 98660286.58 2397417.85 739952.15
Feb 96262868.73 2415398.48 721971.52
Mar 93847470.25 2433513.97 703856.03
Apr 91413956.28 2451765.33 685604.67
May 88962190.95 2470153.57 667216.43
Jun 86492037.38 2488679.72 648690.28
Jul 84003357.66 2507344.82 630025.18
Aug 81496012.84 2526149.9 611220.1
Sep 78969862.94 2545096.03 592273.97
Oct 76424766.91 2564184.25 573185.75
Nov 73860582.66 2583415.63 553954.37
Dec 71277167.03 2602791.25 534578.75
 2027 68674375.78 32798796.07 4849643.93
Jan 68674375.78 2622312.18 515057.82
Feb 66052063.6 2641979.52 495390.48
Mar 63410084.08 2661794.37 475575.63
Apr 60748289.71 2681757.83 455612.17
May 58066531.88 2701871.01 435498.99
Jun 55364660.87 2722135.04 415234.96
Jul 52642525.83 2742551.06 394818.94
Aug 49899974.77 2763120.19 374249.81
Sep 47136854.58 2783843.59 353526.41
Oct 44353010.99 2804722.42 332647.58
Nov 41548288.57 2825757.84 311612.16
Dec 38722530.73 2846951.02 290418.98
 2027 35875579.71 35875549.37 1772890.63
Jan 35875579.71 2868303.15 269066.85
Feb 33007276.56 2889815.43 247554.57
Mar 30117461.13 2911489.04 225880.96
Apr 27205972.09 2933325.21 204044.79
May 24272646.88 2955325.15 182044.85
Jun 21317321.73 2977490.09 159879.91
Jul 18339831.64 2999821.26 137548.74
Aug 15340010.38 3022319.92 115050.08
Sep 12317690.46 3044987.32 92382.68
Oct 9272703.14 3067824.73 69545.27
Nov 6204878.41 3090833.41 46536.59
Dec 3114045 3114014.66 23355.34
 EMI
37648440
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
37648440
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
37648440
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
37648440
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
37648440
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
37648440
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
37648440
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
3137370
Sales 281,814,339.00 365,793,100.00
Expenses 149,393,274.00 223,806,548.00
new sales after 10%decrease 253,632,905.10 329,213,790.00
new expense after 05% increase 156,862,937.70 234,996,875.40
new sales after 20 decrease
gross profit 104,239,631.10 105,407,242.00
Total Operating Cost 24,210,000.00 24,845,000.00
OP 80,029,631.10 80,562,242.00
NP

New sales after 10 %decrease

Income Statement
Particulars Initial Year
Production Capacity
Sales 253,632,905
Expenses 149,393,274
Gross Profit 104,239,631
Less:Rent 1,425,000
Less:Salary & Allowances 4,000,000
Less: Promotional Expenses 1,000,000
Less: Utility & Other Administrativ 785,000
Less: Depreciation 17,000,000
Total Operating Cost 24,210,000
Total Operating Profit 80029631.10
Other Income 5,000,000
Profit Before Interest & Taxes 85,029,631.10
Financial Expenses with Principal 53,750,000.00
Profit Before Taxes 31,279,631
Provision for Tax /Income Taxes 1563981.555
Net Profit / Loss 29,715,650
Withdrawal/Dividend 4,457,347
Retained Earnings for the year 25,258,302
Income Statement
Particulars Initial Year
Production Capacity
Sales 281,814,339
Expenses 156,862,938
Gross Profit 124,951,401
Less:Rent 1,425,000
Less:Salary & Allowances 4,000,000
Less: Promotional Expenses 1,000,000
Less: Utility & Other Administrativ 785,000
Less: Depreciation 17,000,000
Total Operating Cost 24,210,000
Total Operating Profit 100741401.30
Other Income 5,000,000
Profit Before Interest & Taxes 105,741,401.30
Financial Expenses with Principal 53,750,000.00
Profit Before Taxes 51,991,401
Provision for Tax /Income Taxes 2599570.065
Net Profit / Loss 49,391,831
Withdrawal/Dividend 7,408,775
Retained Earnings for the year 41,983,057

Together
Income Statement
Particulars Initial Year
Production Capacity
Sales 253,632,905
Expenses 156,862,938
Gross Profit 96,769,967
Less:Rent 1,425,000
Less:Salary & Allowances 4,000,000
Less: Promotional Expenses 1,000,000
Less: Utility & Other Administrativ 785,000
Less: Depreciation 17,000,000
Total Operating Cost 24,210,000
Total Operating Profit 72559967.40
Other Income 5,000,000
Profit Before Interest & Taxes 77,559,967.40
Financial Expenses with Principal 53,750,000.00
Profit Before Taxes 23,809,967
Provision for Tax /Income Taxes 1190498.37
Net Profit / Loss 22,619,469
Withdrawal/Dividend 3,392,920
Retained Earnings for the year 19,226,549
 879,625,555.00 1,100,415,595.00 1,497,014,730.00
657,821,096.00 806,155,515.00 1,056,481,198.00
791,662,999.50 990,374,035.50 1,347,313,257.00
690,712,150.80 846,463,290.75 1,109,305,257.90

133,841,903.50 184,218,520.50 290,832,059.00

25,635,000.00 26,345,000.00 26,975,000.00
108,206,903.50 157,873,520.50 263,857,059.00

Projected One
31.12.2021 31.12.2022 31.12.2023 31.12.2024

329,213,790 791,663,000 990,374,036 1,347,313,257

223,806,548 657,821,096 806,155,515 1,056,481,198
105,407,242 133,841,904 184,218,521 290,832,059
1,450,000 1,460,000 1,470,000 1,500,000
4,400,000 5,000,000 5,500,000 6,000,000
1,200,000 1,350,000 1,450,000 1,500,000
795,000 825,000 925,000 975,000
17,000,000 17,000,000 17,000,000 17,000,000
24,845,000 25,635,000 26,345,000 26,975,000
80562242.00 108206903.50 157873520.50 263857059.00
6,000,000 7,500,000 8,500,000 9,000,000
86,562,242 115,706,904 166,373,521 272,857,059
53,750,000 53,750,000 53,750,000 53,750,000
32,812,242 61,956,904 112,623,521 219,107,059
1640612.1 3097845.175 5631176.025 10955352.95
31,171,630 58,859,058 106,992,344 208,151,706
7,792,907 17,657,717 37,447,321 104,075,853
23,378,722 41,201,341 69,545,024 104,075,853
 Projected One
31.12.2021 31.12.2022 31.12.2023 31.12.2024

365,793,100 879,625,555 1,100,415,595 1,497,014,730

234,996,875 690,712,151 846,463,291 1,109,305,258
130,796,225 188,913,404 253,952,304 387,709,472
1,450,000 1,460,000 1,470,000 1,500,000
4,400,000 5,000,000 5,500,000 6,000,000
1,200,000 1,350,000 1,450,000 1,500,000
795,000 825,000 925,000 975,000
17,000,000 17,000,000 17,000,000 17,000,000
24,845,000 25,635,000 26,345,000 26,975,000
105951224.60 163278404.20 227607304.25 360734472.10
6,000,000 7,500,000 8,500,000 9,000,000
111,951,225 170,778,404 236,107,304 369,734,472
53,750,000 53,750,000 53,750,000 53,750,000
58,201,225 117,028,404 182,357,304 315,984,472
2910061.23 5851420.21 9117865.2125 15799223.605
55,291,163 111,176,984 173,239,439 300,185,248
13,822,791 33,353,095 60,633,804 150,092,624
41,468,373 77,823,889 112,605,635 150,092,624

Projected One
31.12.2021 31.12.2022 31.12.2023 31.12.2024

329,213,790 791,663,000 990,374,036 1,347,313,257

234,996,875 690,712,151 846,463,291 1,109,305,258
94,216,915 100,950,849 143,910,745 238,007,999
1,450,000 1,460,000 1,470,000 1,500,000
4,400,000 5,000,000 5,500,000 6,000,000
1,200,000 1,350,000 1,450,000 1,500,000
795,000 825,000 925,000 975,000
17,000,000 17,000,000 17,000,000 17,000,000
24,845,000 25,635,000 26,345,000 26,975,000
69371914.60 75315848.70 117565744.75 211032999.10
6,000,000 7,500,000 8,500,000 9,000,000
75,371,915 82,815,849 126,065,745 220,032,999
53,750,000 53,750,000 53,750,000 53,750,000
21,621,915 29,065,849 72,315,745 166,282,999
1081095.73 1453292.435 3615787.2375 8314149.955
20,540,819 27,612,556 68,699,958 157,968,849
5,135,205 8,283,767 24,044,985 78,984,425
15,405,614 19,328,789 44,654,972 78,984,425
IRR Calculation (Proposed Condition): 05% increase in sales and decrease in

Cash Outflow

Year Y-0 (Investment year)

Project Cost (259,700,000.00)
Earning After Tax
Depreciation and Amortization
Earning before depreciation and after Tax
Working Capital Requirement (32,300,000)
Written Down Value after Fifth year
Net Cash Flow (292,000,000)
Discounting Factor 10%
Discounted Cash Flow (292,000,000)
NPV 182,703,576
IRR 24%
Net Cash Flow (292,000,000.00)
Present Value (292,000,000.00)
Discount factor (10%) 24%

Production Year: 1st Year

Capacity Utilization 0%
Sales (BDT mil.) 281,814,339.00

Name of Expense Total Expense

Raw Materials 177,543,033.57
Direct Labor -
Factory Overhead -
Depreciation 18,000,000.00
Administrative Expenses and General Expenses 5,785,000.00
Selling and Distribution Expenses (3% on total Sales) -
Financial Expenses 15,000,000.00
Amortization 18,000,000.00
Total 275,754,783.57

Profit/ Volume Ratio 0.27

Break Even Sales BDT (in Tk. Mil.) 259,677,238.55
Break Even Point 92.14%
Pay Back Period Calculation:

Particulars
Year-0
Year-1
Year-2
Year-3
Year-4
Year-5

PBP 4.43
in sales and decrease in sales

259,700,000.00

Y-1 Y-2 Y-3 Y-4 Y-5

2,973,378 32,158,252 77,678,750 115,937,078

156,240,416
18,000,000 18,000,000 18,000,000 18,000,000
18,000,000
20,973,378 50,158,252 95,678,750 133,937,078
174,240,416
(6,900,000) (3,600,000) (650,000) (650,000)
44,100,000
202,000,000
14,073,378 46,558,252 95,028,750 133,287,078 420,340,416
0.909090909090909 0.826446280991735 0.751314800901578 0.683013455365071 0.6209213230592
12793979.9577272 38477894.6239669 71396506.0787942 91036867.6443719 260998327.22057

14,073,377.95 46,558,252.50 95,028,749.59 133,287,077.92 420,340,415.97

11,357,008.85 30,319,909.24 49,940,381.23 56,526,292.09 143,856,408.60
0.806985279800885 0.651225241815314 0.52552918397973 0.424094315577414 0.3422378699182

Fixed Cost Variable Cost

- 177,543,033.57
- -
- -
18,000,000.00 - 262623603.4 67696250 194927353.4
1,446,250.00 4,338,750.00 275754783.57 71081062.5 204673721.07
- -
9,000,000.00 6,000,000.00
18,000,000.00 -
71,081,062.50 204,673,721.07

Formula
(Sales- Variable Cost)/Sales
(Fixed cost/ PV Ratio)
(Fixed Cost)/(Sales-variable)
 Net Cash Flow Cumu Cashflow
(292,000,000.00) (292,000,000.00)
14,073,377.95 (277,926,622.05)
46,558,252 (231,368,369.55)
95,028,750 (136,339,619.96)
133,287,078 (3,052,542.04)
420,340,416 417,287,873.93

years
 GROWTH RATIOS:
Sales Growth, Sales%
Total Assets Growth, %
Total Liabilities Growth, %

PROFITABILITY RATIOS:

Gross Margin, Composite %

Operating Profit Margin, %
Interest Expense to Sales, %
Net Margin, %
Return on Assets, %
Return on Equity , %
Cash Withdrawal/Dividend Payout Rate, %

COVERAGE RATIOS:
Interest Coverage (EBIT/Total Interest)
Debt Ser. Coverage(EBITDA/Total Interest +CMLTD)

LIQUIDITY RATIOS:

Quick Ratio (X)

Current Ratio (X)

LEVERAGE RATIOS:

Total Liabilities/ Net Worth (X)

Total Assets
growth
margin
Total Liabilities

gross margin

Total Operating Profit

Net Profit / Loss

ROA

1. DPR = Total dividends / Net income

DOR

interst
Financial Expenses with Principal Payments/debt Serv
debt service coverage ratio

Equity

Current Ratio

current asset -inventory

quick ratio

Profit Before Interest & Taxes

Equity
retain earning

total equity
Year-I Year - II Year - III Year-IV Year-V
% % %

- 29.80% 39.32% 17.82% 26.08%

- 11.49% 9.82% 21.47% 17.90%
- -12.96% -11.50% -14.86% -15.00%

40.00% 42.00% 43.00% 45.00% 44.00%

31.41% 35.21% 37.97% 40.61% 40.44%
26.61% 20.50% 8.53% 6.82% 5.01%
13.41% 21.05% 27.45% 31.42% 32.80%
12.65% 23.12% 38.26% 42.48% 47.42%
21.75% 25.38% 54.84% 81.45% 134.91%
15.00% 25.00% 30.00% 35.00% 50.00%

1.25 1.80 2.68 3.36 4.20

0.70 1.43 2.60 3.51 4.62

0.85 1.90 2.26 3.52 4.49

1.21 2.61 3.32 5.00 6.03

1.70 0.97 0.66 0.48 0.25

0.13 0.21 0.27 0.31 0.33

 298650000 332950000 365650000 444150000
11.49% 9.82% 21.47%
0.126494052636866 0.23122449887371 0.382582494783263 0.42477184929078
187973053.25 163619577.6 144795972.95 123283254
-12.96% -11.50% -14.86%

112725735.6 153633102 219138988.65 270187017.75 333086481.2

0.40 0.42 0.43 0.45 0.44

88515735.6 128788102 193503988.65 243842017.75 306111481.2

0.31 0.35 0.38 0.41 0.40
37777448.82 76986196.9 139891289.2175 188662416.8625 248293407.14
0.13 0.21 0.27 0.31 0.33
0.12649405264 0.231224498873705 0.38258249478326 0.42477184929078 0.47415908935358

et income

5666617.323 19246549.225 41967386.76525 66031845.901875 124146703.57

0.15 0.25 0.3 0.35 0.5

Profit Before Interest & Taxes 93,515,735.60 134788102 201003988.65

1.24687647466667 1.79717469333333 2.680053182

 53750000 53750000 53750000 53750000 53750000
0.70283625712 1.43230133767442 2.60262863660465 3.50999845325581 4.61941222586047

np new
37777448.82 70036128 125366960.9 160142676.1

82880000 82880000 82880000 82880000 82880000

46% 85% 151% 193% 265%
Total Current Assets 40000000.00 91300000.00 141000000.00
Total Current Liabilities 32973053.25 34969577.6 42495972.95
Inventory (Stock) 12000000 25000000 45000000 70000000
Inventory (inTrans 0 15000000 25000000 36000000
28000000.00 66300000.00 96000000.00

0.84917826043301 1.8959336815095 2.25903758252463

113211065 123141552 203669459 276415080 422558532
137% 149% 246% 334% 510%

82880000 82880000 82880000 82880000 82880000

32110831.497 52527096 87756872.63 104092739.465 109763423.7

114990831.497 135407096 170636872.63 186972739.465 192643423.7

Sales 281,814,339 365,793,100 509,625,555 600,415,595
29.80% 39.32% 17.82%
Sales Growth %
Interest Expense to Sales, % 0.27 0.21 0.15 0.12
39.32%

29.80%
26.08%

17.82%

1 2 3 4

Total Asset Growth

21.47%

17.90%

11.49%
9.82%

1 2 3 4

Total Liabilites Growth

21.47%

17.90%

11.49%
9.82%

1 2 3 4
1 2 3 4
523650000
17.90%
0.474159089353576
104790426.6
-15.00%

252342017.75 315111481.2

3.36456023666667 4.201486416
 219526847.4

236500000.00 333000000.00
47333254 55190426.6
85000000 6.033655119455
50000000
166500000.00 248000000.00

3.51761152951792 4.493532941816
757,014,730
26.08%

0.10
 Year-I

GROWTH RATIOS:
Sales Growth, Sales% -
Total Assets Growth, % -
Total Liabilities Growth, % -

PROFITABILITY RATIOS:

Gross Margin, Composite % 42.06%

Operating Profit Margin, % 33.03%
Interest Expense to Sales, % 5.14%
Net Margin, % 28.13%
Return on Assets, % 49.82%
Return on Equity , % 33.95%
Cash Withdrawal/Dividend Payout Rate, % 15.00%

COVERAGE RATIOS:
Debt Ser. Coverage(EBITDA/Total Interest +CMLT 5.76

LIQUIDITY RATIOS:

Quick Ratio (X) 0.70

Current Ratio (X) 1.21

LEVERAGE RATIOS:

Total Liabilities/ Net Worth (X) 0.84

Year - II Year - III Year-IV
% % %

25.35% 39.32% 17.82%

73.34% 11.73% 24.85%
1.77% 6.55% 3.95%

42.00% 43.00% 45.00%

34.53% 37.40% 40.05%
4.10% 2.94% 2.50%
30.47% 34.13% 37.02%
39.02% 54.51% 55.79%
46.10% 71.96% 91.94%
15.00% 15.00% 15.00%

7.82 12.21 15.60

1.47 1.67 2.76

2.61 3.32 5.00

0.41 0.33 0.26

Year-V

26.08%
20.16%
6.17%

44.00%
39.92%
1.98%
37.17%
58.78%
116.39%
15.00%

19.74

3.59
6.03

0.22
chart for Ratio
Year-I Year - II Year - III Year-IV Year-V
% % %
GROWTH RATIOS:
Sales Growth, Sales% - 25.35% 39.32% 17.82% 26.08%
Total Assets Growth, % - 73.34% 11.73% 24.85% 20.16%
Total Liabilities Growth, % - 1.77% 6.55% 3.95% 6.17%

PROFITABILITY RATIOS:

Gross Margin, Composite % 42.06% 42.00% 43.00% 45.00% 44.00%

Operating Profit Margin, % 33.03% 34.53% 37.40% 40.05% 39.92%
Interest Expense to Sales, % 5.14% 4.10% 2.94% 2.50% 1.98%
Net Margin, % 28.13% 30.47% 34.13% 37.02% 37.17%
Return on Assets, % 49.82% 39.02% 54.51% 55.79% 58.78%
Return on Equity , % 33.95% 46.10% 71.96% 91.94% 116.39%
Cash Withdrawal/Dividend Payou 15.00% 15.00% 15.00% 15.00% 15.00%
 COVERAGE RATIOS:
Debt Ser. Coverage(EBITDA/Tota 5.76 7.82 12.21 15.60 19.74

LIQUIDITY RATIOS:

Quick Ratio (X) 0.70 1.47 1.67 2.76 3.59

Current Ratio (X) 1.21 2.61 3.32 5.00 6.03

LEVERAGE RATIOS:

Total Liabilities/ Net Worth (X) 0.84 0.41 0.33 0.26 0.22
 Sales Growth, Sales%
45.00%
39.32%
40.00%
35.00% Total Assets Growth, %
30.00% 26.08%
25.35%
80.00%
25.00% 73.34%
20.00%
70.00% 17.82%
15.00% Total Liabilities Growth, %
60.00%
10.00%
7.00% 6.55%
5.00%
50.00% 6.17%
0.00% 6.00%
1
40.00% 2 3 4

5.00%
30.00% 24.85%
3.95% 20.16%
4.00%
20.00%
11.73%
10.00%
3.00%
0.00%1.77%
2.00% 1 2 3 4

1.00%

0.00%
1 2 3 4

Gross Margin, Composite %

46.00% 45.00%
45.00% 44.00%
44.00% Operating Profit
43.00%Margin, %
43.00%
42.06% 42.00%
50.00%
42.00%
41.00%
40.00% Interest Expense to Sales, %
40.00%
30.00%1 5.14%2
6.00% 3 4 5
20.00% 4.10%
10.00% 4.00% 2.94% 2.50% 1.98%
0.00%
1
2.00%
2 Net 3Margin, % 4 5
40.00% 0.00% 37.02% 37.17%
1 2 3 34.13%4 5
35.00% 30.47%
28.13%
30.00% Return on Assets, %
25.00%
20.00% 70.00%
15.00% 55.79% 58.78%
60.00% 54.51%
49.82%
10.00% 50.00%
5.00% 39.02% on Equity , %
Return
40.00%
0.00% 30.00%
1 2 140.00% 3 4 5
20.00% 116.39%
120.00%
10.00% 91.94%
100.00%
0.00% 71.96%
Cash Withdrawal/Dividend Payout
80.00%
1 2 3 4 Rate, % 5
60.00% 46.10%
15.00%
16.00% 33.95% 15.00% 15.00% 15.00% 15.00%
40.00%
14.00%
20.00%
12.00%
0.00%
10.00% 1 2 3 4 5
8.00%
6.00%
4.00%
2.00%
 100.00% 91.94%
71.96%
Cash Withdrawal/Dividend Payout Rate,
80.00% %
60.00% 46.10%
15.00%
16.00% 33.95% 15.00% 15.00% 15.00% 15.00%
40.00%
14.00%
20.00%
12.00%
0.00%
10.00% 1 2 3 4 5
8.00%
6.00%
4.00%
2.00%
0.00%
1 2 3 4 5

Debt Ser. Coverage(EBITDA/Total Interest +CMLTD)

25.00
19.74
20.00
15.60
15.00 12.21
10.00 7.82
5.76
5.00 Quick Ratio (X)
0.00 4.00
1 2 3 4 3.59 5
3.50
3.00 2.76
2.50 Current Ratio (X)
2.00 1.67
7.00
1.47 6.03
1.50 Total
6.00 Liabilities/ Net Worth5.00
(X)
1.000.70 5.00
0.90
0.84
0.50 4.00 3.32
0.80 - 3.00 2.61
1 21.21
2.00 3 4 5
0.70
1.00
0.60 0.00
1 2 3 4 5
0.50
0.41
0.40
0.33
0.30 0.26
0.22
0.20
0.10
0.00
1 2 3 4 5
e, %
15.00%
e, %
15.00%

5
Key Financial Under Existing Setup
Yearly Turnover 98,000,000.00
Yearly Expense 46,800,000.00
Gross profit 51,200,000.00