Table 1

v!s!T!l!ty
Statement of Financial Performance
For the Years 2019-2023

2019 2020 2021 2022 2023

Sales 1,052,640.00 1,365,120.00 1,860,768.00 2,605,392.00 3,626,784.00
Less: Sales Discounts (1,470.00) (300.00) (1,000.00) - (5,700.00)
Net Sales 1,051,170.00 1,364,820.00 1,859,768.00 2,605,392.00 3,621,084.00
Other Income 374,400.00 522,720.00 730,080.00 1,026,720.00 1,434,240.00
Gross Income 1,254,501.60 1,661,035.20 2,279,066.24 3,196,258.56 4,448,685.12
Rent Expense (240,000.00) (240,000.00) (240,000.00) (240,000.00) (240,000.00)
Advertising Expense (10,000.00) (10,500.00) (11,000.00) (11,500.00) (12,000.00)
Repairs and Maintenance Expense (2,000.00) (3,000.00) (4,000.00) (5,000.00) (6,000.00)
Utilities Expense (66,000.00) (66,660.00) (67,326.60) (67,999.87) (68,679.86)
Salaries Expense (558,000.00) (582,000.00) (606,000.00) (630,000.00) (654,000.00)
Store Supplies Expense (175,887.75) (252,379.00) (301,629.00) (456,379.00) (468,879.00)
Office Supplies Expense (1,408.00) (1,692.76) (1,709.69) (1,726.78) (1,744.05)
Housekeeping Expense (15,675.00) (17,100.00) (17,271.00) (17,443.71) (17,618.15)
Depreciation Expense - Machines (3,539.50) (6,418.50) (6,418.50) (6,418.50) (6,418.50)
Depreciation Expense - Equipment (20,212.48) (23,631.48) (23,631.48) (23,631.48) (23,631.48)
Depreciation Expense - Furnitures and Fixtures (25,188.00) (25,188.00) (21,980.00) (21,980.00) (25,576.00)
Other Expenses (17,900.00) (20,500.00) (20,898.00) (20,898.00) (16,800.00)
Net Income before Tax 118,690.87 411,965.46 957,201.97 1,693,281.21 2,907,338.07
Income Tax (30%) (35,607.26) (123,589.64) (287,160.59) (507,984.36) (872,201.42)

Net Income after Tax 83,083.61 288,375.82 670,041.38 1,185,296.85 2,035,136.65

50
 Table 2
v!s!T!l!ty
Statement of Cash Flows
For the Years 2019-2023

Operating Activities 2019 2020 2021 2022 2023

Net Sales 1,051,170.00 1,364,820.00 1,859,768.00 2,605,392.00 3,621,084.00
Other Income 374,400.00 522,720.00 730,080.00 1,026,720.00 1,434,240.00
Payment of Rent (240,000.00) (240,000.00) (240,000.00) (240,000.00) (240,000.00)
Payment of Advertising Expense (10,000.00) (10,500.00) (11,000.00) (11,500.00) (12,000.00)
Payment of Repairs and Maintenance (2,000.00) (3,000.00) (4,000.00) (5,000.00) (6,000.00)
Payment of Utilities (66,000.00) (66,660.00) (67,326.60) (67,999.87) (68,679.86)
Payment of Salaries (492,961.20) (516,481.20) (539,401.20) (562,471.20) (584,956.80)
Purchase of Store Supplies (175,887.75) (252,379.00) (301,629.00) (456,379.00) (468,879.00)
Change in Inventory (53,664.00) (50,889.60) (101,376.00) (146,640.00) (158,004.00)
Purchase of Office Supplies (1,408.00) (1,692.76) (1,709.69) (1,726.78) (1,744.05)
Payment of Housekeeping Expenses (15,675.00) (17,100.00) (17,271.00) (17,443.71) (17,618.15)
Payment of Other Expenses (17,900.00) (20,500.00) (20,898.00) (20,898.00) (16,800.00)
Payment of SSS Premium Payable (47,128.80) (47,128.80) (47,128.80) (47,128.80) (48,013.20)
Payment of Philhealth Premium Payable (6,750.00) (6,750.00) (7,350.00) (7,800.00) (7,950.00)
Payment of Pag-ibig Premium Payable (11,160.00) (11,640.00) (12,120.00) (12,600.00) (13,080.00)
Net Cash Inflows (Outflows) from
285,035.25 642,818.64 1,218,637.71 2,034,524.64 3,411,598.94
Operating Activities

51
Investing Activities 2019 2020 2021 2022 2023
Purchase of Printer/Photocopier (14,395.00) (14,395.00) - - -
Purchase of Coffee Machine (21,000.00)
Purchase of CCTV (4,400.00)
Purchase of Wifi (1,500.00)
Purchase of Stand Aircon (115,998.00)
Purchase of Vacuum (5,895.00)
Purchase of Desktop computer (51,285.00) (17,095.00) - - -
Purchase of Refrigerator (8,499.00)
Purchase of Freezer (8,999.00)
Purchase of Center Table (10,000.00)
Purchase of Locker 12 doors (53,940.00) - (35,960.00) - (17,980.00)
Purchase of Office Table (2,730.00)
Purchase of Office Chairs (5,460.00)
Purchase of Waiting Bench (6,000.00)
Purchase of Monoblock Chair (778.00)
Net Cash Inflows (Outflows) from
(310,879.00) (31,490.00) (35,960.00) (17,980.00)
Investing Activities

Financing Activities 2019 2020 2021 2022 2023

Investment 1,625,000.00
Withdrawals (250,000.00) (500,000.00) (750,000.00) (1,000,000.00) (1,250,000.00)
Net Cash Inflows (Outflows) from
1,375,000.00 (500,000.00) (750,000.00) (1,000,000.00) (1,250,000.00)
Financing Activities

Net Cash Inflows (Outflows) 1,349,156.25 111,328.64 432,677.71 1,034,524.64 2,143,618.94

Add: Cash Balance, January 1 - 1,349,156.25 1,460,484.89 1,893,162.60 2,927,687.24

Cash Balance, December 31 1,349,156.25 1,460,484.89 1,893,162.60 2,927,687.24 5,071,306.18

52
 Table 3
v!s!T!l!ty
Statement of Changes in Partners' Equity
For the Years 2019-2023

2019 Almoguera, Capital Casticimo, Capital Espinosa, Capital Malaluan, Capital Periabras, Capital Total

Beginning Capital (2019) 325,000.00 325,000.00 325,000.00 325,000.00 325,000.00 1,625,000.00

Add: Share in Net Income 16,616.72 16,616.72 16,616.72 16,616.72 16,616.72 83,083.61

Total 341,616.72 341,616.72 341,616.72 341,616.72 341,616.72 1,708,083.61

Less: Withdrawals (50,000.00) (50,000.00) (50,000.00) (50,000.00) (50,000.00) (250,000.00)

Capital Balances, December 31, 2019 291,616.72 291,616.72 291,616.72 291,616.72 291,616.72 1,458,083.61

2020 Almoguera, Capital Casticimo, Capital Espinosa, Capital Malaluan, Capital Periabras, Capital Total

Capital Balances, January 1, 2020 291,616.72 291,616.72 291,616.72 291,616.72 291,616.72 1,458,083.61

Add: Share in Net Income 57,675.16 57,675.16 57,675.16 57,675.16 57,675.16 288,375.82

Total 349,291.88 349,291.88 349,291.88 349,291.88 349,291.88 1,746,459.42

Less: Withdrawals (100,000.00) (100,000.00) (100,000.00) (100,000.00) (100,000.00) (500,000.00)

Capital Balances, December 31, 2020 249,291.88 249,291.88 249,291.88 249,291.88 249,291.88 1,246,459.42

2021 Almoguera, Capital Casticimo, Capital Espinosa, Capital Malaluan, Capital Periabras, Capital Total

Capital Balances, January 1, 2020 249,291.88 249,291.88 249,291.88 249,291.88 249,291.88 1,246,459.42

Add: Share in Net Income 134,008.28 134,008.28 134,008.28 134,008.28 134,008.28 670,041.38

Total 383,300.16 383,300.16 383,300.16 383,300.16 383,300.16 1,916,500.80

Less: Withdrawals (150,000.00) (150,000.00) (150,000.00) (150,000.00) (150,000.00) (750,000.00)

Capital Balances, December 31, 2021 233,300.16 233,300.16 233,300.16 233,300.16 233,300.16 1,166,500.80

53
 2022 Almoguera, Capital Casticimo, Capital Espinosa, Capital Malaluan, Capital Periabras, Capital Total

Capital Balances, January 1, 2022 233,300.16 233,300.16 233,300.16 233,300.16 233,300.16 1,166,500.80

Add: Share in Net Income 237,059.37 237,059.37 237,059.37 237,059.37 237,059.37 1,185,296.85

Total 470,359.53 470,359.53 470,359.53 470,359.53 470,359.53 2,351,797.65

Less: Withdrawals (200,000.00) (200,000.00) (200,000.00) (200,000.00) (200,000.00) (1,000,000.00)

Capital Balances, December 31, 2022 270,359.53 270,359.53 270,359.53 270,359.53 270,359.53 1,351,797.65

2023 Almoguera, Capital Casticimo, Capital Espinosa, Capital Malaluan, Capital Periabras, Capital Total

Capital Balances, January 1, 2023 270,359.53 270,359.53 270,359.53 270,359.53 270,359.53 1,351,797.65

Add: Share in Net Income 407,027.33 407,027.33 407,027.33 407,027.33 407,027.33 2,035,136.65

Total 677,386.86 677,386.86 677,386.86 677,386.86 677,386.86 3,386,934.30

Less: Withdrawals (250,000.00) (250,000.00) (250,000.00) (250,000.00) (250,000.00) (1,250,000.00)

Capital Balances, December 31, 2023 427,386.86 427,386.86 427,386.86 427,386.86 427,386.86 2,136,934.30

54
 Table 4
v!s!T!l!ty
Statement of Financial Position
For the Years 2019-2023

2019 2020 2021 2022 2023

ASSETS

Current Asset

Cash 1,349,156.25 1,460,484.89 1,893,162.60 2,927,687.24 5,071,306.18

Merchandise
72,000.00 54,000.00 102,000.00 150,000.00 162,000.00
Inventory
Total Current Asset 1,421,156.25 1,514,484.89 1,995,162.60 3,077,687.24 5,233,306.18

Non-Current Assets

Machines 35,395.00 46,250.50 42,711.00 36,292.50 29,874.00

Less: Accumulated
Depreciation - (3,539.50) 31,855.50 (3,539.50) 42,711.00 (6,418.50) 36,292.50 (6,418.50) 29,874.00 (6,418.50) 23,455.50
Machines

Equipments 196,576.00 193,458.52 169,827.03 182,155.55 158,524.06

Less: Accumulated
Depreciation - (20,212.48) 176,363.52 (23,631.48) 169,827.03 (23,631.48) 182,155.55 (23,631.48) 158,524.06 (23,631.48) 152,872.58
Equipments

Furnitures and
78,908.00 64,120.00 49,332.00 27,352.00 5,372.00
Fixtures

Less: Accumulated
Depreciation -
(14,788.00) 64,120.00 (14,788.00) 49,332.00 (21,980.00) 27,352.00 (21,980.00) 5,372.00 (25,576.00) (20,204.00)
Furnitures and
Fixtures

Total Non-Current
272,339.02 261,870.03 245,800.05 193,770.06 156,124.08
Assets

TOTAL ASSETS 1,693,495.27 1,776,354.92 2,240,962.65 3,271,457.30 5,389,430.25

55
 2019 2020 2021 2022 2023
LIABILITIES AND PARTNERS' EQUITY

LIABILITIES
SSS Premium
47,128.80 47,128.80 47,128.80 47,128.80 48,013.20
Payable
Philhealth
6,750.00 6,750.00 7,350.00 7,800.00 7,950.00
Premium Payable
Pag-ibig Premium
11,160.00 11,640.00 12,120.00 12,600.00 13,080.00
Payable
TOTAL LIABILITIES 65,038.80 65,518.80 66,598.80 67,528.80 69,043.20

PARTNERS' EQUITY
Almoguera, Capital 291,616.72 249,291.88 233,300.16 270,359.53 427,386.86
Casticimo, Capital 291,616.72 249,291.88 233,300.16 270,359.53 427,386.86
Espinosa, Capital 291,616.72 249,291.88 233,300.16 270,359.53 427,386.86
Malaluan, Capital 291,616.72 249,291.88 233,300.16 270,359.53 427,386.86
Periabras, Capital 291,616.72 249,291.88 233,300.16 270,359.53 427,386.86

TOTAL PARTNERS'
1,628,456.47 1,710,836.12 2,174,363.85 3,203,928.50 5,320,387.05
EQUITY

TOTAL LIABILITIES
AND PARTNERS' 1,693,495.27 1,776,354.92 2,240,962.65 3,271,457.30 5,389,430.25
EQUITY

0.00 0.00 - 0.00 - (0.00) - (0.00)

187,060.93 222,045.70 233,984.21 318,632.25 539,415.49

1,195,765.13 1,077,809.22 1,128,251.25 1,467,131.40

1,382,826.06 2,356,630.12

1,299,854.92 1,362,235.46 1,785,763.65 2,896,045.61

56
 Table 5
v!s!T!l!ty
Schedule of Depreciation
2018-2019
Machine Unit Price Quantity Total Price Useful Life Depreciation
Printer/Photocopier 14,395.00 1 14,395.00 10 1,439.50
Coffee Machine 21,000.00 1 21,000.00 10 2,100.00
Total 3,539.50

2020 - 2023
Machines Unit Price Quantity Total Price Useful Life Depreciation
Printer/Photocopier 14,395.00 1 14,395.00 5 2,879.00
Total 2,879.00
Depreciation (Old Machines) 3,539.50
New Depreciation 6,418.50

2018 - 2019
Equipments Unit Price Quantity Total Price Useful Life Depreciation
Stand Aricon 115,998.00 1 115,998.00 10 11,599.80
Desktop Computer 17,095.00 3 51,285.00 10 5,128.50
Vacuum 5,895.00 1 5,895.00 5 1,179.00
Frezeer 8,999.00 1 8,999.00 10 899.90
Refrigerator 8,499.00 1 8,499.00 10 849.90
CCTV 4,400.00 1 4,400.00 10 440.00
Wifi 1,500.00 1 1,500.00 13 115.38
Total 20,212.48

2020 -2023
Equipments Unit Price Quantity Total Price Useful Life Depreciation
Desktop Computer 17,095.00 1 17,095.00 5 3,419.00
Total 3,419.00
Depreciation (Old Equipments) 20,212.48
New Depreciation 23,631.48

57
 2018-2020
Furniture and Fixtures Unit Price Quantity Total Price Useful Life Depreciation
Center Tables 5,000.00 4 20,000.00 5 4,000.00
Lockers 8,990.00 6 53,940.00 5 10,788.00
Total 14,788.00

2021-2022
Furniture and Fixtures Unit Price Quantity Total Price Useful Life Depreciation
Lockers 8,990.00 4 35,960.00 5 7,192.00
Total 7,192.00
Depreciation (Old Furniture and Fixtures) 14,788.00
New Depreciation 21,980.00

2023
Furniture and Fixtures Unit Price Quantity Total Price Useful Life Depreciation
Lockers 8,990.00 2 17,980.00 5 3,596.00
Total 3,596.00
Depreciation (Old Furniture and Fixtures) 21,980.00
New Depreciation 25,576.00

58
 Table 6
v!s!T!l!ty
Return on Investment
Almoguera Casticimo Espinosa Malaluan Periabras Total
Net Income ₱ 83,083.61 ₱ 83,083.61 ₱ 83,083.61 ₱ 83,083.61 ₱ 83,083.61 ₱ 83,083.61
/Total Investment
₱ 291,616.72 ₱ 291,616.72 ₱ 291,616.72 ₱ 291,616.72 ₱ 291,616.72 ₱ 1,458,083.61
(Equity)
ROI/ROE 0.28 0.28 0.28 0.28 0.28 0.06

Net Income ₱ 288,375.82 ₱ 288,375.82 ₱ 288,375.82 ₱ 288,375.82 ₱ 288,375.82 ₱ 288,375.82

/Total Investment
₱ 249,291.88 ₱ 249,291.88 ₱ 249,291.88 ₱ 249,291.88 ₱ 249,291.88 ₱ 1,246,459.42
(Equity)
ROI/ROE 1.16 1.16 1.16 1.16 1.16 0.23

Net Income ₱ 670,041.38 ₱ 670,041.38 ₱ 670,041.38 ₱ 670,041.38 ₱ 670,041.38 ₱ 670,041.38

/Total Investment
₱ 233,300.16 ₱ 233,300.16 ₱ 233,300.16 ₱ 233,300.16 ₱ 233,300.16 ₱ 1,166,500.80
(Equity)
ROI/ROE 2.87 2.87 2.87 2.87 2.87 0.57

Net Income ₱ 1,185,296.85 ₱ 1,185,296.85 ₱ 1,185,296.85 ₱ 1,185,296.85 ₱ 1,185,296.85 ₱ 1,185,296.85

/Total Investment
₱ 270,359.53 ₱ 270,359.53 ₱ 270,359.53 ₱ 270,359.53 ₱ 270,359.53 ₱ 1,351,797.65
(Equity)
ROI/ROE 4.38 4.38 4.38 4.38 4.38 0.88

Net Income ₱ 2,035,136.65 ₱ 2,035,136.65 ₱ 2,035,136.65 ₱ 2,035,136.65 ₱ 2,035,136.65 ₱ 2,035,136.65

/Total Investment
₱ 427,386.86 ₱ 427,386.86 ₱ 427,386.86 ₱ 427,386.86 ₱ 427,386.86 ₱ 2,136,934.30
(Equity)
ROI/ROE 4.76 4.76 4.76 4.76 4.76 0.95
59
 Table 7
v!s!T!l!ty
Break-even Analysis

Fixed Costs 240,000.00

Selling Price 149

Variable cost 98

Computation:
= Fixed Cost
(Selling Price per Unit-Variable Cost per Unit)

= 240000

1. Breakeven Sales in (141-98)

Units

= 240000.00
51.12

= 4695.00

= Breakeven Sales x Selling Price

2. Breakeven Sales in
= 16317.63 x 32.75
Pesos

= ₱460,989.94

60
 Table 8
v!s!T!l!ty
Salary Schedule

Employee Salary Breakdown (Before

Monthly Salary
Benefits Deduction)

Employees 2019 2020 2021 2022 2023

Manager ₱ 15,000.00 ₱ 15,500.00 ₱ 16,000.00 ₱ 16,500.00 ₱ 17,000.00
Front Desk/Cashier staff ₱ 10,500.00 ₱ 11,000.00 ₱ 11,500.00 ₱ 12,000.00 ₱ 12,500.00
Printer/Photocopier Staff ₱ 10,500.00 ₱ 11,000.00 ₱ 11,500.00 ₱ 12,000.00 ₱ 12,500.00
All-Around Staffs ₱ 10,500.00 ₱ 11,000.00 ₱ 11,500.00 ₱ 12,000.00 ₱ 12,500.00

Benefits Deduction/Contribution
SSS
Employees 2019 2020 2021 2022 2023
Manager ₱ 545.00 ₱ 563.20 ₱ 581.30 ₱ 581.30 ₱ 581.30
Front Desk/Cashier staff ₱ 381.50 ₱ 399.70 ₱ 417.80 ₱ 436.00 ₱ 454.20
Printer/Photocopier Staff ₱ 381.50 ₱ 399.70 ₱ 417.80 ₱ 436.00 ₱ 454.20
All-Around Staffs ₱ 381.50 ₱ 399.70 ₱ 417.80 ₱ 436.00 ₱ 454.20

61
 Employeer 2019 2020 2021 2022 2023
Manager ₱ 1,135.00 ₱ 1,171.80 ₱ 1,208.70 ₱ 1,208.70 ₱ 1,208.70
Front Desk/Cashier staff ₱ 783.50 ₱ 820.30 ₱ 857.20 ₱ 894.00 ₱ 930.80
Printer/Photocopier Staff ₱ 783.50 ₱ 820.30 ₱ 857.20 ₱ 894.00 ₱ 930.80
All-Around Staffs ₱ 783.50 ₱ 820.30 ₱ 857.20 ₱ 894.00 ₱ 930.80

Pag-Ibig
Employees 2019 2020 2021 2022 2023
Manager ₱ 300.00 ₱ 310.00 ₱ 320.00 ₱ 330.00 ₱ 340.00
Front Desk/Cashier staff ₱ 210.00 ₱ 220.00 ₱ 230.00 ₱ 240.00 ₱ 250.00
Printer/Photocopier Staff ₱ 210.00 ₱ 220.00 ₱ 230.00 ₱ 240.00 ₱ 250.00
All-Around Staffs ₱ 210.00 ₱ 220.00 ₱ 230.00 ₱ 240.00 ₱ 250.00

Employeer 2019 2020 2021 2022 2023

Manager ₱ 300.00 ₱ 310.00 ₱ 320.00 ₱ 330.00 ₱ 340.00
Front Desk/Cashier staff ₱ 210.00 ₱ 220.00 ₱ 230.00 ₱ 240.00 ₱ 250.00
Printer/Photocopier Staff ₱ 210.00 ₱ 220.00 ₱ 230.00 ₱ 240.00 ₱ 250.00
All-Around Staffs ₱ 210.00 ₱ 220.00 ₱ 230.00 ₱ 240.00 ₱ 250.00

62
 PhilHealth
Employees 2019 2020 2021 2022 2023
Manager ₱ 150.00 ₱ 155.00 ₱ 160.00 ₱ 165.00 ₱ 170.00
Front Desk/Cashier staff ₱ 105.00 ₱ 110.00 ₱ 115.00 ₱ 120.00 ₱ 125.00
Printer/Photocopier Staff ₱ 105.00 ₱ 110.00 ₱ 115.00 ₱ 120.00 ₱ 125.00
All-Around Staffs ₱ 105.00 ₱ 110.00 ₱ 115.00 ₱ 120.00 ₱ 125.00

Employeer 2019 2020 2021 2022 2023

Manager ₱ 187.50 ₱ 187.50 ₱ 200.00 ₱ 200.00 ₱ 212.50
Front Desk/Cashier staff ₱ 125.00 ₱ 137.50 ₱ 137.50 ₱ 150.00 ₱ 150.00
Printer/Photocopier Staff ₱ 125.00 ₱ 137.50 ₱ 137.50 ₱ 150.00 ₱ 150.00
All-Around Staffs ₱ 125.00 ₱ 137.50 ₱ 137.50 ₱ 150.00 ₱ 150.00

Cut-Off date Pay Date Benifits to be Deducted

rd th th
23 of the mo. to 7 of the next mo. Every 15 of the mo. SSS, Pag-Ibig, PhilHealth

8th of the mo. to 22nd of same mo. Every Last Friday of the mo.

63
 Employee Salary Per Pay Day (After
Monthly Salary
Benefits Deduction)

Employees 2019 2020 2021 2022 2023

Manager ₱ 15,000.00 ₱ 15,500.00 ₱ 16,000.00 ₱ 16,500.00 ₱ 17,000.00
15th of the month ₱ 6,505.00 ₱ 6,721.80 ₱ 6,938.70 ₱ 7,173.70 ₱ 7,408.70
Every Last Friday of the mo. ₱ 7,500.00 ₱ 7,750.00 ₱ 8,000.00 ₱ 8,250.00 ₱ 8,500.00

Front Desk/Cashier staff ₱ 10,500.00 ₱ 11,000.00 ₱ 11,500.00 ₱ 12,000.00 ₱ 12,500.00

15th of the month ₱ 4,418.50 ₱ 4,770.30 ₱ 4,987.20 ₱ 5,204.00 ₱ 5,420.80
Every Last Friday of the mo. ₱ 5,250.00 ₱ 5,500.00 ₱ 5,750.00 ₱ 6,000.00 ₱ 6,250.00

Printer/Photocopier Staff ₱ 10,500.00 ₱ 11,000.00 ₱ 11,500.00 ₱ 12,000.00 ₱ 12,500.00

15th of the month ₱ 4,418.50 ₱ 44,770.30 ₱ 4,987.20 ₱ 5,204.00 ₱ 5,420.80
Every Last Friday of the mo. ₱ 5,250.00 ₱ 5,500.00 ₱ 5,750.00 ₱ 6,000.00 ₱ 6,250.00

All-Around Staffs ₱ 10,500.00 ₱ 11,000.00 ₱ 11,500.00 ₱ 12,000.00 ₱ 12,500.00

15th of the month ₱ 4,418.50 ₱ 44,770.30 ₱ 4,987.20 ₱ 5,204.00 ₱ 5,420.80
Every Last Friday of the mo. ₱ 5,250.00 ₱ 5,500.00 ₱ 5,750.00 ₱ 6,000.00 ₱ 6,250.00

64