We've created an interactive spreadsheet that should help you project monthly cash flow and net annual yield for any property you're considering buying overseas and to compare the return from renting the property short versus long term.

We've hosted the spreadsheet online so that you can play with variables to see the effect on your return on investment. You'll find it at www.liveandinvestoverseas.com/howtodooverseascashflowmath.

When you use the spreadsheet to help you think through a potential cash-flow investment, note the “Current Value” field. This allows you to estimate the current net yield over time, as the property value moves up or down. To start, your calculations will be based on the total purchase price of the property, including all closing costs.