際際滷

際際滷Share a Scribd company logo

income@balance sheet

Download as DOCX, PDF
Muhammad Islam
Muhammad Islam

This document provides a summary of the projected costs, revenue, and financials for an auto and mechanical manufacturing workshop over a 10 year period. It outlines the capital costs of machinery, equipment, and other assets totaling over $1.3 million. It also details the projected annual revenue of over $8.6 million in year 1 from services like sheet metal fabrication and machining operations. The financial projections show increasing revenue, profits, and positive cash flows each year with a cumulative net profit of over $42 million by year 10.

1 of 3
Download to read offline
Auto & Mechanical Manufacturing Workshop: PROJECT COST SUMMARY: 1. Production / Repair Sr. No Description No of pieces handled in Year 1 1 Sheet Metal Blanking Die Set No: 1 180,000 2 Sheet Metal Forming Die Set No: 2 120,000 3 Sheet Metal Stamping Die Set No: 3 144000 4 Putting threads on bolts 15000 5 Sheet metal fabrication work 150 Total 459,150 2. Project Cost Capital Investment Amount Rs. Second Hand / Rebuilt Machinery 1,150,000 Second hand Office Equipment 51,000 Furniture & Fixtures 50,000 Pre-operating Cost 75,000 Total Capital Costs 1,326,000 Working Capital 874,000 Total Investment 2,200,000 3. Machinery and Equipment Requirement List of Machinery and Equipment-Second Hand Sr. No Description Quantity Unit Cost (Rs.) Cum Cost (Rs.) 1 Stamping Machines 3 150,000 450,000 2 Mechanical Hacksaw 1 85,000 85,000 3 16 inch Disc Cutter 1 28,000 28,000 4 Lathe Machine 5 ft bed length 1 100,000 100,000 5 Welding Plant 1 50,000 50,000 6 Horizontal & Vertical Milling Machine 1 200,000 200,000 7 Mechanical Shaper 12 inch stroke 1 105,000 105,000 8 Diesel Genset 6 KVA 1 50,000 50,000 9 Steel Inspection 1 50,000 50,000 10 Measuring Instruments Total 1 32,000 32,000 1,150,000 4. Office Equipment (Second Hand) Sr. No Description Quantity Unit Cost (Rs.) 1 Computer 1 20,000 2 printer 1 10,000 3 Telefax machine 1 5500 4 Refrigerator 1 14,500 5 Telephone 1 1000 Total 51000 5. Raw Materials Used Steel Products Foundry & Forge Products Angle Irons As Cast castings Round bars As Forge castings Hexagonal bars Forgings Flat bars High Tensile bars to make bolts Hardware = Nuts,bolts,washers Cast iron plugs for Engine Block recovery Sheet Metal Imported Cast iron weld supports Sheet Metal galvanized Aluminium Alloy parts Welding Rods Gun metal washers
6. Human Resource Requirement Sr. No Description No of Persons Salary per Month (Rs.) Salary per Annum (Rs) 1 Owner manager 1 50,000 600,000 2 Machinist 1 15,000 180,000 3 Welder 1 18,000 216,000 4 Press operation 1 12,000 144,000 5 Helper 1 10,000 240,000 Total 1,380,000 7. Revenue Generation Sr. No. Category of Services Cost (Rs.) Price / piece (Rs.) Qty Revenue (Rs.) 1 Blanking 10 20 90,000 1,800,000 2 Forming 30 45 60,000 2,700,000 3 Stamping 10 15 72,000 1,080,000 4 Putting threads on high tensile bolts 3 10 75,000 75,000 5 Sheet metal 15,000 40,000 75 3,000,000 Total 8,655,000 8. Utility Costs per annum Sr. No Description Mfg/mth(Rs) Cost / Annum(Rs 1 Electricity 45000/15000 540,000 2 Natural gas 5000/2000 60,000 3 Tel,fax 10000/5000 120,000 4 Postage /starty 2000/500 24,000 5 Water/sewerage 500/400 6000 6 Entertainment 5000/9000 60,000 7 Diesel fuel 36000 432,000 Total 1,242,000 Income Statement Revenue Statement Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 8,655,000 11,424,600 14,661,570 18,431,688 22,809,214 27,877,928 30,665,721 33,732,293 37,105,522 40,816,075 Cost of sales Raw Material 4,567,500 6,029,100 7,737,345 9,726,948 12,037,098 14,712,009 16,183,210 17,801,531 19,581,684 21,539,852 Consumables 456,750 602,910 773,735 972,695 1,203,710 1,471,201 1,618,321 1,780,153 1,958,168 2,153,985 Labour Cost 780,000 858,000 943,800 1,038,180 1,141,998 1,256,198 1,381,818 1,519,999 1,671,999 1,839,199 Diesel Expense 432,000 475,200 522,720 574,992 632,491 695,740 765,314 841,846 926,030 1,018,633 Gas Expense 60,000 66,000 72,600 79,860 87,846 96,631 106,294 116,923 128,615 141,477 Water Expens 6,000 6,600 7,260 7,986 8,785 9,663 10,629 11,692 12,862 14,148 Electricity 540,000 594,000 653,400 718,740 790,614 869,675 956,643 1,052,307 1,157,538 1,273,292 Total cost 6,842,250 8,631,810 10,710,860 13,119,401 15,902,542 19,111,117 21,022,229 23,124,451 25,436,897 27,980,586 Gross Profit 1,812,750 2,792,790 3,950,711 5,312,287 6,906,672 8,766,811 9,643,492 10,607,842 11,668, 626 12,835,488 General administration & selling expenses Admin expns 600,000 660,000 726,000 798,600 878,460 966,306 1,062,937 1,169,230 1,286,153 1,414,769 Rent expense 240,000 264,000 290,400 319,440 351,384 386,522 425,175 467,692 514,461 565,907 Conicat expns 120,000 132,000 145,200 159,720 175,692 193,261 212, 587 233,846 257,231 282,954 Stationary 24,000 25,200 26,460 27,783 29,172 30,631 32,162 33,770 35,459 37,232 Entetinment 60,000 63,000 66,150 69,458 72,930 76,577 80,406 84,426 88,647 93,080 Pmotion ex 15,000 13,500 12,150 10,935 9,842 8,857 7,972 7,174 6,457 5,811 Dep expns 142,000 142,000 142,000 144,680 144,680 147,442 150,544 150,544 150,544 154,135 Mis exp 12,000 13,200 14,520 15,972 17,569 19,326 21,259 23,385 25,723 28,295 Subtotal 1,228,000 1,327,900 1,437,880 1,561,587 1,694,729 1,828,923 1,993,041 2,170,068 2,364,676 2,582,183
Operat Inco 584,750 1,464,890 2,512,831 3,750,700 5,211,943 6,937,888 7,650,451 8,437,773 9,303,950 10,253,305 E BI T 584,750 1,464,890 2,512,831 3,750,700 5,211,943 6,937,888 7,650,451 8,437,773 9,303,950 10,253,305 Interest exp 164,339 150,454 132,204 112,440 91,036 67,855 42,749 15,561 - - Subtotal 164,339 150,454 132,204 112,440 91,036 67,855 42,749 15,561 - - E BT 420,411 1,314,436 2,380,626 3,638,260 5,120,908 6,870,033 7,607,702 8,422,213 9,303,950 10,253,305 Tax 2,041 119,665 323,625 632,065 1,058,772 1,627,011 1,885,195 2,170,274 2,478,882 2,811,156 NPAT 418,370 1,194,771 2,057,001 3,006,195 4,062,136 5,243,022 5,722,507 6,251,939 6,825,068 7,442,149 Balance Sheet Year0 Year1 Year2 Year3 Year4 Year5 Year6 Year7 Year8 Year9 Year 10 Assets Current assets Cash 283,812 655,038 1,656,601 3,664,067 6,864,140 11,470,844 17,729,122 24,906,819 32,846,541 41,994,941 52,117,553 Accounts receivable 355,685 469,504 602,530 757,467 937,365 1,145,668 1,260,235 1,386,259 1,524,884 1,677,373 Raw material 570,188 418,688 552,668 709,257 891,637 1,103,401 1,348,601 1,483,461 1,631,807 1,794,988 1,974,48 Prepaid building rent 20,000 22,000 24,200 26,620 29,282 32,210 35,431 38,974 42,872 47,159 - Total Current Asset 874,000 1,451,411 2,702,972 5,002,474 8,542,526 13,543,820 20,258,822 27,689,489 35,907,478 45,361,973 55,769,413 Fixed assets Equipment 1,150,000 1,035,000 920,000 805,000 690,000 575,000 460,000 345,000 230,000 115,000 Furniture 50,000 40,000 30,000 20,000 10,000 63,814 51,051 38,288 25,526 12,763 Cafe equipment 51,000 34,000 17,000 59,039 39,359 19,680 68,345 45,563 22,782 79,118 52,745 TFA 1,251,000 1,109,000 967,000 884,039 739,359 658,494 579,396 428,852 278,307 206,881 52,745 Intangible assets Pre-operation cost 75,000 60,000 45,000 30,000 15,000 - - - - - - Total asset 2,200,000 2,620,411 3,714,972 5,916,513 9,296,885 14,202,314 20,838,218 28,118,341 36,185,786 45,568,853 55,822,158 Liabilities & Shareholders' Equity Assets Deferred tax 2,041 121,706 445,331 1,077,396 2,136,168 3,763,179 5,648,374 7,818,648 10,297,529 13,108,685 Long term debt 1,980,000 1,980,000 1,760,125 1,522,001 1,264,113 984,821 682,347 354,768 - - - TLTL 1,980,000 1,982,041 1,881,831 1,967,333 2,341,509 3,120,989 4,445,526 6,003,142 7,818,648 10,297,529 13,108,685 Shareholders' equity Paid-up capital 220,000 220,000 220,000 279,039 279,039 342,853 411,198 411,198 411,198 490,316 490,316 Retain earning 418,370 1,613,141 3,670,142 6,676,337 10,738,472 15,981,495 21,704,001 27,955,940 34,781,008 42,223,157 Total Equity 220,000 638,370 1,833,141 3,949,181 6,955,376 11,081,325 16,392,693 22,115,199 28,367,138 35,271,324 42,713,473 TCAL 2,200,000 2,620,411 3,714,972 5,916,513 9,296,885 14,202,314 20,838,218 28,118,341 36,185,786 45,568,853 55,822,158

More Related Content

income@balance sheet

  • 1. Auto & Mechanical Manufacturing Workshop: PROJECT COST SUMMARY: 1. Production / Repair Sr. No Description No of pieces handled in Year 1 1 Sheet Metal Blanking Die Set No: 1 180,000 2 Sheet Metal Forming Die Set No: 2 120,000 3 Sheet Metal Stamping Die Set No: 3 144000 4 Putting threads on bolts 15000 5 Sheet metal fabrication work 150 Total 459,150 2. Project Cost Capital Investment Amount Rs. Second Hand / Rebuilt Machinery 1,150,000 Second hand Office Equipment 51,000 Furniture & Fixtures 50,000 Pre-operating Cost 75,000 Total Capital Costs 1,326,000 Working Capital 874,000 Total Investment 2,200,000 3. Machinery and Equipment Requirement List of Machinery and Equipment-Second Hand Sr. No Description Quantity Unit Cost (Rs.) Cum Cost (Rs.) 1 Stamping Machines 3 150,000 450,000 2 Mechanical Hacksaw 1 85,000 85,000 3 16 inch Disc Cutter 1 28,000 28,000 4 Lathe Machine 5 ft bed length 1 100,000 100,000 5 Welding Plant 1 50,000 50,000 6 Horizontal & Vertical Milling Machine 1 200,000 200,000 7 Mechanical Shaper 12 inch stroke 1 105,000 105,000 8 Diesel Genset 6 KVA 1 50,000 50,000 9 Steel Inspection 1 50,000 50,000 10 Measuring Instruments Total 1 32,000 32,000 1,150,000 4. Office Equipment (Second Hand) Sr. No Description Quantity Unit Cost (Rs.) 1 Computer 1 20,000 2 printer 1 10,000 3 Telefax machine 1 5500 4 Refrigerator 1 14,500 5 Telephone 1 1000 Total 51000 5. Raw Materials Used Steel Products Foundry & Forge Products Angle Irons As Cast castings Round bars As Forge castings Hexagonal bars Forgings Flat bars High Tensile bars to make bolts Hardware = Nuts,bolts,washers Cast iron plugs for Engine Block recovery Sheet Metal Imported Cast iron weld supports Sheet Metal galvanized Aluminium Alloy parts Welding Rods Gun metal washers
  • 2. 6. Human Resource Requirement Sr. No Description No of Persons Salary per Month (Rs.) Salary per Annum (Rs) 1 Owner manager 1 50,000 600,000 2 Machinist 1 15,000 180,000 3 Welder 1 18,000 216,000 4 Press operation 1 12,000 144,000 5 Helper 1 10,000 240,000 Total 1,380,000 7. Revenue Generation Sr. No. Category of Services Cost (Rs.) Price / piece (Rs.) Qty Revenue (Rs.) 1 Blanking 10 20 90,000 1,800,000 2 Forming 30 45 60,000 2,700,000 3 Stamping 10 15 72,000 1,080,000 4 Putting threads on high tensile bolts 3 10 75,000 75,000 5 Sheet metal 15,000 40,000 75 3,000,000 Total 8,655,000 8. Utility Costs per annum Sr. No Description Mfg/mth(Rs) Cost / Annum(Rs 1 Electricity 45000/15000 540,000 2 Natural gas 5000/2000 60,000 3 Tel,fax 10000/5000 120,000 4 Postage /starty 2000/500 24,000 5 Water/sewerage 500/400 6000 6 Entertainment 5000/9000 60,000 7 Diesel fuel 36000 432,000 Total 1,242,000 Income Statement Revenue Statement Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 8,655,000 11,424,600 14,661,570 18,431,688 22,809,214 27,877,928 30,665,721 33,732,293 37,105,522 40,816,075 Cost of sales Raw Material 4,567,500 6,029,100 7,737,345 9,726,948 12,037,098 14,712,009 16,183,210 17,801,531 19,581,684 21,539,852 Consumables 456,750 602,910 773,735 972,695 1,203,710 1,471,201 1,618,321 1,780,153 1,958,168 2,153,985 Labour Cost 780,000 858,000 943,800 1,038,180 1,141,998 1,256,198 1,381,818 1,519,999 1,671,999 1,839,199 Diesel Expense 432,000 475,200 522,720 574,992 632,491 695,740 765,314 841,846 926,030 1,018,633 Gas Expense 60,000 66,000 72,600 79,860 87,846 96,631 106,294 116,923 128,615 141,477 Water Expens 6,000 6,600 7,260 7,986 8,785 9,663 10,629 11,692 12,862 14,148 Electricity 540,000 594,000 653,400 718,740 790,614 869,675 956,643 1,052,307 1,157,538 1,273,292 Total cost 6,842,250 8,631,810 10,710,860 13,119,401 15,902,542 19,111,117 21,022,229 23,124,451 25,436,897 27,980,586 Gross Profit 1,812,750 2,792,790 3,950,711 5,312,287 6,906,672 8,766,811 9,643,492 10,607,842 11,668, 626 12,835,488 General administration & selling expenses Admin expns 600,000 660,000 726,000 798,600 878,460 966,306 1,062,937 1,169,230 1,286,153 1,414,769 Rent expense 240,000 264,000 290,400 319,440 351,384 386,522 425,175 467,692 514,461 565,907 Conicat expns 120,000 132,000 145,200 159,720 175,692 193,261 212, 587 233,846 257,231 282,954 Stationary 24,000 25,200 26,460 27,783 29,172 30,631 32,162 33,770 35,459 37,232 Entetinment 60,000 63,000 66,150 69,458 72,930 76,577 80,406 84,426 88,647 93,080 Pmotion ex 15,000 13,500 12,150 10,935 9,842 8,857 7,972 7,174 6,457 5,811 Dep expns 142,000 142,000 142,000 144,680 144,680 147,442 150,544 150,544 150,544 154,135 Mis exp 12,000 13,200 14,520 15,972 17,569 19,326 21,259 23,385 25,723 28,295 Subtotal 1,228,000 1,327,900 1,437,880 1,561,587 1,694,729 1,828,923 1,993,041 2,170,068 2,364,676 2,582,183
  • 3. Operat Inco 584,750 1,464,890 2,512,831 3,750,700 5,211,943 6,937,888 7,650,451 8,437,773 9,303,950 10,253,305 E BI T 584,750 1,464,890 2,512,831 3,750,700 5,211,943 6,937,888 7,650,451 8,437,773 9,303,950 10,253,305 Interest exp 164,339 150,454 132,204 112,440 91,036 67,855 42,749 15,561 - - Subtotal 164,339 150,454 132,204 112,440 91,036 67,855 42,749 15,561 - - E BT 420,411 1,314,436 2,380,626 3,638,260 5,120,908 6,870,033 7,607,702 8,422,213 9,303,950 10,253,305 Tax 2,041 119,665 323,625 632,065 1,058,772 1,627,011 1,885,195 2,170,274 2,478,882 2,811,156 NPAT 418,370 1,194,771 2,057,001 3,006,195 4,062,136 5,243,022 5,722,507 6,251,939 6,825,068 7,442,149 Balance Sheet Year0 Year1 Year2 Year3 Year4 Year5 Year6 Year7 Year8 Year9 Year 10 Assets Current assets Cash 283,812 655,038 1,656,601 3,664,067 6,864,140 11,470,844 17,729,122 24,906,819 32,846,541 41,994,941 52,117,553 Accounts receivable 355,685 469,504 602,530 757,467 937,365 1,145,668 1,260,235 1,386,259 1,524,884 1,677,373 Raw material 570,188 418,688 552,668 709,257 891,637 1,103,401 1,348,601 1,483,461 1,631,807 1,794,988 1,974,48 Prepaid building rent 20,000 22,000 24,200 26,620 29,282 32,210 35,431 38,974 42,872 47,159 - Total Current Asset 874,000 1,451,411 2,702,972 5,002,474 8,542,526 13,543,820 20,258,822 27,689,489 35,907,478 45,361,973 55,769,413 Fixed assets Equipment 1,150,000 1,035,000 920,000 805,000 690,000 575,000 460,000 345,000 230,000 115,000 Furniture 50,000 40,000 30,000 20,000 10,000 63,814 51,051 38,288 25,526 12,763 Cafe equipment 51,000 34,000 17,000 59,039 39,359 19,680 68,345 45,563 22,782 79,118 52,745 TFA 1,251,000 1,109,000 967,000 884,039 739,359 658,494 579,396 428,852 278,307 206,881 52,745 Intangible assets Pre-operation cost 75,000 60,000 45,000 30,000 15,000 - - - - - - Total asset 2,200,000 2,620,411 3,714,972 5,916,513 9,296,885 14,202,314 20,838,218 28,118,341 36,185,786 45,568,853 55,822,158 Liabilities & Shareholders' Equity Assets Deferred tax 2,041 121,706 445,331 1,077,396 2,136,168 3,763,179 5,648,374 7,818,648 10,297,529 13,108,685 Long term debt 1,980,000 1,980,000 1,760,125 1,522,001 1,264,113 984,821 682,347 354,768 - - - TLTL 1,980,000 1,982,041 1,881,831 1,967,333 2,341,509 3,120,989 4,445,526 6,003,142 7,818,648 10,297,529 13,108,685 Shareholders' equity Paid-up capital 220,000 220,000 220,000 279,039 279,039 342,853 411,198 411,198 411,198 490,316 490,316 Retain earning 418,370 1,613,141 3,670,142 6,676,337 10,738,472 15,981,495 21,704,001 27,955,940 34,781,008 42,223,157 Total Equity 220,000 638,370 1,833,141 3,949,181 6,955,376 11,081,325 16,392,693 22,115,199 28,367,138 35,271,324 42,713,473 TCAL 2,200,000 2,620,411 3,714,972 5,916,513 9,296,885 14,202,314 20,838,218 28,118,341 36,185,786 45,568,853 55,822,158