Selected work

Case study

Bank Projections and Financial Modeling

Built scenario-driven bank projections and financial reporting packages that gave lenders faster decisions, clearer assumptions, and defensible planning.

  • Financial Intelligence
  • Operations

$12M+

closed across lending programs

Context

Overview

Built scenario-driven bank projections and financial reporting packages that gave lenders faster decisions, clearer assumptions, and defensible planning.

Financial modeling solidified the strategy: revenue projections, occupancy ratios, and staffing plans tied directly into loan applications. Scenarios showed resilience under different demand curves, while executive dashboards kept sponsors aligned.

Reporting packages went out weekly—bankers saw operational updates, mitigation plans, and capital expenditures in one narrative. The organization expanded facilities with confidence because the data backed every decision.

Proof

Impact

  • 4 loan packages closed (PPP, SBA, disaster relief, traditional)

    Lending velocity

    Within 12 months

  • Cut lender Q&A cycles from weeks to days

    Reporting cycle

    With automated narrative packets

  • 6 macro/micro scenarios with sensitivity toggles

    Scenario modeling

    Presented during diligence

  • $12M+ closed across lending programs

  • Reduced lender follow-up requests by 50% thanks to proactive reporting.

  • Established quarterly board-ready dashboards tying capital to outcomes.

Highlights

What shipped

  • Built multi-scenario cash flow models with sensitivity analysis for loan committees.

  • Automated reporting packages aligned executive and lender narratives.

  • Integrated operational data to show headcount, occupancy, and revenue impacts.

  • Coached executives on investor-ready storytelling and diligence prep.

How it unfolded

Journey

  1. **Discovery and evidence:** Reviewed historical financials, operating metrics, and facility plans to map lender expectations.

  2. **Model build:** Crafted driver-based revenue, margin, and cash models with adjustable sensitivity inputs.

  3. **Narrative alignment:** Worked with leadership to translate models into stories lenders could absorb quickly.

  4. **Diligence support:** Sat in on committee reviews, managed follow-up requests, and iterated decks in real time.

What stuck

Lessons

  • Models need a story

    Data only lands when executives can narrate why each number exists.

  • Scenario depth wins trust

    Lenders respond faster when every assumption has a contingency.

  • Prep the team, not just the deck

    Coaching leadership for Q&A keeps momentum strong even under scrutiny.

Personal note

Reflection

Capital raises aren't spreadsheets—they're confidence plays built on rigorous analysis and practiced storytelling.
Continue the conversation

Next steps

Need models that get lenders to yes?

Bring your expansion or refinancing goals—we'll pressure-test the numbers, build the story, and prep leadership for the diligence room.