TERRA ✕

Terra — Quick Start Guide

59 min read · ~13,000 words · written to be dipped into — each section stands on its own

Terra takes your assumptions and generates the investment returns — IRR, profit on cost, equity multiple and many more — built from month-by-month cash flows. It works the other way round too: tell it the return you need and it solves the purchase price that delivers it. And it produces an auditable Microsoft Excel model of the whole appraisal, with every total and every KPI a live formula you can follow.

This guide walks you through a first appraisal from start to finish. You don't need to read it all — the single most important idea is “Understanding a line item” (section 4 below), because once you understand one input section you understand sixteen of them.

One convention to know upfront: throughout Terra, costs are entered as negative numbers and income as positive. That's why a construction line shows a rate of -250, while a sale line is positive. You'll see it everywhere.

The same rule decides the sign of the funding, and it is worth saying plainly because it catches people out: capital contributions are POSITIVE — whether they are debt or equity — because they are money coming INTO the development vehicle. An equity injection, a loan drawdown, a facility amount: all positive. What leaves the vehicle — the land, the build, the fees, the interest — is negative.

1. Start from an example, not a blank page

When Terra opens you can begin in one of two ways:

Starting from an example is strongly recommended for your first few appraisals — it shows you what “good” looks like and you learn by editing rather than by building from nothing.

Choose the appraisal style (mode)

Terra has four modes, and the mode simply decides which input sections are shown so you're not distracted by ones you don't need:

Mode Use it for
Development simple A straightforward build-and-sell scheme.
Development complex A development with the full set of cost sections (shows everything).
Investment simple A straightforward income-producing / hold asset.
Investment complex An income asset with the fuller set of sections.
Buy-to-let house A single let residential property — bought, held and sold. The smallest complete appraisal in Terra, and the quickest way to see the whole model end to end.
HMO — four letting rooms The same house let by the room, so four leases run side by side against one building. The simplest example of the lease areas doing real work.

You can switch mode at any time, and you can fine-tune exactly which sections each mode shows in Settings.

2. The building blocks: Appraisal details, Areas, Timings

Three sections at the top set the “shape” of everything else. They're mostly self-explanatory, so briefly:

(Areas and Timings sit together under one Areas and Timings heading, the twelve cost sections under Costs, the operating sections under Net Operating Income and the two sales sections under Sales, so the page opens as a short list of headings. Open a heading to reach the sections inside it.)

3. Purchase price (and the Purchase price helper)

If you don't know the purchase price at all — you want Terra to solve it for a target return — that's the Residual value tool (section 6).

4. Understanding a line item — the one pattern behind 16 sections

This is the heart of Terra. Sixteen of the input sections work in exactly the same way — once you can read one, you can read them all:

Acquisition · Pre-acquisition · Planning · Professional fees · Infrastructure · Enabling works · Refurbishment · Construction · Construction contingency · Community · Marketing · Other costs · Operating costs · Operating income · Sale proceeds · Sale costs

Each of these sections is a stack of line items. Below is a single real line item — the first line of the Construction section — with every box explained.

A typical Terra line item - the first line of the Construction
             section, showing its rate, multiplier, distribution curve, start
             and end periods, and the amount it produces.

Read it as one sentence: “Spend -£250 per ft² of area 0001's gross area (which is 1,000 ft²) = -£250,000, spread as an S-curve from Construction start (period 8) to Construction end (period 25).”

Every box, in order

Section header — Construction  -750,000

The title of the whole section and, on the right, the section total — the sum of every line item in it. Costs are shown as negative numbers, so -750,000 means £750,000 of construction cost across all its line items (this one line is £250,000 of that). The – button on the far right collapses/expands the section.

Description — Phase 1 - Commercial

A free-text label for this line, so you can tell your line items apart. It has no effect on the numbers.

Rate — -250

The price per unit — here -£250 per ft². It's negative because construction is a cost. (Income lines, e.g. Sale proceeds, use positive rates.)

Sign and units. Either sign is allowed — what matters is that Rate × Multiplier comes out the right way round: ordinarily negative on a cost section and positive on an income or sales one. So on a cost line one of the two is negative and the other positive; which one is your choice. Two negatives would turn the cost into income.

The box accepts a plain number or a percentage — 10% and 0.1 mean the same thing. A rate per ft² and a percentage of another line are both ordinary uses.

Multiplier — Gross area 0001: Office 🔗

The quantity the Rate is multiplied by. The 🔗 link icon means this isn't a number you typed — it's linked to another value in the model, in this case the gross internal area of area 0001, the first row of the Areas section. Because it's linked, if you change that area, this line updates automatically.

Each area is named by its number and its description - area 0001 is the one described as Office - and carries its own type (Com: Office, Res: Private sales and so on), which you can change at any time. On a narrow screen the box shows only the start of the name. You can also link a multiplier to the total for a type (Gross area Com: Office), to the commercial or residential totals, to GDV totals, the land area, the purchase price and more.

Sign and units. Same rule as the Rate, because the two are multiplied together: either sign is allowed, and it is the product that should read as a cost or as income. A number or a percentage are both accepted.

Multiplier override — 0.00

Want to ignore the link and type the quantity yourself? Put it here. The greyed 0.00 is a placeholder: while the box is empty, Terra is “not overriding” and uses the linked value. Type a number to override the link — leave it blank to keep using the link.

Sign and units. Either sign, and a number or a percentage — it simply replaces whatever the link resolves to, so the same “the product decides” rule applies. A zero is a real answer here and multiplies the rate by nothing; that is different from leaving the box blank.

Multiplier used — 1,000

The quantity Terra actually used, after resolving the link (or your override). Read-only. Here area 0001's gross area is 1,000 ft².

Amount override — 0.00

Want to set the line's total directly, instead of letting Terra do Rate × Multiplier? Put the total here. Again, the greyed 0.00 is a placeholder — leave the box blank to not override. Use this for a lump-sum line where a rate-times-quantity doesn't make sense.

Sign and units. This one is an amount, never a percentage, and it carries the sign the product would have had — negative on a cost section, positive on an income one. A zero pins the line to nothing, which again is different from leaving it blank.

Amount used — -250,000

The resulting figure for this line = Rate × Multiplier used = -250 × 1,000 = -£250,000 (or your Amount override, if you set one). Read-only. This is what feeds the cash flow.

Distribution — S curve

How the amount is spread across the months between Start and End:

Basis cash flow — Not used

Only relevant when Distribution is “based on another cash flow” — this is where you'd pick which cash flow to follow (e.g. spread marketing in line with sales). Here it's Not used, because the Distribution is a plain S-curve.

Start period — Construction start 🔗 · Offset 0 · Start 8

When this line begins:

End period — Construction end 🔗 · Offset 0 · End 25

When this line finishes, in exactly the same way:

So this one line spreads -£250,000 as an S-curve across months 8 → 25. To add another line (e.g. Phase 2 – Residential), use the section's add control and fill in the same boxes.

That's the whole pattern. Every one of the sixteen sections above is just a stack of these line items. Cost sections use negative rates; income sections (Operating income, Sale proceeds) use positive ones.

5. The action bar — your icon toolbar

The icons run left to right in the order you use them: look at the model, open or save it, analyse it, then take the Excel model away at the end.

Shortcuts use Ctrl+Alt, not Ctrl+Shift. Ctrl+Shift combinations belong to the browser — Ctrl+Shift+R is a hard reload, which would throw away your appraisal — and Alt+Shift is Windows' keyboard-language switcher. Ctrl+Alt is clear of both.

Along the top of the app sits a row of icon buttons. Hover any of them in the app for a tooltip; here's what each one does (keyboard shortcuts in grey). Results update automatically as you edit, so there's no separate “calculate” button. Every shortcut, including the burger menu's, is listed in Appendix A.

Expand / collapse all sections Ctrl+Alt+c

Steps the form through three states: everything collapsed, the section groups open (a list of section headings), and everything open — handy for seeing the whole form or tidying it away.

Headline / detailed KPIs Ctrl+Alt+k

Flips the top banner between the headline numbers and the fuller, detailed KPI set.

Load a saved appraisal Ctrl+Alt+o

Opens My saved appraisals — everything you have saved, plus anything shared with your organisation. Templates are listed first, so a standard starting point is always at the top. Sits next to Save because the two are a pair.

Save the appraisal Ctrl+Alt+s

Saves the current appraisal to your account (name, scenario, date & time) so you can reload it later — and, if enabled, share it with your organisation.

Residual value (solve the price) Ctrl+Alt+r

Solves the purchase price that hits your target KPI — the goal-seek from section 6.

Sensitivity analysis (Pro) Ctrl+Alt+f

Runs a two-variable sensitivity grid so you can see how a KPI moves. Pro only — non-Pro accounts see an “Upgrade to Pro” arrow () in this spot instead.

Cash flow preview Ctrl+Alt+v

Opens the period-by-period vertical cash flow (like the Excel model) without opening Excel.

Build & download the Excel model Ctrl+Alt+e

Generates the fully-formatted, formulaed Excel appraisal and downloads it (a phone opens the share sheet instead).

Settings — the colour theme and which sections show in each mode — lives in the burger menu (top-right), not on the action bar.

6. Residual value — let Terra solve the price for you (not available on the free plan)

Often you don't want to enter a purchase price — you want to know the most you can pay and still hit a target return. That's Residual value (a “goal seek”), and it sits right under the purchase price inputs.

Residual value is not available on the free plan — it comes with Basic and Pro, and during the 7-day free trial; on the free plan the section says “(only available on paid-for plans)”.

  1. Open the Residual value section.
  2. Choose the Target KPI — the measure you want to hit.
  3. Type the Target KPI value you want it to reach.
  4. That's it. Terra re-solves as soon as you change either box, and the answer appears beside the section title, in the same place every other section shows its total. It stays visible when the section is collapsed.

Terra repeatedly re-runs the whole appraisal, adjusting the purchase price each time, until the measure hits your target — so the answer to “what land price makes this a 20% profit-on-cost scheme?” arrives without any trial and error.

The thirteen targets

Target KPI What you are fixing
POC [Leveraged] / [Unleveraged] Profit on cost, the headline basis (sale costs excluded)
POC+Sales costs [Leveraged] / [Unleveraged] Profit on cost with sale costs in the cost base — the valuer's basis
IRR [Leveraged] / [Unleveraged] The annualised internal rate of return
GDV Margin [Leveraged] / [Unleveraged] Profit as a percentage of gross development value
NDV Margin [Leveraged] / [Unleveraged] Profit as a percentage of net development value
Equity Multiple [Leveraged] / [Unleveraged] Cash back divided by cash in, e.g. 1.50 for one and a half times the money back
Equity Total The total equity the scheme needs

Leveraged means with the debt; unleveraged means as if the scheme were funded entirely with cash. Each target remembers its own value, so you can switch between them and back without retyping.

Equity Total answers a different kind of question, and it is the one to reach for when equity and debt draw down pari passu (see Finance). Under that funding order the loan may never reach its cap, so “the price at which this still hits my IRR” and “the price at which I put in no more than £5m of my own money” are genuinely different questions. Before, only the first could be asked.

Things worth knowing

7. Leases — up to 99 areas, and why each has three leases

The Lease inputs section is for income-producing space. There are up to 99 lease areas, and — this surprises people — each area has three lease slots. They represent the life of a letting over time:

  1. Lease 1 — the active (in-place) lease. The tenancy running today. Fill this in if the space is already let.
  2. Lease 2 — a tenant lined up. A known future letting — e.g. an agreed deal due to start later. Optional: leave it blank if you have no specific tenant lined up.
  3. Lease 3 — the recurring lease. The long-run, stabilised letting that repeats into perpetuity — this is what usually drives the investment value of the space.

For a typical development valuation you often only need Lease 3 (the recurring lease): there's no sitting tenant and no specific deal agreed yet, so Leases 1 and 2 can be left empty and the recurring lease carries the value.

Inflating the rents. If you switch on detailed inflation assumptions for a lease area, each lease slot takes its own growth rate: ERV1 → Lease 1, ERV2 → Lease 2, and ERV3 → Lease 3 and every lease after it.

⚠️ There is no ERV4. Because Lease 3 recurs into perpetuity, ERV3 sets the growth rate for the whole of the long-run income — not just the third letting. It is the rate that does most of the work in an investment valuation.

8. Finance

The Finance section is where you size debt and, if you use it, decide how the profit is shared. Whatever the debt does not fund is equity, and that split is what turns the unleveraged numbers into the leveraged ones — leveraged IRR, equity multiple and profit on cost.

Terra models two different loans, and they are not two settings for the same thing. They fund different things, at different points in the scheme's life, and — the part most worth understanding — they measure “value” differently.

Development debt

Development debt funds the build. It is drawn down as costs are incurred rather than in one lump, interest rolls up rather than being serviced monthly, and it is repaid when the scheme sells or refinances.

Its LTV is measured against GDV — the end value, what the finished scheme is expected to be worth. That is the right basis for it: a development lender is lending against something that does not exist yet, so the only value worth testing is the value on completion.

Lower of LTC% and LTV%

Development debt is sized against two limits, and Terra takes the lower (more cautious) of the two:

Terra lends the lower of the two — £6.5m in the example — because that is the binding constraint a lender would apply. Set both percentages and Terra works out which one bites and sizes the loan, and therefore your equity, accordingly.

Which one bites tells you something useful about the scheme. If LTC is the constraint, the lender is limited by what you are spending; if LTV is the constraint, they are limited by what it will be worth. A scheme where LTV bites hard is one where the margin is thin.

Every Finance input is explained one by one in the Appendix D at the end — cash management, equity, both loans and profit sharing, including when the development loan stops lending and how its non-utilisation (commitment) fee is charged.

Investment debt

Investment debt is longer-term debt secured against an income-producing asset that you hold rather than sell. Interest is serviced out of rent, and the loan sits behind the asset for as long as you own it.

⚠️ Its LTV is measured against the purchase price, not against GDV. That is deliberate, and it is the difference people most often trip over when they move between the two modes.

The purchase price is the deemed value at the time — what the asset is demonstrably worth is what you have just agreed to pay for it in an arm's-length transaction. A lender advancing against a standing investment lends against that, not against a valuation of what the asset might be worth later. So a 60% LTV investment loan on a £5.0m purchase is £3.0m, whatever the appraisal says the asset could be worth after the letting-up assumptions play out.

The practical consequence. Raising your rent or exit yield assumptions will change how much development debt Terra sizes, because those feed GDV. It will not change how much investment debt it sizes. If you are expecting the loan to move and it does not, this is almost always why.

Detailed profit sharing — the waterfall (Pro)

Debt decides how much equity you need. The waterfall decides who gets what out of the returns that equity earns — and on a scheme with outside money, that is often the number the deal actually turns on.

Terra splits the equity cash flow between an Investor and a Sponsor through up to ten tiered limbs. Each limb has its own split, and the remainder cascades down to the next one, so the sponsor's share typically grows as the investor's return targets are met in turn. Within each limb Terra applies four tests in order:

  1. IRR hurdle — pay until a target IRR is reached
  2. Multiple hurdle — pay until a target equity multiple is reached
  3. Required amount — pay a specified sum
  4. Sponsor catch-up — the sponsor draws level to an agreed profit share

The tenth limb is the residual “thereafter” split. Sponsor equity is drawn first, and Terra reports each party's IRR and multiple separately as well as a limb-by-limb breakdown, which also comes through into the Excel model on its own sheet.

This is what lets you answer the question a promote structure is really asking: at what point does this deal stop being good for me? Model the promote once and the split is applied to every scenario you then run.

⭐ Pro feature — unlocked on a Pro subscription or during the 7-day free Pro trial; on other plans the section is not shown. (Pro also unlocks sensitivity analysis.)

9. See results, export, and stress-test

Terra shows the headline KPIs (Profit, Profit on cost, IRR, Equity multiple, GDV/NDV margins and many more) in the top banner, with every section total updating alongside. Hover over a tile for a one-line description; Appendix C at the end explains every KPI — what it measures and how it is worked out.

Choosing your KPIs. The banner has two independent layouts, and you set them up separately in Settings (burger menu → Settings):

Each layout lists every available KPI with three controls: Show (green On / red Off), Row and Col. Row and column decide where the tile sits — the banner is six columns wide, and it collapses out any column you leave empty, so fewer KPIs means bigger tiles. Keeping a metric's leveraged and unleveraged versions in the same column is what lines them up underneath each other.

The two layouts are genuinely separate: a KPI can be on the full banner and off the reduced one, in different positions, with different orderings. The Headline / detailed button in the action bar swaps between them.

Making it stick. A banner layout belongs to the appraisal you set it on, so it travels with that appraisal rather than following you to the next one. Once you have an arrangement you like, Save as my default in Settings applies it to every new appraisal you start from then on. Appraisals you have already saved keep whatever they were saved with, so setting a default never reaches back and changes earlier work.

If anything looks questionable, the warnings box flags it and the logo turns red — see Appendix B at the end of this guide. From there:

10. AI assistance — construction costs, rents, sales values and yields

Four assumptions carry more of an appraisal than any others: what the building costs to put up, what it lets for, what it sells for, and the yield a buyer applies to the rent. Terra can build you a research prompt for any of them — already filled in with what it knows about your scheme — which you paste into ChatGPT, Claude or whichever AI assistant you prefer.

Terra sends nothing, and fills nothing in. It writes the question; you ask it, weigh the answer and decide what to type. No figure comes back automatically — this is research to support your judgement, not a valuation.

Where to find it

Look for the small round research icon beside the rate box. It is deliberately quiet — it sits next to the label, not in a column of its own, so it takes up no extra room on a phone. It appears in four places:

What the prompt already knows

Click the icon and Terra fills in everything it can from your appraisal, so you are not retyping it:

Then it asks for the few things it cannot know. For an office that includes the accommodation condition — Cat A, Cat A+, fully fitted or Cat B — with a note explaining each; hover it on a desktop, or tap the i for the same words on a phone. Other uses get a plain “condition and specification” box instead. For a construction cost it asks the project type, specification, storeys, basement, programme, and whether demolition, external works and known abnormals are included. For a sales value it asks the property type (new build, refurbished, conversion …), tenure, specification and the expected completion or sale date. For a yield it asks the tenure, the tenant’s covenant strength, the unexpired term at the sale, the rent review pattern, and lets you correct the lot — this letting alone, the whole building, or a larger portfolio.

What it asks for

The prompt asks for three supportable cases with the evidence behind them — comparable lettings or cost benchmarks, each with a date and a link to its source — and it tells the assistant not to invent figures or references, and to say so plainly where reliable evidence is thin.

The cases run in opposite directions for income and for cost, and it is worth knowing which way round. For a rent or a sales value, downside is a lower figure. For a construction cost, downside is a higher cost — because the bad outcome for a developer is the building costing more — and for a yield downside is a higher yield, because a higher yield is a lower value. The prompt says so each time, but read the answer with it in mind.

Using it

  1. Check the details, and add anything useful — floor level, recent refurbishment, a terrace, an unusual specification. The prompt updates as you type.
  2. Edit the prompt itself if you want to. It is an ordinary text box, and once you change it Terra stops rewriting it.
  3. Copy prompt, then Open ChatGPT or Open Claude — or go to any other assistant yourself — and paste it into a new conversation.
  4. Read the answer and check the sources. Then type whatever you think is right into Terra. Nothing is entered for you.

The prompt needs an address or postcode before it can be copied — without one, the answer is about nowhere in particular. Terra suggests your appraisal’s address; changing it here never changes the appraisal.

11. Put Terra on your device

Terra can sit on your home screen, desktop or taskbar with its own icon and open in its own window, without the browser’s address bar and tabs. Browsers call this installing, which oversells it:

What you get is a shortcut to this website, not a copy of it. Nothing is downloaded. Every time you open it, Terra loads from our servers exactly as it does in a browser tab — so an installed Terra can never be running an older version than the website, and you still need an internet connection. It is the convenience of an app without the thing people rightly worry about, which is a stale copy quietly doing your arithmetic.

It adds a way in; it does not take one away. Terra and every appraisal you have saved stay reachable from any browser on any device with an internet connection, exactly as they are now — your work is held on Terra’s servers, not on the device with the icon on it. Install it on your phone and your desktop if you like; sign in from a colleague’s machine and everything is there.

Where Terra offers it

How it works on each device

Device What happens
Android The menu item opens your browser’s own install dialogue — one tap and it is done. Chrome, Edge, Firefox and Samsung Internet all support it.
iPhone / iPad Apple does not let a website start this, so Terra shows you the three taps instead: Share → Add to Home Screen → Add. Since iOS 16.4 this works from Chrome, Edge and Firefox as well as Safari.
Windows / Mac In Chrome or Edge, the menu item opens the install dialogue; you can then pin Terra to the taskbar or the Dock. In Safari on a Mac, use File → Add to Dock. Firefox on the desktop has no equivalent — a bookmark is the nearest thing.

⚠️ One thing to expect on an iPhone or iPad. The installed app will ask you to sign in again, because iOS keeps a home-screen app’s sign-in separate from the browser’s. Terra allows one active session per account, so signing in there will sign the browser out. Finish anything you have open first — or simply carry on in the installed app from then on.

Changed your mind? Once Terra is installed, the same burger-menu item reads Remove Terra app and shows you where the control is on your device. No browser lets a web page remove itself, so it can only point you at it. Nothing of your work is lost: your appraisals live on Terra’s servers, not on the device, and Terra stays available at terra-appraisal.com in any browser.

Handy tips

Appendix A — every keyboard shortcut

Every shortcut is Ctrl+Alt and a letter, typed without Shift (the letters are shown lower case for that reason). A shortcut does what its icon or menu entry does, and only when that icon or entry is offered to you: the Pro ones do nothing on a Basic account. The action bar's icons are described in section 5.

IconShortcutWhat it doesWhere you find it
Ctrl+Alt+x Calculate now (works whether or not automatic calculation is on) Action bar, while automatic calculation is off
Ctrl+Alt+c Expand / collapse all sections Action bar
Ctrl+Alt+k Headline / detailed KPIs Action bar
Ctrl+Alt+o Load a saved appraisal Action bar; burger menu
Ctrl+Alt+s Save the appraisal Action bar; burger menu
Ctrl+Alt+r Residual value: solve the purchase price Action bar
Ctrl+Alt+p Residual value: transfer the solved value to the Purchase price Residual value section
Ctrl+Alt+h Purchase price helper: transfer its figure to the Purchase price Purchase section, Purchase price helper (open)
Ctrl+Alt+f Sensitivity analysis (Pro) Action bar; burger menu
Ctrl+Alt+v Cash flow (vertical) Action bar; burger menu
Ctrl+Alt+e Build & download the Excel model Action bar
The Terra logo, when it is red Ctrl+Alt+w Show or close the warnings box Top left; the box's heading reminds you
Ctrl+Alt+a Appraisal summary Burger menu
Ctrl+Alt+b Bridge chart Burger menu
Ctrl+Alt+u Print all outputs Burger menu
Ctrl+Alt+y Compare saved appraisals side by side Burger menu
Ctrl+Alt+n New blank appraisal — it replaces the one on screen without asking, so save first Burger menu
Ctrl+Alt+d Ctrl+Alt+i Quick development / quick investment appraisal Burger menu, when offered
Ctrl+Alt+q This Quick start guide, in its own tab Burger menu
Ctrl+Alt+g Settings (colour theme, section visibility, calculation) Burger menu
Ctrl+Alt+j Show all sections (what shows, not your figures) Burger menu
The + beside “Finance” Ctrl+Alt+z Open the Finance section and scroll to it Finance section

No browser uses Ctrl+Alt with a letter, so none of these takes a key away from Chrome, Edge or Firefox. A few desktops claim one before the page sees it: Ctrl+Alt+t opens a terminal on Ubuntu (which is why Terra leaves t free), Ctrl+Alt+l locks the screen on some Linux desktops, and Ctrl+Alt+n starts the NVDA screen reader where it is installed. On a keyboard with an AltGr key, AltGr types its character as usual and never fires a shortcut.

Appendix B — what the warnings mean

The warnings box sits under the KPI banner. When it has something to say the Terra logo turns red; when it is empty the box collapses and the logo goes white. It is capped in height and scrolls, so it shows roughly 8–10 lines at a time.

Every warning is produced by the calculation engine, from the numbers your appraisal was actually built from — not from what happens to be on screen. That matters, because the form and the engine both tidy values as you type, so a check done on the screen can disagree with the model behind it.

Warnings come in two kinds, always shown in this order.

1. Structural — “something in the appraisal looks wrong”

These describe a decision or an input, and they are the ones to read first. They sort to the top so a long run of the second kind can never push them out of view.

Warning What it means Usual fix
Sales start in period X, before construction ends in period Y You are selling before the scheme is built Check the sale timing, or the construction end
Costs but no income at all Costs, but no sale proceeds, no operating income and no NOI Usually a missing sale price or area
Income does not cover the costs before finance The scheme cannot repay itself even ignoring interest Nearly always a mistyped or missing income figure
<Section> is hidden but still carries N line items with values Hiding a section does not remove its money — the engine still charges you for it Show the section, or clear its inputs
<Section>: N line items have a rate but nothing to multiply it by The row looks populated and contributes nothing, because amount = rate × multiplier Set a multiplier, or use an amount override
Leases: N areas have floor area but no rent Space is defined and earns nothing Add a rent, or clear the area
The purchase price is zero but acquisition costs are not Percentage-of-price costs are calculating against nothing Enter the purchase price
The purchase price is positive Costs are negative in Terra, so this is unusual — though a residual value solve can legitimately produce it Check it is not a missing minus sign
Development / Investment debt not fully repaid The loan still has a balance in the last period Extend the term, or check the exit
The cash account still holds … at the end of the cash flow Cash was never distributed, so the leveraged profit, IRR and multiple leave it out Check the minimum cash balance and its end period (Finance > Cash management)
Costs continue after the last income You are still spending after the last money comes in Check the timings; if intended, keep a minimum cash balance (Finance > Cash management)
A timing falls after Sales end A section or line that carries money ends after the last sale Check the timing links and offsets

2. Computation — “a number could not be worked out”

unleveragedIRR is #NUM!, leveragedMultiple is #NUM! and similar. These are real, but they are usually a consequence of something in the first list rather than a separate problem — an appraisal with no income has both, and the missing income is the half worth acting on. Fix the structural warnings first and these often clear on their own.

An IRR reports #NUM! when there is no rate at which the cash flows balance — with no positive cash flow, for instance, no such rate exists. A ratio reports #NUM! when its denominator is zero.

On the banner, the same figure shows as a dash — – — rather than as #NUM! or a zero. The two are the same thing seen twice: the warning names the measure, the tile marks the space where its number would be. Hover the tile and it says why in plain words, because a dash on its own is impossible to tell from a tile that has failed to load. A dash is not an error; it is the honest answer when a measure has none — a profit on cost before there are any costs has no value to show, and a zero there would be a figure nobody calculated.

These are folded away by default. Instead of a wall of #NUM! lines you see a single counted line — “6 computation warnings hidden” — so they can never bury the structural warnings above them, and can never be forgotten either. To see them individually, untick Fold away “could not be calculated” warnings in Settings → Warnings. The setting is saved with the appraisal.

Tip. A brand-new blank appraisal produces several of these, simply because there is nothing to calculate yet — which is why they are folded by default. They clear as soon as the appraisal has costs and income.

Appendix C — the KPIs explained

Every KPI Terra shows, what it measures and how it is worked out. The same figures appear in several places — the banner tiles, the Residual value targets, the sensitivity lists, the KPI comparison and the Excel model — and the names vary slightly between them, because a banner tile has less room. POC is short for Profit on Cost, [Lev] for [Leveraged] and [Unlev] for [Unleveraged]; “POC+Sales costs” is the measure the Residual value list calls “Profit on Cost incl. sales”. Hover over any banner tile for a one-line version of what is written here.

Leveraged and unleveraged. Most returns come in two versions. Unleveraged is the scheme as if it were paid for entirely in cash: no loans, so no interest and no loan fees. Leveraged is the scheme with the debt you set up in Finance: the loans' interest and fees are charged as costs, and the investors' own money — the equity — is whatever the loans do not fund. The gap between the two tells you what the debt is doing to the return.

Sales costs, in or out. The standard Profit on Cost measures take sales costs (agents' and legal fees on disposal) off the sale proceeds, so they never appear in the cost. The “POC+Sales costs” / “incl. sales” versions — the basis many valuers use — count the proceeds gross and put the sales costs into the cost instead. The profit is the same; the cost it is divided by is larger, so these read lower.

Signs and formats. Costs are held negative throughout Terra, so the purchase price, the cost totals and the totals of the cost sections show as negative amounts. Equity and loan amounts are positive — money into the scheme. Percentages show as percentages and multiples as, for example, 1.56x. An IRR or ratio that cannot be worked out shows as a dash on the banner and as #NUM! in the warnings (see Appendix B); a figure that does not apply, such as a profit-sharing party with no equity, shows as n/a.

Value and price

KPI What it measures How it is worked out Format
Purchase price The price paid for the land or property The figure in Purchase price, or the answer a Residual value solve found Amount (negative — a cost)
GDV — GDV [Incl. leases] Gross development value: everything the scheme sells for Every line in Sales plus the sale value of every lease area, before any sales costs Amount
Sale Proceeds The same total as GDV, under the name the cash flow uses As GDV Amount
GDV Total (sensitivity list) Sale proceeds from the Sales section only Every line in Sales; lease sales are not included, so it does not move when you change a lease's cap rate Amount
NDV — NDV [Incl. leases] Net development value: what the sales bring in after the cost of selling GDV less all sales costs — the Sales costs section and each lease's own sale costs Amount
Construction Cost (sensitivity list) The build cost Construction plus construction contingency Amount (negative)

Profit and cost

KPI What it measures How it is worked out Format
Profit [Lev] The profit after the cost of debt The total of the leveraged cash flow: all income less all costs, including every loan's interest and fees Amount
Profit [Unlev] The profit with no debt The total of the unleveraged cash flow: all income less all costs, with no finance costs Amount
Total Cost [Lev] Everything the scheme costs, debt included Total Cost [Unlev] plus the finance costs of both loans. Sales costs are excluded — they are netted off the proceeds Amount (negative)
Total Cost [Unlev] Everything the scheme costs before any debt Every cost section, plus operating costs in any month they exceed operating revenue. No finance costs and no sales costs Amount (negative)
Total Cost2 The cost the development loan and Equity 1 are sized on Total Cost [Unlev] plus the development loan's finance costs, but not the investment loan's. The development loan shows the same figure as Sizing base [Total Cost 2] Amount (negative)
Total Income Everything the scheme brings in Sale proceeds net of sales costs, plus net operating income in the months it is positive Amount

Total Cost [Lev] and Total Cost2 differ by exactly the investment loan's finance cost; hover over either tile to see that reconciliation for your own appraisal.

Returns

KPI What it measures How it is worked out Format
Profit on Cost [Lev] — POC [Leveraged] The leveraged profit as a share of what was spent Profit [Lev] ÷ Total Cost [Lev]. Sales costs excluded %
Profit on Cost [Unlev] — POC [Unleveraged] The same, with no debt Profit [Unlev] ÷ Total Cost [Unlev]. Sales costs excluded %
POC+Sales costs [Lev] — Profit on Cost incl. sales [Leveraged] Leveraged profit on cost on the valuer's basis Profit [Lev] ÷ (Total Cost [Lev] plus all sales costs) %
POC+Sales costs [Unlev] — Profit on Cost incl. sales [Unleveraged] The same, with no debt Profit [Unlev] ÷ (Total Cost [Unlev] plus all sales costs) %
IRR [Lev] The annual return on the equity, allowing for when money goes in and comes out The internal rate of return of the monthly leveraged cash flow — the monthly rate at which it discounts to zero — annualised as (1 + monthly rate)¹² − 1 %
IRR [Unlev] The annual return on the whole scheme, with no debt As above, on the monthly unleveraged cash flow %
Multiple [Lev] — equity multiple How many times the equity is paid back The total of the positive months of the leveraged cash flow ÷ the equity invested (the total of its negative months). 1.50x means every £1 put in came back as £1.50 Multiple
Multiple [Unlev] The same, with no debt The total of the positive months of the unleveraged cash flow ÷ the total of its negative months. Income and cost in the same month are netted first Multiple
GDV Margin [Lev] Leveraged profit as a share of the scheme's value Profit [Lev] ÷ GDV %
GDV Margin [Unlev] Unleveraged profit as a share of the scheme's value Profit [Unlev] ÷ GDV %
NDV Margin [Lev] Leveraged profit as a share of its net value Profit [Lev] ÷ NDV %
NDV Margin [Unlev] Unleveraged profit as a share of its net value Profit [Unlev] ÷ NDV %

Profit on cost and the margins answer “how much, relative to the size of the job”. The IRR adds time — the same profit earned over two years rather than four gives a much higher IRR. The multiple ignores time and says only how much comes back. A margin reads 0 when there is no GDV (or NDV) to divide by.

Equity and debt

KPI What it measures How it is worked out Format
Equity Total The investors' own money the scheme needs Equity 1 plus Equity 2 — the cost the loans do not fund. The tile also shows it as a % of Total Cost2. The leveraged IRR and multiple are measured against this figure Amount
Equity 1 — Equity 1 [Development] The development equity: the committed tranche alongside the development loan What Equity 1 actually drew over the appraisal, shown with its % of Total Cost2 Amount
Equity 2 — Equity 2 [Investment] The residual equity that covers any shortfall nothing else reaches What Equity 2 actually drew. Zero on most development schemes; a large figure usually means the scheme is under-funded Amount
Dev. loan The development loan facility — what the loan is sized to The amount override if you stated one, otherwise the lower of the LTC and LTV tests. Shown with its loan-to-cost % of Total Cost2. It is not necessarily what was drawn — see the loan's Amount drawn and Peak balance Amount
Inv. loan The investment loan amount The amount override if you stated one, otherwise the LTV target × the purchase price. Shown with its % of Total Cost2 Amount
Debt IRR — Debt IRR [All loans] What the finance earns, both loans together The IRR of the combined finance cash flow — the money advanced going out; interest, fees and repayments coming back — annualised. It also includes the flows set by the cash management inputs (cash held in or released from the cash account, and the interest it earns), so it can differ from Dev. debt IRR or Inv. debt IRR even when only one loan is in use %
Dev. debt IRR — Debt IRR [Development loan] What the development lender earns As above, on the development loan's cash flow alone. A loan that is never drawn reads 0 %
Inv. debt IRR — Debt IRR [Investment loan] What the investment lender earns As above, on the investment loan's cash flow alone. A loan that is never drawn reads 0 %

A debt IRR above the loan's interest rate is normal: the arrangement, exit and other fees are part of the lender's return.

Profit sharing — the waterfall (Pro)

These have a value only when Detailed profit sharing is switched on. The two parties take whatever names you give them in the Profit sharing section, so the tiles may read, say, “Bank IRR” rather than “Investors IRR”.

KPI What it measures How it is worked out Format
Investors profit The Investors' share of the profit Everything distributed to the Investors less the equity they put in Amount
Investors IRR The Investors' return, allowing for timing The IRR of the Investors' own cash flow, annualised %
Investors multiple How many times the Investors are paid back Distributions to the Investors ÷ their equity Multiple
Sponsor profit The Sponsor's share of the profit, promote included Everything distributed to the Sponsor less the equity it put in Amount
Sponsor IRR The Sponsor's return, allowing for timing The IRR of the Sponsor's own cash flow, annualised %
Sponsor multiple How many times the Sponsor is paid back Distributions to the Sponsor ÷ its equity Multiple

A Sponsor that takes a promote with no equity of its own has no IRR or multiple — there is nothing to measure a return against — so those read n/a.

Section totals

Every input section shows its total on its title row, and the KPI comparison offers the same figures. Each is the sum of that section's lines over the whole appraisal, in the section's own sign — cost sections negative, income positive.

Total What it adds up
Gross area / Net area The gross and net floor area of every area in Areas — in your area units, not money
Pre-acquisition, Acquisition, Planning, Professional fees, Infrastructure, Enabling works, Refurbishment, Construction, Construction contingency, Community, Marketing, Other costs Each capital cost section — negative amounts
Operating revenues / Operating costs The two halves of Net operating income — revenue positive, costs negative
Sales costs The Sales costs section plus every lease's own sale costs — negative
Debt finance costs All the interest and fees on both loans — negative

Appendix D — Finance settings in detail

Every input in the Finance section, in the order the form shows them. Finance is split into five parts — Cash management, Equity, Development loan, Investment loan and Profit sharing — and each has its own Reset … to default button, which puts that part back to Terra's standard settings without touching anything else, and can be undone. Every setting starts at Terra's standard behaviour, so a part you never open has no effect.

A few conventions apply throughout:

Cash management

Cash management decides what the scheme does with its own cash once it has some: how much of each sale repays each loan, whether income may pay for costs as they arrive, when money may be paid out to the investors, and how much must be kept back. It comes first in Finance because every funding decision below is read against it.

Each month, Terra pays the month's costs, receives its income, repays the loans from what it is allowed to, and pays out (distributes) whatever is left to the equity. These settings change that order of events.

Repaying the loans

Using income to pay for cost

Holding cash back

Minimum and target cash balance — two levels, two jobs. They are easy to confuse, and the difference is the whole point:

That gap between the two is how an interest reserve is modelled: fund a reserve once, set the target at the reserve and the minimum below it, and let the interest be paid out of the reserve as the months go by. A blank target is the same as the minimum. A target below its minimum is ignored — the minimum wins — and a warning says so.

⚠️ The last band that holds cash must end before the appraisal's final period. Otherwise that cash is trapped in the scheme and never distributed, which understates the multiple and the IRR. The warnings box tells you if this happens.

Equity

The investors' own money. Terra has two kinds of equity, and they work quite differently:

Within each month the order is: Equity 1 draws, the development loan draws, the investment loan draws, the development loan is repaid, any surplus is distributed, and then Equity 2 covers anything still negative. A large Equity 2 is worth reading as a warning that a commitment is too small, a facility is capped, or a cost falls where nothing else can reach it — rather than as money you meant to put in.

Development loan

The loan that funds the build — see section 8 for how it is sized against LTC and LTV. Its inputs fall into four groups: who funds each month, how big the loan is, when it lends, and what it costs.

Who funds each month

How big the loan is

When the loan stops lending

A facility does not lend for ever. Terra gives you two ways to say when it stops, and you will usually need neither — leave both blank and the loan advances whatever each month is short of, for as long as the scheme needs it.

⚠️ The ceiling counts every pound ever drawn, not the balance outstanding. Repaying does not free the facility up to be drawn again. A £5m facility that draws £5m, repays £2m and draws £2m more has drawn £7m and is well past its limit, even though only £3m is outstanding. Being able to redraw is what a revolving facility means, and development facilities generally are not revolving — so Terra does not treat them as though they were.

Whichever stops the loan, anything the scheme still needs afterwards is funded by equity (Equity 2), so watch the equity figure when you set either. One thing is drawn on top: the loan's exit fee, because it is charged when the loan is repaid and the loan could not otherwise clear itself. Under a Maximum Facility, room for the exit fee is reserved in advance, so the total ever drawn lands on the ceiling and never above it.

What the loan costs

Non-utilisation fee (also called the commitment fee)

A development lender commits the whole facility up front and charges a fee on the part you have not yet drawn — the price of keeping that money available. It is often called a commitment fee; non-utilisation fee is the same thing.

Terra charges it monthly, at the fee rate ÷ 12, on the undrawn balance, from the month after the loan starts. It stops at the first of:

What counts as undrawn. With Repayments cancel the facility ticked (the usual case), every pound repaid permanently reduces the facility, so the fee falls away as units sell. Unticked, the lender keeps the whole facility committed for the term and charges on all of it until the loan is repaid in full.

Investment loan

Longer-term debt against an income-producing asset you hold — see section 8 for why its LTV is measured against the purchase price rather than GDV. It is advanced in one sum at its start period, its interest is paid monthly out of the scheme's income, and it is repaid on a schedule. How much of each sale repays it is set in Cash management.

Profit sharing (Pro)

The waterfall that splits the equity's returns between two parties — section 8 explains how it works. Its inputs:

Appendix E — key definitions

What Terra means by the terms it uses most, and where its conventions differ from other software. Numbers in square brackets refer to the sources at the end.

Gross Development Value (GDV)

The price a purchaser would pay for the completed development. For units sold individually (e.g. residential for sale), it is the sum of the sale prices. For income-producing property, it is the net rent capitalised at the Net Initial Yield (NIY), with the purchaser's costs then stripped out. This is needed because the NIY is measured on the buyer's total outlay (price plus costs), not the price alone:

GDV = Net rent ÷ NIY ÷ (1 + purchaser's costs)

Where transfer tax is tiered, as with SDLT, purchaser's costs depend on the price itself, so there is no single percentage to divide by. Terra solves for the price at which price + tax + other purchaser's costs equals the capitalised value. The capitalised rent (net rent ÷ NIY) is the buyer's total outlay, not the price. Treating it as the price overstates value.

Conventions differ. Terra follows the RICS definition: GDV is the aggregate market value of the completed development and should represent the "expected contract price", i.e. after purchaser's costs [1]. Some software, notably Argus Developer, labels the gross capitalised figure "GDV", deducts purchaser's costs, and labels the result "Net Development Value" [2][3]. If you are comparing a Terra appraisal with an Argus one, Terra's GDV corresponds to Argus's NDV.

Net Development Value (NDV)

GDV less the vendor's costs of sale, i.e. agent's and legal fees, typically 1–3% of GDV in total. It is what the developer actually receives on disposal.

This follows the RICS definition, under which NDV is GDV less the assumed costs of sale, and the net proceeds of disposal are the expected contract price less the seller's costs [1]. In Argus Developer, by contrast, sales agent and legal fees appear in the costs section as disposal costs rather than as a deduction from value [4] (see the GDV note above).

Internal Rate of Return (IRR)

Technically, the discount rate at which the net present value of a series of cash flows is zero [1]. More intuitively, it is the annual compound rate of return earned on money while it is invested: the interest rate that would grow your contributions into the distributions you receive.

Terra reports three IRRs:

All three are calculated on monthly cash flows, with each month treated as an equal period, and annualised as (1 + monthly IRR)¹² − 1.

IRR measures the rate of return, not its size. A short project can show a high IRR on a small profit, so read it alongside profit on cost and the equity multiple.

Profit on Cost (PoC)

Profit divided by costs, as a percentage. Terra reports four versions:

Within each row the profit is the same; only the denominator changes.

Excluding sales costs reflects the fact that they are deducted from sale proceeds and never need funding, so they behave as negative income rather than true cost. This is consistent with RICS, which treats sale costs as a deduction from GDV to arrive at NDV, and defines profit on value as profit over NDV [1]. Including them matches the Argus Developer presentation, where disposal costs sit within total costs [4].

The versions that exclude sales costs will always show the higher figure, so when comparing with an Argus appraisal, use PoC 2 or PoC 4.

Transfer Tax (Registration Tax)

Tax payable on the purchase of property, usually by the buyer. It is called SDLT in England and Northern Ireland, LTT in Wales and LBTT in Scotland. In the US it is generally called real estate transfer tax (sometimes deed or documentary stamp tax). It is set at state, county or city level, and the seller often pays.

There are three structures:

Unleveraged Cash Flow

The project's cash flows assuming it is funded entirely with equity: costs out and receipts in, with no debt drawdowns, interest, fees or repayments. It measures the performance of the asset itself. Also called ungeared or unlevered.

Leveraged Cash Flow

The cash flows to the equity investor once debt is used: equity contributions out and distributions in, after debt drawdowns, interest, fees and repayments. Also called geared.

Sources

  1. RICS, Valuation of development property, RICS guidance note, global, 1st edition (October 2019, effective 1 February 2020). Glossary and Appendix B1.1.4.
    https://www.southdowns.gov.uk/wp-content/uploads/2020/11/CD9.pdf
  2. Savills (UK) Ltd, Development Appraisal: The Mall, ARGUS Developer v6.00.008 appraisal summary (June 2017), showing GDV less purchaser's costs at 6.80% to give Net Development Value.
    https://www.london.gov.uk/media/46523/download
  3. Dixon Searle Partnership, ARGUS Developer v8.10.001 appraisal summaries (January 2019), showing GDV less purchaser's costs (effective rate 5.75%) to give Net Development Value and Net Realisation.
    https://www.havant.gov.uk/media/8469/download
  4. Grahame Park Plots 10–12 Development Appraisal, ARGUS Developer v8.00.000 appraisal summary (November 2019), showing sales agent fees within costs.
    https://www.london.gov.uk/media/79748/download

Terra Quick Start Guide — version — terra-appraisal.com/TerraQuickStart.html