Overview

Financials
Balance Sheet
Actual 2018
Check Register
Budget 2019
Cash Analysis

Sheet 1: Financials

Lakeside Terrace Estates II HOA Operating Statement 2018
Operating Budget vs. Actual
	2018 Budget	2018 Actual	2018 Variance	2019 Budget
Dues per Lot - Operating Expenses	315	315

Revenue
Dues for Operating Expenses (60 lots)	18,900	18,800	(100)	24000
Late Fee Revenue		30	30
Transfer Fees		300	300
Interest Income	5	4	(1)	5
Other Revenue		0	0
Total Revenue	18,905	19,134	229	24005

Expenses
Lawn Maintenance
Sprinkler Blowout/Activation	120	120	0	500
Cleaning		0	0
Aeration		0	0
Mowing	7,700	6,600	1,100	9600
Fertilization	1,800	1,830	(30)	2135
Trees/Plants	700	882	(182)	900
Sprinkler Repair	300	650	(350)	300
City of Loveland Water	6,500	5,559	941	8450
Post Office Box Rental	126	134	(8)	134
Office Supplies & Expenses	100	584	(484)	200
State Filing Fee (DORA)	28	0	28	28
Insurance (State Farm)	1,125	1,294	(169)	1400
Web Site Hosting	120	94	26	120
State of Colorado Association	10	0	10	10
Association Annual Meeting Costs	75	0	75	75
Bank Service Charge		0	0
Federal Taxes		0	0
Total Expenses	18,704	17,746	958	23852
Net Income	201	1,387	1,186

Asset Replacement Fund
Dues per Lot - Capital Reserve	50	50
Dues for Capital Reserve	3,000	3,000


2018 Cash Analysis
	Operating Account		Reserve Account
Beginning Balance 2018	2,276.61		14,486.54
Revenue	19,133.68	2018 Assessment	3,000.00
Less Expenses Paid	17,746.23	Interest Income	11.94
Transfers (Out)/In		Transfers In/(Out)	0.00
Cash Balance @ Month-End	3,664.06		17,498.48

Total Cash on Hand		21,162.54

Sheet 2: Balance Sheet

Lakeside Terrace Estates II HOA Balance Sheet
31-Dec-17
ASSETS
	Current Assets
		Operating Account	$3,664.06
		Reserve Account	$17,498.48
		Total Cash		$21,162.54
	Total Current Asssets				$21,162.54
TOTAL ASSETS

LIABILITITES & EQUITY

	Equity
		Reserves
		Prior Capital Reserves	$14,486.54
		Current Year Increases/(Decreases)	$3,011.94
		Total Reserves		$17,498.48

		Retained Earnings	$2,276.61
		Net Income (Loss)	$1,387.45
	Total Equity			$3,664.06
TOTAL LIABILITIES & EQUITY					$21,162.54

Sheet 3: Actual 2018

Lakeside Terrace Estates II HOA Actual 2017

	January	February	March	April	May	June	July	August	September	October	November	December	Total

Revenue
Dues per Lot (60) @ 315	4,725.00	2,835.00	6,200.00	2,835.00	1,575.00		630.00						18,800.00
Late Fee Revenue					20.00		10.00						30.00
Transfer Fees	50.00	50.00	50.00	100.00			50.00						300.00
Interest Income	0.16	0.37	0.55	0.59	0.64	0.54	0.49	0.34					3.68
Other Revenue													0.00

Total Revenue	4,775.16	2,885.37	6,250.55	2,935.59	1,595.64	0.54	690.49	0.34	0.00	0.00	0.00	0.00	19,133.68

Expenses
Lawn Maintenance													0.00
Sprinkler Blowout/Activation/Backflow Test					120.00								120.00
Cleaning													0.00
Aeration													0.00
Mowing			1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00					6,600.00
Fertilization- Lawn Chasers			305.00	305.00	305.00	305.00	305.00	305.00					1,830.00
Trees/Plants					882.00								882.00
Sprinkler Repair						650.00							650.00
City of Loveland Water	55.06	57.48	59.78	58.92	222.13	187.07	2,335.59	1,512.83	1,069.67				5,558.53
Post Office Box Rental		134.00											134.00
Office Supplies & Expenses	180.50							20.00	383.21				583.71
State Filing Fee (DORA)													0.00
Insurance (State Farm)			1,294.00										1,294.00
Web Site Hosting			93.99										93.99
State of Colorado Association													0.00
Association Annual Meeting Costs													0.00
Bank Service Charge													0.00
Federal Taxes													0.00

Total Expenses	235.56	191.48	2,852.77	1,463.92	2,629.13	2,242.07	3,740.59	2,937.83	1,452.88	0.00	0.00	0.00	17,746.23

Transfer to (from) Capital Expense Account	-1,150.00		-400.00			-1,350.00	-100.00						-3,000.00

Net Expenses	-914.44	191.48	2,452.77	1,463.92	2,629.13	892.07	3,640.59	2,937.83	1,452.88	0.00	0.00	0.00	14,746.23

Net Income after Transfer	5,689.60	2,693.89	3,797.78	1,471.67	-1,033.49	-891.53	-2,950.10	-2,937.49	-1,452.88	0.00	0.00	0.00	4,387.45

Sheet 4: Check Register

		Lakeside Terrace Estates II HOA Check Register 2018
		Guaranty Bank - Account Number 065552						Guaranty Bank - Account Number 9186913 - Savings Acct
Date	Check No.	Description	Deposits	Checks	Balance	Reconciled		Description	Deposits	Transfers Out	Balance	Reconciled
		Beginning Balance			$2,276.61			Beginning Balance			14486.54
1/5/2018	2004	City of Loveland		$55.06	$2,221.55			Trans from Checking	750.00		$15,236.54
1/22/2018		Tooker	$365.00		$2,586.55			Trans from Checking	400.00		$15,636.54
		Muller	$365.00		$2,951.55			January Interest	1.38		$15,637.92
		Walton	$365.00		$3,316.55			February Interest	1.32		$15,639.24
		Banbury	$365.00		$3,681.55		10-Mar	Trans from Checking			$15,639.24	Posted $600 here but not according to Guaranty - removed
		Foreman	$365.00		$4,046.55		28-Mar	Trans from Checking	400.00		$16,039.24	x
		Kessler	$365.00		$4,411.55			March interest	1.47		$16,040.71	x
		Klagge	$365.00		$4,776.55			April interest	1.45		$16,042.16	x
		Rogers	$365.00		$5,141.55		6/4/2018	Trans from Checking	1,350.00		$17,392.16	x
		Baney	$365.00		$5,506.55		5/31/2018	May interest	1.50		$17,393.66	x
		Benedict	$730.00		$6,236.55		6/30/2018	June interest	1.56		$17,395.22	x
		Morgan	$365.00		$6,601.55		7/23/2018	Trans from Checking	100.00		$17,495.22
		O'Donnell	$365.00		$6,966.55		7/31/2018	July interest	1.63		$17,496.85
		Pape	$365.00		$7,331.55		8/31/2018	August interest	1.63		$17,498.48
		Fidelity Title (Delrita Boyd)	$415.00		$7,746.55						$17,498.48
1/22/2018		Trans to Savings Account		$750.00	$6,996.55						$17,498.48
	2005	Ann Sims		$86.68	$6,909.87						$17,498.48
	2006	Jim Willard		$93.82	$6,816.05						$17,498.48
1/30/2018		Payne	$365.00		$7,181.05						$17,498.48
		Susan Boyd	$365.00		$7,546.05						$17,498.48
		Balsiger	$365.00		$7,911.05						$17,498.48
		McNaught (Ferguson)	$365.00		$8,276.05						$17,498.48
		Weegens	$365.00		$8,641.05						$17,498.48
		Land Title (Tierney)	$415.00		$9,056.05						$17,498.48
		Snell	$315.00		$9,371.05						$17,498.48
		Pickering	$365.00		$9,736.05						$17,498.48
		Sims	$365.00		$10,101.05						$17,498.48
		Trans to Savings Account		$400.00	$9,701.05						$17,498.48
1/31/2018		Interest Income	$0.16		$9,701.21						$17,498.48
2/17/2018	2007	City of Loveland		$57.48	$9,643.73						$17,498.48
	2008	U.S. Post Office		$134.00	$9,509.73						$17,498.48
2/28/2018		Interest Income	$0.37		$9,510.10						$17,498.48
3/8/2018		Harden	$365.00		$9,875.10	x					$17,498.48
		Boettcher	$365.00		$10,240.10	x					$17,498.48
		Haas	$365.00		$10,605.10	x					$17,498.48
		Staiano	$365.00		$10,970.10	x					$17,498.48
		Willard	$365.00		$11,335.10	x					$17,498.48
		Schneider	$365.00		$11,700.10	x					$17,498.48
		McVay	$365.00		$12,065.10	x					$17,498.48
		Keys	$365.00		$12,430.10	x					$17,498.48
		Welle	$365.00		$12,795.10	x					$17,498.48
		Fishburn	$365.00		$13,160.10	x					$17,498.48
		King	$365.00		$13,525.10	x					$17,498.48
		Schichtel	$415.00		$13,940.10	x					$17,498.48
3/10/2018		Trans to Savings Account			$13,940.10	Posted $600 here by Ann Sims but not posted on Guaranty - removed					$17,498.48
	2009	City of Loveland		$59.78	$13,880.32	x					$17,498.48
3/27/2018	2010	State Farm Insurance		$1,294.00	$12,586.32	x					$17,498.48
3/27/2018	2011	Dick Snell		$93.99	$12,492.33	x					$17,498.48
3/28/2018		Moss/Tiefenbrun	$365.00		$12,857.33	x					$17,498.48
		Schilling	$265.00		$13,122.33	x					$17,498.48
		Pressnall	$365.00		$13,487.33	x					$17,498.48
		Mallot	$365.00		$13,852.33	x					$17,498.48
		Felicelli	$365.00		$14,217.33	x					$17,498.48
		Olson	$365.00		$14,582.33	x					$17,498.48
		Johnson	$315.00		$14,897.33	x					$17,498.48
		Johnson	$50.00		$14,947.33	x					$17,498.48
		Atkins	$365.00		$15,312.33	x					$17,498.48
3/28/2018		Trans to Savings Account		$400.00	$14,912.33	x					$17,498.48
3/30/2018		Interest Income	$0.55		$14,912.88	x					$17,498.48
4/4/2018	2153	Lawn Chasers		$1,405.00	$13,507.88	x					$17,498.48
4/26/2018		McGinnis	$365.00		$13,872.88	x					$17,498.48
		Harting	$365.00		$14,237.88	x					$17,498.48
		Straub	$365.00		$14,602.88	x					$17,498.48
		Jirik	$730.00		$15,332.88	x					$17,498.48
		Donovan	$365.00		$15,697.88	x					$17,498.48
		Van Dell	$365.00		$16,062.88	x					$17,498.48
		Shaw	$365.00		$16,427.88	x					$17,498.48
		Koch	$365.00		$16,792.88	x					$17,498.48
4/26/2018		Transfer Fee - Sims to Fierstine and Khamcharoen	$50.00		$16,842.88	x					$17,498.48
		Transfer Fee - Balsiger to Oberhammer	$50.00		$16,892.88	x					$17,498.48
4/26/2028	2154	Colorado Greenbelt Management		$750.00	$16,142.88	Paid to CO Greenbelt Management however invoice was not meant for LTE II HOA					$17,498.48
	2154	Void	$750.00		$16,892.88						$17,498.48
	2155	City of Loveland		$58.92	$16,833.96	x					$17,498.48
4/30/2018	2156	Lawn Chasers		$1,405.00	$15,428.96	x					$17,498.48
4/30/2018		Interest Income	$0.59		$15,429.55	x					$17,498.48
5/1/2018	2157	City of Loveland		$29.79	$15,399.76	x					$17,498.48
5/8/2018	2158	Davey Tree Expert Company		$882.00	$14,517.76	x					$17,498.48
		Mankin	$365.00		$14,882.76	x					$17,498.48
5/25/2018	2159	Lawn Chasers		$1,405.00	$13,477.76	x					$17,498.48
5/29/2018	2160	City of Loveland		$68.57	$13,409.19	x					$17,498.48
5/29/2018	2161	City of Loveland		$123.77	$13,285.42	x
5/30/2018		Juhasz	$375.00		$13,660.42	x
		Koons	$375.00		$14,035.42	x
		Romansky	$365.00		$14,400.42	x
		Wheeler	$365.00		$14,765.42	x
		Snell	$50.00		$14,815.42	x
5/31/2018	2162	Farber Lawn Service/Mark Farber		$120.00	$14,695.42	x
5/31/2018		Interest Income	$0.64		$14,696.06	x
6/4/2018		Transfer to Savings Account		$1,350.00	$13,346.06	x
6/15/2018	2163	Lawn Chasers (via MJ Willard)		$550.00	$12,796.06	x
6/15/2018	2164	City of Loveland		$85.61	$12,710.45	x
6/15/2018	2165	City of Loveland		$101.46	$12,608.99	x
6/30/2018		Interest Income	$0.54		$12,609.53	x
7/5/2018	2166	City of Loveland		$382.44	$12,227.09
7/5/2018		Knight/Wheeler	$10.00		$12,237.09
7/5/2018		Transfer - Donovan to Lee	$50.00		$12,287.09
7/5/2018		Preston	$365.00		$12,652.09
7/5/2018		Fujarczyk	$375.00		$13,027.09
7/9/2018	2167	Lawn Chasers		$1,505.00	$11,522.09
7/11/2018	2168	City of Loveland		$625.70	$10,896.39
7/11/2018	2169	City of Loveland		$441.97	$10,454.42
7/23/2018		Transfer to Savings Account		$100.00	$10,354.42
7/31/2018	2171	City of Loveland		$885.48	$9,468.94
7/31/2018		Interest Income	$0.49		$9,469.43
8/1/2018	2172	Lawn Chasers		$1,405.00	$8,064.43
8/19/2018	2053	City of Loveland		$628.65	$7,435.78
8/19/2018	2054	City of Loveland		$884.18	$6,551.60
8/28/2018	2056	MJ Willard		$20.00	$6,531.60
8/31/2018		Interest Income	$0.34		$6,531.94
9/3/2018	2055	David Richards		$383.21	$6,148.73
9/10/2018	2057	City of Loveland		$309.14	$5,839.59
9/10/2018	2058	City of Loveland		$381.58	$5,458.01
9/10/2018	2059	City of Loveland		$378.95	$5,079.06
9/10/2018	2060	Lawn Chasers		$1,405.00	$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06
					$3,674.06

			$22,893.68	$21,496.23

Sheet 5: Budget 2019

Lakeside Terrace Estates II HOA 2019 Budget
	2018 Budget	2018 Actual	2018 Variance	2019 Budget
Dues per Lot	315	315		400

Revenue
Dues per Lot (60)	18,900	18,800	-100	24000
Late Fee Revenue		30	30	0
Transfer Fees		300	300	0
Interest Income	5	4	-1	5
Other Revenue		0	0	0
Total Revenue	18,905	19,134	229	24005

Expenses
Lawn Maintenance
Sprinkler Blowout/Activation/Backflow	120	120	0	500
Cleaning	0	0	0
Aearation	0	0	0
Mowing	7,700	6,600	1,100	9600
Fertilization	1,800	1,830	-30	2135
Trees/Plants	700	882	-182	900
Sprinkler Repair	300	650	-350	300
City of Loveland Water	6,500	5,559	941	8450
Post Office Box Rental	126	134	-8	134
Office Supplies & Expenses	100	584	-484	200
State Filing Fee (DORA)	28	0	28	28
Insurance (State Farm)	1,125	1,294	-169	1400
Web Site Hosting	120	94	26	120
State of Colorado Association	10	0	10	10
Association Annual Meeting Costs	75	0	75	75
Bank Service Charge		0	0
Federal Taxes		0	0
Total Expenses	18,704	17,746	958	23852
Transfer to (from) Capital Expense Account	0	-3,000
Net Expenses	18,704	14,746	958	23,852
Net Income after Transfer	201	4,387	1,186	153

Sheet 6: Cash Analysis

Cash Analysis
Beginning Balance 2018		2,276.61
Revenue		19,133.68
Less Expenses Paid		17,746.23
Less Transfer to Capital Improvement		-3,000.00
Checking Account Balance @ October 31, 2017		6,664.06
Projected Expenses Remaining		0.00
Projected Cash Balance at Year-End		6,664.06
Capital Improvement Savings Account		17,498.48
Total Cash on Hand		24,162.54