Underwriting
UNDERWRITING
What each deal was bought on, and the document that says so ·
11 deals · edit here, no deploy needed
This page is the record. These rows were seeded once from the
UW ROI sheet of the master distribution workbook and are owned here
now. Saving stamps your name, and the importer skips any row a person has
touched — so a correction made here survives a re-seed.
Years are the underwriter’s own. Year 1 starts on the funding
date, not in January. The calendar columns are derived from them by
day-weighting each investment-year across the year — the rule that reproduces
974 of the 300 calendar cells that were worked out by hand.
Blank is not zero. Where the projection does not reach a year,
the calendar cell is empty rather than 0: “projects nothing” and
“projects zero return” are different claims, and CF-4 divides by this.
| Deal | Funded | Source document | IRR | Mult. | Refi | Sale | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 | Y9 | Y10 | 2024 | 2025 | 2026 | T-12 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Percentages may be typed either way — 9.5 and 0.095 both
mean 9.5%. Anything above 3 is read as whole percent, because no cash-on-cash
fraction is 300%.
ADD UNDERWRITING 24 active deals have none on file
Years 6–10 can be filled in on the row once it exists. A deal with only Year 1–5 projections simply has no comparison once it passes year five, which is the honest answer rather than a flat extrapolation.