Free tool for investors

Investment analysis spreadsheet for Porto

Enter the numbers of the flat, and see at once whether the deal pays off

What's in the file

  • Three rental scenarios side by side: short term, long term, and long term under the new law (10% tax)
  • Every purchase cost: IMT, stamp duty, lawyer, mortgage set-up and fees
  • Mortgage and a full amortisation schedule, month by month
  • Gross yield, net yield and cash on cash return on your own funds
  • A future sale scenario: what you would make after a few years

Cream cells with blue figures are inputs; everything else is calculated. Works in Excel, Google Sheets and Numbers.

Preview of the Porto property investment analysis spreadsheet: snapshot, gross and net yield and cash flow for three rental scenarios

Who it's for

For anyone thinking of buying a flat to invest in Porto or Portugal who wants to check, before committing, what yield it will give, how much of their own money they need, and whether short-term or long-term rental pays better.

More tools

Where should we send the file?

Leave your details and get the file at once, here and by email. Now and then we also send updates on the Porto property market.