D' Axis

Financial Statement Analysis

Digital Marketing Services
2024 2025 Video Marketing 2027
Current Assets 2,749,171.42 7,128,682.47 30 seconds 15,363,867.96
÷ Current Liabilities 970,815.56 1,775,600.74 1-3 minutes 2,163,122.67
Current Ratio 2.83 4.01 Bundle of Cards 7.10
Bond Paper
2024 2025 Consumption of Ink 2027
Total Liabilities 970,815.56 1,775,600.74 Pictures of Product/Services 2,163,122.67
÷ Total Equity 6,280,849.86 9,701,369.73 Tarpaulin 17,240,621.30
Debt to Equity (to 1) 0.15 0.18 Marketing Material for Events 0.13

2024 2025 2026 2027

Total Assets 7,251,665.42 11,476,970.47 14,782,689.81 19,403,743.96
÷ Total Equity 6,280,849.86 9,701,369.73 13,038,920.68 17,240,621.30
Capital Multiplier (to 1) 1.15 1.18 1.13 1.13

2024 2025 2026 2027

Net Income 4,327,124.64 8,551,299.68 8,343,877.38 10,504,251.54
÷ Sales/Revenue 14,374,656.00 24,930,557.00 24,632,244.00 30,258,579.00
Net Profit Margin 30.10% 34.30% 33.87% 34.71%

2024 2025 2026 2027

Gross Profit 8,624,793.60 14,958,334.20 14,779,346.40 18,155,147.40
÷ Sales/Revenue 14,374,656.00 24,930,557.00 24,632,244.00 30,258,579.00
Gross Profit Margin 60.00% 60.00% 60.00% 60.00%

2024 2025 2026 2027

Current Assets 2,749,171.42 7,128,682.47 10,588,607.81 15,363,867.96
Less: Non-liquid Assets:
Inventory 110,271.33 191,248.11 188,959.68 232,120.61
Office Supplies 719.67 744.85 770.92 797.91
Prepaid Insurance 12,000.00 9,000.00 6,000.00 3,000.00
Quick Assets 2,626,180.42 6,927,689.51 10,392,877.21 15,127,949.45
÷ Current Liabilities 970,815.56 1,775,600.74 1,743,769.13 2,163,122.67
Quick Ratio (to 1) 2.71 3.90 5.96 6.99

2024 2025 2026 2027

Cost of Sales 5,749,862.40 9,972,222.80 9,852,897.60 12,103,431.60
÷ Average Inventory 110,271.33 150,759.72 190,103.89 210,540.14
Inventory Turn over 52.14 66.15 51.83 57.49

2024 2025 2026 2027

Average Inventory 110,271.33 150,759.72 190,103.89 210,540.14
÷ (COGS ÷ 365 Days) 15,753.05 27,321.16 26,994.24 33,160.09
Days Sales in Inventory 7.00 5.52 7.04 6.35

2024 2025 2026 2027

Sales/Revenue 14,374,656.00 24,930,557.00 24,632,244.00 30,258,579.00
÷ Average Total Assets 7,251,665.42 9,364,317.94 13,129,830.14 17,093,216.89
Asset Turn over 198.23% 266.23% 187.61% 177.02%

2024 2025 2026 2027

Net Income 4,327,124.64 8,551,299.68 8,343,877.38 10,504,251.54
÷ Average Total Assets 7,251,665.42 9,364,317.94 13,129,830.14 17,093,216.89
Return on Assets 59.67% 91.32% 63.55% 61.45%

2024 2025 2026 2027

Net Income 4,327,124.64 8,551,299.68 8,343,877.38 10,504,251.54
D' Axis
Financial Statement Analysis
÷ Average Equity 6,280,849.86 7,991,109.79 11,370,145.20 15,139,770.99
Return on Equity 68.89% 107.01% 73.38% 69.38%

Investment to
Year Net Cashflow
be recovered
Initial Investment Cost 4,683,336.00
2024 Net Income 1 2,626,180.42 2,057,155.58
2025 Net Income 2 4,301,509.09
2026 Net Income 3 3,465,187.70
2027 Net Income 4 4,735,072.24
2028 Net Income 5 4,965,879.68
Payback Period

Net Present Value PV @ 30% Year

Cash Flow 2024 2,626,180.42 2,020,138.78 Net Investment
Cash Flow 2025 4,301,509.09 2,545,271.65 2024
Cash Flow 2026 3,465,187.70 2,665,529.00 2025
Cash Flow 2027 4,735,072.24 2,801,817.90 2026
Cash Flow 2028 4,965,879.68 3,819,907.44 2027
13,852,664.77 2028
Cost of Investment (4,683,336.00) IRR
Net Present Value @ 30% 9,169,328.77
Rate
5000
20,000.00
2,371,101.94
8.58

2028
2,371,101.94
21,863,184.41
0.11

2028
24,234,286.35
21,863,184.41
1.11

2028
11,556,407.79
33,105,681.00
34.91%

2028
19,863,408.60
33,105,681.00
60.00%

2028
20,348,616.35

253,961.39
825.83
-
20,093,829.13
2,371,101.94
8.47

2028
13,242,272.40
243,041.00
54.49

2028
243,041.00
36,280.20
6.70

2028
33,105,681.00
21,819,015.16
151.73%

2028
11,556,407.79
21,819,015.16
52.96%

2028
11,556,407.79
 19,551,902.85
59.11%

Payback Time of
Year

1.00
0.04

1.04 years

Cash Flow
(4,683,336.00)
2,626,180.42
4,301,509.09
3,465,187.70
4,735,072.24
4,965,879.68
69.554%
D' Axis
PROJECTED INCOME STATEMENT

For the year ended, Digital Marketing Services Rate

December 31, 2024 to 2028 Video
30 Marketing
seconds 5000
20000
Particulars SCHED. January 1-3 minutes March April May
Service Revenue 1.0 1,197,888.00 Bundle of Cards 1,197,888.00 1,197,888.00 1,197,888.00
Less: Cost of Sales 2.0 479,155.20 Bond Paper 479,155.20 479,155.20 479,155.20
Gross Profit 718,732.80 Consumption of Ink 718,732.80 718,732.80 718,732.80
Pictures of Product/Services
Less: Operating Expenses Tarpaulin
Salaries & Wages 3.0 128,000.00 Marketing Material for Events 128,000.00 128,000.00 128,000.00
HDMF/SSS/PHIC 4.0 14,809.95 14,809.95 14,809.95 14,809.95 14,809.95
Depreciation Expense 5.0 12,850.50 12,850.50 12,850.50 12,850.50 12,850.50
Utilities Expense 6.0 6,522.20 6,522.20 6,522.20 6,522.20 6,522.20
Installation Cost 12,000.00 - - - -
Repairs & Maintenance 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
Permits & Licenses 7.0 19,230.00 - - - -
Supplies Expense 8.0 719.67 719.67 719.67 719.67 719.67
Insurance Expense 9.0 250.00 250.00 250.00 250.00 250.00
Marketing Expenses 416.67 416.67 416.67 416.67 416.67
Miscellaneous Expense 23,957.76 23,957.76 23,957.76 23,957.76 23,957.76
Pre-operating Expenses 8,636.00 - - - -
Total Expenses 228,392.75 188,526.75 188,526.75 188,526.75 188,526.75
Operating Income 490,340.05 530,206.05 530,206.05 530,206.05 530,206.05
Add: INTEREST INCOME - - - - -
Earnings before tax 490,340.05 530,206.05 530,206.05 530,206.05 530,206.05
TAX 147,102.02 159,061.82 159,061.82 159,061.82 159,061.82
Net Income 343,238.04 371,144.24 371,144.24 371,144.24 371,144.24
D' Axis
PROJECTED INCOME STATEMENT

For the year ended,

December 31, 2024 to 2028
Particulars SCHED. June July August September October November
Service Revenue 1.0 1,197,888.00 1,197,888.00 1,197,888.00 1,197,888.00 1,197,888.00 1,197,888.00
Less: Cost of Sales 2.0 479,155.20 479,155.20 479,155.20 479,155.20 479,155.20 479,155.20
Gross Profit 718,732.80 718,732.80 718,732.80 718,732.80 718,732.80 718,732.80

Less: Operating Expenses

Salaries & Wages 3.0 128,000.00 128,000.00 128,000.00 128,000.00 128,000.00 128,000.00
HDMF/SSS/PHIC 4.0 14,809.95 14,809.95 14,809.95 14,809.95 14,809.95 14,809.95
Depreciation Expense 5.0 12,850.50 12,850.50 12,850.50 12,850.50 12,850.50 12,850.50
Utilities Expense 6.0 6,522.20 6,522.20 6,522.20 6,522.20 6,522.20 6,522.20
Installation Cost - - - - - -
Repairs & Maintenance 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
Permits & Licenses 7.0 - - - - - -
Supplies Expense 8.0 719.67 719.67 719.67 719.67 719.67 719.67
Insurance Expense 9.0 250.00 250.00 250.00 250.00 250.00 250.00
Marketing Expenses 416.67 416.67 416.67 416.67 416.67 416.67
Miscellaneous Expense 23,957.76 23,957.76 23,957.76 23,957.76 23,957.76 23,957.76
Pre-operating Expenses - - - - - -
Total Expenses 188,526.75 188,526.75 188,526.75 188,526.75 188,526.75 188,526.75
Operating Income 530,206.05 530,206.05 530,206.05 530,206.05 530,206.05 530,206.05
Add: INTEREST INCOME - - - - - -
Earnings before tax 530,206.05 530,206.05 530,206.05 530,206.05 530,206.05 530,206.05
TAX 159,061.82 159,061.82 159,061.82 159,061.82 159,061.82 159,061.82
Net Income 371,144.24 371,144.24 371,144.24 371,144.24 371,144.24 371,144.24
D' Axis
PROJECTED INCOME STATEMENT

For the year ended,

December 31, 2024 to 2028
Particulars SCHED. December 2024 2025 2026 2027 2028
Service Revenue 1.0 1,197,888.00 14,374,656.00 24,930,557.00 24,632,244.00 30,258,579.00 33,105,681.00
Less: Cost of Sales 2.0 479,155.20 5,749,862.40 9,972,222.80 9,852,897.60 12,103,431.60 13,242,272.40
Gross Profit 718,732.80 8,624,793.60 14,958,334.20 14,779,346.40 18,155,147.40 19,863,408.60

Less: Operating Expenses

Salaries & Wages 3.0 256,000.00 1,664,000.00 1,680,640.00 1,697,446.40 1,714,420.86 1,731,565.07
HDMF/SSS/PHIC 4.0 14,809.95 177,719.45 177,719.45 177,719.45 177,719.45 177,719.45
Depreciation Expense 5.0 12,850.50 154,206.00 308,412.00 462,618.00 616,824.00 771,030.00
Utilities Expense 6.0 6,522.20 78,266.40 79,831.73 81,428.36 83,056.93 84,718.07
Installation Cost - 12,000.00 - - - -
Repairs & Maintenance 1,000.00 12,000.00 12,360.00 12,730.80 13,112.72 13,506.11
Permits & Licenses 7.0 - 19,230.00 19,497.90 20,082.84 20,994.32 21,305.88
Supplies Expense 8.0 719.67 8,636.00 8,895.08 9,161.93 9,436.79 9,719.89
Insurance Expense 9.0 250.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00
Marketing Expenses 416.67 5,000.00 5,150.00 5,304.50 5,463.64 5,627.54
Miscellaneous Expense 23,957.76 287,493.12 498,611.14 492,644.88 605,171.58 662,113.62
Pre-operating Expenses - 21,636.00 - - - -
Total Expenses 316,526.75 2,443,186.97 2,794,117.30 2,962,137.16 3,249,200.30 3,480,305.64
Operating Income 402,206.05 6,181,606.63 12,164,216.90 11,817,209.24 14,905,947.10 16,383,102.96
Add: INTEREST INCOME - - 51,925.50 102,615.60 100,126.53 126,051.02
Earnings before tax 402,206.05 6,181,606.63 12,216,142.39 11,919,824.83 15,006,073.63 16,509,153.98
TAX 120,661.82 1,854,481.99 3,664,842.72 3,575,947.45 4,501,822.09 4,952,746.19
Net Income 281,544.24 4,327,124.64 8,551,299.68 8,343,877.38 10,504,251.54 11,556,407.79
D' Axis
Cashflow Statement
For the year ended, Digital Marketing Services Rate
December 31, 2024 to 2028 Video Marketing 5000
CASH FLOW FROM OPERATING 2024 30 seconds 2026 20000 2028
ACTIVITIES
Net Income 4,327,124.64 Bundle of Cards 8,343,877.38 10,504,251.54 11,556,407.79
Adjustment for Depreciation 154,206.00 Bond Paper 154,206.00 154,206.00 154,206.00
Adjustment for Prepayments (12,000.00) Consumption of Ink 3,000.00 3,000.00 3,000.00
Adjustment for Unpaid Salaries Expense 22,916.67 Pictures of Product/Services 231.46 233.77 236.11
Increase (Decrease) in Tax Payable 463,620.50 Tarpaulin (22,223.82) 231,468.66 112,731.03
Decrease (Increase) in Inventory (110,271.33) Marketing Material for Events 2,288.43 (43,160.93) (21,840.78)
Decrease (Increase) in Office Supplies (719.67) (25.19) (26.07) (26.98) (27.93)
Increase (Decrease) in Accounts Payable 484,278.40 351,965.83 (9,839.25) 187,651.10 95,012.14
Net Cash provided by Operating Activities 5,329,155.20 9,432,288.89 8,471,514.13 11,037,623.17 11,899,724.35

CASH FLOW FROM INVESTING

ACTIVITIES
Purchase of Land (1,800,000.00)
Purchase of Building (2,400,000.00)
Purchase of Furnitures and Fixtures (70,700.00)
Purchase of Machineries & Equipments (386,000.00) - - - -
Net Cash provided by Investing Activities (4,656,700.00)

CASH FLOW FROM FINANCING

ACTIVITIES
Cash received from Partners' Contribution 4,550,000.00 - - - -
Cash Payment to Partners (Withdrawal) (2,596,274.78) (5,130,779.81) (5,006,326.43) (6,302,550.92) (6,933,844.67)
Net Cash provided by Financing Activities 1,953,725.22 (5,130,779.81) (5,006,326.43) (6,302,550.92) (6,933,844.67)
NET CASH INFLOW (OUTFLOW) 2,626,180.42 4,301,509.09 3,465,187.70 4,735,072.24 4,965,879.68
Add: Beginning Cash Balance, January 1 2,626,180.42 6,927,689.51 10,392,877.21 15,127,949.45
Ending Cash Balance, December 31 2,626,180.42 6,927,689.51 10,392,877.21 15,127,949.45 20,093,829.13
 4,683,336.00
4,683,336.00

Net Present Value PV @ 30% Year Cash Flow

Cash Flow 2024 - Net Investment (4,683,336.00)
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment (4,683,336.00) IRR Err:523
Net Present Value @ 30% - 4,683,336.00
 D' Axis
Balance Sheet
For the year ended,
December
30 seconds 31, 2024 to 2028 20,000.00
1-3 minutes 2025 2026 2027
ASSETS SCHED.
Current Assets Bond Paper
Cash & Cash Equivalents Consumption of Ink 6,927,689.51 10,392,877.21 15,127,949.45
Inventory Pictures of Product/Services 191,248.11 188,959.68 232,120.61
Supplies 8 Tarpaulin 744.85 770.92 797.91
Prepaid Insurance 9 12,000.00 9,000.00 6,000.00 3,000.00
Total Current Assets 2,749,171.42 7,128,682.47 10,588,607.81 15,363,867.96
Land 1,800,000.00 1,800,000.00 1,800,000.00 1,800,000.00
Building 5 2,400,000.00 2,400,000.00 2,400,000.00 2,400,000.00
Accumulated Depreciation - Bldg 5 (72,000.00) (144,000.00) (216,000.00) (288,000.00)
Furnitures & Fixtures 5 70,700.00 70,700.00 70,700.00 70,700.00
Accumulated Depreciation - F&F 5 (12,726.00) (25,452.00) (38,178.00) (50,904.00)
Machineries & Equipment 5 386,000.00 386,000.00 386,000.00 386,000.00
Accumulated Depreciation - M&E 5 (69,480.00) (138,960.00) (208,440.00) (277,920.00)
Total Non-current Assets 4,502,494.00 4,348,288.00 4,194,082.00 4,039,876.00
TOTAL ASSETS 7,251,665.42 11,476,970.47 14,782,689.81 19,403,743.96
LIABILITIES
Current Liabilities
Accounts Payable 10 484,278.40 836,244.23 826,404.98 1,014,056.08
Income Tax Payable 463,620.50 916,210.68 893,986.86 1,125,455.52
Salaries Payable 3 22,916.67 23,145.83 23,377.29 23,611.06
Total Current Liabilities 970,815.56 1,775,600.74 1,743,769.13 2,163,122.67
TOTAL LIABILITIES 970,815.56 1,775,600.74 1,743,769.13 2,163,122.67
PARTNER'S CAPITAL
Divine S. Alipo-On 12 897,264.27 1,385,909.96 1,862,702.95 2,462,945.90
Jose Zaldy R. Alipo-On 12 897,264.27 1,385,909.96 1,862,702.95 2,462,945.90
Anna Marie A. Bañares 12 897,264.27 1,385,909.96 1,862,702.95 2,462,945.90
Mary Grace T. Linas 12 897,264.27 1,385,909.96 1,862,702.95 2,462,945.90
Patricia Anne M. Ortiz 12 897,264.27 1,385,909.96 1,862,702.95 2,462,945.90
Andrea L. Talamante 12 897,264.27 1,385,909.96 1,862,702.95 2,462,945.90
Kenneth L. Villanueva 12 897,264.27 1,385,909.96 1,862,702.95 2,462,945.90
Total Equity 6,280,849.86 9,701,369.73 13,038,920.68 17,240,621.30
TOTAL LIABILITIES & EQUITY 7,251,665.42 11,476,970.47 14,782,689.81 19,403,743.96

4,683,336.00
4,683,336.00
Net Present Value PV @ 30% Year Cash Flow
Cash Flow 2024 - Net Investment (4,683,336.00)
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment (4,683,336.00) IRR Err:523
Net Present Value @ 30% - 4,683,336.00
 D' Axis
Balance Sheet
For the year ended,
December 31, 2024 to 2028

2028

20,093,829.13
253,961.39
825.83
-
20,348,616.35
1,800,000.00
2,400,000.00
(360,000.00)
70,700.00
(63,630.00)
386,000.00
(347,400.00)
3,885,670.00
24,234,286.35

1,109,068.22
1,238,186.55
23,847.18
2,371,101.94
2,371,101.94

3,123,312.06
3,123,312.06
3,123,312.06
3,123,312.06
 3,123,312.06
3,123,312.06
3,123,312.06
21,863,184.41
24,234,286.35
 NOTE 1
D' Axis
PROJECTED SCHEDULE OF SALES REVENUE
For the year ended,
December 31, 2024 to 2028

Year Sales Revenue

2024 14,374,656.00
2025 24,930,557.00
2026 24,632,244.00
2027 30,258,579.00
2028 33,105,681.00
Net Present Value PV @ 30%
Cash Flow 2024 -
Cash Flow 2025 -
Cash Flow 2026 -
Cash Flow 2027 -
Cash Flow 2028 -
-
Cost of Investment -4683336
Net Present Value @ 30% - 4,683,336.00
Digital Marketing Services Rate
Video Marketing 5000
30 seconds 20000
1-3 minutes
Infographics
Bond Paper
Consumption of Ink
Pictures of Product/Services
Tarpaulin
Marketing Material for Events
4683336
4683336

Year Cash Flow

Net Investme -4683336
2024
2025
2026
2027
2028
IRR Err:523
 NOTE 2
D' Axis
ESTIMATED ON COST OF GOODS SOLD PERCENTAGE
For the year ended,
December 31, 2024 to 2028

Year Sales Cost of Sales

2024 14,374,656.00 5,749,862.40
2025 24,930,557.00 9,972,222.80
2026 24,632,244.00 9,852,897.60
2027 30,258,579.00 12,103,431.60
2028 33,105,681.00 13,242,272.40
Net Present Value PV @ 30%
Cash Flow 2024 -
Cash Flow 2025 -
Cash Flow 2026 -
Cash Flow 2027 -
Cash Flow 2028 -
-
Cost of Investment -4683336
Net Present Value @ 30% - 4,683,336.00
 NOTE 2
D' Axis Rate
ST OF GOODS SOLD PERCENTAGE 5000
or the year ended, 20000
mber 31, 2024 to 2028
Bundle of Cards
Bond Paper
Consumption of Ink
Pictures of Product/Services
Tarpaulin
Marketing Material for Events
40%
4683336
4683336

Year Cash Flow

Net Investment -4683336
2024
2025
2026
2027
2028
IRR Err:523
 NOTE 3
D' Axis
PROJECTED SCHEDULE OF SALARIES & WAGES
For the year ended December 31, 2024 to 2028
30 seconds 20000
2024 2025
Position Qty.
Basic Pay Bundle of Cards Annual Pay 13th Month Total S & W Basic Pay Monthly Pay Annual Pay 13th Month
Marketing Director 1 28,000.00 Bond Paper 336,000.00 28,000.00 364,000.00 28,280.00 28,280.00 339,360.00 28,280.00
Creative Designer 1 24,000.00 Consumption of Ink 288,000.00 24,000.00 312,000.00 24,240.00 24,240.00 290,880.00 24,240.00
Photo-Videographer 1 20,000.00 Pictures of Product/Services 240,000.00 20,000.00 260,000.00 20,200.00 20,200.00 242,400.00 20,200.00
Bookkeeper 1 22,000.00 Tarpaulin 264,000.00 22,000.00 286,000.00 22,220.00 22,220.00 266,640.00 22,220.00
Office Secretary 1 18,000.00 Marketing Material for Events 216,000.00 18,000.00 234,000.00 18,180.00 18,180.00 218,160.00 18,180.00
Office Assistant 1 16,000.00 16,000.00 192,000.00 16,000.00 208,000.00 16,160.00 16,160.00 193,920.00 16,160.00
Total 6 128,000.00 128,000.00 1,536,000.00 128,000.00 1,664,000.00 129,280.00 129,280.00 1,551,360.00 129,280.00

2026 2027
Position Qty.
Basic Pay Monthly Pay Annual Pay 13th Month Total S & W Basic Pay Monthly Pay Annual Pay 13th Month
Marketing Director 1 28,562.80 28,562.80 342,753.60 28,562.80 371,316.40 28,848.43 28,848.43 346,181.14 28,848.43
Creative Designer 1 24,482.40 24,482.40 293,788.80 24,482.40 318,271.20 24,727.22 24,727.22 296,726.69 24,727.22
Photo-Videographer 1 20,402.00 20,402.00 244,824.00 20,402.00 265,226.00 20,606.02 20,606.02 247,272.24 20,606.02
Bookkeeper 1 22,442.20 22,442.20 269,306.40 22,442.20 291,748.60 22,666.62 22,666.62 271,999.46 22,666.62
Office Secretary 1 18,361.80 18,361.80 220,341.60 18,361.80 238,703.40 18,545.42 18,545.42 222,545.02 18,545.42
Office Assistant 1 16,321.60 16,321.60 195,859.20 16,321.60 212,180.80 16,484.82 16,484.82 197,817.79 16,484.82
Total 6 130,572.80 130,572.80 1,566,873.60 130,572.80 1,697,446.40 131,878.53 131,878.53 1,582,542.34 131,878.53

2028
Position Qty.
Basic Pay Monthly Pay Annual Pay 13th Month Total S & W
Marketing Director 1 29,136.91 29,136.91 349,642.95 29,136.91 378,779.86
Creative Designer 1 24,974.50 24,974.50 299,693.95 24,974.50 324,668.45
Photo-Videographer 1 20,812.08 20,812.08 249,744.96 20,812.08 270,557.04
Bookkeeper 1 22,893.29 22,893.29 274,719.46 22,893.29 297,612.75
Office Secretary 1 18,730.87 18,730.87 224,770.47 18,730.87 243,501.34
Office Assistant 1 16,649.66 16,649.66 199,795.97 16,649.66 216,445.63
Total 6 133,197.31 133,197.31 1,598,367.76 133,197.31 1,731,565.07
4683336
 4683336

Net Present Value PV @ 30% Year Cash Flow

Cash Flow 2024 - Net Investment -4683336
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment -4683336 IRR Err:523
Net Present Value @ 30% - 4,683,336.00
 NOTE 3
D' Axis
CTED SCHEDULE OF SALARIES & WAGES
the year ended December 31, 2024 to 2028
2025
Total S & W
367,640.00
315,120.00
262,600.00
288,860.00
236,340.00
210,080.00
1,680,640.00

2027
Total S & W
375,029.56
321,453.91
267,878.26
294,666.09
241,090.43
214,302.61
1,714,420.86
 NOTE 4
D' Axis
PROJECTED SCHEDULE OF SSS/PHIC/HDMF CONTRIBUTIONS
For the year ended December 31, 2024 to 2028
30 seconds 20000
2024
Position Qty. HDMF SSS PHIC Total
Basic Pay Bundle of Cards
ER Share EE Share ER Share EE Share ER Share EE Share ER Share EE Share
Marketing Director 1 28,000.00 Consumption of Ink 560.00 560.00 1,699.99 900.00 560.00 560.00 2,819.99 2,020.00
Creative Designer 1 24,000.00 480.00 480.00 1,699.99 900.00 480.00 480.00 2,659.99 1,860.00
Pictures of Product/Services
Photo-Videographer 1 20,000.00 400.00 400.00 1,699.99 900.00 400.00 400.00 2,499.99 1,700.00
Bookkeeper 1 22,000.00 Marketing Material for Events 440.00 440.00 1,699.99 900.00 440.00 440.00 2,579.99 1,780.00
Office Secretary 1 18,000.00 18,000.00 360.00 360.00 1,529.99 810.00 360.00 360.00 2,249.99 1,530.00
Office Assistant 1 16,000.00 16,000.00 320.00 320.00 1,359.99 720.00 320.00 320.00 1,999.99 1,360.00
Total Monthly 2,560.00 2,560.00 9,689.95 5,130.00 2,560.00 2,560.00 14,809.95 10,250.00
Total Annually 30,720.00 30,720.00 116,279.45 61,560.00 30,720.00 30,720.00 177,719.45 123,000.00

2025
Position Qty. HDMF SSS PHIC Total
Basic Pay Monthly Pay
ER Share EE Share ER Share EE Share ER Share EE Share ER Share EE Share
Marketing Director 1 28,280.00 28,280.00 560.00 560.00 1,699.99 900.00 560.00 560.00 2,819.99 2,020.00
Creative Designer 1 24,240.00 24,240.00 480.00 480.00 1,699.99 900.00 480.00 480.00 2,659.99 1,860.00
Photo-Videographer 1 20,200.00 20,200.00 400.00 400.00 1,699.99 900.00 400.00 400.00 2,499.99 1,700.00
Bookkeeper 1 22,220.00 22,220.00 440.00 440.00 1,699.99 900.00 440.00 440.00 2,579.99 1,780.00
Office Secretary 1 18,180.00 18,180.00 360.00 360.00 1,529.99 810.00 360.00 360.00 2,249.99 1,530.00
Office Assistant 1 16,160.00 16,160.00 320.00 320.00 1,359.99 720.00 320.00 320.00 1,999.99 1,360.00
Total Monthly 2,560.00 2,560.00 9,689.95 5,130.00 2,560.00 2,560.00 14,809.95 10,250.00
Total Annually 30,720.00 30,720.00 116,279.45 61,560.00 30,720.00 30,720.00 177,719.45 123,000.00

2026
Position Qty. HDMF SSS PHIC Total
Basic Pay Monthly Pay
ER Share EE Share ER Share EE Share ER Share EE Share ER Share EE Share
Marketing Director 1 28,562.80 28,562.80 560.00 560.00 1,699.99 900.00 560.00 560.00 2,819.99 2,020.00
Creative Designer 1 24,482.40 24,482.40 480.00 480.00 1,699.99 900.00 480.00 480.00 2,659.99 1,860.00
Photo-Videographer 1 20,402.00 20,402.00 400.00 400.00 1,699.99 900.00 400.00 400.00 2,499.99 1,700.00
Bookkeeper 1 22,442.20 22,442.20 440.00 440.00 1,699.99 900.00 440.00 440.00 2,579.99 1,780.00
Office Secretary 1 18,361.80 18,361.80 360.00 360.00 1,529.99 810.00 360.00 360.00 2,249.99 1,530.00
Office Assistant 1 16,321.60 16,321.60 320.00 320.00 1,359.99 720.00 320.00 320.00 1,999.99 1,360.00
Total Monthly 2,560.00 2,560.00 9,689.95 5,130.00 2,560.00 2,560.00 14,809.95 10,250.00
Total Annually 30,720.00 30,720.00 116,279.45 61,560.00 30,720.00 30,720.00 177,719.45 123,000.00
 NOTE 4
D' Axis
PROJECTED SCHEDULE OF SSS/PHIC/HDMF CONTRIBUTIONS
For the year ended December 31, 2024 to 2028
2027
Position Qty. HDMF SSS PHIC Total
Basic Pay Monthly Pay
ER Share EE Share ER Share EE Share ER Share EE Share ER Share EE Share
Marketing Director 1 28,848.43 28,848.43 560.00 560.00 1,699.99 900.00 560.00 560.00 2,819.99 2,020.00
Creative Designer 1 24,727.22 24,727.22 480.00 480.00 1,699.99 900.00 480.00 480.00 2,659.99 1,860.00
Photo-Videographer 1 20,606.02 20,606.02 400.00 400.00 1,699.99 900.00 400.00 400.00 2,499.99 1,700.00
Bookkeeper 1 22,666.62 22,666.62 440.00 440.00 1,699.99 900.00 440.00 440.00 2,579.99 1,780.00
Office Secretary 1 18,545.42 18,545.42 360.00 360.00 1,529.99 810.00 360.00 360.00 2,249.99 1,530.00
Office Assistant 1 16,484.82 16,484.82 320.00 320.00 1,359.99 720.00 320.00 320.00 1,999.99 1,360.00
Total Monthly 2,560.00 2,560.00 9,689.95 5,130.00 2,560.00 2,560.00 14,809.95 10,250.00
Total Annually 30,720.00 30,720.00 116,279.45 61,560.00 30,720.00 30,720.00 177,719.45 123,000.00

2028
Position Qty. HDMF SSS PHIC Total
Basic Pay Monthly Pay
ER Share EE Share ER Share EE Share ER Share EE Share ER Share EE Share
Marketing Director 1 29,136.91 29,136.91 560.00 560.00 1,699.99 900.00 560.00 560.00 2,819.99 2,020.00
Creative Designer 1 24,974.50 24,974.50 480.00 480.00 1,699.99 900.00 480.00 480.00 2,659.99 1,860.00
Photo-Videographer 1 20,812.08 20,812.08 400.00 400.00 1,699.99 900.00 400.00 400.00 2,499.99 1,700.00
Bookkeeper 1 22,893.29 22,893.29 440.00 440.00 1,699.99 900.00 440.00 440.00 2,579.99 1,780.00
Office Secretary 1 18,730.87 18,730.87 360.00 360.00 1,529.99 810.00 360.00 360.00 2,249.99 1,530.00
Office Assistant 1 16,649.66 16,649.66 320.00 320.00 1,359.99 720.00 320.00 320.00 1,999.99 1,360.00
Total Monthly 2,560.00 2,560.00 9,689.95 5,130.00 2,560.00 2,560.00 14,809.95 10,250.00
Total Annually 30,720.00 30,720.00 116,279.45 61,560.00 30,720.00 30,720.00 177,719.45 123,000.00
 NOTE 5
D' Axis
PROJECTED SCHEDULE OF DEPRECIATION EXPENSE
For the year ended December 31, 2024 to 2028
30 seconds 20,000.00
Salvage Depreciable Useful
PARTICULARS Qty. Unit 1-3 minutes Total Cost
Value (10%) Cost life

Machineries & Equipments Bundle of Cards 386,000.00 38,600.00 347,400.00

Computer Set 6 Unit Bond Paper 150,000.00 15,000.00 135,000.00 5

Printer with scanner 1 Unit Consumption of Ink 7,800.00 780.00 7,020.00 5
Projector 1 Unit Pictures of Product/Services 6,200.00 620.00 5,580.00 5
Printing Machine 1 Unit Tarpaulin 115,000.00 11,500.00 103,500.00 5
Telephone 2 Unit Marketing Material for Events 4,400.00 440.00 3,960.00 5
Digital Camera 1 Unit 68,000.00 68,000.00 6,800.00 61,200.00 5
Tripod 1 Unit 2,300.00 2,300.00 230.00 2,070.00 5
Studio Soft-box Lighting Set 1 Unit 32,300.00 32,300.00 3,230.00 29,070.00 5
Building 1 2,400,000.00 240,000.00 2,160,000.00 30
Furnitures & Fixtures 44,600.00 70,700.00 7,070.00 63,630.00
Office Table 5 pcs 3,500.00 17,500.00 1,750.00 15,750.00 5
Office Chair 12 pcs 1,100.00 13,200.00 1,320.00 11,880.00 5
Conference Table 1 pcs 23,000.00 23,000.00 2,300.00 20,700.00 5
Sofa 1 pcs 17,000.00 17,000.00 1,700.00 15,300.00 5
TOTAL 303,400.00 456,700.00 45,670.00 411,030.00

Annual Accumulated Depreciation

PARTICULARS
Depreciation 2023 2024 2025 2026
Building 72,000.00 72,000.00 144,000.00 216,000.00 288,000.00
Furnitures & Fixtures 12,726.00 12,726.00 25,452.00 38,178.00 50,904.00
Machineries & Equipments 69,480.00 69,480.00 138,960.00 208,440.00 277,920.00
TOTAL 154,206.00 154,206.00 308,412.00 462,618.00 616,824.00
 NOTE 5
D' Axis
PROJECTED SCHEDULE OF DEPRECIATION EXPENSE
For the year ended December 31, 2024 to 2028

4,683,336.00
4,683,336.00

Net Present Value PV @ 30% Year Cash Flow

Cash Flow 2024 - Net Investment (4,683,336.00)
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment (4,683,336.00) IRR Err:523
 NOTE 5
D' Axis
PROJECTED SCHEDULE OF DEPRECIATION EXPENSE
For the year ended December 31, 2024 to 2028
Net Present Value @ 30% - 4,683,336.00
 NOTE 5
D' Axis
SCHEDULE OF DEPRECIATION EXPENSE
year ended December 31, 2024 to 2028
Annual
Depreciation
69,480.00

27,000.00
1,404.00
1,116.00
20,700.00
792.00
12,240.00
414.00
5,814.00
72,000.00
12,726.00
3,150.00
2,376.00
4,140.00
3,060.00
82,206.00

Accumulated Depreciation
2027
360,000.00
63,630.00
347,400.00
771,030.00
 NOTE 6
D' Axis
PROJECTED SCHEDULE OF UTILITY EXPENSES
For the year ended December 31, 2024 to 2028
30 seconds 20000
Particulars Monthly 2024 1-3 minutes 2026 2027
Electricity (NOCECO) 4,720.00 56,640.00 Bundle of Cards 58,928.26 60,106.82
Water Supply (KWCD) 403.20 4,838.40 Bond Paper 5,033.87 5,134.55
Internet 1,399.00 16,788.00 Pictures of Product/Services 17,466.24 17,815.56
TOTAL 6,522.20 78,266.40 Tarpaulin 81,428.36 83,056.93
Marketing Material for Events
 4683336
4683336

Net Present Value PV @ 30% Year Cash Flow

Cash Flow 2024 - Net Investment -4683336
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment -4683336 IRR Err:523
Net Present Value @ 30% - 4,683,336.00
 NOTE 6
D' Axis
ECTED SCHEDULE OF UTILITY EXPENSES
or the year ended December 31, 2024 to 2028

2028
61,308.96
5,237.24
18,171.87
84,718.07
 NOTE 7
D' Axis
PROJECTED SCHEDULE OF PERMITS & LICENSES
For the year ended December 31, 2024 to 2028
1-3 minutes
Particulars 2024 2025 Bundle of Cards 2027
DTI Registration 200.00 - Bond Paper 206.00
Barangay Clearance 100.00 - Consumption of Ink 103.00
Fire Safety Insurance 500.00 515.00 Pictures of Product/Services 546.36
BIR Fees (Certificate of Registration) 500.00 515.00 Tarpaulin 546.36
SEC registration (Partnership) 6,750.00 6,952.50 Marketing Material for Events 7,375.91
Mayor's Permit and Business Licenses 4,810.00 4,954.30 5,102.93 5,256.02
Building Permit 6,370.00 6,561.10 6,757.93 6,960.67
TOTAL 19,230.00 19,497.90 20,082.84 20,994.32
 4683336
4683336

Net Present Value PV @ 30% Year

Cash Flow 2024 - Net Investment
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment -4683336 IRR
Net Present Value @ 30% - 4,683,336.00
2028
-
-
562.75
562.75
7,597.18
5,413.70
7,169.49
21,305.88
Cash Flow
-4683336

Err:523
 NOTE 8
D' Axis
PROJECTED SCHEDULE OF SUPPLIES
For the year ended December 31, 2024 to 2028

Description Qty Unit

Consumable Ink 10 pcs
Bond Paper 5 rims
Tarpaulin Roll 50 rolls
Paper cutter 2 pcs
Ball Pens 3 box
Calculator 2 pcs
Record Book 5 pcs
Ruler 1 pcs
Total
 NOTE 8
D' Axis
PROJECTED SCHEDULE OF SUPPLIES
For the year ended December 31, 2024 to 2028

Description Qty Unit

Net Present Value PV @ 30%

Cash Flow 2024 -
Cash Flow 2025 -
Cash Flow 2026 -
Cash Flow 2027 -
Cash Flow 2028 -
-
Cost of Investment -4,683,336.00
Net Present Value @ 30% - 4,683,336.00
 NOTE 8
D' Axis
PROJECTED SCHEDULE OF SUPPLIES Rate
For the year ended December 31, 2024 to 2028 5000
30 seconds 20000
1-3 minutes Total Cost
Pictures of Product/Services 1,790.00
Tarpaulin 925.00
Marketing Material for Events 4,000.00
350.00 700.00
60.00 180.00
288.00 576.00
50.00 250.00
215.00 215.00
8,636.00
 NOTE 8
D' Axis
PROJECTED SCHEDULE OF SUPPLIES Rate
For the year ended December 31, 2024 to 2028 5000
30 seconds 20000
1-3 minutes Total Cost

4,683,336.00
4,683,336.00

Year Cash Flow

Net Investment ###
2024
2025
2026
2027
2028
IRR Err:523
 NOTE 9
D' Axis
PROJECTED SCHEDULE OF PREPAID INSURANCE
For the year ended December 31, 2024 to 2028
1-3 minutes
Period Prepaid
Particulars Bundle of Cards Remaining Balance
Covered Insurance

(Yrs.) Bond Paper 2024 2025 2026 2027

Fire Insurance 5 15,000.00 Consumption of Ink 12,000.00 9,000.00 6,000.00 3,000.00
Building Insurance 5 25,000.00 Pictures of Product/Services 20,000.00 15,000.00 10,000.00 5,000.00
TOTAL 15,000.00 Tarpaulin 12,000.00 9,000.00 6,000.00 3,000.00
Marketing Material for Events
4683336
4683336
Net Present Value PV @ 30% Year Cash Flow
Cash Flow 2024 - Net Investmen -4683336
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment -4683336 IRR Err:523
Net Present Value @ 30% - 4,683,336.00
 NOTE 9
D' Axis
ED SCHEDULE OF PREPAID INSURANCE
he year ended December 31, 2024 to 2028

Remaining Balance

2028
-
-
-
 NOTE 10
D' Axis
PROJECTED SCHEDULE OF ACCOUNTS PAYABLE
For the year ended December 31, 2024 to 2028
1-3 minutes
Unpaid Amount
Particulars
2024 2025 Bond Paper 2027
Payable to Suppliers 479,155.20 831,018.57 Consumption of Ink 1,008,619.30
Payable to Electricity Consumption 4,720.00 4,814.40 Pictures of Product/Services 5,008.90
Payable to Water Consumption 403.20 411.26 Tarpaulin 427.88
Total 484,278.40 836,244.23 Marketing Material for Events 1,014,056.08
4683336
4683336
Net Present Value PV @ 30% Year
Cash Flow 2024 - Net Investment
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment -4683336 IRR
Net Present Value @ 30% - 4,683,336.00
 NOTE 10
D' Axis
D SCHEDULE OF ACCOUNTS PAYABLE
year ended December 31, 2024 to 2028

Unpaid Amount
2028
1,103,522.70
5,109.08
436.44
1,109,068.22
Cash Flow
-4683336

Err:523
 NOTE 11
D' Axis
PROJECTED SCHEDULE OF CAPITAL MOVEMENT
For the year ended December 31, 2024 to 2028
30 seconds 20000
2024 2025
Partners
Contribution Profit Share Infographics End. Capital Beg. Capital Profit Share Withdrawal End. Capital
Divine S. Alipo-On 650,000.00 618,160.66 Bond Paper 897,264.27 897,264.27 1,221,614.24 (732,968.54) 1,385,909.96
Jose Zaldy R. Alipo-On 650,000.00 618,160.66 Consumption of Ink 897,264.27 897,264.27 1,221,614.24 (732,968.54) 1,385,909.96
Anna Marie A. Bañares 650,000.00 618,160.66 Pictures of Product/Services 897,264.27 897,264.27 1,221,614.24 (732,968.54) 1,385,909.96
Mary Grace T. Linas 650,000.00 618,160.66 Tarpaulin 897,264.27 897,264.27 1,221,614.24 (732,968.54) 1,385,909.96
Patricia Anne M. Ortiz 650,000.00 618,160.66 Marketing Material for Events 897,264.27 897,264.27 1,221,614.24 (732,968.54) 1,385,909.96
Andrea L. Talamante 650,000.00 618,160.66 (370,896.40) 897,264.27 897,264.27 1,221,614.24 (732,968.54) 1,385,909.96
Kenneth L. Villanueva 650,000.00 618,160.66 (370,896.40) 897,264.27 897,264.27 1,221,614.24 (732,968.54) 1,385,909.96
Total 4,550,000.00 4,327,124.64 (2,596,274.78) 6,280,849.86 6,280,849.86 8,551,299.68 (5,130,779.81) 9,701,369.73
2026 2027
Partners
Beg. Capital Profit Share Withdrawal End. Capital Beg. Capital Profit Share Withdrawal End. Capital
Divine S. Alipo-On 1,385,909.96 1,191,982.48 (715,189.49) 1,862,702.95 1,862,702.95 1,500,607.36 (900,364.42) 2,462,945.90
Jose Zaldy R. Alipo-On 1,385,909.96 1,191,982.48 (715,189.49) 1,862,702.95 1,862,702.95 1,500,607.36 (900,364.42) 2,462,945.90
Anna Marie A. Bañares 1,385,909.96 1,191,982.48 (715,189.49) 1,862,702.95 1,862,702.95 1,500,607.36 (900,364.42) 2,462,945.90
Mary Grace T. Linas 1,385,909.96 1,191,982.48 (715,189.49) 1,862,702.95 1,862,702.95 1,500,607.36 (900,364.42) 2,462,945.90
Patricia Anne M. Ortiz 1,385,909.96 1,191,982.48 (715,189.49) 1,862,702.95 1,862,702.95 1,500,607.36 (900,364.42) 2,462,945.90
Andrea L. Talamante 1,385,909.96 1,191,982.48 (715,189.49) 1,862,702.95 1,862,702.95 1,500,607.36 (900,364.42) 2,462,945.90
Kenneth L. Villanueva 1,385,909.96 1,191,982.48 (715,189.49) 1,862,702.95 1,862,702.95 1,500,607.36 (900,364.42) 2,462,945.90
Total 9,701,369.73 8,343,877.38 (5,006,326.43) 13,038,920.68 13,038,920.68 10,504,251.54 (6,302,550.92) 17,240,621.30
2028
Partners
Beg. Capital Profit Share Withdrawal End. Capital
Divine S. Alipo-On 2,462,945.90 1,650,915.40 (990,549.24) 3,123,312.06
Jose Zaldy R. Alipo-On 2,462,945.90 1,650,915.40 (990,549.24) 3,123,312.06
Anna Marie A. Bañares 2,462,945.90 1,650,915.40 (990,549.24) 3,123,312.06
Mary Grace T. Linas 2,462,945.90 1,650,915.40 (990,549.24) 3,123,312.06
Patricia Anne M. Ortiz 2,462,945.90 1,650,915.40 (990,549.24) 3,123,312.06
Andrea L. Talamante 2,462,945.90 1,650,915.40 (990,549.24) 3,123,312.06
Kenneth L. Villanueva 2,462,945.90 1,650,915.40 (990,549.24) 3,123,312.06
Total 17,240,621.30 11,556,407.79 (6,933,844.67) 21,863,184.41
 4683336
4683336

Net Present Value PV @ 30% Year Cash Flow

Cash Flow 2024 - Net Investment -4683336
Cash Flow 2025 - 2024
Cash Flow 2026 - 2025
Cash Flow 2027 - 2026
Cash Flow 2028 - 2027
- 2028
Cost of Investment -4683336 IRR Err:523
Net Present Value @ 30% - 4,683,336.00
1 Gross Income 60%
2 Cost Ratio 40%

4 Repairs &Maintenance 12,000.00 103%

first year
5 Marketing Expense 5,000.00 103%

Accounting And Audit Fees - 103%

6 Miscellaneous Expense 2% of sales

7 Income Tax Rate 30%

8 Supplies 103%

9 Utilities Expense:
Electricity 6,000.00
Water 1,200.00 102%
LPG
Natural Gas
Internet 1,399.00
8,599.00
10 Share On Net Income (Withdraw) 60%

12 Petty Cash Fund 5,000.00

13 Cash In Bank
Interest Rate Per Annum 3%

14 Payroll 101%

15 Installation Cost 12,000.00

16 Rental - 3 months

Fixed & Other Investment

Land 1,800,000.00
 Building 2,400,000.00 Canal-4475
Furnitures & Fixtures 70,700.00
Machineries & Equipments 386,000.00
Pre-Operating Cost 21,636.00
Working Capital Requirements 5,000.00
Total 4,683,336.00
Each partner 669,048.00
650,000.00

Legend Sheetname
Note 1 Forecast on Sales/Service Revenue
Note 2 Estimated on Cost of Cost of Goods Sold Percentage
Note 3 Projected Schedule of Salaries & Wages
Note 4 Projected Schedule of SSS/PHIC/HDMF contributions
Note 5 Projected Schedule of Depreciation Expense
Note 6 Projected Schedule of Utility Expense
Note 7 Projected Schedule of Permits & Licenses
Note 8 Projected Schedule of Office Supplies
Note 9 Projected Schedule of Prepaid Insurance
Note 10 Projected Schedule of Accounts Payable
Note 11 Projected Schedule of Capital Movement
 YEAR
2024
2025
2026
2027
416.67 2028

-
 HOT-Gelicious Snackhouse
PROJECTED PROJECTED
PROJECTED SALES MARKET SHARE ANNUAL SALES ANNUAL SALES
103,747,586.00 7.00%
105,822,537.00 7.00%
107,938,988.00 7.00%
110,097,768.00 7.00%
112,299,723.00 7.00%
 PROJECTED PROJECTED
ANNUAL SALES MONTHLY SALES
6,766,427.080 1,197,888.00
7,346,277.220 2,077,546.42
7,975,797.730 2,052,687.00
8,659,182.830 2,521,548.25
9,401,097.920 2,758,806.75

14,374,656.00
24,930,557.00
24,632,244.00
30,258,579.00
33,105,681.00
 MONTHLY PAYROLL SU

NET INCOME

NAME No. of OT REGULAR

DAYS DAILY RATE
Employees HOURS SALARY

Marketing Director 1 24 1,166.67 14,000.00

Creative Designer 1 24 1,000.00 12,000.00
Photo-Videographer 1 24 833.33 10,000.00
Bookkeeper 1 24 916.67 11,000.00
Office Secretary 1 24 750.00 9,000.00
Office Assistant 1 24 666.67 8,000.00
TOTAL 6
MONTHLY PAYROLL SUMMARY

NCOME DEDUCTIONS

MONTHLY OT GROSS
SSS PHILHEALTH Pag-ibig TAX TOTAL
SALARY SALARY INCOME

28,000.00 28,000.00 900.00 560.00 560.00 1,433.40 3,453.40

24,000.00 24,000.00 900.00 480.00 480.00 633.40 2,493.40
20,000.00 20,000.00 900.00 400.00 400.00 - 1,700.00
22,000.00 22,000.00 900.00 440.00 440.00 - 1,780.00
18,000.00 18,000.00 810.00 360.00 360.00 - 1,530.00
16,000.00 16,000.00 720.00 320.00 320.00 - 1,360.00
128,000.00 128,000.00 900.00 2,560.00 2,560.00 - 6,020.00
 NET
PAY UNPAID SALARIES

24,546.60 5,833.33 5891.66667 5950.58333 6010.0891667 6070.1900583

21,506.60 5,000.00 5050 5100.5 5151.505 5203.02005
18,300.00 4,166.67 4208.33333 4250.41667 4292.9208333 4335.8500417
20,220.00 4,583.33 4629.16667 4675.45833 4722.2129167 4769.4350458
16,470.00
14,640.00 3,333.33 3366.66667 3400.33333 3434.3366667 3468.6800333
121,980.00 22,916.67 23145.8333 23377.2917 23611.064583 23847.175229
 RANGE OF
EE
COMPENSATION

3,249.00 135.00 255.00

3,250.00 157.50
3,750.00 180.00
4,250.00 202.50
4,750.00 225.00
5,250.00 247.50
5,750.00 270.00
6,250.00 292.50
6,750.00 315.00
7,250.00 337.50
7,750.00 360.00 348.75
8,250.00 382.50
8,750.00 405.00
9,250.00 427.50
9,750.00 450.00
10,250.00 472.50
10,750.00 495.00
11,250.00 517.50
11,750.00 540.00
12,250.00 562.50
12,750.00 585.00
13,250.00 607.50
13,750.00 630.00
14,250.00 652.50
14,750.00 675.00
15,250.00 697.50
15,750.00 720.00
16,250.00 742.50
16,750.00 765.00
17,250.00 787.50
17,750.00 810.00
18,250.00 832.50
18,750.00 855.00
19,250.00 877.50
19,750.00 900.00
20,250.00 900.00
20,750.00 900.00
21250 900
21750 900
22250 900
22750 900
23250 900
23750 900
24250 900
24750 900
 NAME GROSS INCOME GROUP MIN TAX
Marketing Director 28,000.00 2 0
Creative Designer 24,000.00 2 0
Photo-Videographer 20,000.00 1 0
Bookkeeper 22,000.00 2 0
Office Assistant 16,000.00 1 0
 TABLE
-
20,833.00
EXCESS TAX ON EXCESS TOTAL TAX DUE 33,333.00
7,167.00 1433.4 1433.4
3,167.00 633.4 633.4
20,000.00 0 0
1,167.00 233.4 233.4
16,000.00 0 0
GROUP MIN TAX EXCESS EXCESS RATE
1.00 - - 0%
2.00 - 20,833.00 20%
3.00 2,500.00 33,333.00 25%