Investment Analysis
Full deal underwriting with year-by-year cash flows, IRR, equity multiple, and exit value.
ACQUISITION
OPERATING (YEAR 1)
EXIT
KEY METRICS
IRR
20.79%
EQUITY MULTIPLE
3.37x
YEAR 1 CASH-ON-CASH
4.70%
YEAR 1 CAP RATE
7.44%
TOTAL EQUITY IN
$2,210,000
LOAN AMOUNT
$6,375,000
EXIT SALE PRICE
$12,138,708
EQUITY AT EXIT
$6,275,477
YEAR-BY-YEAR CASH FLOW
| Year | Gross Income | EGI | OpEx | NOI | Debt Service | Cash Flow |
|---|---|---|---|---|---|---|
| Yr 1 | $950,000 | $902,500 | $270,000 | $632,500 | $528,547 | $103,953 |
| Yr 2 | $978,500 | $929,575 | $276,750 | $652,825 | $528,547 | $124,278 |
| Yr 3 | $1,007,855 | $957,462 | $283,669 | $673,794 | $528,547 | $145,246 |
| Yr 4 | $1,038,091 | $986,186 | $290,760 | $695,426 | $528,547 | $166,878 |
| Yr 5 | $1,069,233 | $1,015,772 | $298,029 | $717,742 | $528,547 | $189,195 |
| Yr 6 | $1,101,310 | $1,046,245 | $305,480 | $740,765 | $528,547 | $212,217 |
| Yr 7 | $1,134,350 | $1,077,632 | $313,117 | $764,515 | $528,547 | $235,968 |
Estimates only. Assumes straight-line growth in income and expenses, monthly amortization, and constant exit cap rate. Consult Adrian Ramirez, CCIM for detailed underwriting on actual deals.