PROJECTED INCOME STATEMENT - Excel TMP

Republic of the Philippines PILI WATER DISTRICT Pili, Camarines Sur

PROJECTED INCOME STATEMENT Budget Year 2016

639 642 649 650

956

701 705 707 711 713 714 715 716 717 719 720 722 723 724 725 731 732 733 734 749

751 753 755 756 761 764 765 766 767 771 772 773 774 775 778 780

INCOME Income from Waterworks Rent Income Other Business Income Fines and Penalties TOTAL Discounts TOTAL BUSINESS & SERVICE INCOME

PERSONAL SERVICES Salaries & Wages Salaries & Wages - Regular Salaries & Wages - Casual Salaries and Wages -Emergency PERA (Personal Economic Relief Allow.) Representation Allowance Transportation Allowance Clothing/Uniform Allowance Subsistence Allowance Productivity Incentive Bonus Other Bonuses and Allowances Honoraria Longevity Pay Overtime & Night Pay Cash Gift Year End Bonus Life & Retirement Insurance Contribution Pag Ibig Contribution PHILHEALTH Contributions ECC Contribution Other Personnel Benefits

TOTAL PERSONAL SERVICES

MOOE Traveling Expense - Local Training Expenses Office Supplies Expense Accountable Foms Expense Gasoline, Oil and Lubricants Chemicals/Other Filtering Materials Other Supplies Expense Water Expenses Electricity Expense Postage and Deliveries Telephone Expense - Landline Telephone Expense - Mobile Internet Expense Cable, Telegraph Expense Membership Dues & Cont. Advertising Expense

TOTAL

87,595,394 918,000

2,206,500 4,817,747 95,537,640

941,962 94,595,679

9,905,368 2,194,642

108,000 1,180,000

282,000 282,000 250,000 708,000 250,000 825,000

30,000 500,000 250,000 1,022,140 1,452,001 59,200 136,340 59,000 947,592

20,441,283

1,136,000 230,000 492,000 180,000 960,000 700,000 930,000 96,000

5,520,000 42,000

126,000 96,000

144,000 24,000 60,000 36,000

781 782 783 784 786 788 791 792 795 797 800 805 808 811 815 821 822 823 826 829 840 841 848 878 891 892 893 901 902 905 908 911 915 921 922 923 926 929 931 935 936 940 941 945 969 TOTAL MOOE

Printing and Binding Expenses Rent Expenses Representation Expense Transp & Delivery Expense Subscription Expense Rewards and Other Claims Legal Services Auditing Services General Services Security Services Council/Board Members Allowance R & M - Electrification, Power & Energy Structure R & M - Irrigation, Water Systems Struct R & M - Office Building R & M - Other Structures R & M - Office Equipment R & M - Furnitures & Fixtures R & M - IT Equipment & Software R & M - Machinery R & M - Communications Equipment R & M - Other Machineries & Equipment R & M - Motor Vehicles R & M - Other Transportation Equipment Donations Taxes, Duties and Licenses Fidelity Bond Premiums Insurance Expense Bad Debts Expense Depreciation - Land Improvements Depreciation - Electrific., Power & Energy Structure Depreciation - Irrigation & Water Systems & Structures Depreciation - Building Depreciation - Other Structures Depreciation - Office Equipment Depreciation - Furniture & Fixtures Depreciation - IT Equipment Depreciation - Machineries Depreciation - Communication Equipment Depreciation - Fire Fighting Equipment Depreciation - Sports Equipment Depreciation - Technical & Scientific Equipment Depreciation - Other Machineries & Equipment Depreciation - Motor Vehicles Depreciation - Other Transportation Equipment Other Operating and Maintenance Expense

Financial Expenses

975

Interest Expenses

979

Other Financial Charges

TOTAL FINANCIAL EXPENSES

TOTAL EXPENSES

Add: Other Income Interest Income Income from Grants & Donation

Net Income Before Income Tax

192,000 60,000

480,000 30,000 12,000 48,000

132,000 150,000 5,529,358 1,130,004 778,896

36,000 1,362,000

44,000 24,000 60,000 30,000 30,000 180,000 24,000 60,000 360,000 30,000 36,000 1,800,000 144,000 540,000 12,000 13,200 300,000 7,800,000 864,000 576,000 240,000 240,000 480,000 1,440,000 72,000

3,600 12,000

6,000 96,000 540,000

6,000 1,175,268 37,950,326

8,001,509 80,015

8,081,524

66,473,133

360,000 409,572

28,892,118

PROJECTED CASH FLOW STATEMENT Budget Year 2016

CASH FLOW FROM OPERATING ACTIVITIES Cash Inflows

Collection of Receivables Current Arrears

Rent Income Collection of Business Income Proceeds from NHA through its Resettlement Program Proceeds from Transfer of Funds

Cash Receipts from Operation

TOTAL

111,938,169

36,918,880 50,198,789

918,000 2,206,500

396,000 21,300,000

Cash Outflows Payment of Operating Expenses Personal Services Operating & Maintenance Expense Payment of Payables Purchase of Office Supplies & Various Inventories Purchase of Chemicals Payment of Construction Materials Inventory Payment of Prepaid Expenses: Insurance & Fidelity Bond Premiums Remittance to GSIS/HDMF/Others Remittance to BIR Transfer of funds from LBP CA to DBP Cash Advances of Officers & Employees Total Cash Outflows

Total Cash Provided/Used by Operating Activities

CASH FLOW FROM INVESTING ACTIVITIES Cash Inflows

Collection of Interest Income Proceeds from transfer of funds

Total Cash Inflows Cash Outflows

CAPEX (Operations) Reserve for Sinking Fund

Total Cash Outflows Total Cash Provided/Used by Investing Activities

CASH FLOW FROM FINANCING ACTIVITIES Cash Outflows

Debt Service Total Cash Outflows

81,023,902 30,914,267

12,214,268 20,115,526

1,660,200 2,070,575

718,000 16,006,386

0 595,933 7,207,940 2,819,076 17,616,000

0

23,452,908 36,358,443

240,000 23,212,908

31,274,127 5,084,316

(12,905,534)

(17,616,000)

17,616,000

Total Cash Provided (Used) by Financing Total Cash Provided (Used) by Operating,

Investing and Financing Activities Add: Cash and Cash Equivalents, Beginning

Cash and Cash Equivalents, Ending

(17,616,000) 51,624,691

392,733 51,231,958

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download