Currency

Foreign Currency Exchange Rate: Foreign Currency Units:

1 EURO = 130.37 ETB In EURO
Feberuary 08th 2025
1 USD = 125.70 ETB In USD

Financial Analysis
Projected Period 10 years
Working Time
Working Hours Per Day (Hr.) 8
Working Hours Per Weeek (Hr.) 48
Working Hours Per Month (Hr.) 224
Average Working Days Per Month (Days) 28
Working Days Per Year (Days) 336
Working Hours Per Year (Hr.) 2,688
Overtime (Hr/Days) 2
Regular Employee Allowances
Medical Allowance (ETB/Year) 9,500
Professional Allowance 30%
Responsibility Allowance
Deputy CEO (Engineer) 12,000
Department Manager 10,500
Team Leader 9,000
Advisor 11,000
Project Manager (Engineer) 11,000
Professional Allowance
Deputy CEO (Engineer) 75%
Department Manager 50%
Team Leader 40%
Advisor 50%
Project Manager (Engineer) 50%
Fuel Allowance
Deputy CEO (Engineer) 240
Department Manager 120
Team Leader 80
Advisor 180
Project Manager (Engineer) 120
Medical Allowance
Deputy CEO (Engineer) 3 month salary/year
Department Manager 3 month salary/year
Team Leader 3 month salary/year
Advisor 3 month salary/year
Project Manager (Engineer) 3 month salary/year
Perdiem & Traveling Expense
 Annual Perdiem & Traveling Expense 6%
Fuel
2/7/2025 white diesel per liter Fuel Price( ETB/birr) 122.54
Raw Material
Westage of Raw Material 5%
Rate of Electric Consumption
10 MW

Water Consumption
Water Supply 2
Other Costs
Consumables(oil, grease, tinner etc.) 0.70%
Uniform & Protective Safety wares (once in a year) 15,000
Oil & Lubricants 2.00%
Insurance 1.00%
Spare Parts (fast wearing parts) 0.50%
Service, Repair & Maintenance 0.50%
Marketing Advertizing & Promotion 0.50%
Stationary Items 0.75%
Sanitary Items 0.50%
Clinical Items 0.50%
Telephone, Postage & Internet 1.00%
Legal and Audit Fee 1.00%
Miscellaneous Expense 1.00%
Pre-Production cost
Electrical Installation Cost 500,000.00
Water Installation Cost 1,500,000.00
Machinery installation fee 2,000,000.00
Training Fee 2,500,000.00
Training Fee (local) 1,500,000.00
Licensing Fee and Others 350,000.00
Operatig Costs
Increase in Basic Salary 0.0% Every year
Increase in Fringe Benefit 0.0% Every year
Increase in Material Cost 0.0% Every year

Dividend, Profit Margin & Tax

Profit Margin 35%
Profit Tax 35%
Tax Free Privilege 0 Years
Dividend / Withdrawal 0%
 1,210,000.00

240 Lit/Month 29,409.60 birr

180 Lit/Month 14,704.80 birr
120 Lit/Month 9,803.20 birr
180 Lit/Month 22,057.20 birr
120 Lit/Month 14,704.80 birr
of regular salary & wage

borehole

of annual material cost

per person 14 210,000.00 210,000.00
annual fuel cost/year
machinery & equipment value
machinery & equipment value
total fixed asset value/year
of raw material cost
of raw material cost
of raw material cost
of raw material cost
utility cost/year
of raw material cost
of raw material cost

Lump Sum
Lump Sum
Lump Sum
Lump Sum
Lump Sum Installation, Testing, Commissioning & Training
Lump Sum
 Annual Man Power Cost
S/N Job Positions employee Monthly Annual Salary Overtime
salary (Birr) (Birr) Expense
1 General Manager Office
General Manager 1 65,000.00 780,000
Executive Secretary 1 12,000.00 144,000
Sub-total 2 77,000.00 924,000.00 -
2 Production and Engineering Department
Project Manager/Supervisor 1 38,000.00 456,000.00
3D Printer Operator 2 32,000.00 768,000.00
38,000.00 -
Material Mixers/Loaders 2 18,000.00 432,000.00
Civil Engineer 1 32,000.00 384,000.00
Safety & Quality Inspector 1 22,000.00 264,000.00
Maintenance/Electricians Technician 1 18,000.00 216,000.00
BIM/CAD Technician 1 22,000.00 216,000.00
Casual laborer 2 10,000.00 528,000.00
-
Sub-total 11 230,000.00 3,264,000.00 -
3 Procurment, Sales and Markting
Department
Department Head 1 38,000.00 456,000.00
Marketing Officer 1 22,000.00 264,000.00
Sales Officer 1 22,000.00 264,000.00
Purchasser 1 18,000.00 216,000.00
18,000.00 -
-
Sub-total 4 118,000.00 1200000 0
4 HR & Genral Administrative Department
Department Head 1 38,000.00 456,000.00
HRM Officer 1 22,000.00 264,000.00
Accountant 1 22,000.00 264,000.00
Casher 1 13,000.00 156,000.00
Property & Store Keeper 1 13,000.00 156,000.00
Driver 2 15,000.00 360,000.00
Cleaner 2 9,000.00 216,000.00
-
-
-
-

Sub-total 9 132,000.00 1,872,000.00 -

Grand Total 26.00 557,000.00 7,260,000.00 -
 Annual Employee Benefit
Perd. & Trav. Responsibility Professional Medical Fuel
Total cost
Expense Allowance Allowence Allowance Allowance

46,800.00 826,800.00 15,000.00 176,457.60

8,640.00 152,640.00 15,000.00
55,440.00 979,440.00 - - 30,000.00 176,457.60
- -
27,360.00 483,360.00 15,000.00 117,638.40
46,080.00 814,080.00 15,000.00
- -
25,920.00 457,920.00 15,000.00
23,040.00 407,040.00 15,000.00
15,840.00 279,840.00 15,000.00
12,960.00 228,960.00 15,000.00
12,960.00 228,960.00 15,000.00
31,680.00 559,680.00 15,000.00
- -
195,840.00 3,459,840.00 - - 90,000.00 117,638.40

- -
27,360.00 483,360.00 15,000.00 117,638.40
15,840.00 279,840.00 15,000.00
15,840.00 279,840.00 15,000.00
12,960.00 228,960.00 15,000.00
- - 15,000.00
- - 15,000.00
72000 1272000 - - 90,000.00 117,638.40
- -
27,360.00 483,360.00 15,000.00 117,638.40
15,840.00 279,840.00 15,000.00
15,840.00 279,840.00 15,000.00
9,360.00 165,360.00 15,000.00
9,360.00 165,360.00 15,000.00
21,600.00 381,600.00 15,000.00
12,960.00 228,960.00 15,000.00
- -
- -
- -
- -

112,320.00 1,984,320.00 - - 105,000.00 117,638.40

435,600.00 7,695,600.00 - - 315,000.00 529,372.80
 Annual Man Power Cost
S.N Title Direct Cost (ETB)
Total cost

- 1 Regular Salary & Wages 3,264,000.00

191,457.60 2 Overtime Expense -
15,000.00 3 Perd. & Trav. Expense 195,840.00
206,457.60 Sub Total 3,459,840.00
- 4 Employee Benefits

132,638.40 4.1 Responsibility Allowance -

- 4.2 Professional Allowence -

15,000.00 4.3 Medical Allowance 90,000.00
15,000.00 4.4 Fuel Allowance 117,638.40
15,000.00 Sub Total 207,638.40

15,000.00 Grand Total 3,667,478.40

15,000.00
-
207,638.40

-
132,638.40
15,000.00
15,000.00
15,000.00
15,000.00
15,000.00
207,638.40
-
132,638.40
15,000.00
15,000.00
15,000.00
15,000.00
15,000.00
15,000.00
-
-
-
-
-
-
-
-
222,638.40
844,372.80 ###
al Man Power Cost
Indirect Cost (ETB) Total Cost (ETB)

3,996,000.00 7,260,000.00
- -
239,760.00 435,600.00
4,235,760.00 7,695,600.00
-
- -

- -
225,000.00 315,000.00
411,734.40 529,372.80
636,734.40 844,372.80

4,872,494.40 8,539,972.80
 Machinery Cost 1 dollar= 133 ETB

Types of Equipment Specification Total Price (USD)

SOFTWARE
Rhino 3 D für Windows Grasshopper
16,800.00
TACO,ABB Software, BauMinator "Quick Design"
CONTROLS

IRC5,Typen,bezeichn
ABB Steuerungssystem
, included in roboter 256,000.00
BauMinator Steuerungssystem system appendix 2
ROBOTIC MACHINE PRINTER
IRB4600-
ABB 4600 - Capacity 40 kg customized Set-up 40/2,55,IRBT
(Bauminator) ABB Robot care / Connected Service Security
4004
Fencing - Light Service Spacing 647,000.00
Machine Stand 44,760.00
Rail System for 1 unit (First 1,9 Meter)
67,000.00
A,Additional Rail Meter (6)
MACHINES
Mixer - mortar pump 225,667.00
Watson
Accelerator Pump 23,580.00
Marlow
Accessories - Sundries - Hoses - LUMP SUM 22,800.00
BAUMINATOR NOZZLE
BauMintor Nozzles (Lease agreement) 143,280.00
BauMinator Know How/Technology inkl. Basis Support - 198,000.00
Wear & Spare Parts Starter Package 16,500.00
INSTALLATION BAUMINATOR SYSTEM
Set up at production site
106,000.00
fixed price for 4 back up printing nozzles.
DELIVERY & INSTALLATION MOBILE PLANT
Set up at production site
288,000.00
fixed price for 4 back up printing nozzles.
ADDITIONAL SERVICES
Training in Österreich / BauMinator Printing Specialist - 1
29,560.00
week / max. 3 people
Total required Equipment Cost 2,084,947.00
Exchange rate: 1 USD = 133 ETB, on 28 May 2025 at CBE
Total Price (ETB)

2,234,400.00

34,048,000.00

86,051,000.00
5,953,080.00

8,911,000.00

-
30,013,711.00

3,136,140.00

3,032,400.00
-
19,056,240.00
26,334,000.00
2,194,500.00
-

14,098,000.00

38,304,000.00

3,931,480.00

277,297,951.00
 Auxiliary & Workshop Equipment’s
S/N Description Unit Qty Unit Cost
1 Generator 100 kVA pcs 1 3,432,000.00
2 Air Compressor pcs 1 128,252.96
Total
Project site Tools & machine
1 Core Drilling machine pcs 2 5,940.00
Saws (different size according to site
2 pcs 2 7,524.00
arrangement)
3 Hammers pcs 2 1,424.00
4 Screwdrivers set 2 8,976.00
5 Wrenches set 2 6,600.00
Measuring Tools(Laser Levels and Tape
6 set 1 100,320.00
Measures
Total
Grand Total
VAT 15%
Total including Vat
t’s
Total Cost (Birr)
3,432,000.00
128,252.96
3,560,252.96

11,880.00

15,048.00

2,848.00
17,952.00
13,200.00

100,320.00

161,248.00
3,721,500.96
558,225.14
4,279,726.10
 List of Vehicles and Material Handling Equipment and their costs

S/n Nat Qty Unit Price

I Vehicles
1 Low Bed truck 9,495,398.00
2 Toyota HI-LUIX P/UP double cabin 5,015,175.00
3 Toyota coaster 7,244,186.00
4 Freight vehicles with 60 quintal capacity 7,774,591.00
5 Toyota HIACE Minibus 5,572,461.00
Total
Material production and Handling
II
Equipment
1 Forklifts 1 5,572,421.13
2 Moveable crane (car mounted) 1 11,768,944.00
Total (Birr)
Grand Total(Birr)
VAT(15%)
Grand total with Vat
ment and their costs

Total Price

-
-
-
-
-
-

5,572,421.13
11,768,944.00
17,341,365.13
17,341,365.13
2,601,204.77
19,942,569.90

4,500,000.00
 Office Furniture and Equipment

NO Office Furniture's Unit Quantity Unit cost Total cost

1 Managerial Executive Table PCS 1 77,000.00 77,000.00
2 Executive table PCS 1 71,500.00 71,500.00
3 Guest Chair Metal Leg/leather chair/ PCS 2 11,000.00 22,000.00
4 High Back Mesh Chair PCS 2 22,000.00 44,000.00
5 Medium back chair PCS 6 17,600.00 105,600.00
6 Conference Table 4.80m PCS 0 71,500.00 -
7 Office table PCS 4 13,200.00 52,800.00
8 4 in 1 workstation table PCS 1 27,500.00 27,500.00
9 Office secretary chair PCS 0 8,800.00 -
10 Modern office cabinet PCS 1 38,500.00 38,500.00
11
12
13
Total 438,900.00
VAT (15%) 65,835.00
Total-Office Furniture's 504,735.00
Office Equipment's Unit Quantity Unit cost Total cost
1 Laptop PCS 2 132,000.00 264,000.00
2 Desktop Computer PCS 6 165,000.00 990,000.00
3 Photocopy Machine PCS 1 385,000.00 385,000.00
4 Printer PCS 1 132,000.00 132,000.00
5
Total 1,771,000.00
VAT (15%) 265,650.00
Total-Office Equipment's 2,036,650.00
Grand Total-Fixed Asset Cost 2,541,385.00
 Cost of Sheds & Buildings/Factory Warehouse cost/

Space required in (M2) Rental per month Monthly amount

500 250.00 125,000.00
Yearly rental amount
1,500,000.00
 Element
Unit / Production Cost
Production
Discription measurement in including
capasity
m2 structural
(conc+rebar)
Core(Foundation,Column and Load bearing
wall) 1.00 12,290.53 27,561.77
Shell (three-dimensional solid structural
element withsmall thickness) 1.00 13,938.40 13,321.52
Shear wall 1.00 16,125.00 16,399.26
Partition wall 1.00 2,261.00 54,664.19
Facade 1.00 2,261.00 45,936.29
Slab 1.00 4,729.60 50,529.92
Column 1.00 6,564.19 10,060.05
Beam (grade beam,Floor beam and top tie
beam) 1.00 5,586.00 11,116.58
Total

Element
Unit / Production Cost
Production
Discription measurement including
capasity
in m2 structural
Core(Foundation,Column and Load bear 1.00 (conc+rebar)
12,290.53 19,008.00
Shell (three-dimensional solid structura 1.00 13,938.40 9,187.26
Shear wall 1.00 16,125.00 11,309.83
Partition wall 1.00 2,261.00 37,699.44
Facade 1.00 2,261.00 31,680.20
Slab 1.00 4,729.60 34,848.22
Column 1.00 6,564.19 6,937.96
Beam (grade beam,Floor beam and top t 1.00 5,586.00 7,666.61
Total 158,337.52

27,561.77 0.12
13,321.52 0.06
16,399.26 0.07
54,664.19 0.24
45,936.29 0.20
50,529.92 0.22
10,060.05 0.04
11,116.58 0.05
229,589.58 1.00
 Element
Production size
on Facing area annual man Annual rental Aanual estimated
Annual production cost
(except Manpowe Equpment cost matarial cost
Columns on 2
side projection)
7.50 45,166,508.03

7.50 24,757,430.87
7.50 35,258,399.39
7.50 16,479,429.67
7.50 13,848,260.23
11.60 20,602,267.66
2.80 23,584,321.06

4.86 12,777,207.42 19,011,685 50,000,000 123,462,139.32

192,473,824.32 19,011,685 50,000,000 123,462,139.32

Element
Production
size on Facing
Annual production annual man Annual rental Aanual estimated
area (except
cost Manpowe Equpment cost matarial cost
Columns on 2
side 7.50 31,149,119.23 2,471,519.05 6,500,000.00 22,177,600.18
projection)
7.50 17,074,090.25 2,471,519.05 6,500,000.00 8,102,571.20
7.50 24,316,137.51 2,471,519.05 6,500,000.00 15,344,618.46
7.50 11,365,123.91 2,471,519.05 6,500,000.00 2,393,604.86
7.50 9,550,524.29 2,471,519.05 6,500,000.00 579,005.24
11.60 14,208,460.46 2,851,752.75 7,500,000.00 3,856,707.71
2.80 16,265,049.01 1,711,051.65 4,500,000.00 10,053,997.36
4.86 8,811,867.19 2,091,285.35 5,500,000.00 1,220,581.84
132,740,371.85 19,011,685.00 50,000,000.00 63,728,686.85
 Remark

Annual renatal
equpiment cost
is for
estimated and
lupsum

Remark

Annual
renatal
equpiment
cost is for
estimated and
lupsum
 Fuel Cost

Fuel
Km/Hr per
Sr. No. Types of Vehicles/Machine Qty Consumption
Year
(Ltr/KM/HR)
1 Low Bed truck 0 30,000 0.13
2 Toyota HI-LUIX P/UP double cabin 0 30,000 0.13
3 Toyota coaster 0 74,000 0.25
4 Freight vehicles with 60 quintal capaci 0 30,000 0.13
6 Forklifts 1 30,000 0.25
7 Moveable crane (car mounted) 1 15,000 0.25

Sub-total
Oil & lubricants 10% of fuel cost
Total Fuel, Oil & Lubricant Cost
 Total Fuel Fuel cost Total Cost of
Requirement per liter Fuel

0 122.53 -
0 122.53 -
0 122.53 -
0 122.53 -
7,500 122.53 918,975.00
3,750 122.53 459,487.50
0 122.53 -
1,378,462.50
137,846.25
t 1,516,308.75
 Utility Cost

Description Daily Power consuMonthly Power consuCost/Kwh Demand char Service Char Estimated monthly
Total Cost per annum
Electricity for produ 1,008.00 28,224.00 1.39 147.54 55.19 39,434.09 473,209.08
 Estimated
Daily water Monthly water
monthly water Total Cost per
Description consumption consumption Cost/m 3
consumption annum (Birr)
l Cost per annum (m3) (m3)
(birr)
Water 40.00 1,120.00 30 33,600.00 403,200.00
Total Utility Cost 876,409.08

100
 Service Life of Asset Initial Value of Asset Salvage Value of
(Years) (ETB) Asset (ETB)

Building 20 -
Main machine 10 277,297,951.00 96,687,817.00
auxilary 10 4,279,726.10 1,492,248.22
Vehicles 10 19,942,570 6,953,544.16
Office Furniture's 5 504,735 298,040.97
Office Equipment's 5 2,036,650 1,202,621.46
Total Depreciation Cost 304,061,632.00 106,634,271.81
Year -0 Remaining Book Value
Remaining Book Value

MACHINE Book V Deprec expense 10% N.B.Value

Building - -
Main machine 180,610,134.00 18,061,013.40
auxilary 2,787,477.88 278,747.79
Vehicles 12,989,025.74 1,298,902.57
Office Furniture's 206,694.03 41,338.81
Office Equipment's 834,028.54 166,805.71
 Depreciation of Fixed Assets
Amount Depreciated @
End of Service Life Period (Years)
(ETB) Year-0 Year-1 Year-2 Year-3 Year-4

- - - - -
180,610,134.00 18,061,013.40 18,061,013.40 18,061,013.40 18,061,013.40
2,787,477.88 278,747.79 278,747.79 278,747.79 278,747.79
12,989,025.74 1,298,902.57 1,298,902.57 1,298,902.57 1,298,902.57
206,694.03 41,338.81 41,338.81 41,338.81 41,338.81
834,028.54 166,805.71 166,805.71 166,805.71 166,805.71
197,427,360.19 304,061,632.00 19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28

304,061,632.00 284,214,823.73 264,368,015.45 244,521,207.17 224,674,398.90

Period (Years)
Year-5 Year-6 Year-7 Year-8 Year-9 Year-10

- - - - - -
18,061,013.40 18,061,013.40 18,061,013.40 18,061,013.40 18,061,013.40 18,061,013.40
278,747.79 278,747.79 278,747.79 278,747.79 278,747.79 278,747.79
1,298,902.57 1,298,902.57 1,298,902.57 1,298,902.57 1,298,902.57 1,298,902.57
41,338.81 41,338.81 41,338.81 41,338.81 41,338.81 41,338.81
166,805.71 166,805.71 166,805.71 166,805.71 166,805.71 166,805.71
19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28
(1,040,722.57)
204,827,590.62 183,940,059.77 164,093,251.50 144,246,443.22 124,399,634.95 104,552,826.67
 Operating Costs

Project Years
Description
Cost Type Full Capicty 1 2 3 4 5 6 7 8 9 10
65% 75% 80% 80% 80% 80% 80% 80% 80% 80%
Direct Cost
Raw Material-Local
Raw Matrial cost Variable 123,462,139.32 80,250,390.56 92,596,604.49 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46
Sub-total 123,462,139.32 80,250,390.56 92,596,604.49 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46 98,769,711.46
Direct Man power fixed 3,667,478.40 3,667,478.40 3,667,478.40 3,667,478.40 3,667,478.40 3,667,478.40 3,667,478.40 3,667,478.40 3,667,478.40 3,667,478.40 3,667,478.40
Utility Expense/electric & water/ Variable 876,409.08 569,665.90 657,306.81 701,127.26 701,127.26 701,127.26 701,127.26 701,127.26 701,127.26 701,127.26 701,127.26
Transportation cost Variable - - - - - - - - - - -
Sub-total 4,543,887.48 4,237,144.30 4,324,785.21 4,368,605.66 4,368,605.66 4,368,605.66 4,368,605.66 4,368,605.66 4,368,605.66 4,368,605.66 4,368,605.66
Total of direct cost 128,006,026.80 84,487,534.86 96,921,389.70 103,138,317.12 103,138,317.12 103,138,317.12 103,138,317.12 103,138,317.12 103,138,317.12 103,138,317.12 103,138,317.12
Indirect cost
Indirect man power Wages and Salaries fixed 4,872,494.40 4,872,494.40 4,872,494.40 4,872,494.40 4,872,494.40 4,872,494.40 4,872,494.40 4,872,494.40 4,872,494.40 4,872,494.40 4,872,494.40
Office Supply
Stationary Items fixed 477,965.15 477,965.15 477,965.15 477,965.15 477,965.15 477,965.15 477,965.15 477,965.15 477,965.15 477,965.15 477,965.15
Sanitary Items fixed 318,643.43 318,643.43 318,643.43 318,643.43 318,643.43 318,643.43 318,643.43 318,643.43 318,643.43 318,643.43 318,643.43
Clinical Items fixed - - - - - - - - - - -
Sub-total 5,669,102.99 5,669,102.99 5,669,102.99 5,669,102.99 5,669,102.99 5,669,102.99 5,669,102.99 5,669,102.99 5,669,102.99 5,669,102.99 5,669,102.99
Other cost
factory rent or lease expenses fixed 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00
Professional Expense (Legal and Audit Fee,
fixed - - - - - - - - - - -
consultancy)
Uniform and Clothing fixed 240,000.00 240,000.00 240,000.00 240,000.00 240,000.00 240,000.00 240,000.00 240,000.00 240,000.00 240,000.00 240,000.00
Telephone and Fax Expense fixed 105,169.09 105,169.09 105,169.09 105,169.09 105,169.09 105,169.09 105,169.09 105,169.09 105,169.09 105,169.09 105,169.09
Fuel, Oil and Lubricants Variable 1,516,308.75 985,600.69 1,137,231.56 1,213,047.00 1,213,047.00 1,213,047.00 1,213,047.00 1,213,047.00 1,213,047.00 1,213,047.00 1,213,047.00
Miscellaneous expenses fixed 637,286.87 637,286.87 637,286.87 637,286.87 637,286.87 637,286.87 637,286.87 637,286.87 637,286.87 637,286.87 637,286.87
Spare part Variable 1,386,489.76 901,218.34 1,039,867.32 1,109,191.80 1,109,191.80 1,109,191.80 1,109,191.80 1,109,191.80 1,109,191.80 1,109,191.80 1,109,191.80
Service, Repair & Maintenance Variable 1,721,216.40 1,118,790.66 1,290,912.30 1,376,973.12 1,376,973.12 1,376,973.12 1,376,973.12 1,376,973.12 1,376,973.12 1,376,973.12 1,376,973.12
Marketing Advertising & Promotion fixed - - - - - - - - - - -
Insurance fixed 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51
Sub-total of other cost 9,879,450.37 8,261,045.15 8,723,446.64 8,954,647.39 8,954,647.39 8,954,647.39 8,954,647.39 8,954,647.39 8,954,647.39 8,954,647.39 8,954,647.39
Total of indirect cost 15,548,553.36 13,930,148.14 14,392,549.63 14,623,750.38 14,623,750.38 14,623,750.38 14,623,750.38 14,623,750.38 14,623,750.38 14,623,750.38 14,623,750.38
Total operating cost l (DC+IC) 143,554,580.16 98,417,683.00 111,313,939.33 117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49

Variable Cost 128,962,563.30

Fixed Cost 14,592,016.85
total cost 143,554,580.16
 Working Capital Requirement

Description
Coverage 0 1 2
Direct Cost
Raw Material-Local
Raw Matrial cost 3 20,062,597.64 23,149,151.12 24,692,427.86
Sub-total 20,062,597.64 23,149,151.12 24,692,427.86
Direct Man power 3 916,869.60 916,869.60 916,869.60
Utility Expense/electric & water/ 3 142,416.48 164,326.70 175,281.82
Transportation cost 3 - - -
Sub-total 1,059,286.08 1,081,196.30 1,092,151.42
Total direct cost 21,121,883.71 24,230,347.42 25,784,579.28
Indirect cost
Indirect man power Wages and Salaries 3 1,218,123.60 1,218,123.60 1,218,123.60
Office Supply
Stationary Items 3 119,491.29 119,491.29 119,491.29
Sanitary Items 3 79,660.86 79,660.86 79,660.86
Clinical Items 3 - - -
Sub-total 1,417,275.75 1,417,275.75 1,417,275.75
Other cost
Factory rent or lease expenses 12 1,500,000.00 1,500,000.00 1,500,000.00
Professional Expense (Legal and Audit Fee,
12 - - -
consultancy)
Uniform and Clothing 12 240,000.00 240,000.00 240,000.00
Telephone and Fax Expense 3 26,292.27 26,292.27 26,292.27
Fuel, Oil and Lubricants 3 246,400.17 284,307.89 303,261.75
Miscellaneous expenses 3 159,321.72 159,321.72 159,321.72
Spare part 3 225,304.59 259,966.83 277,297.95
Service, Repair & Maintenance 3 279,697.66 322,728.07 344,243.28
Marketing Advertising & Promotion 12 - - -
Insurance 12 2,772,979.51 2,772,979.51 2,772,979.51
Sub-total of other cost 5,449,995.92 5,565,596.29 5,623,396.48
Total of indirect cost 6,867,271.67 6,982,872.04 7,040,672.23
Total Working Capital Requirement 27,989,155.38 31,213,219.46 32,825,251.51
Increase in Working Capital 3,224,064.08 1,612,032.04

Proposed Working Capital Requirement

27,989,155.38

Cash 7,015,700.84 7,080,641.48 7,113,111.79

Inventory 20,973,454.54 24,132,577.99 25,712,139.71
 Project Years
3 4 5 6 7 8

24,692,427.86 24,692,427.86 24,692,427.86 24,692,427.86 24,692,427.86 24,692,427.86

24,692,427.86 24,692,427.86 24,692,427.86 24,692,427.86 24,692,427.86 24,692,427.86
916,869.60 916,869.60 916,869.60 916,869.60 916,869.60 916,869.60
175,281.82 175,281.82 175,281.82 175,281.82 175,281.82 175,281.82
- - - - - -
1,092,151.42 1,092,151.42 1,092,151.42 1,092,151.42 1,092,151.42 1,092,151.42
25,784,579.28 25,784,579.28 25,784,579.28 25,784,579.28 25,784,579.28 25,784,579.28

1,218,123.60 1,218,123.60 1,218,123.60 1,218,123.60 1,218,123.60 1,218,123.60

119,491.29 119,491.29 119,491.29 119,491.29 119,491.29 119,491.29

79,660.86 79,660.86 79,660.86 79,660.86 79,660.86 79,660.86
- - - - - -
1,417,275.75 1,417,275.75 1,417,275.75 1,417,275.75 1,417,275.75 1,417,275.75

1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00

- - - - - -

240,000.00 240,000.00 240,000.00 240,000.00 240,000.00 240,000.00

26,292.27 26,292.27 26,292.27 26,292.27 26,292.27 26,292.27
303,261.75 303,261.75 303,261.75 303,261.75 303,261.75 303,261.75
159,321.72 159,321.72 159,321.72 159,321.72 159,321.72 159,321.72
277,297.95 277,297.95 277,297.95 277,297.95 277,297.95 277,297.95
344,243.28 344,243.28 344,243.28 344,243.28 344,243.28 344,243.28
- - - - - -
2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51 2,772,979.51
5,623,396.48 5,623,396.48 5,623,396.48 5,623,396.48 5,623,396.48 5,623,396.48
7,040,672.23 7,040,672.23 7,040,672.23 7,040,672.23 7,040,672.23 7,040,672.23
32,825,251.51 32,825,251.51 32,825,251.51 32,825,251.51 32,825,251.51 32,825,251.51
- - - - - -

7,113,111.79 7,113,111.79 7,113,111.79 7,113,111.79 7,113,111.79 7,113,111.79

25,712,139.71 25,712,139.71 25,712,139.71 25,712,139.71 25,712,139.71 25,712,139.71
 9 10

24,692,427.86 24,692,427.86
24,692,427.86 24,692,427.86
916,869.60 916,869.60
175,281.82 175,281.82
- -
1,092,151.42 1,092,151.42
25,784,579.28 25,784,579.28

1,218,123.60 1,218,123.60

119,491.29 119,491.29
79,660.86 79,660.86
- -
1,417,275.75 1,417,275.75

1,500,000.00 1,500,000.00

- -

240,000.00 240,000.00
26,292.27 26,292.27
303,261.75 303,261.75
159,321.72 159,321.72
277,297.95 277,297.95
344,243.28 344,243.28
- -
2,772,979.51 2,772,979.51
5,623,396.48 5,623,396.48
7,040,672.23 7,040,672.23
32,825,251.51 32,825,251.51
- -

7,113,111.79 7,113,111.79
25,712,139.71 25,712,139.71
 Fixed Cost

Description Unit Qty

Cost of Sheds & Buildings No 1
sub total
Factory Machinery's, Equipment's & Tools No 1
sub total
Vehicles
Low Bed truck No 0
Toyota HI-LUIX P/UP double cabin No 0
Toyota coaster No 0
Freight vehicles with 60 quintal capacity No 0
Toyota HIACE Minibus No 0
Forklifts No 1
Tower crane No 1
total OF VEHICLE
VAT (15%)
sub total
equipments
Generator ( >200KVA) Set 1
Air Compressor No 1
total of equipment
VAT (15%)
sub total
Office Furniture's
Managerial Executive Table PCS 1
Executive table PCS 1
L-Shape Tabel 1.5m PCS 2
Guest Chair Metal Leg/leather chair/ PCS 2
High Back M.Chair PCS 6
Medium back chair PCS 0
Conference Tabel 4.80 PCS 4
Office table PCS 1
4 in 1 warkstation table PCS 0
office seceratery chair PCS 1
Guest Chair /3 sitter/ PCS 0
File Cabinet 4 Drawer Wooden PCS 0
modern office cabinet/metal/ PCS 0
Total-Office Furniture's
VAT (15%)
sub total
Office Equipment's
Laptop PCS 2
Desktop Computer PCS 6
Photocopy Machine PCS 1
Scanner PCS 1
Printer PCS 0
Total-Office Equipment's
VAT (15%)
sub total
Total Value of Fixed Assets
Unit price Total price
- -
-
277,297,951.00 277,297,951.00
277,297,951.00

9,495,398.00 9,495,398.00
5,015,175.00 5,015,175.00
7,244,186.00 7,244,186.00
7,774,591.00 7,774,591.00
5,572,461.00 5,572,461.00
5,572,421.13 5,572,421.13
11,768,944.00 11,768,944.00
52,443,176.13
7,866,476.42
60,309,652.55

3,432,000.00 3,432,000.00
128,252.96 128,252.96
3,560,252.96
534,037.94
4,094,290.90

77,000.00 77,000.00
71,500.00 71,500.00
11,000.00 22,000.00
22,000.00 44,000.00
17,600.00 105,600.00
71,500.00 -
13,200.00 52,800.00
27,500.00 27,500.00
8,800.00 -
38,500.00 38,500.00
- -
- -
- -
438,900.00
65,835.00
504,735.00

132,000.00 264,000.00
165,000.00 990,000.00
385,000.00 385,000.00
132,000.00 132,000.00
- -
1,771,000.00
265,650.00
2,036,650.00
344,243,279.45
 Pre-Production Cost

No. Description Annual cost in birr

1 Electrical Installation Cost 1,000,000.00
2 Water Installation Cost 800,000.00
3 Machinery installation fee
5 Training Fee (local)
6 Licensing Fee and Others 500,000.00
Total Sum 2,300,000.00
7 Pre-Production Intrest 25,915,290.70
Total Sum 28,215,290.70
 Remark
Lump sum
Lump sum
Lump sum
Lump sum
Lump sum
 Invstment Cost

Total Cost
Cost Item
(Birr)
Fixed Asset Cost

Building -
Factory Machineries Equipment & Tools 277,297,951.00
Auxiliary 4,279,726.10
Vehicles 19,942,569.90
Office Furniture 438,900.00
Office Equipment 1,771,000.00
Sub-total 303,730,147.00
Pre-Production Capital Expenditure

Pre-production Cost 2,300,000.00

Pre-production Interest 25,915,290.70 25,915,290.70
Sub-total 28,215,290.70
Working Capital

Working Capital 27,989,155.38

Sub-total 27,989,155.38
Grand total 359,934,593.09

Amount Percentage
ECWC Contribution 143,973,837.23 40%
Bank Loan Contribution 215,960,755.85 60%
Total 359,934,593.09 100%
Description Amount Coverage (%)
Fixed assets 303,730,147.00 84.38%
Working capital 27,989,155.38 7.78%
Pre-operating costs 2,300,000.00 0.64%
Pre-operating interest 25,915,290.70 7.20%
Total 359,934,593.09 100.00%
 DESCRIPTION
- 1
Loan Requirement 215,960,755.9
Beginning Balance 215,960,755.9 215,960,755.9
Interest to be paid 25,915,290.7 25,915,290.7
Interest rate 12.0% 12.0%
Loan Repayment
Interest 25,915,290.7 25,915,290.7
18 Principal 12,306,343.2
8.5 Total 38,221,633.9
13.25 Ending Balance 215,960,755.9 203,654,412.7

amount borrowed 215,960,756 0.12000

period 10
rate 0.1200
payment 38,221,634

Year Beginning Balance

0 Year-1 215,960,756
Year-2 203,654,413
Year-3 189,871,308
Year-4 174,434,231
Year-5 157,144,705
Year-6 137,780,436
Year-7 116,092,455
Year-8 91,801,915
Year-9 64,596,511
Year-10 34,126,459

10

$38,221,633.87
 Loan Repayment Schedule
Project Years
2 3 4 5 6

203,654,412.7 189,871,308.3 174,434,231.5 157,144,705.4 137,780,436.2

24,438,529.5 22,784,557.0 20,932,107.8 18,857,364.6 16,533,652.3
12.0% 12.0% 12.0% 12.0% 12.0%

24,438,529.5 22,784,557.0 20,932,107.8 18,857,364.6 16,533,652.3

13,783,104.3 15,437,076.9 17,289,526.1 19,364,269.2 21,687,981.5
38,221,633.9 38,221,633.9 38,221,633.9 38,221,633.9 38,221,633.9
189,871,308.3 174,434,231.5 157,144,705.4 137,780,436.2 116,092,454.6

12.00

PMT Interest Principle Ending Balance

38,221,634 25,915,291 12,306,343 203,654,413
38,221,634 24,438,530 13,783,104 189,871,308
38,221,634 22,784,557 15,437,077 174,434,231
38,221,634 20,932,108 17,289,526 157,144,705
38,221,634 18,857,365 19,364,269 137,780,436
38,221,634 16,533,652 21,687,982 116,092,455
38,221,634 13,931,095 24,290,539 91,801,915
38,221,634 11,016,230 27,205,404 64,596,511
38,221,634 7,751,581 30,470,053 34,126,459
38,221,634 4,095,175 34,126,459 0
 7 8 9 10

116,092,454.6 91,801,915.3 64,596,511.3 34,126,458.8

13,931,094.6 11,016,229.8 7,751,581.4 4,095,175.1
12.0% 12.0% 12.0% 12.0%

13,931,094.6 11,016,229.8 7,751,581.4 4,095,175.1 70

24,290,539.3 27,205,404.0 30,470,052.5 34,126,458.8 30
38,221,633.9 38,221,633.9 38,221,633.9 38,221,633.9
91,801,915.3 64,596,511.3 34,126,458.8 -
 Annual Production @
Maximum Utilization
S/N Elements Capacity (m²)
1 Core 27,561.77
2 Shell 13,321.52
3 Shear wall 16,399.26
4 Partition wall 54,664.19
5 Facade 45,936.29
6 Slab 50,529.92
7 Column 10,060.05
8 Beam (grade beam, Floor beam and 11,116.58
Discription Unit / measuremeElement Unit SelliProduction capasity Element Production size on Facing area (ex
Core(Foundation, 1 16,859.48 27,561.77 7.5
Shell (three-dime 1 19,001.71 13,321.52 7.5
Shear wall 1 21,844.29 16,399.26 7.5
Partition wall 1 3,821.09 54,664.19 7.5
Facade 1 3,821.09 45,936.29 7.5
Slab 1 7,030.27 50,529.92 11.6
Column 1 9,415.24 10,060.05 2.8
Beam (grade beam 1 8,143.59 11,116.58 4.86
Total

Year 1 2 3 4
capacity 65% 75% 80% 80%
revenue 180,573,139.81 208,353,622.86 222,243,864.38 222,243,864.38
Production size on Facing area (except Columns on 2 side projection)
61,956,953.33
33,750,898.36
47,764,012.48
27,850,236.14
23,403,559.78
30,624,049.45
33,827,777.84
18,627,343.10
277,804,830.48

5 6 7 8 9 10
80% 80% 80% 80% 80% 80%
222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38
 Projected Profit an
65% 75% 80%
Description
1 2 3
Revenue 180,573,139.81 208,353,622.86 222,243,864.38
Total Operating Cost 98,417,683.00 111,313,939.33 117,762,067.49
Profit Before Depr, Interest and tax 82,155,456.81 97,039,683.53 104,481,796.89
Depreciation and Amort. 19,846,808.28 19,846,808.28 19,846,808.28
Profit Before Interest and tax 62,308,648.53 77,192,875.25 84,634,988.61
Interest Expense 25,915,290.70 24,438,529.52 22,784,557.00
Profit Before tax 36,393,357.83 52,754,345.73 61,850,431.61
Profit tax (30%) 10,918,007.35 15,826,303.72 18,555,129.48
Net Profit/Loss 25,475,350.48 36,928,042.01 43,295,302.13

Dividend (30%)2 7,642,605.14 11,078,412.60 12,988,590.64

Retained Earning 33,117,955.63 48,006,454.61 56,283,892.76
Cumulative Retained Earning 33,117,955.63 81,124,410.24 137,408,303.00

19,509,775.50
Projected Profit and Loss Statement
80% 80% 80% 80% 80%
Project Years
4 5 6 7 8
222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38
117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49
104,481,796.89 104,481,796.89 104,481,796.89 104,481,796.89 104,481,796.89
19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28
84,634,988.61 84,634,988.61 84,634,988.61 84,634,988.61 84,634,988.61
20,932,107.78 18,857,364.65 16,533,652.34 13,931,094.56 11,016,229.84
63,702,880.83 65,777,623.96 68,101,336.27 70,703,894.05 73,618,758.77
19,110,864.25 19,733,287.19 20,430,400.88 21,211,168.22 22,085,627.63
44,592,016.58 46,044,336.77 47,670,935.39 49,492,725.84 51,533,131.14

13,377,604.97 13,813,301.03 14,301,280.62 14,847,817.75 15,459,939.34

57,969,621.56 59,857,637.81 61,972,216.01 64,340,543.59 66,993,070.48
195,377,924.56 255,235,562.37 317,207,778.37 381,548,321.96 448,541,392.44
 80% 80%

9 10
222,243,864.38 222,243,864.38
117,762,067.49 117,762,067.49
104,481,796.89 104,481,796.89
19,846,808.28 19,846,808.28
84,634,988.61 84,634,988.61
7,751,581.36 4,095,175.06
76,883,407.25 80,539,813.55
23,065,022.18 24,161,944.07 19,110,864.25
53,818,385.08 56,377,869.49

16,145,515.52 16,913,360.85
69,963,900.60 73,291,230.33
518,505,293.04 591,796,523.38
 Projected Cash Flow Statement

Description
0 1 2 3
Cash Inflows
Owner's Equity 143,973,837.23
DBE Loan 215,960,755.85
Net Profit 25,475,350.48 36,928,042.01 43,295,302.13
Depreciation 19,846,808.28 19,846,808.28 19,846,808.28
Total Cash Inflows 359,934,593.09 45,322,158.76 56,774,850.29 63,142,110.40
Cash out Flows
Fixed assets 303,730,147.00
Working capital 27,989,155.38
Increase In working Capital 3,224,064.08 1,612,032.04 -
Pre-Production Cost 2,300,000.00
Pre-Production Interest 25,915,290.70
Loan Repayment 12,306,343.16 13,783,104.34 15,437,076.86
Dividends 7,642,605.14 11,078,412.60 12,988,590.64
Replacement
Total Cash Outflows 359,934,593.09 23,173,012.39 26,473,548.99 28,425,667.50
Net Cash Flow 22,149,146.37 30,301,301.30 34,716,442.90
Cumulative Cash Balance 22,149,146.37 52,450,447.67 87,166,890.57
 Project Years
4 5 6 7 8 9

44,592,016.58 46,044,336.77 47,670,935.39 49,492,725.84 51,533,131.14 53,818,385.08

19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28 19,846,808.28
64,438,824.86 65,891,145.05 67,517,743.66 69,339,534.11 71,379,939.41 73,665,193.35

- - - - - -

17,289,526.09 19,364,269.22 21,687,981.52 24,290,539.31 27,205,404.02 30,470,052.51

13,377,604.97 13,813,301.03 14,301,280.62 14,847,817.75 15,459,939.34 16,145,515.52
(1,040,722.57)
30,667,131.06 32,136,847.68 35,989,262.14 39,138,357.06 42,665,343.37 46,615,568.03
33,771,693.80 33,754,297.37 31,528,481.52 30,201,177.05 28,714,596.05 27,049,625.32
120,938,584.36 154,692,881.73 186,221,363.26 216,422,540.31 245,137,136.36 272,186,761.68
 10

56,377,869.49
19,846,808.28
76,224,677.76

34,126,458.81
16,913,360.85

51,039,819.66
25,184,858.11
297,371,619.79
 P
DESCRIPTION
0 1 2
ASSETS
CURRENT ASSETS
Cash 7,015,700.8 22,149,146.4 52,450,447.7

Inventory 20,973,454.5 31,213,219.5 32,825,251.5

Total Current Assets 27,989,155.4 53,362,365.8 85,275,699.2
FIXED ASSETS
Building cost - - -
Main machine 277,297,951.0 295,358,964.4 313,419,977.8
Auxilary 4,279,726.1 4,558,473.9 4,837,221.7
Vehicles 19,942,569.9 21,241,472.5 22,540,375.0
Office Furniture 504,735.0 546,073.8 587,412.6
Office Equipment 2,036,650.0 2,203,455.7 2,370,261.4
Sub-total 304,061,632.0 323,908,440.3 343,755,248.6
Pre-production Cost 2,300,000.0 2,300,000.0 2,300,000.0
Pre-production Interest 25,915,290.7 25,915,290.7 25,915,290.7
Sub-total 28,215,290.7 28,215,290.7 28,215,290.7
Total Assets 360,266,078.1 405,486,096.8 457,246,238.4
LIABILITIES & Capital
DBE long term Loan 215,960,755.9 203,654,412.7 189,871,308.3
Sub-total 215,960,755.9 203,654,412.7 189,871,308.3
CAPITAL
Owner's Equity 143,973,837.2 143,973,837.2 143,973,837.2
Retained earning - 33,117,955.6 48,006,454.6
Sub-total 143,973,837.2 177,091,792.9 191,980,291.8
Total Liabilities and Capital 359,934,593.1 380,746,205.6 381,851,600.2
 Projected Balance Sheet Statement
Project years
3 4 5 6 7

87,166,890.6 120,938,584.4 154,692,881.7 186,221,363.3 216,422,540.3

32,825,251.5 32,825,251.5 32,825,251.5 32,825,251.5 32,825,251.5

119,992,142.1 153,763,835.9 187,518,133.2 219,046,614.8 249,247,791.8

- - - - -
331,480,991.2 349,542,004.6 367,603,018.0 385,664,031.4 403,725,044.8
5,115,969.5 5,394,717.3 5,673,465.0 5,952,212.8 6,230,960.6
23,839,277.6 25,138,180.2 26,437,082.8 27,735,985.3 29,034,887.9
628,751.4 670,090.2 504,735.0 546,073.8 587,412.6
2,537,067.1 2,703,872.8 2,036,650.0 2,203,455.7 2,370,261.4
363,602,056.8 383,448,865.1 402,254,950.8 422,101,759.1 441,948,567.4
2,300,000.0 2,300,000.0 2,300,000.0 2,300,000.0 2,300,000.0
25,915,290.7 25,915,290.7 25,915,290.7 25,915,290.7 25,915,290.7
28,215,290.7 28,215,290.7 28,215,290.7 28,215,290.7 28,215,290.7
511,809,489.6 565,427,991.7 617,988,374.8 669,363,664.6 719,411,649.9

174,434,231.5 157,144,705.4 137,780,436.2 116,092,454.6 91,801,915.3

174,434,231.5 157,144,705.4 137,780,436.2 116,092,454.6 91,801,915.3

143,973,837.2 143,973,837.2 143,973,837.2 143,973,837.2 143,973,837.2

56,283,892.8 57,969,621.6 59,857,637.8 61,972,216.0 64,340,543.6
200,257,730.0 201,943,458.8 203,831,475.0 205,946,053.2 208,314,380.8
374,691,961.5 359,088,164.2 341,611,911.2 322,038,507.9 300,116,296.2
 8 9 10

245,137,136.4 272,186,761.7 297,371,619.8

32,825,251.5 32,825,251.5 32,825,251.5

277,962,387.9 305,012,013.2 330,196,871.3

- - -
421,786,058.2 439,847,071.6
6,509,708.4 6,788,456.2
30,333,790.5 31,632,693.1
628,751.4 670,090.2
2,537,067.1 2,703,872.8
461,795,375.6 481,642,183.9 -
2,300,000.0 2,300,000.0 2,300,000.0
25,915,290.7 25,915,290.7 25,915,290.7
28,215,290.7 28,215,290.7 28,215,290.7
767,973,054.2 814,869,487.8 358,412,162.0

64,596,511.3 34,126,458.8 -
64,596,511.3 34,126,458.8 -

143,973,837.2 143,973,837.2 143,973,837.2

66,993,070.5 69,963,900.6 73,291,230.3
210,966,907.7 213,937,737.8 217,265,067.6
275,563,419.0 248,064,196.6 217,265,067.6
 Calculation of Financial Internal Rate of Return

Description
Year-0 Year-1 Year-2 Year-3

Revenue 180,573,140 208,353,623 222,243,864

Working Capital Rec.
Fixed Asset Recovery
Total Benefits 180,573,140 208,353,623 222,243,864
Initial Investment (359,934,593.09)
Replacement Costs
Operating Costs (98,417,683.00) (111,313,939.33) (117,762,067.49)
Total Costs (359,934,593.09) (98,417,683.00) (111,313,939.33) (117,762,067.49)
Income Tax (10,918,007.35) (15,826,303.72) (18,555,129.48)
Total Cost Inc. Income Tax
(359,934,593.09) (109,335,690.35) (127,140,243.05) (136,317,196.98)

Net Benefit Before Tax (359,934,593.09) 82,155,456.81 97,039,683.53 104,481,796.89

Net Benefit After Tax (359,934,593.09) 71,237,449.46 81,213,379.81 85,926,667.40

Description NPV @15% IRR

Before Tax $150,089,216.73 25.38%

After Tax $70,998,512.23 20.12%

Annual Discounting Rate 15%

 Period (Years)
Year-4 Year-5 Year-6 Year-7 Year-8

222,243,864 222,243,864 222,243,864 222,243,864 222,243,864

222,243,864 222,243,864 222,243,864 222,243,864 222,243,864

(2,541,385.00)
(117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49)
(117,762,067.49) (120,303,452.49) (117,762,067.49) (117,762,067.49) (117,762,067.49)
(19,110,864.25) (19,733,287.19) (20,430,400.88) (21,211,168.22) (22,085,627.63)

(136,872,931.74) (140,036,739.68) (138,192,468.38) (138,973,235.71) (139,847,695.13)

104,481,796.89 101,940,411.89 104,481,796.89 104,481,796.89 104,481,796.89

85,370,932.64 82,207,124.70 84,051,396.01 83,270,628.67 82,396,169.26
Year-9 Year-10

222,243,864 222,243,864
32,825,252
106,634,271.81
222,243,864 361,703,388

(117,762,067.49) (117,762,067.49)
(117,762,067.49) (117,762,067.49)
(23,065,022.18) (24,161,944.07)

(140,827,089.67) (141,924,011.56)

104,481,796.89 243,941,320.21
81,416,774.71 219,779,376.14
 Sensitivity Analysis
REVENUE DECREASE BY 10%

Description
Year-0 Year-1

Revenue 162,515,825.83

Working Capital Recovery

Sensitivity Analysis If - -
Fixed Asset Recovery -
Revenue Decrease by 10% Total Benefits - 162,515,825.83
Operating Cost Increase by 10% Initial Investment (359,934,593.09) -
Initial Investment Cost Increa 10% Replacement Costs - -
Operating Costs - (98,417,683.00)
Total Costs (359,934,593.09) (98,417,683.00)
Profit Tax - (5,500,813.16)
Total Cost Inc. Income
Tax (359,934,593.09) (103,918,496.16)

Net Benefit Before Tax

(359,934,593.09) 64,098,142.83
Net Benefit After Tax
(359,934,593.09) 58,597,329.67

Description NPV @15% IRR

Before Tax 57,162,946.90 19.06%

After Tax 5,950,123.35 15.44%

Annual Discounting Rate 0.15

ysis

Period (Years)
Year-2 Year-3 Year-4 Year-5 Year-6

187,518,260.57 200,019,477.94 200,019,477.94 200,019,477.94 200,019,477.94

- - - - -
- - - - -
187,518,260.57 200,019,477.94 200,019,477.94 200,019,477.94 200,019,477.94
- - - - -
- - - (2,541,385.00) -
(111,313,939.33) (117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49)
(111,313,939.33) (117,762,067.49) (117,762,067.49) (120,303,452.49) (117,762,067.49)
(9,575,695.03) (11,887,813.55) (12,443,548.32) (13,065,971.26) (13,763,084.95)

(120,889,634.36) (129,649,881.05) (130,205,615.81) (133,369,423.75) (131,525,152.44)

76,204,321.24 82,257,410.45 82,257,410.45 79,716,025.45 82,257,410.45

66,628,626.21 70,369,596.90 69,813,862.13 66,650,054.19 68,494,325.50

Year-7 Year-8 Year-9 Year-10

200,019,477.94 200,019,477.94 200,019,477.94 200,019,477.94

- - - 32,825,251.51
- - - 106,634,271.81
200,019,477.94 200,019,477.94 200,019,477.94 339,479,001.26
- - - -
- - - -
(117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49)
(117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49)
(14,543,852.28) (15,418,311.70) (16,397,706.24) (17,494,628.13)

(132,305,919.78) (133,180,379.19) (134,159,773.74) (135,256,695.63)

82,257,410.45 82,257,410.45 82,257,410.45 221,716,933.77

67,713,558.16 66,839,098.75 65,859,704.20 204,222,305.63

OPERATING COST INCREASE BY 10%

Description
Year-0 Year-1 Year-2

Revenue - 180,573,139.81 208,353,622.86

Working Capital Recovery

- - -
Fixed Asset Recovery - - -
Total Benefits - 180,573,139.81 208,353,622.86
Initial Investment (359,934,593.09) - -
Replacement Costs - - -
Operating Costs - (108,259,451.30) (122,445,333.26)
Total Costs (359,934,593.09) (108,259,451.30) (122,445,333.26)
Profit Tax (7,965,476.86) (12,486,885.54)
Total Cost Inc. Income Tax
(359,934,593.09) (116,224,928.16) (134,932,218.80)

Net Benefit Before Tax

(359,934,593.09) 72,313,688.51 85,908,289.60
Net Benefit After Tax
(359,934,593.09) 64,348,211.65 73,421,404.06

Description NPV @15% IRR

Before Tax 100,582,812.00 22.05%

After Tax 36,344,028.91 17.65%

Annual Discounting Rate 0.15

 Period (Years)
Year-3 Year-4 Year-5 Year-6 Year-7

222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38

- - - - -
- - - - -
222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38
- - - - -
- - (2,541,385.00) - -
(129,538,274.24) (129,538,274.24) (129,538,274.24) (129,538,274.24) (129,538,274.24)
(129,538,274.24) (129,538,274.24) (132,079,659.24) (129,538,274.24) (129,538,274.24)
(15,022,267.46) (15,578,002.22) (16,200,425.16) (16,897,538.86) (17,678,306.19)

(144,560,541.70) (145,116,276.47) (148,280,084.41) (146,435,813.10) (147,216,580.44)

92,705,590.14 92,705,590.14 90,164,205.14 92,705,590.14 92,705,590.14

77,683,322.68 77,127,587.91 73,963,779.97 75,808,051.28 75,027,283.95

 INITIAL INVSTEMENT COST INCREAS

Description
Year-8 Year-9 Year-10

222,243,864.38 222,243,864.38 222,243,864.38 Revenue

Working Capital Recovery

- - 32,825,251.51
- - 106,634,271.81 Fixed Asset Recovery

222,243,864.38 222,243,864.38 361,703,387.70 Total Benefits

- - - Initial Investment

- - - Replacement Costs

(129,538,274.24) (129,538,274.24) (129,538,274.24) Operating Costs

(129,538,274.24) (129,538,274.24) (129,538,274.24) Total Costs

(18,552,765.61) (19,532,160.15) (20,629,082.04) Profit Tax

Total Cost Inc. Income Tax

(148,091,039.85) (149,070,434.40) (150,167,356.29)

Net Benefit Before Tax

92,705,590.14 92,705,590.14 232,165,113.46
Net Benefit After Tax
74,152,824.53 73,173,429.99 211,536,031.41

Description

Before Tax
After Tax

Annual Discounting Rate

Initial Investment Cost Increase

STEMENT COST INCREASE BY 10%

Period (Years)
Year-0 Year-1 Year-2 Year-3 Year-4

180,573,139.81 208,353,622.86 222,243,864.38 222,243,864.38

- - - -
- - - -
180,573,139.81 208,353,622.86 222,243,864.38 222,243,864.38
(395,928,052.40) - - - -
- - - - -
- (98,417,683.00) (111,313,939.33) (117,762,067.49) (117,762,067.49)
(395,928,052.40) (98,417,683.00) (111,313,939.33) (117,762,067.49) (117,762,067.49)
- (10,918,007.35) (15,826,303.72) (18,555,129.48) (19,110,864.25)

(395,928,052.40) (109,335,690.35) (127,140,243.05) (136,317,196.98) (136,872,931.74)

(395,928,052.40) 82,155,456.81 97,039,683.53 104,481,796.89 104,481,796.89

(395,928,052.40) 71,237,449.46 81,213,379.81 85,926,667.40 85,370,932.64

NPV @15% IRR

118,790,556.46 23%
39,699,851.96 18%

0.15

10%
Period (Years)
Year-5 Year-6 Year-7 Year-8 Year-9 Year-10

222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38

- - - - - 32,825,251.51
- - - - - 106,634,271.81
222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 222,243,864.38 361,703,387.70
- - - - - -
(2,541,385.00) - - - - -
(117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49)
(120,303,452.49) (117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49) (117,762,067.49)
(19,733,287.19) (20,430,400.88) (21,211,168.22) (22,085,627.63) (23,065,022.18) (24,161,944.07)

(140,036,739.68) (138,192,468.38) (138,973,235.71) (139,847,695.13) (140,827,089.67) (141,924,011.56)

101,940,411.89 104,481,796.89 104,481,796.89 104,481,796.89 104,481,796.89 243,941,320.21

82,207,124.70 84,051,396.01 83,270,628.67 82,396,169.26 81,416,774.71 219,779,376.14

 Y-0 Y-1 Y-2

Sales/Revenue 180,573,140 208,353,623

Operating Cost 98,417,683.00 111,313,939.33
Net Profit 25,475,350 36,928,042
Cumulative Retained Earning 33,117,956 81,124,410
Cumulative Cash Balance 22,149,146 52,450,448
Total Asset 304,061,632 323,908,440 343,755,249
Liabilities 215,960,756 203,654,413 189,871,308

700000000

600000000

500000000

400000000

300000000

200000000

100000000

0
1 2 3
 Y-3 Y-4 Y-5 Y-6 Y-7 Y-8

222,243,864 222,243,864 222,243,864 222,243,864 222,243,864 222,243,864

117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49 117,762,067.49
43,295,302 44,592,017 46,044,337 47,670,935 49,492,726 51,533,131
137,408,303 195,377,925 255,235,562 317,207,778 381,548,322 448,541,392
87,166,891 120,938,584 154,692,882 186,221,363 216,422,540 245,137,136
363,602,057 383,448,865 402,254,951 422,101,759 441,948,567 461,795,376
174,434,231 157,144,705 137,780,436 116,092,455 91,801,915 64,596,511

700000000

600000000

500000000

400000000 Net Profit

Cumulative Retained Earning
Cumulative Cash Balance
300000000 Total Asset
Liabilities

200000000

100000000

0
1 2 3 4 5 6 7 8 9 10 11
 Y-9 Y-10

222,243,864 222,243,864
117,762,067.49 117,762,067.49
53,818,385 56,377,869
518,505,293 591,796,523
272,186,762 297,371,620
481,642,184 0
34,126,459 0

Net Profit
umulative Retained Earning
umulative Cash Balance
otal Asset
abilities
Year Net Benefit After Tax Present Value Undiscaunied PP Discounted PP
0 (359,934,593.09) (359,934,593.09)
1 71,237,449.46 61,945,608.23 (288,697,143.63) (297,988,984.86)
2 81,213,379.81 61,408,982.84 (207,483,763.82) (236,580,002.02)
3 85,926,667.40 56,498,178.62 (121,557,096.41) (180,081,823.40)
4 85,370,932.64 48,811,107.81 (36,186,163.78) (131,270,715.59)
5 82,207,124.70 40,871,469.88 46,020,960.92 (90,399,245.71)
6 84,051,396.01 36,337,737.97 (54,061,507.74)
7 83,270,628.67 31,304,513.66 (22,756,994.09)
8 82,396,169.26 26,935,453.89 4,178,459.80
9 81,416,774.71 23,143,728.76
10 219,779,376.14 54,326,100.50

Undiscounted pay back period One years and Seven Months

Discounted pay back period One years and Nine Months

Benefit Cost Ratio

Sum of Present Value of

Describition Cost of Initial Investment
BCR PV/INT.INV 441,582,882.15 359,934,593.09 1.23
NBCR BCR-1 0.23
 1.15 - 1.0000
1.15 1.00 1.1500
1.15 2.00 1.3225
1.15 3.00 1.5209
1.15 4.00 1.7490
1.15 5.00 2.0114
1.15 6.00 2.3131
1.15 7.00 2.6600
1.15 8.00 3.0590
1.15 9.00 3.5179
1.15 10.00 4.0456

months
undiscounted 0.44
discounted 0.84
No. Description Annual Production Unit Selling Annual Revenue Item
1 Core(Foundation,Co 3,674.90 16,859.48 61,956,953.33 Core(Foundation
2 Shell (three-dimens 1,776.20 19,001.71 33,750,898.36 Shell (three-dim
3 Shear wall 2,186.57 21,844.29 47,764,012.48 Shear wall
4 Partition wall 7,288.56 3,821.09 27,850,236.14 Partition wall
5 Facade 6,124.84 3,821.09 23,403,559.78 Facade
6 Slab 4,356.03 7,030.27 30,624,049.45 Slab
7 Column 3,592.87 9,415.24 33,827,777.84 Column
8 Beam (grade beam,F 2,287.36 8,143.59 18,627,343.10 Beam (grade bea

Total 31,287.33 277,804,830.48

Variable Cost 128,962,563.30
Fixed Cost 14,592,016.85 W.A.C.m
Total 143,554,580.16 bep unit
bep value

Total unit
250
500
750
1000
1250
1500
1750
2000
2250
2500
2750
3000
3250
3500
3750
4000
Unit Selling Price unit varible cost contribution marunit fixed cost % share W.A.P W.A.V.C
16,859.48 7,826.51 9,032.97 466.39 22% 3,760.06 1,745.49
19,001.71 8,820.97 10,180.74 466.39 12% 2,308.54 1,071.67
21,844.29 10,140.56 11,703.73 466.39 17% 3,755.77 1,743.50
3,821.09 1,773.83 2,047.26 466.39 10% 383.07 177.83
3,821.09 1,773.83 2,047.26 466.39 8% 321.91 149.44
7,030.27 3,263.59 3,766.68 466.39 11% 774.99 359.76
9,415.24 4,370.74 5,044.50 466.39 12% 1,146.48 532.22
8,143.59 3,780.42 4,363.17 466.39 7% 546.04 253.48

6,963.45
2,095.51 7%
27,235,091.52 10%

Total fixed cost Total varible cost Total cost Sales revenue p/l
14,592,016.85 1,508,349.82 16,100,366.68 3,249,213.23 (12,851,153.44)
14,592,016.85 3,016,699.65 17,608,716.50 6,498,426.47 (11,110,290.04)
14,592,016.85 4,525,049.47 19,117,066.33 9,747,639.70 (9,369,426.63)
14,592,016.85 6,033,399.30 20,625,416.15 12,996,852.93 (7,628,563.22)
14,592,016.85 7,541,749.12 22,133,765.98 16,246,066.17 (5,887,699.81)
14,592,016.85 9,050,098.95 23,642,115.80 19,495,279.40 (4,146,836.40)
14,592,016.85 10,558,448.77 25,150,465.63 22,744,492.64 (2,405,972.99)
14,592,016.85 12,066,798.60 26,658,815.45 25,993,705.87 (665,109.58)
14,592,016.85 13,575,148.42 28,167,165.28 29,242,919.10 1,075,753.83
14,592,016.85 15,083,498.25 29,675,515.10 32,492,132.34 2,816,617.24
14,592,016.85 16,591,848.07 31,183,864.92 35,741,345.57 4,557,480.65
14,592,016.85 18,100,197.90 32,692,214.75 38,990,558.80 6,298,344.06
14,592,016.85 19,608,547.72 34,200,564.57 42,239,772.04 8,039,207.46
14,592,016.85 21,116,897.54 35,708,914.40 45,488,985.27 9,780,070.87
14,592,016.85 22,625,247.37 37,217,264.22 48,738,198.51 11,520,934.28
14,592,016.85 24,133,597.19 38,725,614.05 51,987,411.74 13,261,797.69

60,000,000.00

50,000,000.00

40,000,000.00

30,000,000.00
60,000,000.00

50,000,000.00

40,000,000.00

30,000,000.00

20,000,000.00

10,000,000.00

-
250 500 750 100012501500175020002250250027503000325035003750
BEP by unit BEP by value
467.35 6,074,060.31
254.59 3,308,829.45
360.29 4,682,630.06
210.08 2,730,347.52
176.54 2,294,409.68
231.00 3,002,283.25
255.17 3,316,366.47
140.51 1,826,164.77

Total varible cost

Total cost
 Total varible cost
Total cost
Sales revenue

0275030003250350037504000
Product Description Rate on demand Daily production( %)
C5 7 0.5
C10 6 2
C15 4 9
C20 5 3
C25 1 40
C30 3 15
C40 2 30
C50 7 0.5
Daily production(m3) Annualy production(m3)
3.2 960
12.8 3840
57.6 17280
19.2 5760
256 76800
96 28800
192 57600
3.2 960