A residential subdivision has the following sales data over the past 12 months: Month 1-3: 15 sales, Month 4-6: 22 sales, Month 7-9: 28 sales, Month 10-12: 35 sales. The current inventory is 180 homes. Based on the most recent quarter's activity, what is the current absorption rate?
Correct Answer
A) 5.1 months
Most recent quarter (Month 10-12) shows 35 sales over 3 months = 11.67 sales per month. Absorption rate = 180 homes ÷ 11.67 sales per month = 5.1 months.
Why This Is the Correct Answer
Option A correctly calculates the absorption rate using the most recent quarter's sales data (35 sales in months 10-12). First, we determine the monthly sales rate: 35 sales ÷ 3 months = 11.67 sales per month. Then we divide current inventory by monthly sales rate: 180 homes ÷ 11.67 sales per month = 5.1 months. This represents how long it would take to absorb all current inventory at the most recent sales pace.
Why the Other Options Are Wrong
Option B: 15.4 months
This answer likely results from using an incorrect sales period or averaging all quarters instead of focusing on the most recent quarter. It may also stem from dividing inventory by quarterly sales (35) instead of monthly sales rate (11.67).
Option C: 6.4 months
This incorrect answer probably comes from using a different quarter's data or making calculation errors in determining the monthly sales rate from the most recent quarter's activity.
Option D: 1.9 months
This answer is far too low and likely results from dividing current inventory by total annual sales or making a fundamental calculation error in the absorption rate formula.
AIMS Method
A-I-M-S: Absorption = Inventory ÷ Monthly Sales. Remember 'AIMS at the market' - you're aiming to measure how the market absorbs inventory.
How to use: When you see absorption rate questions, immediately think AIMS: find the current inventory, calculate monthly sales from the most recent quarter, then divide inventory by monthly sales.
Exam Tip
Always use the most recent quarter's sales data for absorption rate calculations, and remember to convert quarterly sales to monthly sales by dividing by 3 before calculating the final absorption rate.
Common Mistakes to Avoid
- -Using total annual sales instead of the most recent quarter's data
- -Forgetting to convert quarterly sales to monthly sales rate
- -Dividing monthly sales by inventory instead of inventory by monthly sales
Concept Deep Dive
Analysis
Absorption rate is a critical market analysis metric that measures how long it would take to sell all available inventory at the current sales pace. It's calculated by dividing current inventory by the average sales per month, typically using the most recent quarter's data for accuracy. This metric helps appraisers assess market conditions - lower absorption rates indicate stronger markets with faster sales, while higher rates suggest slower markets. The key is using the most current sales data to reflect present market conditions rather than averaging all historical data.
Background Knowledge
Absorption rate measures market velocity by calculating how long current inventory would last at the present sales pace, expressed in months. It's calculated as: Current Inventory ÷ Average Monthly Sales = Absorption Rate in Months. Appraisers typically use the most recent quarter's data to ensure the calculation reflects current market conditions rather than outdated trends.
Real-World Application
Appraisers use absorption rates to support market condition conclusions in reports, helping clients understand whether they're in a buyer's market (high absorption rate) or seller's market (low absorption rate), which directly impacts pricing strategies and market value opinions.
More Market Analysis Questions
Which comparable selection criterion is MOST important when choosing sales for a residential appraisal?
A residential subdivision has absorbed 120 units over the past 18 months. Based on this historical data, how long would it take to sell 80 remaining lots?
Which of the following is the correct sequence for analyzing highest and best use?
A market has 500 homes sold in the past 12 months and currently has 180 homes for sale. The monthly absorption rate is:
When analyzing highest and best use, which of the following would make a use financially infeasible?
People Also Study
Valuation Principles & Procedures
25% of exam
Property Description & Analysis
20% of exam
Appraisal Math & Statistics
15% of exam
USPAP (Ethics & Standards)
15% of exam
Report Writing & Compliance
10% of exam