Michael Medvin Consulting: Fee Position Analyzer

Property & Acquisition

Property Name

Property Type ?

Location

Fee Purchase Price ($) ?

Acquisition Costs (%) ?

Going-In Cap Rate ? —

Hold Period (years) ?

Exit Cap Rate (%) ?

Ground Lease Terms

Lease Term (years): 99 ?

Starting Annual Ground Rent ($) ?

Escalation Type ?

Fixed Escalation Rate (%) ?

CPI Assumption (%): 2.5 ?

CPI Cap (%) ?

CPI Floor (%) ?

FMV Reset Frequency (years) ?

FMV Appreciation (%/yr) ?

FMV Revaluation Cap Rate (%) ?

Financing

Add Leverage ?

LTV (%): 50 ?

Loan Amount —

Interest Rate (%) ?

Loan Term (years) ?

Amortization (years) ?

Interest Only Period (years) ?

Leasehold Stress Test

Model Leasehold Impact ?

Building NOI - Year 1 ($) ?

NOI Growth Rate (%) ?

Senior Mortgage on Leasehold ($) ?

Senior Mortgage Rate (%)

Senior Mortgage Term (years)

Unlevered IRR ?

—

Levered IRR ?

—

Equity Multiple ?

—

Cash-on-Cash (Yr 1) ?

—

DSCR (Yr 1) ?

—

Min DSCR (Loan Term) ?

—

Going-In Cap ?

—

CPI Strip Value ?

—

Exit Waterfall Breakdown ?

Operating Cash Flow	—
Terminal Value	—
Loan Payoff	—
Net Sale Proceeds	—
Total to Equity	—

Loan Sizing Calculator ?

At 1.25x DSCR

—

LTV: —

At 1.50x DSCR

—

LTV: —

IRR Sensitivity — CPI Rate vs Exit Cap Rate ?

Calculating...

Scenario Comparison

No saved scenarios yet.

Rent Projection — All Escalation Types ?

Net Cash Flow Waterfall ?

Cumulative Cash Flow ?

Cash Flow Schedule ?

The Scissors Chart — NOI vs Ground Rent ?