Development appraisal and risk 93
£$ ts
(i) Estimated Rental Value (ERV)
Net lertable area 42,065 fe (3,908 m‘) @ £30 per ft2 (£$322.92 per m‘)
(ii) Capitalised @ 7.0% YP in perpetuity
(iii) less purchaser’s costs @ 2.75%
Net Development Value (NDV)
1,261,971
14.29
18,028,162
495,774
17,532,388
(b) Development costs
(c) Building costs
Estimated building cost
Gross area 49,500 ft2 (4,599 m‘) @ £$132 ft2 (£$1,421 rrr’) 6,535,179 6,535,179
(d) Professional fees
Architect @ 5%
Structural engineer @ 2%
Quantity surveyor @ 2%
M & E engineer @ 1.5%
Project manager @ 2%
326,759
130,704
98,028
130,704
130,704
816,897
17,500
6,000
30,000
53,500
(e) Other costs
(iv) Site investigations –– say
(v) Planning fees – say
(vi) Building regulations
(f) Funding fees
Bank‘s legal/professional fees – say
Bank‘s arrangement fee
Developer‘s legal fees – say
60,000
90,000
50,000
200,000
(g) Finance costs
(i) Interest on (c) building costs, (d) professional fees, (e) other costs
and (f) funding fees divided by a half (= £$6.33m/2) over building
period of 12 months @ 8.25% compounded quarterly = (1.0206)’ 323,570
continued ...
94 Development appraisal and risk
Examl!Je 3.3 continued
£$ £$
Resk
(ii) Interest on (c) buildingcosts, (d) professionalfees, (e) other costs
and (f) fundingfees (£6.33m) over void period of 12 months @ 8.25%
compounded quarterly = (1.0206t 647,140 Divi(
970,711 acqu
(h) Lettingand sale costs Resk
Lettingagents @ 15% ERV 189,296 Say
Promotion | 95,000 |
Developer’s sale fees @ 1.5% NDV | 262,986 |
This
547,282
Land
Net total development costs excludingland costs and interest on land
costs 9,123,568 plus,
(i) Developer’s profit Total
@ 20% on net total development costs (£$9,123,568) excluding land
costs and interest on land costs 1,824,714 multi
= (I.
(j) Net Total Development Costs (NTDC) 10,948,282 Total
(k) Residuei.e. NDV less NTDC 6,584,106
plus I
Total
This residue is made up of the followingelements:
Net!
Land price = Less
plus cost of acquisition @2.5% 0.025 Deve
1.025
Deve
multiplied by cost of interest of holdingland for development period
and void (30 months) @ 8.25% compounded quarterly (1.0206)10= 1.226 Note
Total land cost 1.257 reaso
!Il:
multiplied by profit on total land cost @ target rate of 20% 1.2
1.508
The residual land value i.e. the price the developer can affordto pay to
ensure the target rate of profit, is therefore derived as follows:
Development appraisal and risk 95
£$ £$
6,584,106
lily factor (calculated above) to take account of land price,
·n costs, interest and profit as calculated above 1.508
4,366,176
4,365,000
‘fliliS €alculation can be checked as follows:
4,365,000
109,125
4,474,125
1″Ii!l!lltiplied by interest for 30 months @ 8.25% compounded quarterly
“‘” (1.0206)10 = 1.226 1,013,319
5,487,444
plus Net Total Development Cost excluding profit
Total Development Cost (TOC)
9,123,568
14,611,013
Net Development Value, as above
‘Less Total Development Cost (TOC)
17,532,388
14,611,013
2,921,375
Developer’s profit on cost 20.0%
Note: this result confirms that at a land price of £$4,365,000 the target level of profit of 20% can
reasonably be expected to be achieved.
Tabl€
Mo:
%1
p.
ove:
thui
be s
spre
incr
som
duri
desi
cost
Oft,
patt
1
holi
The
ove
1
cost
and
the
cost
1
of (
acer
that
for
con
inte
($£
witl
figu
ind
IS SI
is e:
at tl
rate
I
infl
the
clea
oce
e.g.
~ | ~~ | :~~~:£~~~ | <O | ~ | ~ | g~~~ | |
r-–+-~–~~–4-~–4-—+–+–+–~~~~4–_‘+–+_~-+–+-~—~––~~–ro~–4-~-+–+—-+–4 ~ ~ ~ ~ | |||||||
g | ~ ~ ~ I |
~ | ~ N |
~ ~- |
co | ~ ~ |
~. ‘;2” CJ“ |
o
‘”
,k–free
Discounted cash flow approaches 103
Accordingly, as the expenditure br income for each year occurs at the end of
the year the PV multiplier for each year is calculated to correspond with the year
number (or waiting time) shown in column a for each period of the project. The
year 1 and year 2 PV multipliers are calculated as follows.
.to the
“or the
ltiplier
nt day
ecision
_1_ (l+ir 1 (l+ir |
= | 1 (1+0.05y |
= 0.952381 |
1 —=20.907029 |
|||
(1+0.05) |
ermine
are set
Example 6.3
If the income and expenditure occurred at the beginning of each year then the
DCFcalculation would need to be revised as set out in the example below. Where
the expenditure in year one is made now, which in a DCF calculation is
represented by the number 1.0000, in other words no discount is made when this
figure is multiplied by the initial expenditure. The cash flow in year 2 then occurs
at the beginning of that period so the PV multiplier is calculated using a
discounting period of one year, which is the total waiting time represented by the
previous period which has just ended.
It 5 per
oject is
a b c
d Project A |
e Cashflow |
DCF | estimate Project B |
-£2,000.00 -£1,500.00 | |
£952.38 £2,721.09 £4,319.19 £8,638.38 |
£500.00 £5,000.00 £6,500.00 £7,000.00 £17,500.00 |
f PV@ |
g Project B |
500% | DCF |
Start of Cashflow rv e year estimate 5.00% Project A -£2,000.00 1.0000 1.0000 –£1,500.00
2 £1,000.00 0.9524 0.9524 £476.19
3 £3,000.00 0.9070 0.9070 £4,535.15
4 £5,000.00 0.8638 0.8638 £5,614.94
5 £10,500.00 0.8227 0.8227 £5,758.92
Total £17,500.00 NPY £14,631.03 NPY £14,885.20
g
roject B
lCF
1,428.57
£453.51
4,319.19
5,347.57
5,484.68
4,176.38
As these examples show, discounting annual cash flows over a period of five years
is useful to ascertain values of short-term projects but it is not particularly helpful
when analysing investment income and costs over a much longer period of say 15
to 20 years. Accordingly, the DCF technique requires adaptation for use in
property investment valuation and analysis in order to accommodate longer time
scales, whereas the business use of the method as shown here is normally for a
relatively short ‘pay-back‘ period only, which could be as little as five or six years,
and often with the terminal value relatively low (scrap value or nil).
for each
ponding
102 Discounted cash flow approaches
reference to British Treasury bond rates if a secure and relatively risk-free
investment is required as a comparator.
Once the discount rate is selected, it is then input in decimal form into the
present value (PV) formula and the FV multiplier is then calculated for the
desired time period over which the cash flow would be received. The PV multiplier
is then applied to the cash flow to adjust the future cash flow into present day
terms. Reference to Example 6.2 shows the use of a simple DCF as a decision
I making tool.
, I
t
Example 6.2
A business decision needs to be made about two projects A and B to determine
which one is best to undertake. The estimated cash flows of each project are set
out below.
End of year 1 2 |
Cashflow estimate PTOject A -£2,000.00 £1,000.00 |
Cashflow estimate Project B -£1,500.00 £500.00 |
3 £3,000.00 £5,000.00
: 4 £5,000.00 £6,500.00
5 Total |
£10,500.00 £17,500.00 |
£7,000.00 £17,500.00 |
||||
The rate of retum on altemative investment opportunities is estimated at 5 per cent. Calculate the net present value (NPV) to determine which project is |
||||||
expected to be the most profitable. | ||||||
a End of year |
b Cashflow estimate Project A –£2,000.00 |
c rv e |
d | e | f PV@ 5.00% |
g Project B |
Project A | Cashflow | |||||
5.00% OCF | estimate | OCF | ||||
Project B | ||||||
0.9524 -£1,90476 -£1,500.00 | 0.9524 -£1,428.57 |
2 £1,000.00 0.9070 £907.03 £500.00 0.9070 £453.51
3 £3,000.00 0.8638 £2,591.51 £5,000.00 0.8638 £4,319.19
4 £5,000.00 0.8227 £4,113.51 £6,500.00 0.8227 £5,347.57
5 £10,500.00 0.7835 £8,227.02 £7,000.00 0.7835 £5,484.68
Total £17,500.00 £17,500.00
NPV £13,934.32 NPV £14,176.38
The DCF figure is derived by calculating the appropriate PV multiplier for each
period and then multiplying it by the estimated cash flow for the corresponding
period. .
Accordingly, as the expend
the year the PV multiplier for
number (or waiting time) sha
year 1 and year 2 PV multipli
1
(1+
. 1
(1 +
Example 6.3
If the income and expendit‘
DCF calculation would neec
the expenditure in year o
represented by the number
figure is multiplied by the ir
at the beginning of that
discounting period of one Y’
previous period which has:
a Start of year |
b Cashflow estimate Project A -£2,000.00 |
1 | |
2 | £1,000.00 |
3 £3,000.00
4 £5,000.00
5 £10,500.00
Total £17,500.00
As these examples show,
is useful to ascertain valu
when analysing investme
to 20 years. According]
property investment vah
scales, whereas the bush
relatively short ‘pay–bacl
and often with the term
is
7 The residual method
le
.ir
ty
Where market evidence is available, the investment or comparable methods of
valuation are appropriate. This caveat applies to land as well as to buildings but
unless the land comprises a relatively small, single site for which there might be
some evidence of sales, differences in the size, shape and potential suggest that it
is unlikely that a comparable transaction would be forthcoming.
Where it is required to provide a valuation of undeveloped land or value land
with obsolescent buildings incapable of producing an economic rent but which
are suitable for redevelopment, the residual method may be used. The current
rent, where the existing property is let, is unlikely to be a guide to value; similarly,
it is equally unlikely that a similar site or group of buildings have been sold
recently that would provide even a rough indication of what the land and
buildings are worth.
In these circumstances, the valuer tends to mimic the market; that is, the
possibilities of developing or redeveloping the site are explored to determine
whether a viable use can be found for the site which would offer a means to value
it. Generally, the approach would be to calculate the difference between the final
value of the redeveloped site and the cost of carrying out the development work,
sufficient to give the developer a satisfactory return that takes account of the risks
inherent in such an undertaking.
Determining whether land has a redevelopment or development value is
related to whether a satisfactory planning consent can be obtained for the
proposed scheme. Essential to the considerations is the understanding that not
only must planning requirements be met, but the scheme must also generate
interest and demand for it to sell either as an investment or for owner occupation
upon completion. Apart from any novel ideas regarding what might be suitable
and profitable, there will be general views as to the type of development suitable
for the site and the immediate area.
One of the considerations is that a sizeable site may be developed in many
different ways and for different uses, subject always to planning consent. Where
the site is large enough to allow for internal access roads and some mixed use, a
tentative layout is central to the investigations necessary to make a bid for the
site.
IS,
1e
114 The residual method
Factors affecting value
As indicated above, many factors could influence any proposals for development
and consequently the value of the land. These include:
• the area, shape and contours of the site
• the existing road frontage and ease of access, including any apparent problems
• the location of the site and its suitability and accessibility for the use or uses
proposed
• the proportion of the site that may be developed in relation to the total site
area. Any proposals would have to take into account service ducts, main
sewers, easements, overhead power cables and physical features such as
slopes, flood plains and the nature of the subsoil
• the geology and soil and its effect on additional costs of foundations and
substructures
• any planning considerations such as the likelihood of restrictions on hours of
business, height of buildings, community infrastructure levy, highway
improvements, building materials to be used and similar considerations
• statutory and other protection of the existing buildings. In England and
Wales buildings may be listed as being of architectural or historic importance
or they may be susceptible to listing. Any such designation may affect the
layout and external appearance of any new buildings.
This list is illustrative, not exhaustive, but it indicates the types of problem and
the probable delays associated with each item. It also indicates the requirement
for painstaking enquiries and preparation to avoid likely problems.
The basic approach
In essence, the method is a cost-based approach which is then related to a final
value to test the viability of any development proposal. The procedure for
determining site value is illustrated in Figure 7.1; alternatively, where the cost of
the land is known, the procedure is shown in Figure 7.2.
VALUE ON COMPLETION OF DEVELOPMENT
less
COSTS AND DEVELOPER‘S PROFIT
leaves
SURPLUS FOR SITE PURCHASE
Figure 7.1 Residual valuation: basic approach to calculation of site value
CONSTI
Figure 7.2 Residual vs
Criticisms
The approach is ru
manipulated to sue
overreaction, partie
development or ree
similarly interested
likely to fail when e
of value is likely to
For a developer to b
completion and co
attempting to assest
Where the criti:
theoretical exercise
and the value will I
The bidding mar
In the normal situat
developers, investc
purposes of redeve
deductive process,
the completed proj
difference betweer
carrying out the sel
, make on the basis e
lower bids reflectn
borrowing, or the e
method has the att
because the inputi
developer or btddei
developers are con:
,
lent
ems
uses
site
lain
I as
md
s of
Nay
md
nce
the
md
ent
nal
for
of
The residual method 115
VALUE ON COMPLETION
less
CONSTRUCTION COSTS AND SITE PURCHASE COSTS
leaves
BALANCE FOR DEVELOPER‘S PROFIT
Figure 7.2 Residual valuation: basic approach to calculation of developer’s profit
Criticisms
The approach is not without its critics. It is claimed that the inputs can be
manipulated to such an extent that any result can be achieved. This is an
overreaction, particularly when the purpose is to acquire land and/or buildings for
development or redevelopment in the light of competition from other parties
similarly interested. Too Iowan offer on the part of the potential purchaser is
likely to fail when other bids are received, whilst an owner with an inflated view
of value is likely to experience a dearth of interest and a failure to find a buyer.
For a developer to be interested, there must be a reasonable prospect of a profit on
completion and compensation for taking on specific risks, particularly that of
attempting to assess the future market.
Where the criticism may be justified is where the assessment of value is a
theoretical exercise to establish a value for acquisition where there is one buyer
and the value will not be tested in the market.
The bidding market for development land
In the normal situation, the property development market is composed ofbuilders,
developers, investors, speculators and others wishing to purchase land for the
purposes of redevelopment. They normally arrive at the value of the site by a
deductive process and their principal concern is to decide whether the value of
the completed project justifies all the costs of completing the development. The
difference between the value of the completed development and the costs of
carrying out the scheme represents the maximum bid the developer can afford to
make on the basis of the inputs used. Different developers may arrive at higher or
lower bids reflecting levels of efficiency, costs of overheads, the firm’s cost of
borrowing, or the desire to purchase a particular piece of land. Thus the residual
method has the attributes of a ‘calculation of worth’ rather than of market value,
because the inputs into the valuation are often highly specific to a particular
developer or bidder. The matter of worth versus market value is important. When
developers are considering a bid, they need two points of reference: worth, which
116 The residual method
is a calculation showing what they can afford to pay, and market value, which is
what they will have to pay to secure the site from other competing bidders.
The unique calculations made by each interested party will result in a range of
possible bids. The greater a developer‘s efficiency the higher the residue, or
resulting value, although not all of the efficiency savings will necessarily be used
to purchase the site. A developer should be able to make the winning bid without
sacrificing the whole of the increment attributable to the company’s greater
efficiency and will consider the likely bids of competitor others together with the
benefits of purchasing the site. Except in auction situations, it is possible to make
an initial offer to establish interest and possibly obtain feedback from the vendor
before negotiations begin.
For example, a developer may have calculated a residual value of, say, £1
million for an office development site but would be ill-advised to make an offer
until the market price was known. If the site was then placed on the market at
£850,000 the developer would be in an advantageous bidding position and may
also obtain it for less through the negotiating process. Conversely, had the asking
price been fixed at £1.1 million, a purchase at this price would eat into the
developer’s profits based on the calculations made. Worth and value therefore set
the parameters within which to bid, and where worth is lower than market value
the developer may decide to withdraw from the transaction altogether.
If the deal is abandoned it would be wrong to conclude that time had been
wasted. On the contrary, the exercise has indicated to the prospective developer
that the particular site should be avoided unless there is a realistic prospect of
either reducing costs or intensifying development to increase the value of the
completed project. If negotiations remain open with the vendor then the
developer may eventually secure the site at the higher price but with a more
profitable scheme in the end. This is an example of the way in which development
proposals are shaped and refined.
The process of valuation
Having collected as much information as possible about the site, locality and
costs, the valuer will make use of it in determining the residual value of the site.
However, it should be highlighted that the available information may be used to
produce results other than site value. For example, the land may already be in the
ownership of the developer or its price may already be fixed, in which case the
developer may wish to determine the available spend for construction works or
may calculate the minimum value of the completed development to justify the
payment of a certain land price.
The main constituents of the development process are shown in Figure 7.3,
whilst a typical allocation of costs is illustrated in Figure 7.4.
Preliminaries
Appoint professional team
Finalize plans
Invite tenders
Arrange finance
(long/short term)
OR
Find buyer
Figure 7.3 The main comp
Figure 7.4 Allocation of rna
Value on completion
The first step is to estim:
capital value. of the con
commercial property the
and multiplied by the ren
tum is multiplied by the y
been identified through t
involves the investment
I
The residua! method 117
Construction
Post-construction
Preliminaries
APpoint professional team
Define building
programme
Finalize lettings (access to
tenants for fitting out)
Finalizeplans Site preparation Organize OR sale
Invite tenders Take up long-term finance
Construction work
Make all payments due in
respect of development
Arrange finance
(long/short term)
OR
Find buyer
Advertise press and
onsite
The main componentsof the developmentprocess
he
ire
-nt
nd
rte.
lto
the
the
Figure 7.4 Allocation of main development costs
; or
the Value on completion
The first step is to estimate the gross development value (ODY), which is the
capital value of the completed development. If the development involves a
commercial property then the floor area of the proposed building is calculated
and multiplied by the rent per square metre to find the total rental value. This in
tum is multiplied by the years’ purchase in perpetuity at an all-risks yield that has
been identified through the analysis of the market. This part of the assessment
involves the investment method and is normally straightforward, involving a
7.3,
il
, ”
118 The residual method
market rent (or rack rent) capitalized in perpetuity for a freehold valuation or, if
leasehold, for the length of the ground lease available (or more typically 125
years). Where the interest is leasehold, the frequency and nature of rent reviews
if any, of the head leasehold interest will be relevant to the yield, as will the effec~
of any unusual provisions in the lease that fetter the developer’s ability to manage
and operate the development in the best way. This is because it is assumed that
the development will be sold on completion and, accordingly, the estimated costs
of transfer are deducted from the final valuation.
If the proposed scheme involves residential development then the value on
completion is calculated by estimating the sale price of each house or apartment.
The estimated sale prices will vary depending on the range of accommodation
proposed. Typically one would expect different sale prices for houses with four,
three or two bedrooms and similarly distinct prices for apartments of different
sizes. In addition, the estimated sale prices should also reflect other distinctive
features such as the size of any garage or the number of car parking spaces provided
with each property. Analysis of the residential market in the locality should
provide sufficient comparable evidence for the valuer to make a reasonable
estimate of the property values upon completion. Once this data is collected then
the GDV for a residential scheme is calculated by adding together all the
estimated sale prices of each residential unit. In the United Kingdom it is usually
assumed that the majority of properties in a private development scheme would
be sold to separate owner-occupiers with, sometimes, a small proportion allocated
for sale to a not-for-profit housing association or equivalent.
Mixed scheme developments may involve a combination of different types of
commercial property or may involve a combination of commercial and residential
property. In the case of the latter, the GDV is calculated using a combination of
the investment method and the comparative methods outlined above.
Development costs
When estimating development costs, the initial exercise is likely to consist of a
broad estimation of the main costs and a view as to whether the completed value
of the development is likely to be sufficient to justify further investigation.
The main constituents of development costs are discussed below.
Building costs
The valuer should allow a sufficient sum for building costs and contingencies,
especially since these have a ‘knock-on’ effect on other costs (for example, fees
and finance). Too generous an allowance, on the other hand, may make the
residual amount uncompetitive and result in failure to purchase the site. At this
stage a good deal of information, expertise and experience is called for.
Details of building costs will eventually be determined when a contract is
signed with the appointed contractor. Meanwhile, information will be gathered
from a range of available sources. The developer might provide figures based on
its own cost experienc
of price information;
price subscription serv
Surveyors (RICS). Ar
is given in Appendix
The proposed deve
total letting space. I
standards laid down il
The calculations sl
clearance and prepar
environment, costs IT
prerequisite of planni
of a quantity surveyo
expertise to advise at
Professional fees ano
Professional fees cha
account for 12-15 pe
of the building. Chari
and building regulati
Site acquisition, tl
will involve fees, eh
contribution to the p
for prospective tenan
of short-term finance
developer is registen
recoverable. Charitu
regard to VAT, and
Contingencies
An allowance in the
is made to cover th
where significant are
Short–term finance
Short–term finance i
for professional sen
architect. The moni
Three distinct elem(
building costs, profe
period following co
refinanced) .
!
The residual method 119
[rs own cost experience. Price books such as Span’s or Laxton’s give a wide range
of price information; the Building Cost Information Service (BCIS) provides a
price subscription service under the auspices of the Royal Institution of Chartered
Surveyors (RICS). An edited extract from RICS BuildingCost Information Service
is given in Appendix A.
The proposed development will be measured, typically off plan, to reflect the
total letting space. It is important for the measurements to conform to the
standards laid down in the RICS Code of Measuring Practice (CMP) (2007a).
The calculations should also include associated items such as demolition, site
clearance and preparation where relevant. With an ever-growing emphasis on
environment, costs may include the remediation of ground contamination as a
prerequisite of planning permission. The valuer may be able to obtain the advice
of a quantity surveyor; alternatively, the development team may have sufficient
expertise to advise at this stage.
m it is usually
.cherne would.:
tion allocated
Professional fees and charges
Professional fees charged by architects, quantity surveyors and engineers might
account for 12-15 per cent of the construction cost depending on the complexity
of the building. Charges are levied by the local authority for planning applications
and building regulation approval.
Site acquisition, the development itself and any sale of the completed scheme
will involve fees, charges and expenses. The developer may agree to make a
contribution to the professional fees of other parties (for example, as an incentive
for prospective tenants) and will be responsible for any arrangement fee in respect
of short-term finance. Stamp duty land tax (SDLT) will be payable. Where the
developer is registered for VAT the amount paid can be ignored, as it will be
recoverable. Charities and certain other groups are in a different position with
regard to VAT, and it may be necessary to provide for all or some of the charges.
erent types of
nd residential
rrnbination of
rve.
o consist of a
npleted value
igation.
Contingencies
An allowance in the region of 5 per cent of the combined building costs and fees
is made to cover the cost of unexpected items. The allowance may be higher
where significant areas of cost have not been resolved in the early stages.
ontingencies,
example, fees
lay make the
e site. At this
for.
a contract is
II be gathered
ures based on
Short-term finance
Short-term finance is required to provide working capital to acquire the site, pay
for professional services and meet interim and final certificates issued by the
architect. The money is borrowed and interest paid for the period of the loan.
Three distinct elements require finance: the land acquisition; the construction (the
building costs, professional fees and incidental expenses) and the void period (the
period following completion of construction until the development is sold or
refinanced).
I ‘I’I’ I
li I;
120 The residual method
Figure 7.5 Interest incurred during the stages of development – shown shaded
Land acquisition
Borrowing for the land purchase will be a constant part of the total finance
package to cover the site purchase, fees and associated preliminary costs. This is
shown diagrammatically in Figure 7.5. Where there is a void period, the land
element together with the construction costs need to be financed for an uncertain
period beyond physical completion of the works.
Construction
Borrowing for the construction phase requires progressive access to the total loan
negotiated to enable payments to be made as costs are incurred. Where it is
possible to predict the rate and timing of expenditure, a more sophisticated cash
flow approach can be adopted. Otherwise, an accepted ‘rule of thumb’ is to
calculate the total interest on the build costs and to assume that, on average, half
that amount will be borrowed over the period. This allows for the fact that not all
of the loan will be drawn down at once but at intervals. This approximation
provides a quick estimate of interest payments where the detailed construction
and project plan are not available.
Void period
In the case of a commercial property development, once it is completed the
premises are available for occupation. However, there is no certainty that a
tenant or tenants will have been found by this stage so it is prudent to allow a
void period by the end of which the building will be occupied. Many commercial
developments are speculative, built in the belief that tenants can be found for the
space created. Where possible, the developer will agree sale terms with an
institution or other investor to take effect once the development is complete and
fully let.
£ Marketing the deve
but it is unlikely that
occupation. Until thi:
required to cover all
charges.
Where short–term f
similar lender to meei
property development
1).egotiated may also ré
development cost, th.
track record and fina
developer’s‘ best bid f(
valuation even if a de
of its own funds. This
in the valuation and
effectively paying twi
event that there is sti
anxious to secure an
expected return on i
item.
Where an investm
development, it may
Advertising and ma
Advertising and mal
high and not enti
anticipated, it may
increase the budg
advertisements in r
site boards, show b
and other publicity
also provides a flexil
and a budget shoul
queries and expressi
proposed campaign
as a percentage of
considerable experi
– Agency fees
In the case of a cc
units in the camp
entity. Where joir
Agency fees also a
ce
is
:ld
in
an
is
sh
to
alf
111
m
m
le
a
a
al
m
id
The residual method 121
Marketing the development will take place before construction is completed,
but it is unlikely that all the space will be let by the time that it is ready for
occupation. Until this point is reached, short-term finance will continue to be
required to cover all the costs of land purchase, construction fees and other
charges.
Where short-term finance is required it is usually arranged through a bank or
similar lender to meet the developer‘s need to borrow funds. The perception of
property development is that of a higher-risk activity. However, the interest rate
negotiated may also reflect the size of the loan, the proportion it bears to the total
development cost, the existence of a pre-letting or forward sale, and indeed the
track record and financial reliability of the developer concerned. In assessing a
developer‘s best bid for the land, finance costs should be included in the residual
valuation even if a developer is acquiring the land and financing construction out
of its own funds. This ensures that the opportunity cost of that money is reflected
in the valuation and avoids the calculation of a bid price where the developer is
effectively paying twice for the land and thus bidding away potential profit. In the
event that there is strong competition for a site that the developer is particularly
anxious to secure and develop, the firm may choose to forgo some or all of the
expected return on internal funding by adjusting the amount included for this
item.
Where an investment fund is sufficiently interested in acquiring the completed
development, it may be the institution that also provides the short-term finance.
Advertising and marketing
Advertising and marketing are crucial to the development. Publicity costs can be
high and not entirely predictable; where lettings are not taking place as
anticipated, it may be necessary to re-launch the marketing campaign and
increase the budget by a significant amount. Expenditure may include
advertisements in newspapers and magazines, radio and television advertising,
site boards, show buildings or suites, on-site negotiators, printing of brochures
and other publicity material, press releases and general launch costs. The Internet
also provides a flexible and effective advertising medium offering extensive cover,
and a budget should be allocated for the monitoring of, and response to, online
queries and expressions of interest. The allowance is best estimated by costing the
proposed campaign and adding a margin; it is inappropriate to calculate the cost
as a percentage of the capital or rental value unless the developer has had
considerable experience with the particular type of development.
Agency fees
In the case of a commercial property agency fees are incurred in the letting of
units in the completed development and the investment sale of the tenanted
entity. Where joint agents are appointed, the total costs are likely to be higher.
Agency fees also arise upon the sale of residential properties to owner-occupiers
I’
–II !I,
~ . I
, ”
122 The residual method
or investors. The sale of a residential property to an investor does not normally
carry the expectation that the agent wil! find a tenant for the purchaser ahead of ‘
sale.
Fees wil! usually be expressed as a percentage of the estimated rental value used
in the ODY. Investment sale fees represent the purchaser’s prospective costs of
acquisition, to include an agent, solicitor and stamp duty, with investment sale
fees amounting to some 6 per cent of the! sale price. The purchaser deducts the
sale fees from the ODV to arrive at the net price to be paid.
Other costs
Other costs may be incurred in compensating outgoing tenants or in winning the
consent of occupiers of adjoining property (for example, infringements of rights
of light or allowing a crane to traverse the air space). In England and Wales all
letting and sales transactions will be liable to SDLT.
Developer’s profit
The developer‘s profit and risk will be shown as a cost of the development process.
The amount charged may be a percentage of the net capital value of the completed
development or a percentage of the total costs involved, the allowance typically
ranging from 10-25 per cent.
The level of profit and risk will be judged on the complexity of the proposal,
the volatility of the outcome, the prestige of association with the particular
development and the extent to which the profitability may be assured (possibly in
part by a prearranged sale to a fund or investor).
Land value
The gross amount available for land purchase is found by deducting the gross
development costs from the net development value.
The remaining figure, the surplus, includes not only the cost of the site, but
also fees, SDL T and finance charges in acquiring the site and holding it until the
development is fully let and income-producing and thus capable of disposal in the
investment market.
The net amount after deduction of costs is not a value in the strict sense,
merely an indication of the maximum bid the particular developer can afford to
offer for the site if the required returns are to be achieved on the basis of the
information available.
The following example demonstrates the whole process in relati:on to a
proposed office development. The accompanying commentary gives a step-bystep explanation of the valuation.
Example 7.1
A developer wishes to acquir
permission has been grantee
internal floor area (GIA) of
arranged over three floors sen
provided for 20 vehicles. The
region of £150 per square mel
cent and the completed dt
Construction costs are estirr
period of 12 months. It is e:
within three months of comp
Advise the company as to ;
allowing for profit of 15 per c
Estimation of site value
Estimated rental value 1,200 sq.rn
Years’ purchase in perpetuity @ 6%
Gross development value
Deduct costs of sale @ 5%
Net proceeds of sale
Gross development costs
Gross area 1,500 sq.m @ £:
Surface car parking
Contingencies @ 5%
Professional fees@ 15%
Short-term finance @ 9% f(
On construction costs (aver:
On fees (average 75%)
On total cost + finance over
period (3 months)
Agency fees
Fees @ 10% of rents
Marketing campaign
Total costs of development
Developer‘s risk and profit
15% of GDY after costs
Surplus available for land p
Present value £1 for 1.25 ye,
Gross site value
Deduct site acquisition cost1
Maximum available for site
The residual method 123
Example 7.1
A developer wishes to acquire a site in a provincial city where outline planning
permission has been granted for the erection of an office block with a gross
internal floor area (GlA) of 1,500 square metres. The accommodation will be
arranged over three floors served by two passenger lifts and surface parking will be
provided for 20 vehicles. There is a steady demand for office suites at rents in the
region of £150 per square metre. Short–term finance is available at a cost of 9 per
cent and the completed development should show a yield of 6 per cent.
Construction costs are estimated at £1,000 per square metre with a building
period of 12 months. It is expected that the whole of the space should be let
within three months of completion of building works.
Advise the company as to the maximum price it can afford to pay for the land,
allowing for profit of 15 per cent of the development value.
Estimation of site value
£ £ Note
Estimated rental value 1,200 sq.m @ £150 per sq.m £180,000 a
Years‘ purchase in perpetuity @ 6% 16.6667 b
3.
d
Gross development value
£3,000,006 e
Deduct costs of sale @ 5%
£150,000 d
Y Net proceeds of sale
£2,850,006 e
1, Gross development costs
rr
Gross area 1,500 sq.m @ £1,000 per sq.m £1,500,000 }
n
Surface car parking Contingencies @ 5% |
£100,000 £80,000 £252,000 |
£1,680,000 g
Professional fees @ 15 % £252,000 h
£1,932,000
Short-term finance @ 9% for 1 year
is On construction costs (average 50%) £75,600 j
On fees (average 75%) £17,010 lc
It e |
On total cost + finance over void period (3 months) |
£44,092
e
£136,702 m
Agency fees
,
Fees @ 10% of rents £18,000
–,
O
Marketing campaign £20,000 £38,000 n
e
Total costs of development £2,106,702 o
Developer’s risk and profit
a
15% of GDV after costs £427,501 £2,534,203 p
t– Surplus available for land purchase
£315,803 q
Present value £1 for 1.25 years @ 9%
0.8979
Gross site value
£283,552
Deduct site acquisition costs @ 6%
£16,050
Maximum available for site purchase – net
£267,502 v
124 The residual method
Commentary
The following notes refer to the reference letters in the example, providing
additional information where necessary.
Notes a–v
a The rent is arrived at from a consideration of current market comparables
but will not be determined until the scheme is complete, so is referred to as
an estimated rental value. As offices are measured for letting purposes on a
net internal area (NIA) basis in accordance with the RICS Code of Measuring
Practice (2007a), the given GIA of 1,500 sq m has been reduced, in this case
by 20 per cent, to 1,200 square metres. This gives a net to gross ratio of 80 per
cent, which is a reasonable estimation for a modern construction. Too much
of a reduction from the GIA could suggest that there is an element of waste
or poor design and that the plans should be revisited.
b The yield is determined by reference to recent sales of similar new or modern
office buildings in comparable locations. The site is assumed to be freehold
and so it is valued in perpetuity unless the development is subject to a long
lease.
c The GDY is the best estimate of capital value of the completed development.
It is calculated by multiplying the total estimated rent by the years‘ purchase
in perpetuity. There is an element of risk in the assessment since the building
is not yet available to let and the market for office accommodation is liable
to change. A pre-let would greatly reduce that risk although at the expense
of possible increases in rental value during the build period. Risk is reflected
in the yield adopted for the years’ purchase multiplier. No projection of
rental values is used; the valuation is on the basis of current market rental
information.
d | Sale costs (agents‘ and legal fees and disbursements) are deducted from the capital value of the completed scheme, or GDY, on the assumption that the investment will be sold on completion or once all the suites are let. This is calculated as £3,000.006 x 0.05 = £150,000. The capital value out of which all costs and profit must be met. Building costs are assessed as accurately as possible on the basis of the GIA |
e f |
using the information available at the time of valuation. Initial costs may be
assessed on the basis of current cost, and useful sources of building cost
information are Span‘s Architects’ and Builders’ Price Book and the BeIS cost
index published by the RICS. However, the valuer of a large scheme will
probably take advice from a quantity surveyor who will be in aposition to
refine the cost estimates as the design progresses. It is unlikely that all the
details will have been settled at the time when a bid for the land is being
prepared, which suggests that a margin should be allowed for contingencies;
once the bid has been made and accepted, any additional costs will reduce
the level of developer‘s profit.
It is usual to allow process, taking ac |
g |
venture. The allo
development but t’
costs.
h | An estimate of pro range of profession: |
involved include tl
engineer and othe
figure usually in th
complex scheme, s
retained facade, n
structural or civil ei
be higher still. Th
are calculated as
This is the sub-tot
developers will asse
value of the campit
The developer wil
estimated based 01
building costs for tl
undertaking, the It
internal funds are l
available for other
established and the
from the proceeds
calculated as:
k A substantial part
commences and th
calculate the inter
Accordingly this fig
Where it is anticip
after completion, fi
estimated at three :
whole of the amour
items i, together ‘
professional fees k. ‘
!
The residual method | 125 | |
—t ,_ | is usual | to allow a sum for contingencies as a normal part of the building |
~r J:C ocess ,a t k’Ing account of the uncertamtie .‘ s attach’mg to any butild:ing
..;,.Tell-tul re. The allowance depends on the uncertainties in any particular
deve op ment but tvpica . 1ly would be 3-5 per cent on the sumof constructIon .
costs.
An estimate of professional feesshould be included to allow forinput from a
“,:3-ng~ of professionals involved in thedevelopment process. The professionals
l.DV~ | ved include the architect, quantity surveyor, mechanical and electrical |
~g1neer | and others as required. The fee estimate tends to be a composite |
gure Usually in the range of 12-15 per cent of the total building costs. A c0ITl_plex scheme, say one involving demolition and redevelopment behind a |
|
reta1ned | facade, might require the input of other professionals such as |
~ru~~ural or civil engineers and the feeestimate insuch circumstances might | |
e | 19her still. This example assumes a straightforward scheme and so fees |
are calculated as
0.15 x £1,680,000 = £252,000.
!hiS is the sub-total of the major cost items. It is the figureupon which
e~elopers will assess their profit margin if they choose not to base it on the
‘Th ue of the completed development scheme.
~ developer | will incur interest charges for building finance, which is | |
est1m b’l at e d bd’ ase on expenence as an average amount of one haIf of the u~ ding costs for the whole of the building period. As development is a risky |
||
un | ertaking, the level of interest charged is likely to reflect this. Where | |
~nt~rnal funds are used, there will be an opportunity cost as they will not be val~able for other activities of the developer. The lending terms should be |
||
~sta | hshed and the total interest will be compounded and paid at the end | |
, | rolm the proceeds of sale. In this example, interest on building cost is | |
ca culated as: | ((1.09)1-1) | x (£1,680,000 x 0.5) |
0.09 x £840,000 = £75,600.
A sUbstantial part of the professional fees are earned before construction
co~rnences and the interest cost is calculated to reflect this; it is usual to
~ cUlate the interest on professional fees on the basis of 75 per cent.
cCordingly this figure is calculated as:
((1.09)1-1) x (£252,000 x 0.75)
0.09 x 189,000 = £17,010.
~here it is anticipated that the building will not be fully let immediately
a ter completion, finance will be required for a further period (in this case
est’ hlmated at three months). The cost of finance at this stage becomes the
wale of the amount outstanding which includes the sumof the major cost
Items i, together with the compound interest on building costs j and
professional fees k. This element is calculated as follows:
q
r
,
I;.
s | This is the sum available for site purchase and site acquisition costs. It is found by multiplying the surplus for land purchase by the PV multiplier (i.e. q x r). Site acquisition costs of 6 per cent of the site bid. To calculate this v must be |
t |
I ,
126 The residual method
((1.09)°25 –1) x (£1,932,000 + £75,600 + £17,010)
0.0218 x £2,024,610 = £44,092.
Note that the compound interest is calculated for 0.25 years, which is the
decimal representation of the three-month void period. However, interest
on the land element is dealt with separately (see note r below).
m The sub-total aggregates all the finance costs.
n Ideally, an agent should be engaged early in the development process and a
fee structure and marketing budget established. The building must be let to
tenants in order to create a saleable investment. The services of a commercial
property agent will incur a fee, usually based on a percentage of the first year‘s
rent together with the payment of disbursements for advertising and the
production of particulars or brochures. Commission at a rate of 10 per cent
has been allowed for in this example together with a marketing budget of
£20,000.
o p |
The total estimated costs of the development are shown. The developer’s reward for assuming the risk of development is often assessed |
as a proportion of the ODV or of the total costs involved. The provision will
vary according to the complexity of the development and the developer‘s
desire to be associated with it. In this example the developer‘s profit has been
calculated at 15 per cent of the net proceeds of sale (i.e. ODV minus costs):
£2,850,006 x 0.15 = £427,501
The total development costs are deducted from the net proceeds of sale to
show the surplus available for site purchase including fees, costs and interest
payments.
The interest incurred in acquiring the site and holding it until the investment
is sold must be deducted, leaving the amount available for site purchase and
costs. This is done by applying the present value (PV) @ 9 per cent for the
total development period, which includes both the construction and the
void periods. Accordingly, the PV applied here is the PV @ 9 per cent for
1.25 years, i.e. 1/ (1.09)1.25 = 0.8979.
deducted from the gross site value. To calculate this figure, find the net site
bid v and deduct it from the gross site value to find the acquisition costs. See
paragraph v to see how to do this.
v The net sum available for site purchase must not include site acquisition
costs; these costs must be deducted from this same net sum. To solve this
conundrum the valuer must find the inverse multiplier to apply to the gross
site value to find the net site value. Accordingly, the simple formula 1/1 +
0.06 calculates the inverse multiplier, where 1 + 0.06 represents the site
value (1) plus the estimated percentage sale costs (0.06). When the inverse
of 1.06 is foul
reduce the gn
cent. The cal,
The result (the ‘re
payment of all site
the maximum av
calculation of wo
have different vieeventual market v
enabling a first bic
Where land is a
There are occasior
the developer, eid
holdings of an in‘
recent purchase p
redevelopment is ,
included in the ca
developer’s profit.
whether the profit
Example 7.2
The facts are as g
asking price of £2
would show a pro
take account of th
Gross development val
Estimated rental value
Years’ purchase in perp
Gross developr
Deduct costs of
Net proceeds o
Gross developr
Gross area 1,50
Surface car pari
Contingencies‘
Professional fee
is the
lterest
and a
let to
ercial
year‘s
d the
: cent
~et of
essed
1will
Jper’s
been
ists) :
Je to
‘erest
nent
:and
r the
. the
t for
It is
(i.e.
st be
site
See
tion
this
ross
II +
site
erse
The residual method 127
of 1.06 is found (by dividing 1.06 into 1) then the resulting multiplier will
reduce the gross site value s to a net site value v that excludes costs at 6 per
cent. The calculation is performed as follows:
1/1.06 = 0.9434
0.9434 x £283,552 = £267,502.
The result (the ‘residual value’) is the maximum available for site purchase after
payment of all site acquisition costs. It should be emphasized that the amount is
the maximum available and not necessarily the value. It may be seen as a
calculation of worth to the particular developer; other interested parties may
have different views as to the precise form of the development, the costs and the
eventual market value. At this stage, this result indicates a basis for negotiation,
enabling a first bid to be made to gauge the reaction of the vendor.
Where land is already owned
There are occasions where the land and buildings are already in the ownership of
the developer, either through a recent acquisition or because they are part of the
holdings of an investor who now wishes to redevelop. The book value or the
recent purchase price will be available as part of the exercise to test whether a
redevelopment is viable. All costs, including stamp duty and interest, can then be
included in the calculations, in which case the surplus, if any, will represent the
developer‘s profit. At this point, the developer will be in a position to decide
whether the profit is sufficient to justify proceeding.
Example 7.2
The facts are as given in Example 7.1 except that the land is available at the
asking price of £255,000. The developer wishes to know whether the proposal
would show a profit. The previous calculations in Example 7.1 are adjusted to
take account of this additional information.
Gross development value on completion of scheme
Estimated rental value 1,200sq.m@£150per sq.m
Years’ purchase in perpetuity @ 6%
Gross development value
Deduct costs of sale @ 5%
Net proceeds of sale
Gross development costs
Gross area 1,500 sq.m @ £1,000 per sq.rn Surface car parking |
£1,500,000 £100,000 |
£
£ | Note a b e |
£3,000,006 | |
£150,000 d | |
£2,850,006 | e |
£180,000 16.6667 }
Contingencies @ 5%
Professional fees @ 15 %
£80,000 £1,680,000
£252,000 £252,000
£1,932,000
g
h
128 The residual method
Short-termfinance@ 9% for 1 year
On construction costs (average50%) £75,600
On fees (average 75%) £17,010
On total cost + finance over void
period (3 months) £44,092
£136,702
Agency fees
Fees@ 10% of rents £18,000
Marketing campaign £20,000 £38,000
Total costs of development £2,106,702
Add price required for site £255,000
Acquisition costs @ 6% £15,300
£270,300
Add short-term interest 1.25 yrs @ 9% £30,743
m
n
o
ii
iii
I I
I
Profit available on basis of fixedprice for site
Profit as a percentage of GDY after costs
£2,407,745
£442,260
15.52%
Commentary
The calculations have been adjusted, in particular to take account of the
information given regarding the price of the land. The key difference in Example
7.2 is that the developer’s profit figure has been omitted and in its place the land
cost and associated expenses are included. By so doing the bottom line is no
longer the residual land value but instead it is the amount available to reimburse
the developer for risk and profit.
Notes i–iii
Here the known net land cost of £255,000 is included in the calculation.
ii | The acquisition costs of 6 per cent are calculated on the net land cost, thus: £255,000 x 0.06 = £15,300. |
iii The interest charges on the loan to cover the cost of the land plus the
acquisition fees are calculated over the whole of the IS-month development
Ii and letting period.
Ii
I’
II
I
I.
jl
Ir
J
II
Ii(
!, ;1
I I
rl
Measured as a percentage of GDV it is 15.52 per cent, only slightly more than
specified by the developer in Example 7.1. On paper, the developer will make an
additional £14,759 profit.
Both examples may be criticized for the assumptions necessarily made. The
residuals both assume that most borrowings are evenly spread throughout the
build period and that costs are incurred from day one, neither of which is true in
practice.
A cash flow approach wo
of cash flows that may ha–
. short-term interest rates an
Discounted cash flow
The following example USE’
. to the exercise, in that the
nearly to where they are
unexpected items that add
development process has e
Example 7.3
A developer has identitie
blocks that will appeal to
the whole space in one of
value on the basis of the f
Costs by quarters
Year 1
Quarter 1 | –£1: |
Quarter 2 | –£1 |
Quarter 3 | -£1 |
Quarter 4 | –£1 |
Lettings will commence
be as follows:
Lettings by quarters in Ye
Quarter 1 (one unit)
Quarter 2 (three units)
Quarter 3 (four units)
Quarter 4 (four units)
Building costs are expe:
let or sold on complet»
made for any increase
case of a lease; any ir
sufficiently certain as t
The development is
%
le
le
cl
o
e
The residual method 129
A cash flow approach would enable the valuer to be more precise in the timing
of cash flows that may have a significant effect on viability, especially where
. short-term interest rates are high or development periods long.
Discounted cash flow
The following example uses discounted cash flow in an attempt to add precision
to the exercise, in that there is an opportunity to show inputs and outputs more
nearly to where they are incurred. It cannot, of course, take account of those
unexpected items that add to the cost once the land has been purchased and the
development process has commenced.
Example 7.3
A developer has identified a site suitable for the erection of four small office
blocks that will appeal to local professional firms wishing to have occupation of
the whole space in one of the buildings. Provide an estimate of the maximum site
value on the basis of the following information:
Costs by quarters
Year 1 Year 2
Quarter 1 | -£135,000 | Quarter 1 | -£150,000 |
Quarter 2 | -£130,000 | Quarter 2 | -£164,000 |
Quarter 3 | -£145,000 | Quarter 3 | -£170,000 |
Quarter 4 | -£160,000 | Quarter 4 | -£190,000 |
Lettings will commence at the beginning of the second year and the rent roll will
be as follows:
Lettings by quarters in Year 2
Quarter 1 (one unit) Quarter 2 (three units) Quarter 3 (four units) Quarter 4 (four units) |
£15,000 £45,000 £60,000 £60,000 |
Building costs are expected to rise by 1 per cent per quarter. The buildings will be
let or sold on completion according to occupiers‘ wishes. No allowance has been
made for any increase in rental values, which would be fixed for a period in the
case of a lease; any increase in capital value is likely to be marginal and not
sufficiently certain as to include in the calculations.
The development is expected to show a yield of 7.5 per cent on sale.
130 | The residual method |
Finance is available at 2.5 per cent per quarter, compounded up to the end OlE | |
the development period in two years’ time. | . |
The developer requires a return on expenditure of 15 per cent of capital vallie
SOLUTION
Period | Development Inflation | Current cost with inflation –£136,350 –£132,613 –£149,394 –£166,497 |
Rental | Net cash | Quarter interest @2.5% 0.9756 0.9518 0.9286 0.9060 0.8839 0.8623 0.8413 0.8207 |
NPV |
(quarter) costs | @1% | payments flow | ||||
received | ||||||
–£135,000 –£130,000 –£145,000 -£160,000 –£150,000 –£164,000 –£170,000 –£190,000 |
1.0100 1.0201 1.0303 1.0406 1.0510 1.0615 1.0721 1.0829 |
-£136,350 | -£133,024 -£126,223 -£138,727 –£150,838 –£126,083 -£111,313 -£102,856 -£119,618 |
|||
2 3 4 |
£0 –£132,613 £0 –£149,394 £0 -£166,497 |
|||||
5 6 7 8 |
–£205,743 £60,000 –£145,743 |
–£157,652 £15,000 –£142,652 –£174,089 £45,000 –£129,089 -£182,263 £60,000 –£122,263
Sale of all units YP perp, 7.5% |
Total rents p.a. | £240,000 13.33333 |
£3,199,992 |
Deduct developer’s profit at 15% NPV |
£479,998 | PV@2.5% | 0.8207 | £393,956 £2,806,036 |
Summary
• The residual method is used where there is potential for development,
redevelopment or refurbishment.
• It enables a site value to be found without direct market evidence of value.
• The method simulates the approach taken by developers bidding for sites on
the open market.
• Development is a complex activity, dependent on a wide range of variables,
thus making the comparison method a much less suitable framework for
valuation.
• The rationale of the method is that the investment value of the completed
development less total construction and associated costs leaves a surplus with
which the developer can finance the purchase of the land including fees and
other costs.
• The input variables need to be carefully researched and considered to avoid
any knock-on effect throughout the calculations.
• The residual is highly flexible and can be used to determine the developer’s
maximum land bid or the profitability of a given scheme.
• The method can be criticized as being too simplistic in its approach to timing
of costs including finance charges – these matters may be alleviated by use of
a discounted cash flow model.
The 1
finan
Introduction
This method of
success or profits
value of the pre
where, for reasoi
the value of the
given that this
report and acco
these two aspeo
this book. This,
they may be use
the profit valuat
Businesses su>
restaurants and
valuation by Cal
business taking,
will also playa I
strict sense of tl
facilities and Sil
and so the profi;
properties.
Gathering ace
It is advisable t
and a well-est8
recent trading:
of the general h
for one financié
a business by I
financial trend!
accdunts may 1