Complete in Excel

You are an intern at the the Tax Assesors Office for the city of Winkelman and your supervisor, Mrs. Jacqueline Anderson, has asked uou to prepare the following

.A property tax estimate for a new built subdivision (Walters) after she conducted her assessment of the property. Apply a 12% millage rate on the assessed value of each house and the park. The land that the house sits on is included in the market value of the property. Also, what is the total assessed value of all the units/properties and the total estimated tax?

1. The new subdivision has 100 units and Park. The price provided below are based on assessed value.

2. There are 15 two-bedroom houses on 5 acres of land valued at $70,000.00 each

3. There are 15 two-bedroom houses on 20 acres of land valued at $85,000.00 each

4. There are 60 three-bedroom houses with a two-car garage on 75 acres of land. The houses They are valued at $210,000.00 each

5. The last 15 houses are four-bedroom units with a two car garage on 15 acres of land. They are valued at $170,000.00

6. Lastly, the subdivision has a park with a swimming pool, tennis court, and a basketball court. The park and green space is valued at $65,000.00

Note: Assessed value is: Individual Unit Value X the Number of Units

Here is the Table to calculate the estimates, I had to align it vertically becuase of restrictions on Chegg. But the table is horizontal, 6 Categories across stating with items, and Green Space and Park at the botton of all 6, and total underneath that

Property Tax Estimate

Walters Subdivison

City of Winkelman

FY of 2014

Items

Two BR on 5 Acres

Two BR on 20 Acres

Three BR on 75 Acres

Four BR on 20 Acres

Number of Units

15

15

60

15

Green Space and Park 1

Total: 101

Indivdual Unit Value

$70,000.00

85,000.00

210,000.00

170,000.00

Green Space and Park 65,000.00

Assessed Value _________

Green Space and Park _________

Miilliage Rate 12%

12%

12%

12%

12%

Green Space and Park 12%

Total Est. Tax _______

Green Space and Park ______