Montgomery County, Maryland 2005 to 2006 Property Tax Analysis and Projection Spreadsheet created by Louis Wilen, firstname.lastname@example.org This spreadsheet has not been subjected to formal testing, nor has it been authorized, approved, or reviewed by the Montgomery County Government. Comments about Montgomery County property taxes should be emailed to email@example.com or to your Montgomery County Councilmember. This spreadsheet is designed to show the effect of tax rate and tax credit changes on properties that did not change ownership between 2005 and 2006. If the property being analyzed changed ownership during 2005 or 2006, additional property tax rules may apply that are not necessarily handled by this spreadsheet. Unusual credits, such as the "circuit breaker" tax credit, are not handled by this spreadsheet because they require input data that is unique to the individual taxpayer (such as personal income information). Additionally, although basic validation of input data is performed, it is still possible to enter incorrect data and receive invalid results (garbage in, garbage out). Despite its somewhat complex appearance, the spreadsheet is easy to use. The initial values for any property can be obtained and entered into the spreadsheet in about 3 minutes. To use the spreadsheet, follow these instructions: 1. Go to http://www.dat.state.md.us. (You can click on the cell to the right to go there now.) Select "Real Property Data Search". From the pull down, select "Montgomery County". The click on the "Street Address" button. Enter the street address number and the street name of the property of interest. Do not enter RD, ST, AVE, or any other street name suffix. The press the SEARCH button. Print the page that is displayed. (Note: For condos and other properties that share an address, select the property of interest from the list that is displayed.) 2. Go to https://www.montgomerycountymd.gov/apps/tax/index.asp. (You can click on the cell to the right to go there now.) In the STREET ADDRESS field, enter the street address of the property of interest. Then select the VIEW button to the right of the street address box. Next, click on the account number for the property. Then select the bill for the 2005 tax year. Then click on "Click here for a printer-friendly version of your tax bill ". Print the bill. 3. Using the information from SDAT data sheet and the tax bill that you printed, modify the values in the boxes with the black values in lines 5 to 7 and lines 14 to 23 of the Tax Projection Worksheet, accessible by clicking on the yellow tab at the bottom of this screen. The green values on the worksheet are all calculated and cannot be changed. 4. Adjust the values in C50 to C54 to see the effects of various tax rates and tax credits on your taxes. If you live in a municipal area, be sure to set box C54 to the anticipated 2006 rate for your municipality (call you local government tax office to find out the expected 2006 rate). A reasonable starting value for box C53 is the same as the value in box B53. Box C49 can be changed to N to view the tax savings that landlords and other property owners get who are not using the property as their principal residence. Boxes B60, B61, and B62 show the projected tax bill and mortgage payment change for 2006. When the tax rate (box C55) is reduced enough to actually have an effect on the property tax, the amount in box B60 will begin to decline, and at that tax rate (and lower), you will be receiving a tax cut benefit. FAQ: Question: Where can I find detailed information about how Montgomery County taxes are calculated? Answer: http://www.montgomerycountymd.gov/content/finance/CountyTaxes/Info%20Taxes/county_taxes.ASP Question: I think that I found an error in the spreadsheet. Can you correct it? Answer: I am eager to correct any errors. Please send error reports to firstname.lastname@example.org. In your note, please include the address of the property being analyzed and a description of the error. Also attach a copy of the spreadsheet to your note. Please note that this spreadsheet has not been subjected to formal testing, so it may contain errors. Question: Can you enhance the spreadsheet so that I could simply type in a property address and have the values for the property from the SDAT and the county tax records be automatically inserted into the spreadsheet? Answer: That would be a very useful enhancement, but due to the way that the data from the SDAT and the county web sites is formatted, it would be very time-consuming to write the code to automatically insert the data into the spreadsheet. However, if someone has some extra time and is willing to write the code, I would certainly use it. If anyone from the county or state is listening, it would be very helpful to make the data from the web sites available as XML formatted documents. Question: What is the purpose of the Tax Class Table? Answer: It is used to calculated the Special Area Property Tax Rate and the Municipal Area Property Tax Rate, based on the tax CLASS. The Tax Class Table is in hidden columns, but can be unhidden if desired. Do not modify the Tax Class Table because doing so will cause the results in the Tax Projection Worksheet to be incorrect. Click here to obtain the most current version of this spreadsheet from: http://mocotax.com http://www.dat.state.md.us https://www.montgomerycounty md.gov/apps/tax/index.asp Montgomery County, Maryland 2005 to 2006 Property Tax Analysis and Projection Spreadsheet created by Louis Wilen, email@example.com Want instructions? Click on the Instructions tab at the bottom of the page to view the instructions for using this spreadsheet. Obtain these values from the SDAT online information for your property at: http://www.dat.state.md.us (Select Real Property Data Search) Total base value (from "Base Value" column) Assessment Cycle Year (2004, 2005, or 2006, from "Value As Of" column) Total Value As Of 01/01 in Cycle Year (From "Value As Of" column) Phase-in yearly adjustment Phase-in values as of 07/01/05 and 07/01/06 (should match SDAT data sheet) County and State homestead taxable value for 2005 and 2006 (10% cap) Municipal homestead taxable value for 2005 and 2006 (% cap varies depending on municipality) 0 <-- From SDAT 2005 <-- From SDAT 0 <-- From SDAT 0 0 0 0 Anticipated 2006 Value (typically same as 2005) 0 0 0 Obtain these values from your 2005 County Tax Bill. These are not taxes, but are additional fees included on your tax bill that usually remain constant each year, but occasionally change. WATER QUAL PROTECT CHG SOLID WASTE CHARGE WSSC CONNECTION FEE CHG WSSC FRONT FOOT BENEFIT CHG OTHER CHARGE OTHER CHARGE TOTAL FEES Principal Residence in 2005? (Y or N) CLASS (in box on left or top edge of tax bill) Assessment Homestead Credit (must be zero or negative) Y 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 <--From tax bill <--From tax bill R042 0 <--From tax bill 2005 County Tax without homestead credit County Homestead Credit County Tax with homestead credit State Tax without homestead credit State Homestead Credit State Tax with homestead credit Special Area Tax without homestead credit Special Area Homestead Credit Special Area Tax with homestead credit Municipal Tax without homestead credit Municipal Homestead Credit Municipal Tax with homestead credit County Property Tax Credit ("Fixed" credit) Total Tax without Credits Total Credits TOTAL TAX TOTAL AMOUNT OF TAX BILL (TOTAL TAX + TOTAL FEES) Anticipated Principal Residence in 2006 (Y or N) Anticipated "Fixed" County Property Tax Credit for 2006 (Enter as a negative number) 2006 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Y <-- Adjust to see effect 0.00 <-- Adjust to see effect 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -116.00 0.00 -116.00 -116.00 -116.00 County property tax rate State property tax rate Special area property tax rate Municipal area property tax rate Total Tax Rate 0.679 0.132 0.288 0.000 1.099 0.584 <-- Adjust to see effect 0.112 <-- Adjust to see effect 0.288 <-- Adjust to see effect 0.000 <-- Adjust to see effect 0.984 Based on the rates, charges, and credits above, your 2006 property tax bill will change as shown below. Projected increase in tax from 2005 to 2006 Projected increase in total bill from 2005 to 2006 Projected increase in monthly mortgage payment (for properties where a mortgage company maintains a tax escrow account) $116.00 $116.00 -100.00% -100.00% $9.67 NOTE: Calculated values may not match tax bill due to rounding, but will normally be within about 2 cents of tax bill values. erty Tax Analysis and Projection age to view the instructions for using this spreadsheet. Property Address (optional) Enter property address here. This is for identification purposes only and has no effect on the results. Municipal Homestead cap (varies depending upon municipality) ---> <-- Adjust to see effect <-- Adjust to see effect <-- Adjust to see effect <-- Adjust to see effect <-- Adjust to see effect <-- Adjust to see effect ll normally be within about 2 cents of tax bill values.