````markdown
title: “MARKET ANALYSIS SUMMARY” author: “Katherine Button” date: “December 03, 2025” output: pdf_document: toc: true toc_depth: 2 geometry: margin=1in fontsize: 12pt mainfont: Arial —
Purpose & Scope
This report summarizes the subject market using two data scopes:
- Assignment Data Frame (ADF): Broad market — nearby neighborhoods with similar utility and buyer appeal.
- Competitive Market Segment (CMS): Narrower — best substitutes to the subject based on gross living area, age, condition, and overall appeal.
Key market indicators analyzed include:
- Number of competing sales and listings
- Price ranges and median pricing
- Absorption rate and months of inventory
- Indicators of market (time) conditions
Both tables include Median Sale Price and Median Days on Market (DOM) to strengthen reliability and market relevance.
Assignment Data Frame (ADF) — Broader Market
ADFmarket_summary_vertical <- read_csv("data/ADFmarket_summary_vertical.csv")
ADFmarket_summary_vertical <- ADFmarket_summary_vertical %>%
mutate(across(where(is.numeric), ~ comma(., accuracy = 1)))
kable(ADFmarket_summary_vertical, caption = "Assignment Data Frame — Key Indicators")| Metric | Value |
|---|---|
| Number_Sold | 128 |
| Sold_Min_Price | 230,000 |
| Sold_Max_Price | 615,000 |
| Sold_Median_Price | 476,250 |
| Median_Year_Built | 1,981 |
| Median_DOM | 12 |
| Number_Listings | 30 |
| Listing_Min_Price | 405,000 |
| Listing_Max_Price | 560,000 |
| Absorption_Rate | 11 |
| Inventory | 3 |
Competitive Market Segment (CMS) — Best Substitutes
CMSmarket_summary_vertical <- read_csv("data/CMSmarket_summary_vertical.csv")
CMSmarket_summary_vertical <- CMSmarket_summary_vertical %>%
mutate(across(where(is.numeric), ~ comma(., accuracy = 1)))
kable(CMSmarket_summary_vertical, caption = "Competitive Market Segment — Key Indicators")| Metric | Value |
|---|---|
| Number_Sold | 50 |
| Sold_Min_Price | 395,000 |
| Sold_Max_Price | 565,000 |
| Sold_Median_Price | 487,500 |
| Number_Listings | 17 |
| Listing_Min_Price | 420,900 |
| Listing_Max_Price | 559,000 |
| Absorption_Rate | 4 |
| Inventory | 4 |
Gross Living Area Distribution
Net Price & PPSF Alignment: CMS vs ADF
Market Conditions (Time Adjustment Support)
Summary
The CMS provides a reliable, competitive set of comparables for the subject property. Median sale price and DOM reflect current buyer behavior, and months of inventory indicate overall market balance. Time-trend analysis based on CMS sales supports the market condition (time) adjustments applied in the Sales Comparison Approach.
---