cm*^^ · 2016. 5. 3. · 6120 6140 6190 6200 6210 credit reports employees benefits garbage ins...

UNITED MOBILEHOME OWNERS ASSOCIATION OF FAIRFIELD, INC

(dba Creekside Estates, Country Club Estates and DoverMobilehome Park)

MONTHLY REPORT- March 2016

The following information is provided as required by Article 5.15(b)(v) of the Loan Agreement. The income, balance sheet,

cash flow and budget variances are contained in the attached financial statement.

A) The "BOND DEBTSERVICE COVERAGE RATIO" was computed utilizing a "NET REVENUE AVAILABLE FOR DEBTSERVICE"

of $116,739.44 and is 214.42%.

B) RENTAL ACTIVITY:

a) Space rent charges:

i) DOVER MOBILEHOME PARK

ii) COUNTRY CLUB ESTATES

b) Spaces available for occupancy

Spaces occupied

Percentage of spaces occupied

c) Delinquencies and evictions:

i) Delinquencies

(1) Late Charges

(2) Unpaid Rent (3/60 NoticeIssued)

ii) Eviction Activity

(1) Preliminary procedures started

(2) Forwarded to attorney

(3) Favorable court judgment

(4) Default satisfied

(5) Currently active

C) LOW INCOMETENANT PROGRAMS:

a) Low Income Park Assistance Program • • •

b) Section 8 Voucher Program participants • • •

PRIOR

JAN 2008-JAN 2016

295

193

25

26

2

20

THIS PERIOD

$440.00

$440.00

417

417

100.00%

TOTAL

295

194

25

26

2

20

0

c) Low income certification data required by the LoanAgreement:

i) Spaces available

ii) Spaces occupied by low income tenants

iii) Percent of spaces occupied by low income tenants

51

0

Loan AS OF

AUGUST 1994

PRIOR

CHANG

E

PERIOD

CHANG

E

TOTAL

415 2 0 417

163 107 0 270

e tenants 39.3% 64.75%

Cm*^^Carolyn Murray

CEO, UMOAFApril 13, 2016

UNITED MOBILEHOME OWNERS ASSOCIATION OF FAIRFIELD, INC.

04/13/16 Statement of Cash FlowMarch 2016

Mar 16

OPERATING ACTIVITIES

Net Income 90,612.88Adjustments to reconcile Net Incometo net cash provided by operations:

1300 • Prepaid lnsurance:1304 • Employees - Health Care:1304a • Employee Health Ins - Prepaid -3,473.211340 • Prepaid Expenses -551.882000 • Accounts Payable -45,065.282500 • Payroll Tax Liability:2501 • FIT 170.002500 • Payroll Tax Liability:2502 • FICA 154.582500 • Payroll Tax Liability:2503 • SIT 44.652500 • Payroll Tax Liability:2504 • SDI 9.112500 • Payroll Tax Liability:2505 • SUI/ETT -Employer -208.962550 • Accrued Expenses:2557 • Interest - 2012 Bonds 25,276.56

Net cash provided by Operating Activities 66,968.45

Net cash increase for period 66,968.45

Cash at beginning of period 2,382,985.66

Cash at end of period 2,449,954.11

Prepared without audit Page 1


04/13/16 Balance SheetAccrual Basis As of March 31, 2016

ASSETS

Current Assets

Checking/Savings1015 • Expense Account

1029 BNY-Escrow

1045 • Repair and Replacement Account1070-2012 Bond Fund

1080 • 2012 Bond Reserve Fund

1120 - Operating Cash in Bank

Total Checking/Savings

Other Current Assets

1300 • Prepaid Insurance

1330 • Prepaid Trustee Fees1340 • Prepaid Expenses

Total Other Current Assets

Total Current Assets

Fixed Assets

1550 • Furniture & Fixtures

1560 • Machinery & Equipment1570 • Auto & Truck

1580 • Real Property

1590 • Property Improvements

1650 - Accumulated Depreciation

Total Fixed Assets

Other Assets

1850 • Deposits1895 • Deferred 2012 Bond Expense1965 • Amortization -2012 Loan Exp.

Total Other Assets

TOTAL ASSETS

Prepared without audit

Mar 31,16

118,564.96

0.02

204,192.00

394,135.01

654,770.76

1,078,291.36

2,449,954.11

38,896.62

2,216.74

4,041.95

45,155.31

2,495,109.42

58,027.45531,252.58

18,095.587.928,406.34

4,343,838.23

-4,884,057.00

7,995,563.18

2,785.00

293,616.06

-33,308.35

263,092.71

10,753,765.31

Page 1


04/13/16 Balance SheetAccrual Basis As of March 31, 2016

LIABILITIES & EQUITY

Liabilities

Current Liabilities

Accounts Payable2000 • Accounts Payable

Total Accounts Payable

Other Current Liabilities

2200 • Notes Payable - Current2500 • Payroll Tax Liability

2550 - Accrued Expenses

Total Other Current Liabilities

Total Current Liabilities

Long Term Liabilities2620 • Less Current Portion-N/P

2650 - 2012 Revenue Bonds

Total Long Term Liabilities

Total Liabilities

Equity3000 • Capital Surplus3020 • Retained EarningsNet Income

Total Equity

TOTAL LIABILITIES & EQUITY


Mar 31,16

59,876.96

59,876.96

330,000.00

2,730.75

133,728.54

466,459.29

526,336.25

-330,000.00

6,455,000.00

6,125,000.00

6,651,336.25

2,000.003,867,677.36

232,751.70

4,102,429.06

10,753,765.31

Page 2


04/13/16 Profit & Loss: Current vs. Year-to-DateAccrual Basis March 2016


Ordinary Income/ExpenseIncome

4010 • Rent Income

4020 • Utilities-Gas/Elec

4040 • R.V. Parking Income

Total Income

Cost of Goods Sold

5025 • Interest Expense - 2012 Bonds5035 • 2012 Loan Fees

5045 - Amortization Expense 2012 Bond

Total COGS

Gross Profit

Expense6010 Accounting

6040 Automobile Expense

6060 Bank Service Charges

6080

6090

Cable TV

Corp -Security

6100 Corp-Director Fees

6120

6140

6190

6200

6210

Credit ReportsEmployees BenefitsGarbageIns - W/CompInternet Service

6230

6250

Janitorial/CleaningLandscaping

6260

6280

Legal FeesMaintenance

6300 Meals and Entertainment

6330 Office Supplies

6350 /Short

6370

6500

Permits & Fees

Salaries

6545

6550

Salary Direct Deposit feesSpecial Clothing

6590 Sm Tools/Equip

6600

6650

Taxes - PayrollTelephone

6700 Utilities - PG/E

6720 Water-Sewer

Total Ex pense

Net Ordinary Income

Other Income/ExpenseOther Income

7000 • Other Income

Total Other Income

Mar 16 Jan-Mar 16 % of In-

182,699.32 546,357.77 77.4%52,501.37 178,812.16 22.2%

950.00 2,955.00 0.4%

236,150.69 728,124.93 100.0%

25,276.56 75,829.68 10.7%850.00 850.00 0.4%

0.00 139.58

76,819.26

0.0%

26,126.56 11.1%

210,024.13 651,305.67 88.9%

8,199.00 8,199.00 3.5%

83.02 182.53 0.0%

196.50 329.07 0.1%

12,496.28 31,038.24 5.3%

90.04 378.08 0.0%

0.00 1,417.81 0.0%

0.00 29.00 0.0%

0.00 7,252.99 0.0%

-72.12 25,579.83 -0.0%

0.00 2,439.84 0.0%

244.00 753.24 0.1%

0.00 96.03 0.0%

0.00 486.86 0.0%

329.89 1,767.39 0.1%

3,087.12 27,121.02 1.3%

23.46 59.71 0.0%

1,084.81 3,919.84 0.5%

28.78 705.96 0.0%

120.00 5,079.60 0.1%

34,450.47 74,449.26 14.6%

24.00 83.25 0.0%

991.34 991.34 0.4%

0.00 165.57 0.0%

2,914.34 7,487.36 1.2%

2,278.21 4,160.20 1.0%

21,582.02 119,691.76 9.1%

28,571.09 87,220.19 1?.1%

116,722.25 411,084.97 49.4%

93,301.88

51.00

51.00

240,220.70

551.00

551.00

39.5%

0.0%

0.0%

Page 1

UNITED MOBILEHOME OWNERS ASSOCIATION OF FAIRFIELD, INC.04/13/16 Profit & Loss: Current vs. Year-to-DateAccrual Basis March 2016

Other Expense8050 • Rent Adjustment

Total Other Expense

Net Other Income

Net Income


Mar 16

2,740.00

2,740.00

-2,689.00

90,612.88

Jan-Mar 16 %ofln...

8,020.00 1.2%

8,020.00 1.2%

-7,469.00 -1.1%

232,751.70 38.4%

Page 2

04/13/16

Accrual Basis

UNITED MOBILEHOME OWNERS ASSOCIATION OF FAIRFIELD, INC.Profit & Loss: Budget vs. Actual

March 2016




4022 • Gas Income

4025 • Electric Income

Total 4020 • Utilities-Gas/Elec


Total Income

Cost of Goods Sold

5001 • Depreciation Expense5010 • Insurance

5011 • Liability5012 • Directors/Officers

5015 • Fidelity/Crime

Total 5010 • Insurance

5025 • Interest Expense - 2012 Bonds

5035 • 2012 Loan Fees

5045 • Amortization Expense 2012 Bond5050 • Real Property Taxes5070 • Trustee Fees

Total COGS

Gross Profit

Expense

6010 • Accounting

6012 • Auditing6013 • Accounting • CPA

Total 6010 • Accounting

6040 • Automobile Expense

6041 • Auto Fuel


Total 6040 • Automobile Expense

6060 • Bank Service Charges6061 • Bank Service Charges6062 • Remote Deposit Service6063 • Returned Check Charges

Total 6060 - Bank Service Charges

6080 • Cable TV

6090 • Corp - Security6091 - Intrusion Detection

Total 6090 • Corp - Security

6100 • Corp-Director Fees

6101 • Board Meetings

6102 • Food Bag Program6103 • Miscellaneous Director Fees

Total 6100 • Corp-Director Fees

6120 • Credit Reports6130 • Dues & Subscriptions

6140 • Employees Benefits6190 • Garbage6200 • Ins - W/Comp6210 • Internet Service

6211 AT&T DSL

6212 • Comcast Hi-Speed

Total 6210 • Internet Service

6230 • Janitorial/Cleaning6250 • Landscaping

6252 • LndsSupplies6253 - Sprinkler System

Total 6250 • Landscaping

6260 • Legal Fees


182,699 32

27.556 37

24.945 00

52.501 37

950.00

Budget

181.662.50

19.590 00

22.001 00

41.591.00

950 00

S Over Budget

7.956 37

2.944 00

10.91037

0 00

% of Budget

100.6%

140 7%

113 4%

126.2%

100.0%

236.150 69 224.203 50 11.947 19 105.3%

000 20.539 13 -20,539 13 0.0%

0 00 1,906 25 -1,906 25 0 0%

0 00 200 92 -200 92 0 0%

C 00 26.50 -26 50 c :•;:

0.00 2,13367 -2,133.67 0.0%

25.27656 25,27656 000 100 0%

85000 850 00 000 1000%

0.00 69 79 -69.79 0.0%

000 5.088 25 -5.08825 0 0%oc: 158 33 -158.33 0 0%

:••; i:••;:•; 54.115.73 -27,989.17 48.3%

210.024 13 170,087 77 39,936 36 123.5%

000 1,250 00 -1,250 00 0 0%

8.199 00

8,199 00 1.250 00 6.949.00 655.9%

83 02 150 00 -66 98 55 3%

0 00 350 00 -350 00 0 0%

83.02 500 00 -116 98 166%

52 90 80 00 -27 10 66 1%

11960 125 00 -540 957%

:••: oo 48.00 -24 00 50 0%

196 50 253 00 -56 50 77 7%

12,496 28 12,387 72 108 56 100 9%

90 04 315.88 -225 84 28 5%

90 04 315.88 -22584 28.5%

0 00 50 00 -50 00 0 0%

0 00 100 00 -100 00 0 0%

0.00 180 OC -180.00 00%

0 00 330 00 -330 00 0.0%

000 36 00 -36.00 0.0%

000 0 00 0.00 0.0%

000 4,61287 -4,61287 0 0%

-72.12 9,091 42 -9.163 54 -0.8%

0.00 1.219 92 -1,21992 0.0%

244 00 200.00 44 00 122 0%

0 00 11500 -115 00 0 0%

244 00 315.00 -71.00 77 5%

000 300 00 -300 00 0.0%

0 00 300.00 -300 00 0 0%

0 00 30000 -300 00 0.0%

000 600 00 -600 00 0.0%

32989 1.000 00 -67011 33.0%

Page 1

04/13/16

Accrual Basis


March 2016

6280 • Maintenance

6281 • Building Maintenance6282 • Misc-Area Maint - Shop Supplies6283 • Other Maintenance

6284 • Plumbing Maintenance

6285 • Sewer Maintenance

6286 • Site Maintenance

6287 • Golf Cart Maintenance

Total 6280 • Maintenance

6300 • Meals and Entertainment

6301 • Employee Functions6302 • Movie Time for Residents

6302a • Equipment and Accessories

6302b • Movies and Other Entertainment

6302c • Refreshments

Total 6302 • Movie Time for Residents

Total 6300 • Meals and Entertainment

6330 • Office Supplies6331 • Office Supplies6332 • Postal Expense6333 • Software - Tech Support

Total 6330 • Office Supplies

6350 • /Short

6352 • /Short

Total 6350 • /Short

6370 • Permits & Fees

6380 • Pool Service & Supplies6400 • Repairs

6401 • Electrical Repairs

6402 • Equipment Repairs

6403 • Fum/Equip Repairs6404 • Natural Gas Pipeline Repairs

Total 6400 • Repairs

6500 • Salaries

6510 • Manager


6530 • Office

6540 • Administration

6541 • Bookkeeping6542 • Bonuses - Promotional

6543 • Vacation Cashout

Total 6540 • Administration

Total 6500 • Salaries

6545 • Salary Direct Deposit fees6550 • Special Clothing


6552 • Office

Total 6550 • Special Clothing

6590 • Sm Tools/Equip

6591 • Equipment Fuel


Total 6590 • Sm Tools/Equip

6600 • Taxes - Payroll

6650 • Telephone6651 • Telephone - Office

6652 • Wireless Communication

Total 6650 • Telephone

6670 • Transfer/Registration Tax

6700 • Utilities - PG/E

6701 • Gas Expense6702 • Electric Expense

Total 6700 • Utilities - PG/E

6720 • Water-Sewer

Total Expense

Net Ordinary Income


7000 - Other Income

7001 • Late & Returned Check Charges


Mar 16 Budget S Over Budget %of Budget

1,039 20 1,000.00 39.20 103 9%

0 00 1,000.00 -1.000 00 0 0%0 00 500 00 -500 00 0 0%

0 00 250 00 -250 00 0 0%

0 00 150 00 -150 00 0 0%

2.047 92 1,000 00 1,047 92 204 8%

0 00 1,000.00

4.900.00

-1.000 00 0.0%

3,087 12 -1.812.88 63.0%

23 46

000

0 00

0 00

709 81

000

375 00

1,084.81

28 78

12000

000

0 00

0 00

000

0 00

20 00

2000

150 00

1.000 00

100 00

995

100 00

1,518 22

250 00

200 00

250 00

100.00

10000

-76 54

-20 00

-20 00

-150.00

-190 00

-266.54

-29019

-100 00

365 05

-25 14

-7122

-1,398 22

-250 00

-200 00

-250 00

-100 00

-100 00

23.5%

0 0%

0.0%

0 0%

71 0%

0.0%

3,768.8%

28 8%

0 0%

0 0%

0.0%

0 0%

79%

00%

0.0%

4.166 66

10,411 76

19,29785

4,166.67

13,453 37

4,869.93

-601

-3.041 61

14,427 92

00 0%

77.4%

396 3%

324 20

250 00

000

3.88382

250 00

000

-3.559.62

0.00

0 00

8 3%

100 0%

0 0%

574 20 4,133.82 -2 559 62 13 9%

34,45047 26,62379 7,82668 129.4%

2400 34 00 10 00 706%

991 34

0 00

1.620.00

125.00

•62866

-125 00

61 2%

0 0%

1.745 00 -75366 55 3%

0 00 100.00 -100 00 0.0%

0.00 200 00 -200 00 00%

0 00 300 00 -300 00 0.0%

2.91434 2,443 29 471.05 119.3%

49615 575 00 -78 85 86 3%

1,782 06 615.00 1,167.06 289 8%

2,278.21 1,190 00 1.088 21 191 4%

0 00 0 00 0 00 0.0%

9.373 03 9,280 00 9303 101 0%

12.208 99 19.71900 -7.510.01 61 9%

21,582 02 28,999 00 -7,41698 74.4%

28,571 09 25,601 00 2.97009 111 6%

116,72225 127,956 06 -11.243.81 91.2%

93,301 88 42,121.71 51,18017 221 5%

51 00 51.0%

Page 2

04/13/16

Accrual Basis


March 2016

7002 - Miscellaneous

7002b • Miscellaneous Income

Total 7002 • Miscellaneous

Total 7000 • Other Income

Total Other Income


8052 • UPA

Total 8050 • Rent Adjustment

Total Other Expense

Net Other Income

Net Income


0 00

51.00

2.74000

90,612.88

Budget S Over Budget

0 00

-49 00

2,71900

2,71900

39,502.71 51,110.17

%of Budget

0 0%

100 8%

1027%

Page 3

04/13/16

Accrual Basis


Profit & Loss: Year-to-Date Actual vs. BudgetJanuary through March 2016




4022 • Gas Income




Total Income

Cost of Goods Sold


5011 • Liability5012 • Directors/Officers

5015 - Fidelity/Crime

Total 5010- Insurance


5045 • Amortization Expense 2012 Bond5050 • Real Property Taxes5070 • Trustee Fees

Total COGS

Gross Profit

Expense6010 • Accounting

6012- Auditing6013 • Accounting - CPA



6041 • Auto Fuel



6060 • Bank Service Charges6061 • Bank Service Charges

6062 • Remote Deposit Service

6063 • Returned Check Charges

Total 6060 • Bank Service Charges

6080 • Cable TV

6090 • Corp - Security6091 • Intrusion Detection


6100 • Corp-Director Fees6101 • Board Meetings

6102 • Food Bag Program6103 - Miscellaneous Director Fees

Total 6100 • Corp-Director Fees

6120 • Credit Reports6130 • Dues & Subscriptions6140 • Employees Benefits6190 • Garbage6200 • Ins - W/Comp

6210 • Internet Service

6211 AT&T DSL

6212 • Comcast Hi-Speed


6230 - Janitorial/Cleaning6250 • Landscaping

6252 • LndsSupplies6253 • Sprinkler System

Total 6250 • Landscaping

6260 • Legal Fees


95.928 19

82.883 97

178.812 16

2,955 00

728,124 93

oco

oco

0 00

0 00

Budget

71,294 00

64,41200

135,706 00

2,850 00

5,718 75602.76

79 50

S Over Budget

1.370.27

24,634 19

18,471 97

43,106.16

105 00

-5,718 75-602 76

-79 50

%of Budget

134 6%

1287%

131 8%

103 7%

106 5%

00%

00%

0 0%

0.00 6,401 01 -6,401.01 00%

75,82968 75,82968 0.00 100 0%

850 00 850 00 000 100 0%

139 58 209.37 -69.79 66 7%

000 15.264 75 -15.264 75 0 0%

0 00 474.99 -174.99 0.0%

76.819 26 160.64719 -83.827 93 47 8%

651.30567 522,895 31 128.409.36 124 6%

0 00 3.750 00 -3.750 00 0.0%

8,199 00

8,199.00 3.75000 4.449.00 2186%

18253 450 00 -267 47 406%

oco 1.050 00 -1,050 00 00%

182.53 1,500 00 -1.317.47 12 2%

5407 24000 -185 93 22.5%

239.00 37500 -136 00 63 7%

36 00 144 00 -108 00 25 0%

329 07 759 00 -12993 434%

31.038 24 37,16316 -6,124.92 83 5%

378 08 947 64 -569 56 39 9%

378 08 94764 -569 56 39.9%

000 100 00 -100 00 0 0%

000 300 00 -300 00 0.0%

1.417 81 34000 1.077 81 417 0%

1,417.81 74000 677 81 191 6%

29.00 108.00 -79.00 26 9%

0 00 0 00 0.00 0.0%

7,252 99 13.133.92 -5,880.93 55 2%

25,579 83 27.274 26 -1.694 43 93 8%

2.439 84 3.659 76 -1219 92 66 7%

642 00 600 00 42 00 107 0%

111 24 34500

94500

-233 76 32 2%

753 24 -191 76 79 7%

96 03 90000 -803.97 10.7%

486 86 900 00 -413.14 54 1%

0 00 900 00 -900 00 0.0%

486 86

1,767 39

1.800 00

3,000.00

-1,31314

-1.232 61

27 0%

58 9%

Page 1

04/13/16

Accrual Basis

UNiTEDMOBILEHOME OWNERS ASSOCIATION OF FAIRFIELD, INC.Profit & Loss: Year-to-Date Actual vs. Budget

January through March 2016


6281 • Building Maintenance6282 • Misc-Area Maint - Shop Supplies6283 • Other Maintenance

6284 • Plumbing Maintenance

6285 • Sewer Maintenance

6286 • Site Maintenance

6287 • Golf Cart Maintenance



6301 • Employee Functions6302 • Movie Time for Residents

6302a • Equipment and Accessories6302b • Movies and Other Entertainment

6302c - Refreshments

Total 6302 • Movie Time for Residents

6300 • Meals and Entertainment - Other


6330 • Office Supplies6331 • Office Supplies6332 • Postal Expense

6333 • Software - Tech Support


6350 • /Short

6351 • Returned checks

6352 • /Short



6380 • Pool Service & Supplies6400 • Repairs

6401 • Electrical Repairs6402 • Equipment Repairs

6403 • Fum/Equip Repairs

6404 • Natural Gas Pipeline Repairs

Total 6400 • Repairs

6500 • Salaries

6510 • Manager6520 • Maintenance

6530 • Office


6541 • Bookkeeping

6542 • Bonuses - Promotional


6540 • Administration - Other


Total 6500 • Salaries

6545 • Salary Direct Deposit fees6550 - Special Clothing


6552 • Office


6590 • Sm Tools/Equip6591 • Equipment Fuel


Total 6590 • Sm Tools/Equip


6650 • Telephone

6651 • Telephone - Office6652 • Wireless Communication


6670 - Transfer/Registration Tax6700 • Utilities - PG/E

6701 - Gas Expense6702 • Electric Expense

Total 6700 • Utilities - PG/E


Total Expense

Net Ordinary Income


Jan - Mar 16 Budget SOv er Budget %of Budget

1.525 04 3.00000 -1.474.96 50 8%1.046 69 3,000 00 -1.953.31 34 9%

19,250 00 1,500 00 17.750 00 1,283 3%

2,87500 75000 2.125.00 383 3%

0.00 450.00 -450.00 0,0%2.136 43 3,000 00 -863.57 71 2%

287 86 3.000 00 -2,712 14 96%

27,121 02 14,70000 12.421 02 184 5%

23 46

0 00

000

3248

32 48

3 77

59 71

60 00

60 00

450 00

57000

870 00

-60 00

-60 00

-117 52

-537 52

-810 29

0 0%

00%

72%

5.7%

2.730 18 3,00000 -26982 91 0%

123 00 500.00 -377.00 24.6%

1,066 66 29.85 1,036.81 3,573.4%

3,91984 3.529 85

6 9%

608 59

97 37 300 00 -202.63 32.5%

705 96 300.00 405 96 235.3%

5,079 60 7,724.82 -2,64522 65 8%

0 00 750 00 -750 00 00%

000 600 00 -600.00 00%

0 00 750 00 -750.00 0 0%

0 00 300.00 -300.00 0 0%

0 00 300 00 -300.00 0 0%

0 00 1,950 00 -1,950 00 0.0%

12,49998 12,500.01 -0.03 100 0%

30.156 80 38,425 44 -8,268.64 78 5%

30.218 33 14,608.91 15,609 42 206 8%

1,324.15 11.652 33 -10,328 18 11.4%

250.00 250 00 0.00 100 0%

0.00 0.00 000 0.0%

0.00

1,574.15 11,902.33 -10,328 18 132%

74,44926 77,43669 -2,987.43 96.1%

8325 102 00 -1875 81 6%

991 34 1.620 00 -628 66 61 2%

0.00 125.00 -125.00 0 0%

991 34 1.745 00 -753 66 56 8%

0 00 300 00 -300 00 0 0%

16557 60000 -434.43 27 5%

16557 900 00 -734.43 18 4%

7.487 36 8,470 89 -983 53 884%

1,670 18 1,725 00 -54.82 96.8%

2,490 02 1,845.00 645 02 135 0%

4,160 20 3.57000 590.20 116.5%

0,00 0 00 0.00 0.0%

54,06320 57,563.00 -3,499.80 93 9%

65,628 56 60.908.00 4,720.56 107 8%

119,691 76 118.471 00 1,220 76 101.0%

87,220.19 75,303 00 11.917 19 115 8%

411.084 97 411,503 99 -419 02 99.9%

240.220 70 111.392 32 128.828 38 215 7%

Page 2

04/13/16

Accrual Basis


Profit & Loss: Year-to-Date Actual vs. BudgetJanuary through March 2016

Budget S Over Budget



7001 • Late & Returned Check Charges7002 • Miscellaneous

7002b • Miscellaneous Income

Total 7002 • Miscellaneous


Total Other Income


8052 • UPA

Total 8050 - Rent Adjustment

Total Other Expense

Net Other Income

Net Income


551 00

0.00

551.00

8,020.00

8,020 00

-7,46900

232,751.70

300 00 251.00

0 00

141.00

7,879 00

-7,579 00

103,813.32 128,938.38

%of Budget

0 0%

1837%

101

224.2%

Page 3

UNITED MOBILEHOME OWNERS ASSOCIATION OF FAIRFIELD, INC.04/13/16 Profit & Loss: Previous Year ComparisonAccrual Basis March 2016





Total Income

Cost of Goods Sold



5045 - Amortization Expense 2012 Bond5050 • Real Property Taxes5070 • Trustee Fees

Total COGS

Gross Profit

Expense6010 Accounting

6040 Automobile Expense

6060 Bank Service Charges

6080 Cable TV

6090 Corp - Security

6120 Credit Reports6140 Employees Benefits6190 Garbage6200 Ins - W/Comp6210 Internet Service

6230 Janitorial/Cleaning6250 Landscaping

6260 Legal Fees6280 Maintenance

6300 Meals and Entertainment

6330 Office Supplies

6350 /Short

6370 Permits & Fees

6380 Pool Service & Supplies6400 Repairs

6500 Salaries

6545 Salary Direct Deposit fees6550 Special Clothing

6590 Sm Tools/Equip

6600 Taxes - Payroll6650 Telephone



Total Expense

Net Ordinary Income


Mar 16 Mar 15 $ Change %Cha...

182,699.32

52,501.37180,419.00

62,518.692,280.32

-10.017.321.3%

-16.0%

950.00 1,025.00 -75.00 -7.3%

236,150.69 243,962.69 -7,812.00 -3.2%

0.00

0.00

20,539.122,111.76

-20,539.12

-2,111.76-100.0%

-100.0%

25,276.56

850.00

0.00

0.00

0.00

26,114.060.00

69.79

4,337.36158.33

-837.50

850.00

-69.79

-4,337.36

-158.33

-3.2%

100.0%

-100.0%

-100.0%

-100.0%

26,126.56 53,330.42 -27,203.86 -51.0%

210,024.13 190,632.27 19,391.86 10.2%

8,199.00 2,083.34 6,115.66 293.6%

83.02 131.00 -47.98 -36.6%

196.50 162.79 33.71 20.7%

12,496.28

90.04

11,751.02296.23

745.26

-206.19

6.3%

-69.6%

0.00

0.00

-72.12

0.00

244.00

42.00

4,570.73

8,646.151,278.25

383.07

^2.00

-4,570.73-8,718.27-1,278.25

-139.07

-100.0%

-100.0%

-100.8%

-100.0%

-36.3%

0.00

0.00

45.99

1,202.86

-45.99

-1,202.86-100.0%

-100.0%

329.89

3,087.12

780.00

842.59

-450.11

2,244.53

-57.7%

266.4%

23.46 123.59 -100.13 -81.0%

1,084.81 1,074.03 10.78 1.0%

28.78 606.63 -577.85 -95.3%

120.00

0.00

0.00

1,383.744.23

581.08

-1,263.74-4.23

-581.08

-91.3%

-100.0%

-100.0%

34,450.47 26,223.40 8,227.07 31.4%

24.00

991.34

30.20

435.92

-6.20

555.42

-20.5%

127.4%

0.00 167.16 -167.16 -100.0%

2,914.34

2,278.21

2,405.08

983.32

509.26

1,294.89

21.2%

131.7%

21,582.02 31,591.58 -10,009.56 -31.7%

28,571.09 29,193.03 -621.94 -2.1%

116,722.25 127,019.01 -10,296.76 -8.1%

93,301.88 63,613.26 29,688.62 46.7%

Page 1

UNITED MOBILEHOME OWNERS ASSOCIATION OF FAIRFIELD, INC.04/13/16 Profit & Loss: Previous Year ComparisonAccrual Basis March 2016



Total Other Income


Total Other Expense

Net Other Income

Net Income


Mar 16

51.00

51.00

2,740.00

2,740.00

-2,689.00

90,612.88

Mar 15

300.00

300.00

2,392.00

2,392.00

-2,092.00

61,521.26

$ Change %Cha...

-249.00

-249.00

348.00

348.00

-597.00

29,091.62

-83.0%

-83.0%

14.6%

14.6%

-28.5%

47.3%

Page 2

04/13/16

Accrual Basis

UNITED MOBILEHOME OWNERS ASSOCIATION OF FAIRFIELD, INC.Profit & Loss by Class




4022 • Gas Income




Total Income

Cost of Goods Sold


Total COGS

Gross Profit

Expense6010 • Accounting

6013 • Accounting - CPA


6040 • Automobile Expense6041 • Auto Fuel


6060 • Bank Service Charges6061 • Bank Service Charges

6062 • Remote Deposit Service6063 • Returned Check Charges

Total 6060 • Bank Service Charges

6080 • Cable TV

6090 • Corp - Security6091 • Intrusion Detection


6190 • Garbage6210 • Internet Service

6211 AT&T DSL


6260 • Legal Fees


6281 - Building Maintenance

6286 - Site Maintenance



6301 • Employee Functions


6330 • Office Supplies

6331 • Office Supplies6333 • Software - Tech Support


6350 • /Short

6352 • /Short



6500 • Salaries

6510 - Manager


6530 • Office


6541 • Bookkeeping6542 • Bonuses - Promotional



Total 6500 - Salaries

6545 • Salary Direct Deposit fees6550 • Special Clothing





March 2016

Administration Country...

91.156.50

0.00

-813

Dover ... Utilities... Utilities-DOVER Unclass... TOTAL

000

000

000

91.542 82

248 76

66 77

0 00

27,487 79

24.796 13

000

-18018

9023

0.00

0.00

0.00

182,699 32

27.556 37

24,945 00

0 00

0 00

-813

550 00

315 53 52,283 92

400 00 0.00

000 91,698 37 92.258 35 52.283 92

25.27656

850 00

26,12656

000

0 00

000

0.00

000

0 00

-26.126 56 91,69837 92,258 35 52,283 92

8,199 00 0 00 0.00 0 00

0 00

52 90 0.00 0 00 0 00

44 60 25 00 50 00 000

24.00 oco 000 0.00

121 50 2500 50 00 000

0.00 6,274 15 6.222.13 0 00

40 05 0.00 4999 0 00

40 05 0.00 4999 0 00

0 00 -6273 -9 39 oco

000 0 00 244 00 oco

0 00 000 244 00 0 00

329 89 0.00 000 000

0.00 760.37 278 83 0 00

000 58 22

81859

789 71 0 00

000 1,068 53 0.00

23 46

000

375 00

0.00

354.91

0.00

000

354.90

000

1665

0 00

0 00

0 00

0 00

0 00

-89 95

0 00

-89 95

000

0 00

-89.95

000

0.00

0 00

000

0 00

000

0 00

0 00

000

0.00

0 00

0.00

0.00

0 00

0 00

0 00

52.501 37

95000

0.00 236,150 69

000 25,276.560.00 85000

0 00 . : 125 56

0.00 210,024.13

0.00 8.199 00

0.00 8,199.00

0 00

0.00

0.00

0.00

0.00

0 00

0.00

000

000

0.00

0.00

1.200 00

0.00

0.00

0.00

0 00

52 90

119 60

24 00

196.50

12.49628

90 04

90.04

-72.12

244 00

244 00

329.89

1.039 20

2,047 92

3,087 12

23 46

709 81

375 00

0 00 1213 1665 0 00 0 00 0 00 28 78

120 00 0 00 000 000 0 00 0.00 12000

4,166 66 0.00 000 0 00 000 000 4,166 66

10,411.76 000 000 000 0.00 000 10,411 76

0.00 6,34510 12.952 75 000 0 00 000 19.297 85

0 00 000 324 20 0 00 000 000 324.20

000 000 250 00 0 00 0 00 0 00 250 00

oco 0 00 0 00 0 00 000

0 00

0 00

0.00 000

000 0.00 57420 0 00 0.00 574.20

14.578 42 6,34510 13,526 95 0 00 0.00 34.45047

24 00 0 00 0 CO 000 0 00 0.00 24.00

991 34 0.00 0.00 0 00 0.00

000

0 00 991 34

991.34 000 0 00 0 00 000 991 34

1.232 49 587 88 1.093.97 0 00 0 00 000 2,91434

Page 1

04/13/16

Accrual Basis


Profit & Loss by ClassMarch 2016

6650 • Telephone

6651 • Telephone - Office6652 • Wireless Communication



6701 • Gas Expense6702 • Electric Expense

Total 6700 - Utilities - PG/E


Total Expense

Net Ordinary Income



7001 • Late & Returned Check Charges


Total Other Income

Other Expense

8050 • Rent Adjustment8052 • UPA

Total 8050 • Rent Adjustment

Total Other Expense

Net Other Income

Net Income


Administration

57 76

000

0 00

Country...

-1 83

000

Dover... Utilities... Utilities-DOVER Unclass... TOTAL

175 70

1.782 06

322 28

000

0.00

000

000

OCO

000

9 24

0 00

000

0 00

496.15

1 782.06

1,9

000

0 00

-1 83

000

0 00

322.28

000

000

0 00

4,66278

0 00

4.710.25

12.208.99

0.00

000

0.00

0.00

0 00

2,27821

9.373.03

12,208.99

0 00

13,97248

0.00

14,598.61

4,662 78

0 00

16,91 21.582.02

28.571 09

28.07593 oh :•::':, cii 37,53862 4,662.78 16,919.24 1.200.00 116.72225

-54.202 49 63.37269 54,71973 47,621 14 -17.009 19 -1.200 00 93.301.88

26 00

0 00

0 00 1.325.00

0 00 1,325 00

0 00 -1,299 00

-54,202.49 62,073.69

25 00 0.00

25 00

1.415.00 0 00

1.415 00 0 00

1,415 00 0.00

-1,390.00 0 00

53,329.73 47,621.14

0 00 51.00

0 00 51 00

000 000

000 2.740.00

0 00 0 00 2.740 00

2,740.00

0 00

-17,009.19 -1,200.00 90,612.88

Page 2

cm*^^ · 2016. 5. 3. · 6120 6140 6190 6200 6210 credit reports employees benefits garbage ins...

Documents