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 | $29,432 |
| Rent after vacancy | $28,300 |
| Operating expenses | −$8,068 |
| Net operating income | $20,232 |
| Loan repayments | −$52,358 |
| Gross yield | 3.27% |
| Net yield | 2.25% |
| Break-even rent | $1,209/wk |
| Cash-on-cash return | -13.70% |
| Annual cash flow | $-32,126 ($-618/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 | $-37,831 | $-76,127 |
| 3 | $927,271 | $696,861 | $230,410 | $-37,710 | $-117,371 |
| 5 | $945,909 | $678,467 | $267,442 | $-37,604 | $-155,597 |
| 10 | $994,160 | $619,295 | $374,865 | $-37,406 | $-235,558 |
Base
Growth 4% · Rent 3% · Rate 6.1%
| Year | Value | Loan | Equity | Cash flow | Net position |
|---|---|---|---|---|---|
| 1 | $936,000 | $711,322 | $224,678 | $-32,126 | $-41,918 |
| 3 | $1,012,378 | $692,299 | $320,079 | $-30,930 | $-8,983 |
| 5 | $1,094,988 | $670,814 | $424,174 | $-29,670 | $35,133 |
| 10 | $1,332,220 | $604,139 | $728,081 | $-26,219 | $200,865 |
Bull
Growth 6% · Rent 4.5% · Rate 5.35%
| Year | Value | Loan | Equity | Cash flow | Net position |
|---|---|---|---|---|---|
| 1 | $954,000 | $710,031 | $243,969 | $-28,015 | $-18,516 |
| 3 | $1,071,914 | $688,423 | $383,491 | $-25,999 | $67,978 |
| 5 | $1,204,403 | $664,381 | $540,022 | $-23,801 | $175,784 |
| 10 | $1,611,763 | $591,746 | $1,020,017 | $-17,400 | $555,429 |
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.