Budget analysis

Spring2018-CMP3400-Assignment3problem1baseline.xls

Sheet1

PROPERTY TAX ANALYSIS:				Problem #1
SCENARIO:		Baseline
PROPERTY TAX DETERMINATION									Assessed
			Assessed	Assess-		%			Value	Dec. 2005	TAD
			Value	ment	Equalized	Distri-	Apportioned		Tax	Tax	Tax
			Jan. 2005	Ratio	Value	bution	Levies		Rate	Bills	Receipts
City of Roaring Rapids			3,200,000	1.10	2,909,091	0.450	city	32,000	0.01000		55,273
							county	23,273	0.00727
Parcel 1	land		200,000				total	55,273	0.01727
	improvements		2,800,000
	total		3,000,000							51,818
Parcel 2	land		100,000
	improvements		100,000
	total		200,000							3,455
Town of Placidville			3,200,000	0.90	3,555,556	0.550	town	12,800	0.00400		41,244
							county	28,444	0.00889
Parcel 3	land		3,000,000				total	41,244	0.01289
	improvements		200,000
	total		3,200,000							41,244
Crepe Myrtle County			6,400,000		6,464,646
LOCAL				City	Town	County	DISTRIBUTION OF TAD RECEIPTS
GOVERNMENT
BUDGETS		SPENDING		1,132,000	513,000	1,372,000			City	Town	Tax
FY 2018		AIDS		1,000,000	500,000	1,200,000			TAD	TAD	Received
		OTHER REVENUES		100,000	200	120,283	Total receipts		55,273	41,244	96,517
							Payments to:
	PROPERTY TAX LEVY			32,000	12,800	51,717	City		32,000		32,000
							Town			12,800	12,800
							County		23,273	28,444	51,717
							Balance		0	0
IMPACT ASSESSMENT
		Baseline	Scenario		%			Baseline	Scenario		%
		Tax	Tax	Impact	Change			Tax Rate	Tax Rate	Impact	Change
Property 1		51,818	51,818	0	0.000		City	0.01727	0.01727	0.00000	0.000
Property 2		3,455	3,455	0	0.000		Town	0.01289	0.01289	0.00000	0.000
Property 3		41,244	41,244	0	0.000