Day to day I have built AI into my own recurring work, and these are the pieces of it worth handing over. Below is the set, free to take: run them here, or download and make them yours. I would rather they got used than sat unopened on a hard drive.
Every figure on this page is invented.
A full acquisition model for a value-add apartment deal.
Rent roll by unit type, the T-12 against the pro forma, rent growth and loss to lease, a renovation program, the loan sized by its binding test, the exit, levered and unlevered IRR, equity multiple and cash on cash, 3 sensitivity grids, and the depreciation and tax view.
At the invented defaults
| Levered IRR | 13.63% |
|---|---|
| Equity multiple | 1.83x |
Every loan has 3 ceilings. Only one of them binds.
The loan sized by LTV, DSCR and debt yield with the binding test named, rate and amortization scenarios, interest-only periods, the schedule and balloon, prepayment by step-down or yield maintenance, and a refinance at the end of the hold.
At the invented defaults
| Maximum loan, DSCR binds | $15,699,848 |
|---|---|
| Cash out at a year 5 refinance | $3,241,490 |
The premium is not the return. The downtime is in the denominator.
Unit types with their premiums and costs, a month by month schedule with downtime and lease-up, return on all-in cost by type, payback, and the value created at a cap rate.
At the invented defaults
| Return on all-in cost | 14.43% |
|---|---|
| Value created at a 5.75% cap | $2,883,677 |
6 weeks free on a 15-month term is not 6 weeks free.
Net effective rent under any concession, loss to lease and how fast it burns off, a comp survey with adjustments, and renewal against a new lease at your retention.
At the invented defaults
| Net effective rent | $1,296.09 |
|---|---|
| Loss to lease | 5.58% |