Loading...
HomeMy WebLinkAbout[04b] Financial statementsST. CLOUD AREA PLANNING ORGANIZATION Income & Expense January 2016 Accrual Basis Jan 16 Jan 15 Ordinary Income/Expense Income 4000 · Assessments 54,646.50 54,112.00 4103 · MnDOT 31,407.00 31,407.00 4104 · MTC 275.13 266.38 4105 · Consolidated Planning Grant 27,641.38 32,280.17 4108 · Local Match Reimbursement 0.00 4,671.21 4900 · Interest 1,780.25 662.62 4950 · Miscellaneous 0.00 0.00 5001 · Washington Lobbyist Assessment 21,000.00 20,764.00 Total Income 136,750.26 144,163.38 Expense 6560 · Payroll Expenses 19,449.08 22,965.89 6565 · Payroll Tax Expense 253.98 -1,838.55 6600 · Employee Benefits 1,655.66 11,875.79 6601 · Office Supplies -120.83 368.81 6602 · Accounting & Audit Services 0.00 0.00 6603 · Communications 272.73 307.54 6604 · Travel 174.58 1,090.78 6606 · Utilities and Maintenance 29.75 166.83 6608 · Copy Machine -378.25 558.81 6609 · Software & IT 0.00 0.00 6610 · Dues & Subscriptions 1,320.51 1,380.36 6611 · Miscellaneous Expenses 0.00 -0.84 6615 · Insurance - Office 2,054.12 2,137.67 6618 · Professional Development 377.42 345.00 6620 · Washington Lobbyist 3,500.00 3,000.00 6622 · CPG Passthrough Expense 0.00 10,616.39 6630 · MPO Conference Expense 400.00 0.00 Total Expense 28,988.75 52,974.48 Net Ordinary Income 107,761.51 91,188.90 Net Income 107,761.51 91,188.90 Attachment B-1 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 ST. CLOUD AREA PLANNING ORGANIZATION Balance Sheet As of January 31, 2016 Accrual Basis Jan 31, 16 Jan 31, 15 % Change ASSETS Current Assets Checking/Savings 1002 · Liberty Checking account 229,745.64 158,311.13 45.12% 1100 · Investments 1100.6 · RBC Dain Rauscher 255,031.78 249,647.57 2.16% 1100.7 · UBS Financial Services, Inc.260,625.38 255,908.69 1.84% Total 1100 · Investments 515,657.16 505,556.26 2.0% Total Checking/Savings 745,402.80 663,867.39 12.28% Accounts Receivable 1200 · Accounts Receivable 175,191.63 162,858.05 7.57% Total Accounts Receivable 175,191.63 162,858.05 7.57% Other Current Assets 1205 · Prior Year receivable CPG 1,469.00 5,372.00 -72.66% Total Other Current Assets 1,469.00 5,372.00 -72.66% Total Current Assets 922,063.43 832,097.44 10.81% Fixed Assets Building 1540 · Original Cost 236,477.00 236,477.00 0.0% 1540.01 · Accumulated Depreciation -47,248.00 -39,366.00 -20.02% Total Building 189,229.00 197,111.00 -4.0% Computer 1510 · Original Cost 14,962.11 14,962.11 0.0% 1510.01 · Accumulated Depreciation -14,962.11 -14,962.11 0.0% Total Computer 0.00 0.00 0.0% Improvements 1550 · Original Cost 13,624.13 6,099.13 123.38% 1550.01 · Accumulated Depreciation -2,515.00 -1,213.00 -107.34% Total Improvements 11,109.13 4,886.13 127.36% Land 1500 · Land value 165,000.00 165,000.00 0.0% Total Land 165,000.00 165,000.00 0.0% Office Furiture 1530 · Original Cost 19,741.04 19,741.04 0.0% 1530.01 · Accumulated Depreciation -19,741.04 -19,741.04 0.0% Total Office Furiture 0.00 0.00 0.0% Total Fixed Assets 365,338.13 366,997.13 -0.45% Attachment B-2 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 Jan 31, 16 Jan 31, 15 % Change TOTAL ASSETS 1,287,401.56 1,199,094.57 7.36% LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable 2000 · Accounts Payable 68,676.57 33,635.52 104.18% Total Accounts Payable 68,676.57 33,635.52 104.18% Other Current Liabilities 2015 · PERA Withholding 0.00 0.01 -100.0% 2100 · Payroll Liabilities 2400 · APO Accrued Vacation 9,478.32 8,849.99 7.1% 2410 · Accured Vested Sick Leave 32,642.77 36,349.88 -10.2% Total 2100 · Payroll Liabilities 42,121.09 45,199.87 -6.81% Total Other Current Liabilities 42,121.09 45,199.88 -6.81% Total Current Liabilities 110,797.66 78,835.40 40.54% Total Liabilities 110,797.66 78,835.40 40.54% Equity 3000 · Opening Bal Equity 396,200.48 396,200.48 0.0% 3900 · Retained Earnings 672,641.91 632,869.79 6.28% Net Income 107,761.51 91,188.90 18.17% Total Equity 1,176,603.90 1,120,259.17 5.03% TOTAL LIABILITIES & EQUITY 1,287,401.56 1,199,094.57 7.36% Attachment B-2 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 ST. CLOUD AREA PLANNING ORGANIZATION Income & Expense February 2016 Accrual Basis Feb 16 Feb 15 Ordinary Income/Expense Income 4104 · MTC 234.27 179.38 4105 · Consolidated Planning Grant 28,438.93 30,872.60 4107 · CPG Passthrough Revenue 0.00 5,945.18 4900 · Interest 2,977.97 1,886.43 Total Income 31,651.17 38,883.59 Expense 6560 · Payroll Expenses 22,777.93 22,400.81 6565 · Payroll Tax Expense 1,652.27 1,634.42 6600 · Employee Benefits 4,381.65 5,097.28 6601 · Office Supplies 1,252.35 1,704.67 6602 · Accounting & Audit Services 1,095.00 1,740.00 6603 · Communications 373.93 343.48 6604 · Travel 162.17 221.49 6606 · Utilities and Maintenance 528.84 677.84 6607 · Legal Services 0.00 157.50 6608 · Copy Machine 1,116.74 540.60 6609 · Software & IT 0.00 1,622.98 6610 · Dues & Subscriptions 590.00 751.65 6611 · Miscellaneous Expenses 35.00 11.28 6618 · Professional Development 116.82 1,015.00 6620 · Washington Lobbyist 3,556.00 7,500.00 Total Expense 37,638.70 45,419.00 Net Ordinary Income -5,987.53 -6,535.41 Net Income -5,987.53 -6,535.41 Attachment B-3 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 ST. CLOUD AREA PLANNING ORGANIZATION Balance Sheet As of February 29, 2016 Accrual Basis Feb 29, 16 Feb 28, 15 % Change ASSETS Current Assets Checking/Savings 1002 · Liberty Checking account 127,448.34 209,688.07 -39.22% 1100 · Investments 1100.6 · RBC Dain Rauscher 257,087.66 250,830.27 2.5% 1100.7 · UBS Financial Services, Inc.261,514.52 256,583.07 1.92% Total 1100 · Investments 518,602.18 507,413.34 2.21% Total Checking/Savings 646,050.52 717,101.41 -9.91% Accounts Receivable 1200 · Accounts Receivable 199,879.81 74,214.92 169.33% Total Accounts Receivable 199,879.81 74,214.92 169.33% Other Current Assets 1205 · Prior Year receivable CPG 1,469.00 5,372.00 -72.66% Total Other Current Assets 1,469.00 5,372.00 -72.66% Total Current Assets 847,399.33 796,688.33 6.37% Fixed Assets Building 1540 · Original Cost 236,477.00 236,477.00 0.0% 1540.01 · Accumulated Depreciation -47,248.00 -39,366.00 -20.02% Total Building 189,229.00 197,111.00 -4.0% Computer 1510 · Original Cost 14,962.11 14,962.11 0.0% 1510.01 · Accumulated Depreciation -14,962.11 -14,962.11 0.0% Total Computer 0.00 0.00 0.0% Improvements 1550 · Original Cost 13,624.13 6,099.13 123.38% 1550.01 · Accumulated Depreciation -2,515.00 -1,213.00 -107.34% Total Improvements 11,109.13 4,886.13 127.36% Land 1500 · Land value 165,000.00 165,000.00 0.0% Total Land 165,000.00 165,000.00 0.0% Office Furiture 1530 · Original Cost 19,741.04 19,741.04 0.0% 1530.01 · Accumulated Depreciation -19,741.04 -19,741.04 0.0% Total Office Furiture 0.00 0.00 0.0% Total Fixed Assets 365,338.13 366,997.13 -0.45% Attachment B-4 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 Feb 29, 16 Feb 28, 15 % Change TOTAL ASSETS 1,212,737.46 1,163,685.46 4.22% LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable 2000 · Accounts Payable 0.00 4,761.82 -100.0% Total Accounts Payable 0.00 4,761.82 -100.0% Other Current Liabilities 2015 · PERA Withholding 0.00 0.01 -100.0% 2100 · Payroll Liabilities 2400 · APO Accrued Vacation 9,478.32 8,849.99 7.1% 2410 · Accured Vested Sick Leave 32,642.77 36,349.88 -10.2% Total 2100 · Payroll Liabilities 42,121.09 45,199.87 -6.81% Total Other Current Liabilities 42,121.09 45,199.88 -6.81% Total Current Liabilities 42,121.09 49,961.70 -15.69% Total Liabilities 42,121.09 49,961.70 -15.69% Equity 3000 · Opening Bal Equity 396,200.48 396,200.48 0.0% 3900 · Retained Earnings 672,641.91 632,869.79 6.28% Net Income 101,773.98 84,653.49 20.22% Total Equity 1,170,616.37 1,113,723.76 5.11% TOTAL LIABILITIES & EQUITY 1,212,737.46 1,163,685.46 4.22% Attachment B-4 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 ST. CLOUD AREA PLANNING ORGANIZATION Income & Expense March 2016 Accrual Basis Mar 16 Mar 15 Ordinary Income/Expense Income 4104 · MTC 0.00 210.14 4105 · Consolidated Planning Grant 0.00 34,814.77 4107 · CPG Passthrough Revenue 0.00 9,770.03 4108 · Local Match Reimbursement 0.00 12,391.55 4900 · Interest 1,178.01 3,253.87 Total Income 1,178.01 60,440.36 Expense 6560 · Payroll Expenses 22,935.18 22,371.26 6565 · Payroll Tax Expense 1,594.69 1,632.16 6600 · Employee Benefits 5,176.92 4,739.83 6601 · Office Supplies 231.01 104.51 6602 · Accounting & Audit Services 1,755.00 1,485.00 6603 · Communications 599.34 407.28 6604 · Travel 1,050.47 1,227.69 6605 · Printing & Publishing 8.10 0.00 6606 · Utilities and Maintenance 860.55 705.50 6607 · Legal Services 0.00 90.00 6608 · Copy Machine 661.78 0.00 6609 · Software & IT 25.00 0.00 6610 · Dues & Subscriptions 0.00 395.00 6611 · Miscellaneous Expenses 0.00 277.32 6618 · Professional Development 0.00 487.70 6620 · Washington Lobbyist 3,500.00 2,168.40 6622 · CPG Passthrough Expense 0.00 17,446.49 6625 · Non-Capital Acquisitions 0.00 3,224.15 Total Expense 38,398.04 56,762.29 Net Ordinary Income -37,220.03 3,678.07 Net Income -37,220.03 3,678.07 Attachment B-5 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 ST. CLOUD AREA PLANNING ORGANIZATION Balance Sheet As of March 31, 2016 Accrual Basis Mar 31, 16 Mar 31, 15 % Change ASSETS Current Assets Checking/Savings 1002 · Liberty Checking account 265,204.47 152,835.47 73.52% 1100 · Investments 1100.6 · RBC Dain Rauscher 257,462.51 252,459.29 1.98% 1100.7 · UBS Financial Services, Inc.262,279.22 258,174.47 1.59% Total 1100 · Investments 519,741.73 510,633.76 1.78% Total Checking/Savings 784,946.20 663,469.23 18.31% Accounts Receivable 1200 · Accounts Receivable 29,136.53 126,730.20 -77.01% Total Accounts Receivable 29,136.53 126,730.20 -77.01% Other Current Assets 1205 · Prior Year receivable CPG -3,903.43 5,372.00 -172.66% Total Other Current Assets -3,903.43 5,372.00 -172.66% Total Current Assets 810,179.30 795,571.43 1.84% Fixed Assets Building 1540 · Original Cost 236,477.00 236,477.00 0.0% 1540.01 · Accumulated Depreciation -47,248.00 -39,366.00 -20.02% Total Building 189,229.00 197,111.00 -4.0% Computer 1510 · Original Cost 14,962.11 14,962.11 0.0% 1510.01 · Accumulated Depreciation -14,962.11 -14,962.11 0.0% Total Computer 0.00 0.00 0.0% Improvements 1550 · Original Cost 13,624.13 6,099.13 123.38% 1550.01 · Accumulated Depreciation -2,515.00 -1,213.00 -107.34% Total Improvements 11,109.13 4,886.13 127.36% Land 1500 · Land value 165,000.00 165,000.00 0.0% Total Land 165,000.00 165,000.00 0.0% Office Furiture 1530 · Original Cost 19,741.04 19,741.04 0.0% 1530.01 · Accumulated Depreciation -19,741.04 -19,741.04 0.0% Total Office Furiture 0.00 0.00 0.0% Total Fixed Assets 365,338.13 366,997.13 -0.45% Attachment B-6 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 Mar 31, 16 Mar 31, 15 % Change TOTAL ASSETS 1,175,517.43 1,162,568.56 1.11% LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable 2000 · Accounts Payable 0.00 -33.14 100.0% Total Accounts Payable 0.00 -33.14 100.0% Other Current Liabilities 2100 · Payroll Liabilities 2400 · APO Accrued Vacation 9,478.32 8,849.99 7.1% 2410 · Accured Vested Sick Leave 32,642.77 36,349.88 -10.2% Total 2100 · Payroll Liabilities 42,121.09 45,199.87 -6.81% Total Other Current Liabilities 42,121.09 45,199.87 -6.81% Total Current Liabilities 42,121.09 45,166.73 -6.74% Total Liabilities 42,121.09 45,166.73 -6.74% Equity 3000 · Opening Bal Equity 396,200.48 396,200.48 0.0% 3900 · Retained Earnings 672,641.91 632,869.79 6.28% Net Income 64,553.95 88,331.56 -26.92% Total Equity 1,133,396.34 1,117,401.83 1.43% TOTAL LIABILITIES & EQUITY 1,175,517.43 1,162,568.56 1.11% Attachment B-6 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 ST. CLOUD AREA PLANNING ORGANIZATION Income & Expense April 2016 Accrual Basis Apr 16 Apr 15 Ordinary Income/Expense Income 4104 · MTC 0.00 237.63 4105 · Consolidated Planning Grant 0.00 30,786.33 4107 · CPG Passthrough Revenue 0.00 6,001.02 4108 · Local Match Reimbursement 0.00 663.96 4900 · Interest 44.99 738.24 Total Income 44.99 38,427.18 Expense 6560 · Payroll Expenses 27,260.11 22,026.50 6565 · Payroll Tax Expense 1,970.33 1,605.78 6600 · Employee Benefits 3,603.02 6,049.78 6601 · Office Supplies 40.33 212.93 6602 · Accounting & Audit Services 1,875.00 1,640.00 6603 · Communications 293.14 628.48 6604 · Travel 151.63 417.03 6605 · Printing & Publishing 25.00 0.00 6606 · Utilities and Maintenance 524.22 508.39 6607 · Legal Services 225.00 382.50 6608 · Copy Machine 0.00 1,378.53 6609 · Software & IT 750.00 700.00 6611 · Miscellaneous Expenses 0.00 141.68 6615 · Insurance - Office 0.00 1,075.00 6618 · Professional Development 0.00 20.00 6620 · Washington Lobbyist 3,500.00 4,948.43 6622 · CPG Passthrough Expense 0.00 10,716.11 6625 · Non-Capital Acquisitions 0.00 8,085.00 Total Expense 40,217.78 60,536.14 Net Ordinary Income -40,172.79 -22,108.96 Net Income -40,172.79 -22,108.96 Attachment B-7 Agenda Item #4 b St. Cloud APO Policy Board Meeting May 12, 2016 ST. CLOUD AREA PLANNING ORGANIZATION Balance Sheet As of April 30, 2016 Accrual Basis Apr 30, 16 Apr 30, 15 % Change ASSETS Current Assets Checking/Savings 1002 · Liberty Checking account 257,275.57 213,952.77 20.25% 1100 · Investments 1100.6 · RBC Dain Rauscher 257,462.51 252,459.29 1.98% 1100.7 · UBS Financial Services, Inc.262,279.22 258,884.86 1.31% Total 1100 · Investments 519,741.73 511,344.15 1.64% Total Checking/Savings 777,017.30 725,296.92 7.13% Accounts Receivable 1200 · Accounts Receivable 463.33 42,793.55 -98.92% Total Accounts Receivable 463.33 42,793.55 -98.92% Other Current Assets 1205 · Prior Year receivable CPG -3,903.43 5,372.00 -172.66% Total Other Current Assets -3,903.43 5,372.00 -172.66% Total Current Assets 773,577.20 773,462.47 0.02% Fixed Assets Building 1540 · Original Cost 236,477.00 236,477.00 0.0% 1540.01 · Accumulated Depreciation -47,248.00 -39,366.00 -20.02% Total Building 189,229.00 197,111.00 -4.0% Computer 1510 · Original Cost 14,962.11 14,962.11 0.0% 1510.01 · Accumulated Depreciation -14,962.11 -14,962.11 0.0% Total Computer 0.00 0.00 0.0% Improvements 1550 · Original Cost 13,624.13 6,099.13 123.38% 1550.01 · Accumulated Depreciation -2,515.00 -1,213.00 -107.34% Total Improvements 11,109.13 4,886.13 127.36% Land 1500 · Land value 165,000.00 165,000.00 0.0% Total Land 165,000.00 165,000.00 0.0% Office Furiture 1530 · Original Cost 19,741.04 19,741.04 0.0% 1530.01 · Accumulated Depreciation -19,741.04 -19,741.04 0.0% Total Office Furiture 0.00 0.00 0.0% Total Fixed Assets 365,338.13 366,997.13 -0.45% Attachment B-8 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016 Apr 30, 16 Apr 30, 15 % Change TOTAL ASSETS 1,138,915.33 1,140,459.60 -0.14% LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable 2000 · Accounts Payable 3,500.00 -33.14 10,661.26% Total Accounts Payable 3,500.00 -33.14 10,661.26% Other Current Liabilities 2005 · Payroll Taxes Withheld -0.01 0.00 -100.0% 2010 · MSRS Withholding 70.71 0.00 100.0% 2015 · PERA Withholding -0.01 0.00 -100.0% 2100 · Payroll Liabilities 2400 · APO Accrued Vacation 9,478.32 8,849.99 7.1% 2410 · Accured Vested Sick Leave 32,642.77 36,349.88 -10.2% Total 2100 · Payroll Liabilities 42,121.09 45,199.87 -6.81% Total Other Current Liabilities 42,191.78 45,199.87 -6.66% Total Current Liabilities 45,691.78 45,166.73 1.16% Total Liabilities 45,691.78 45,166.73 1.16% Equity 3000 · Opening Bal Equity 396,200.48 396,200.48 0.0% 3900 · Retained Earnings 672,641.91 632,869.79 6.28% Net Income 24,381.16 66,222.60 -63.18% Total Equity 1,093,223.55 1,095,292.87 -0.19% TOTAL LIABILITIES & EQUITY 1,138,915.33 1,140,459.60 -0.14% Attachment B-8 Agenda Item #4 b. St. Cloud APO Policy Board Meeting May 12, 2016