SSS Phi

RANGE OF EMPLOYER - EMPLOYEE

MONTHLY
COMPENSATION SALARY SOCIAL SECURITY Salary Salary Range
FROM TO CREDIT ER EE TOTAL Bracket FROM
1,000.00 1,249.99 1,000.00 73.70 36.30 110.00 1 0.00
1,250.00 1,749.99 1,500.00 110.50 54.50 165.00 2 9,000.00
1,750.00 2,249.99 2,000.00 147.30 72.70 220.00 3 10,000.00
2,250.00 2,749.99 2,500.00 184.20 90.80 275.00 4 11,000.00
2,750.00 3,249.99 3,000.00 221.00 109.00 330.00 5 12,000.00
3,250.00 3,749.99 3,500.00 257.80 127.20 385.00 6 13,000.00
3,750.00 4,249.99 4,000.00 294.70 145.30 440.00 7 14,000.00
4,250.00 4,749.99 4,500.00 331.50 163.50 495.00 8 15,000.00
4,750.00 5,249.99 5,000.00 368.30 181.70 550.00 9 16,000.00
5,250.00 5,749.99 5,500.00 405.20 199.80 605.00 10 17,000.00
5,750.00 6,249.99 6,000.00 442.00 218.00 660.00 11 18,000.00
6,250.00 6,749.99 6,500.00 478.80 236.20 715.00 12 19,000.00
6,750.00 7,249.99 7,000.00 515.70 254.30 770.00 13 20,000.00
7,250.00 7,749.99 7,500.00 552.50 272.50 825.00 14 21,000.00
7,750.00 8,249.99 8,000.00 589.30 290.70 880.00 15 22,000.00
8,250.00 8,749.99 8,500.00 626.20 308.80 935.00 16 23,000.00
8,750.00 9,249.99 9,000.00 663.00 327.00 990.00 17 24,000.00
9,250.00 9,749.99 9,500.00 699.80 345.20 1,045.00 18 25,000.00
9,750.00 10,249.99 10,000.00 736.70 363.30 1,100.00 19 26,000.00
10,250.00 10,749.99 10,500.00 773.50 381.50 1,155.00 20 27,000.00
10,750.00 11,249.99 11,000.00 810.30 399.70 1,210.00 21 28,000.00
11,250.00 11,749.99 11,500.00 847.20 417.80 1,265.00 22 29,000.00
11,750.00 12,249.99 12,000.00 884.00 436.00 1,320.00 23 30,000.00
12,250.00 12,749.99 12,500.00 920.80 454.20 1,375.00 24 31,000.00
12,750.00 13,249.99 13,000.00 957.70 472.30 1,430.00 25 32,000.00
13,250.00 13,749.99 13,500.00 994.50 490.50 1,485.00 26 33,000.00
13,750.00 14,249.99 14,000.00 1,031.30 508.70 1,540.00 27 34,000.00
14,250.00 14,749.99 14,500.00 1,068.20 526.80 1,595.00 28 35,000.00
14,750.00 15,249.99 15,000.00 1,105.00 545.00 1,650.00
15,250.00 15,749.99 15,500.00 1,141.80 563.20 1,705.00
15,750.00 0.00 16,000.00 1,178.70 581.30 1,760.00
 Philhealth PagIbig
Monthly Compensation
Total Employee Employer
Salary Range Salary Base 0
Monthly Share Share
To Premium 1501
8,999.99 8,000.00 200.00 100.00 100.00
9,999.99 9,000.00 225.00 112.50 112.50
10,999.99 10,000.00 250.00 125.00 125.00
11,999.99 11,000.00 275.00 137.50 137.50
12,999.99 12,000.00 300.00 150.00 150.00
13,999.99 13,000.00 325.00 162.50 162.50
14,999.99 14,000.00 350.00 175.00 175.00
15,999.99 15,000.00 375.00 187.50 187.50
16,999.99 16,000.00 400.00 200.00 200.00
17,999.99 17,000.00 425.00 212.50 212.50
18,999.99 18,000.00 450.00 225.00 225.00
19,999.99 19,000.00 475.00 237.50 237.50
20,999.99 20,000.00 500.00 250.00 250.00
21,999.99 21,000.00 525.00 262.50 262.50
22,999.99 22,000.00 550.00 275.00 275.00
23,999.99 23,000.00 575.00 287.50 287.50
24,999.99 24,000.00 600.00 300.00 300.00
25,999.99 25,000.00 625.00 312.50 312.50
26,999.99 26,000.00 650.00 325.00 325.00
27,999.99 27,000.00 675.00 337.50 337.50
28,999.99 28,000.00 700.00 350.00 350.00
29,999.99 29,000.00 725.00 362.50 362.50
30,999.99 30,000.00 750.00 375.00 375.00
31,999.99 31,000.00 775.00 387.50 387.50
32,999.99 32,000.00 800.00 400.00 400.00
33,999.99 33,000.00 825.00 412.50 412.50
34,999.99 34,000.00 850.00 425.00 425.00
>35,000.00 35,000.00 875.00 437.50 437.50
 PagIbig Income Tax Annual
Monthly Compensation EE ER Over Not Over Tax due Plus
1500 1% 2% 0 250,000
2% 2% 250,001 400,000 20.00%
400,001 800,000 30,000.00 25.00%
800,001 2,000,000 130,000.00 30.00%
2,000,001 8,000,000 490,000.00 32.00%
8,000,001 500,000 2,410,000.00 35.00%

Income Tax Monthly Estimate

Over Not Over Tax due Plus
- 20,833.33 0.00%
20,833.42 33,333.33 20.00%
33,333.42 66,666.67 2,500.00 25.00%
66,666.75 166,666.67 10,833.33 30.00%
166,666.75 666,666.67 40,833.33 32.00%
666,666.75 41,666.67 200,833.33 35.00%
ual
of Excess Over

250,000
400,000
800,000
2,000,000
8,000,000

Estimate
of Excess Over
-
20,833.33
33,333.33
66,666.67
166,666.67
666,666.67
 Number of Employee
Employee Position/ Name Classification 2019 2020 2021 2022
1 Operational Manager AD 1 1 1 1
2 Sales Reservation IL 1 1 1 1
3 Driver DL 4 4 4 4
4 Tour Coodinator DL 4 4 4 4
5
 Daily Salary
2023 Employee Position 2019 2020 2021 2022 2023
1 1 Operational Manager 1,200.00 1,212.00 1,224.12 1,236.36 1,248.72
1 2 Sales Reservation 600.00 606.00 612.06 618.18 624.36
4 3 Driver 625.00 631.25 637.56 643.94 650.38
4 4 Tour Coodinator 480.00 484.80 489.65 494.54 499.49
5

480
 Monthly Salary
Employee Position 2019 2020 2021 2022 2023
1 Operational Manager 24,000.00 24,240.00 24,482.40 24,727.22 24,974.50 1
2 Sales Reservation 12,000.00 12,120.00 12,241.20 12,363.61 12,487.25 2
3 Driver 12,500.00 12,625.00 12,751.25 12,878.76 13,007.55 3
4 Tour Coodinator 9,600.00 9,696.00 9,792.96 9,890.89 9,989.80 4
5 5
 Annual Salary
Employee Position 2019 2020 2021 2022 2023
Operational Manager 288,000.00 290,880.00 293,788.80 296,726.69 299,693.95
Sales Reservation 144,000.00 145,440.00 146,894.40 148,363.34 149,846.98
Driver 600,000.00 606,000.00 612,060.00 618,180.60 624,362.41
Tour Coodinator 460,800.00 465,408.00 470,062.08 474,762.70 479,510.33
 Philhealth
Employee Position\Name 2019 2020 2021 2022 2023
1 Operational Manager 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00
2 Sales Reservation 1,800.00 1,800.00 1,800.00 1,800.00 1,800.00
3 Driver 7,200.00 7,200.00 7,200.00 7,200.00 7,800.00
4 Tour Coodinator 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00
5
 EMPLOYEE (ANNUAL)
SSS Pag Ibig
2019 2020 2021 2022 2023 2019 2020 2021
6,975.60 6,975.60 6,975.60 6,975.60 6,975.60 5,760.00 5,817.60 5,875.78
5,232.00 5,232.00 5,232.00 5,450.40 5,450.40 2,880.00 2,908.80 2,937.89
21,801.60 21,801.60 22,670.40 22,670.40 22,670.40 12,000.00 12,120.00 12,241.20
16,569.60 16,569.60 17,438.40 17,438.40 17,438.40 9,216.00 9,308.16 9,401.24
Pag Ibig Income Tax
2022 2023 2019 2020 2021 2022 2023
5,934.53 5,993.88 7,600.00 8,176.00 8,757.76 9,345.34 9,938.79 1
2,967.27 2,996.94 - - - - - 2
12,363.61 12,487.25 - - - - - 3
9,495.25 9,590.21 - - - - - 4
5
 EMPLOYER (ANNUAL)
Philhealth
Employee Position\Name 2019 2020 2021 2022 2023 2019
Operational Manager 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00 14,144.40
Sales Reservation 1,800.00 1,800.00 1,800.00 1,800.00 1,800.00 10,608.00
Driver 7,200.00 7,200.00 7,200.00 7,200.00 7,800.00 44,198.40
Tour Coodinator 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 33,590.40

Total 18,000.00 18,000.00 18,000.00 18,000.00 18,600.00 102,541.20

EMPLOYER (ANNUAL)
SSS Pag Ibig
2020 2021 2022 2023 2019 2020 2021 2022
14,144.40 14,144.40 14,144.40 14,144.40 5,760.00 5,817.60 5,875.78 5,934.53
10,608.00 10,608.00 11,049.60 11,049.60 2,880.00 2,908.80 2,937.89 2,967.27
44,198.40 45,969.60 45,969.60 45,969.60 12,000.00 12,120.00 12,241.20 12,363.61
33,590.40 35,361.60 35,361.60 35,361.60 9,216.00 9,308.16 9,401.24 9,495.25

102,541.20 106,083.60 106,525.20 106,525.20 29,856.00 30,154.56 30,456.11 30,760.67

 2023
5,993.88
2,996.94
12,487.25
9,590.21

31,068.27
 Project Cost
Amount
Office Furniture’s and Fixtures 6,293.00
Office Machineries 80,437.00
Tour Equipment 17,510.66
Tour Vehicle 1,449,000.00
Office Equipment 2,509.00
Van Maintenance Equipment 1,102.00
Tour Supplies 9,120.00
Van Maintenance Supply 8,474.00
Office Utility Supplies 730.00
Office Supplies 9,126.20
Engine Oil and Fuel 229,406.40
Salaries for 3 months 373,200.00
Prepaid Rent 30,000.00
Pre-Operating Expense 37,701.00
Total 2,254,609.26
 Pre-Operating Expense
Expense Amount
1 SEC Registration 2,210.00
2 BIR Registration 686.00
3 DOT Registration 5,300.00
4 Community Tax Certificate 5.00
5 Business Permit 1,349.00
6 Locational Clearance 165.00
7 Fire inspection 200.00
8 LTO Registration 24,696.00
9 LTFRB Registration 2,040.00
10 Business Clearance (travel agency) 1,000.00
11 Barangay Clearance 50.00
12
13
14
15
Total 37,701.00
 Company Name

Company Type

Year

Increase in Employee Salary

Number of Working Days

VAT

Inflation

1 Ianna Mae Rodulfo

2 Micah Jay Aringay
3 Jethro Talusan
4 Maikah Joy Aguilon
5 Jelieza Ramirez
Partners

1 Ianna Mae Rodulfo

2 Micah Jay Aringay
3 Jethro Talusan
4 Maikah Joy Aguilon
5 Jelieza Ramirez
Partners
 Expenses (Percentage of Sales)
1
2
3

Expenses (Exact Amount)

1 Advertisement Expense
2
3

Current
Income/Witholding Tax Payment
Prior

Current
Employee Benefits Payment (PagIbig,SSS,Philhealth),Utilities and VAT
Prior

Admin
Ratio of Utilities Expense
Factory

Admin
Ratio of Rent Expense
Factory

1 Telecommunication and Internet Expense

2 Electricity supply
Utilities Expense (Monthly)
3 Water supply
4

Notes Payable
Payment of Notes Payable
Interest Rate

Rent per month (W/ VAT)

Prepaid Rent (Months)

Current
Collection from Customer
Prior
 Smile for Miles Parnership

Partnership

2019 2020 2021 2022 2023

1% 1% 1% 1%

20

12%

2% 2% 2% 2%

Contribution
2019 2020 2021 2022 2023
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000

Drawings
2019 2020 2021 2022 2023
500,000 600,000 1,000,000 1,100,000 1,600,000
500,000 600,000 1,000,000 1,100,000 1,600,000
500,000 600,000 1,000,000 1,100,000 1,600,000
500,000 600,000 1,000,000 1,100,000 1,600,000
500,000 600,000 1,000,000 1,100,000 1,600,000
entage of Sales)

act Amount)
4,800.00 4,800.00 4,800.00 4,800.00 4,800.00

75% 75% 75% 75% 75%

25% 25% 25% 25% 25%

11/12 11/12 11/12 11/12 11/12

1/12 1/12 1/12 1/12 1/12

0%
100%

0%
100%

12,891.00
9,000.00
3,000.00

15,000.00 15,000.00 15,000.00 15,000.00 15,000.00

2

100%
0%
 Expenses (net of VAT)
2019 2020 2021
Percentage of Sales 13,183,374.00 15,160,880.10 17,435,012.12
1
2
3
Total - - -
Exact Amount
1 Advertisement Expense 4,285.71 4,285.71 4,285.71
2
3
Total 4,285.71 4,285.71 4,285.71
 Utilities Payable
2022 2023
20,050,263.93 23,057,803.52 Monthly Utilities
Telecommunication and Internet Expense
Electricity supply
Water supply
- -
Total Utilities Amount
4,285.71 4,285.71 TOTAL Utilities Expense
W/O VAT of Utilities Expense
VAT of Utilities Expense
4,285.71 4,285.71 Utilities Paid
Current Year
Prior Year
Total Payment
Utilities Payable
 Utilities Payable
2019 2020 2021 2022 2023
Income/(Loss)
12,891.00 13,148.82 13,411.80 13,680.03 13,953.63 Income Tax Rate
9,000.00 9,180.00 9,363.60 9,550.87 9,741.89 Income Tax Expense
3,000.00 3,060.00 3,121.20 3,183.62 3,247.30 Income Tax Paid

24,891.00 25,388.82 25,896.60 26,414.53 26,942.82

298,692.00 304,665.84 310,759.16 316,974.34 323,313.83
266,689.29 272,023.07 277,463.53 283,012.80 288,673.06 Income Tax Payable
32,002.71 32,642.77 33,295.62 33,961.54 34,640.77

273,801.00 279,277.02 284,862.56 290,559.81 296,371.01

24,891.00 25,388.82 25,896.60 26,414.53
273,801.00 304,168.02 310,251.38 316,456.41 322,785.54
24,891.00 25,388.82 25,896.60 26,414.53 26,942.82 Employee Contribution
Employer Contribution
Total Contribution
Total Payment

PagIbig Contribution Payable

Employee Contribution
Employer Contribution
Total Contribution
Total Payment

Philhealth Contribution Paya

Employee Contribution
Employer Contribution
Total Contribution
Total Payment

SSS Contribution Payable

Witholding Tax
Total Payment

Witholding Tax Payable

 Income Tax Payable
2019 2020 2021 2022 2023
Income/(Loss) ### ### 12,606,524.45 14,929,521.35 17,602,393.61
Income Tax Rate 30% 30% 30% 30% 30%
Income Tax Expense ### ### 3,781,957.34 4,478,856.41 5,280,718.08
Income Tax Paid
Current Year ### ### 2,836,468.00 3,359,142.30 3,960,538.56
Prior Year 661,314.66 794,443.00 945,489.33 1,119,714.10
Total Payment ### ### 3,630,911.00 4,304,631.64 5,080,252.66
Income Tax Payable 661,314.66 794,443.00 945,489.33 1,119,714.10 1,320,179.52

PagIbig Payable
2019 2020 2021 2022 2023
Employee Contribution 29,856.00 30,154.56 30,456.11 30,760.67 31,068.27
Employer Contribution 29,856.00 30,154.56 30,456.11 30,760.67 31,068.27
Total Contribution 59,712.00 60,309.12 60,912.21 61,521.33 62,136.55
Total Payment
Current Year 54,736.00 55,283.36 55,836.19 56,394.56 56,958.50
Prior Year 4,976.00 5,025.76 5,076.02 5,126.78
Total Payment 54,736.00 60,259.36 60,861.95 61,470.57 62,085.28
PagIbig Contribution Payable 4,976.00 5,025.76 5,076.02 5,126.78 5,178.05

Philhealth Payable
2019 2020 2021 2022 2023
Employee Contribution 18,000.00 18,000.00 18,000.00 18,000.00 18,600.00
Employer Contribution 18,000.00 18,000.00 18,000.00 18,000.00 18,600.00
Total Contribution 36,000.00 36,000.00 36,000.00 36,000.00 37,200.00
Total Payment
Current Year 33,000.00 33,000.00 33,000.00 33,000.00 34,100.00
Prior Year 3,000.00 3,000.00 3,000.00 3,000.00
Total Payment 33,000.00 36,000.00 36,000.00 36,000.00 37,100.00
Philhealth Contribution Paya 3,000.00 3,000.00 3,000.00 3,000.00 3,100.00
 SSS Payable
2019 2020 2021 2022 2023
Employee Contribution 50,578.80 50,578.80 52,316.40 52,534.80 52,534.80
Employer Contribution 102,541.20 102,541.20 106,083.60 106,525.20 106,525.20
Total Contribution 153,120.00 153,120.00 158,400.00 159,060.00 159,060.00
Total Payment
Current Year 140,360.00 140,360.00 145,200.00 145,805.00 145,805.00
Prior Year 12,760.00 12,760.00 13,200.00 13,255.00
Total Payment 140,360.00 153,120.00 157,960.00 159,005.00 159,060.00
SSS Contribution Payable 12,760.00 12,760.00 13,200.00 13,255.00 13,255.00

Witholding Tax Payable

2019 2020 2021 2022 2023
Witholding Tax 7,600.00 8,176.00 8,757.76 9,345.34 9,938.79
Total Payment
Current Year 5,700.00 6,132.00 6,568.32 7,009.00 7,454.09
Prior Year 1,900.00 2,044.00 2,189.44 2,336.33
Total Payment 5,700.00 8,032.00 8,612.32 9,198.44 9,790.43
Witholding Tax Payable 1,900.00 2,044.00 2,189.44 2,336.33 2,484.70
 Notes Payable
2019 2020 2021
Beginning - - -
Additional Notes Payable - - -
Payment of Notes Payable - - -
Total Notes Payable - - -
Interest Rate 0% 0% 0%
Interest Expense - - -

Rent
2019 2020 2021
Payment for Rent (W/ VAT) 210,000.00 180,000.00 180,000.00
Payment for Rent (W/out VAT) 187,500.00 160,714.29 160,714.29
Annual rent Expense 160,714.29 160,714.29 160,714.29
Prepaid Rent
Current 26,785.71 - -
Prior 26,785.71 26,785.71
Total Prepaid Rent 26,785.71 26,785.71 26,785.71
2022 2023
- -
- -
- -
- -
0% 0%
- -

2022 2023
180,000.00 180,000.00
160,714.29 160,714.29
160,714.29 160,714.29

- -
26,785.71 26,785.71
26,785.71 26,785.71
 2019 2020 2021 2022
Admin Employees
SE Gross Salary 288,000.00 288,000.00 288,000.00 288,000.00
SE SSS Employee 6,975.60 6,975.60 6,975.60 6,975.60
SE Philhealth Employee 3,600.00 3,600.00 3,600.00 3,600.00
SE Pagibig Employee 5,760.00 5,817.60 5,875.78 5,934.53
SE Witholding Tax 7,600.00 8,176.00 8,757.76 9,345.34
Net Pay Total 264,064.40 263,430.80 262,790.86 262,144.53

2019 2020 2021 2022

Indirect Labor Employees
SE Gross Salary 144,000.00 144,000.00 144,000.00 144,000.00
SE SSS Employee 5,232.00 5,232.00 5,232.00 5,450.40
SE Philhealth Employee 1,800.00 1,800.00 1,800.00 1,800.00
SE Pagibig Employee 2,880.00 2,908.80 2,937.89 2,967.27
SE Witholding Tax - - - -
Net Pay Total 134,088.00 134,059.20 134,030.11 133,782.33

2019 2020 2021 2022

Direct Labor Employees
SE Gross Salary 1,060,800.00 ### ### ###
SE SSS Employee 38,371.20 38,371.20 40,108.80 40,108.80
SE Philhealth Employee 12,600.00 12,600.00 12,600.00 12,600.00
SE Pagibig Employee 21,216.00 21,428.16 21,642.44 21,858.87
SE Witholding Tax - - - -
Net Pay Total 988,612.80 988,400.64 986,448.76 986,232.33
 2023 2019 2020
SSS Employer 102,541.20 102,541.20
288,000.00 Philhealth Employer 18,000.00 18,000.00
6,975.60 Pagibig Employer 29,856.00 30,154.56
3,600.00 13th Month Pay 58,100.00 58,681.00
5,993.88 Total Employee Benefits 208,497.20 209,376.76
9,938.79
261,491.73

Total SSS Contribution 153,120.00 153,120.00

Total Philhealth Contribution 36,000.00 36,000.00
2023 Total Pag-Ibig Contribution 59,712.00 60,309.12

144,000.00
5,450.40
1,800.00
2,996.94
-
133,752.66

2023

###
40,108.80
13,200.00
22,077.45
-
985,413.75
 2021 2022 2023
106,083.60 106,525.20 106,525.20
18,000.00 18,000.00 18,600.00
30,456.11 30,760.67 31,068.27
59,267.81 59,860.49 60,459.09
213,807.52 215,146.35 216,652.57

158,400.00 159,060.00 159,060.00

36,000.00 36,000.00 37,200.00
60,912.21 61,521.33 62,136.55
 2019 2020
Total Service Revenue 13,183,374.00 15,160,880.10
VAT 1,412,504.36 1,624,380.01
Net Service Revenue 11,770,869.64 13,536,500.09

Cost of Services
2019 2020
Direct Labor 1,060,800.00 1,060,800.00
Indirect Labor 144,000.00 144,000.00
Tour Supplies 8,142.86 8,926.61
Van Maintenance Supply 7,566.07 8,294.31
Engine Oil and Fuel 204,827.14 224,541.76
Depreciation Expense
Tour Equipment 11,512.97 11,512.97
Tour Vehicle 517,500.00 517,500.00
Van Maintenance Equipmen 445.71 445.71
Utilities Expense 266,689.29 272,023.07
Rent Expense 160,714.29 160,714.29
Total Cost of Good Sold 2,382,198.33 2,408,758.71
 2021 2022 2023
17,435,012.12 20,050,263.93 23,057,803.52
1,868,037.01 2,148,242.56 2,470,478.95
15,566,975.11 17,902,021.37 20,587,324.57

Services
2021 2022 2023
1,060,800.00 1,060,800.00 1,060,800.00
144,000.00 144,000.00 144,000.00
9,162.82 9,346.07 9,533.00
8,513.78 8,684.06 8,857.74
230,483.45 235,093.12 239,794.98

11,512.97 11,512.97 11,512.97

517,500.00 517,500.00 517,500.00
445.71 445.71 445.71
277,463.53 283,012.80 288,673.06
160,714.29 160,714.29 160,714.29
2,420,596.56 2,431,109.03 2,441,831.75
 Smile for Miles P
Statement of Compreh
for the year ended 2019,202
2019

Service Revenue 11,770,869.64

Cost of Services (2,382,198.33)
Gross Profit 9,388,671.31

Less: Operating Activities

Office Furniture’s and Fixtures 2,759.46
Office Machineries 20,560.00
Office Equipment 538.93
Office Utility Supplies 651.79
Office Supplies 8,148.39
Advertising Expense 4,285.71
Salaries and Wages Expense 288,000.00
Employee Benefits 208,497.20
Pre-Operating Expense 37,701.00
Total 571,142.49

Net Income before Tax 8,817,528.83

Income Tax 30% (2,645,258.65)
Net Income 6,172,270.18
mile for Miles Parnership
ment of Comprehensive Income
year ended 2019,2020,2021,2022,2023
2020 2021 2022

13,536,500.09 15,566,975.11 17,902,021.37

(2,408,758.71) (2,420,596.56) (2,431,109.03)
11,127,741.38 13,146,378.55 15,470,912.34

2,759.46 2,759.46 2,759.46

20,560.00 20,560.00 20,560.00
538.93 538.93 538.93
714.52 733.43 748.10
8,932.68 9,169.05 9,352.43
4,285.71 4,285.71 4,285.71
288,000.00 288,000.00 288,000.00
209,376.76 213,807.52 215,146.35

535,168.06 539,854.10 541,390.99

10,592,573.32 12,606,524.45 14,929,521.35

(3,177,771.99) (3,781,957.34) (4,478,856.41)
7,414,801.32 8,824,567.12 10,450,664.95
2023

20,587,324.57 Operating Activities

(2,441,831.75)
18,145,492.82

2,759.46
20,560.00
538.93
763.06
9,539.48
4,285.71
288,000.00
216,652.57

543,099.21

17,602,393.61 Investing Activities

(5,280,718.08)
12,321,675.53

Financing Activities

Total Cash Inflow/(Outflow)

Cash, Beg
Cash, End
 Smile for
Stateme
for the year ende

Operating Activities
Cash received from Customers
Cash paid for Supplies
Cash paid to Employees
Cash paid for SSS Contribution
Cash paid for Philhealth Contribution
Cash paid for PagIbig Contribution
Cash paid for Witholding Tax
Cash paid for 13th Month Pay
Cash paid for Utilities Expense
Cash paid for Rent
Cash paid for Advertisement Expense
Cash paid for Pre-operating Expense
Cash paid for VAT
Cash paid for Income Tax
Net Cash Inflow/(Outflow) from Operating Activities
Investing Activities
Cash paid for Equipments
Net Cash Inflow/(Outflow) from Investing Activities

Financing Activities
Contribution of Partners
Cash withdrawals of Partner
Net Cash Inflow/(Outflow) from Financing Activities

Total Cash Inflow/(Outflow)

Cash, Beg
Cash, End
 Smile for Miles Parnership
Statement of Cash Flows
for the year ended 2019,2020,2021,2022,2023
#NAME?
2019 2020 2021

13,183,374.00 15,160,880.10 17,435,012.12

(278,261.32) (283,826.54) (289,503.07)
(1,386,765.20) (1,385,890.64) (1,383,269.73)
(140,360.00) (153,120.00) (157,960.00)
(33,000.00) (36,000.00) (36,000.00)
(54,736.00) (60,259.36) (60,861.95)
(5,700.00) (8,032.00) (8,612.32)
(58,100.00) (58,681.00) (59,267.81)
(273,801.00) (304,168.02) (310,251.38)
(210,000.00) (180,000.00) (180,000.00)
(4,800.00) (4,800.00) (4,800.00)
(37,701.00)
(628,084.78) (1,470,165.27) (1,763,723.54)
(1,983,943.99) (3,044,643.66) (3,630,911.00)
8,088,120.72 8,171,293.61 9,549,851.31

(5,996,575.64) - -
(5,996,575.64) - -

10,000,000.00 - -
(2,500,000.00) (3,000,000.00) (5,000,000.00)
7,500,000.00 (3,000,000.00) (5,000,000.00)

9,591,545.08 5,171,293.61 4,549,851.31

9,591,545.08 14,762,838.69
9,591,545.08 14,762,838.69 19,312,689.99
#NAME? #NAME? #NAME? ###
2022 2023

20,050,263.93 23,057,803.52 Current Assets

(295,293.14) (301,199.00)
(1,382,159.20) (1,380,658.14)
(159,005.00) (159,060.00)
(36,000.00) (37,100.00)
(61,470.57) (62,085.28)
(9,198.44) (9,790.43)
(59,860.49) (60,459.09)
(316,456.41) (322,785.54)
(180,000.00) (180,000.00)
(4,800.00) (4,800.00) Non-Current Assets

(2,039,599.20) (2,337,323.77)
(4,304,631.64) (5,080,252.66) Total Assets
11,201,789.84 13,122,289.62

- (200,575.64) Liabilities
- (200,575.64) Current Liabilities

- -
(5,500,000.00) (8,000,000.00)
(5,500,000.00) (8,000,000.00)

5,701,789.84 4,921,713.98
19,312,689.99 25,014,479.84
25,014,479.84 29,936,193.82 Total Liabilities

Partners' Capital
Total Liabilities and Part
 Smile for Miles Parnersh
Statement of Financial Posi
for the year 2019,2020,2021,2022

Assets
2019
Current Assets
Cash 9,591,545.08
Prepaid Rent 26,785.71
Tour Supplies 678.57
Van Maintenance Supply 630.51
Office Utility Supplies 54.32
Office Supplies 679.03
Engine Oil and Fuel 17,068.93
Total 9,637,442.14

Non-Current Assets
Property, Plant and Equipment 4,800,768.31
Total 4,800,768.31
Total Assets 14,438,210.46

Liabilities and Partner's Cap

Liabilities 2019
Current Liabilities
Utilities Payable 24,891.00
SSS Contribution Payable 12,760.00
Pag-Ibig Contribution Payable 4,976.00
Philhealth Contribution Payable 3,000.00
Witholding Tax Payable 1,900.00
VAT payable 57,098.62
Income Tax Payable 661,314.66
Total Current Liabilities 765,940.28
Total Liabilities 765,940.28

Partners' Capital
 Ianna Mae Rodulfo, Capital 2,734,454.04
Micah Jay Aringay, Capital 2,734,454.04
Jethro Talusan, Capital 2,734,454.04
Maikah Joy Aguilon, Capital 2,734,454.04
Jelieza Ramirez, Capital 2,734,454.04
Total Partners' Capital 13,672,270.18

Total Liabilities and Partner's Capital 14,438,210.46

0.00
 Smile for Miles Parnership
Statement of Financial Position
r the year 2019,2020,2021,2022,2023

Assets
2020 2021 2022

14,762,838.69 19,312,689.99 25,014,479.84

26,785.71 26,785.71 26,785.71
749.82 764.82 780.11
696.71 710.64 724.86
60.02 61.22 62.44
750.33 765.34 780.64
18,861.17 19,238.39 19,623.16
14,810,742.45 19,361,016.12 25,063,236.77

4,247,451.24 3,694,134.16 3,140,817.08

4,247,451.24 3,694,134.16 3,140,817.08
19,058,193.68 23,055,150.27 28,204,053.85

Liabilities and Partner's Capital

2020 2021 2022

25,388.82 25,896.60 26,414.53

12,760.00 13,200.00 13,255.00
5,025.76 5,076.02 5,126.78
3,000.00 3,000.00 3,000.00
2,044.00 2,189.44 2,336.33
128,460.60 148,660.27 171,903.54
794,443.00 945,489.33 1,119,714.10
971,122.18 1,143,511.65 1,341,750.28
971,122.18 1,143,511.65 1,341,750.28
 3,617,414.30 4,382,327.72 5,372,460.71
3,617,414.30 4,382,327.72 5,372,460.71
3,617,414.30 4,382,327.72 5,372,460.71
3,617,414.30 4,382,327.72 5,372,460.71
3,617,414.30 4,382,327.72 5,372,460.71
18,087,071.50 21,911,638.62 26,862,303.56

19,058,193.68 23,055,150.27 28,204,053.85

0.00 - 0.00
 Sm
Statemen
for the ye

2023
For each Partner
29,936,193.82 Beginning
26,785.71 Additonal Contribution
795.72 Share in Profit and Loss
739.35 Withdrawals
63.69 Ending, Capital
796.26
20,015.62
29,985,390.17

2,766,585.39
2,766,585.39
32,751,975.56

2023

26,942.82
13,255.00
5,178.05
3,100.00
2,484.70
196,856.38
1,320,179.52
1,567,996.47
1,567,996.47
 6,236,795.82
6,236,795.82
6,236,795.82
6,236,795.82
6,236,795.82
31,183,979.09

32,751,975.56

-
 Smile for Miles Parnership
Statement of Changes in Partners' Equity
for the year ended 2019,2020,2021,2022,2023

2019 2020 2021

2,000,000.00 2,734,454.04 3,617,414.30

- -
1,234,454.04 1,482,960.26 1,764,913.42
(500,000.00) (600,000.00) (1,000,000.00)
2,734,454.04 3,617,414.30 4,382,327.72
quity
023

2022 2023

4,382,327.72 5,372,460.71
- -
2,090,132.99 2,464,335.11
(1,100,000.00) (1,600,000.00)
5,372,460.71 6,236,795.82
 Classification COGS or Expense
1 Office Furniture’s and Fixtures Expense
2 Office Machineries Expense
3 Tour Equipment COS 1
4 Tour Vehicle COS 2
5 Office Equipment Expense 3
6 Van Maintenance Equipment COS 4
7 Engine Oil and Fuel COS 5
8 6
9 7
10 8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 Classification COS or Expense

Office Machineries Expense

Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Machineries Expense
Office Furniture’s and Fixtures Expense
Office Furniture’s and Fixtures Expense
Office Furniture’s and Fixtures Expense
Office Furniture’s and Fixtures Expense
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Equipment COS
Tour Vehicle COS
Office Equipment Expense
Office Equipment Expense
 Office Equipment Expense
Office Equipment Expense
Office Equipment Expense
Office Equipment Expense
Office Equipment Expense
Van Maintenance Equipment COS
Van Maintenance Equipment COS
Van Maintenance Equipment COS

Total
 Useful lIfe Quantity
PPE Name Price
(Years) (pcs)
LENOVO IDEA CENTRE 21.5" COMPUTER 5 17,095.00 3
CANON E410 PRINTER SCANNER COPIER PRINTER 5 3,480.00 1
AIR CONDITIONER 5 15,677.00 1
INTERNET & TELEPHONE 5 1,699.00 1
CCTV 5 6,500.00 1
STAPLER 5 95.00 2
WALL CLOCK 5 150.00 1
DECORATIONS 5 2,000.00 1
PUNCHER 5 69.00 2
SCISSORS 5 45.00 2
TAPE DISPENSER 5 75.00 2
SIGN BOARDS 5 75.00 4
TELEVISION 5 13,300.00 1
PROMATE PH1,500 GASOLINE GENERATOR 5 13,999.00 1
FIRE DISTINGUISHER 5 1,179.00 1
FAX MACHINE 5 4,999.00 1
OFFICE TABLE 5 2,650.00 2
OFFICE CHAIR 5 1,349.00 3
GUEST CHAIR 5 759.00 4
CABINETS 5 1,535.00 2
WIFI 5 1,799.00 4
KARAOKE MACHINE 5 1,800.00 4
DASH CAMERA 5 950.00 4
TELEVISION 5 3,039.00 2
FLASHDRIVE 5 699.00 4
VACUUM 5 686.00 2
EXTRA TIRE 5 3,692.00 4
CAR TRASH BIN 5 120.00 4
CAR TOOLS SET 5 1,559.00 4
EMERGENCY LIGHT 5 715.00 4
MED KIT 5 270.00 4
GLOVES 5 112.66 4
PORTABLE GAS STOVE 5 499.00 4
TENT 5 470.00 8
ICE BOX (COOLER) 5 1,100.00 4
Nissan Urban NV350 10 1,449,000.00 4
WALL CLOCK 5 150.00 1
DECORATIONS 5 2,000.00 1
 SIGNBOARDS 5 75.00 4
STAPLER 5 95.00 2
PUNCHER 5 69.00 2
SCISSORS 5 45.00 2
TAPE DISPENSER 5 75.00 2
VACUUM 5 686.00 2
GLASS CLEANER 5 146.00 4
WATER CANNON HOSE 5 270.00 2
 Depreciation
Total Amount (With Total Amount (W/o Depreciation 2019
VAT) VAT) Expense
51,285.00 45,790.18 9,158.04 9,158.04
3,480.00 3,107.14 621.43 621.43
15,677.00 13,997.32 2,799.46 2,799.46
1,699.00 1,516.96 303.39 303.39
6,500.00 5,803.57 1,160.71 1,160.71
190.00 169.64 33.93 33.93
150.00 133.93 26.79 26.79
2,000.00 1,785.71 357.14 357.14
138.00 123.21 24.64 24.64
90.00 80.36 16.07 16.07
150.00 133.93 26.79 26.79
300.00 267.86 53.57 53.57
13,300.00 11,875.00 2,375.00 2,375.00
13,999.00 12,499.11 2,499.82 2,499.82
1,179.00 1,052.68 210.54 210.54
4,999.00 4,463.39 892.68 892.68
5,300.00 4,732.14 946.43 946.43
4,047.00 3,613.39 722.68 722.68
3,036.00 2,710.71 542.14 542.14
3,070.00 2,741.07 548.21 548.21
7,196.00 6,425.00 1,285.00 1,285.00
7,200.00 6,428.57 1,285.71 1,285.71
3,800.00 3,392.86 678.57 678.57
6,078.00 5,426.79 1,085.36 1,085.36
2,796.00 2,496.43 499.29 499.29
1,372.00 1,225.00 245.00 245.00
14,768.00 13,185.71 2,637.14 2,637.14
480.00 428.57 85.71 85.71
6,236.00 5,567.86 1,113.57 1,113.57
2,860.00 2,553.57 510.71 510.71
1,080.00 964.29 192.86 192.86
450.64 402.36 80.47 80.47
1,996.00 1,782.14 356.43 356.43
3,760.00 3,357.14 671.43 671.43
4,400.00 3,928.57 785.71 785.71
5,796,000.00 5,175,000.00 517,500.00 517,500.00
150.00 133.93 26.79 26.79
2,000.00 1,785.71 357.14 357.14
 300.00 267.86 53.57 53.57
190.00 169.64 33.93 33.93
138.00 123.21 24.64 24.64
90.00 80.36 16.07 16.07
150.00 133.93 26.79 26.79
1,372.00 1,225.00 245.00 245.00
584.00 521.43 104.29 104.29
540.00 482.14 96.43 96.43

5,996,575.64 553,317.08 553,317.08

 Depreciation Expense Accumul
2020 2021 2022 2023 2019
1
9,158.04 9,158.04 9,158.04 9,158.04 9,158.04
621.43 621.43 621.43 621.43 621.43
2,799.46 2,799.46 2,799.46 2,799.46 2,799.46
303.39 303.39 303.39 303.39 303.39
1,160.71 1,160.71 1,160.71 1,160.71 1,160.71
33.93 33.93 33.93 33.93 33.93
26.79 26.79 26.79 26.79 26.79
357.14 357.14 357.14 357.14 357.14
24.64 24.64 24.64 24.64 24.64
16.07 16.07 16.07 16.07 16.07
26.79 26.79 26.79 26.79 26.79
53.57 53.57 53.57 53.57 53.57
2,375.00 2,375.00 2,375.00 2,375.00 2,375.00
2,499.82 2,499.82 2,499.82 2,499.82 2,499.82
210.54 210.54 210.54 210.54 210.54
892.68 892.68 892.68 892.68 892.68
946.43 946.43 946.43 946.43 946.43
722.68 722.68 722.68 722.68 722.68
542.14 542.14 542.14 542.14 542.14
548.21 548.21 548.21 548.21 548.21
1,285.00 1,285.00 1,285.00 1,285.00 1,285.00
1,285.71 1,285.71 1,285.71 1,285.71 1,285.71
678.57 678.57 678.57 678.57 678.57
1,085.36 1,085.36 1,085.36 1,085.36 1,085.36
499.29 499.29 499.29 499.29 499.29
245.00 245.00 245.00 245.00 245.00
2,637.14 2,637.14 2,637.14 2,637.14 2,637.14
85.71 85.71 85.71 85.71 85.71
1,113.57 1,113.57 1,113.57 1,113.57 1,113.57
510.71 510.71 510.71 510.71 510.71
192.86 192.86 192.86 192.86 192.86
80.47 80.47 80.47 80.47 80.47
356.43 356.43 356.43 356.43 356.43
671.43 671.43 671.43 671.43 671.43
785.71 785.71 785.71 785.71 785.71
517,500.00 517,500.00 517,500.00 517,500.00 517,500.00
26.79 26.79 26.79 26.79 26.79
357.14 357.14 357.14 357.14 357.14
 53.57 53.57 53.57 53.57 53.57
33.93 33.93 33.93 33.93 33.93
24.64 24.64 24.64 24.64 24.64
16.07 16.07 16.07 16.07 16.07
26.79 26.79 26.79 26.79 26.79
245.00 245.00 245.00 245.00 245.00
104.29 104.29 104.29 104.29 104.29
96.43 96.43 96.43 96.43 96.43

553,317.08 553,317.08 553,317.08 553,317.08 553,317.08

 Accumulated Depreciation Purchases and Payment of Property,Plant a
2020 2021 2022 2023 2019 2020
2 3 4 5 1 2
18,316.07 27,474.11 36,632.14 45,790.18 45,790.18
1,242.86 1,864.29 2,485.71 3,107.14 3,107.14
5,598.93 8,398.39 11,197.86 13,997.32 13,997.32
606.79 910.18 1,213.57 1,516.96 1,516.96
2,321.43 3,482.14 4,642.86 5,803.57 5,803.57
67.86 101.79 135.71 169.64 169.64
53.57 80.36 107.14 133.93 133.93
714.29 1,071.43 1,428.57 1,785.71 1,785.71
49.29 73.93 98.57 123.21 123.21
32.14 48.21 64.29 80.36 80.36
53.57 80.36 107.14 133.93 133.93
107.14 160.71 214.29 267.86 267.86
4,750.00 7,125.00 9,500.00 11,875.00 11,875.00
4,999.64 7,499.46 9,999.29 12,499.11 12,499.11
421.07 631.61 842.14 1,052.68 1,052.68
1,785.36 2,678.04 3,570.71 4,463.39 4,463.39
1,892.86 2,839.29 3,785.71 4,732.14 4,732.14
1,445.36 2,168.04 2,890.71 3,613.39 3,613.39
1,084.29 1,626.43 2,168.57 2,710.71 2,710.71
1,096.43 1,644.64 2,192.86 2,741.07 2,741.07
2,570.00 3,855.00 5,140.00 6,425.00 6,425.00
2,571.43 3,857.14 5,142.86 6,428.57 6,428.57
1,357.14 2,035.71 2,714.29 3,392.86 3,392.86
2,170.71 3,256.07 4,341.43 5,426.79 5,426.79
998.57 1,497.86 1,997.14 2,496.43 2,496.43
490.00 735.00 980.00 1,225.00 1,225.00
5,274.29 7,911.43 10,548.57 13,185.71 13,185.71
171.43 257.14 342.86 428.57 428.57
2,227.14 3,340.71 4,454.29 5,567.86 5,567.86
1,021.43 1,532.14 2,042.86 2,553.57 2,553.57
385.71 578.57 771.43 964.29 964.29
160.94 241.41 321.89 402.36 402.36
712.86 1,069.29 1,425.71 1,782.14 1,782.14
1,342.86 2,014.29 2,685.71 3,357.14 3,357.14
1,571.43 2,357.14 3,142.86 3,928.57 3,928.57
1,035,000.00 1,552,500.00 2,070,000.00 2,587,500.00 5,175,000.00
53.57 80.36 107.14 133.93 133.93
714.29 1,071.43 1,428.57 1,785.71 1,785.71
 107.14 160.71 214.29 267.86 267.86
67.86 101.79 135.71 169.64 169.64
49.29 73.93 98.57 123.21 123.21
32.14 48.21 64.29 80.36 80.36
53.57 80.36 107.14 133.93 133.93
490.00 735.00 980.00 1,225.00 1,225.00
208.57 312.86 417.14 521.43 521.43
192.86 289.29 385.71 482.14 482.14

1,106,634.16 1,659,951.24 2,213,268.31 2,766,585.39 5,354,085.39 -

ayment of Property,Plant and Equipment (W/out VAT) VAT of PPE
2021 2022 2023 2019 2020 2021
3 4 5 1 2 3
45,790.18 5,494.82
3,107.14 372.86
13,997.32 1,679.68
1,516.96 182.04
5,803.57 696.43
169.64 20.36
133.93 16.07
1,785.71 214.29
123.21 14.79
80.36 9.64
133.93 16.07
267.86 32.14
11,875.00 1,425.00
12,499.11 1,499.89
1,052.68 126.32
4,463.39 535.61
4,732.14 567.86
3,613.39 433.61
2,710.71 325.29
2,741.07 328.93
6,425.00 771.00
6,428.57 771.43
3,392.86 407.14
5,426.79 651.21
2,496.43 299.57
1,225.00 147.00
13,185.71 1,582.29
428.57 51.43
5,567.86 668.14
2,553.57 306.43
964.29 115.71
402.36 48.28
1,782.14 213.86
3,357.14 402.86
3,928.57 471.43
621,000.00
133.93 16.07
1,785.71 214.29
 267.86 32.14
169.64 20.36
123.21 14.79
80.36 9.64
133.93 16.07
1,225.00 147.00
521.43 62.57
482.14 57.86

- - 179,085.39 642,490.25 - -
AT of PPE PPE, net
2022 2023 2019 2020
4 5 1 2
5,494.82 Beginning - 5,354,085.39
372.86 Purchases 5,354,085.39 -
1,679.68 Disposal - -
182.04 Total 5,354,085.39 5,354,085.39
696.43 Accumulated Depreciation (553,317.08) (1,106,634.16)
20.36 PPE, net 4,800,768.31 4,247,451.24
16.07
214.29
14.79
9.64
16.07
32.14
1,425.00
1,499.89
126.32
535.61
567.86
433.61
325.29
328.93
771.00
771.43
407.14
651.21
299.57
147.00
1,582.29
51.43
668.14
306.43
115.71
48.28
213.86
402.86
471.43

16.07
214.29
 32.14
20.36
14.79
9.64
16.07
147.00
62.57
57.86

- 21,490.25
PPE, net
2021 2022 2023
3 4 5
5,354,085.39 5,354,085.39 5,354,085.39
- - 179,085.39
- - -
5,354,085.39 5,354,085.39 5,533,170.79
(1,659,951.24) (2,213,268.31) (2,766,585.39)
3,694,134.16 3,140,817.08 2,766,585.39
 Classification COGS or Expense
1 Tour Supplies COS
2 Van Maintenance Supply COS
Classification
3 Office Utility Supplies Expense
4 Office Supplies Expense 1 Tour Supplies
5 Engine Oil and Fuel COS 2 Tour Supplies
6 3 Tour Supplies
7 4 Van Maintenance Supply
8 5 Van Maintenance Supply
9 6 Van Maintenance Supply
10 7 Van Maintenance Supply
8 Van Maintenance Supply
9 Van Maintenance Supply
10 Van Maintenance Supply
11 Van Maintenance Supply
12 Van Maintenance Supply
13 Office Utility Supplies
14 Office Utility Supplies
15 Office Utility Supplies
16 Office Supplies
17 Office Supplies
18 Office Supplies
19 Office Supplies
20 Office Supplies
21 Office Supplies
22 Office Supplies
23 Office Supplies
24 Office Supplies
25 Office Supplies
26 Office Supplies
27 Office Supplies
28 Office Supplies
29 Office Supplies
30 Office Supplies
31 Office Supplies
32 Office Supplies
33 Office Supplies
34 Office Supplies
35 Office Supplies
36 Office Supplies
37 Office Supplies
38 Engine Oil and Fuel
39 Engine Oil and Fuel
40
41
42
43
44
45
 Supplie
COGS or Expense Supply Name Quantity Amount Usage per Year
COS GARBAGE BAG 25 60.00 1
COS HAND SANITIZER/ ALCOHOL 105 24.00 1
COS BUTANE FOR GAS STOVE 850 6.00 1
COS CAR CLEAN TOWEL 252 4.00 1
COS CAR AIR FRESHENER 159 8.00 1
COS CAR WASH SHAMPOO 133 4.00 1
COS TIRE BLACK SHAMPOO 150 4.00 1
COS CLEANING SPONGE 180 4.00 1
COS AIR VENT SLIT CLEANING BRUSH 97 4.00 1
COS WHEEL BRUSH 325 4.00 1
COS SOFT CLEANING BRUSHES 282 4.00 1
COS CAR PRESSURE WASHER SPRAY 763 2.00 1
Expense BROOM & DUSTPAN 120 1.00 1
Expense MOP 320 1.00 1
Expense TRASH BIN 290 1.00 1
Expense BOND PAPER-Long 6 160.00 1
Expense BOND PAPER-Short 6 150.00 1
Expense INKS 3 700.00 1
Expense CASH VOUCHER 6 30.00 1
Expense LEDGER/JOURNAL 3 35.00 1
Expense PENCIL 12 4.50 1
Expense BALLPENS 12 5.80 1
Expense FOLDER-LONG 12 6.00 1
Expense FOLDER-SHORT 12 4.80 1
Expense CALCULATOR 2 150.00 1
Expense EXPANDABLE ENVELOPE-LONG 12 19.00 1
Expense EXPANDABLE ENVELOPE-SHORT 12 16.00 1
Expense PAPER FASTENER 12 40.00 1
Expense PAPER CLIPS 12 69.00 1
Expense STAPLE WIRES 10 15.00 1
Expense GLUE 5 13.00 1
Expense RULER 2 18.00 1
Expense MARKER 2 25.00 1
Expense SCOTCH TAPE 5 15.00 1
Expense LIQUID ERASURE 2 52.00 1
Expense TIME CARD 100 20.00 1
Expense CALENDAR 2 60.00 1
COS FUEL 3120 44.72 1
COS ENGINE OIL 280 321.00 1

Total
 Supplies
Total Annual Expense Supplies Purchases Without Vat
(With VAT) 2019 2020 2021 2022
1,500.00 1,450.89 1,479.91 1,509.51 1,539.70
2,520.00 2,437.50 2,486.25 2,535.98 2,586.69
5,100.00 4,933.04 5,031.70 5,132.33 5,234.98
1,008.00 975.00 994.50 1,014.39 1,034.68
1,272.00 1,230.36 1,254.96 1,280.06 1,305.66
532.00 514.58 524.88 535.37 546.08
600.00 580.36 591.96 603.80 615.88
720.00 696.43 710.36 724.56 739.06
388.00 375.30 382.80 390.46 398.27
1,300.00 1,257.44 1,282.59 1,308.24 1,334.41
1,128.00 1,091.07 1,112.89 1,135.15 1,157.85
1,526.00 1,476.04 1,505.56 1,535.67 1,566.39
120.00 116.07 118.39 120.76 123.18
320.00 309.52 315.71 322.03 328.47
290.00 280.51 286.12 291.84 297.68
960.00 928.57 947.14 966.09 985.41
900.00 870.54 887.95 905.71 923.82
2,100.00 2,031.25 2,071.88 2,113.31 2,155.58
180.00 174.11 177.59 181.14 184.76
105.00 101.56 103.59 105.67 107.78
54.00 52.23 53.28 54.34 55.43
69.60 67.32 68.67 70.04 71.44
72.00 69.64 71.04 72.46 73.91
57.60 55.71 56.83 57.97 59.12
300.00 290.18 295.98 301.90 307.94
228.00 220.54 224.95 229.45 234.03
192.00 185.71 189.43 193.22 197.08
480.00 464.29 473.57 483.04 492.70
828.00 800.89 816.91 833.25 849.91
150.00 145.09 147.99 150.95 153.97
65.00 62.87 64.13 65.41 66.72
36.00 34.82 35.52 36.23 36.95
50.00 48.36 49.33 50.32 51.32
75.00 72.54 74.00 75.48 76.98
104.00 100.60 102.61 104.66 106.75
2,000.00 1,934.52 1,973.21 2,012.68 2,052.93
120.00 116.07 118.39 120.76 123.18
139,526.40 134,958.57 137,657.74 140,410.90 143,219.12
89,880.00 86,937.50 88,676.25 90,449.78 92,258.77

256,856.60 248,447.60 253,416.56 258,484.89 263,654.59

 Supplies VAT
Vat Supplies 2019 2020 2021
2023 1 Tour Supplies 1,058.57 1,079.74 1,101.34
1,570.49 2 Van Maintenance Supply 983.59 1,003.26 1,023.33
2,638.43 3 Office Utility Supplies 84.73 86.43 88.16
5,339.68 4 Office Supplies 1,059.29 1,080.48 1,102.09
1,055.37 5 Engine Oil and Fuel 26,627.53 27,160.08 27,703.28
1,331.78 6
557.00 7
628.20 8
753.84 9
406.23 10
1,361.09
1,181.01
1,597.71
125.64 Supplies purchases with VAT
335.04 Supplies 2019 2020 2021
303.63 1 Tour Supplies 9,880.00 10,077.60 10,279.15
1,005.12 2 Van Maintenance Supply 9,180.17 9,363.77 9,551.05
942.30 3 Office Utility Supplies 790.83 806.65 822.78
2,198.69 4 Office Supplies 9,886.72 10,084.45 10,286.14
188.46 5 Engine Oil and Fuel 248,523.60 253,494.07 258,563.95
109.93 6
56.54 7
72.87 8
75.38 9
60.31 10
314.10
238.71
201.02
502.56
866.91
157.05
68.05
37.69
52.35
78.52
108.89
2,093.99
125.64
146,083.50
94,103.95

268,927.68
 Supplies Begining 2019 2020
1 Tour Supplies 678.57
2022 2023 2 Van Maintenance Supply 630.51
1,123.36 1,145.83 3 Office Utility Supplies 54.32
1,043.79 1,064.67 4 Office Supplies 679.03
89.92 91.72 5 Engine Oil and Fuel 17,068.93
1,124.13 1,146.61 6
28,257.35 28,822.49 7
8
9
10
Supplies Purchases
1 Tour Supplies 8,821.43 8,997.86
2 Van Maintenance Sup 8,196.58 8,360.51
3 Office Utility Supplies 706.10 720.22
4 Office Supplies 8,827.43 9,003.97
VAT 5 Engine Oil and Fuel 221,896.07 226,333.99
2022 2023 6
10,484.74 10,694.43 7
9,742.07 9,936.91 8
839.24 856.02 9
10,491.86 10,701.70 10
263,735.23 269,009.94 Supplies Expense
1 Tour Supplies 8,142.86 8,926.61
2 Van Maintenance Sup 7,566.07 8,294.31
3 Office Utility Supplies 651.79 714.52
4 Office Supplies 8,148.39 8,932.68
5 Engine Oil and Fuel 204,827.14 224,541.76
6
7
8
9
10
Supplies Ending
1 Tour Supplies 678.57 749.82
2 Van Maintenance Sup 630.51 696.71
3 Office Utility Supplies 54.32 60.02
4 Office Supplies 679.03 750.33
5 Engine Oil and Fuel 17,068.93 18,861.17
6
7
 8
9
10
 2021 2022 2023
749.82 764.82 780.11
696.71 710.64 724.86
60.02 61.22 62.44
750.33 765.34 780.64
18,861.17 19,238.39 19,623.16

9,177.81 9,361.37 9,548.60

8,527.72 8,698.27 8,872.24
734.63 749.32 764.31
9,184.05 9,367.73 9,555.09
230,860.67 235,477.89 240,187.44

9,162.82 9,346.07 9,533.00

8,513.78 8,684.06 8,857.74
733.43 748.10 763.06
9,169.05 9,352.43 9,539.48
230,483.45 235,093.12 239,794.98

764.82 780.11 795.72

710.64 724.86 739.35
61.22 62.44 63.69
765.34 780.64 796.26
19,238.39 19,623.16 20,015.62
Liquidity Ratios
Current Ratio

Acid Test Ratio

Debt/Equity Ratios/Levera
Debt to Net Worth Rati

Profitability Ratios
Gross Profit Margin Rat

Net Income Margin

Invested Capital Turnov

Return on Investment
 Formula 2019 2020

Current Assets/Current Liability 1258% 1525%

Current Assets-Inventories-Prepaid Expenses/Current Liability 1255% 1522%

Total Liabilities/Total Capital 6% 5%

Gross Profit/Revenues 80% 82%

Net Income/Sales 52% 55%

Sales/ Invested Capital 1.1770869643 0.9900696747

Net Income/ Invested Capital 0.617227018 0.5423240781

 2021 2022 2023

1693% 1868% 1912%

1691% 1866% 1911%

5% 5% 5%

84% 86% 88%

57% 58% 60%

0.8606686332 0.8170097033 0.7664020519

0.4878936381 0.4769458427 0.4586976504

 2019 2020 2021
Beg
PPE (642,490.25) - -
Supplies (29,813.71) (30,409.99) (31,018.19)
Utilities (32,002.71) (32,642.77) (33,295.62)
Rent (22,500.00) (19,285.71) (19,285.71)
Expenses (514.29) (514.29) (514.29)
Ouput Vat 1,412,504.36 1,624,380.01 1,868,037.01
(Input)/Output VAT 685,183.40 1,541,527.26 1,783,923.20
 2022 2023 2019 2020
Output VAT 685,183.40 1,541,527.26
- (21,490.25) Current 628,084.78 1,413,066.65
(31,638.55) (32,271.32) Prior - 57,098.62
(33,961.54) (34,640.77) Total Payment 628,084.78 1,470,165.27
(19,285.71) (19,285.71) VAT Payable 57,098.62 128,460.60
(514.29) (514.29)
2,148,242.56 2,470,478.95
2,062,842.48 2,362,276.61
 2021 2022 2023
1,783,923.20 2,062,842.48 2,362,276.61
1,635,262.94 1,890,938.94 2,165,420.23
128,460.60 148,660.27 171,903.54
1,763,723.54 2,039,599.20 2,337,323.77
148,660.27 171,903.54 196,856.38