Real estate

Real Estate Analysis

You are an analyst at a small real-estate agency. The sales director wants a quick read on the current 60 listings: what the portfolio is worth, where prices are highest, and which homes are sitting on the market too long. Work through the steps in order; every step builds on the same workbook.

Deliverable: A listings sheet with price per square foot, a summary block, slow listings highlighted, a PivotTable of average price by neighborhood with a chart, and the table sorted by price.

1. 1Price per square foot30 pts
2. 2Portfolio value15 pts
3. 3Average price15 pts
4. 4How many condos?15 pts
5. 5Riverside average15 pts
6. 6Most expensive listing20 pts
7. 7Flag slow listings20 pts
8. 8Average price by neighborhood25 pts
9. 9Chart it15 pts
10. 10Sort by price15 pts