Available now

CRE Loan Underwriting

Analyze the borrower, guarantor, and property in sequence, measure global debt service, review the appraisal, and present a clear recommendation.

9
Core courses
~12.1 hrs
Total time
7
Case studies
$1,795
or 9 credits with membership

Full Learning Path · per learner

Cover it with a membership →
Path Includes
  • Hands-on exercises throughout
  • Learning checks after every module
  • Quizzes after every course
★ RETAKE ANY COURSE OR QUIZ ★★★★SHOCKPROOFLEARNINGGUARANTEE

Learning Guarantee: retake any course or quiz as many times as you need. How it works

Free · No sign-up required

Not Sure If CRE Loan Underwriting Is Right for You?

Answer 10 questions in about 8 minutes. Get a score, a learning plan, and the courses that close your gaps.

Take the free assessment

What Learners Say

Similar courses offered by other companies have a lot of fluff; Shockproof courses are robust and to the point.
Credit Analyst, Community Bank in New Hampshire
Shockproof's real cases show our team what they need to know to do their jobs better. There's no substitute to get up to speed quickly and be able to handle whatever senior management sends their way.
Chief Credit Officer, Business Bank in Oklahoma
New to commercial credit?

Start with the Learning Paths for New Banking Professionals

Two short Foundations learning paths take a new hire from zero to ready for CRE Loan Underwriting.

  1. 1Accounting & Finance FoundationsLearn to read a business
  2. 2Commercial Lending FundamentalsLearn to think like a lender
  3. 3CRE Loan UnderwritingThis Learning Path
Who this is for

Built for Everyone Who Works on CRE Loans

Credit analysts, underwriters, relationship managers, and portfolio managers who analyze and underwrite commercial real estate loans, as well as loan review, special assets, and credit administration staff who review CRE credit memoranda. The path assumes familiarity with accrual financial statements and their terminology for a commercial real estate operation, including rent rolls, operating statements, and NOI, the fluency the learning paths for new banking professionals build.

What learners will be able to do

By the End of the Core Path

  • Follow the regulator-endorsed borrower, guarantor, and property analytical sequence and identify the three sources of repayment
  • Construct and read borrower cash flow, personal cash flow, and global debt service analysis, including the UCA cash flow statement, and test debt-service capacity
  • Review an appraisal independently and derive net operating income, a capitalization rate, and a value conclusion
  • Size and stress-test a CRE loan against underwriting standards and project forward performance
  • Identify repayment risks, design covenants and documentation that address them, and present a well-supported recommendation in a comprehensive credit memorandum
The path at a glance

Specs and Scope

Format
9-course progressive sequence, self-paced
Core time
About 12.1 hours of content
Case work
6 complete case files: Haddad Gardens Apartments; Cruz Development Partners; Aldergrove Commons Retail Center; Northbrook Office Park; Frostgate Logistics Center; Okafor Precision Components
Method
The regulator-endorsed borrower, guarantor, property sequence with global debt service analysis
Assessment
Free 10-question pre-assessment; hands-on exercises throughout
Credential
Certificate of Excellence, shareable and verifiable
Recommended prep
The learning paths for new banking professionals, including Commercial Real Estate Financial Analysis, or equivalent fluency with CRE operating statements
Topics covered

Core Courses

1

The CRE Analytical Process

The course covers the standard analytical sequence and the three sources of repayment. It assesses the borrower's entity structure and the reliability of its financial reporting. It closes on screening for red flags and on the four essential issues of every credit memorandum.

2

Borrower Cash Flow: Primary Repayment Source

The course covers business drivers and ratio trends, the two necessary conditions for business success, and cash-flow proxies against true cash flow. It builds the UCA cash flow statement, computes debt service coverage and identifies borrowing causes. The analysis is anchored where it applies with full force in CRE lending. On the owner-occupied credit, the occupying business (not the property) is the primary source of repayment. On investor credits, it reaches the operating entities met inside global debt service analysis. For a pure investor credit with a passive single-asset borrower, the property income analysis of Courses 5-7 leads. There this course's tools are used to analyze the related entities and the sponsor.

3

Guarantors and Personal Cash Flow

The course covers the guarantor's tax-return package and reading K-1s for cash against taxable income. It builds the personal cash flow statement and measures guarantor capacity and the value of the guaranty. It closes on global debt service analysis across related entities.

4

Property Diligence and Market Value

The course covers whether a transaction requires an appraisal or supports an evaluation, and the appraisal's role and limits. It covers property quality and documentation, and environmental and property-condition diligence and how findings feed the credit. It then works the three approaches to value, the sales comparison approach and adjustment quality, and the lender's independent review. It closes on loan-to-value against policy and supervisory limits.

5

Income Capitalization and the Cap Rate

The course covers converting an income stream to value, direct against yield capitalization, and the capitalization rate and its drivers. It sets out gross, modified-gross and net rent structures and the expense recoveries that follow from them. It then builds the rent roll and effective gross income, operating expenses and net operating income, and derives an independent value conclusion.

6

Underwriting Standards and Breakeven Analysis

The course applies maximum LTV, minimum DSCR and minimum debt yield, and sizes the loan from cash flow through the debt constant. It builds the lender's underwriting NOI and steps it down to net cash flow after reserves, tenant improvements and leasing commissions. It computes and validates DSCR, then works breakeven occupancy, stress testing, and investor return and leverage. It closes on owner-occupied underwriting, in which the occupying business's global coverage is the governing test and the property is tested at market rent as the shadow.

7

Lease Analysis and Property-Type Underwriting

The commercial lease is the contract that produces a stabilized property's cash flow, and income, expense and risk drivers differ across the major income-property types. The course covers abstracting a lease, weighted average lease term and the rollover schedule, tenant credit and credit tenancy, and tenant improvements and leasing commissions. It then covers the distinct underwriting of each property type, with the lender-protection provisions that secure the income stream. Multifamily, office, industrial and retail are taught against worked cases. Hospitality and self-storage are reference treatment, naming the instruments and norms an analyst reads them against without a worked case. Rent structures and expense recoveries are taught in Course 5, immediately before the income build that depends on them. This course reads the lease against an income figure the learner already understands on that basis. Ground-up construction and lease-up of un-stabilized property are out of scope. Owner-occupied property is treated as a special case within the property-type modules. There the "tenant" is the sponsor's own business, so the intercompany lease is not arm's-length evidence of income. The underwriting defers to the occupying business's cash flow (Course 2).

8

Market Analysis and Forward Projections

The course covers grounding a projection in the market and submarket: supply, demand, absorption and comparables. It builds the pro forma projection and discloses its assumptions. It covers the cash-flow waterfall, balloon maturities and working capital in projections. It closes on projected global debt service, closing the gap, and assessing management competence and competitive forces.

9

Repayment Risks and Covenants

The course identifies repayment risks and red flags, and maps risks and mitigants to each source of repayment. It covers covenant categories and design, and why conventional covenants are weak. It then works monitoring and remedies, guaranties and entity structure, documentation, the risk rating, and the credit memorandum and recommendation. This course is the capstone that integrates every prior source of repayment into a single credit decision.

Case studies coverage

Cases Across the Full Range of Outcomes

Each case is a complete borrower file you work through the path, module by module. One more case is reserved for the final assessment.

Approved

Haddad Gardens Apartments

Stabilized multifamily acquisition, rent roll to effective gross income, net operating income and the cap rate, debt service coverage and loan-to-value.

Approved with Conditions

Cruz Development Partners

Owner with multiple related entities, guarantor personal cash flow and global debt service analysis, global contingent obligations and the value of the guarantee, distributions and intercompany flows.

Declined

Aldergrove Commons Retail Center

Suburban retail center reliant on collateral value, actual versus stabilized NOI gap, failing the minimum DSCR despite acceptable LTV, breakeven occupancy and dark-anchor stress testing.

Restructured

Northbrook Office Park

Distressed office property with a balloon maturity, projected cash-flow shortfall and the financing gap, covenant breach, monitoring, and remedies, repayment risks and mitigants by source.

Approved with Conditions

Frostgate Logistics Center

Single-tenant industrial NNN acquisition, credit-tenant analysis of an unrated corporate tenant, triple-net rent structure and expense reimbursements, weighted average lease term and binary rollover risk.

Approved with Conditions

Okafor Precision Components

Owner-occupied industrial acquisition through a related single-asset entity, the intercompany lease and the look-through to the operating business, UCA coverage materially below proxy coverage on working-capital use, the market-rent shadow test the property fails as an investor deal.

Path resources

The Working Files

References used throughout the path.

How the path is built

Three Principles, Every Path

Every Shockproof Learning Path is built on these principles.

1Principle 1

Real Borrower Files

Every module works from complete borrower packages with statements, notes, and tax returns, the way the file actually arrives.

2Principle 2

Method Before Memory

The analytical sequence and global debt service analysis are taught as one repeatable procedure, then applied across every case until it becomes routine.

3Principle 3

Analysis That Leads to a Decision

Every case ends in a recommendation to approve, decline, or restructure, with feedback based on what an experienced credit team decided.

Inside every module

Optimized Learning Modules

Every module shares the same structure so learners build a rhythm and retain more.

Narrated Video

An expert walkthrough of the concept in plain English.

Detailed Cases & Exercises

Hands-on with the files your team uses.

Quizzes & Learning Checks

A learning check after every module and a quiz after every course.

Frequently Asked Questions