IT

Appraisal

Analysis of real estate deals
Built with Claude Code, 2026

Scroll
The real estate appraisal tool, on a fictitious case
The tool on a fictitious case, “Via dei Tigli 14”, with made-up figures.
The tool

A real estate deal examined from every angle before deciding.

Holding and exit scenarios side by side, under three assumptions, with mortgage, partners and a final report. The case shown is fictitious, “Via dei Tigli 14”, with made-up figures.

13Chapters
3Assumptions
2026Year
Part one

The problem

Before buying a property to refurbish, let or sell on, there is one question: does it pay?

The answer depends on many variables that affect each other (price, taxes, construction cost, timing, mortgage, rents, sale prices) and it changes with every strategy and every assumption. Redoing the sums for each combination was slow, and the result was hard to explain to whoever had to decide.

Part two

The solution

A single interactive document, divided into chapters that follow the deal: change one figure and everything is recalculated.

It compares several holding and exit strategies under three assumptions, cautious, base and favourable, and works out profit, return, equity, mortgage and cash flows for each partner. At the end it produces the report to hand to investors and clients.

The real estate appraisal tool, on a fictitious case
Part three

The main features

  1. 3.1

    The property record and the scenarios

    The deal opens with the property record and the scenarios to be compared.

    • Chapters that follow the deal, from purchase to final payment
    • Each scenario is a strategy: outright sale, standard letting, short-term letting
    • At the top, always in view, the indicators of the chosen scenario
    Opening view of the tool: indicators of the chosen scenario, title block, property record and scenarios
  2. 3.2

    The price and the three assumptions

    Every input has a cautious, base and favourable value; change one and the whole page is recalculated.

    • The chart shows profit as the purchase price varies, under the three assumptions
    • It shows at once whether the deal is viable and how much each €10,000 weighs
    • Purchase taxes and costs calculated from the land registry data
    Purchase price chapter: price, outlay, profit and equity, with the profit chart under the three assumptions
  3. 3.3

    Timing

    From completion to the final payment, month by month: timing affects interest, rents and taxes.

    • Schedule with permits, works, lettings and sales
    • The bars can be dragged and update the chapters
    • The five-year threshold for capital gains is marked
    Schedule from purchase to final payment, with design, works, lettings and unit sales
  4. 3.4

    Mortgage and cash

    How much is owed to the bank and how much the partners have to put in, year by year.

    • Mortgage plan with instalment, interest and APR
    • Cash over time: the deal’s cash flow and peak exposure
    • Table of income, outgoings and balance, with monthly detail
    Debt in the deal and mortgage plan
    The mortgage
    Cash over time: cumulative cash flow, investors’ position and bank debt, with the yearly table
    Cash over time
  5. 3.5

    The partners

    A deal shared by several people: who puts in what and what they get back.

    • Shares of capital and profit
    • Capital to contribute and taxes for each partner
    • Year-by-year cash flows for each partner
    Split of capital, profit and taxes among four partners, with year-by-year cash flows
  6. 3.6

    The comparison and the report

    The scenarios side by side, and a document to hand to whoever has to decide.

    • One row per strategy: profit, margin, return, equity, duration
    • The report for investors and clients, with introduction, scenarios and risk analysis
    • Break-even point and limit values for each item
    Comparison of three scenarios with net profit, margin, return, equity, debt, taxes and duration
    The comparison
    First page of the report: introduction and summary, scenarios considered
    The report
Part four

Review and refinement

A decision tool is only as good as the trust in its numbers: every refinement went in that direction.

The chapters were rewritten until every number could be traced back to its source and every assumption could be read by someone who had not built the model.

  1. Every field shows where it comes from. Colour distinguishes an initial or calculated value from one entered by hand, and “Initial values” resets everything to the starting point.
  2. Three assumptions for every input. Cautious, base and favourable are not three separate files: you choose at the top and it applies to the whole page.
  3. Timing is adjusted by hand. The schedule can be dragged, and the durations flow back into the chapters that use them.
  4. Open checks stay visible. Whatever still needs confirming with the accountant, the bank or the authorities is listed at the end, and the report carries it.
Part five

The result

Chapters
13
Assumptions
3
Scenarios
side by side
Output
report

A deal is assessed in one place, from the first assumption to the final document. The report brings together introduction, method, scenarios, comparison, risk analysis and break-even point, with the assumptions stated: it is ready to hand to investors and clients.

The method

How I built it

  1. The rules are mine. I defined the workflow, the checks and the edge cases myself, based on how we really work.
  2. Claude writes the code. One feature at a time, with Claude Code, describing the problem and reviewing the solution.
  3. Checking stays with me. Every feature is tested on real cases before it goes into everyday use.

The screenshots use sample data only: the data of the practice, its clients and its real transactions remain confidential.

Analysis tool

The case shown is fictitious,
with made-up figures

Analysis and report

Real estate investment appraisal.
A deal examined from every angle before deciding

Designed by

Lorenzo Fava

Built with

Claude Code

Case shown

Via dei Tigli 14, fictitious

Year

2026

07

Document

Investment appraisal

Scenarios, three assumptions, mortgage, partners, report

Next project Villa Benni Survey, enhancement and design options for a historic villa

← Back to profile