Investment deal analyser
An institutional-style model of a single residential purchase. Every figure below is derived from the inputs on the left — no hidden assumptions, no score. National median house: $1,004,000.
Or work out the full purchase costAcquisition
What it takes to complete the purchase
- Deposit
- $180,000
- Transfer duty
- $49,070
- Other costs
- $5,400
- Cash required
- $234,470
- Loan amount
- $720,000
- LVR
- 80.0%
- Monthly repayment
- $4,363
- Annual interest
- $43,920
Transfer duty is an estimate using standard residential scales and excludes concessions, foreign buyer surcharges and land tax.
Operating position
First full year, at today's rent and rate
| Gross annual rent | $36,296 |
| Rent after vacancy | $34,900 |
| Operating expenses | −$8,503 |
| Net operating income | $26,397 |
| Loan repayments | −$52,358 |
| Gross yield | 4.03% |
| Net yield | 2.93% |
| Break-even rent | $1,217/wk |
| Cash-on-cash return | -11.07% |
| Annual cash flow | $-25,961 ($-499/wk) |
Scenarios
Bear, Base and Bull over one to ten years
Bear
Growth 1% · Rent 1% · Rate 7.1%
| Year | Value | Loan | Equity | Cash flow | Net position |
|---|---|---|---|---|---|
| 1 | $909,000 | $712,826 | $196,174 | $-31,667 | $-69,963 |
| 3 | $927,271 | $696,861 | $230,410 | $-31,445 | $-98,725 |
| 5 | $945,909 | $678,467 | $267,442 | $-31,236 | $-124,268 |
| 10 | $994,160 | $619,295 | $374,865 | $-30,783 | $-171,624 |
Base
Growth 4% · Rent 3% · Rate 6.1%
| Year | Value | Loan | Equity | Cash flow | Net position |
|---|---|---|---|---|---|
| 1 | $936,000 | $711,322 | $224,678 | $-25,961 | $-35,753 |
| 3 | $1,012,378 | $692,299 | $320,079 | $-24,414 | $10,036 |
| 5 | $1,094,988 | $670,814 | $424,174 | $-22,783 | $67,739 |
| 10 | $1,332,220 | $604,139 | $728,081 | $-18,318 | $270,899 |
Bull
Growth 6% · Rent 4.5% · Rate 5.35%
| Year | Value | Loan | Equity | Cash flow | Net position |
|---|---|---|---|---|---|
| 1 | $954,000 | $710,031 | $243,969 | $-21,850 | $-12,351 |
| 3 | $1,071,914 | $688,423 | $383,491 | $-19,292 | $87,280 |
| 5 | $1,204,403 | $664,381 | $540,022 | $-16,504 | $209,380 |
| 10 | $1,611,763 | $591,746 | $1,020,017 | $-8,400 | $630,480 |
Net position is equity plus cumulative cash flow, less the cash required at settlement. Projections are arithmetic consequences of the assumptions above, not forecasts or advice.