PROJECTED STATEMENT OF ACTIVITIES

USJ-R Mobile School

Statement of Activities
For The Years Ended December 31

Schedule 2019 2020 2021 2022 2023

Contributions revenue
Restricted contributions 2 30,000.00 30,000.00 31,500.00 31,500.00 33,075.00
Unrestricted 3 110,000.00 110,000.00 115,500.00 115,500.00 121,275.00
contributions
Total 140,000.00 140,000.00 147,000.00 147,000.00 154,350.00
Expenses:
Program
Per diem Expense 7 6,600.00 6,600.00 6,750.00 7,317.00 7,931.66
Depreciation Expense 6 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00
Utilities Expenses 10 4,532.00 4,664.00 4,770.00 4,770.00 4,770.00
School Supplies Expense 4 12,012.30 5,369.11 5,651.15 2,835.99 6,375.49
Cleaning Supplies Expense 5 309.00 384.60 478.29 465.37 526.82
Meals 12 17,820.00 17,820.00 18,225.00 18,225.00 18,225.00
Total 45,273.30 38,837.71 39,874.44 37,613.35 41,828.97
Administrative Expense
Advertising Expense 9 3,000.00 510.00 3,045.20 515.00 3,060.10
Project Fasibility 8 8,800.00 - - - -
Repairs and Maintenance 11 16,000.00 16,000.00 16,480.00 16,974.40 17,483.63
Total 27,800.00 16,510.00 19,525.20 17,489.40 20,543.73
Total expenses 73,073.30 55,347.71 59,399.64 55,102.75 62,372.70

Excess of Revenues over 66,926.70 84,652.29 87,600.36 91,897.25 91,977.30

Expenses
 PROJECTED STATEMENT OF FINANCIAL POSITION
USJ-R Mobile School
Statement of Financial Position
As of December 31, 2018

Assets Schedule 2019 2020 2021 2022 2023

Current Assets
Cash SCF 193,312.50 286,943.19 378,893.06 477,326.10 571,607.80
Supplies 4&5 8,214.20 3,835.80 4,086.29 2,200.90 4,601.54
Total 201,526.70 290,778.99 382,979.35 479,527.00 576,209.34

Noncurrent Assets
Furnitures and Fixtures 6 16,000.00 12,000.00 8,000.00 4,000.00 -
Total 16,000.00 12,000.00 8,000.00 4,000.00 -
Total Assets 217,526.70 302,778.99 390,979.35 483,527.00 576,209.34

Liabilities and Net

Assets
Current Liabilities
Accrued Per diem 7 600.00 1,200.00 1,800.00 2,450.40 3,155.44
Total Liabilities 600.00 1,200.00 1,800.00 2,450.40 3,155.44
Net Assets
Capital contribution 150,000.00 216,926.70 301,578.99 389,179.35 481,076.60
Excess of Revenues over SOA 66,926.70 84,652.29 87,600.36 91,897.25 91,977.30
expenses
Total net assets 216,926.70 301,578.99 389,179.35 481,076.60 573,053.91

Total Liabilities and Net 217,526.70 302,778.99 390,979.35 483,527.00 576,209.34

Assets
 PROJECTED STATEMENT OF CHANGES IN EQUITY
USJ-R Mobile School
Statement of Changes in Equity
As of December 31, 2019

Note 2019 2020 2021 2022 2023

Capital contribution 150,000.00

Accumulated Deficiency of
Revenue over Expenses
Balance at the beginning of 216,926.70 301,578.99 389,179.35 481,076.60
the year
Excess (deficiency)of revenue SOA 66,926.70 84,652.29 87,600.36 91,897.25 91,977.30
over expenses
Total 66,926.70 301,578.99 389,179.35 481,076.60 573,053.91
Total Equity 216,926.70 301,578.99 389,179.35 481,076.60 573,053.91
 PROJECTED STATEMENT OF CASH FLOWS
USJ-R MOBILE SCHOOL
Statement of Cash Flows
As of December 31

Schedule 2019 2020 2021 2022 2023

Operating Cash Flows
Excess of Revenue over SOA 66,926.70 84,652.29 87,600.36 91,897.25 91,977.30
expenses
Add: Depreciation SOA 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00
Expense
Net income before depreciation
(Increase) Decrease of SFP (8,214.20) 4,378.40 (250.49) 1,885.39 (2,400.64)
Supplies
Increase (Decrease) SFP 600.00 600.00 600.00 650.40 705.04
Accrued Per diem
Net Operating Activities 63,312.50 93,630.69 91,949.87 98,433.04 94,281.70

Investing Cash Flows

Additions on Furnitures & 6 (20,000.00) - - - -
Fixtures
Net Investing Activities (20,000.00) - - - -

Financing Cash Flows

Additional Investments SFP 150,000.00 - - - -
Net Financing Activities 150, 000.00
Net Cash Flows 43,312.50 93,630.69 91,949.87 98,433.04 94,281.70
Add: Beginning cash balance 150,000.00 193,312.50 286,943.19 378,893.06 477,326.10
Cash balance, end 193,312.50 286,943.19 378,893.06 477,326.10 571,607.80
 Schedule 1
Projected Contributions Revenue
Particulars Schedule 2019 2020 2021 2022 2023
Restricted Contributions 2 30,000.00 30,000.00 31,500.00 31,500.00 33,075.00
Revenue
Unrestricted Contributions 3 110,000.00 110,000.00 115,500.00 115,500.00 121,275.00
Revenue
TOTAL 140,000.00 140,000.00 147,000.00 147,000.00 154,350.00

Schedule 2
Restricted Contributions Revenue
Particulars Note 2019 2020 2021 2022 2023
Private Individuals/Companies ( see chapter 30,000.00 30,000.00 31,500.00 31,500.00 33,075.00
2)
TOTAL 30,000.00 30,000.00 31,500.00 31,500.00 33,075.00
 Schedule 3
Unrestricted Contributions Revenue
Particulars Note 2019 2020 2021 2022 2023
Jollibee 10,000.00 10,000.00 10,500.00 10,500.00 11,025.00
McDonalds 10,000.00 10,000.00 10,500.00 10,500.00 11,025.00
VICSAL Corporation 20,000.00 20,000.00 21,000.00 21,000.00 22,050.00
National Bookstore 10,000.00 10,000.00 10,500.00 10,500.00 11,025.00
REX Bookstore 10,000.00 10,000.00 10,500.00 10,500.00 11,025.00
San Miguel Corporation 10,000.00 10,000.00 10,500.00 10,500.00 11,025.00
JJC Donors 20,000.00 20,000.00 21,000.00 21,000.00 22,050.00
Private Individuals/Companies ( see chapter 20,000.00 20,000.00 21,000.00 21,000.00 22,050.00
2)
TOTAL 110,000.00 110,000.00 115,500.00 115,500.00 121,275.00

Schedule 4
School Supplies
2019 2020 2021 2022 2023
Balance, beg. 8,008.20 3,579.40 3,767.43 1,890.66
Purchases
Rosary 800.00 0.00 808.00 816.08
Small Pencil Eraser 200.00 202.00 204.02 206.06 208.12
Notebook 500.00 0.00 505.00 510.05
Cartolina 56.00 56.56 57.13
Short Bond Paper 187.75 189.63 191.52
Long Bond Paper 249.00 251.49 254.00
Colored paper 420.00 424.20 428.44
Intermediate Pad 300.00 56.56 57.13 57.70 58.27
 Crayons 1,000.00 1010.00 1020.10
Staple Wire 219.00 221.19 223.40
Paper Fastener 70.00 70.00 70.70
Marker pen 200.00 202.00 204.02
Glue 290.00 292.90 295.83
Ball Pen 450.00 454.50 459.05
Pencil 525.00 530.25 535.55 540.91 546.32
Whiteboard 600.00 - - - -
Whiteboard Eraser 128.00 129.28 130.57
Chart 200.00
Battery 150.00 151.50 153.02 154.55 156.09
English Textbook 2,800.00
Math Textbook 2,800.00
Filipino Textbook 2,800.00
Flash Cards 500.00
Pencil Sharpener Big 1,197.00 2828.00
Stapler 172.00 173.72 175.46
Puncher 256.75
Scissors 100.00 101.00 102.01
Floor mat 1,000.00
Wall clock 150.00
Speaker 700.00
Microphone 1,000.00
Total 20,020.50 940.31 5,839.18 959.21 8,735.16
Total Goods Available for Use 20,020.50 8,948.51 9,418.58 4,726.64 10,625.82
Consumption (12,012.30) (5,369.11) (5,651.15) (2,835.99) (6,375.49)
Balance, end 8,008.20 3,579.40 3,767.43 1,890.66 4,250.33
 Schedule 5
Cleaning Supplies

2019 2020 2021 2022 2023

Balance, beg. 206.00 256.40 318.86 310.24
Purchases
Broom 40.00 - 42.00 - 44.10
Air Freshener 135.00 135.00 141.75 141.75 148.84
Dustpan 40.00 - 42.00 - 44.10
Rug 100.00 100.00 105.00 105.00 110.25
Trash bag 200.00 200.00 210.00 210.00 220.50
Total 515.00 435.00 540.75 456.75 567.79
Total Goods Available for Use 515.00 641.00 797.15 775.61 878.03
Consumption (309.00) (384.60) (478.29) (465.37) (526.82)
Balance, end 206.00 256.40 318.86 310.24 351.21

Schedule 6
Furnitures and fixtures

2019 2020 2021 2022 2023

Balance, beg. - 16,000.00 12,000.00 8,000.00 4,000.00
Additions
Cabinet 4,000.00 -
Table 16,000.00 -
Depreciation (4,000.00) (4,000.00) (4,000.00) (4,000.00) (4,000.00)
expense
Derecognition -
Balance, end 16,000.00 12,000.00 8,000.00 4,000.00 -
 Schedule 7
Accrued Per diem

2019 2020 2021 2022 2023

Balance, beg. - 600.00 1,200.00 1,800.00 2,450.40
Honararium
expense
Volunteer 5,280.00 5,280.00 5,400.00 5,859.00 6,357.02
Driver 1,320.00 1,320.00 1,350.00 1,458.00 1,574.64
Payment (6,000.00) (6,000.00) (6,150.00) (6,666.60) (7,226.62)
Balance, end 600.00 1,200.00 1,800.00 2,450.40 3,155.44

Schedule 8
Project Feasibility Cost
Particulars Total Cost
Grammar and Plagiarism Test 300.00
Miscellaneous 1,000.00
Transportation and Expense 760.00
AutoCAD 700.00
Book Binding 1,000.00
Printing Fee 1,000.00
Snacks 540.00
Panelist’s and Adviser's Fees 3,500.00
TOTAL 8,800.00
 Schedule 9
Advertising Expense

Particulars 2019 2020 2021 2022 2023

Facebook Ad 500.00 510.00 520.20 515.00 509.85
Tarpaulin 2,500.00 2525.00 2550.25
TOTAL 3,000.00 510.00 3,045.20 515.00 3,060.10

Schedule 10
Utilities Expense

Fuel 2019 2020 2021 2022 2023

Price 51.5 53 53 53 53
x No. of Liters 2 2 2 2 2
Number of Sessions 44 44 45 45 45
TOTAL 4,532.00 4,664.00 4,770.00 4,770.00 4,770.00

Schedule 11
Repairs and Maintenance
2019 2020 2021 2022 2023
Minor Repair 6,000.00 6,000.00 6,180.00 6,365.40 6,556.36
Vehicle Maintenance 10,000.00 10,000.00 10,300.00 10,609.00 10,927.27
TOTAL 16,000.00 16,000.00 16,480.00 16,974.40 17,483.63
 Schedule 12
Meals
No. of Persons 2019 2020 2021 2022 2023
Students' Snacks 20 13,200.00 13,200.00 13,500.00 13,500.00 13,500.00
Volunteers' Snacks 4 2,640.00 2,640.00 2,700.00 2,700.00 2,700.00
Driver's Snacks 1 660.00 660.00 675.00 675.00 675.00
Barangay Tanods' Snacks 2 1,320.00 1,320.00 1,350.00 1,350.00 1,350.00
TOTAL 17,820.00 17,820.00 18,225.00 18,225.00 18,225.00

Schedule 13
Expenses
2019 2020 2021 2022 2023
Program expense
Per diem Expense 6,600.00 6,600.00 6,750.00 7,317.00 7,931.66
Depreciation Expense 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00
Utilities Expenses 4,532.00 4,664.00 4,770.00 4,770.00 4,770.00
Supplies Expense 12,012.30 5,369.11 5,651.15 2,835.99 6,375.49
Cleaning Supplies Expense 309.00 384.60 478.29 465.37 526.82
Meals 17,820.00 17,820.00 18,225.00 18,225.00 18,225.00
TOTAL 45,273.30 38,837.71 39,874.44 37,613.35 41,828.97

Administrative expense
Advertising Expense 3,000.00 510.00 3,045.20 515.00 3,060.10
Project Feasibility 8,800.00 0.00 0.00 0.00 0.00
Repairs and Maintenance 16,000.00 16,000.00 16,480.00 16,974.40 17,483.63
TOTAL 27,800.00 16,510.00 19,525.20 17,489.40 20,543.73

TOTAL EXPENSES 73,073.30 55,347.71 59,399.64 55,102.75 62,372.70

 SENSITIVITY ANALYSIS

Particulars Scenario 1 Scenario 2 Scenario 3

Increase Deacrease Increase Decrease

Contributions 3% 3%
Honorarium 2% 2%
Repairs and Maintenance 5% 5%
Advertising Expense 7% 7%
Utilities Expense 4% 4%

SCENARIO 1
USJ-R Mobile School
Statement of Activities
For The Years Ended December 31

Schedule 2019 2020 2021 2022 2023

Particulars
Projected Contribution 1 140,000.00 140,000.00 147,000.00 147,000.00 154,350.00
Less: Expenses 13 69,073.30 55,347.71 59,399.64 55,102.75 62,372.70
Excess of Revenues over 70,926.70 84,652.29 87,600.36 91,897.25 91,977.30
Expenses
SCENARIO 2
USJ-R Mobile School
Statement of Activities
For The Years Ended December 31

Schedule 2019 2020 2021 2022 2023

Particulars
Projected Contribution 1 135,800.00 135,800.00 135,590.00 135,590.00 135,369.50
Less: Expenses 13 69,073.30 55,347.71 59,399.64 55,102.75 62,372.70
Excess of Revenues over 66,726.70 80,452.29 76,190.36 80,487.25 72,996.80
Expenses

SCENARIO 3
USJ-R Mobile School
Projected Statement of Activities
For The Years Ended December 31

Schedule 2019 2020 2021 2022 2023

Particulars
Projected Contribution 1 135,926.00 135,926.00 135,932.30 135,932.30 135,938.92
Less: Expenses 13 69,073.30 55,347.71 59,399.64 55,102.75 62,372.70
Excess of Revenues over 66,852.70 80,578.29 76,532.66 80,829.55 73,566.22
Expenses