January February March Cash Sales
January February March Cash Sales
January February March Cash Sales
(Less)
(2) Water and Light 126,709.00 126,709.00 126,709.00
(3) Communication 2,000.00 2,000.00 2,000.00
(4) Salaries and Wages 37,670.00 37,670.00 37,670.00
(5) Raw Materials (Contingency for food) 200.00 200.00 200.00
(6) Depreciation: Furnitures and Fixtures 178.39 178.39 178.39
(7) Depreciation: Machinery and Equipments 4,711.11 4,711.11 4,711.11
(8) Depreciation: Tool and Utensils 297.50 297.50 297.50
(9) Depreciation: Transportation Equipments 1,611.11 1,611.11 1,611.11
(10) Depreciation: Building and Building Equipments 64.31 64.31 64.31
(11) Depreciation: Office Equipments 536.81 536.81 536.81
(12) Advertising 300.00 300.00 300.00
(13) Transportation (For errands) 500.00 500.00 500.00
(14) Sales Tax 110,240.00 176,384.00 308,672.00
Month Sales
January 1,378,000.00
February 2,204,800.00
March 3,858,400.00
April 3,858,400.00
May 4,409,600.00
June 4,960,800.00
July 5,512,000.00
August 5,512,000.00
September 3,307,200.00
October 3,858,400.00
November 5,512,000.00
December 5,512,000.00
Total
Year 1 49,883,600.00
Year 2 50,881,272.00
Year 3 51,898,897.44
*The Company assumes that there will be a 2% increase in sales for year 2 and
3.The annual increase percentage in sale is based on the assumption that the
demand of the product will increase also.
(2) Water and Electricity
49,883,600.00 4,156,966.67
Monthly average
Month sales Electricity @3%
January 4,156,966.67 124,709.00
February 4,156,966.67 124,709.00
March 4,156,966.67 124,709.00
April 4,156,966.67 124,709.00
May 4,156,966.67 124,709.00
June 4,156,966.67 124,709.00
July 4,156,966.67 124,709.00
August 4,156,966.67 124,709.00
September 4,156,966.67 124,709.00
October 4,156,966.67 124,709.00
November 4,156,966.67 124,709.00
December 4,156,966.67 124,709.00
Total 41,569,666.67 1,496,508.00
Month Water
January 2,000.00
February 2,000.00
March 2,000.00
April 2,000.00
May 2,000.00 Assume that there will be increase 2% increase in Lig
June 2,000.00
July 2,000.00
August 2,000.00
September 2,000.00
October 2,000.00
November 2,000.00
December 2,000.00
Total 24,000.00 Year 1
Total electricity and water for 12 months: 1,520,508.00
Total electricity and water for the first 3 months: 380,127.00
MONTHLY ELECTRICITY AND WATER 126,709.00
Year 1
Since the worker giving their best, the owner provided a 200 allowance for food
Carrying
Depreciation Depreciation Amount of Depreciation
Year
Percentage Per Year Furniture Per Month
and Fixtures
Carrying
Amount of
Depreciation Depreciation Depreciation
Year Machinery
Percentage Per Year Per Month
and
Equipment
Beginning Balance 169,600.00
1 33% 56,533.33 113,066.67 4,711.11
2 33% 56,533.33 56,533.33 4,711.11
3 33% 56,533.33 - 4,711.11
Carrying
Amount of
Depreciation Depreciation Depreciation
Year Transportati
Percentage Per Year Per Month
on
Equipment
Beginning Balance 58,000.00
1 33% 19,333.33 38,666.67 1,611.11
2 33% 19,333.33 19,333.33 1,611.11
3 33% 19,333.33 - 1,611.11
Carrying
Amount of
Depreciation Depreciation Building and Depreciation
Year
Percentage Per Year Building Per Month
Improvement
s
Carrying
Depreciation Depreciation Amount of Depreciation
Year
Percentage Per Year Office Per Month
Equipment
Beginning Balance 19,325.00
1 33% 6,441.67 12,883.33 536.81
2 33% 6,441.67 6,441.67 536.81
3 33% 6,441.67 - 536.81
(12) Advertising 300.00
Year 1 3,600.00
YEAR 2 and 3 SALES TAX assumed that there will be increase of sale of 2% as for the year 2 & 3 also with
Year 2 Year 3
1,550,918.16 1,581,936.52