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.