Tools

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 cost

Purchase

Loan

Income and costs

Assumptions

Acquisition

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$23,348
Rent after vacancy$22,450
Operating expenses−$7,682
Net operating income$14,768
Loan repayments−$52,358
Gross yield2.59%
Net yield1.64%
Break-even rent$1,201/wk
Cash-on-cash return-16.03%
Annual cash flow$-37,590 ($-723/wk)

Scenarios

Bear, Base and Bull over one to ten years

Bear

Growth 1% · Rent 1% · Rate 7.1%

YearValueLoanEquityCash flowNet position
1$909,000$712,826$196,174$-43,295$-81,591
3$927,271$696,861$230,410$-43,264$-133,897
5$945,909$678,467$267,442$-43,248$-183,367
10$994,160$619,295$374,865$-43,277$-292,227

Base

Growth 4% · Rent 3% · Rate 6.1%

YearValueLoanEquityCash flowNet position
1$936,000$711,322$224,678$-37,590$-47,382
3$1,012,378$692,299$320,079$-36,706$-25,841
5$1,094,988$670,814$424,174$-35,775$6,233
10$1,332,220$604,139$728,081$-33,223$138,790

Bull

Growth 6% · Rent 4.5% · Rate 5.35%

YearValueLoanEquityCash flowNet position
1$954,000$710,031$243,969$-33,479$-23,980
3$1,071,914$688,423$383,491$-31,945$50,869
5$1,204,403$664,381$540,022$-30,269$146,006
10$1,611,763$591,746$1,020,017$-25,377$488,906

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.