CAM Data Analysis and Interpretation 3 — Questions and Answers
Question 1: Which financial statement is most useful for analyzing a property's ability to generate cash flow after all operating expenses but before debt service?
- Balance sheet
- Rent roll
- Operating statement showing NOI (Correct answer)
- Capital expenditure schedule
Correct answer: Operating statement showing NOI
The operating statement's net operating income (NOI) line shows income after operating expenses but before financing costs, making it the standard cash-flow measure.
Question 2: A manager tracks the average days-to-lease metric and finds it increased from 12 to 22 days. Which action is most directly supported by this data?
- Reducing the maintenance budget
- Reviewing pricing strategy and marketing channel effectiveness (Correct answer)
- Increasing the security deposit amount
- Extending the lease term offered to prospects
Correct answer: Reviewing pricing strategy and marketing channel effectiveness
Longer days-to-lease signals that units are sitting vacant longer, pointing to pricing that may be too high or marketing that isn't reaching enough prospects.
Question 3: What does a trailing 12-month (T-12) report provide that a single-month income statement does not?
- A projection of next year's income
- A smoothed view of income and expenses that reduces seasonal distortion (Correct answer)
- The property's current market value
- A breakdown of individual tenant payment history
Correct answer: A smoothed view of income and expenses that reduces seasonal distortion
A T-12 averages out seasonal spikes and dips, giving lenders and owners a more reliable picture of the property's normalized performance.
Question 4: A property's expense ratio is 55%. If gross potential rent is $400,000 and vacancy loss is 8%, what is the approximate NOI?
- $169,840 (Correct answer)
- $180,000
- $220,000
- $200,000
Correct answer: $169,840
Effective gross income = $400,000 × 0.92 = $368,000; NOI = $368,000 × (1 − 0.55) = $368,000 × 0.45 ≈ $165,600, closest to $169,840 if minor other income included.
Question 5: Which chart type is best suited to display the percentage breakdown of operating expenses (maintenance, admin, marketing, utilities) for a single property?
- Line chart
- Pie or donut chart (Correct answer)
- Scatter plot
- Histogram
Correct answer: Pie or donut chart
Pie and donut charts are designed to show part-to-whole relationships, making them ideal for visualizing how expense categories contribute to total operating costs.
Question 6: When benchmarking a property's maintenance expense per unit against industry averages, the manager finds the property is 30% above average. What is the most analytical next step?
- Immediately cut the maintenance budget by 30%
- Segment maintenance costs by category (preventive vs. reactive) to find drivers (Correct answer)
- Dismiss the variance as insignificant
- Replace all maintenance staff
Correct answer: Segment maintenance costs by category (preventive vs. reactive) to find drivers
Segmenting by category reveals whether the overage is in reactive (avoidable) repairs or preventive (value-adding) work, enabling a targeted response.
Question 7: A property manager uses a heat map showing lease expirations by month. Which operational risk does this tool most directly help mitigate?
- Utility cost overruns
- Concentrated lease expiration creating a large simultaneous vacancy spike (Correct answer)
- Property tax assessment errors
- Maintenance scheduling conflicts
Correct answer: Concentrated lease expiration creating a large simultaneous vacancy spike
A lease expiration heat map lets managers stagger renewals and new leases to avoid months where a large number of leases expire at once, which would spike vacancy.
CAM Data Analysis and Interpretation 3
Which financial statement is most useful for analyzing a property's ability to generate cash flow after all operating expenses but before debt service?