Copy of Financial Aspect-manufacturing_cash Transactions Only

Manufacturing Manufacturing Business

TOTAL PROJECT COST

Fixed Assets/ Capital Investment Investments s Factory Building Improvements Factory & Office Machines Factory Vehicle Factory, Selling & Office Equipment Office & Selling Fur Furniture and Fix Fixtures Sub-Total Add: 10% contingency contingency

500,000.00 300,000.00 500,000.00 125,000.00 100,000.00 1,525,000.00 152,500.00

1,677,500.00

8,000.00 80,000.00 80,000.00 101,666.67 3,000.00 192,666.67 19,266.67

211,933.33

Pre-Operating & Operating Expenses Permits and licenses Advance rental rental & deposits Purchases - Raw Materials Factory, selling & office supplies Sub-Total Add: 10% contingency contingency

TOTAL PROJECT COST

1,889,433.33

OR

Fixed Assets/ Capital Investment Investments s Factory Building Improvements Factory & Office Machines Factory Vehicle Factory, Selling & Office Equipment Office & Selling Furniture and Fixtures

500,000.00 300,000.00 500,000.00 125,000.00 100,000.00

Pre-Operating Expenses Permits and licenses Advance rental rental & deposits Purchases - Raw Materials Factory, selling & office supplies

Total Add: 10% contingency TOTAL PROJECT COST

8,000.00 80,000.00 80,000.00 101,666.67 3,000.00 1,717,666.67 171,766.67 1,889,433.33

Manufacturing Business

ABC MANUFACTURING Projected Cash Flow Statement Five-Year Period Pre-Operating CASH INFLOWS: Capital, beginning Net Sales Total CASH OUTFLOWS: Factory Bldg Improvements Factory & Office Machines Factory Vehicle Factory & Office Equipment Office Furniture and Fixtures Purchases-Raw Materials Permits and licenses Rental (advances & deposits) Supplies Salaries and wages SSS & Philhealth Light Water Communications Transportation-office Delivery expenses Repair & Maintenance Income Tax Withdrawals Miscellaneous-office expenses Total NET CASH FLOW Add: Cash balance, beginning CASH BALANCE, END

Year 1

Year 2

Year 3

Year 4

Year 5

1,889,433.33 1,889,433.33

1,629,250.00 1,629,250.00

1,967,319.38 1,967,319.38

2,276,744.50 2,276,744.50

2,629,875.65 2,629,875.65

3,037,518.76 3,037,518.76

500,000.00 300,000.00 500,000.00 125,000.00 100,000.00 101,666.67 8,000.00 80,000.00 3,000.00 1,717,666.67 171,766.67 171,766.67

508,333.33 200,000.00 33,000.00 480,000.00 35,958.00 84,000.00 14,400.00 21,600.00 18,000.00 30,000.00 20,000.00 12,000.00 1,457,291.33 171,958.67 171,766.67 343,725.33

660,500.00 10,000.00 264,000.00 39,600.00 480,000.00 35,958.00 92,400.00 15,840.00 23,760.00 19,800.00 33,000.00 30,500.00 20,000.00 12,000.00 1,737,358.00 229,961.38 343,725.33 573,686.71

726,525.00 11,000.00 290,400.00 43,560.00 528,000.00 39,553.80 101,640.00 17,424.00 26,136.00 21,780.00 36,300.00 33,550.00 20,383.12 20,000.00 12,000.00 1,928,251.92 348,492.58 573,686.71 922,179.29

799,151.25 12,100.00 319,440.00 47,916.00 528,000.00 39,553.80 111,804.00 19,166.40 28,749.60 23,958.00 39,930.00 36,905.00 54,797.06 20,000.00 12,000.00 2,093,471.11 536,404.55 922,179.29 1,458,583.83

879,038.81 13,310.00 351,384.00 52,707.60 580,800.00 43,509.18 122,984.40 21,083.04 31,624.56 26,353.80 43,923.00 40,595.50 121,407.53 20,000.00 12,000.00 2,360,721.43 676,797.33 1,458,583.83 2,135,381.16


Notes: 1 2 3 4 5 6 7

Purchases-Raw Materials Adavance rental & deposits Supplies Salaries and wages SSS & Philhealth Light, water, transportation repair and maintenance

equivalent to 2 months stock (P 610,000 / 12 x 2 months) 2 months advance and 2 months deposit (P 20,000 per month) total of factory, selling and administrative (see schedule for breakdown) refer to schedule for breakdown refer to schedule for breakdown refer to schedule for breakdown assumed at 2% of fixed assets (refer to schedule for breakdown)


Notes: 1 2 3 4 5 6 7

Purchases-Raw Materials Adavance rental & deposits Supplies Salaries and wages SSS & Philhealth Light, water, transportation repair and maintenance

equivalent to 2 months stock (P 610,000 / 12 x 2 months) 2 months advance and 2 months deposit (P 20,000 per month) total of factory, selling and administrative (see schedule for breakdown) refer to schedule for breakdown refer to schedule for breakdown refer to schedule for breakdown assumed at 2% of fixed assets (refer to schedule for breakdown)

ABC MANUFACTURING Statement of Cost of Goods Manufactured Five-Year Period

Year 1 Direct Materials Direct Labor Manufacturing Overhead Rental Supplies SSS & Philhealth Light Water Communications Depreciation Repair and Maintenance Manufacturing Costs Add: Work-in-Process, beginning Total Cost of Goods Placed in Process Less: Work-in-Process, ending Cost of Goods Manufactured Manufacturing Cost

Year 2

Year 3

Year 4

Year 5

600,000.00 120,000.00

660,000.00 120,000.00

726,000.00 132,000.00

798,600.00 132,000.00

878,460.00 145,200.00

120,000.00 5,400.00 9,019.20 50,400.00 8,640.00 5,400.00 105,428.57 1,024,287.77 1,024,287.77 20,000.00 1,004,287.77

132,000.00 5,940.00 9,019.20 55,440.00 9,504.00 5,940.00 105,428.57 26,600.00 1,129,871.77 20,000.00 1,149,871.77 20,000.00 1,129,871.77

145,200.00 6,534.00 9,921.12 60,984.00 10,454.40 6,534.00 105,428.57 29,260.00 1,232,316.09 20,000.00 1,252,316.09 20,000.00 1,232,316.09

159,720.00 7,187.40 9,921.12 67,082.40 11,499.84 7,187.40 105,428.57 32,186.00 1,330,812.73 20,000.00 1,350,812.73 20,000.00 1,330,812.73

175,692.00 7,906.14 10,913.23 73,790.64 12,649.82 7,906.14 105,428.57 35,404.60 1,453,351.15 20,000.00 1,473,351.15 20,000.00 1,453,351.15

1,024,287.77

1,129,871.77

1,232,316.09

1,330,812.73

1,453,351.15

ABC MANUFACTURING Statement of Cost of Goods Manufactured Five-Year Period

Year 1 Direct Materials Direct Labor Manufacturing Overhead Rental Supplies SSS & Philhealth Light Water Communications Depreciation Repair and Maintenance Manufacturing Costs Add: Work-in-Process, beginning Total Cost of Goods Placed in Process Less: Work-in-Process, ending Cost of Goods Manufactured Manufacturing Cost Annual production in units

Year 2

Year 3

Year 4

Year 5

600,000.00 120,000.00

660,000.00 120,000.00

726,000.00 132,000.00

798,600.00 132,000.00

878,460.00 145,200.00

120,000.00 5,400.00 9,019.20 50,400.00 8,640.00 5,400.00 105,428.57 1,024,287.77 1,024,287.77 20,000.00 1,004,287.77

132,000.00 5,940.00 9,019.20 55,440.00 9,504.00 5,940.00 105,428.57 26,600.00 1,129,871.77 20,000.00 1,149,871.77 20,000.00 1,129,871.77

145,200.00 6,534.00 9,921.12 60,984.00 10,454.40 6,534.00 105,428.57 29,260.00 1,232,316.09 20,000.00 1,252,316.09 20,000.00 1,232,316.09

159,720.00 7,187.40 9,921.12 67,082.40 11,499.84 7,187.40 105,428.57 32,186.00 1,330,812.73 20,000.00 1,350,812.73 20,000.00 1,330,812.73

175,692.00 7,906.14 10,913.23 73,790.64 12,649.82 7,906.14 105,428.57 35,404.60 1,453,351.15 20,000.00 1,473,351.15 20,000.00 1,453,351.15

1,024,287.77 3,500.00

1,129,871.77 3,850.00

1,232,316.09 4,235.00

1,330,812.73 4,658.50

1,453,351.15 5,124.35

292.65

293.47

290.98

285.67

283.62

Unit Production Cost Note/s:

1 There is no work-in-process beginning in year 1. 2 Work-in-process ending is estimated at P 20,000 every year.


ABC MANUFACTURING Projected Income Statement Five-Year Period Year 1 Revenues Sales less: Sales Returns & Allow. Net Sales Cost of Sales Finished Goods, beginning Add: Cost of Goods Manufactured Cost of goods available for sale Less: Finished Goods, ending Gross Income Operating Expenses Selling & Administrattive Expenses Permits and licenses Rental Supplies Salaries and wages SSS & Philhealth Light Water Communications Transportation-office Delivery expenses Depreciation Repair and Maintenance Miscellaneous-office expenses Total

1,662,500.00 33,250.00 1,629,250.00

%

Year 2

100%

2,007,468.75 40,149.38 1,967,319.38

1,004,287.77 1,004,287.77 51,214.39 953,073.38 676,176.62

0% 62% 62% 3% 58% 42%

8,000.00 120,000.00 30,600.00 360,000.00 26,938.80 33,600.00 5,760.00 16,200.00 18,000.00 30,000.00 23,464.29 12,000.00 684,563.09

0% 7% 2% 22% 2% 2% 0% 1% 1% 2% 1% 0% 1% 42%

%

Year 3

100%

2,323,208.67 46,464.17 2,276,744.50

51,214.39 1,129,871.77 1,181,086.16 59,061.48 1,122,024.68 845,294.69

3% 57% 60% 3% 57% 43%

10,000.00 132,000.00 33,660.00 360,000.00 26,938.80 36,960.00 6,336.00 17,820.00 19,800.00 33,000.00 23,464.29 3,900.00 12,000.00 715,879.09

1% 7% 2% 18% 1% 2% 0% 1% 1% 2% 1% 0% 1% 36%

%

Year 4

100%

2,683,546.58 53,670.93 2,629,875.65

59,061.48 1,232,316.09 1,291,377.57 64,543.83 1,226,833.74 1,049,910.76

3% 54% 57% 3% 54% 46%

11,000.00 145,200.00 37,026.00 396,000.00 29,632.68 40,656.00 6,969.60 19,602.00 21,780.00 36,300.00 23,464.29 4,290.00 12,000.00 783,920.57

0% 6% 2% 17% 1% 2% 0% 1% 1% 2% 1% 0% 1% 34%

%

Year 5

%

100%

3,099,508.94 61,990.18 3,037,518.76

100%

64,543.83 1,330,812.73 1,395,356.56 69,708.94 1,325,647.62 1,304,228.03

2% 51% 53% 3% 50% 50%

69,708.94 1,453,351.15 1,523,060.09 76,127.90 1,446,932.19 1,590,586.57

2% 48% 50% 3% 48% 52%

12,100.00 159,720.00 40,728.60 396,000.00 29,632.68 44,721.60 7,666.56 21,562.20 23,958.00 39,930.00 23,464.29 4,719.00 12,000.00 816,202.93

0% 6% 2% 15% 1% 2% 0% 1% 1% 2% 1% 0% 0% 31%

13,310.00 175,692.00 44,801.46 435,600.00 32,595.95 49,193.76 8,433.22 23,718.42 26,353.80 43,923.00 23,464.29 5,190.90 12,000.00 894,276.79

0% 6% 1% 14% 1% 2% 0% 1% 1% 1% 1% 0% 0% 29%


ABC MANUFACTURING Projected Income Statement Five-Year Period Year 1 Revenues Sales less: Sales Returns & Allow. Net Sales Cost of Sales Finished Goods, beginning Add: Cost of Goods Manufactured Cost of goods available for sale Less: Finished Goods, ending Gross Income Operating Expenses Selling & Administrattive Expenses Permits and licenses Rental Supplies Salaries and wages SSS & Philhealth Light Water Communications Transportation-office Delivery expenses Depreciation Repair and Maintenance Miscellaneous-office expenses Total Net Income before Tax Less: Income Tax NET INCOME

Notes: 1 Sales and Sales returns 2 finished goods inventory & cost of goods manufactured 3 operating expenses

1,662,500.00 33,250.00 1,629,250.00

%

Year 2

100%

2,007,468.75 40,149.38 1,967,319.38

1,004,287.77 1,004,287.77 51,214.39 953,073.38 676,176.62

0% 62% 62% 3% 58% 42%

8,000.00 120,000.00 30,600.00 360,000.00 26,938.80 33,600.00 5,760.00 16,200.00 18,000.00 30,000.00 23,464.29 12,000.00 684,563.09 (8,386.47) (8,386.47)

0% 7% 2% 22% 2% 2% 0% 1% 1% 2% 1% 0% 1% 42% -1% 0% -1%

%

Year 3

100%

2,323,208.67 46,464.17 2,276,744.50

51,214.39 1,129,871.77 1,181,086.16 59,061.48 1,122,024.68 845,294.69

3% 57% 60% 3% 57% 43%

10,000.00 132,000.00 33,660.00 360,000.00 26,938.80 36,960.00 6,336.00 17,820.00 19,800.00 33,000.00 23,464.29 3,900.00 12,000.00 715,879.09 129,415.61 20,383.12 109,032.49

1% 7% 2% 18% 1% 2% 0% 1% 1% 2% 1% 0% 1% 36% 7% 1% 6%

%

Year 4

%

100%

2,683,546.58 53,670.93 2,629,875.65

59,061.48 1,232,316.09 1,291,377.57 64,543.83 1,226,833.74 1,049,910.76

3% 54% 57% 3% 54% 46%

11,000.00 145,200.00 37,026.00 396,000.00 29,632.68 40,656.00 6,969.60 19,602.00 21,780.00 36,300.00 23,464.29 4,290.00 12,000.00 783,920.57 265,990.19 54,797.06 211,193.13

0% 6% 2% 17% 1% 2% 0% 1% 1% 2% 1% 0% 1% 34% 12% 2% 9%

Year 5

%

100%

3,099,508.94 61,990.18 3,037,518.76

100%

64,543.83 1,330,812.73 1,395,356.56 69,708.94 1,325,647.62 1,304,228.03

2% 51% 53% 3% 50% 50%

69,708.94 1,453,351.15 1,523,060.09 76,127.90 1,446,932.19 1,590,586.57

2% 48% 50% 3% 48% 52%

12,100.00 159,720.00 40,728.60 396,000.00 29,632.68 44,721.60 7,666.56 21,562.20 23,958.00 39,930.00 23,464.29 4,719.00 12,000.00 816,202.93 488,025.11 121,407.53 366,617.58

0% 6% 2% 15% 1% 2% 0% 1% 1% 2% 1% 0% 0% 31% 19% 5% 14%

13,310.00 175,692.00 44,801.46 435,600.00 32,595.95 49,193.76 8,433.22 23,718.42 26,353.80 43,923.00 23,464.29 5,190.90 12,000.00 894,276.79 696,309.78 187,819.13 508,490.65

0% 6% 1% 14% 1% 2% 0% 1% 1% 1% 1% 0% 0% 29% 23% 6% 17%

refer to schedule refer to schedule refer to schedule


ABC MANUFACTURING Projected Income Statement Five-Year Period Year 1 Revenues Sales less: Sales Returns & Allow. Net Sales Cost of Sales Finished Goods, beginning Add: Cost of Goods Manufactured Cost of goods available for sale Less: Finished Goods, ending Gross Income Operating Expenses Selling & Administrattive Expenses Permits and licenses Rental Supplies Salaries and wages SSS & Philhealth Light Water Communications Transportation-office Delivery expenses Depreciation Repair and Maintenance Miscellaneous-office expenses Total

Year 2

Year 3

Year 4

Year 5

1,662,500.00 33,250.00 1,629,250.00

2,007,468.75 40,149.38 1,967,319.38

2,323,208.67 46,464.17 2,276,744.50

2,683,546.58 53,670.93 2,629,875.65

3,099,508.94 61,990.18 3,037,518.76

1,004,287.77 1, 004,287.77 51,214.39 953,073.38 676,176.62

51,214.39 1,129,871.77 1,181,086.16 59,061.48 1,122,024.68 845,294.69

59,061.48 1,232,316.09 1,291,377.57 64,543.83 1,226,833.74 1,049,910.76

64,543.83 1,330,812.73 1,395,356.56 69,708.94 1,325,647.62 1,304,228.03

69,708.94 1,453,351.15 1,523,060.09 76,127.90 1,446,932.19 1,590,586.57

8,000.00 120,000.00 30,600.00 360,000.00 26,938.80 33,600.00 5,760.00 16,200.00 18,000.00 30,000.00 23,464.29 12,000.00 684,563.09

10,000.00 132,000.00 33,660.00 360,000.00 26,938.80 36,960.00 6,336.00 17,820.00 19,800.00 33,000.00 23,464.29 3,900.00 12,000.00 715,879.09

11,000.00 145,200.00 37,026.00 396,000.00 29,632.68 40,656.00 6,969.60 19,602.00 21,780.00 36,300.00 23,464.29 4,290.00 12,000.00 783,920.57

12,100.00 159,720.00 40,728.60 396,000.00 29,632.68 44,721.60 7,666.56 21,562.20 23,958.00 39,930.00 23,464.29 4,719.00 12,000.00 816,202.93

13,310.00 175,692.00 44,801.46 435,600.00 32,595.95 49,193.76 8,433.22 23,718.42 26,353.80 43,923.00 23,464.29 5,190.90 12,000.00 894,276.79


ABC MANUFACTURING Projected Income Statement Five-Year Period Year 1 Revenues Sales less: Sales Returns & Allow. Net Sales Cost of Sales Finished Goods, beginning Add: Cost of Goods Manufactured Cost of goods available for sale Less: Finished Goods, ending

Year 3

Year 4

Year 5

1,662,500.00 33,250.00 1,629,250.00

2,007,468.75 40,149.38 1,967,319.38

2,323,208.67 46,464.17 2,276,744.50

2,683,546.58 53,670.93 2,629,875.65

3,099,508.94 61,990.18 3,037,518.76

1,004,287.77 1, 004,287.77 51,214.39 953,073.38 676,176.62

51,214.39 1,129,871.77 1,181,086.16 59,061.48 1,122,024.68 845,294.69

59,061.48 1,232,316.09 1,291,377.57 64,543.83 1,226,833.74 1,049,910.76

64,543.83 1,330,812.73 1,395,356.56 69,708.94 1,325,647.62 1,304,228.03

69,708.94 1,453,351.15 1,523,060.09 76,127.90 1,446,932.19 1,590,586.57

10,000.00 132,000.00 33,660.00 360,000.00 26,938.80 36,960.00 6,336.00 17,820.00 19,800.00 33,000.00 23,464.29 3,900.00 12,000.00 715,879.09 129,415.61 20,383.12 109,032.49

11,000.00 145,200.00 37,026.00 396,000.00 29,632.68 40,656.00 6,969.60 19,602.00 21,780.00 36,300.00 23,464.29 4,290.00 12,000.00 783,920.57 265,990.19 54,797.06 211,193.13

12,100.00 159,720.00 40,728.60 396,000.00 29,632.68 44,721.60 7,666.56 21,562.20 23,958.00 39,930.00 23,464.29 4,719.00 12,000.00 816,202.93 488,025.11 121,407.53 366,617.58

13,310.00 175,692.00 44,801.46 435,600.00 32,595.95 49,193.76 8,433.22 23,718.42 26,353.80 43,923.00 23,464.29 5,190.90 12,000.00 894,276.79 696,309.78 187,819.13 508,490.65

Gross Income Operating Expenses Selling & Administrattive Expenses Permits and licenses Rental Supplies Salaries and wages SSS & Philhealth Light Water Communications Transportation-office Delivery expenses Depreciation Repair and Maintenance Miscellaneous-office expenses Total Net Income before Tax Less: Income Tax NET INCOME

Notes: 1 Sales and Sales returns 2 finished goods inventory & cost of goods manufactured 3 operating expenses

Year 2

8,000.00 120,000.00 30,600.00 360,000.00 26,938.80 33,600.00 5,760.00 16,200.00 18,000.00 30,000.00 23,464.29 12,000.00 684,563.09 (8,386.47) (8,386.47)

refer to schedule refer to schedule refer to schedule

ABC MANUFACTURING Projected Balance Sheet Five-Year Period Pre-Operating

Year 1

Year 2

Year 3

Year 4

Year 5

171,766.67 101,666.67 91,000.00 364,433.33

343,725.33 10,000.00 20,000.00 51,214.39 40,000.00 464,939.72

573,686.71 10,500.00 20,000.00 59,061.48 40,000.00 703,248.19

922,179.29 11,025.00 20,000.00 64,543.83 40,000.00 1,057,748.11

1,458,583.83 11,576.25 20,000.00 69,708.94 40,000.00 1,599,869.02

2,135,381.16 12,155.06 20,000.00 76,127.90 40,000.00 2,283,664.13

500,000.00 500,000.00

500,000.00 18,000.00 482,000.00

500,000.00 36,000.00 464,000.00

500,000.00 54,000.00 446,000.00

500,000.00 72,000.00 428,000.00

500,000.00 90,000.00 410,000.00

Machines less: Accumulated Depreciation

300,000.00 300,000.00

300,000.00 38,571.43 261,428.57

300,000.00 77,142.86 222,857.14

300,000.00 115,714.29 184,285.71

300,000.00 154,285.71 145,714.29

300,000.00 192,857.14 107,142.86

Transportation Vehicle less: Accumulated Depreciation

500,000.00 500,000.00

500,000.00 45,000.00 455,000.00

500,000.00 90,000.00 410,000.00

500,000.00 135,000.00 365,000.00

500,000.00 180,000.00 320,000.00

500,000.00 225,000.00 275,000.00

Equipment less: Accumulated Depreciation

125,000.00 125,000.00

125,000.00 16,071.43 108,928.57

125,000.00 32,142.86 92,857.14

125,000.00 48,214.29 76,785.71

125,000.00 64,285.71 60,714.29

125,000.00 80,357.14 44,642.86

ASSETS CURRENT Cash Raw Materials Inventory Work-in-Process Inventory Finished Goods Inventory Prepaid Expenses Total NON-CURRENT Building Improvements less: Accumulated Depreciation

ABC MANUFACTURING Projected Balance Sheet Five-Year Period Pre-Operating

Year 1

Year 2

Year 3

Year 4

Year 5

171,766.67 101,666.67 91,000.00 364,433.33

343,725.33 10,000.00 20,000.00 51,214.39 40,000.00 464,939.72

573,686.71 10,500.00 20,000.00 59,061.48 40,000.00 703,248.19

922,179.29 11,025.00 20,000.00 64,543.83 40,000.00 1,057,748.11

1,458,583.83 11,576.25 20,000.00 69,708.94 40,000.00 1,599,869.02

2,135,381.16 12,155.06 20,000.00 76,127.90 40,000.00 2,283,664.13

500,000.00 500,000.00

500,000.00 18,000.00 482,000.00

500,000.00 36,000.00 464,000.00

500,000.00 54,000.00 446,000.00

500,000.00 72,000.00 428,000.00

500,000.00 90,000.00 410,000.00

Machines less: Accumulated Depreciation

300,000.00 300,000.00

300,000.00 38,571.43 261,428.57

300,000.00 77,142.86 222,857.14

300,000.00 115,714.29 184,285.71

300,000.00 154,285.71 145,714.29

300,000.00 192,857.14 107,142.86

Transportation Vehicle less: Accumulated Depreciation

500,000.00 500,000.00

500,000.00 45,000.00 455,000.00

500,000.00 90,000.00 410,000.00

500,000.00 135,000.00 365,000.00

500,000.00 180,000.00 320,000.00

500,000.00 225,000.00 275,000.00

Equipment less: Accumulated Depreciation

125,000.00 125,000.00

125,000.00 16,071.43 108,928.57

125,000.00 32,142.86 92,857.14

125,000.00 48,214.29 76,785.71

125,000.00 64,285.71 60,714.29

125,000.00 80,357.14 44,642.86

Furniture and Fixture less: Accumulated Depreciation

100,000.00 100,000.00

100,000.00 11,250.00 88,750.00

100,000.00 22,500.00 77,500.00

100,000.00 33,750.00 66,250.00

100,000.00 45,000.00 55,000.00

100,000.00 56,250.00 43,750.00

1,525,000.00

1,396,107.14

1,267,214.29

1,138,321.43

1,009,428.57

880,535.71

1,889,433.33

1,861,046.86

1,970,462.47

2,196,069.54

2,609,297.59

3,164,199.84

ASSETS CURRENT Cash Raw Materials Inventory Work-in-Process Inventory Finished Goods Inventory Prepaid Expenses Total NON-CURRENT Building Improvements less: Accumulated Depreciation

Total TOTAL ASSETS LIABILITIES AND CAPITAL LIABILITIES


Income Tax Payable

CAPITAL ABC Capital, beginning Add: Net Income Total Less: Withdrawals

TOTAL LIABILITIES AND CAPITAL

-

1,889,433.33 1,889,433.33 1,889,433.33 1,889,433.33

-

1,889,433.33 (8,386.47) 1,881,046.86 20,000.00 1,861,046.86 1,861,046.86

20,383.12 20,383.12

54,797.06 54,797.06

121,407.53 121,407.53

187,819.13 187,819.13

1,881,046.86 109,032.49 1,990,079.35 40,000.00 1,950,079.35

1,990,079.35 211,193.13 2,201,272.48 60,000.00 2,141,272.48

2,201,272.48 366,617.58 2,567,890.06 80,000.00 2,487,890.06

2,567,890.06 508,490.65 3,076,380.71 100,000.00 2,976,380.71

1,970,462.47

2,196,069.54

2,609,297.59

3,164,199.84

Income Tax Payable

-

CAPITAL ABC Capital, beginning Add: Net Income Total Less: Withdrawals

TOTAL LIABILITIES AND CAPITAL

-

1,889,433.33 1,889,433.33 1,889,433.33 1,889,433.33

1,889,433.33 (8,386.47) 1,881,046.86 20,000.00 1,861,046.86 1,861,046.86

20,383.12 20,383.12

54,797.06 54,797.06

121,407.53 121,407.53

187,819.13 187,819.13

1,881,046.86 109,032.49 1,990,079.35 40,000.00 1,950,079.35

1,990,079.35 211,193.13 2,201,272.48 60,000.00 2,141,272.48

2,201,272.48 366,617.58 2,567,890.06 80,000.00 2,487,890.06

2,567,890.06 508,490.65 3,076,380.71 100,000.00 2,976,380.71

1,970,462.47

2,196,069.54

2,609,297.59

3,164,199.84



Schedule 1

Raw Materials Requirement Yr 1 Daily requirements in units (sacks) Working days per year Annual requirements Increase per year (10%) Total Purchase price per sack Cost of Raw Materials

Schedule 2

Yr 3

Yr 4

Yr 5

3,000.00 200.00 600,000.00

10.00 300.00 3,000.00 300.00 3,300.00 200.00 660,000.00

10.00 300.00 3,000.00 630.00 3,630.00 200.00 726,000.00

10.00 300.00 3,000.00 993.00 3,993.00 200.00 798,600.00

10.00 300.00 3,000.00 1,392.30 4,392.30 200.00 878,460.00

610,000.00 610,000.00 10,000.00 600,000.00

10,000.00 660,500.00 670,500.00 10,500.00 660,000.00

10,500.00 726,525.00 737,025.00 11,025.00 726,000.00

11,025.00 799,151.25 810,176.25 11,576.25 798,600.00

11,576.25 879,038.81 890,615.06 12,155.06 878,460.00

Employer

Employer

Raw Materials Inventory - Ending Beginning balance Add: Purchases Total available for use Less: RM, ending Raw Materials Used

Schedule 3

10.00 300.00 3,000.00

Yr 2

Salaries and Wages No.

Mo. Salary

Annual

Total


Schedule 1

Raw Materials Requirement Yr 1 Daily requirements in units (sacks) Working days per year Annual requirements Increase per year (10%) Total Purchase price per sack Cost of Raw Materials

Schedule 2

Yr 3

Yr 4

Yr 5

3,000.00 200.00 600,000.00

10.00 300.00 3,000.00 300.00 3,300.00 200.00 660,000.00

10.00 300.00 3,000.00 630.00 3,630.00 200.00 726,000.00

10.00 300.00 3,000.00 993.00 3,993.00 200.00 798,600.00

10.00 300.00 3,000.00 1,392.30 4,392.30 200.00 878,460.00

610,000.00 610,000.00 10,000.00 600,000.00

10,000.00 660,500.00 670,500.00 10,500.00 660,000.00

10,500.00 726,525.00 737,025.00 11,025.00 726,000.00

11,025.00 799,151.25 810,176.25 11,576.25 798,600.00

11,576.25 879,038.81 890,615.06 12,155.06 878,460.00

Raw Materials Inventory - Ending Beginning balance Add: Purchases Total available for use Less: RM, ending Raw Materials Used

Schedule 3

10.00 300.00 3,000.00

Yr 2

Salaries and Wages No.

Direct Labor Worker 1 Worker 2

1 1 2

Mo. Salary

5,000.00 5,000.00 10,000.00

Annual Salary

60,000.00 60,000.00 120,000.00

Employer Share (Philhealth) 750.00 750.00 1,500.00

Employer Share (SSS) 3,759.60 3,759.60 7,519.20

Total Employer's Share 4,509.60 4,509.60 9,019.20


Salaries and Wages Selling Sales employee 1 Sales employee 2

Schedule 4

1 1 2

5,000.00 5,000.00 10,000.00

60,000.00 60,000.00 120,000.00

750.00 750.00 1,500.00

3,759.60 3,759.60 7,519.20

4,509.60 4,509.60 9,019.20

General & Administrative General Manager 1 Office employee 1 1 Office employee 2 1 3

10,000.00 5,000.00 5,000.00 20,000.00

120,000.00 60,000.00 60,000.00 240,000.00

1,500.00 750.00 750.00 3,000.00

7,400.40 3,759.60 3,759.60 14,919.60

8,900.40 4,509.60 4,509.60 17,919.60

Distribution of Cost

Permits and licenses Rental Supplies Salaries and wages SSS & Philhealth Light

Total Expenses (Year 1)

Factory

8,000.00 240,000.00 36,000.00 480,000.00 35,958.00 84,000.00

120,000.00 5,400.00 120,000.00 9,019.20 50,400.00

Selling

60,000.00 18,000.00 120,000.00 9,019.20 16,800.00

General/ Administrative

8,000.00 60,000.00 12,600.00 240,000.00 17,919.60 16,800.00


Salaries and Wages Selling Sales employee 1 Sales employee 2

Schedule 4

1 1 2

5,000.00 5,000.00 10,000.00

60,000.00 60,000.00 120,000.00

750.00 750.00 1,500.00

3,759.60 3,759.60 7,519.20

4,509.60 4,509.60 9,019.20

General & Administrative General Manager 1 Office employee 1 1 Office employee 2 1 3

10,000.00 5,000.00 5,000.00 20,000.00

120,000.00 60,000.00 60,000.00 240,000.00

1,500.00 750.00 750.00 3,000.00

7,400.40 3,759.60 3,759.60 14,919.60

8,900.40 4,509.60 4,509.60 17,919.60

Distribution of Cost

Permits and licenses Rental Supplies Salaries and wages SSS & Philhealth Light Water Communications Transportation-office Delivery expenses Miscellaneous-office expenses Total

Schedule 5

Total Expenses (Year 1)

Factory

8,000.00 240,000.00 36,000.00 480,000.00 35,958.00 84,000.00 14,400.00 21,600.00 18,000.00 30,000.00 12,000.00

120,000.00 5,400.00 120,000.00 9,019.20 50,400.00 8,640.00 5,400.00 318,859.20

Selling

General/ Administrative

60,000.00 18,000.00 120,000.00 9,019.20 16,800.00 2,880.00 10,800.00 30,000.00 267,499.20

8,000.00 60,000.00 12,600.00 240,000.00 17,919.60 16,800.00 2,880.00 5,400.00 18,000.00 12,000.00 393,599.60

Depreciation


Cost

Factory Bldg Improvements Machine 1 Vehicle Equipment 1 Total

Selling Equipment 2 Furniture & Fixture 1

Office Machine 2 Equipment 3 Furniture & Fixture 2

TOTAL Schedule 6

Repair and Maintenance

Salvage Value (10% of cost)

Depreciable Value

Estimated Useful Life

Annual Depreciation

500,000.00 250,000.00 500,000.00 80,000.00 1,330,000.00

50,000.00 25,000.00 50,000.00 8,000.00 133,000.00

450,000.00 225,000.00 450,000.00 72,000.00 1,197,000.00

25 7 10 7

18,000.00 32,142.86 45,000.00 10,285.71 105,428.57

20,000.00 30,000.00 50,000.00

2,000.00 3,000.00 5,000.00

18,000.00 27,000.00 45,000.00

7 8

2,571.43 3,375.00 5,946.43

50,000.00 25,000.00 70,000.00 145,000.00

5,000.00 2,500.00 7,000.00 14,500.00

45,000.00 22,500.00 63,000.00 130,500.00

7 7 8

6,428.57 3,214.29 7,875.00 17,517.86

1,525,000.00

152,500.00

1,372,500.00

128,892.86


Cost

Factory Bldg Improvements Machine 1 Vehicle Equipment 1 Total

Annual Depreciation

450,000.00 225,000.00 450,000.00 72,000.00 1,197,000.00

25 7 10 7

18,000.00 32,142.86 45,000.00 10,285.71 105,428.57

20,000.00 30,000.00 50,000.00

2,000.00 3,000.00 5,000.00

18,000.00 27,000.00 45,000.00

7 8

2,571.43 3,375.00 5,946.43

50,000.00 25,000.00 70,000.00 145,000.00

5,000.00 2,500.00 7,000.00 14,500.00

45,000.00 22,500.00 63,000.00 130,500.00

7 7 8

6,428.57 3,214.29 7,875.00 17,517.86

1,525,000.00

152,500.00

1,372,500.00

128,892.86

Repair and Maintenance Yr 1 Factory Selling Office

Schedule 7

Estimated Useful Life

50,000.00 25,000.00 50,000.00 8,000.00 133,000.00

Office Machine 2 Equipment 3 Furniture & Fixture 2

Schedule 6

Depreciable Value

500,000.00 250,000.00 500,000.00 80,000.00 1,330,000.00

Selling Equipment 2 Furniture & Fixture 1

TOTAL

Salvage Value (10% of cost)

Yr 2 -

26,600.00 1,000.00 2,900.00 30,500.00

Yr 3 29,260.00 1,100.00 3,190.00 33,550.00

Yr 4 32,186.00 1,210.00 3,509.00 36,905.00

Yr 5 35,404.60 1,331.00 3,859.90 40,595.50

Sales & Finished Goods Inventory Yr 1

Yr 2

Yr 3

Yr 4

Yr 5


Beginning balance Add: Production units Total Less: Ending Balance Finished Goods Sold Selling Price Sales Finished Goods, ending (units) x Cost per unit Finished Goods, ending (amount)

3,500.00 3,500.00 175.00 3,325.00

175.00 3,850.00 4,025.00 201.25 3,823.75

201.25 4,235.00 4,436.25 221.81 4,214.44

221.81 4,658.50 4,880.31 244.02 4,636.30

244.02 5,124.35 5,368.37 268.42 5,099.95

500.00 1,662,500.00

525.00 2,007,468.75

551.25 2,323,208.67

578.81 2,683,546.58

607.75 3,099,508.94

175.00 292.65 51,214.39

201.25 293.47 59,061.48

221.81 290.98 64,543.83

244.02 285.67 69,708.94

268.42 283.62 76,127.90

175.00 292.65 51,214.39

201.25 293.47 59,061.48

221.81 290.98 64,543.83

244.02 285.67 69,708.94

Finished Goods, beg. (units) x Cost per unit Finished Goods, beg. (amount)

Schedule 8

-

Sales Breakdown Yr 1 Sales less: SR & A Net Sales

100% 2% 98%

1,662,500.00 33,250.00 1,629,250.00

Yr 2

Yr 3

Yr 4

Yr 5

2,007,468.75 40,149.38 1,967,319.38

2,323,208.67 46,464.17 2,276,744.50

2,683,546.58 53,670.93 2,629,875.65

3,099,508.94 61,990.18 3,037,518.76


Beginning balance Add: Production units Total Less: Ending Balance Finished Goods Sold Selling Price Sales Finished Goods, ending (units) x Cost per unit Finished Goods, ending (amount)

3,500.00 3,500.00 175.00 3,325.00

175.00 3,850.00 4,025.00 201.25 3,823.75

201.25 4,235.00 4,436.25 221.81 4,214.44

221.81 4,658.50 4,880.31 244.02 4,636.30

244.02 5,124.35 5,368.37 268.42 5,099.95

500.00 1,662,500.00

525.00 2,007,468.75

551.25 2,323,208.67

578.81 2,683,546.58

607.75 3,099,508.94

175.00 292.65 51,214.39

201.25 293.47 59,061.48

221.81 290.98 64,543.83

244.02 285.67 69,708.94

268.42 283.62 76,127.90

175.00 292.65 51,214.39

201.25 293.47 59,061.48

221.81 290.98 64,543.83

244.02 285.67 69,708.94

Finished Goods, beg. (units) x Cost per unit Finished Goods, beg. (amount)

Schedule 8

-

Sales Breakdown Yr 1 Sales less: SR & A Net Sales

Schedule 9

100% 2% 98%

1,662,500.00 33,250.00 1,629,250.00

Yr 2

Yr 3

Yr 4

Yr 5

2,007,468.75 40,149.38 1,967,319.38

2,323,208.67 46,464.17 2,276,744.50

2,683,546.58 53,670.93 2,629,875.65

3,099,508.94 61,990.18 3,037,518.76

Permits and Licenses DTI permit Mayor's permit BIR registration fees Total

500.00 7,000.00 500.00 8,000.00


Schedule 10 Advance Rental and Deposits Monthly Rental Two months advance Two months deposit Total advance rental & deposits

20,000.00 40,000.00 40,000.00 80,000.00

Schedule 11 Income Tax Yr 1 Net Income before Tax Tax on P 10,000 & less Tax on P 70,000 Tax on P 250,000 Tax on P 500,000 Tax on excess Total Tax Payable Net Income after Tax

Yr 2

(8,386.47)

129,415.61

Yr 3

Yr 4

265,990.19

488,025.11

50,000.00

50,000.00

4,797.06 54,797.06 211,193.13

71,407.53 121,407.53 366,617.58

Yr 5 696,309.78

8,500.00

(8,386.47)

11,883.12 20,383.12 109,032.49

125,000.00 62,819.13 187,819.13 508,490.65


Schedule 10 Advance Rental and Deposits Monthly Rental Two months advance Two months deposit Total advance rental & deposits

20,000.00 40,000.00 40,000.00 80,000.00

Schedule 11 Income Tax Yr 1 Net Income before Tax Tax on P 10,000 & less Tax on P 70,000 Tax on P 250,000 Tax on P 500,000 Tax on excess Total Tax Payable Net Income after Tax

Yr 2

(8,386.47)

129,415.61

Yr 3

Yr 4

Yr 5

265,990.19

488,025.11

696,309.78

50,000.00

50,000.00

(8,386.47)

11,883.12 20,383.12 109,032.49

4,797.06 54,797.06 211,193.13

71,407.53 121,407.53 366,617.58

125,000.00 62,819.13 187,819.13 508,490.65

20,000.00 20,000.00

20,000.00 20,000.00 40,000.00

40,000.00 20,000.00 60,000.00

60,000.00 20,000.00 80,000.00

80,000.00 20,000.00 100,000.00

8,500.00

Schedule 12 Withdrawals (Drawings) Withdrawal, beginning Add: Withdrawal for the year Withdrawals, ending


ASSUMPTIONS UNDERLYING PROJECTIONS 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13.

Total sales are composed of 90% cash sales and 10% credit sales. Sales returns and allowances are estimated at 2% of total sales. Raw materials (in units) will increase by 5% per year. Finished Goods inventory is estimated at 5% of the total cost of goods available for sale. Permits and licenses will increase by 10% starting year 2. Rentals, office supplies, electricity, water, communication and transportation expenses will increase by 10% per year. Salaries will increase by 10% every after 2 years. Repair and maintenance will start in year 2. This will increase by 10% per year. Depreciation is computed using the straight-line method. Salvage value is estimated at 10% of the acquisition cost. Miscellaneous expenses are estimated at P 12,000 per year. Income tax for the year will be paid the following year.


ASSUMPTIONS UNDERLYING PROJECTIONS 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13.

Total sales are composed of 90% cash sales and 10% credit sales. Sales returns and allowances are estimated at 2% of total sales. Raw materials (in units) will increase by 5% per year. Finished Goods inventory is estimated at 5% of the total cost of goods available for sale. Permits and licenses will increase by 10% starting year 2. Rentals, office supplies, electricity, water, communication and transportation expenses will increase by 10% per year. Salaries will increase by 10% every after 2 years. Repair and maintenance will start in year 2. This will increase by 10% per year. Depreciation is computed using the straight-line method. Salvage value is estimated at 10% of the acquisition cost. Miscellaneous expenses are estimated at P 12,000 per year. Income tax for the year will be paid the following year.

Copy of Financial Aspect-manufacturing_cash Transactions Only

Recommend Documents