urgent need asap Preparing budgets
smilenjoylife
exampleofexcelformulaformodule2budgetrequestpad3204.xlsAppendix 2A
| Example of excel formula for the budget | ||||
| City of Theodore | ||||
| FY 2013-2014 | Estimated | Year to Date | Uncollected | Uncollected |
| Revenue | Actual Revenue | Balance | Percent | |
| GENERAL FUND | ||||
| Tax Revenue-City Portion | $ 1,780,000.00 | $ 1,649,781.71 | $ 130,218.29 | 7.32% |
| Auto Property Tax | 225,000.00 | 161,377.07 | 63,622.93 | 28.28% |
| Prop. Tax Int & Penalty | 10,000.00 | 13,171.73 | <3171.73> | -31.72% |
| Prop. Tax Int/ Penalty Prior | 90,000.00 | 7,831.06 | 82,168.94 | 91.30% |
| Auto Tax (State) | - 0 | 3,576.97 | <3576.97> | |
| Prop tax Delinq 96 Prior | - 0 | 36,560.21 | <36560.21> | |
| Prop Tax Delinq 97 | - 0 | 238,490.52 | <238490.52> | |
| Propery Taxes (State) | 35,000.00 | 35,920.50 | <920.5> | -2.63% |
| Payment in Lieu of Taxes | 68,000.00 | 28,589.12 | 39,410.88 | 57.96% |
| Bank Deposits Tax | 90,000.00 | 100,863.58 | <10863.58> | -12.07% |
| Tobacco Tax | - 0 | 6.02 | <6.02> | |
| Payroll Tax | 6,225,000.00 | 4,693,517.87 | 1,531,482.13 | 24.60% |
| Payroll Tax Penalty | 6,000.00 | 11,631.66 | <5631.66> | -93.86% |
| Business Licneses | 600,000.00 | 43,612.99 | 556,387.01 | 92.73% |
| Business Lic. Pen& Int | - 0 | 3,711.08 | <3711.08> | |
| INS Premium Licnese Tax | 1,575,000.00 | 1,186,939.63 | 388,060.37 | 24.64% |
| Liquor and Beer Licenses | 19,000.00 | 1,693.75 | 17,306.25 | 91.09% |
| Cable TV Franchise | 150,000.00 | 95,538.35 | 54,461.65 | 36.31% |
| Franchise Tax | 65,000.00 | 103.24 | 64,896.76 | 99.84% |
| Court Revenue | 125,000.00 | 93,696.78 | 31,303.22 | 25.04% |
| Severance Tax | 25,000.00 | 24,374.24 | 625.76 | 2.50% |
| Insurance Payroll DED | - 0 | - 0 | - 0 | |
| Investement Interest | 325,000.00 | 250,744.95 | 74,255.05 | 22.85% |
| Rent Income | 3,000.00 | 2,250.00 | 750.00 | 25.00% |
| Misc Inc Used Veh/Equip Sale | 15,000.00 | 17,950.66 | <2950.66> | -19.67% |
| Misc-Inc Police CT Sale | - 0 | - 0 | - 0 | |
| Building Permit Fees | 60,000.00 | 59,960.02 | - 0 | 0.07% |
| FEMA Flood Reimbursement | - 0 | 12,690.00 | <12690> | |
| Miscellaneous Income | 25,000.00 | 20,091.96 | 4,908.04 | 19.63% |
| DARE Program Reimbursement | 17,000.00 | 21,026.30 | <4026.30> | -23.68% |
| HWY Safety Prog. Reimbur. | 35,000.00 | 14,743.25 | 20,256.75 | 57.88% |
| Building Demo Reimbursement | 10,000.00 | - 0 | 10,000.00 | 100.00% |
| Houseing Authority Grant | 33,000.00 | 24,099.02 | 8,900.98 | 26.97% |
| Staduium Prop Sale | 9,000.00 | - 0 | 9,000.00 | 100.00% |
| Circuit Court Clerk Fees | 4,000.00 | 3,890.00 | 110.00 | 2.75% |
| Police Department | 8,000.00 | 5,679.20 | 2,320.80 | 29.01% |
| Animail Control License Fee | 20,000.00 | - 0 | 20,000.00 | 100.00% |
| Parking Meters | - 0 | - 0 | - 0 | |
| SUBTOTAL General Fund Net | $ 11,652,000.00 | $ 8,864,113.44 | $ 3,110,445.81 | |
| SUBTOTAL GENERAL Fund Prior YR | $ 820,179.00 | $ - 0 | $ 820,179.00 | |
| TOTAL General Revenue Fund | $ 12,472,179.00 | $ 8,864,113.44 | $ 3,930,624.81 |
&A
Sheet2
&A
Page &P
Sheet3
&A
Page &P
Sheet4
&A
Page &P
Sheet5
&A
Page &P
Sheet6
&A
Page &P
Sheet7
&A
Page &P
Sheet8
&A
Page &P
Sheet9
&A
Page &P
Sheet10
&A
Page &P
Sheet11
&A
Page &P
Sheet12
&A
Page &P
Sheet13
&A
Page &P
Sheet14
&A
Page &P
Sheet15
&A
Page &P
Sheet16
&A
Page &P
