Using a Development Finance Calculator Properly, and Where It Misleads You
A development finance calculator answers one question: given a scheme’s costs and its finished value, how much can be borrowed and what will that borrowing cost. It is a useful tool and it is wrong more often than it is right, almost always in the developer’s favour.
The reason sits in the drawdown. Development finance is released in tranches against certified progress, so the balance the interest is charged on rises through the build rather than sitting flat. Any calculator that treats the facility as a lump sum from day one overstates the interest badly. Any calculator that ignores the staging entirely understates the cash you need to carry. Most published tools do one or the other, and the developer finds out which at underwriting.
So this is a guide to the inputs, the arithmetic behind the results, and the specific places where a finance calculator and a credit committee disagree.
What does a development finance calculator actually work out?
Three numbers, in a fixed order, and each one constrains the next.
First, the maximum gross loan amount. This is calculated from gross development value against the LTGDV ceiling, which on our lender panel runs to 65 to 70 percent for senior debt. Second, the total cost of the facility: interest plus every fee. Third, the equity requirement, which is simply total project costs plus finance costs minus the gross loan amount.
That third number is the one that matters and it is the one most tools bury. A developer looking at a development finance calculator wants to know whether the scheme works, and the scheme works or does not work on whether the equity gap is a number they actually have.
Notice the direction of the arithmetic. The loan is not derived from the costs. It is derived from the finished value, then tested against the costs. That is why a scheme can be perfectly well costed and still fail: the value did not support the borrowing, and no amount of careful cost planning fixes that.
Which inputs does a finance calculator need before it can give you results?
Six, and a tool that asks for fewer is guessing at the rest.
Gross development value, evidenced. This is the total sale value of every finished unit, not the value of the site with consent. It sets the ceiling on everything.
Land cost, including stamp duty and acquisition fees. The land amount is drawn in full on day one, so it drives more interest than an equivalent amount of build spend.
Build cost, from a cost plan rather than a rate per square foot. The tool needs the total, and a good one asks for the profile too.
Contingency, as a percentage of build cost. Ten percent is what lenders expect on a straightforward residential scheme. Almost no public development finance calculator includes a contingency field, which is the single most common reason its results are optimistic.
Term in months, split between build period and sales period. Interest accrues across both.
The rate, and the fees. Interest from 6.5 percent a year on our lender panel, an arrangement fee, an exit fee and the professional costs.
Feed in six real inputs and the results are worth something. Feed in a build cost per square foot and an end value from a local agent and you have produced a number, not a model.
How is the gross loan amount calculated?
Work an example rather than describe it.
A scheme with a gross development value of £3,200,000. Land at £750,000. Build cost of £1,650,000, plus 10 percent contingency, so £1,815,000. Professional fees on the build of £120,000. Total project costs before finance: £2,685,000.
The LTGDV test first. At 65 percent, the maximum gross loan amount is £2,080,000. At 70 percent it is £2,240,000.
The loan to cost test second. Most lenders cap at around 90 percent of total costs, which here is £2,416,500. That is above the LTGDV figure, so LTGDV is the binding constraint. It usually is on schemes with a thin development margin, and loan to cost usually binds on schemes with a fat one.
So the gross loan is £2,080,000 to £2,240,000. Total costs are £2,685,000. Add finance costs of roughly £185,000 and the developer needs £630,000 to £790,000 of equity.
That equity number is the output the whole exercise exists to produce. A calculator that returns the loan amount and stops has told you the least interesting third of the answer.
One more test the tools rarely apply: the development margin. Gross development value of £3,200,000 against total costs of £2,685,000 plus finance of £185,000 leaves £330,000, which is a margin of about 10 percent on gross development value. Most lenders want 15 to 20 percent before they are comfortable, because the margin is the buffer that absorbs a cost overrun. On that test this scheme is marginal, and a calculator will never tell you so.
How is rolled up interest calculated on a staged drawdown?
This is where the arithmetic gets genuinely fiddly and where cheap tools cheat.
Interest on development finance is charged on the drawn balance, daily, and it is normally rolled up rather than serviced, because a half-built property has no income. So the interest cost depends entirely on the shape of the drawdown curve, not just on the loan amount and the rate.
The wrong way, which many calculators use: gross loan amount times rate times term. On £2,080,000 at 6.5 percent for 21 months that gives £236,600. This is comfortably too high, because the full amount is never drawn for the full term.
The rough way, which is defensible: take the land amount as drawn throughout, and treat the build amount as drawn on average at half its value across the build period. Here, £750,000 drawn for 21 months gives £85,300. The build element of roughly £1,330,000 at an average of half over 18 months gives £64,800. Total, about £150,000. That is much closer to what a lender will calculate.
The right way, which is what a lender’s own model does: build a monthly cash flow with the actual drawdown schedule from the cost plan, apply the rate to each month’s balance, and compound the accrued interest. On a scheme with an unusual build profile the difference between the rough method and the real one can be tens of thousands of pounds.
The practical rule is that a calculator overstating interest is annoying and a calculator understating it is dangerous, because the understated amount has to come from somewhere and the somewhere is your equity.
Which costs and fees does a development finance calculator usually leave out?
Most tools model interest and an arrangement fee. Here is what is missing.
The exit fee, which is charged on many facilities and is the largest single omission. Worse, the basis varies: an exit fee of 1 percent on the loan is £20,800 on our example, while 1 percent on gross development value is £32,000. Same headline percentage, £11,200 apart.
The monitoring surveyor, which runs from an initial appraisal fee through a charge for every site visit across an 18 month programme. On a mid-sized scheme this is several thousand pounds and it is a real cost of using a staged facility.
Valuation fees, which scale with the scheme.
Legal costs, both sides, because the borrower pays the lender’s solicitor as well as their own.
Non-utilisation fees, charged by some lenders on committed but undrawn funds, which is how an oversized facility costs money for nothing.
Stamp duty on the land purchase, which some calculators include in land cost and some do not, and the amount is large enough that the ambiguity matters.
Add the omissions together on our example and the gap between a naive calculation and the real total cost of funding is commonly £40,000 to £60,000. On a scheme with a £330,000 margin, that gap is a fifth of the profit.
Where do bridging calculators and development calculators diverge?
They look similar and they model different things, and mixing them up produces bad numbers in both directions.
A bridging calculator models a lump sum. You borrow an amount on day one, the balance stays flat, and the interest is a monthly rate applied to that flat balance. Bridging loans run from 0.55 percent a month up to 1.0 percent a month on our lender panel, over a term of 1 to 18 months. The arithmetic is simple because the drawdown is simple.
A development calculator models a curve. The balance starts low, climbs through the build, and peaks at practical completion. There is no single balance to apply a rate to.
Three consequences follow. Bridging finance quoted monthly looks cheaper than development finance quoted annually until you annualise it, and 0.75 percent a month is 9 percent a year. Development finance charges you less than the headline suggests because most of the money is drawn for less than the full term. And a bridging calculator used on a build scheme will overstate the interest badly, because it assumes a balance you will not carry.
The comparison that actually matters is on the job rather than the rate. If the requirement is a site purchase ahead of planning, bridging finance is the right tool and the flat-balance arithmetic applies. If the requirement is funding a build, you need a staged model, and running the numbers on a bridging calculator will tell you the scheme costs more than it does.
What does an exit fee do to the results?
More than developers expect, because it is charged at the end on a number that has grown.
An exit fee on the loan is calculated on the facility amount, so on a £2,080,000 gross loan a 1 percent exit fee is £20,800. An exit fee on gross development value is calculated on £3,200,000, so the same 1 percent is £32,000. Some lenders charge 2 percent on the loan, which is £41,600.
The reason this matters more than an equivalent amount of interest is timing. The exit fee is paid out of sale proceeds at the moment the developer is trying to release profit, and it is not reduced by finishing early. Interest rewards speed. An exit fee does not.
So when comparing two facilities, convert everything to a single total cost figure over your real programme. A facility at 6.5 percent with a 1 percent exit fee on gross development value can easily cost more in total than one at 7.25 percent with no exit fee, and the results of that comparison flip depending on how long you borrow for.
Which property development finance calculator should you actually trust?
There are three kinds published online and they are built for different purposes, which is worth knowing before you rely on one.
The lead capture tool is the most common. Two or three fields, a headline loan amount, and a form. It exists to collect an enquiry rather than to model a scheme, and the arithmetic behind it is usually a flat LTGDV percentage with no costs, no fees and no term. Useful for a sanity check on the gross loan and nothing else.
The lender’s own property development finance calculator is better. It reflects that lender’s real criteria, its LTGDV ceiling and its fee structure, so the results are close to what that lender would actually offer. The limitation is obvious: it tells you what one lender would do, and development finance pricing across a panel of over 100 lenders varies enough that one data point is close to no information.
The full appraisal model is the real tool, and it is a spreadsheet rather than a web form. It carries a monthly cash flow, a drawdown schedule taken from the build programme, interest calculated on each month’s balance, all fees in the month they fall, and sale receipts phased across the sales period. Every developer who builds more than one scheme ends up with one, and every property development finance case we place is modelled this way before it goes to a lender.
The gap between the first and the third is not detail. It is whether the answer is right. A lead capture calculator on our example scheme returns a gross loan of £2,080,000 and stops. The full model returns the same loan, plus £150,000 of interest, plus £62,000 of fees, plus a peak cash requirement in month seven that the developer has to fund out of their own resources, and it is that last number that decides whether the scheme can be built.
One more thing to check on any tool: whether it applies loan to cost as well as loan to gross development value. A calculator that only tests LTGDV will happily tell a developer buying an overpriced site that they can borrow more than the scheme costs, which no lender will do.
How do you model the cash flow gap a calculator does not show?
The gross loan amount tells you what you can borrow in total. It does not tell you what you need in the bank in month seven, and that is the number that stops builds.
The gap exists because development finance pays after the work rather than before it. The contractor invoices, the developer pays, the monitoring surveyor visits, the certificate is issued, the lender releases. Two to four weeks pass between the developer’s money going out and the lender’s money coming in, every single month.
Model it as a simple monthly table. Costs out in the month they are actually paid. Loan drawdowns in the month they are actually received, which is one cycle later. The running difference is your cash requirement, and its worst point is your peak exposure.
On a scheme drawing an average of £150,000 a month through the build, the rolling gap is around £150,000 and the peak is usually higher, because that is when materials, deposits and a payment cycle overlap. Add the deposits paid to suppliers for windows, kitchens and roof trusses, none of which the surveyor will certify until they are fitted, and £200,000 of working capital on a scheme with a £2,080,000 loan is entirely normal.
Three levers reduce it. Negotiate longer payment terms with the contractor so the outflow moves closer to the drawdown. Agree more frequent drawdowns, fortnightly rather than monthly, which halves the rolling exposure. And ask, before you sign, how many working days the lender takes between certificate and release, because a lender at three days and a lender at fifteen are running very different facilities at the same interest rates.
None of this appears in any development finance calculator published anywhere, and it is the most common reason a properly costed scheme still gets into trouble.
Why does the lender’s number come back lower than the calculator’s?
Four reasons, and all four are predictable enough to model in advance.
The gross development value is discounted. A valuer instructed by the lender will test your unit prices against comparable evidence, and where the evidence is thin they will report conservatively. Land Registry sold prices for genuinely comparable units are the benchmark, and a £3,200,000 appraisal that comes back at £3,000,000 has just cut the maximum gross loan amount by £130,000 to £140,000 at a stroke.
The build cost is increased. A monitoring surveyor reviewing a cost plan that looks light for the specification will report a higher figure, and the lender will size the facility on the surveyor’s number rather than yours.
The contingency is enforced. If your appraisal carried 5 percent and the lender requires 10 percent, that difference lands entirely in your equity requirement.
And the term is extended. Lenders routinely add a few months to a developer’s programme and a few months to the sales period, which increases rolled up interest and therefore the total facility.
Stack all four and the lender’s number on our example scheme can come back £200,000 below the calculator’s. None of it is unreasonable. All of it is avoidable as a surprise, because you can apply the same four haircuts yourself before you submit.
How do you model a deal that starts as bridging and becomes development finance?
Plenty of schemes run in two stages, and modelling them as one facility gets the costs wrong in both halves.
The common shape is this. You buy a site without detailed consent, or you buy at auction on a 28 day deadline, and no development lender can move that fast or lend against an unconsented site. So bridging loans fund the acquisition. Then consent lands, the scheme is designed and costed, and development finance refinances the bridging loan and funds the build.
Model that as two calculations joined at the hip.
Stage one is flat balance arithmetic. A bridging loan of £500,000 at 0.75 percent a month for eight months costs £30,000 in interest, plus 1 to 2 percent arrangement fee, plus valuation and legals. Bridging is priced monthly and runs 1 to 18 months, so the only variable that really moves the cost is how long you hold it, and the answer to that is however long the planning authority takes.
Stage two is the staged model already described. The development finance facility repays the bridging loan on day one, which means the bridge amount behaves exactly like the land tranche in the development calculation and starts accruing development finance interest immediately.
Two traps in joining them up.
The first is double counting the acquisition costs. The stamp duty and legals were paid at stage one. They belong in total project costs once, not twice, and a developer running two separate calculators frequently counts them in both.
The second is the bridging exit. Your bridging loan has a term. If consent takes 14 months and the bridge was written for 9, you are paying extension fees and a higher rate at exactly the point you have no leverage. Price the bridging stage on a pessimistic planning timetable rather than an optimistic one, and check whether the bridging lender will extend before you need them to.
Run properly, a two stage model shows something a single development finance calculator never will: that the total cost of funding a scheme bought pre-consent includes eight to fifteen months of bridging interest rates that were never in the appraisal, and on a thin margin that can be the whole profit.
What should you do with the results before speaking to a lender?
Run three versions rather than one.
The base case, with your own inputs. The lender case, with the value cut by 5 percent, the build cost up by 5 percent, the contingency at 10 percent and the term extended by three months. And the stress case, with the value down 10 percent and the term extended by six.
If the scheme survives the lender case, you are having a straightforward conversation. If it only survives the base case, you are looking for either more equity, a second layer of capital such as mezzanine finance at around 12 percent a year to take the total to 85 to 90 percent LTGDV, or a different site.
The other thing worth doing with the results is separating the two questions a calculator conflates. Can the scheme be funded, and should it be built. A development finance calculator answers the first. The development margin, the market you are selling into and your own capacity to carry the cash flow gap answer the second, and the second question is the one that decides whether you make money.
Does one development finance calculator work for every property type?
No, and the reason is that the finished value is arrived at differently depending on what you are building.
Residential property is valued on comparable sales. Eleven houses at £290,000 each is a gross development value of £3,190,000, and the evidence for it is what similar houses nearby actually sold for. A development finance calculator handles this well, because the input is a single number the developer can evidence.
Commercial property is valued on income. An office or an industrial unit is worth its rent divided by a yield, so the calculator needs two inputs it rarely asks for: the expected rent and the yield a buyer would apply. Get either wrong and the gross development value is wrong, and with it every number downstream. Commercial development finance is also sized more conservatively for exactly this reason, because a value built on an assumed letting is a softer number than one built on comparable sales.
Mixed use property needs both methods at once, blended. A scheme with flats above a retail unit has a residential value from comparables and a commercial value from income, and the finance is sized on the total. If the retail unit is unlet at practical completion, the commercial half of that value is theoretical, and lenders discount it accordingly.
Specialist property is different again. Care homes, student accommodation and holiday units are valued as operating businesses rather than as buildings, which means the operator matters as much as the construction. No general development finance calculator models this, and these schemes are appraised individually.
The practical consequence is straightforward. If you are building houses, a standard calculator gets you close. If there is any commercial or specialist content in the scheme, the calculator will give you a number and the number will be soft, and the finance you are eventually offered is the one derived from a valuer’s view of the income rather than from your appraisal.
If you want a scheme modelled properly against live terms, we model a development facility across a panel of over 100 lenders and will show you the arithmetic rather than a number. Where the equity gap is too large, mezzanine finance is the usual answer. For a site purchase before consent, price it as bridging loans instead. Where a completed scheme is still selling, development exit finance reprices the debt downwards.
Construction Capital is a trading name of Lenzie Consulting Ltd, registered in England and Wales, company number 08174104. We are a commercial finance broker and introducer, not a lender, and we are not authorised by the FCA. Rates and terms are indicative, vary by lender and deal, and are never an offer of finance. Written by Matt Lenzie.