EstateMaster Development Feasibility DF overview

Hello, this is Tim.

I'm from the EstateMaster
support desk in Sydney Australia.

And in this movie, I'm going to give you
a brief overview of the EstateMaster

DF software or EstateMaster
Development Feasibility.

In the context, DF is part of the EstateMaster
development suite.

And other products in this suite combine, and are
designed to provide a fully integrated solution.

And it's designed to give you a
clear picture of your project.

Both in projected figures and in actual figures.
On the other elements of the developers suite,

included DM which is Development Management,

and this is where you can track your
original and project budgets life with actuals.

And EstateMaster CC which is

Corporate Consolidation and reporting
which allows you to merge both

feasibility and management cash flows

and to track the stage developments or
company-wide portfolios.

But for as the EstateMaster software
talking about in this movie,

this software is designed to provide
developers, valuers, investors and

lending institutions a powerful flexible

and easy to use feasibility
and valuation tool.

So, what exactly does DF do?

Well, from an intuitive set of user inputs,

DF can evaluate development opportunities
and test project feasibility.

It can calculate key investment performance
indicators including the residual land value,

development profit and margin,
net present value and internal rate of return.

It can compare multiple options
side-by-side

to ensure that the best financial outcome
of the development site is achieved.

And you can analyze risk,

using sensitivity testing and
probability analysis.

And it will investigate flexible funding options,
and model joint venture arrangements.

When you first install EstateMaster,
you'll see a shortcut with EstateMaster logo

in your Windows toolbar.

Pressing this will present
EstateMaster welcome screen.

From here, you can not only open EstateMaster DF,

but any other EstateMaster package you may have,

or you can try a 14-day trial of EstateMaster
package you'd like to evaluate.

As well as some useful links to contact
the support desk, investigate training options

see what else news in EstateMaster,
and dozens of useful links.

To start the DF, just open an extra previously used
DF file from the list,

or press run DF for a new file.

Although EstateMaster DF is designed in the
microsoft.net platform

for faster processing in smaller file sizes.

You'll see it retained the familiar
spreadsheet interface,

including all the benefits
of being able to link cells,

insert your own worksheets,

and apply many other
functions and formulas found in Microsoft Excel.

It began with an intro sheet

which provides you with
a general description of your project.

Details like, the project name,
its address and suburb.

The input sheet is a single area of
the model where the majority of your

projects assumptions will be entered.

These assumptions will include your costs,

including your land purchase costs,

cost escalation, professional fees,
construction costs,

And whatever other costs may be
deemed to necessary.

In the input sheet,

It also where you entered your
revenue assumptions, such as

your sales and rental revenue escalation,

your selling and leasing costs,

as well as your actual sales themselves,

and any other possible income.

And finally, here is

where we set up our financial details.
This includes:

how much equity is involved in the project?

plus up to four
other layers of financing.

Once you entered your input assumptions,
they are then used by the model to automatically

generate the products monthly cash flow.

As well as a series reports including

your summary report which details
the project's revenue, costs,

all key performance indicators,

and a breakdown of your financing.

In the financials tab,

you have a profit and loss statement
which summarizes the products revenues,

costs and expenses incurred during a
specific period in time.

And you have a balance sheet

which summarizes the
company's assets liabilities and

shareholders equity at specific points
in time.

Going back to the input sheet,

we can generate gain chart.

This will provide us with a
visual representation of the

project timelines and assist you in
scheduling and timing your project.

DF also contains useful risk analysis
tools, such as sensitivity and probability testing.

Both of these provide
further analysis for your project

by looking at the effects
that changes in variables, such as

construction costs, construction time
periods, sales values, interest rates

rents and many other variables will have
on the key performance indicators for your project.

EstateMaster also features a number of
preferences that can be customized to suit your model,

such as the currency of your project,

the ability to adjust taxation details
and also several options to customize

the calculation of your key performance
indicators.

This allows you to change the way

of product works so does better
adjusted for your business or property type.

The input sheet is where we start off,

by entering the vast majority of the
assumptions used in the project.

For if you use, ourselves requiring input
a feature of input font.

Each section of the input sheet is completed the
same manner.

For each cost item, we input a description,

how the cost is calculated which can either
be a percentage,

a base rate per unit or both.

Next, we select an
applicable escalation rates.

These are defined by you
in the escalation table above.

Next, choose if your costs
require an S-curve,

and this can be defined by you
in the S-curve tab.

Then, you enter the month
of cost begins

and the amount of months it's been across.

And once you completed
these inputs, your costs will go

as a monthly expense in the cash flow sheet.

Once you enter all your costs,

there are four types of revenue we have to
consider and input.

There is a share revenue,

and other income in the input sheet.

And in addition, we can detail

rental income and capitalized sales in the
tenancy sheet.

It allows you to model all

types of development projects.

Cells can be entered
as an amount per unit

or as an amount per area.

Pre-sales or deposits can be modeled
by entering start and spend days

in the presales exchange section,

here displayed in green font.

Once those sales details are
entered into the model,

a sales rate will be generated.

Each sale will require a
customized land use code.

This is used to distinguish escalation and sales
commissions between different categories of sales.

And then, once you've entered
all these details,

these revenues will enter the cash flow.

Once our revenues completed,

we need to enter the details of our financing.

You can import equity
and up to four layers of finance.

Once these entered in EstateMaster,

DF will calculate all your
financing details for you.

Final input sheet, we choose
our hurdle rates.

This allows us to designate
a target internal rate of return

and target development margin.

Once all these details are entered into
the DF input sheet,

not only you get a detailed of
month by month cash flow

but you're also provided
with a summary sheet.

This provides you with a detailed
breakdown of all your costs and revenues,

as well as the ability to break
through further down by area or by load.

It also calculates all relevant key
performance indicators for your project,

including your development margin,

your net present value,
your internal rate of return,

and two Residual Land Values.

Below these key performance indicators, you'll
find the returns on funds invested table.

This allows you to evaluate your project
based on each layer of financing you're using.

Once you completed the input sheet,

and review the cash flow
and summary sheet,

you can store these feasibility ways, and compared
against previously input feasibilities.

By pressing the options and stages
button,

you can line up these feasibilities
side-by-side with others,

and compare the performance indicators.

On the consolidation sheet,
you can compare the revenue and cost items

and performance indicators side-by-side.

You can do this flap to eight different feasibilities,

or you can combine any cash flows stages
in a single project.

Then, the further analyze
your current project,

you can test its sensitivity changes in
various assumptions

and inputs in a statement of DF.

For example, if your
land acquisition cost was to increase by 5%,

or your construction costs were
to decreased 5%.

The EstateMaster sensitivity sheet

can display how those
changes will affect all your performance indicators.

And in the probability sheet,
you will be provided with a tool

that can give you risk assessment for your project

by signing multiple probability profiles
to variables in the sensitivity sheet.

Once you pressed
the probability analysis button,

EstateMaster will run multiple simulations and
eventually drive a probability range,

for your development margin and you IRR.

What's the key value proposition
with EstateMaster software

is its ability to allow the user to create their own
client specific reports and calculations.

It's from scratch or from importing existing Excel
spreadsheets and then dynamically

linking these reports to
or from EstateMaster data.

Here, you can see an example

of importing an existing Excel
spreadsheet and the unique ability to

link your own data to and
from EstateMaster.

If you modulating the stage development,

EstateMaster DF allows you
to allocate any cost a revenue to a specific stage.

Then, you can break down
those costs interviews on a stage by

stage basis in the staged
cash flow sheet.

The DF Stage Cash Flow sheet also allow you

dedicate global costs and
allocate those costs across your status basis

on a percentage basis.

And if you have
any repeated in specific types of projects.

Projects dedicated to specific
regions or specific financial structures.

You can create EstateMaster DF
templates.

In these templates, you can configure

your inputs, preferences, display
settings and even custom worksheets.

You can then use this template to start a
new project of that type with all your

preferences and
settings ready for you.

Beyond the use of EstateMaster DF,

once you've decided which feasibility
of going to proceed with,

you ready for EstateMaster DM
development management.

Simply import your feasibility DM
and then what approaches you applied.

It can compare your actual expenditure against
your original or any previous budgets.

As well, all EstateMaster packages come
with the option of using the estate

master enterprise database.

This is an SQL
database which allows users to store

all the development cash flows from any
state master project in one central location.

When using conjunction
with EstateMaster CC,

corporate consolidation reporting, it allows users
to generate consolidated or comparison

reports for selected cash flows, projects
or portfolios to calculate forecasted an

actual investment returns, including
development profit, internal rate of

return and net present value.

And finally, EstateMaster DF
has many tutorial options

when it comes to using the model.

For example, every title in the input sheet,
and in the tenancy sheet,

it will give you an instructional
dropdowns you click on the title.

On the very right-hand side of the toolbar,

you'll also see there's a Help
Menu.

But of course, if you can't find your

answers you can always visit
www.ticketmaster.com

for a comprehensive list of
training dates in your area,

or you can login to our client area,

and search for solutions database,
as well as few case studies,

and check out your license details.

But of course, you're
always free to contact myself

or any of my colleagues
at the EstateMaster support desk.

Please feel free try EstateMaster for yourself,

visit www.ticketmaster.com
to download a free 14 day trial software.

And if you have any further questions,

please feel free to contact us
at any of our global EstateMaster offices.