BUS-REAL58-04 · Lesson 7 · 9 clock hours · theory
Reconciliation, Report Writing, and Credential Exam Review
Objective. Students integrate the three value indications from their subject property analyses into a final reconciled opinion, draft a reconciliation narrative meeting professional standards, and correctly answer valuation questions drawn from the state licensing exam and IREM CPM exam competency areas.
⚠ Pending professional review
This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.
VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.
Bringing It All Together: Reconciliation, Report Writing, and Exam Readiness
By the time you reach this lesson, you have produced three separate value indications for your subject property: one from the sales comparison approach, one from the cost approach, and one from the income approach. Each number was produced by a different method and rests on different data. Reconciliation is the professional process of weighing those three indications and arriving at a single, defensible final opinion of value. It is not averaging. It is a reasoned judgment.
What Reconciliation Is—and Is Not
A common mistake is to add the three approach results and divide by three. That arithmetic gives every approach equal weight regardless of how reliable each one is for the property type at hand. Professional reconciliation does not work that way.
Instead, you ask three questions about each approach:
1. How much quality data supported this approach? An income approach built on three years of certified rent rolls is more credible than one built on a single month's estimate.
2. How appropriate is this approach for the property type? The income approach is the primary indicator for income-producing properties such as apartment buildings. The sales comparison approach typically anchors single-family residential conclusions. The cost approach gains weight when the improvements are new or highly specialized and few comparable sales exist.
3. How narrow is the range of value produced within the approach? A sales comparison grid that adjusts to a tight range gives you more confidence than one with a wide spread.
After answering those questions, you assign relative weight—explicitly in words, not necessarily as formal percentages—and state your final opinion. Your final opinion may fall at, near, or between the individual indications, but you must explain why.
Writing a Reconciliation Narrative
Professional standards require that the reconciliation be stated clearly in the report. A strong reconciliation paragraph does four things:
- States each value indication and the approach that produced it.
- Explains which approach is given the most weight and why, referencing the property type, data quality, and market behavior.
- Acknowledges the other approaches and notes any limitations that reduce their weight.
- States the final opinion of value as a specific dollar amount (or a range if circumstances justify it) with the effective date.
Avoid vague language such as "all three approaches were considered." Explain the reasoning. An unsupported conclusion is a professional deficiency and can expose a licensee to liability.
Assembling the Summary Report Package
A complete summary report ties all your work into a single coherent document. At minimum it contains:
- Cover page — property address, effective date, client name, preparer name.
- Table of contents — page numbers matching the sections below.
- Subject photograph — taken by you, dated, labeled.
- Neighborhood description — boundaries, land use trends, employment base, market conditions.
- Highest-and-best-use analysis — four tests: legally permissible, physically possible, financially feasible, maximally productive. State the conclusion for the site as if vacant and as improved.
- Sales comparison approach section — subject data, comparable grid, adjustments, indication.
- Cost approach section — site value, reproduction or replacement cost, depreciation estimate, indication.
- Income approach section — rent schedule, vacancy allowance, operating expenses, net operating income, capitalization rate, indication.
- Reconciliation and final opinion — the narrative described above.
Consistency matters. Check that the property description on page one matches the description in every approach section. Dates, square footage, and unit counts must be identical throughout.
Professional and Ethical Boundaries
As you prepare for a state real estate salesperson license, remember that practicing real estate without the license is illegal. A license is not simply a credential—it is the legal permission granted by your state licensing board to represent clients in real estate transactions. Similarly, representing yourself as holding the IREM CPM designation before earning it violates the Institute of Real Estate Management's membership standards.
In fieldwork settings, personal safety applies even in an office-adjacent role: when inspecting properties, never enter spaces with unknown utility or structural hazards without proper authorization, adequate lighting, and, where appropriate, personal protective equipment. Always inform someone of your inspection schedule.
Credential Exam Focus Areas
Both the state salesperson licensing exam and the IREM CPM Body of Knowledge test valuation concepts. For the licensing exam, expect questions on appraisal principles (substitution, anticipation, conformity), the three approaches to value, market analysis, and highest-and-best-use. For IREM CPM competencies, focus on financial analysis skills: calculating net operating income, interpreting cap rates, and reading a property operating statement.
Practice under timed conditions. A score of 75 percent or higher on the practice set is the checkpoint for this lesson. If you fall below that threshold, complete the remediation worksheet before the course assessment—identify the specific topic area for each missed question and study only those areas rather than reviewing everything at random. A focused study plan is more efficient than broad re-reading.
Key terms10
ReconciliationThe analytical process of reviewing the value indications from each approach to value, weighing their relative reliability for the subject property type and data quality, and arriving at a single final opinion of value.
Final Opinion of ValueThe appraiser's or analyst's concluded dollar amount (or range) representing the defined value for the subject property as of a specific effective date, supported by the reconciliation narrative.
Highest-and-Best-UseThe reasonably probable use of a property that is legally permissible, physically possible, financially feasible, and maximally productive, forming the foundation for all three valuation approaches.
Net Operating Income (NOI)Effective gross income minus total operating expenses, before debt service and income taxes; the primary income figure used in direct capitalization.
Capitalization RateThe ratio of a property's net operating income to its market value or sale price, used to convert an income stream into a value indication in the income approach.
Sales Comparison ApproachA valuation method that estimates value by comparing the subject property to recent sales of similar properties and making adjustments for differences.
Cost ApproachA valuation method that estimates value as the land value plus the depreciated cost to reproduce or replace the improvements.
Effective Gross IncomePotential gross income minus vacancy and collection losses, representing the realistic income a property is expected to generate.
Principle of SubstitutionThe appraisal principle that a prudent buyer will pay no more for a property than the cost of acquiring an equally desirable substitute; it underpins all three approaches to value.
Summary ReportA written valuation report format that presents the data, analysis, and conclusions with enough detail for the client to understand the reasoning, assembled as a single organized document.
Worked examples4
1. A small rental house produced the following value indications: Sales Comparison = $245,000; Cost = $258,000; Income = $238,000. The property is a 30-year-old single-family rental in an active resale market with abundant comparable sales and reliable rent data. Weight the approaches and state a final opinion.
- Step 1 — Evaluate the sales comparison approach. The market is active, comparable sales are plentiful, and adjustments were modest. This approach directly reflects what buyers are paying. Assign primary (greatest) weight.
- Step 2 — Evaluate the income approach. The property is investor-owned and rent data is verified. The income approach is relevant. Assign secondary weight.
- Step 3 — Evaluate the cost approach. The improvements are 30 years old; estimating accrued depreciation introduces significant subjectivity. Assign least weight.
- Step 4 — Frame the final opinion. The sales comparison indication of $245,000 is best supported. The income approach at $238,000 is consistent and confirms the lower end of the range. The cost approach at $258,000 is least reliable given the age of the improvements. The final opinion of value is $245,000 as of the effective date.
Answer: Final opinion of value: $245,000, with primary weight on the sales comparison approach.
2. A 12-unit apartment building has a monthly gross scheduled rent of $1,200 per unit. Vacancy and collection loss is estimated at 5%. Annual operating expenses total $48,000. What is the annual NOI?
- Step 1 — Calculate annual potential gross income: 12 units × $1,200/month × 12 months = $172,800.
- Step 2 — Subtract vacancy and collection loss: $172,800 × 5% = $8,640; $172,800 − $8,640 = $164,160 effective gross income.
- Step 3 — Subtract annual operating expenses: $164,160 − $48,000 = $116,160.
- Step 4 — State the result: Annual NOI = $116,160.
Answer: Annual Net Operating Income = $116,160.
3. Using the NOI from the example above ($116,160) and a market capitalization rate of 7.5%, what is the income approach indication of value?
- Step 1 — Recall the direct capitalization formula: Value = NOI ÷ Cap Rate.
- Step 2 — Substitute the known values: Value = $116,160 ÷ 0.075.
- Step 3 — Perform the division: $116,160 ÷ 0.075 = $1,548,800.
- Step 4 — State the income approach indication: $1,548,800 (rounded as appropriate for the assignment).
Answer: Income approach indication of value = $1,548,800.
4. A comparable sale closed at $310,000. The comparable has a two-car garage worth $8,000 that the subject lacks, and the comparable's location is inferior to the subject by $5,000. What is the adjusted sale price?
- Step 1 — Identify the direction of each adjustment. You adjust the comparable to match the subject. The comparable has a feature the subject lacks (garage), so subtract $8,000. The comparable's location is inferior to the subject, so add $5,000.
- Step 2 — Apply the adjustments: $310,000 − $8,000 + $5,000 = $307,000.
- Step 3 — State the adjusted sale price: $307,000.
Answer: Adjusted sale price of the comparable = $307,000.
In class: Reconciliation workshop: each student brings their three value indications (sales comparison, cost, income) from prior lessons; in small groups, students apply a weighted-reconciliation process, discuss which approach is most reliable for their property type and why, and write a final reconciliation paragraph; groups present conclusions to the class for critique. · Report assembly exercise: students assemble all completed forms, grids, photographs, and narratives from Lessons 3 through 6 into a single summary report package with a cover page, table of contents, subject photograph, neighborhood description, highest-and-best-use analysis statement, and the three approach sections; instructor walks through each section against a report-quality rubric. · Credential exam drill: instructor administers a timed 30-question practice set drawn from state licensing exam valuation topic areas (appraisal principles, approaches to value, market analysis) and from IREM CPM Body of Knowledge financial-analysis competencies; students self-score, identify weak areas, and write a one-paragraph study plan for the items they missed.
Materials: Assembled report packets from prior lessons; report-quality rubric; 30-question practice exam packet (state licensing and IREM CPM mapped items); answer key; pencils; timer
Check: Practice exam score reviewed: students must score 75% or higher; reconciliation narrative graded against rubric for logical support, correct weighting rationale, and absence of unsupported conclusions; students scoring below 75% on practice exam complete a remediation worksheet before the course assessment.
Practice check8
Answer each question, then check it. Nothing is recorded; this is your own practice.
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.