Description
A device in various keyboard instruments for deadening the vibrations of the strings
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
FINANCIAL FEASIBILITY STUDY REPORT
INDEX
INVESTMENT SUMMARY BALANCE SHEET INCOME STATEMENT SALES DETAILS SALES GRAPH COST OF RAW MATERIALS COST OF DIRECT LABOUR COST OF FACTORY OVERHEADS SALARY DETAILS ADMINISTRATION EXPENSES GENERAL EXPENSES DEPRECIATION SHEET FIXED ASSET DETAILS CASH FLOW RATIO ANALYSIS RATIO GRAPH BREAK EVEN ANALYSIS OPERATING DATA
PAGE NO. PAGE 02 PAGE 03 & 04 PAGE 05 PAGE 06 PAGE 07 PAGE 08 PAGE 09 PAGE 10 PAGE 11 & 12 PAGE 13 PAGE 14 & 15 PAGE 16 / 17 & 18 PAGE 19 & 20 PAGE 21 PAGE 22 PAGE 23 PAGE 24 PAGE 25
Page 01
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
START-UP INVESTMENT ESTIMATE FOR 2011
SR NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 FACTORY CONSTRUCTION COST OFFICE FURNISHING LEASE HOLD IMPROVEMENT COMPUTER FURNITURE OFFICE EQUIPMENTS MOTOR VECHILES INVENTORY ( RAW MATERIAL ) RECRUITMENT EXP SALARY EXPENSE ( 6 MONTHS ) ADVERTISEMENT EXP CONSULTANCY FEE OTHER EXP MINISTRY RENT FOR 6 MONTHS 388,052 690,948 DESCRIPITION AMOUNT IN QATAR RIYAL 0 0 0 161,000 10,000 0 0 250,000
TOTAL START UP FUNDS REQUIRED INVESTMENT FROM OWNERS LOAN FROM BANK
1,500,000
Page 02
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED BALANCE SHEET
YEAR 2012 ASSETS FIXED ASSETS FURNITURE & FIX. - OFFICE FURNITURE & FIX. - HOUSE OFFICE EQUIPMENTS COMPUTER EQUIP. & SOFTWARE WORKSHOP EQUIPMENTS LEASEHOLD IMPROVMENT MOTOR VEHICLES PLANT & MACHINERY LAND AND BUILDINGS TOTAL - FIXED ASSETS CURRENT ASSETS CASH & BANK BILLS RECEIVABLES ACCOUNTS RECEIVABLES - TRADE ACCOUNTS RECEIVABLES - STAFF STOCK DUE FROM AFFILIATES PREPAID EXPENSES ADVANCES RETENTION & DEPOSITS TOTAL - CURRENT ASSETS TOTAL ASSETS YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
8,500 0 0 107,334 0 0 0 7,801,875 0 7,917,709
7,000 0 0 53,668 0 0 0 7,391,250 0 7,451,918
5,500 0 0 (0) 0 0 0 6,980,625 0 6,986,125
4,000 0 0 0 0 0 0 6,570,000 0 6,574,000
2,500 0 0 0 0 0 0 6,159,375 0 6,161,875
(5,551,655)
(3,661,074)
(1,143,863)
2,203,728
6,573,548
250,000
250,000
250,000
250,000
250,000
(5,301,655) 2,616,054
(3,411,074) 4,040,844
(893,863) 6,092,261
2,453,728 9,027,728
6,823,548 12,985,423
Page 03 PARTNER'S EQUITY AND LIABILITIES
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED BALANCE SHEET
YEAR 2012 PARTNERS EQUITY CAPITAL RETAINED EARNINGS TOTAL - PARTNERS EQUITY CURRENT LIABILITIES BILLS PAYABLE ACCOUNTS PAYABLE-TRADE ACCOUNTS PAYABLE-OTHERS ADVANCE RECEIVED ACCRUALS & OTHER PAYABLES PROVISIONS TOTAL - CURRENT LIABILITIES TOTAL LIABILITIES DIFFERENCE IN BALANCE 1,500,000 1,116,054 2,616,054 YEAR 2013 1,500,000 2,540,844 4,040,844 YEAR 2014 1,500,000 4,592,261 6,092,261 YEAR 2015 1,500,000 7,527,728 9,027,728 YEAR 2016 1,500,000 11,485,423 12,985,423
0 2,616,054 0
0 4,040,844 0
0 6,092,261 0
0 9,027,728 0
0 12,985,423 0
Page 04
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED INCOME STATEMENT
YEAR 2012 NET REVENUES COST OF FINISHED GOODS GROSS PROFIT / LOSS ADMINISTRATION EXPENSES GENERAL EXPENSES TOTAL ADMIN. & GEN. EXP. NET OPERATING PROFIT / LOSS DEP. & AMORT. EXPENSES OTHER INCOME NET PROFIT / LOSS 1,116,054 8,584,800 6,756,955 1,827,845 0 246,000 246,000 1,581,845 465,791 % 100% 79% 21% 0% 3% 3% 18% 5% 0% 13% 1,424,790 YEAR 2013 9,872,520 7,711,339 2,161,181 0 270,600 270,600 1,890,581 465,791 % 100% 78% 22% 0% 3% 3% 19% 5% 0% 14% 2,051,417 YEAR 2014 11,847,024 9,032,154 2,814,870 0 297,660 297,660 2,517,210 465,793 % 100% 76% 24% 0% 3% 3% 21% 4% 0% 17% 2,935,466 YEAR 2015 14,216,429 10,526,529 3,689,900 0 342,309 342,309 3,347,591 412,125 % 100% 74% 26% 0% 2% 2% 24% 3% 0% 21% 3,957,695 YEAR 2016 17,059,715 12,296,239 4,763,476 0 393,655 393,655 4,369,820 412,125 % 100% 72% 28% 0% 2% 2% 26% 2% 0% 23%
Page 05
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED SALES REPORT
YEAR 2012 INCOME FIRE SMOKE DAMPERS CURTAIN FIRE DAMPERS LOUVERS TOTAL INCOME TURNOVER GROWTH % Y.O.Y 8,584,800 100% 0% 0% 8,584,800 100% 9,872,520 100% 0 0% 0 0% 9,872,520 100% 15% 11,847,024 100% 0 0% 0 0% 11,847,024 100% 20% 14,216,429 100% 0 0% 0 0% 14,216,429 100% 20% 17,059,715 100% 0 0% 0 0% 17,059,715 100% 20% % YEAR 2013 % YEAR 2014 % YEAR 2015 % YEAR 2016 %
F/S DAMP 36 X 48, S.P USD 320/( 2 ITEM PER HOUR ) F/S DAMP 24 X 24, S.P USD 170/( 2 ITEM PER HOUR ) MONTHLY TOTAL
467,200.00
248,200.00
715,400.00
Page 06
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED SALES GRAPH
YEAR 2012 TO 2016
18,000,000 16,000,000 14,000,000 12,000,000 Axis Title 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 Series1 YEAR 2012 8,584,800 YEAR 2013 9,872,520 YEAR 2014 11,847,024 YEAR 2015 14,216,429 YEAR 2016 17,059,715
Page 07
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED COST OF RAW MATERIAL
YEAR 2012 COST OF RAW MATERIAL DPLC OF RAW MATERIAL FREIGHT CHARGES CUSTOMS & CLEARANCE CHARGES INSURANCE - PURCHASE BANK CHARGES - PURCHASE UNLOADING & LOADING EXP OTHER EXP - PURCHASE TOOLS & CONSUMABLE ITEMS ROYALTY EXP TOTAL COST OF RAW MATERIAL 3,433,920 206,035 34,339 34,339 43,800 3,752,434 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 0.51% 43.71% YEAR 2013 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 1.85% 45.05% YEAR 2014 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 3.08% 46.28% YEAR 2015 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 2.57% 45.77% YEAR 2016 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 2.14% 45.34%
3,949,008 236,940 39,490 39,490 182,500 4,447,429
4,738,810 284,329 47,388 47,388 365,000 5,482,914
5,686,572 341,194 56,866 56,866 365,000 6,506,497
6,823,886 409,433 68,239 68,239 365,000 7,734,797
Page 08
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED COST OF DIRECT LABOUR
YEAR 2012 COST OF LABOUR BASIC SALARY WAGES OVERTIME HOUSING ALLOWANCE ( HRA ) TRAVELLING ALLOWANCE ( TRA ) SPECIAL ALLOWANCES ( SPA ) TELEPHONE ALLOWANCE ( TLA ) EDUCATION ALLOWANCE ( EDA ) FURNITURE ALLOWANCE ( FRA ) UTILITY / E&W ALLOWANCE ( UTA ) FOOD ALLOWANCE ( FDA ) STAFF ACCOMDATION RENT STAFF ACCOMDATION E&W EXP STAFF ACCOMDATION MAINT EXP VEHICLE HIRE - STAFF RECRUITMENT EXPENSES VISA CHARGES VISA CHARGES - FAMILY HEALTH CARD EXP HEALTH CARD EXP - FAMILY LIFE INSURANCE EXP LIFE INSURANCE EXP - FAMILY MEDICAL INSURANCE MEDICAL INSURANCE - FAMILY LEAVE SALARY LEAVE WAGES LEAVE AIR TICKET LEAVE AIR TICKET - FAMILY GRATUITY BONUS STAFF WELFARE TOTAL COST OF LABOUR LABOUR COST % ON SALES 698,400 % YEAR 2013 % YEAR 2014 % YEAR 2015 % YEAR 2016 INCREASE INCREASE INCREASE INCREASE 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 768,240 0 0 0 79,200 39,600 0 0 0 0 63,360 356,400 0 0 0 0 45,210 0 3,630 0 17,820 0 0 0 0 0 82,500 0 64,126 0 0 1,520,086 15.40% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 845,064 0 0 0 87,120 43,560 0 0 0 0 69,696 392,040 0 0 0 0 49,731 0 3,993 0 19,602 0 0 0 0 0 90,750 0 70,538 0 0 1,672,094 14.11% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 971,824 0 0 0 100,188 50,094 0 0 0 0 80,150 450,846 0 0 0 0 57,191 0 4,592 0 22,542 0 0 0 0 0 104,363 0 81,119 0 0 1,922,908 13.53% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 1,117,597 0 0 0 115,216 57,608 0 0 0 0 92,173 518,473 0 0 0 0 65,769 0 5,281 0 25,924 0 0 0 0 0 120,017 0 93,287 0 0 2,211,345 12.96% Page 09
0 72,000 36,000 0 0 0 0 57,600 324,000
0 41,100 0 3,300 0 16,200 0 0
75,000 0 58,296
1,381,896 16.10%
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED COST OF FACTORY OVERHEADS
YEAR 2012 COST OF FACTORY OVERHEADS FACTORY RENT FACTORY ELECT & WATER EXP FACTORY MAINTANANCE DEP. EXP. PLANT & MACHINERY MACHINERY MAINTANANCE FUEL / GAS / LUBRICANTS TOTAL COST OF OVERHEADS OVERHEAD % ON SALES 1,200,000 6,000 6,000 410,625 6,000 12,000 1,622,625 18.90% % OF INCREASE 10.00% 10.00% 10.00% 0.00% 10.00% 10.00% YEAR 2013 % OF INCREASE 10.00% 10.00% 10.00% 0.00% 10.00% 10.00% YEAR 2014 % OF INCREASE 15.00% 15.00% 15.00% 0.00% 15.00% 15.00% YEAR 2015 % OF INCREASE 15.00% 15.00% 15.00% 0.00% 15.00% 15.00% YEAR 2016
1,320,000 6,600 6,600 410,625 6,600 13,200 1,743,825 17.66%
1,452,000 7,260 7,260 410,625 7,260 14,520 1,877,145 15.84%
1,669,800 8,349 8,349 410,625 8,349 16,698 2,097,123 14.75%
1,920,270 9,601 9,601 410,625 9,601 19,203 2,350,098 13.78%
Page 10
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
SALARY STRUCTURE SR NO 1 2 3 4 5 6 7 8 9 10 STAFF POSITION GENERAL MANAGER SALES MANAGER SALES ENGINEER FACTORY MANAGER HUMAN RESOURCES ADMINISTRATION ACCOUNTANT ACCOUNTS ASSISTANT SECRETARY OFFICE BOY MONTHY TOTAL YEARLY TOTAL PRODUCTION ENGINEER PRODUCTION ENGINEER PRODUCTION ENGINEER QA & TECH SUPPORT QA & TECH SUPPORT QA & TECH SUPPORT SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN BASIC SALARY HRA TRA SPA TLA EDA FRA UTA FDA GROSS CTC CTC TOTAL MONTHLY YEARLY 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6,000 8,294 99,524 6,000 8,294 99,524 6,000 8,294 99,524 6,000 8,210 98,516 6,000 8,210 98,516 6,000 8,210 98,516 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 Page 11 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
0 0 5,000 5,000 5,000 4,000 4,000 4,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 800 800 800 800 800 800
0 0
0 0 1,000 1,000 1,000 1,000 1,000 1,000
0 0
0 0
0 0
0 0
0 0
0 0
1,000 1,000 1,000 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
SALARY STRUCTURE SR NO 23 24 25 26 27 28 29 30 STAFF POSITION UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN MONTHLY TOTAL YEARLY TOTAL MONTHLY GRAND TOTAL YEARLY GRAND TOTAL BASIC SALARY 800 800 800 800 800 800 800 800 58,200 698,400 58,200 698,400 HRA TRA SPA TLA EDA FRA UTA FDA 200 200 200 200 200 200 200 200 4,800 57,600 4,800 57,600 GROSS CTC CTC TOTAL MONTHLY YEARLY 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 72,000 115,158 1,381,896 864,000 1,381,896 72,000 864,000 115,158 1,381,896 1,381,896
0 6,000 3,000 0 72,000 36,000 0 6,000 3,000 0 72,000 36,000
0 0 0 0
0 0
0 0
0 0
Page 12
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED ADMINISTRATION EXPENSES
YEAR 2012 ADMINISTRATION EXPENSES BASIC SALARY WAGES OVERTIME HOUSING ALLOWANCE ( HRA ) TRAVELLING ALLOWANCE ( TRA ) SPECIAL ALLOWANCES ( SPA ) TELEPHONE ALLOWANCE ( TLA ) EDUCATION ALLOWANCE ( EDA ) FURNITURE ALLOWANCE ( FRA ) UTILITY / E&W ALLOWANCE ( UTA ) FOOD ALLOWANCE ( FDA ) STAFF ACCOMDATION RENT STAFF ACCOMDATION E&W EXP STAFF ACCOMDATION MAINT EXP VEHICLE HIRE RECRUITMENT EXPENSES VISA CHARGES VISA CHARGES - FAMILY HEALTH CARD EXP HEALTH CARD EXP - FAMILY LIFE INSURANCE EXP LIFE INSURANCE EXP - FAMILY MEDICAL INSURANCE MEDICAL INSURANCE - FAMILY LEAVE SALARY LEAVE WAGES LEAVE AIR TICKET LEAVE AIR TICKET - FAMILY GRATUITY BONUS STAFF WELFARE H.O MANAGEMENT CHARGES TOTAL ADMINISTATION EXPENSES ADMIN EXP % ON SALES Page 13 0 % OF INCREASE 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% YEAR 2013 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 % OF INCREASE 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% YEAR 2014 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 % OF INCREASE 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% YEAR 2015 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 % OF INCREASE 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% YEAR 2016 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0
0
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED GENERAL EXPESES
YEAR 2012 GENERAL EXPENSES
OFFICE RENT GENERAL POST BOX RENT TAXI / PARKING CHARGES PETROL & OIL VEHICLE REPAIR TELEPHONE / FAX / INTERNET COURIER & POSTAGE EXP. PRINTING EXPENSES STATIONARY EXPENSES ADVERTISEMENT CONSULTANCY FEES GIFT EXPENSES ENTERTAINMENT EXPENSES SALES PROMOTION BUSINESS TRIP TICKET BUSINESS TRIP EXPENSES VEHICLE INSURANCE WAREHOUSE INSURANCE INTEREST ON OVER DRAFT INTEREST ON BANK LOAN INTEREST ON TERM LOAN INTEREST ON CIL L/C OPENING CHARGES AMENDMENT CHARGES TELEX CHARGES BANK CHARGES L/C NEGOTIATION CHARGES SALESMAN COMMISSION TENDER EXPENSES AUDIT FEES ELEC. & WATER OFFICE OFFICE RENOVATION / MAINTENANCE
0 0 0 12,000 0 12,000 6,000 24,000 12,000 24,000 0 0 12,000 12,000 45,000 60,000 0 0 0 0
% OF YEAR 2013 % OF YEAR 2014 % OF YEAR 2015 % OF YEAR 2016 INCREASE INCREASE INCREASE INCREASE 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 6,600 10.00% 7,260 15.00% 8,349 15.00% 9,601 10.00% 26,400 10.00% 29,040 15.00% 33,396 15.00% 38,405 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 26,400 10.00% 29,040 15.00% 33,396 15.00% 38,405 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 49,500 10.00% 54,450 15.00% 62,618 15.00% 72,010 10.00% 66,000 10.00% 72,600 15.00% 83,490 15.00% 96,014 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 Page 14 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED GENERAL EXPESES
YEAR 2012 GENERAL EXPENSES
OFFICE EQUIPMENT MAINTENANCE COMPUTER & SOFTWARE MAINTENANCE REPAIRS AND MAINTENANCE - GENERAL MEDICAL EXPENSES OFFICE REFRESHEMENT EXPENSES DISCOUNT ALLOWED PRIOR YEAR EXPENSES GENERAL EXPENSES LICENSE AND REGISTRATION EXP NEWSPAPER & PERIODICALS EXPENSES DELIVERY CHARGES EXPORT EXPENSES PENALITY BAD DEBTS DAMAGE GOODS LOSS ON SALE OF FIXED ASSET
% OF YEAR 2013 % OF YEAR 2014 % OF YEAR 2015 % OF YEAR 2016 INCREASE INCREASE INCREASE INCREASE 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 12,000 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 0 10.00% 0 15.00% 0 15.00% 0 3,000 10.00% 3,300 10.00% 3,630 15.00% 4,175 15.00% 4,801 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 12,000 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 270,600 297,660 342,309 393,655
TOTAL GENERAL EXPENSES
246,000
Page 15
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED DEPRECIATION DETAILS
SR NO DESCRIPITION 1 PARTICULARS % OF DEP 15.00% 10,000 10,000 1,500 1,500 8,500 15.00% 0 0 0 0 0 20.00% 0 0 0 0 0 33.33% 161,000 161,000 53,666 53,666 107,334 53,666 107,332 53,668 53,668 161,000 0 161,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,500 3,000 7,000 1,500 4,500 5,500 1,500 6,000 4,000 1,500 7,500 2,500 10,000 10,000 10,000 YEAR 2012 YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
FURNITURE & FIXTURES - OFFICE OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE FURNITURE & FIXTURES - HOUSE OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE OFFICE EQUIPMENTS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE COMPUTER EQUIPMENTS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE
2
3
4
Page 16
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED DEPRECIATION DETAILS
SR NO DESCRIPITION 5 PARTICULARS % OF DEP 20.00% 0 0 0 0 0 20.00% 0 0 0 0 0 20.00% 0 0 0 0 0 5.00% 8,212,500 8,212,500 Page 17 410,625 410,625 7,801,875 410,625 821,250 7,391,250 410,625 1,231,875 6,980,625 410,625 1,642,500 6,570,000 410,625 2,053,125 6,159,375 8,212,500 8,212,500 8,212,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 YEAR 2012 YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
WORKSHOP EQUIPMENTS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE LEASE HOLD IMPROVEMENTS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE MOTOR VECHILES OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE PLANT & MACHINERRY OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE
6
7
8
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED DEPRECIATION DETAILS
SR NO DESCRIPITION 9 PARTICULARS % OF DEP 5.00% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 YEAR 2012 YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
LAND & BUILDINGS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE SUMMARY OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE
0 8,383,500 0 465,791 465,791 7,917,709
8,383,500 0 0 465,791 931,582 7,451,918
8,383,500 0 0 465,793 1,397,375 6,986,125
8,222,500 0 0 412,125 1,648,500 6,574,000
8,222,500 0 0 412,125 2,060,625 6,161,875
Page 18
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED ASSET DETAILS
SR NO 1 2 3 TOTAL FURNITURE & FIXTURES - HOUSE 1 2 3 TOTAL OFFICE EQUIPMENTS 1 2 3 4 TOTAL COMPUTER EQUIPMENTS 1 2 3 4 5 TOTAL WORKSHOP EQUIPMENTS 1 2 3 TOTAL LEASE HOLD IMPROVEMENTS TOOLS MISC EQUIPMENTS 0 0 0 0 Page 19 LAPTOP - 1 COMPUTER - 2 SOFTWARE ( TECH DISCLOSURE FEE ) PRINTER 5,000 10,000 146,000 0 161,000 PHOTOCOPY MACHINE FAX MACHINE NET WORKING TELEPHONE SETS 0 0 0 0 0 HOUSE FURNITURE 0 0 0 0 DESCRIPITION FURNITURE & FIXTURES - OFFICE OFFICE FURNITURE 10,000 0 0 10,000 NAME OF THE ASSET COST OF THE ASSET
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED ASSET DETAILS
SR NO 1 2 3 MOTOR VECHILES 1 2 3 TOTAL PLANT & MACHINERRY 1 2 3 TOTAL LAND & BUILDINGS 1 2 3 TOTAL NET TOTAL CONSTRUCTION COST OF BLDG 0 0 0 0 8,383,500 Page 20 MACHINERRY - DPLC INSTALLATION CHRG 6 MONTHS ASSISTANCE 8,212,500 0 0 8,212,500 PICKUP 2 TRAILER 1 FORKLIFT 2 0 0 0 0 DESCRIPITION NAME OF THE ASSET OFFICE FURNISHING MISCELLANOUS WORKS TOTAL COST OF THE ASSET 0 0 0 0
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED CASH FLOW
YEAR 2012 CASH FLOW SATEMENT OPERATING ACTIVITIES NET OPERATING PROFIT / LOSS DEPRECIATION AMORTIZATION INCREASE / (DECREASE) IN CURRENT ASSET INCREASE / (DECREASE) IN CURRENT LIABILITY NET CASH FLOW FROM OPERATING ACTIVITY INVESTING ACTIVITY COST OF FIXED ASSET NET CASH FLOW USED IN INVESTING ACTIVITY FINANCING ACTIVITIES CAPITAL BROUGHT IN NET MOVEMENT IN PARTNERS LOAN A/C NET MOVEMENT IN PARTNERS CURRENT A/C NET CASH FLOW FROM FINACING ACTIVITY YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
1,116,054 465,791 -250,000 1,331,845
1,424,790 465,791
2,051,417 465,793
2,935,466 412,125
3,957,695 412,125
1,890,581
2,517,210
3,347,591
4,369,820
-8,383,500 -8,383,500
0
0
0
0
1,500,000
1,500,000
0
0
0
0
INCREASE / (DECREASE ) IN CASH / CASH EQUIVALENTS OPENING CASH / CASH EQUIVALENTS CLOSING CASH / CASH EQUIVALENTS CASH EQUIVALENTS AS ON YEAR END CASH IN HAND CASH AT BANK
-5,551,655 0 -5,551,655
1,890,581 -5,551,655 -3,661,074
2,517,210 -3,661,074 -1,143,863
3,347,591 -1,143,863 2,203,728
4,369,820 2,203,728 6,573,548
0
0
0
0
0
Page 21
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED RATIO ANALYSIS
DESCRIPITION GROSS PROFIT RATIO NET OPERATING PROFIT RATIO ( Before Depreciation & Other Income ) NET PROFIT RATIO RETURN ON INVESTMENT YEAR 2012 21% 18% YEAR 2013 22% 19% YEAR 2014 24% 21% YEAR 2015 26% 24% YEAR 2016 28% 26%
13% 0.74
14% 0.95
17% 1.37
21% 1.96
23% 2.64
Page 22
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
RETURN ON INVESTMENT CHART
3.00
2.50
2.00
1.50
1.00
0.50
0.00
YEAR 2012
YEAR 2013
YEAR 2014
YEAR 2015
YEAR 2016
Page 23
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED BREAKEVEN ANALYSIS
YEAR 2012 SALE VARIABLE COST ( Material Cost / Labour / Overhead ) CONTRIBUTION (Amount of Sale - Associated Variable Cost ) PROFIT VOLUME RATIO ( Contribution / Sales ) FIXED COST (Rent, Salary, Depreciation, Etc) BREAK EVEN POINT - SALE BREAK EVEN POINT - % MARGIN OF SAFETY - % MARGIN OF SAFETY - SALE 8,584,800 6,756,955 YEAR 2013 9,872,520 7,711,339 YEAR 2014 11,847,024 9,032,154 YEAR 2015 14,216,429 10,526,529 YEAR 2016 17,059,715 12,296,239
1,827,845
2,161,181
2,814,870
3,689,900
4,763,476
0.21
0.22
0.24
0.26
0.28
246,000
270,600
297,660
342,309
393,655
1,155,383 0.13 0.87 7,429,417
1,236,132 0.13 0.87 8,636,388
1,252,770 0.11 0.89 10,594,254
1,318,846 0.09 0.91 12,897,582
1,409,821 0.08 0.92 15,649,894
Page 24
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED OPERATING DATA
YEAR 2012 YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
DAYS SALES IN ACCOUNTS RECEIVABLE DAYS MATERIALS COST IN INVENTORY DAYS FINISHED GOODS IN INVENTORY DAYS MATERIALS COST IN PAYBLES
90 45 15 60
90 45 15 60
90 45 15 60
90 45 15 60
90 45 15 60
Chart Title
100 80 60 40 20 0 YEAR 2012
DAYS SALES IN ACCOUNTS RECEIVABLE
YEAR 2013
YEAR 2014
YEAR 2015
YEAR 2016
DAYS MATERIALS COST IN PAYBLES
DAYS MATERIALS COST IN INVENTORY
DAYS FINISHED GOODS IN INVENTORY
Page 25
doc_470154790.xls
A device in various keyboard instruments for deadening the vibrations of the strings
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
FINANCIAL FEASIBILITY STUDY REPORT
INDEX
INVESTMENT SUMMARY BALANCE SHEET INCOME STATEMENT SALES DETAILS SALES GRAPH COST OF RAW MATERIALS COST OF DIRECT LABOUR COST OF FACTORY OVERHEADS SALARY DETAILS ADMINISTRATION EXPENSES GENERAL EXPENSES DEPRECIATION SHEET FIXED ASSET DETAILS CASH FLOW RATIO ANALYSIS RATIO GRAPH BREAK EVEN ANALYSIS OPERATING DATA
PAGE NO. PAGE 02 PAGE 03 & 04 PAGE 05 PAGE 06 PAGE 07 PAGE 08 PAGE 09 PAGE 10 PAGE 11 & 12 PAGE 13 PAGE 14 & 15 PAGE 16 / 17 & 18 PAGE 19 & 20 PAGE 21 PAGE 22 PAGE 23 PAGE 24 PAGE 25
Page 01
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
START-UP INVESTMENT ESTIMATE FOR 2011
SR NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 FACTORY CONSTRUCTION COST OFFICE FURNISHING LEASE HOLD IMPROVEMENT COMPUTER FURNITURE OFFICE EQUIPMENTS MOTOR VECHILES INVENTORY ( RAW MATERIAL ) RECRUITMENT EXP SALARY EXPENSE ( 6 MONTHS ) ADVERTISEMENT EXP CONSULTANCY FEE OTHER EXP MINISTRY RENT FOR 6 MONTHS 388,052 690,948 DESCRIPITION AMOUNT IN QATAR RIYAL 0 0 0 161,000 10,000 0 0 250,000
TOTAL START UP FUNDS REQUIRED INVESTMENT FROM OWNERS LOAN FROM BANK
1,500,000
Page 02
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED BALANCE SHEET
YEAR 2012 ASSETS FIXED ASSETS FURNITURE & FIX. - OFFICE FURNITURE & FIX. - HOUSE OFFICE EQUIPMENTS COMPUTER EQUIP. & SOFTWARE WORKSHOP EQUIPMENTS LEASEHOLD IMPROVMENT MOTOR VEHICLES PLANT & MACHINERY LAND AND BUILDINGS TOTAL - FIXED ASSETS CURRENT ASSETS CASH & BANK BILLS RECEIVABLES ACCOUNTS RECEIVABLES - TRADE ACCOUNTS RECEIVABLES - STAFF STOCK DUE FROM AFFILIATES PREPAID EXPENSES ADVANCES RETENTION & DEPOSITS TOTAL - CURRENT ASSETS TOTAL ASSETS YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
8,500 0 0 107,334 0 0 0 7,801,875 0 7,917,709
7,000 0 0 53,668 0 0 0 7,391,250 0 7,451,918
5,500 0 0 (0) 0 0 0 6,980,625 0 6,986,125
4,000 0 0 0 0 0 0 6,570,000 0 6,574,000
2,500 0 0 0 0 0 0 6,159,375 0 6,161,875
(5,551,655)
(3,661,074)
(1,143,863)
2,203,728
6,573,548
250,000
250,000
250,000
250,000
250,000
(5,301,655) 2,616,054
(3,411,074) 4,040,844
(893,863) 6,092,261
2,453,728 9,027,728
6,823,548 12,985,423
Page 03 PARTNER'S EQUITY AND LIABILITIES
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED BALANCE SHEET
YEAR 2012 PARTNERS EQUITY CAPITAL RETAINED EARNINGS TOTAL - PARTNERS EQUITY CURRENT LIABILITIES BILLS PAYABLE ACCOUNTS PAYABLE-TRADE ACCOUNTS PAYABLE-OTHERS ADVANCE RECEIVED ACCRUALS & OTHER PAYABLES PROVISIONS TOTAL - CURRENT LIABILITIES TOTAL LIABILITIES DIFFERENCE IN BALANCE 1,500,000 1,116,054 2,616,054 YEAR 2013 1,500,000 2,540,844 4,040,844 YEAR 2014 1,500,000 4,592,261 6,092,261 YEAR 2015 1,500,000 7,527,728 9,027,728 YEAR 2016 1,500,000 11,485,423 12,985,423
0 2,616,054 0
0 4,040,844 0
0 6,092,261 0
0 9,027,728 0
0 12,985,423 0
Page 04
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED INCOME STATEMENT
YEAR 2012 NET REVENUES COST OF FINISHED GOODS GROSS PROFIT / LOSS ADMINISTRATION EXPENSES GENERAL EXPENSES TOTAL ADMIN. & GEN. EXP. NET OPERATING PROFIT / LOSS DEP. & AMORT. EXPENSES OTHER INCOME NET PROFIT / LOSS 1,116,054 8,584,800 6,756,955 1,827,845 0 246,000 246,000 1,581,845 465,791 % 100% 79% 21% 0% 3% 3% 18% 5% 0% 13% 1,424,790 YEAR 2013 9,872,520 7,711,339 2,161,181 0 270,600 270,600 1,890,581 465,791 % 100% 78% 22% 0% 3% 3% 19% 5% 0% 14% 2,051,417 YEAR 2014 11,847,024 9,032,154 2,814,870 0 297,660 297,660 2,517,210 465,793 % 100% 76% 24% 0% 3% 3% 21% 4% 0% 17% 2,935,466 YEAR 2015 14,216,429 10,526,529 3,689,900 0 342,309 342,309 3,347,591 412,125 % 100% 74% 26% 0% 2% 2% 24% 3% 0% 21% 3,957,695 YEAR 2016 17,059,715 12,296,239 4,763,476 0 393,655 393,655 4,369,820 412,125 % 100% 72% 28% 0% 2% 2% 26% 2% 0% 23%
Page 05
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED SALES REPORT
YEAR 2012 INCOME FIRE SMOKE DAMPERS CURTAIN FIRE DAMPERS LOUVERS TOTAL INCOME TURNOVER GROWTH % Y.O.Y 8,584,800 100% 0% 0% 8,584,800 100% 9,872,520 100% 0 0% 0 0% 9,872,520 100% 15% 11,847,024 100% 0 0% 0 0% 11,847,024 100% 20% 14,216,429 100% 0 0% 0 0% 14,216,429 100% 20% 17,059,715 100% 0 0% 0 0% 17,059,715 100% 20% % YEAR 2013 % YEAR 2014 % YEAR 2015 % YEAR 2016 %
F/S DAMP 36 X 48, S.P USD 320/( 2 ITEM PER HOUR ) F/S DAMP 24 X 24, S.P USD 170/( 2 ITEM PER HOUR ) MONTHLY TOTAL
467,200.00
248,200.00
715,400.00
Page 06
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED SALES GRAPH
YEAR 2012 TO 2016
18,000,000 16,000,000 14,000,000 12,000,000 Axis Title 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 Series1 YEAR 2012 8,584,800 YEAR 2013 9,872,520 YEAR 2014 11,847,024 YEAR 2015 14,216,429 YEAR 2016 17,059,715
Page 07
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED COST OF RAW MATERIAL
YEAR 2012 COST OF RAW MATERIAL DPLC OF RAW MATERIAL FREIGHT CHARGES CUSTOMS & CLEARANCE CHARGES INSURANCE - PURCHASE BANK CHARGES - PURCHASE UNLOADING & LOADING EXP OTHER EXP - PURCHASE TOOLS & CONSUMABLE ITEMS ROYALTY EXP TOTAL COST OF RAW MATERIAL 3,433,920 206,035 34,339 34,339 43,800 3,752,434 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 0.51% 43.71% YEAR 2013 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 1.85% 45.05% YEAR 2014 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 3.08% 46.28% YEAR 2015 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 2.57% 45.77% YEAR 2016 % ON SALES 40.00% 0.00% 2.40% 0.00% 0.40% 0.00% 0.40% 0.00% 2.14% 45.34%
3,949,008 236,940 39,490 39,490 182,500 4,447,429
4,738,810 284,329 47,388 47,388 365,000 5,482,914
5,686,572 341,194 56,866 56,866 365,000 6,506,497
6,823,886 409,433 68,239 68,239 365,000 7,734,797
Page 08
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED COST OF DIRECT LABOUR
YEAR 2012 COST OF LABOUR BASIC SALARY WAGES OVERTIME HOUSING ALLOWANCE ( HRA ) TRAVELLING ALLOWANCE ( TRA ) SPECIAL ALLOWANCES ( SPA ) TELEPHONE ALLOWANCE ( TLA ) EDUCATION ALLOWANCE ( EDA ) FURNITURE ALLOWANCE ( FRA ) UTILITY / E&W ALLOWANCE ( UTA ) FOOD ALLOWANCE ( FDA ) STAFF ACCOMDATION RENT STAFF ACCOMDATION E&W EXP STAFF ACCOMDATION MAINT EXP VEHICLE HIRE - STAFF RECRUITMENT EXPENSES VISA CHARGES VISA CHARGES - FAMILY HEALTH CARD EXP HEALTH CARD EXP - FAMILY LIFE INSURANCE EXP LIFE INSURANCE EXP - FAMILY MEDICAL INSURANCE MEDICAL INSURANCE - FAMILY LEAVE SALARY LEAVE WAGES LEAVE AIR TICKET LEAVE AIR TICKET - FAMILY GRATUITY BONUS STAFF WELFARE TOTAL COST OF LABOUR LABOUR COST % ON SALES 698,400 % YEAR 2013 % YEAR 2014 % YEAR 2015 % YEAR 2016 INCREASE INCREASE INCREASE INCREASE 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 768,240 0 0 0 79,200 39,600 0 0 0 0 63,360 356,400 0 0 0 0 45,210 0 3,630 0 17,820 0 0 0 0 0 82,500 0 64,126 0 0 1,520,086 15.40% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 845,064 0 0 0 87,120 43,560 0 0 0 0 69,696 392,040 0 0 0 0 49,731 0 3,993 0 19,602 0 0 0 0 0 90,750 0 70,538 0 0 1,672,094 14.11% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 971,824 0 0 0 100,188 50,094 0 0 0 0 80,150 450,846 0 0 0 0 57,191 0 4,592 0 22,542 0 0 0 0 0 104,363 0 81,119 0 0 1,922,908 13.53% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 1,117,597 0 0 0 115,216 57,608 0 0 0 0 92,173 518,473 0 0 0 0 65,769 0 5,281 0 25,924 0 0 0 0 0 120,017 0 93,287 0 0 2,211,345 12.96% Page 09
0 72,000 36,000 0 0 0 0 57,600 324,000
0 41,100 0 3,300 0 16,200 0 0
75,000 0 58,296
1,381,896 16.10%
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED COST OF FACTORY OVERHEADS
YEAR 2012 COST OF FACTORY OVERHEADS FACTORY RENT FACTORY ELECT & WATER EXP FACTORY MAINTANANCE DEP. EXP. PLANT & MACHINERY MACHINERY MAINTANANCE FUEL / GAS / LUBRICANTS TOTAL COST OF OVERHEADS OVERHEAD % ON SALES 1,200,000 6,000 6,000 410,625 6,000 12,000 1,622,625 18.90% % OF INCREASE 10.00% 10.00% 10.00% 0.00% 10.00% 10.00% YEAR 2013 % OF INCREASE 10.00% 10.00% 10.00% 0.00% 10.00% 10.00% YEAR 2014 % OF INCREASE 15.00% 15.00% 15.00% 0.00% 15.00% 15.00% YEAR 2015 % OF INCREASE 15.00% 15.00% 15.00% 0.00% 15.00% 15.00% YEAR 2016
1,320,000 6,600 6,600 410,625 6,600 13,200 1,743,825 17.66%
1,452,000 7,260 7,260 410,625 7,260 14,520 1,877,145 15.84%
1,669,800 8,349 8,349 410,625 8,349 16,698 2,097,123 14.75%
1,920,270 9,601 9,601 410,625 9,601 19,203 2,350,098 13.78%
Page 10
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
SALARY STRUCTURE SR NO 1 2 3 4 5 6 7 8 9 10 STAFF POSITION GENERAL MANAGER SALES MANAGER SALES ENGINEER FACTORY MANAGER HUMAN RESOURCES ADMINISTRATION ACCOUNTANT ACCOUNTS ASSISTANT SECRETARY OFFICE BOY MONTHY TOTAL YEARLY TOTAL PRODUCTION ENGINEER PRODUCTION ENGINEER PRODUCTION ENGINEER QA & TECH SUPPORT QA & TECH SUPPORT QA & TECH SUPPORT SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN SKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN BASIC SALARY HRA TRA SPA TLA EDA FRA UTA FDA GROSS CTC CTC TOTAL MONTHLY YEARLY 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6,000 8,294 99,524 6,000 8,294 99,524 6,000 8,294 99,524 6,000 8,210 98,516 6,000 8,210 98,516 6,000 8,210 98,516 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 2,200 3,494 41,924 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 Page 11 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
0 0 5,000 5,000 5,000 4,000 4,000 4,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 800 800 800 800 800 800
0 0
0 0 1,000 1,000 1,000 1,000 1,000 1,000
0 0
0 0
0 0
0 0
0 0
0 0
1,000 1,000 1,000 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
SALARY STRUCTURE SR NO 23 24 25 26 27 28 29 30 STAFF POSITION UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN UNSKILLED WORKMEN MONTHLY TOTAL YEARLY TOTAL MONTHLY GRAND TOTAL YEARLY GRAND TOTAL BASIC SALARY 800 800 800 800 800 800 800 800 58,200 698,400 58,200 698,400 HRA TRA SPA TLA EDA FRA UTA FDA 200 200 200 200 200 200 200 200 4,800 57,600 4,800 57,600 GROSS CTC CTC TOTAL MONTHLY YEARLY 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 1,000 2,194 26,324 72,000 115,158 1,381,896 864,000 1,381,896 72,000 864,000 115,158 1,381,896 1,381,896
0 6,000 3,000 0 72,000 36,000 0 6,000 3,000 0 72,000 36,000
0 0 0 0
0 0
0 0
0 0
Page 12
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED ADMINISTRATION EXPENSES
YEAR 2012 ADMINISTRATION EXPENSES BASIC SALARY WAGES OVERTIME HOUSING ALLOWANCE ( HRA ) TRAVELLING ALLOWANCE ( TRA ) SPECIAL ALLOWANCES ( SPA ) TELEPHONE ALLOWANCE ( TLA ) EDUCATION ALLOWANCE ( EDA ) FURNITURE ALLOWANCE ( FRA ) UTILITY / E&W ALLOWANCE ( UTA ) FOOD ALLOWANCE ( FDA ) STAFF ACCOMDATION RENT STAFF ACCOMDATION E&W EXP STAFF ACCOMDATION MAINT EXP VEHICLE HIRE RECRUITMENT EXPENSES VISA CHARGES VISA CHARGES - FAMILY HEALTH CARD EXP HEALTH CARD EXP - FAMILY LIFE INSURANCE EXP LIFE INSURANCE EXP - FAMILY MEDICAL INSURANCE MEDICAL INSURANCE - FAMILY LEAVE SALARY LEAVE WAGES LEAVE AIR TICKET LEAVE AIR TICKET - FAMILY GRATUITY BONUS STAFF WELFARE H.O MANAGEMENT CHARGES TOTAL ADMINISTATION EXPENSES ADMIN EXP % ON SALES Page 13 0 % OF INCREASE 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% YEAR 2013 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 % OF INCREASE 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% YEAR 2014 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 % OF INCREASE 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% YEAR 2015 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 % OF INCREASE 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% YEAR 2016 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0
0
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED GENERAL EXPESES
YEAR 2012 GENERAL EXPENSES
OFFICE RENT GENERAL POST BOX RENT TAXI / PARKING CHARGES PETROL & OIL VEHICLE REPAIR TELEPHONE / FAX / INTERNET COURIER & POSTAGE EXP. PRINTING EXPENSES STATIONARY EXPENSES ADVERTISEMENT CONSULTANCY FEES GIFT EXPENSES ENTERTAINMENT EXPENSES SALES PROMOTION BUSINESS TRIP TICKET BUSINESS TRIP EXPENSES VEHICLE INSURANCE WAREHOUSE INSURANCE INTEREST ON OVER DRAFT INTEREST ON BANK LOAN INTEREST ON TERM LOAN INTEREST ON CIL L/C OPENING CHARGES AMENDMENT CHARGES TELEX CHARGES BANK CHARGES L/C NEGOTIATION CHARGES SALESMAN COMMISSION TENDER EXPENSES AUDIT FEES ELEC. & WATER OFFICE OFFICE RENOVATION / MAINTENANCE
0 0 0 12,000 0 12,000 6,000 24,000 12,000 24,000 0 0 12,000 12,000 45,000 60,000 0 0 0 0
% OF YEAR 2013 % OF YEAR 2014 % OF YEAR 2015 % OF YEAR 2016 INCREASE INCREASE INCREASE INCREASE 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 6,600 10.00% 7,260 15.00% 8,349 15.00% 9,601 10.00% 26,400 10.00% 29,040 15.00% 33,396 15.00% 38,405 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 26,400 10.00% 29,040 15.00% 33,396 15.00% 38,405 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 49,500 10.00% 54,450 15.00% 62,618 15.00% 72,010 10.00% 66,000 10.00% 72,600 15.00% 83,490 15.00% 96,014 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 Page 14 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED GENERAL EXPESES
YEAR 2012 GENERAL EXPENSES
OFFICE EQUIPMENT MAINTENANCE COMPUTER & SOFTWARE MAINTENANCE REPAIRS AND MAINTENANCE - GENERAL MEDICAL EXPENSES OFFICE REFRESHEMENT EXPENSES DISCOUNT ALLOWED PRIOR YEAR EXPENSES GENERAL EXPENSES LICENSE AND REGISTRATION EXP NEWSPAPER & PERIODICALS EXPENSES DELIVERY CHARGES EXPORT EXPENSES PENALITY BAD DEBTS DAMAGE GOODS LOSS ON SALE OF FIXED ASSET
% OF YEAR 2013 % OF YEAR 2014 % OF YEAR 2015 % OF YEAR 2016 INCREASE INCREASE INCREASE INCREASE 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 12,000 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 0 10.00% 0 15.00% 0 15.00% 0 3,000 10.00% 3,300 10.00% 3,630 15.00% 4,175 15.00% 4,801 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 12,000 10.00% 13,200 10.00% 14,520 15.00% 16,698 15.00% 19,203 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 10.00% 0 10.00% 0 15.00% 0 15.00% 0 270,600 297,660 342,309 393,655
TOTAL GENERAL EXPENSES
246,000
Page 15
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED DEPRECIATION DETAILS
SR NO DESCRIPITION 1 PARTICULARS % OF DEP 15.00% 10,000 10,000 1,500 1,500 8,500 15.00% 0 0 0 0 0 20.00% 0 0 0 0 0 33.33% 161,000 161,000 53,666 53,666 107,334 53,666 107,332 53,668 53,668 161,000 0 161,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,500 3,000 7,000 1,500 4,500 5,500 1,500 6,000 4,000 1,500 7,500 2,500 10,000 10,000 10,000 YEAR 2012 YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
FURNITURE & FIXTURES - OFFICE OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE FURNITURE & FIXTURES - HOUSE OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE OFFICE EQUIPMENTS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE COMPUTER EQUIPMENTS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE
2
3
4
Page 16
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED DEPRECIATION DETAILS
SR NO DESCRIPITION 5 PARTICULARS % OF DEP 20.00% 0 0 0 0 0 20.00% 0 0 0 0 0 20.00% 0 0 0 0 0 5.00% 8,212,500 8,212,500 Page 17 410,625 410,625 7,801,875 410,625 821,250 7,391,250 410,625 1,231,875 6,980,625 410,625 1,642,500 6,570,000 410,625 2,053,125 6,159,375 8,212,500 8,212,500 8,212,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 YEAR 2012 YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
WORKSHOP EQUIPMENTS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE LEASE HOLD IMPROVEMENTS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE MOTOR VECHILES OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE PLANT & MACHINERRY OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE
6
7
8
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED DEPRECIATION DETAILS
SR NO DESCRIPITION 9 PARTICULARS % OF DEP 5.00% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 YEAR 2012 YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
LAND & BUILDINGS OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE SUMMARY OPENING VALUE ADDITIONS DELETIONS DEPRECIATION ACCU DEPRECIATION NET BOOK VALUE
0 8,383,500 0 465,791 465,791 7,917,709
8,383,500 0 0 465,791 931,582 7,451,918
8,383,500 0 0 465,793 1,397,375 6,986,125
8,222,500 0 0 412,125 1,648,500 6,574,000
8,222,500 0 0 412,125 2,060,625 6,161,875
Page 18
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED ASSET DETAILS
SR NO 1 2 3 TOTAL FURNITURE & FIXTURES - HOUSE 1 2 3 TOTAL OFFICE EQUIPMENTS 1 2 3 4 TOTAL COMPUTER EQUIPMENTS 1 2 3 4 5 TOTAL WORKSHOP EQUIPMENTS 1 2 3 TOTAL LEASE HOLD IMPROVEMENTS TOOLS MISC EQUIPMENTS 0 0 0 0 Page 19 LAPTOP - 1 COMPUTER - 2 SOFTWARE ( TECH DISCLOSURE FEE ) PRINTER 5,000 10,000 146,000 0 161,000 PHOTOCOPY MACHINE FAX MACHINE NET WORKING TELEPHONE SETS 0 0 0 0 0 HOUSE FURNITURE 0 0 0 0 DESCRIPITION FURNITURE & FIXTURES - OFFICE OFFICE FURNITURE 10,000 0 0 10,000 NAME OF THE ASSET COST OF THE ASSET
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED ASSET DETAILS
SR NO 1 2 3 MOTOR VECHILES 1 2 3 TOTAL PLANT & MACHINERRY 1 2 3 TOTAL LAND & BUILDINGS 1 2 3 TOTAL NET TOTAL CONSTRUCTION COST OF BLDG 0 0 0 0 8,383,500 Page 20 MACHINERRY - DPLC INSTALLATION CHRG 6 MONTHS ASSISTANCE 8,212,500 0 0 8,212,500 PICKUP 2 TRAILER 1 FORKLIFT 2 0 0 0 0 DESCRIPITION NAME OF THE ASSET OFFICE FURNISHING MISCELLANOUS WORKS TOTAL COST OF THE ASSET 0 0 0 0
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED CASH FLOW
YEAR 2012 CASH FLOW SATEMENT OPERATING ACTIVITIES NET OPERATING PROFIT / LOSS DEPRECIATION AMORTIZATION INCREASE / (DECREASE) IN CURRENT ASSET INCREASE / (DECREASE) IN CURRENT LIABILITY NET CASH FLOW FROM OPERATING ACTIVITY INVESTING ACTIVITY COST OF FIXED ASSET NET CASH FLOW USED IN INVESTING ACTIVITY FINANCING ACTIVITIES CAPITAL BROUGHT IN NET MOVEMENT IN PARTNERS LOAN A/C NET MOVEMENT IN PARTNERS CURRENT A/C NET CASH FLOW FROM FINACING ACTIVITY YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
1,116,054 465,791 -250,000 1,331,845
1,424,790 465,791
2,051,417 465,793
2,935,466 412,125
3,957,695 412,125
1,890,581
2,517,210
3,347,591
4,369,820
-8,383,500 -8,383,500
0
0
0
0
1,500,000
1,500,000
0
0
0
0
INCREASE / (DECREASE ) IN CASH / CASH EQUIVALENTS OPENING CASH / CASH EQUIVALENTS CLOSING CASH / CASH EQUIVALENTS CASH EQUIVALENTS AS ON YEAR END CASH IN HAND CASH AT BANK
-5,551,655 0 -5,551,655
1,890,581 -5,551,655 -3,661,074
2,517,210 -3,661,074 -1,143,863
3,347,591 -1,143,863 2,203,728
4,369,820 2,203,728 6,573,548
0
0
0
0
0
Page 21
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED RATIO ANALYSIS
DESCRIPITION GROSS PROFIT RATIO NET OPERATING PROFIT RATIO ( Before Depreciation & Other Income ) NET PROFIT RATIO RETURN ON INVESTMENT YEAR 2012 21% 18% YEAR 2013 22% 19% YEAR 2014 24% 21% YEAR 2015 26% 24% YEAR 2016 28% 26%
13% 0.74
14% 0.95
17% 1.37
21% 1.96
23% 2.64
Page 22
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
RETURN ON INVESTMENT CHART
3.00
2.50
2.00
1.50
1.00
0.50
0.00
YEAR 2012
YEAR 2013
YEAR 2014
YEAR 2015
YEAR 2016
Page 23
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED BREAKEVEN ANALYSIS
YEAR 2012 SALE VARIABLE COST ( Material Cost / Labour / Overhead ) CONTRIBUTION (Amount of Sale - Associated Variable Cost ) PROFIT VOLUME RATIO ( Contribution / Sales ) FIXED COST (Rent, Salary, Depreciation, Etc) BREAK EVEN POINT - SALE BREAK EVEN POINT - % MARGIN OF SAFETY - % MARGIN OF SAFETY - SALE 8,584,800 6,756,955 YEAR 2013 9,872,520 7,711,339 YEAR 2014 11,847,024 9,032,154 YEAR 2015 14,216,429 10,526,529 YEAR 2016 17,059,715 12,296,239
1,827,845
2,161,181
2,814,870
3,689,900
4,763,476
0.21
0.22
0.24
0.26
0.28
246,000
270,600
297,660
342,309
393,655
1,155,383 0.13 0.87 7,429,417
1,236,132 0.13 0.87 8,636,388
1,252,770 0.11 0.89 10,594,254
1,318,846 0.09 0.91 12,897,582
1,409,821 0.08 0.92 15,649,894
Page 24
PROPOSED PRODUCT STUDY FOR LOUVERS & DAMPERS
BACK TO INDEX
PROJECTED OPERATING DATA
YEAR 2012 YEAR 2013 YEAR 2014 YEAR 2015 YEAR 2016
DAYS SALES IN ACCOUNTS RECEIVABLE DAYS MATERIALS COST IN INVENTORY DAYS FINISHED GOODS IN INVENTORY DAYS MATERIALS COST IN PAYBLES
90 45 15 60
90 45 15 60
90 45 15 60
90 45 15 60
90 45 15 60
Chart Title
100 80 60 40 20 0 YEAR 2012
DAYS SALES IN ACCOUNTS RECEIVABLE
YEAR 2013
YEAR 2014
YEAR 2015
YEAR 2016
DAYS MATERIALS COST IN PAYBLES
DAYS MATERIALS COST IN INVENTORY
DAYS FINISHED GOODS IN INVENTORY
Page 25
doc_470154790.xls