At the $1,750,000 asking price, this park doesn't clear UWmatic's default screening gates.
These are UWmatic's default gates, and every user can set their own. A miss here describes the price, not the park.
- Debt service coverage ratio. Net cash flow (NOI after replacement reserves) divided by the year's loan payments. 1.25x means $1.25 of cash flow for every $1 of loan payment.Learn more 1.20xMisses the default target of 1.25x or more
- Year-one cash flow after loan payments and replacement reserves, divided by the total cash invested.Learn more 4.18%Misses the default target of 12% or more
- Net operating income (NOI, before replacement reserves) divided by the purchase price. The property's yearly return before any loan.Learn more 8.03%Clears the default target of 8% or more
At about $1,670,000 it clears the 1.25x DSCR gate. At about $1,335,000 it clears all three, and that is the price the sample LOI below offers.
Same financing in every case: 25% down, 7.00% interest, 25-year amortization. Results vary with the assumptions; this is an illustration, not advice on any real offering.
Try a different price
Move the purchase price and the deal is re-run on the same engine a signed-in user gets. Only the price changes; the financing terms stay as they are.
- Purchase price
- At asking$1,750,000Your price$1,750,000Change$0
- Cap rate
- At asking8.03%Your price8.03%Change0 bps
- Cash-on-cash (yr 1)
- At asking4.18%Your price4.18%Change0.00 pts
- DSCR
- At asking1.20xYour price1.20xChange0.00
At $1,750,000, cash-on-cash is 4.18%, still below the 12% target. DSCR is 1.20x, below 1.25x.
Financing held at 75% LTV, 7.00%, 25-yr amortization. The loan moves with the price.
Lot Mix
Income Summary (Year 1)
- Gross Rental Income
- $285,330
- Other Income
- $26,140
- Gross Potential Income
- $311,470
- Vacancy Loss
- -$14,400
- Adjustments
- $0
- Effective Gross Income
- $297,070
Expense Summary (Year 1)
- Operating Expenses
- $156,502
- Replacement Reserves
- $7,500
- Net Operating Income
- $140,568
Sources & Uses
- Purchase Price
- $1,750,000
- Closing Costs
- $35,000
- Acquisition Fee
- $35,000
- Lender Fees
- $13,125
- Operating Reserve
- $0
- CapEx Budget
- $0
- Total Uses
- $1,833,125
- Senior Debt
- $1,312,500
- Total Equity
- $520,625
Equity Structure
- Down Payment
- $437,500
- Closing Costs
- $35,000
- Loan Fee
- $13,125
- Acquisition Fee
- $35,000
- Total Equity Invested
- $520,625
Projections (5-Year Hold)
| Year | Income | Expenses | NOI | Cash Flow |
|---|---|---|---|---|
| Year 1 | $297,070 | $156,502 | $140,568 | $21,750 |
| Year 2 | $305,593 | $161,197 | $144,396 | $25,354 |
| Year 3 | $314,372 | $166,033 | $148,339 | $29,065 |
| Year 4 | $323,415 | $171,014 | $152,401 | $32,888 |
| Year 5 | $332,728 | $176,144 | $156,584 | $36,825 |
Exit Assumptions
Where the numbers come from
Four inputs, each traced to the cell it was read from in the source T-12. Open a cell to see how it was read and the twelve months behind it.
- Lot rent, tenant-owned homes$167,700
- Home rent, park-owned homes$32,630
- Water and sewer$29,260
- Management fee$23,920
Download the files
The model shows the deal as listed. The LOI shows what you'd offer. The files stay at these prices; the price control above doesn't change them.
How a deal like this gets underwritten
- 1Upload the P&LDrop in a T-12 or OM. Lot rent, home rent and expenses are read into separate lines.
- 2Check what was readReview the parsed lines against the source before the deal is saved.
- 3Adjust the assumptionsChange the price, financing or gates and the returns update.
- 4ExportDownload the Excel model, an LOI, or a lender or investor package.
Curious what a value-add plan does to this park? The in-app sample adds infill, utility billbacks and a home program. It opens in your account after you sign up.
See the value-add versionDisclaimers
- This analysis is provided for informational purposes only and does not constitute investment, tax, legal, or financial advice, nor an offer to sell or a solicitation of an offer to buy any security.
- All figures are projections and estimates based on assumptions that may not materialize. Past and projected performance is not a guarantee of future results.
- Recipients should conduct their own due diligence and consult their own advisors before making any investment decision.
- Sunset Pines is a sample deal built from synthetic data. It is not a real property, and nothing on this page is an offer to buy, sell or invest.