ahacker-1/cre-agent-skills / claude-code-plugins/cre-lender-credit
cre-lender-credit
VerifiedCRE Lender/Credit analysis suite - 8 specialist skills for U.S. CRE loan screening and sizing, sponsor and appraisal review, credit memo writing, annual risk rating, covenant and watchlist monitoring, problem loans, and portfolio stress testing.
| File | Kind | Size |
|---|---|---|
| README.md | markdown | 699 B |
| SKILL.md | skill md | 6.0 KB |
| knowledge/cre-concentration-and-stress-testing.md | markdown | 11.9 KB |
| knowledge/credit-memo-and-appraisal-review-standards.md | markdown | 16.0 KB |
| knowledge/lender-credit-policy-benchmarks.md | markdown | 15.1 KB |
| knowledge/regulatory-risk-rating-and-classification.md | markdown | 18.6 KB |
| knowledge/risk-scoring.md | markdown | 43.7 KB |
| knowledge/underwriting-calc.md | markdown | 47.7 KB |
| skills/annual-loan-review-and-risk-rating.md | markdown | 23.3 KB |
| skills/appraisal-and-valuation-reviewer.md | markdown | 23.6 KB |
| skills/covenant-compliance-and-watchlist-monitor.md | markdown | 19.6 KB |
| skills/cre-portfolio-concentration-and-stress-tester.md | markdown | 23.4 KB |
| skills/credit-memo-writer.md | markdown | 19.1 KB |
| skills/loan-request-screening-and-sizing.md | markdown | 19.9 KB |
| skills/problem-loan-and-modification-analyst.md | markdown | 31.1 KB |
| skills/sponsor-and-guarantor-analyst.md | markdown | 18.9 KB |
skills/appraisal-and-valuation-reviewer.md
View on GitHub---
license: Apache-2.0
metadata:
author: "Avi Hacker, J.D."
organization: "The AI Consulting Network"
homepage: https://www.theaiconsultingnetwork.com
source: https://github.com/ahacker-1/cre-agent-skills
copyright: "Copyright 2026 Avi Hacker, J.D. / The AI Consulting Network"
---
# Appraisal and Valuation Reviewer
Review a commercial real estate appraisal or evaluation for regulatory compliance and analytical reasonableness, reconcile it to the lender's underwriting, and issue an accept, condition, or reject decision with required revisions.
---
## When to Use This Skill
Use this skill on the lender side of a U.S. commercial real estate transaction, before the final credit decision, when an appraisal or evaluation has to be accepted, conditioned, returned to the appraiser, or replaced. It fits new originations, renewals and modifications, annual reviews, watchlist and workout re-valuations, purchased loans and participations, and any file where an examiner or loan review will ask how the value was tested. The request and value premise usually arrive from [Loan Request Screening and Sizing](skills/lender-credit/loan-request-screening-and-sizing.md); the accepted value and conditions feed [Credit Memo Writer](skills/lender-credit/credit-memo-writer.md) and, on existing credits, [Annual Loan Review and Risk Rating](skills/lender-credit/annual-loan-review-and-risk-rating.md).
This is educational decision support, not legal, tax, investment, accounting, appraisal, or financing advice. Your institution's loan policy, its primary regulator, and its counsel control. A reviewer who is not a state certified or licensed appraiser is performing a compliance and reasonableness review, not a USPAP appraisal review.
---
## What You'll Need to Provide
- The appraisal or evaluation, including addenda, exhibits, and the certification page
- The engagement letter, the appraiser's license or certification, and evidence of who ordered the work
- Transaction value (loan amount), facility type, purpose, and the phase being funded
- The lender's underwriting: in-place and stabilized NOI, rent roll, operating statements, cap rate, vacancy, absorption, TI and LC, capital budget, and the sizing tests
- Prior appraisals or evaluations on the property, and the date and value of each
- Any third-party reports the appraisal relies on: environmental, engineering, survey, feasibility or market study, title, zoning
- The institution's valuation policy: reviewer qualification tiers, review depth criteria, reconciliation variance triggers, and revaluation intervals
---
## Mission
Establish that the right valuation product was obtained by the right party, that it meets the regulatory minimums, that its methods and assumptions are supportable, and that the value the credit memo relies on is the right premise for the credit decision. Produce a documented review conclusion, a value acceptance or rejection, and a specific revision list.
---
## Strategy
### Step 1: Set the Regulatory Gate
Before reading a single comparable, confirm the correct product was ordered.
- Transaction value is the amount of the loan or extension of credit, not the property value.
- An evaluation may substitute for an appraisal only where the loan amount is $500,000 or less; the transaction is a business loan of $1 million or less and income from the sale or rental of real estate is not the primary repayment source; the transaction is an existing extension of credit with no new money beyond reasonable closing costs; or it is an existing extension of credit with new money but no obvious and material change in market conditions or the physical property that would threaten collateral adequacy.
- A state certified appraiser is required at $1 million or more, and for nonresidential transactions of $500,000 or more including one- to four-family construction.
- The abundance of caution exemption applies only where the credit is well supported by cash flow or other collateral, tested in [Sponsor and Guarantor Analyst](skills/lender-credit/sponsor-and-guarantor-analyst.md), and the file documents that knowing the real estate's market value is unnecessary to the decision.
- A conditional approval may precede the valuation; the final credit decision or action must follow receipt, review, and acceptance of it.
- Record the product obtained, the product required, and any gap. A gap here ends the review; nothing downstream cures it.
### Step 2: Test Independence, Engagement, and Reviewer Standing
Check the file facts, not the narrative.
- The lender or its agent engaged the appraiser directly, in writing, before work began. The engagement letter names the client, the intended use, and the intended users, and it is in the credit file.
- No prohibited communication occurred: no predetermined, expected, or qualifying value, loan amount, or target LTV; no minimum value as a condition of ordering; no compensation tied to loan consummation; no threat, express or implied, to future engagement over a value. Asking the appraiser to consider added information, support a basis, or correct a factual error is permitted and should be documented.
- A borrower-ordered or borrower-provided appraisal is not usable. A borrower may say one exists; the lender requests it directly from the institution that commissioned it.
- A transferred appraisal requires all five conditions: the other financial services institution selected and engaged the appraiser; the appraiser had no direct or indirect interest in the property or the parties; the appraisal remains valid; it conforms to the appraisal regulation; and it is appropriate for this transaction. Apply at least the same review depth used on your own work, and refuse anything readdressed or altered to conceal the original client.
- A staff appraiser is acceptable if independent of loan production, uninvolved in approving the transaction, and free of any interest in the property; credit unions apply the parallel rule for staff and fee appraisers. The reviewer is independent of the transaction, insulated from loan production, and competent for this property type, market, and complexity. Where absolute separation is not achievable, the safeguard is documented and any reviewing loan officer abstains from approving or voting on the loan. Set review depth by risk: expand for large-dollar credits, complex or specialized collateral, ADC, going concern assets, and out-of-market properties.
### Step 3: Check Report Content Against the Minimum Standards
Confirm the six minimum appraisal standards are met and that the report supports a credit decision.
- Conforms to USPAP, with the certification and required disclosures: prior services on the property within three years, whether the property was inspected, and whether anyone provided significant assistance.
- Written, with sufficient information and analysis to support the decision. A report option restricted to a single client and intended user is generally not appropriate for a federally related transaction; reserve that format for portfolio monitoring.
- Subject to appropriate review for USPAP compliance, documented, and analyzes and reports appropriate deductions and discounts where required (see Step 6).
- Uses the regulatory market value definition. Going concern value, value in use, and special value to a specific user cannot serve as market value; they may appear as separate, clearly identified opinions. Where the report produces an enterprise value, confirm the allocation among real property, personal property, and intangibles. FF&E counts as other acceptable collateral only if perfected, quantifiable, and appropriately discounted; business enterprise value never does.
- Performed by a state licensed or certified appraiser, credential verified and current.
- Includes the legal description, an accurate property description with the source for areas and dimensions, adequate photos, a reported as-is value, analysis of any current agreement of sale, option, or listing, and reported sales of the property in the prior three years.
Then run the assumption test. List every extraordinary assumption and hypothetical condition and ask three questions of each: is it disclosed, is it logical and supportable with market data, and is it consistent with the lender's intended collateral position? An extraordinary assumption resting on a third-party report requires that report in the file and current. A hypothetical condition that values the property contrary to a known fact needs an explicit credit rationale or it is a finding.
### Step 4: Test the Approaches and the Comparables
- Every applicable and necessary approach is present, omissions are explained, and the reconciliation reasons to a conclusion rather than averaging.
- Cost approach: useful for construction draw review, harder to apply as a property ages, and usually inappropriate in a troubled market outside special purpose facilities because new construction cost normally exceeds the market value of comparable existing property. If cost exceeds or closely approximates value, the project is not economically feasible, and the review has to ask what the borrower's and the lender's motivation to do the deal actually is.
- Sales comparison: comparables must be genuinely comparable in market location, financing terms, property condition and use, timing, and transaction costs, with adjustments discussed and supported rather than tabled without explanation, and units of comparison (per square foot, per unit, per key) consistent with the comparables cited. Commercial sales data is often too thin to carry the conclusion alone.
- Income approach: direct capitalization suits a stable market with no unusual rent or occupancy pattern; a discounted cash flow with an explicit stabilization period and a discounted reversion is the better instrument for a troubled or lease-up property.
- The capitalization or discount rate is supported and reasonable for the class, property type, and market. Where market activity is dominated by a few transactions or liquidation sales, the high rates implied by those sales should not be used; the rate should reflect conditions that are neither highly speculative nor depressed.
### Step 5: Test Income, Rent, Vacancy, and Absorption
Work each operating assumption and mark it supported, thin, or unsupported.
- Current revenues, expenses, and vacancy analyzed against actuals; outstanding lease terms and NOI compared with budgets
- Discount and capitalization rate analysis present, not a bare assertion
- Tenant strength, rollover risk, anticipated rents, renewal probability, and marketing and re-leasing costs including TI and leasing commissions
- Current and projected vacancy and absorption rates, with effective rents or prices net of concessions rather than face rents
- Property management expertise, and the effect of planned or new construction and renovation entering the market area
- Any significant departure from the subject's past lease rates, expenses, or absorption, explained
- Whether the site and improvements suit the market and can sustain historical cash flow, the subject's position in its submarket, future supply and demand, and the cost of anticipated replacements or improvements
- Flag the assumptions that carry the value: usually market rent, stabilized vacancy, the absorption schedule, the expense load, and the exit or terminal rate
### Step 6: Test the Value Premise, Deductions, and Discounts
- Identify every value reported and its effective date: as-is, prospective as complete, prospective as stabilized, and any liquidation or disposition value. Prospective values must rest on current and reasonably expected market conditions and must state the point of reference for market conditions and time frame. Confirm the as-is value is understood and that the prospective value used matches the credit decision and the phase being funded.
- Deductions and discounts are mandatory for proposed construction or renovation, partially leased buildings, non-market lease terms, and tract developments with unsold units. Their absence in any of those cases is a regulatory finding.
- Partially leased or proposed rental property: leasing commissions, rent loss, tenant improvements, and entrepreneurial profit where not embedded in the discount rate, plus absorption of the unleased space.
- Non-market leases: the ownership interest appraised is stated and the leases are discussed. Where the leased fee is appraised and contract rent is below market on long-term leases to a highly rated tenant, the leased fee value is below fee simple, and the leased fee value is the one to use.
- Raw land: valued in current condition and existing zoning; a developmental approach must carry deductions and discounts for feasibility, permitting, engineering, holding, marketing, and entrepreneurial profit, reconciled against sales comparison where both are supportable.
- For-sale and tract product (five or more units in a single development): holding costs, marketing costs, and entrepreneurial profit across the absorption period, with prices and absorption supported by anticipated demand at the time units are exposed for sale. The sum of retail sales is not market value. Unit-level appraisals may be used only where an independently obtained feasibility study or market analysis shows all units can be built and sold within 12 months, and in that case LTV value is the lower of retail sellout or actual development and construction cost. Presold units require a binding contract, a substantial nonrefundable deposit, and written prequalification or a financing commitment.
### Step 7: Reconcile to Underwriting, Then Conclude
- Compare line by line: NOI, market rent, vacancy, expense ratio, capital and reserve load, TI and LC, absorption period, capitalization rate, discount rate, exit rate, and value, using [Underwriting Calculations](knowledge/underwriting-calc.md) for the mechanics. Where the lender underwrites tighter, keep the lender's number; where the appraisal is tighter, ask why the credit memo is more optimistic than the independent valuation.
- Apply the institution's own variance trigger and name it in the output; no agency source publishes a numeric tolerance. Document every rate difference but escalate only a material, supported one, since examiners generally are not expected to challenge cap or discount rate assumptions that differ only marginally from norms for the collateral.
- Confirm the value premise driving LTV matches the asset and the strategy, and check the resulting LTV against policy and the supervisory limits summarized in [Credit Memo and Appraisal Review Standards](knowledge/credit-memo-and-appraisal-review-standards.md).
- Test validity if an existing valuation is being reused: passage of time, local market volatility, financing terms and availability, natural disasters, over or under supply of competing space, improvements or deferred maintenance at the subject or competitors, changed assumptions such as capitalization rates and lease terms, zoning, materials or technology changes, and environmental contamination. An arbitrary interval such as 12 months is not the deciding criterion, and the conclusion has to be documented. Deterioration flagged by [Covenant Compliance and Watchlist Monitor](skills/lender-credit/covenant-compliance-and-watchlist-monitor.md), or a workout under [Problem Loan and Modification Analyst](skills/lender-credit/problem-loan-and-modification-analyst.md), warrants a new or updated valuation on material change in project performance, in the geographic market or property type, in variances from original appraisal assumptions, or in project specifications.
- Conclude. The reviewer cannot change the value conclusion. The choices are accept, accept with conditions, return to the appraiser with specific questions, or order a new compliant valuation; where a deficiency cannot be resolved with the appraiser, a compliant appraisal or evaluation must be obtained before the credit decision, and a second opinion of value requires a USPAP-compliant appraisal or appraisal review by a state certified or licensed appraiser. Accepted values and LTVs roll up through [CRE Portfolio Concentration and Stress Tester](skills/lender-credit/cre-portfolio-concentration-and-stress-tester.md).
---
## Output Format
```markdown
# Appraisal and Valuation Review
## Property / Borrower:
## Appraiser / Firm / Credential:
## Report Date / Effective Date(s):
## Reviewer / Review Date / Review Depth: Standard | Expanded
## Verdict: ACCEPT | ACCEPT WITH CONDITIONS | RETURN TO APPRAISER | REJECT - NEW VALUATION REQUIRED
## Value Relied On: $______ (as-is | as-complete | as-stabilized), effective __________
### Regulatory Gate and Report Content
| Test | Finding | Pass / Fail | Source in File |
|---|---|---|---|
| Product required vs obtained; credential level | | | |
| Direct engagement, engagement letter, prohibited communication | | | |
| Transferred or broker-ordered conditions; reviewer independence | | | |
| Report option adequacy and market value definition used | | | |
| Description, photos, sale/option/listing, 3-year sales history | | | |
| Extraordinary assumptions, hypothetical conditions, going concern allocation | | | |
### Approaches and Comparables
| Approach | Used / Omitted | Rationale Given | Reviewer Assessment |
|---|---|---|---|
| Cost | | | |
| Sales comparison | | | |
| Income (direct cap / DCF) | | | |
| Reconciliation | | | |
### Reconciliation to Underwriting
| Assumption | Appraisal | Lender Underwriting | Variance | Within Policy Trigger? | Resolution |
|---|---|---|---|---|---|
| Market rent | | | | | |
| Stabilized vacancy | | | | | |
| Operating expenses / NOI | | | | | |
| TI / LC and absorption | | | | | |
| Cap rate / discount / exit rate | | | | | |
| Value | | | | | |
### Deductions, Discounts, and Validity
- Deduction trigger present / items applied / items missing:
- Validity factors considered and conclusion (reused valuations only):
### Review Findings
| # | Finding | Severity | Regulatory or Analytical | Required Action | Owner | Due |
|---|---|---|---|---|---|---|
### Value Conclusion Acceptance
- Accepted value and premise; value NOT accepted and why:
- Conditions precedent to credit decision:
### Confidence Level
HIGH | MEDIUM | LOW
```
---
## Quality Checks
- The product test ran on transaction value, not on property value, and engagement, independence, and credential facts are cited to documents in the file
- Every value reported is listed with its effective date, and the one driving LTV is named
- Every extraordinary assumption and hypothetical condition is listed and individually assessed
- Omitted approaches have a stated rationale, the reconciliation reasons rather than averages, and comparable adjustments and units of comparison are supported
- Deductions and discounts were tested against all four mandatory triggers
- The reconciliation table shows the lender's number beside the appraisal's for every value-driving assumption, against a named institution variance trigger
- The verdict is one of the four permitted conclusions, and no line in the review restates or adjusts the appraiser's value
---
## Red Flags & Dealbreakers
- The borrower ordered, paid for, provided, or selected the appraiser, or picked the appraiser off the lender's approved list; or anyone conveyed a target value, loan amount, or LTV to the appraiser, or tied engagement or payment to the value reached
- A transferred appraisal was readdressed or altered to conceal the original client, or the file cannot show the other institution engaged the appraiser
- An evaluation is used above the threshold, or an evaluation rests on unsupported assumptions such as average condition or a future zoning change
- A restricted-format report supports the credit decision, or a going concern or business enterprise value is carried into the LTV without allocation to real property
- A partially leased or proposed property is valued with no deductions and discounts, or a for-sale project's retail sellout is presented as market value
- The as-stabilized value drives LTV on an asset with no funded leasing capital, no signed leases, and no stabilization plan, or the premise was chosen to fit a desired LTV
- Absorption or market rent departs materially from the subject's own history and competing supply with no explanation, or the capitalization or discount rate is asserted with no analysis or drawn from liquidation-dominated transactions
- Cost exceeds or approximates value and no one asks why the deal is being done, or an appraisal is called valid solely because it is under 12 months old
- The reviewer changed, adjusted, or overrode the value conclusion in the review memo rather than ordering compliant work
- The credit decision was finalized before the valuation was received, reviewed, and accepted
---
## When Data is Missing
- No engagement letter: treat engagement and independence as unverified and make the letter a condition; do not infer it from the report's client line. With no credential evidence, verify the license or certification with the state regulator before accepting
- Missing addenda, exhibits, or the certification page: the report is incomplete; request the full document rather than reviewing an extract. A third-party report behind an extraordinary assumption that is absent or stale leaves that assumption unsupported
- No rent roll, operating statements, or lease abstracts to test against: mark the income assumptions unverified and cap the review at MEDIUM confidence
- No feasibility or market study on an ADC or for-sale project: absorption is unsupported and the 12-month unit-appraisal exception is unavailable
- No prior appraisal for a reused valuation: run the validity factor test on current evidence and say the trend could not be tested
- No written institution variance trigger: present the reconciliation without a policy threshold and route the variance to the credit officer
---
## Confidence Scoring
| Level | Criteria |
|---|---|
| HIGH | Complete report with addenda, engagement letter, and credential evidence in file; rent roll, operating statements, and leases available to test income assumptions; all value premises and their effective dates identified; deductions and discounts tested; institution variance trigger applied |
| MEDIUM | Complete report but one supporting input missing, such as the feasibility study, a third-party report behind an extraordinary assumption, or the operating statements needed to test expenses; conclusion holds but one or more assumptions are unverified |
| LOW | Extract, summary, or transmittal letter only; engagement or independence unverified; value premise ambiguous; or the underwriting data needed for reconciliation was not provided |
---
## Related Knowledge Bases
- [Credit Memo and Appraisal Review Standards](knowledge/credit-memo-and-appraisal-review-standards.md)
- [Underwriting Calculations](knowledge/underwriting-calc.md)
## Research Basis
- [Appraisal and Valuation Reviewer Research](research/lender-credit/appraisal-and-valuation-reviewer-research.md)
---
## Attribution
Built and maintained by [The AI Consulting Network](https://www.theaiconsultingnetwork.com/?utm_source=github&utm_medium=skill-file&utm_campaign=cre-agent-skills), the commercial real estate AI consulting practice of Avi Hacker, J.D., and part of [CRE Agent Skills](https://github.com/ahacker-1/cre-agent-skills), an open-source library of AI skills for commercial real estate.
If this skill saved you time and you want systems like it built inside your firm, [reach out](https://www.theaiconsultingnetwork.com/contact?utm_source=github&utm_medium=skill-file&utm_campaign=cre-agent-skills). We would love to work with you.
Copyright 2026 Avi Hacker, J.D. / The AI Consulting Network. Licensed under the [Apache License 2.0](https://github.com/ahacker-1/cre-agent-skills/blob/main/LICENSE). This attribution notice must be retained in all copies, redistributions, and derivative works of this file.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |