Template Use Cases

Customer Type

Category

Template

Use Case

Lenders

Analyze

CRE Appraisal Comparison

Use this template to compare up to four appraisal reports or scenarios side-by-side. It’s designed to help lenders quickly review and evaluate key differences in valuation assumptions, report dates, and property-level details — all in one centralized view.

When to Use:

· When reviewing multiple appraisals submitted for the same property but under different scenarios (e.g., As Is vs. As Stabilized)

· When comparing different properties under consideration for the same loan pool or deal

· To validate consistency across reports from different appraisers or firms

· When preparing a credit memo or internal review, needing fast reference to key metrics like GBA, land area, value conclusion, and effective date

Key Features:

· Select up to four reports using the LightBox insert tool

· Automatically displays:

o Appraisal Report details (date, firm, appraiser, intended users)

o Subject Property overview (address, property name, location)

o Valuation Conclusion by scenario (cost, sales, and income approaches)

· Ideal for loan officers, credit analysts, and reviewers needing clarity at-a-glance

Lenders

Analyze

CRE Benchmark Comparison

Use this template to benchmark a subject property against a cohort of comparable appraisals. It leverages extracted data to provide lenders with insight into market trends and positioning across key valuation and performance metrics. Designed for trend analysis and benchmarking, it helps uncover how a property stacks up relative to peers in the same geography and property type.

When to Use:

· When evaluating whether a subject appraisal’s assumptions and conclusions align with other recent report subjects

· To identify outliers in valuation drivers such as Value per SF, Cap Rate, or NOI margins

· During credit committee or internal review, when context against market ranges is needed

· To support portfolio and risk analysis with clear visuals of how subject properties compare to local benchmarks

Key Features:

· Select report year, property type, and appraisal scenario filters

· Subject property displayed on interactive property map with comp cohort

· Benchmark charts automatically generated for:

o Value/Net SF

o Effective Gross Income (EGI)/Net SF

o Operating Expenses (OPEX)/Net SF

o OPEX/EGI Ratio

o Net Operating Income (NOI)/Net SF

o Cap Rate

o Discount Rate (DCF)

· Visual min–max ranges from comps with subject overlaid for instant comparison

· Tabular comp list with report details, effective date, and core financial metrics

Best For:
Credit analysts, loan officers, and reviewers seeking to validate appraisal assumptions against peer benchmarks and market trends.

Lenders

Analyze

CRE Collateral Map

Use this template to visually map properties the bank has evaluated for lending based on extracted location data (latitude/longitude). The template helps lenders and reviewers quickly see geographic distribution, concentration risks, and regional coverage across portfolios.

When to Use:

· To visualize properties by state or property type across a loan portfolio

· When preparing materials for committee review, risk assessment, or client meetings

· To assess collateral dispersion, geographic overlap, or clustering

· When evaluating exposure by region or property category

Key Features:

· Interactive Bing Maps integration

· Distinct worksheets for:

o State filtered view

o Property Type filtered view

· Color-coded map pins for quick pattern recognition

Important Notes:

· Requires property latitude and longitude values to appear on map

· Not compatible with Mac OS (Bing Maps is Windows-only)

Lenders

Analyze

CRE Op Ex Comparison

Use this template to compare operational performance across multiple commercial properties. It’s ideal for reviewing income and expense metrics from appraisal reports — normalized per square foot or per unit.

When to Use:

· When analyzing cash flow strength or expense efficiency across a portfolio

· To compare reported operational metrics from different appraisals side by side

· During underwriting or asset management, when validating assumptions like NOI, cap rate, or expense ratios

· To explore how properties of similar type perform relative to one another

Key Features:

· Supports up to 10 comparison documents

· Select Appraisal Scenario for each comp

· Choose unit of comparison: Per SF or Per Unit

· Displays side-by-side comparison of:

o Income (rental, other, EGI)

o Expenses (total op ex, expense ratio)

o Net Operating Income & Valuation metrics (cap rate, income approach value)

· Includes core property info like address, report date, and GBA

Best For:

· Credit analysts, lending officers, or portfolio managers

· Any scenario where operational efficiency is key to value or risk assessment

Lenders

Analyze

CRE Portfolio Concentration

Use this template to visualize geographic and property-type concentration across a commercial real estate portfolio. Designed to support risk review and exposure management, this tool provides an at-a-glance look at where the most value is concentrated.

When to Use:

· During portfolio review or asset quality monitoring

· To highlight overexposure in certain counties or property types

· When preparing credit committee materials or internal strategy decks

· For evaluating diversification, especially during stress testing or regulatory audits

Key Features:

· Displays Appraised Value by County (heatmap)

· Breaks down Appraised Value by Property Type (bar/stacked chart)

· Calculates total appraised portfolio value

· Easy-to-read visuals designed for presentations and decision-making

Important Notes:

· Requires Excel Desktop App — charts are not supported in Excel for Web

· Must be used with a full set of extracted appraisal documents (including value and property type)

Appraisers

Digitize

LightBox Valuation Data Capture

Use this template to capture and structure key appraisal data for seamless integration with the LightBox PARCEL platform. It supports both manual entry and automated linking from other Excel-based appraisal models.

When to Use:

· Before uploading data to the PARCEL WF or PARCEL MT platforms

Key Features:

· Built-in field structure for:

o Platform, currency, and valuation premise

o Property identity and location (address, lat/long, county/state)

o Scenario details and report metadata

· LightBox JSON icon triggers export into a PARCEL-ready .json file

· Supports formulas, lookups, or manual entry from your primary Excel appraisal model

Best For:

· Appraisers or admin teams preparing jobs for digital submission

Lenders

Summarize

All Available Fields Report

Use this template to review all data extracted from a single appraisal report, including subject property information, site details, improvements, and up to five valuation conclusions. Designed to give a full view into report content for credit review, compliance, and internal documentation.

When to Use:

· When performing loan file review or pre-funding due diligence

· To verify multiple value conclusions in one appraisal (e.g., As Is, As Stabilized)

· When preparing internal materials for credit committee or regulatory documentation

Key Features:

· Displays full report metadata, job/property context, and valuation detail

· Supports up to 5 valuation scenarios side by side

· Includes:

o Value conclusions (by approach and scenario)

o Subject property info, site data, and building characteristics

o Key report fields like dates, premise type, and currency

Best For:

· Lenders, underwriters, and credit analysts

· Teams reviewing appraisal data for quality, consistency, or risk

Lenders

Analyze

CRE Appraisal Review Memo

Use this template to complete a formal review memo for a single appraisal report. It combines key extracted data with structured review checklists, allowing credit analysts and reviewers to efficiently evaluate report quality, completeness, and compliance.

When to Use:

· During the compliance/technical review phase of the loan process

· To prepare internal documentation summarizing appraisal conclusions

· When reviewers need to validate assumptions or flag missing/incomplete information

· For recordkeeping and audit support where memo documentation is required

Key Features:

· Connects to extracted appraisal report data

· Auto-populates:

o Subject property details

o Appraiser and firm information

· Includes dropdown-driven checklists for review memo

· Space for manual entry and memo finalization

Best For:

· Lenders, reviewers, or technical compliance teams

· Anyone needing to formally document findings from appraisal review in a standardized format

Lenders

Analyze

CRE Appraisal Summary

Use this template to generate a clean, readable summary of key appraisal report content for a single subject property. It’s designed to provide lenders with a concise reference across report & subject details, financials, and valuation conclusions — all in one place.

When to Use:

· During early underwriting review or deal screening

· When preparing internal credit packages or loan files

· To supplement a narrative appraisal review with structured, extracted facts

· When needing a quick appraisal snapshot for committee or risk review

Key Features:

· Structured across sections:

o Report Info

o Subject Info (Location, Site, Improvements)

o Subject Financials

o Valuation Summary

Best For:

· Lending teams, credit officers, and analysts needing a one-page view of an appraisal

· Use as a companion file when reviewing or storing an appraisal report