Free download

Free Property Deal Analyser

Analyse a potential property purchase, refurbishment, refinance and ongoing rental performance in one spreadsheet. You enter your own assumptions, and the workbook shows how they play out across the deal.

Free. Excel workbook, version 1.0. Enter your email once to unlock Fructus resources on this browser.

How it helps

One spreadsheet, the whole deal.

Rather than juggling separate calculations for the purchase, the works, the refinance and the rent, the Deal Analyser is built to bring them together so you can compare what each assumption does to the result.

01

Assess purchase costs

Enter the purchase price and the costs that come with buying, so the total outlay is visible before you commit time to a deal.

02

Plan refurbishment costs

Add your own refurbishment budget to see how works change the cash required and the overall cost of the project.

03

Work through SDLT

Include Stamp Duty Land Tax in the acquisition costs rather than leaving it as an afterthought.

04

Test expected revaluation

Enter the value you expect after works, as your own assumption, to see how it feeds into refinance and equity.

05

Set refinance assumptions

Change loan-to-value and borrowing terms to explore how much cash could remain in the deal after a refinance.

06

Model rental income and operating costs

Enter expected rent and running costs to understand income and expenses over a year.

07

See cash remaining and return metrics

Review cash invested, cash left in the deal, yield and ROCE together in one place.

Who it is for
  • Landlords weighing up a buy, refurbish and refinance project
  • Property investors comparing several potential deals on the same footing
  • Small property companies reviewing acquisition assumptions before approval
  • Property managers helping owners think through a purchase
Before you use it

The Deal Analyser is an informational tool. Results depend entirely on the figures and assumptions you enter, and it does not predict returns or recommend any investment. It does not provide financial, tax, investment or legal advice. Take professional advice before making decisions.

Back to all free resources