MUGS AND MINDS CAFE

Statement of Owner's Equity

For the Period as Indicated

Notes Year 1 Year 2 Year 3 Year 4 Year 5

Beginning, Balance 4,533,396.76 5,059,729.87 5,833,115.77 6,875,830.51

Capital
Cash 49 4,000,000.00
Total Capital 4,000,000.00 4,533,396.76 5,059,729.87 5,833,115.77 6,875,830.51

Net Income 53 533,396.76 526,333.11 773,385.90 1,042,714.74 1,342,760.88

Total

Less:
Withdrawal

Ending, Balance 30 4,533,396.76 5,059,729.87 5,833,115.77 6,875,830.51 8,218,591.39

 MUGS AND MINDS CAFE
Cash Flow Statement
For the Period as Indicated

Notes Year 1 Year 2 Year 3 Year 4 Year 5

OPERATING ACTIVITIES

Collection from Sales Receipts 32 21,711,256.51 23,882,382.16 26,270,620.38 28,897,682.42 31,787,450.66

Collection from Accouts Receiveable 33 0.00 0.00 0.00 0.00 0.00
Inflow from operating services 21,711,256.51 23,882,382.16 26,270,620.38 28,897,682.42 31,787,450.66

Paymet to Purchases (Ingredients) 34 14,807,542.09 16,288,296.30 17,917,125.93 19,708,838.52 21,679,722.37

Payment to Purchases (Supplies) 35 1,922,569.03 2,114,825.93 2,326,308.53 2,558,939.38 2,814,833.32
Payment to Salaries Expense 39 2,813,348.08 2,869,615.04 2,927,007.34 2,985,547.49 3,045,258.43
Payment to SSS, PhilHealth, Pagibig 40 121,102.80 122,313.83 123,536.97 124,772.34 126,020.06
Payment to Utilities 41 348,000.00 382,800.00 421,080.00 463,188.00 509,506.80
Payment to Repairs and Maintenance 42 579,642.00 637,606.20 701,366.82 771,503.50 848,653.85
Payment to Miscellaneous 43 12,000.00 13,200.00 14,520.00 15,972.00 17,569.20
Payment Income Tax Expense 44 63,645.32 62,313.63 131,404.80 221,544.74 321,957.71
VAT Remittance 45 547,925.99 648,379.09 717,022.04 789,041.33 867,971.89
Preoperating Permits and Licenses 46 12,862.00
Out flow from operating services 21,228,637.30 23,139,350.01 25,279,372.41 27,639,347.29 30,231,493.63

Cashflow from Operating Activities 482,619.21 743,032.15 991,247.96 1,258,335.12 1,555,957.03

INVESTING ACTIVITIES

Furnitures and Fixtures 391,351.00

Equipment 340,789.00
Building 47 1,200,000.00
Cashflow from Investing Activities 1,932,140.00 0 0 0 0

FINANCING ACTIVITIES

Capital 49 4,000,000.00
Withradawal
Cashflow from Financing Activities 4,000,000.00 0 0 0 0

Cash Balance, Beginning 2,493,226.04 3,226,498.03 4,213,510.17 5,467,787.11

Cash Balance, End 31 2,493,226.04 3,226,498.03 4,213,510.17 5,467,787.11 7,019,341.39
 MUGS AND MINDS CAFE
Income Statement
For the Period as Indicated

Preoperating Year 1 Year 2 Year 3 Year 4 Year 5

Notes Expense
Sales 1 19,105,905.73 21,016,496.30 23,118,145.93 25,429,960.53 27,972,956.58
Less: Cost of Sales 2 13,281,771.04 14,827,854.62 16,270,796.40 17,853,501.79 19,593,717.45
Gross Profit 5,824,134.69 6,188,641.68 6,847,349.53 7,576,458.73 8,379,239.13

Less:
Salaries 3 2,397,062.48 2,445,003.73 2,493,903.80 2,543,781.88 2,594,657.52
SSS, PhilHealth, Pagibig 4 103,183.46 104,215.29 105,257.44 106,310.02 107,373.12
Supplies Expense 5 1,607,267.71 1,848,357.87 2,037,211.82 2,241,133.91 2,465,257.35
Depreciation Expense - Building 6 64,800.00 64,800.00 64,800.00 64,800.00 64,800.00
Depreciation Expense - Equipment 7 23,147.28 23,147.28 23,147.28 23,147.28 23,147.28
Depreciation Expense - Furniture & Fixture 8 70,443.18 70,443.18 70,443.18 70,443.18 70,443.18
Utilities Expense 9 348,000.00 382,800.00 421,080.00 463,188.00 509,506.80
Repairs and Maintenance 11 579,642.00 637,606.20 701,366.82 771,503.50 848,653.85
Miscellaneous Expense 13 12,000.00 13,200.00 14,520.00 15,972.00 17,569.20
Total Operating Expense 14 1,423,909.91 3,794,498.20 5,589,573.55 5,931,730.35 6,300,279.77 6,701,408.30

Profit Before Tax 605,726.58 599,068.14 915,619.18 1,276,178.96 1,677,830.83

Tax Expense 44 63,645.32 62,313.63 131,404.80 221,544.74 321,957.71

Net Income 53 542,081.27 536,754.51 784,214.39 1,054,634.22 1,355,873.12

 MUGS AND MINDS CAFE
Balance Sheet
For the Period as Indicated

Notes Year 1 Year 2 Year 3 Year 4 Year 5

Cash 31 2,550,479.21 3,293,511.36 4,284,759.32 5,543,094.44 7,099,051.47
Materials Inventory, End 17 130,306.37 144,640.07 159,117.11 175,028.95 192,531.85
Finished Goods Inventory 19 134,159.30 149,776.31 164,351.48 180,338.40 197,916.34
Supplies 20 84,593.04 97,281.99 107,221.67 117,954.42 129,750.39
Total Current Asset 2,899,537.92 3,685,209.73 4,715,449.58 6,016,416.21 7,619,250.04

Furnitures and Fixtures 21 391,351.00 391,351.00 391,351.00 391,351.00 391,351.00

Less: Accumulated Depereciation 22 70,443.18 140,886.36 211,329.54 281,772.72 352,215.90
Total Book Value 320,907.82 250,464.64 180,021.46 109,578.28 39,135.10
Equipment 23 340,789.00 340,789.00 340,789.00 340,789.00 340,789.00
Less: Accumulated Depereciation 24 61,342.02 122,684.04 184,026.06 245,368.08 306,710.10
Total Book Value 279,446.98 218,104.96 156,762.94 95,420.92 34,078.90
Building 25 1,200,000.00 1,200,000.00 1,200,000.00 1,200,000.00 1,200,000.00
Less: Accumulated Depereciation 26 108,000.00 216,000.00 324,000.00 432,000.00 540,000.00
Total Book Value 1,092,000.00 984,000.00 876,000.00 768,000.00 660,000.00
Total NonCurrent Asset 1,692,354.80 1,452,569.60 1,212,784.40 972,999.20 733,214.00

Total Asset 4,591,892.72 5,137,779.33 5,928,233.98 6,989,415.41 8,352,464.04

Liabilities
VAT Payable 29 49,811.45 58,943.55 65,183.82 71,731.03 78,906.54
Total Liabilities 49,811.45 58,943.55 65,183.82 71,731.03 78,906.54

Owner's Equity 30 4,542,081.27 5,078,835.78 5,863,050.16 6,917,684.38 8,273,557.51

Total Liabilities and Owner's Equity 4,591,892.72 5,137,779.33 5,928,233.98 6,989,415.41 8,352,464.04
Mark up 70%
VAT 12%
Days Open Per Month 22
Months Open per Year 12
Yearly Increase 110%
Materials Inventory 1%
WIP inventory 0%
Finished Goods Inventory 1%

Hourly Unit Monthly

PRODUCTS Sales Cost Price Qty Cost Price
1. Americano 5 31 52.7 880 27,280.00 46,376.00
2. Cappuccino 4 40 68 704 28,160.00 47,872.00
3. Espresso 4 31 52.7 704 21,824.00 37,100.80
4. Double Espresso 4 62 105.4 704 43,648.00 74,201.60
5. Vanilla Latte 4 75 127.5 704 52,800.00 89,760.00
6. Macchiato 4 40 68 704 28,160.00 47,872.00
7. Hot Chocolate 4 60 102 704 42,240.00 71,808.00
8. Strawberry Cake 4 79.44 135.05 704 55,925.76 95,073.79
9. Chocolate Cake 4 78.38 133.25 704 55,179.52 93,805.18
10. Carrot Cake 4 50.5 85.85 704 35,552.00 60,438.40
11. Cheeseburger 4 36.5 62.05 704 25,696.00 43,683.20
12. Beef Burger 4 31.5 53.55 704 22,176.00 37,699.20
13. Chicken Burger 4 29 49.3 704 20,416.00 34,707.20
14. Bacon and Egg Sandwich 4 47.5 80.75 704 33,440.00 56,848.00
15. Vanilla Frappe 5 50 85 880 44,000.00 74,800.00
16. Chocolate Frape 5 53 90.1 880 46,640.00 79,288.00
17. Winter melon Milk Tea 5 53 90.1 880 46,640.00 79,288.00
18. Matcha Milk Tea 5 53 90.1 880 46,640.00 79,288.00
19. Red Velvet Milk Tea 5 53 90.1 880 46,640.00 79,288.00
20. Cookies & Cream Milk Tea 5 53 90.1 880 46,640.00 79,288.00
21. Okinawa Milk Tea 5 48 81.6 880 42,240.00 71,808.00
22. Taro Milk Tea 5 53.00 90.10 880 46,640.00 79,288.00
23. Chocolate Smoothie 5 42 71.4 880 36,960.00 62,832.00
24. Strawberry Smoothie 5 57 96.9 880 50,160.00 85,272.00
25. Banana Smoothie 5 42 71.4 880 36,960.00 62,832.00
26. Mango Tropics Smoothie 5 40.75 69.28 880 35,860.00 60,962.00
27. Pineapple Smoothie 5 52 88.4 880 45,760.00 77,792.00
 NOTES 1, 2, 32, 17, 18, 19, 2
Notes Year 1 Year 2 Year 3 Year 4 Year 5
Sales
Sales Cash 32 21,711,256.51 23,882,382.16 26,270,620.38 28,897,682.42 31,787,450.66
Sales on Account 0.00 0.00 0.00 0.00 0.00
Total Sales 21,711,256.51 23,882,382.16 26,270,620.38 28,897,682.42 31,787,450.66
Less: Input VAT 2,605,350.78 2,865,885.86 3,152,474.45 3,467,721.89 3,814,494.08
Net Sales 1 19,105,905.73 21,016,496.30 23,118,145.93 25,429,960.53 27,972,956.58

Direct Materials
Materials Inventory, Beginning 130,306.37 144,640.07 159,117.11 175,028.95
Puchase Materials 13,030,637.04 14,333,700.74 15,767,070.81 17,343,777.90 19,078,155.69

Total Materials Available 13,030,637.04 14,464,007.11 15,911,710.89 17,502,895.01 19,253,184.64

Less: Materials Inventory, End 17 130,306.37 144,640.07 159,117.11 175,028.95 192,531.85

Total Materials Used 12,900,330.67 14,319,367.04 15,752,593.78 17,327,866.06 19,060,652.79

Direct Materials Used 12,900,330.67 14,319,367.04 15,752,593.78 17,327,866.06 19,060,652.79

Direct Labor 434,204.94 442,709.85 451,383.06 460,227.92 469,247.86

Supplies Expense Applied 0.00 0.00 0.00 0.00 0.00

Depreciation Expense (Furniture and Fixture) 0.00 0.00 0.00 0.00 0.00
Depreciation Expense (Building) 43,200.00 43,200.00 43,200.00 43,200.00 43,200.00
Depreciation Expense (Equipment) 38,194.74 38,194.74 38,194.74 38,194.74 38,194.74
Other Applicable Expense
Manufacturing Overhead Applied 81,394.74 81,394.74 81,394.74 81,394.74 81,394.74

Total Manufacturing Cost 13,415,930.35 14,843,471.63 16,285,371.57 17,869,488.72 19,611,295.39

Work in Progress inventory, Beginning 0 0 0 0

Total Cost of Goods Placed in Process 13,415,930.35 14,843,471.63 16,285,371.57 17,869,488.72 19,611,295.39

Less: Work in Progress inventory, End 18 0 0 0 0 0

Cost of Goods Manufactured 13,415,930.35 14,843,471.63 16,285,371.57 17,869,488.72 19,611,295.39

Finished Goods Inventory, Beginning 134,159.30 149,776.31 164,351.48 180,338.40

Total Goods Available for Sale 13,415,930.35 14,977,630.93 16,435,147.88 18,033,840.20 19,791,633.79

Less: Finished Goods Inventory, End 19 134,159.30 149,776.31 164,351.48 180,338.40 197,916.34
Cost of Goods Sold 2 13,281,771.04 14,827,854.62 16,270,796.40 17,853,501.79 19,593,717.45

NOTES 34, 27, 37

Puchase Materials Notes Year 1 Year 2 Year 3 Year 4 Year 5
Cash Purchase 34 14,807,542.09 16,288,296.30 17,917,125.93 19,708,838.52 21,679,722.37
On Account Purchase 0.00 0.00 0.00 0.00 0.00
Total Purchases 14,807,542.09 16,288,296.30 17,917,125.93 19,708,838.52 21,679,722.37
Less: Input VAT 1,776,905.05 1,954,595.56 2,150,055.11 2,365,060.62 2,601,566.68
Net Purchases 13,030,637.04 14,333,700.74 15,767,070.81 17,343,777.90 19,078,155.69

Accounts Payable
Accounts Payable, Beginning 0.00 0.00 0.00 0.00
On Account Purchase 0.00 0.00 0.00 0.00 0.00
Total Accounts Payable 0.00 0.00 0.00 0.00 0.00

Accounts Payable End 27 0.00 0.00 0.00 0.00 0.00

Payment to Accounts Payable (Ingredients) 37 0.00 0.00 0.00 0.00 0.00

Ending 5%
Increase 110%
Months 12
VAT 12%
 Item QTY Yearly Yearly
Pre-operating Supplies
Expense Quantity (less preoperating)
Menu Board 3 450 1,350.00 14 6,300.00
Cups and Saucers 50 200.00 10,000.00 240 48,000.00
Espresso Cups 50 150 7,500.00 240 36,000.00
Latte Glasses 50 250 12,500.00 240 60,000.00
Cappuccino Glasses 50 200 10,000.00 240 48,000.00
Measuring Cups 5 300.00 1,500.00 24 7,200.00
Macchiato Glasses 50 200 10,000.00 240 48,000.00
Measuring Spoons 5 150 750.00 24 3,600.00
Thermometers 2 500 1,000.00 10 5,000.00
Cleaning Brushes 5 150 750.00 24 3,600.00
Cups And Lids 500 5 2,500.00 2400 12,000.00
Straws 1000 0.5 500.00 11000 5,500.00
Shakers 10 200 2,000.00 48 9,600.00
Measuring Cups 5 300 1,500.00 24 7,200.00
Measuring Spoons 5 150 750.00 24 3,600.00
Thermometers 2 500 1,000.00 10 5,000.00
Cleaning Brushes 5 150.00 750.00 24 3,600.00
Mixing Bowl 2 116 232.00 10 1,160.00
Grater 1 71.5 71.50 5 357.50
Ladle 5 80 400.00 24 1,920.00
Strainer Set 5 99 495 24 2,376.00
Chopping Board 5 110 550.00 24 2,640.00
Cup 50 45 2,250.00 240 10,800.00
Mug 50 65 3,250.00 240 15,600.00
Spice Container Set 2 92 184.00 10 920.00
Saucer Set 2 104 208.00 10 1,040.00
Knife 5 110.00 550.00 24 2,640.00
Scissors 5 129 645.00 24 3,096.00
Food Tongs 5 135 675.00 24 3,240.00
Wooden Spoon 3 59 177.00 14 826.00
5 Set Prep Bowl 5 653.00 3,265.00 24 15,672.00
Cooking Pot 1 289 289.00 5 1,445.00
Frying Pan 2 302.00 604.00 10 3,020.00
Can Opener 1 109 109.00 5 545.00
Sunny Side up Cooking Pan 3 200 600.00 14 2,800.00
Serving Tray 20 100 2,000.00 96 9,600.00
Plastic Bag 10 50 500.00 110 5,500.00
Garlic Press 1 70 70.00 5 350.00
Peeler 2 99.19 198.38 10 991.90
(25 pcs) Disposable Spoon & 15
Fork 20 300.00 72 1,440.00
Mortar & Pestle 1 250 250.00 5 1,250.00
Spoon 100 25 2,500.00 1100 27,500.00
Fork 100 25 2,500.00 1100 27,500.00
Small Wooden Plates 100 150 15,000.00 480 72,000.00
Medium Wooden Plates 100 200 20,000.00 480 96,000.00
Large Wooden Plates 100 300 30,000.00 480 144,000.00
Saucer Set 50 350 17,500.00 240 84,000.00
Water Glass 100 50 5,000.00 480 24,000.00
Glass Pitcher 50 250 12,500.00 240 60,000.00
Sheet Pan 10 159 1,590.00 48 7,632.00
Rolling Pin 8 115.00 920.00 38 4,370.00
Oven Gloves 2 39.00 78.00 10 390.00
Parchment Paper 8 54 432 38 2,052.00
Pastry Brush 10 60 600 48 2,880.00
Rubber Scraper 5 84 420 24 2,016.00
Dough Scraper 5 115 575 24 2,760.00
Pastry Bag 8 150 1200 38 5,700.00
Piping Nozzle 5 78 390 24 1,872.00
Wisk 2 80 160 10 800.00
Spoon 100 25 2500 480 12,000.00
Fork 100 25 2500 480 12,000.00
Small Wooden Plates 100 150 15000 480 72,000.00
Medium Wooden Plates 100 200 20000 480 96,000.00
Large Wooden Plates 100 300 30000 480 144,000.00
Saucer Set 50 350 17500 240 84,000.00
Water Glass 100 50 5000 480 24,000.00
Glass Pitcher 50 250 12500 240 60,000.00
Mop with Handle 6 460 2760 29 13,340.00
Ceiling Broom 6 239 1434 29 6,931.00
Cobweb Brush 5 168.75 843.75 24 4,050.00
Dustpan 2 69 138 10 690
Hand Soap 10 120 1200 48 5,760.00
Cleaning Towel 10 25 250 110 2,750.00
Alcohol 10 93 930 110 10,230.00
Dishwashing Liquid 15 145 2175 165 23,925.00
Trash Bin 10 149 1490 48 7,152.00
Door Mat 5 75 375 24 1,800.00
Bucket 2 126 252 10 1,260.00
Trash Bag 2 90 180 22 1,980.00
Table Tissue 10 60 600 110 6,600.00
Toilet Tissue 10 56 560 110 6,160.00
Air Freshener 10 59 590 110 6,490.00
Bleach 10 135 1350 110 14,850.00
Gloves 10 178 1780 48 8,544.00
Sponge 15 5 75 165 825
Toilet Brush 5 80 400 24 1,920.00
Wet Floor Sign 5 360 1800 24 8,640.00
Residual Value 10%
Useful life (Years) 5
Useful life (Month) 60
Method Straight Line Method

Item Qty Cost Cost

Sandared Sofa 11 2,990.00 32,890.00
Round Table Dining 7 1,500.00 10,500.00
Counter Coffee Table 1 7,467.00 7,467.00
Long Sofa 2 32,990.00 65,980.00
Background Wall Mural 2 350.00 700.00
Wooden Wall Hang display 3 300.00 900.00
Café Sign Board 1 1,200.00 1,200.00
Minimalist Chandelier 8 552 4,416.00
Coffee Display Led Signage 1 994.00 994.00
Flower Vases 4 176.00 704.00
Bar and Table Chair 3 3,500.00 10,500.00
Table Set 10 22,500.00 225,000.00
Indoor Plants 4 1,500.00 6,000.00
Sink 3 1,000.00 3,000.00
Toilet 3 3,000.00 9,000.00
Mirror 3 500.00 1,500.00
Kitchen Working Table 2 5,300.00 10,600.00

NOTES 21, 51, 8, 22 Notes Year 1 Year 2 Year 3 Year 4 Year 5

Furniture and Fixture 21 & 51 391,351.00 391,351.00 391,351.00 391,351.00 391,351.00

Total Depreciation Expense 70,443.18 70,443.18 70,443.18 70,443.18 70,443.18
Overhead Depreciation Expense 0.00 0.00 0.00 0.00 0.00
Operating Depreciation Expense 8 70,443.18 70,443.18 70,443.18 70,443.18 70,443.18
Accumulated Depreciation 22 70,443.18 140,886.36 211,329.54 281,772.72 352,215.90
Residual Value 10%
Useful life (Years) 5
Useful life (Month) 60
Method Straight Line Method

Item Qty Cost Total Cost

Freezer 1 12,000.00 12,000.00
Aircon 3 20,000.00 60,000.00
Espresso Machine 1 50,000.00 50,000.00
Coffee Grinder 1 15,000.00 15,000.00
Milk Frother 2 2,000.00 4,000.00
Hot Water Dispenser 1 3,500.00 3,500.00
Hot Chocolate Dispenser 1 12,000.00 12,000.00
Blender 1 10,000.00 10,000.00
Ice Crusher 1 5,000.00 5,000.00
Refrigerator 2 25,000.00 50,000.00
Syrup Dispensers 5 1,200.00 6,000.00
Dishwasher 2 7,249.00 14,498.00
Burner Gas Range 1 60,390.00 60,390.00
Weighing Scale 2 850.00 1,700.00
Refrigerator 1 30,999.00 30,999.00
Electric Mixer 3 368.00 1,104.00
Hand Dryer 2 2,299.00 4,598.00

NOTES 23, 52, 7, 24 Notes Year 1 Year 2 Year 3 Year 4 Year 5

Equipment 23 & 52 340,789.00 340,789.00 340,789.00 340,789.00 340,789.00

Depreciation Expense 61,342.02 61,342.02 61,342.02 61,342.02 61,342.02
Overhead Depreciation Expense 38,194.74 38,194.74 38,194.74 38,194.74 38,194.74
Operating Depreciation Expense 7 23,147.28 23,147.28 23,147.28 23,147.28 23,147.28
Accumulated Depreciation 24 61,342.02 122,684.04 184,026.06 245,368.08 306,710.10
Residual Value 10%
Useful life (Years) 10
Useful life (Month) 120
Method Straight Line Method
Overhead 40%

Item Qty Cost

Land for Building 320,000.00
Permits and Licenses 50,000.00
Interior Design and Architectural Plans 150,000.00
Cement, Gravel, Sand 100,000.00
Flooring (tiles, wood, or laminate) 80,000.00
Paint and Finishes 50,000.00
Labor Costs 300,000.00
Plumbing and Electrical Works 150,000.00

NOTES 25, 26, 6 Notes Year 1 Year 2 Year 3 Year 4 Year 5

Building 25 1,200,000.00 1,200,000.00 1,200,000.00 1,200,000.00 1,200,000.00

Depreciation Expense 108,000.00 108,000.00 108,000.00 108,000.00 108,000.00
Accumulated Depreciation 26 108,000.00 216,000.00 324,000.00 432,000.00 540,000.00

Depreciation Expense Operations 6 64,800.00 64,800.00 64,800.00 64,800.00 64,800.00

Depreciation Expense Overhead 43,200.00 43,200.00 43,200.00 43,200.00 43,200.00
SSS 11%
SSS EE 3.63%
SSS ER 7.37%
Yearly Increase 102%
Year Contribution increase 101%
Months 12

Salary Contribution
Base Income SSS SSS EE SSS ER PI PI EE PI ER PH PH EE PH ER EE EE ER Total
Manager 35,000 3850 139.76 283.745 400 200 200 500 250 250 34,410.25 589.76 733.75 35,733.75
Supervisor 25,000 2750 99.825 202.675 400 200 200 500 250 250 24,450.18 549.83 652.68 25,652.68
Barista 15,000 1650 59.895 121.605 400 200 200 500 250 250 14,490.11 509.9 571.61 15,571.61
Chef 20,000 2200 79.86 162.14 400 200 200 500 250 250 19,470.14 529.86 612.14 20,612.14
Certified Public Accountant (CPA)
35,000 3850 139.76 283.745 400 200 200 500 250 250 34,410.25 589.76 733.75 35,733.75
Business Lawyer 80,000 8800 319.44 648.56 400 200 200 500 250 250 79,230.56 769.44 1,098.56 81,098.56
Cashier 17,000 1870 67.881 137.819 400 200 200 500 250 250 16,482.12 517.88 587.82 17,587.82
Server 12,000 1320 47.916 97.284 400 200 200 500 250 250 11,502.08 497.92 547.28 12,547.28

Notes Year 1 Year 2 Year 3 Year 4 Year 5

Salaries Expense 39 2,813,348.08 2,869,615.04 2,927,007.34 2,985,547.49 3,045,258.43
SSS, PhilHealth, Pagibig 40 121,102.80 122,313.83 123,536.97 124,772.34 126,020.06

Operating Salaries Expense 3 2,397,062.48 2,445,003.73 2,493,903.80 2,543,781.88 2,594,657.52

Operating SSS, PhilHealth, Pagibig 4 103,183.46 104,215.29 105,257.44 106,310.02 107,373.12

Direct Salaries Expense 416,285.60 424,611.31 433,103.53 441,765.61 450,600.92

Direct SSS, PhilHealth, Pagibig 17,919.34 18,098.54 18,279.52 18,462.32 18,646.94
Direct Labor 62 434,204.94 442,709.85 451,383.06 460,227.92 469,247.86
Increase 110%

NOTES 13 & 43 Monthly Year 1 Year 2 Year 3 Year 4 Year 5

Miscellaneous Expense 13 & 43 1,000.00 12,000.00 13,200.00 14,520.00 15,972.00 17,569.20

NOTES 9 & 41 Monthly Year 1 Year 2 Year 3 Year 4 Year 5

Water Bill 3,000.00 36,000.00 39,600.00 43,560.00 47,916.00 52,707.60
Internet and Phone 5,000.00 60,000.00 66,000.00 72,600.00 79,860.00 87,846.00
LPG Gas Refill 5,000.00 60,000.00 66,000.00 72,600.00 79,860.00 87,846.00
Fuel (Generator 150 KVA) 3,000.00 36,000.00 39,600.00 43,560.00 47,916.00 52,707.60
Electricity 10,000.00 120,000.00 132,000.00 145,200.00 159,720.00 175,692.00
Waste Management 3,000.00 36,000.00 39,600.00 43,560.00 47,916.00 52,707.60
Total Utilities Expense 9 & 41 29,000.00 348,000.00 382,800.00 421,080.00 463,188.00 509,506.80

NOTES 11 & 42 30% Total Year 1 Year 2 Year 3 Year 4 Year 5

Renovation 0 0 0 0 0 0
Building 1,200,000.00 360,000.00 396,000.00 435,600.00 479,160.00 527,076.00
Equipment 340,789.00 102,236.70 112,460.37 123,706.41 136,077.05 149,684.75
Furnitures and Fixtures 391,351.00 117,405.30 129,145.83 142,060.41 156,266.45 171,893.10
Repairs and Maintenance Expense 11 & 42 579,642.00 637,606.20 701,366.82 771,503.50 848,653.85
NOTES 46
PARTICULARS PRICE
Mayor's Permit 6,000.00
Barangay Clearance 20
Community Tax Certificate 50
Sketch of Location 500
Assessment Fees 120
DTI Biusiness Registration Requirement 230
Sanitary/Health Permit Requirements 300
ENRO (Clearance0 Requirements 300
Tax Clearance Certificate 25
Pest Control Clearance 240
Fire Safety Inspection Certificate Requirement 500.00
SSS Clearance 1,017.00
Philhealth Clearance 2,700.00
BIR Clearance/Registration 500
Pag-ibig Clearnance 360.00
Permits and Licences 46 12,862.00

NOTES 14
Ingredients supplies 1,064,277.28
Office Supplies 317,770.63
Building Renovation 0.00
Permits and Licences 12,862.00
Utililties 29,000.00
Preoperating Expense 14 1,423,909.91

NOTES 45 & 29 Year 1 Year 2 Year 3 Year 4 Year 5

Beginning VAT 49,811.45 58,943.55 65,183.82 71,731.03
Output VAT 2,605,350.78 2,865,885.86 3,152,474.45 3,467,721.89 3,814,494.08
Input VAT 2,007,613.33 2,208,374.67 2,429,212.13 2,672,133.35 2,939,346.68
VATPAYABLE 597,737.45 707,322.65 782,205.87 860,772.36 946,878.43
REMITTANCE 45 547,925.99 648,379.09 717,022.04 789,041.33 867,971.89
VATPAYABLE 29 49,811.45 58,943.55 65,183.82 71,731.03 78,906.54
 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
LIQUIDITY
CURRENT RATIO
QUICK RATIO

PROFITABILITY
GROSS PROFIT RATIO 0.3 0.29 0.3 0.3 0.3
OPERATING RATIO 0.2 0.27 0.26 0.25 0.24
OPERATING PROFIT RATIO 0.03 0.03 0.04 0.05 0.06
NET PROFIT RATIO 0.03 0.03 0.03 0.04 0.05
RETURN ON INVESTMENT (ROI) 0.14 0.13 0.2 0.26 0.34

SOLVENCY
DEBT-TO-EQUITY 0 0 0 0 0
DEBT-TO-ASSETS 0 0 0 0 0

ACTIVITY
TOTAL ASSET TURNOVER RATIO 4.16 4.09 3.9 3.64 3.35
 Year 1 Year 2 Year 3 Year 4 Year 5
Sales 19,105,905.73 21,016,496.30 23,118,145.93 25,429,960.53 27,972,956.58
Fixed Cost:
Salaries 2,397,062.48 2,445,003.73 2,493,903.80 2,543,781.88 2,594,657.52
SSS, PhilHealth, Pagibig 103,183.46 104,215.29 105,257.44 106,310.02 107,373.12
Supplies Expense 1,607,267.71 1,848,357.87 2,037,211.82 2,241,133.91 2,465,257.35
Depreciation Expense - Building 64,800.00 64,800.00 64,800.00 64,800.00 64,800.00
Depreciation Expense - Equipment 23,147.28 23,147.28 23,147.28 23,147.28 23,147.28
Depreciation Expense - Furniture & Fixture 70,443.18 70,443.18 70,443.18 70,443.18 70,443.18
Utilities Expense 348,000.00 382,800.00 421,080.00 463,188.00 509,506.80
Repairs and Maintenance 579,642.00 637,606.20 701,366.82 771,503.50 848,653.85
Miscellaneous Expense 12,000.00 13,200.00 14,520.00 15,972.00 17,569.20
Total Fixed Cost 3,794,498.20 5,589,573.55 5,931,730.35 6,300,279.77 6,701,408.30

Variable Cost:
Cost of Sales 13,281,771.04 14,827,854.62 16,270,796.40 17,853,501.79 19,593,717.45
Total Variable Cost 13,281,771.04 14,827,854.62 16,270,796.40 17,853,501.79 19,593,717.45

Break-Even Sales (Php) 12,447,741.80 18,982,073.57 20,026,815.81 21,146,537.13 22,371,745.27

Margin Safety(Php) 6,658,163.93 2,034,422.73 3,091,330.12 4,283,423.40 5,601,211.31
Margin Safety Ratio (%) 35% 10% 13% 17% 20%