Example figures. Change any box.

Rooming house returns

What it costs, what it earns, what is left after the bank.

Client (for the report)

Client name Client address Report date

Cost

Land purchase ($, optional) Build cost ($) Furniture ($) Solar ($)

Income

Rooms Rent per room per week ($) Empty rooms (%)

Loan

Your cash in (% of cost) Interest rate (%) Loan years Cash left put back into loan (%)

Upfront costs

Stamp duty (% of land) Transfer and registration ($) Conveyancing ($) Valuation ($) Lender's mortgage insurance ($) Loan type

Value

Cap rate (%)

Value is rent left before loan, divided by the cap rate.

Running costs

Council rates ($ a year) Insurance ($ a year) Water, power ($ a year) Repairs (% of rent) Management (% of rent)

Cash left each year

Returns

-Gross yield

-Net yield, before loan

-Return on your cash

-Land and build (or build only)

-Your cash in

-Furniture and solar

Paying out the loan

Extra paid on the loan each year-

Loan cleared in-

Loan left after 5 years-

Loan left after 10 years-

Interest saved-

Cash left each year goes back into the loan. Rent and costs stay as entered.

Value and safety

Value at your cap rate-

Value if cap rate is 1% higher-

Value if cap rate is 1% lower-

Value less land and build-

Empty rooms when cash left hits zero-

Each month

Cash in (rent collected)-

Cash out: running costs-

Cash out: loan repayments-

Cash out: total-

Left over-

Where the money goes (a year)

Rent if every room is full-

Lost to empty rooms-

Rent actually collected-

Running costs-

Left before loan-

Loan repayments-

Cash left-

Cash needed

Stamp duty-

All upfront costs-

Cash needed (your cash in plus upfront)-

Return on cash needed-

Rooming house returns

Client (for the report)

Cost

Income

Loan

Upfront costs

Value

Running costs

Cash left each year

Returns

Paying out the loan

Value and safety

Each month

Where the money goes (a year)

Cash needed

Client report