0:00:13.050,0:00:15.630
Hello, this is Tim.

0:00:15.630,0:00:19.960
I'm from the EstateMaster [br]support desk in Sydney Australia.

0:00:19.960,0:00:26.410
And in this movie, I'm going to give you[br]a brief overview of the EstateMaster

0:00:26.410,0:00:31.160
DF software or EstateMaster[br]Development Feasibility.

0:00:31.160,0:00:35.840
In the context, DF is part of the EstateMaster[br]development suite.

0:00:36.000,0:00:42.516
And other products in this suite combine, and are [br]designed to provide a fully integrated solution.

0:00:42.516,0:00:45.996
And it's designed to give you a[br]clear picture of your project.

0:00:45.996,0:00:50.806
Both in projected figures and in actual figures.[br]On the other elements of the developers suite,

0:00:50.806,0:00:53.720
included DM which is Development Management,

0:00:53.720,0:01:00.050
and this is where you can track your[br]original and project budgets life with actuals.

0:01:00.050,0:01:01.877
And EstateMaster CC which is

0:01:02.000,0:01:06.626
Corporate Consolidation and reporting[br]which allows you to merge both

0:01:06.626,0:01:09.830
feasibility and management cash flows

0:01:09.830,0:01:14.000
and to track the stage developments or[br]company-wide portfolios.

0:01:14.000,0:01:18.710
But for as the EstateMaster software [br]talking about in this movie,

0:01:18.770,0:01:22.976
this software is designed to provide[br]developers, valuers, investors and

0:01:23.000,0:01:26.993
lending institutions a powerful flexible

0:01:27.000,0:01:31.230
and easy to use feasibility[br]and valuation tool.

0:01:31.580,0:01:36.000
So, what exactly does DF do?

0:01:36.000,0:01:39.000
Well, from an intuitive set of user inputs,

0:01:39.000,0:01:44.453
DF can evaluate development opportunities[br]and test project feasibility.

0:01:45.000,0:01:50.396
It can calculate key investment performance[br]indicators including the residual land value,

0:01:50.396,0:01:57.660
development profit and margin,[br]net present value and internal rate of return.

0:01:57.660,0:02:01.760
It can compare multiple options[br]side-by-side

0:02:01.760,0:02:06.960
to ensure that the best financial outcome[br]of the development site is achieved.

0:02:06.960,0:02:09.347
And you can analyze risk,

0:02:09.347,0:02:12.577
using sensitivity testing and[br]probability analysis.

0:02:12.750,0:02:19.143
And it will investigate flexible funding options,[br]and model joint venture arrangements.

0:02:21.000,0:02:25.306
When you first install EstateMaster, [br]you'll see a shortcut with EstateMaster logo

0:02:25.306,0:02:28.140
in your Windows toolbar.

0:02:28.140,0:02:33.900
Pressing this will present [br]EstateMaster welcome screen.

0:02:34.000,0:02:36.000
From here, you can not only open EstateMaster DF,

0:02:36.000,0:02:39.000
but any other EstateMaster package you may have,

0:02:39.000,0:02:45.663
or you can try a 14-day trial of EstateMaster[br]package you'd like to evaluate.

0:02:46.000,0:02:52.006
As well as some useful links to contact[br]the support desk, investigate training options

0:02:52.006,0:02:55.803
see what else news in EstateMaster, [br]and dozens of useful links.

0:02:56.000,0:03:01.943
To start the DF, just open an extra previously used[br]DF file from the list,

0:03:02.480,0:03:07.530
or press run DF for a new file.

0:03:11.000,0:03:15.066
Although EstateMaster DF is designed in the[br]microsoft.net platform

0:03:15.066,0:03:18.220
for faster processing in smaller file sizes.

0:03:18.220,0:03:23.120
You'll see it retained the familiar [br]spreadsheet interface,

0:03:23.120,0:03:28.150
including all the benefits [br]of being able to link cells,

0:03:29.000,0:03:33.533
insert your own worksheets,

0:03:34.266,0:03:40.816
and apply many other[br]functions and formulas found in Microsoft Excel.

0:03:45.173,0:03:47.330
It began with an intro sheet

0:03:47.330,0:03:51.540
which provides you with [br]a general description of your project.

0:03:51.540,0:03:59.487
Details like, the project name, [br]its address and suburb.

0:03:59.570,0:04:04.937
The input sheet is a single area of[br]the model where the majority of your

0:04:05.000,0:04:07.920
projects assumptions will be entered.

0:04:07.920,0:04:13.190
These assumptions will include your costs,

0:04:13.190,0:04:18.187
including your land purchase costs,

0:04:18.187,0:04:29.227
cost escalation, professional fees, [br]construction costs,

0:04:31.570,0:04:36.703
And whatever other costs may be [br]deemed to necessary.

0:04:37.451,0:04:40.451
In the input sheet,

0:04:41.000,0:04:46.333
It also where you entered your [br]revenue assumptions, such as

0:04:46.333,0:04:50.463
your sales and rental revenue escalation,

0:04:50.760,0:04:54.103
your selling and leasing costs,

0:04:56.000,0:05:00.933
as well as your actual sales themselves,

0:05:02.116,0:05:05.000
and any other possible income.

0:05:05.000,0:05:08.000
And finally, here is

0:05:08.000,0:05:12.733
where we set up our financial details.[br]This includes:

0:05:13.000,0:05:16.370
how much equity is involved in the project?

0:05:16.370,0:05:20.000
plus up to four[br]other layers of financing.

0:05:20.000,0:05:25.286
Once you entered your input assumptions, [br]they are then used by the model to automatically

0:05:25.286,0:05:29.320
generate the products monthly cash flow.

0:05:29.320,0:05:32.000
As well as a series reports including

0:05:32.000,0:05:39.350
your summary report which details[br]the project's revenue, costs,

0:05:41.000,0:05:45.930
all key performance indicators,

0:05:45.930,0:05:50.000
and a breakdown of your financing.

0:05:50.000,0:05:52.257
In the financials tab,

0:05:52.257,0:05:56.997
you have a profit and loss statement[br]which summarizes the products revenues,

0:05:56.997,0:06:01.637
costs and expenses incurred during a[br]specific period in time.

0:06:01.637,0:06:04.537
And you have a balance sheet

0:06:04.537,0:06:07.943
which summarizes the[br]company's assets liabilities and

0:06:07.943,0:06:11.220
shareholders equity at specific points[br]in time.

0:06:11.220,0:06:13.970
Going back to the input sheet,

0:06:13.970,0:06:17.603
we can generate gain chart.

0:06:17.603,0:06:21.153
This will provide us with a [br]visual representation of the

0:06:21.153,0:06:26.263
project timelines and assist you in[br]scheduling and timing your project.

0:06:26.263,0:06:33.120
DF also contains useful risk analysis[br]tools, such as sensitivity and probability testing.

0:06:33.250,0:06:35.860
Both of these provide [br]further analysis for your project

0:06:35.860,0:06:38.976
by looking at the effects[br]that changes in variables, such as

0:06:39.000,0:06:45.237
construction costs, construction time[br]periods, sales values, interest rates

0:06:45.237,0:06:52.417
rents and many other variables will have[br]on the key performance indicators for your project.

0:06:52.417,0:06:57.906
EstateMaster also features a number of[br]preferences that can be customized to suit your model,

0:06:58.000,0:07:02.250
such as the currency of your project,

0:07:02.250,0:07:09.663
the ability to adjust taxation details[br]and also several options to customize

0:07:09.663,0:07:12.850
the calculation of your key performance[br]indicators.

0:07:12.850,0:07:15.300
This allows you to change the way

0:07:15.300,0:07:21.996
of product works so does better[br]adjusted for your business or property type.

0:07:25.000,0:07:28.156
The input sheet is where we start off,

0:07:28.156,0:07:32.577
by entering the vast majority of the[br]assumptions used in the project.

0:07:33.000,0:07:37.800
For if you use, ourselves requiring input[br]a feature of input font.

0:07:38.000,0:07:41.993
Each section of the input sheet is completed the[br]same manner.

0:07:41.993,0:07:46.283
For each cost item, we input a description,

0:07:46.283,0:07:50.657
how the cost is calculated which can either [br]be a percentage,

0:07:51.000,0:07:56.000
a base rate per unit or both.

0:07:56.000,0:07:59.000
Next, we select an[br]applicable escalation rates.

0:07:59.000,0:08:03.373
These are defined by you [br]in the escalation table above.

0:08:03.373,0:08:06.653
Next, choose if your costs [br]require an S-curve,

0:08:06.653,0:08:11.463
and this can be defined by you[br]in the S-curve tab.

0:08:11.570,0:08:15.350
Then, you enter the month[br]of cost begins

0:08:15.350,0:08:19.403
and the amount of months it's been across.

0:08:19.403,0:08:23.903
And once you completed[br]these inputs, your costs will go

0:08:23.903,0:08:28.133
as a monthly expense in the cash flow sheet.

0:08:29.682,0:08:32.682
Once you enter all your costs,

0:08:33.000,0:08:37.732
there are four types of revenue we have to[br]consider and input.

0:08:38.000,0:08:42.210
There is a share revenue,

0:08:42.210,0:08:44.730
and other income in the input sheet.

0:08:44.730,0:08:47.330
And in addition, we can detail

0:08:47.330,0:08:53.697
rental income and capitalized sales in the[br]tenancy sheet.

0:08:53.697,0:08:56.697
It allows you to model all

0:08:56.697,0:09:00.070
types of development projects.

0:09:00.070,0:09:04.230
Cells can be entered [br]as an amount per unit

0:09:04.230,0:09:07.750
or as an amount per area.

0:09:08.000,0:09:13.753
Pre-sales or deposits can be modeled[br]by entering start and spend days

0:09:14.000,0:09:16.886
in the presales exchange section,

0:09:16.886,0:09:20.320
here displayed in green font.

0:09:20.320,0:09:23.320
Once those sales details are[br]entered into the model,

0:09:23.320,0:09:29.647
a sales rate will be generated.

0:09:29.647,0:09:33.880
Each sale will require a[br]customized land use code.

0:09:33.880,0:09:40.556
This is used to distinguish escalation and sales[br]commissions between different categories of sales.

0:09:40.636,0:09:43.697
And then, once you've entered[br]all these details,

0:09:43.697,0:09:49.700
these revenues will enter the cash flow.

0:09:49.700,0:09:53.330
Once our revenues completed,

0:09:53.330,0:09:58.133
we need to enter the details of our financing.

0:09:58.378,0:10:04.428
You can import equity[br]and up to four layers of finance.

0:10:05.000,0:10:08.366
Once these entered in EstateMaster,

0:10:08.366,0:10:13.923
DF will calculate all your [br]financing details for you.

0:10:13.923,0:10:17.450
Final input sheet, we choose[br]our hurdle rates.

0:10:17.450,0:10:22.290
This allows us to designate [br]a target internal rate of return

0:10:22.290,0:10:26.867
and target development margin.

0:10:26.867,0:10:30.823
Once all these details are entered into[br]the DF input sheet,

0:10:31.000,0:10:33.510
not only you get a detailed of[br]month by month cash flow

0:10:33.510,0:10:37.050
but you're also provided [br]with a summary sheet.

0:10:37.050,0:10:42.356
This provides you with a detailed[br]breakdown of all your costs and revenues,

0:10:42.356,0:10:48.163
as well as the ability to break[br]through further down by area or by load.

0:10:49.000,0:10:53.976
It also calculates all relevant key[br]performance indicators for your project,

0:10:54.000,0:10:58.540
including your development margin,

0:10:58.540,0:11:03.970
your net present value,[br]your internal rate of return,

0:11:04.000,0:11:09.400
and two Residual Land Values.

0:11:09.988,0:11:16.508
Below these key performance indicators, you'll[br]find the returns on funds invested table.

0:11:16.508,0:11:21.046
This allows you to evaluate your project[br]based on each layer of financing you're using.

0:11:21.046,0:11:23.780
Once you completed the input sheet,

0:11:23.780,0:11:26.680
and review the cash flow [br]and summary sheet,

0:11:26.680,0:11:32.746
you can store these feasibility ways, and compared[br]against previously input feasibilities.

0:11:32.746,0:11:36.300
By pressing the options and stages[br]button,

0:11:36.300,0:11:39.300
you can line up these feasibilities [br]side-by-side with others,

0:11:39.300,0:11:41.986
and compare the performance indicators.

0:11:41.986,0:11:46.377
On the consolidation sheet, [br]you can compare the revenue and cost items

0:11:46.377,0:11:51.050
and performance indicators side-by-side.

0:11:51.050,0:11:54.410
You can do this flap to eight different feasibilities,

0:11:54.410,0:12:00.583
or you can combine any cash flows stages[br]in a single project.

0:12:00.583,0:12:03.273
Then, the further analyze[br]your current project,

0:12:03.273,0:12:06.550
you can test its sensitivity changes in[br]various assumptions

0:12:06.550,0:12:09.240
and inputs in a statement of DF.

0:12:09.240,0:12:14.820
For example, if your[br]land acquisition cost was to increase by 5%,

0:12:14.820,0:12:19.710
or your construction costs were[br]to decreased 5%.

0:12:20.000,0:12:22.470
The EstateMaster sensitivity sheet

0:12:22.470,0:12:28.000
can display how those[br]changes will affect all your performance indicators.

0:12:28.000,0:12:32.380
And in the probability sheet, [br]you will be provided with a tool

0:12:32.380,0:12:35.530
that can give you risk assessment for your project

0:12:35.530,0:12:41.656
by signing multiple probability profiles [br]to variables in the sensitivity sheet.

0:12:41.656,0:12:44.947
Once you pressed[br]the probability analysis button,

0:12:44.947,0:12:49.673
EstateMaster will run multiple simulations and[br]eventually drive a probability range,

0:12:50.000,0:12:54.800
for your development margin and you IRR.

0:12:57.828,0:13:02.958
What's the key value proposition[br]with EstateMaster software

0:13:03.040,0:13:08.790
is its ability to allow the user to create their own[br]client specific reports and calculations.

0:13:09.000,0:13:15.430
It's from scratch or from importing existing Excel[br]spreadsheets and then dynamically

0:13:15.430,0:13:19.430
linking these reports to [br]or from EstateMaster data.

0:13:19.430,0:13:22.470
Here, you can see an example

0:13:22.470,0:13:26.950
of importing an existing Excel[br]spreadsheet and the unique ability to

0:13:26.950,0:13:33.660
link your own data to and[br]from EstateMaster.

0:13:39.680,0:13:42.000
If you modulating the stage development,

0:13:42.000,0:13:47.930
EstateMaster DF allows you[br]to allocate any cost a revenue to a specific stage.

0:13:48.307,0:13:52.227
Then, you can break down[br]those costs interviews on a stage by

0:13:52.227,0:13:57.250
stage basis in the staged [br]cash flow sheet.

0:13:57.250,0:13:59.880
The DF Stage Cash Flow sheet also allow you

0:13:59.880,0:14:04.076
dedicate global costs and[br]allocate those costs across your status basis

0:14:04.076,0:14:07.000
on a percentage basis.

0:14:07.000,0:14:11.570
And if you have[br]any repeated in specific types of projects.

0:14:11.570,0:14:17.070
Projects dedicated to specific[br]regions or specific financial structures.

0:14:17.070,0:14:19.890
You can create EstateMaster DF[br]templates.

0:14:19.890,0:14:22.300
In these templates, you can configure

0:14:22.300,0:14:27.310
your inputs, preferences, display[br]settings and even custom worksheets.

0:14:27.310,0:14:31.726
You can then use this template to start a[br]new project of that type with all your

0:14:31.726,0:14:36.150
preferences and[br]settings ready for you.

0:14:37.130,0:14:40.240
Beyond the use of EstateMaster DF,

0:14:40.240,0:14:44.380
once you've decided which feasibility[br]of going to proceed with,

0:14:44.380,0:14:47.810
you ready for EstateMaster DM [br]development management.

0:14:47.810,0:14:53.463
Simply import your feasibility DM[br]and then what approaches you applied.

0:14:53.463,0:14:59.590
It can compare your actual expenditure against[br]your original or any previous budgets.

0:15:00.000,0:15:05.346
As well, all EstateMaster packages come[br]with the option of using the estate

0:15:05.346,0:15:08.000
master enterprise database.

0:15:08.000,0:15:11.000
This is an SQL[br]database which allows users to store

0:15:11.000,0:15:18.486
all the development cash flows from any[br]state master project in one central location.

0:15:19.000,0:15:22.000
When using conjunction[br]with EstateMaster CC,

0:15:22.000,0:15:26.976
corporate consolidation reporting, it allows users[br]to generate consolidated or comparison

0:15:27.000,0:15:35.297
reports for selected cash flows, projects[br]or portfolios to calculate forecasted an

0:15:35.297,0:15:38.976
actual investment returns, including[br]development profit, internal rate of

0:15:39.000,0:15:42.000
return and net present value.

0:15:42.000,0:15:45.870
And finally, EstateMaster DF [br]has many tutorial options

0:15:45.870,0:15:48.216
when it comes to using the model.

0:15:48.216,0:15:51.766
For example, every title in the input sheet,[br]and in the tenancy sheet,

0:15:51.766,0:15:55.920
it will give you an instructional [br]dropdowns you click on the title.

0:15:55.920,0:15:59.300
On the very right-hand side of the toolbar,

0:15:59.300,0:16:02.580
you'll also see there's a Help[br]Menu.

0:16:02.580,0:16:05.420
But of course, if you can't find your

0:16:05.420,0:16:09.740
answers you can always visit[br]www.ticketmaster.com

0:16:09.740,0:16:14.130
for a comprehensive list of [br]training dates in your area,

0:16:14.130,0:16:17.047
or you can login to our client area,

0:16:17.090,0:16:22.537
and search for solutions database, [br]as well as few case studies,

0:16:23.000,0:16:26.320
and check out your license details.

0:16:26.320,0:16:29.000
But of course, you're[br]always free to contact myself

0:16:29.000,0:16:33.433
or any of my colleagues [br]at the EstateMaster support desk.

0:16:36.090,0:16:39.577
Please feel free try EstateMaster for yourself,

0:16:39.577,0:16:45.950
visit www.ticketmaster.com[br]to download a free 14 day trial software.

0:16:45.950,0:16:48.666
And if you have any further questions,

0:16:48.666,0:16:52.832
please feel free to contact us [br]at any of our global EstateMaster offices.