Paybck/cashflow models for Vacation rentals

[Ryan Mann]

Has anyone developed an excel based model for showing cashflow and payback for vacation rentals? I'm thinking about buying something, but I need to take into account all of the variables. Is there a good resource for first time researchers?

[Scott Sutherland]

I just uploaded a file to the fileplace section of the resources tab.

It shows the vacation rental performance of our Austin duplex compared to current long term rental rates. 

This is the way we determine our property strategy. By determining how much additional money we'd receive by renting short term vs long term. ROT (return on time) calculation. It's the cell titled "STR Advantage" in the spreadsheet.

The combined cell is for times that we rent both A and B simultaneously to the same group.

The cleaning value was a SWAG but we've started doing a better job of tracking it.

Maintenance and repairs is higher than average due to deferred maintenance.

Shameless plug: Checkout podcast #114 on vacation rentals.

Link below.

http://www.biggerpockets.com/files/user/RealtyStak...

S