Home

1 Introduction to Estate Master CC

1. A Dr de l Stanwell Gardens Precinct 1 Propo En Do iH New Portfolio A E Stanwell Gardens Precinct 2 Propo A mvg tt nn 2 En Mal hal A ANNE Stanwell Gardens Precinct 3 Prope EN En Me Edit Financing Stanwell Gardens Precinct 4 Propo Be a ES Clone Portfolio AM Stanwell Gardens Precinct 5 Propo ee ar Popre a se a na atl cattle ta til anata 2 When prompted enter in a name for the new Portfolio being created It must be a unique name that no other Portfolio has Clone Portfolio Portfolio Name Land Development alternate Financing 3 Click OK to conform the name The new Portfolio will be created and following prompt will appear gr E A Cloning Portfolio ex The Portfolio has been cloned do you wish to change the settings of amp the new Portfolio a If Yes the Portfolio settings will appear for the new Portfolio will load so they can be adjusted if required b If No it will return the user to the Home screen with the new Portfolio activated 2015 Estate Master Pty Ltd aa Estate Master CC 5 Working with Projects The Project is the next hierarchical group in the Estate Master CC program below Portfolios They are created when a user exports a DF DM IA HF Cash Flow file for the first time for that Project in the Enterprise Database and they are prompted to Add new project to database during the export process f Add new project to database C Append to existing proje
2. Estate Master CC software User Manual Estate Master www estatemaster com 2 Estate Master CC Table of Contents Part Part Ill 1 2 Part IV 4 Part VII 1 N Of Bb N Part VIII 1 2 3 Part IX 4 2 Part X Introduction to Estate Master CC 5 A A a AE 5 Dala MerarC hV cs our ca a 6 SISTEMES MENS nnne nnnm nnmnnn nnmnnn mnnn 7 Starting Estate Master 9 The Welcome SCREEN anclas Urraca 9 Product TADS iaa 10 Connecting CC to Enterprise DatabaSe oooocnccncncnncnncncnncnnnncnnrncnnrnnnncnnrncnnrnnancnnrncnnrananrnnancanaanane 11 Operating the Program 13 NOME Sr Mita 13 MENUS ANG TOOIDANS aaa 16 Working with Portfolios 22 ROTO lO DETU S ii iii iii rita 22 Creating POOL 26 Portfolio FING CHING ai iad s 31 e AAA O E O A E E E E A E E E 42 Working with Projects 44 A 44 Merging Projects 0 ias 45 Working with Cash Flows 47 Importing Cash OW S caitaica iii tacita 47 All Cash Hows Sreem oa 50 Reports 56 The Report PANG a a a 56 TNE REDON VICWO estadal a a a aid 57 Report Preferences cccccccccceccecceceenceneecceneecccceccecceuceccecusausaueneeeenseneeaescecceuceucecuecuscusausaseass 58 Consolidated Reports idad a 64 Comparison Reposo 68 Data Valdano a a a 70 late PACING AEAEE A A A E E AE T AOA A OEE E E AO E EAA 71 Dashboard 14 Consolldated oca lec 76 COM DaAFIS ON a es dde TE 80 A a ent ies Crile iad adie eldest id ste 81 Exchange Rates 83 EQUINOS in ie 84 Jato laia e RAICS o
3. P1234 Paramatta Sub Total e Detail By Cash Flow For each cost and revenue category the individual cash flows that make up the selected Portfolio are reported on separate lines Revenue Gross Sales Revenue Hotel Conv Centre Mired Use Town Centre Option 1 Subdivision Paramatta Units Parameatta Units Stage 1 Retail Phase 1 Stage 1 Mixed Use Stage 2 Commercial Stage 2 Commercial Sub Total 9 a e Summary Only the major cost and revenue categories are reported for the selected Portfolio Gross Sales Revenue Selling Coste Rental Income Leasing Cost Interest Receiwed Other Income Tax Payment See listers GER re otal Revenue 31 All Type Reports Report Detail Level by Net Cash Flow Before Interest Detail By Project Sources amp amp Application of Funds Summary Development Type Reports Report Detail Level al b Cash Flow Detail By Cash Flow DM Cash Flow Variation Summary Investment Type Reports Report Detail Level b Executive Summary Detail By Cash Flow m th 1 up the selected Po AE y AA ected Portholio e zal h mi Lill 2015 Estate Master Pty Ltd eo Estate Master CC 7 3 2 7 3 3 7 3 4 Currency Comparison For the Currency Comparison Summary report select up to 2 additional currencies in addition to the Portfolio s Currency to report against e First Comparison Currency Select a currency from
4. ES Do you want to delete this Cash Flow and all its history Click Only This to delete this Cash Flow only Click History to delete this Cash Flow and its history Only This e The system will confirm the deletion with the user If Yes is pressed then the Cash Flow will be deleted permanently Delete Cash Flow The Cash Flow exists in 2 Portfolios o Do vou want to delete this Cash Flow From the database Yes 2015 Estate Master Pty Ltd 52 Estate Master CC Delete Cash Flows Multiple To delete more than one Cash Flow at a time from the Enterprise Database permanently e Select the Cash Flows using the check boxes All Cash Flows All Cash Flows Advanced F Select Project Number Project Name Equinox Square Equinox Square CELLETEETETETEEETTETEEETETETETETTEETTETTEEETETEEETETEEEEET COCO OEE e Press the Delete Selection button in the Menu Bar Delete Selection e A form will then appear listing the Cash Flows that have been selected to be deleted and showing what Project and Portfolio they belong to Delete Multiple Cash Flows Ame Project Number Portfolio Name 2 128 1 111 3 1282 1 111 Build and Sell 12M Equinox Square P2000 Division Commerica Option 1 26 Equinox Square P9000 Region Domestic Pr Option 3 2 Equinox Square Region Domestic Pr A A A A AR EA A ON e Ifa Cash Flow belongs to more than one Portfolio it will be indicated by a expansion ico
5. Add Cash Flows from Project to Portfolio Delete Cash Flow from the Enterprise Database Only if the user has Write access to the Portfolio that the Cash Flow is being added to Applies also if the users ow ns the Cash Flow Cash Flow Permissions The Cash Flow Permissions level permits importing and deleting Cash Flows owned by a user There is no functionality to edit these settings as they are automatically set and controlled by the system Basically users have Full Control over any Cash Flow they own these are Cash Flows that were exported by them into the Enterprise Database Once the Security Permissions functionality is enabled on the Estate Master CC program then e Users can only Import Cash Flows from the Enterprise Database into DF DM IA HF that they own e Users unless they are a Application or Project Admin can only delete Cash Flows from the Enterprise Database that they own 2015 Estate Master Pty Ltd Security Permissions 97 10 5 Preference Permissions Once Security Permissions have been enabled in Estate Master CC the user will be provided with additional options to lock unlock specific Preferences e f Enable Security Permissions is ENABLED and the user running Estate Master CC is part of the Administrator Group an unblock lock button will be displayed next to each Preference Option depending on their current lock status e f Enable Security Permissio
6. 2 000 000 2 000 000 O 0 Changing Portfolios that have Manual Adjustments lf a change is made to a Portfolio and Manual Adjustments have been made to the Consolidated Financing structure for that Portfolio the user will receive a warning when they try and view the Consolidated Dashboard or Reports for that Portfolio This will occur when e A Cash Flow is added to or deleted from the Portfolio e A Cash Flow that exists in the Portfolio is updated e The users toggles between Use Latest Cash Flow and Use Fixed Cash Flow for a Cash Flow that exists in the Portfolio Check Manual Inputs One or more Cash Flows inthe selected Portfolio have either been 9 added removed updated Do you wish to check your Portfolio Financing Manual Inputs before proceeding to generate the report Portfolio Period Jan 2008 Dec 2017 IF you select Ignore you will not be prompted until another change has occurred in the Portfolio Warning when generating a Consolidated Report Warning when viewing Consolidated Dashboard 2015 Estate Master Pty Ltd 36 Estate Master CC The warning is informing the user that one of the above changes in the Portfolio may be causing their manually inputted funding requirements to change so it is recommending to check them The user can ignore this warning and it will not reappear until another change is made to a Portfolio Here are some examples of why the user would need to c
7. 2015 Estate Master Pty Ltd Working with Portfolios 33 Interest Rate Calculation This is the method for converting the Interest Rates from an Annual to a Monthly equivalent as the Consolidated Financing cash flow is based on monthly rests e Nominal Conversion D T e Effective Conversion D 1 1 T 1 Where D is the annual interest rate T The number of rest periods per annum i e Monthly 12 Interest Rate Calculation per annum Effective ve Profit Share This is a fixed percentage for a percentage of profit to be distributed e g to the Land Owner or other investor at the end of the project as a lump sum Profit Share 10 00 4 3 2 Manual Adjustments Once the Finance Settings have been set the user may wish to make manual adjustments to the Financing cash flow including e Equity injections and repayments e Loan 1 draw downs and repayments e Interest Rate variations for Loan 1 and Senior Loan To make manual adjustments to the financing items click the Manual Adjustments button located on the Financing Settings screen which will load a new window All input cells are identified by blue font on a white background All other cells are calculation cells and are locked This window has a spreadsheet input interface meaning the user can actually type in formulas into the input cells and even link to other parts on the financing cash flow 2015 Estate Master Pty Ltd 34 Estate
8. A yearly Cash Flow table for each Option Scenario based on the Financial Year End as set in the Report Preferences A monthly Profit and Loss Statement for each Option Scenario using the data from the Financials sheet in the DF amp DM Cash Flow models A yearly P L Statement for each Option Scenario based on the Financial Year End as set in the Report Preferences A monthly Balance Sheet for each Option Scenario using the data from the Financials sheet in the DF amp DM Cash Flow models A yearly Balance Sheet for each Option Scenario based on the Financial Year End as set in the Report Preferences A monthly Cash Flow table for each Option Scenario with all Costs and Revenues discounted to present value using the Portfolio s Discount Rate A Cash Flow table for each Option Scenario w here 3 phases of the the time line can be grouped using different rest periods as defaulted in the Report Preferences These rest periods can be adjusted when the report is run along with the ability to set a custom start and end date range for the report 6 All Periods Select Range Stat Mar 2011 Sle End Mar 2018 fe A summarised Cash Flow table for each Option Scenario from a user defined point in time All data before the selected month is ignored 2015 Estate Master Pty Ltd Nominated Start Date Nominate the date Month and Year from which this report is to start from Start Date Mar 2011 e OK
9. Budget blank e lf the no Current Forecast exists it is replaced w ith the most recent cash flow The Budgets Forecasts for the report are derived from a DM Cash Flow being stored to the database at the time the Budgets Forecasts is set within DM By keeping the Cash Flow Tile unchanged each time the budget is set in DM and exporting to the database w hen prompted to do so when setting a budget a history of budgets forecasts for that DM Cash Flow are then stored in CC The example below shows a DM Cash Flow with title Detailed DM being stored in the database w hen the Original Budget and Project Budgets w ere set in DM 2015 Estate Master Pty Ltd e Estate Master CC Project Cash Flows Cash Flow Title Description DM Budget Version i Ml Dni OM 200 Aparseecs vith ground boradi r Peas 5 13 gt Cazsded CH 200 Sparse wth ground Roos mad Dan abot 5 13 E Cecnted DM 200 Sparse wh ground Aou mai Orig eral 5 13 For this history to be stored in CC you must ensure that the follow ing Preference in DM has been set Export to Enterprise Database Always prompt when setting budgets forecasts FD DM Variation A report for consolidating Estate Master DM Cash Flow s show ing the different budgets stored Original Project and Previous and their variations to the Current Budget It also includes Cost to Date and Forecast to Complete The treatment of DM Cash Flow s that don t have certain budgets
10. Cancel The cash flow is summarised by Gross Sales Revenue Other Revenue Gross Rental Income Interest Received on Deposits and Other Income and Total Net Costs all development selling and leasing costs excluding loan fees and interest charges Interest Charged and Received on Equity and Profit Share Payments are not displayed on this report Gantt Chart A graphical timeline of the monthly Cash Flow for each Option Scenario Financial Year Gantt Chart A graphical timeline of the financial year Cash Flow for each Option Scenario Cash Flow Charts Four charts are generated for each Option Scenario 1 Cumulative Net Cash Flow 2 Cumulative Net Revenue 3 Cumulative Project Costs 4 Cumulative Construction Costs Inventory A monthly stock report show ing the pre sales sales and settlements handovers occurring on a quantity area and value basis for each Option Scenario This report can also be run in Variable Period mode Investment Cash Flows DCF A monthly comparison Discounted Cash Flow table nancial year DOF A yearly comparison Discounted Cash Flow table based on the Financial Year End as set in the Report Preferences Capitalisation Summary A comparison Capitalisation Summary report w here the user is prompted to select one of four valuation methods that w ere calculated in the Estate Master IA model Executive Summary A comparison Executive Summary report detailing the key outputs of a indivi
11. In all other time periods the user can enter vary the interest rate manually e Interest Charged The amount of capitalised interest calculated each period e Line Fees The monthly fee paid in arrears during the period of the loan It is based on the annual fee as defined in the Financing Settings e Repayment This shows the amount being repaid to the Senior Loan It cannot be manually adjusted e Loan Balance The remaining balance on the loan including any capitalised interest and fees Manual Adjustment Rules When making manual adjustments to the financing there are certain rules that will dictate what can and cannot be entered into an input cell for a certain time period These rules are 1 You cannot manually repay equity more than the available revenue positive net cash flow for a specific month 2 You cannot manually repay Loan 1 more than the available revenue positive net cash flow for a specific month 3 You cannot manually draw down for Loan 1 more than than the required amount that is the sum of costs negative cash flow and outstanding balance on the Senior Loan If any of these input rules are breached the input cell background will become red and a warning will appear to the user when they try and update the database with the changes Net Cash Flow Period Month Bafora Intarast Apr 08 7 825 757 12 May 08 1 828 13 Jun 08 35 461 Manual Injections Draw Down to Fund or Repayments CCF
12. All Yields are based on the Captilised Value e Estate Master CC 7 9 e Outputs related to the DCF approach to valuation NPV IRR Terminal Sale Value etc Each individual Cash Flow is reported along w ith the consolidated returns Comparison Reports The Comparison Reports provide an amalgamated analysis of a selection of Cash Flows that are being compared ie Options Scenarios The reports are All Cash Flows Net Cash Flow Before Interest Net Cash Flow After Interest Sources and Application of Funds A monthly comparison Net Cash Flow for each Option Scenario excluding interest and other funding costs A monthly comparison Net Cash Flow for each Option Scenario including interest and other funding costs A monthly comparison Cash Flow table show ing where funds are coming from e g equity debt revenue etc and how it is applied expense outlays interest loan repayments profit share etc This report can also be run in Variable Period mode Development Cash Flows Report Description Summary Report Cash Flow Financial Year Cash Flow P amp L Statement Financial Year P L Statement Balance Sheet Financial Year Balance Sheet PV Cash Flow Variable Period Cash Flow Future Cash Flow Summary of Options Scenarios that are being compared including Costs Revenues and Key Performance Indicators such as Profit IRR NPV etc A monthly Cash Flow table for each Option Scenario
13. Fix current Cash Flows to Portfolio Use Latest Cash Flows for Portfolio Print Reports 2 A Permissions for Portfolio screen will then pop up Click on Add to add a new user to the Portfolio Permissions Group Permissions for Portfolio 22222 Group or user names Permissions for Administrators 2015 Estate Master Pty Ltd 92 Estate Master CC 3 A Select Users or Groups screen will then appear Make sure that Object Types has been selected as Users and Groups and Locations has been set to Entire Directory before entering a User Group name in the field provided To ensure that the name exists in the Windows Domain click Check Names Once the User Group has been successfully found click on OK Select Users or Groups Select this object type Users or Groups From this location Entire Directory Enter the object names to select examples EM Development 4 The program will then return to the Permissions for Portfolio screen where the User Group who was just added to the Portfolio Permissions group will appear in the Group or User Names list lt is at this point where there specific permissions can be set Permissions for Portfolio 22222 LX Group or user names AEM Development EM EM Development Permissions for EM Development Allow Full Control Admin MN Read Write Cancel 2015 Estate Master Pty Ltd Security Permissions 93 Permis
14. Hhh JP RITA IEA PTE R A A jad Faro LF Pog Lol AE dral iira hj P kif E paha Hii c HLI F ih d Lac TOTA FR Cu EC TC CTi Eadie Ta r n Li hia Lidd 04 gt CTi r Ld POTA L PR DDC T C TA rear Ta rl ey TIF GITIS EE IMCA GTS 1 Coenen Proc 1 0 tore Prak Shee l P AEL ee Be POE rA TTA GAE L Earra hl reir dr ME RE TA AT E L ehe ci n h od el Cece i hi ra ra Propa Seri T UTA Ren A Far Pe LATE l Ores heen a ce rar Ca ec pt T F ec Pre ercu hk mi A pa shanri mis rire l PEATA ATR peru rrira RF on Gp Cady Lehe F de PYG Lap E F AOS ita JR T Hoek d LE EDO IA Ll ORT Her dl 110 AA ce THAT hE Blt EIC T it hes nated Herh ag Lon Tt TRF a Dac std Hoek A CTO me Te ie T del G 1a 1rd T JET Hoek J Uh se TR ay His ste Hert a e E t Tara JET T Tait dls Cal ala dj Co hern Cel E ja Cd Cahe E adria eek CHF Hr ANTARE k kiarra m lll ee rico rie pi r Ml le vege bp eS ella rip oligo a le Co He ge al ees reg eel a Pring araire ep Cab Her h Feil mi rir kil meir k mmh de eee k mk prikk miaf mira rok k kika riel bain ES barely LEF ort miy emka h ee FF h ee i Cee irc h nir he se ce el ei P Coes Corer Faar leer be Leer 2015 Estate Master Pty Ltd s Estate Master CC In addition to displaying the report there are many options available in the Report Viewer for the user via its menu bar Go to first or last page of the report Go to previous or next page of the report Go
15. WA will be displayed w ith a mouse over message One of the Cash Flow s does not have a Net Lettable Area entered The amalgamated number of car spaces for all of the Investment Cash Flows Estate Master lA in the selected Project or Portfolio The amalgamated values of all the Investment properties in the selected Project or Portfolio These values are based on the Adopted Valuation set on the Executive Summary report in the Estate Master IA Cash Flows The total vacant area in all of the Investment properties in the selected Project or Portfolio The unit of measurement is based on the selection for Net Lettable Area Displays the total vacant area as a percentage of total Net Lettable Area This is the w eighted average duration of all leases in the selected Project or Portfolio based on area The start and end dates for the investment period of the selected Project or Portfolio or essentially the earliest start date and the latest end date for all the Investment Cash Flow s Estate Master lA The Investment Discount Rate or Target IRR is simplistically the desired returns on funds invested For discounted cash flow analysis the discount rate is the rate at w hich future Development Cash Flows are discounted to present value lt is based on the Portfolio Preference The return on the Investment Cash Flows or the discount rate at which the NPV equals zero It is calculated based on Portfolio Preferences for the Discount Rate Conv
16. _ Applies To N A Ls Poo NAF dlet Prasant alua AAR N Cannot calculate result because Portfolio level Consolidated Financing is being used Y Example of IRR NPV warning e Same as Summary report e IRR and NPV o If the Portfolio is set to calculate the IRR NPV on a cash flow that includes financing costs and or interest these are calculated from the Consolidated Financing results 2015 Estate Master Pty Ltd 42 Estate Master CC 4 4 Cloning Portfolios Cloning a Portfolio allows the user to create a copy of an existing Portfolio i e the Cash Flows that it is comprised of its settings permissions etc so that they can report on the same group of Cash Flows but using different KPI settings Discount Rate IRR assumptions etc Financing structures etc 1 Select the Portfolio to be cloned and either right click it and click Clone Portfolio from the context menu or click Clone from the Ribbon menu These buttons will only be enabled if the user has sufficient permissions Write or Full on the Portfolio being cloned Import Home AllCash Refresh Exchange Options Settings Financing Portfolio EM File Flows Rates File View Tools Portfolios All Portfolios Portfolio Cash Flows H Eg Crows nest Project Number Project Name Cash Flow Title Desc H a Division Commerical pera econ priekam l ard Duca na lL a nar Li
17. base Currency for the selected Cash Flows Portfolio Settings Esmeralda Portfolio Currency Title amp Description Bahamian Dollar KPI Settings Financing Bahraini Dinar Corporate Equity Bangladeshi Taka Currency and Area Barbados Dollar Bermudian Dollar aa Repobakels gt A ONN T a aT T e tint Setting the Currency for a Portfolio or selection of Cash Flows Evaluation of Consolidated Returns Greenwood Park Report printed using the Australian Dollar currency COSTS amp REVENUES Potential Projects All Projects eee eee 4 gti ae N o ts as A tl e a a F Displaying the Currency on Reports 3 Viewing the Dashboard If a Portfolio is selected on the Home screen and it contains Cash Flows based on different currencies then the selected base currency in its Portfolio Settings will convert all Cash Flows to a common currency for vewing purposes Mode consolidated All Project in AUD The Portfolio Currency used for the dashboard This does not apply to Projects that have Cash Flows with different currencies No Dashboard data will be displayed in that instance with a warning being displayed to the user Consolidated Some Cash Flows have different currencies and therefore cannot consolidate data in Project Trying to view a Dashboard for a Project wth different Currencies 2015 Estate Master Pty Ltd sa Estate Master CC 9 1 Editing Rates To edit the Ex
18. e Estate Master Enterprise Database installed and configured on your network SQL Server 2005 2008 2012 or SQL Express Edition e Microsoft Report Viewer 2008 e Microsoft Net Framework 4 0 or higher e 2Gb RAM or higher e Internet connection for downloading files and activating licences Note to Apple Mac Users Estate Master can only run on Mac s va a Windows Virtualization tool such as VMWare or Parallels 2015 Estate Master Pty Ltd Starting Estate Master 9 2 Starting Estate Master 2 1 The Welcome Screen The entire EstateMaster software suite now operates from a central launcher that is loaded from a single shortcut within Windows e Once loaded you can select your installed applications and it will display a list of files recently opened and saved by the user e There are also shortcuts to our extensive Sample File Library Operations Manual and Training Courses Booking page on our website e For those applications not yet installed on the machine there is information to learn more about them and even links to downloading a free trial e Live web content at the bottom also displays frequently updated update alerts important news and other items of interest such as the release of new training courses or tutorial videos Starting Estate Master 1 In Windows go to the Start gt Programs gt Estate Master gt and click on Estate Master de Estate Master es Estatebdaster 2 The Estate Master
19. fit in the allocated area e If the image is smaller than the allocated it will not be upscaled to avoid distortion Company Logo Select Logo Delete Logo File Path DiWeork EstateMaster MASTER FILES CURRENT OCF Files Images Images Sample Property Photo Portraithipg Image Preview 2015 Estate Master Pty Ltd 64 Estate Master CC 7 4 Consolidated Reports The Consolidated Reports provide an amalgamated analysis of a selection of Cash Flows ie a Portfolio The reports are All Cash Flows Net Cash Flow Before A monthly consolidated Net Cash Flow excluding interest and other funding costs Interest Net Cash Flow After A monthly consolidated Net Cash Flow including interest and other funding costs Interest Sources and Application A monthly consolidated Cash Flow table show ing w here funds are coming from e g equity of Funds debt revenue etc and how it is applied expense outlays interest loan repayments profit share etc This report can also be run in Variable Period mode Development Cash Flows Report Description Summary Report Summary of consolidated Costs Revenues and Key Performance Indicators such as Profit IRR NPV etc Summary Report By This is similar to the Summary Report above but each individual Cash Flow is reported Cash Flow separately in addition to the consolidated returns DF vs DM Summary Summary of consolidated Costs Revenues and Key Performance Indic
20. more seamless and efficient option to using the Single File Import option for each one 1 In the Ribbon menu click File gt Import EM File gt Folder Import 2 A folder browse dialog will appear Select the folder that contains the DF DM IA HF files you wish to import and press OK 3 During the import process a No import wizard will appear Instead it will silently loop through each DF DM IA HF file that it finds in the selected folder only 1 level does not search sub folders and attempt to import the file into the database b If the Project Number in the DF DM IA HF file DOES NOT already exist in the database a new Project will automatically be created and the Cash Flows being imported will be linked to that Project in Estate Master CC c lf the Project Number in the DF DM IA HF file DOES already exist in the database the Cash Flows being imported will be linked to that Project in Estate Master CC 2015 Estate Master Pty Ltd a Estate Master CC 4 When the import process complete it will report what files were imported any other issues errors to the user lec Import Complete XH 2 of 9 Files imported The following files were imported Pacific Palms 3 Stages emdtf Stanwell Gardens 5 precincts emdf The following issues were identified For file Demo DE with link cells to costplan emdf There are no Options Stages to import One or more Options stages could not be im
21. settings that has been applied to the specific Cash Flow in either the Estate Master DF DM or IA model itself Therefore those settings can only be edited while the Cash Flow is in either the Estate Master DF DM or IA program A combination of settings When viewing a Comparison dashboard to ensure that the user is comparing KPI s that are calculated on a common basis the IRR NPV and Development Margin calculations use the settings from the KPI Ddefaults if a Project is selected or the KPI Settings if a Portfolio is selected while the Discount Rate used and whether it is a nominal or effective rate is determined from the specific settings of the Cah Flow iteself 2015 Estate Master Pty Ltd Estate Master CC 8 1 Consolidated This dashboard will be displayed if there are both Development DF and DM and Investment IA Cash Flows in the selected Project or Portfolio If only Development Cash Flows exist then the Consolidated Development dashboard layout will be displayed instead even though Consolidated All may have been selected No of Cash Flows The number of Cash Flow s that are in the selected Project or Portfolio Last Updated The date of the most recently updated Cash Flow in the selected Project or Portfolio Site Area The amalgamated site area of all the Development Cash Flows Estate Master DF and DM in the selected Project or Portfolio If Cash Flows have different measurement units for their site a
22. tab e Details of the currently connected Enterprise Database on the active machine e A Configure Connection button to start the Enterprise Database Management Utility e A Run button to start the Estate Master CC application e Links to view the Training Course online booking site or open the User Manual PDF f Development DF Feasibility Development DM Management investment Appraisal Hotel Feasibility Corporate Consolidation Corporate Consolidation CC delivers a corporate level view of your entire property portfolio or multi staged project with consolidated cash flaw forecasts and corporate funding needs It s your key management tool collating all the detailed project intelligence and analysis already modelled in Estate Master DF DM and lA Training Currently Connected to e User Manual server emdev k8 lt q 12005 J 4 la Du J EstateMasterlata Lontiure Connection 2015 Estate Master Pty Ltd Starting Estate Master 11 Software is not Installed When the Estate Master CC software is not installed on the active machine the following will be displayed on the product tab e A brief summary of the product with links to a demonstration video software data sheet and contact details e A link to download a 14 day free trial of the software D Development Feasibility Corporate cc Consolidation Development Management Estate Master C
23. the list The currency exchange rate for that currency will then be used to generate a set of results in the Currency Comparison Summary e Second Comparison Currency This is optional If you do not wish to compare a second currency select Ignore from the top of the list box Currency Comparison Summary First Comparison Currency Bahraini Dinar E Second Comparison Currency Optional Chilean Peso Forecast Summary Report Preferences for the Forecast Summary report are e Historical DF Cash Flow Data Select how any historical DF Development Feasibility data costs or revenues occurring before the current month year is to be reported in the Forecast Summary report The options available are o Report as is and assume it is an actual cost to date o Accumulate all historical data and report is as occurring in the current month o Ignore the historical data and assume no cost or revenue activity before the current month Historical OF Cash Flow Data Accumulated as at Current Month le DM Variation Report Preferences for the DM Variation report are e Use Current Budget if no Budget Set This option will use the Current Budget data when no Original Project or Previous Forecasts have been set for a DM Cash Flow This will enable the user to consolidate DM Cash Flows and run the DM Variation report even though some budgets may not have been set for a particular Cash Flow Budget Substitution Use Current Budget if no Bu
24. used for reporting Development Report Labels Statutory Fees amp Contributions Miscellaneous Costs 1 Miscellaneous Costs 2 Miscellaneous Costs 3 Development Management Fees e Portfolio Logo Select an image or logo for this particular Portfolio It will appear on the Title Page for the Portfolio in addition to the Company Logo if selected o Only Bitmap PNG JPEG or GIF files can be inserted o There are no file image size restrictions o The program will automatically downscale the image if it is too large to fit in the allocated area o If the image is smaller than the allocated it will not be upscaled to avoid distortion Portfolio Logo Select Logo Delete Logo 2015 Estate Master Pty Ltd Working with Portfolios 29 3 Once the user has completed the Portfolio Settings wizard the program will take them to the Edit Portfolio screen This screen is split into two grids e Portfolio Displaying the Cash Flows that exist in the Portfolio e All Available Cash Flows Displaying all the Cash Flows that exist in the Enterprise Database that do not currently exist in that Portfolio c9 iA ON Edit Portfolio Estate Master CC aX Main alone ls sy Y i Z N New Import Home AllCash Refresh Exchange Options Portfolio EM File Flows Rates File View Tools Portfolio Division Commerical Select Project Number Project Name CF DM Budget Version Edition Proj
25. 15 Estate Master Pty Ltd Working with Portfolios 39 Applies To o Only the Net Cash Flow before interest w ill be displayed Future Cash Flow Development DF Equity Injections and Repayments are are calculated from the Consolidated amp DM Financing results e External Loan Fees area calculated from the Loan 1 and Senior Loan Fees in the Consolidated Financing results e External Interest Charges area calculated from the Loan 1 and Senior Loan Fees in the Consolidated Financing results P 8 L Statement Development DF e No impact as these reports ignore Consolidated Financing and use the financing Financial Year P amp L amp DM fromthe individual DF and DM Cash Flows Statement Balance Sheet Financial Year Balance Sheet Cash Flow Chart Development DF e For the Consolidated Equity Cash Flow chart amp DM o The Equity Cash Flow is calculated from the Consolidated Financing results o lf an Estate Master lA Investment Cash Flow is part of the Portfolio this Development DF and DM Cash Flow chart will not be shown e For the Consolidated Cash Flow chart o The Overdraft and Net Cash Flow lines are calculated from the Consolidated Financing results o If an Estate Master lA Investment Cash Flow is part of the Portfolio this Development DF and DM Cash Flow chart will not be show n e For the Cost vs Revenue chart o The Fees and Interest Charges that are included in the Costs are calcula
26. 2015 Estate Master Pty Ltd Working with Cash Flows 49 Being Licensed to use the Enterprise Database Integration Module An Estate Master user must have the Enterprise Database Integration Module licensed in their version of DF DM IA HF to be able to get data from those products into the Enterprise Database by either of the following methods 1 Opening the data file within the Estate Master DF DM IA HF application itself and using the Export to Database function or 2 Using the Import EM File function within CC to browse to a data file and import it If the first method is used the user of DF DM IA HF is immediately made aware if they are not licensed to use this feature and it stops them from exporting the data to the database If the second method is used when the user of CC attempts to import the selected DF DM IA HF data file it checks to see if that specific file was saved using a version of DF DM IA HF that was licensed to use the Enterprise Database Integration Module If it was not licensed to use that feature the following message will appear Estate Master DF jim B r _ AAA This Estate Master DF file cannot be imported as it was last saved by a user that does not have the Enterprise Database Integration Module licensed and enabled in their version of Estate Master DF Contact Estate Master for further assistance To remedy this the selected file must be saved using a version DF DM IA HF th
27. 3 6 Financial Year End Select the month that signifies the end of the Financial Year It will affect the following reports e Financial Year Cash Flow e Financial Year Gantt Chart e Financial P amp L Statement e Financial Balance Sheet e Forecast Summary e DM Profit Margin Year to Date e DM Summary Year to Date Financial Year End Jun y Used when printing yearly reports amp forecast summar 2015 Estate Master Pty Ltd e2 Estate Master CC 7 3 7 Variable Period Cash Flow The preferences for the Variable Period Cash Flow report prompt the user to nominate what rest periods the three different time frames are reported in 1 First x months Monthly Quarterly Halt Y early Y early 2 Next x months Monthly Quarterly Half Y early Y early 3 Thereafter Monthly Quarterly Half Y early Y early lf the nominate rest period is e Monthly then any number can be entered for the of months e Quarterly then only numbers divisible by 3 can be entered for the of months e Half Yearly then only numbers divisible by 6 can be entered for the of months e Yearly then only numbers divisible by 12 can be entered for the of months Variable Period Cash Flow f Monthy Any number can be entered above zero If Quarterly Only numbers divisible by 3 can be entered TF Ws F Wessels a pre harr Apaia hi se ha antaras If Half Yearly Only numbers divisible by 6 can be entered If Yearly Only numbers divisible by 12 can be entered Firs
28. 355 thi sarc Goatees bea ial E A E E aaa E A E e cee hei Let aa Glo tad 85 Security Permissions 97 Applicaton AMIA SAA acido 89 2015 Estate Master Pty Ltd Contents 3 2 PORHTONO Permissions ura 91 3 Project Permissions iii o o e io 0 oe 94 4 Cash FIOW PERMISSIONS al 96 5 Preference Permissions ica da 97 O 2015 Estate Master Pty Ltd Introduction to Estate Master cc 5 1 Introduction to Estate Master CC 1 1 Introduction This operations manual is a guide for using the Estate Master CC Corporate Ai Aib AL ail Consolidation software developed in Acquisition Analysts Development Managers Investment Analysts Hotel Developers Microsoft SQL and NET Real Estate Valuers Project Managers und Managers Hotel Valuers Property Consultants Accountants Real Estate Valuers Estate Master CC is a program that works in conjunction with the Estate Master DE DM ES H Enterprise Database a secure and central irae pot DEVELOPMENT INVESTMENT data repository system that is installed FEASIBILITY MANAGEMENT APPRAISAL FEASIBILITY and configured on a network to allow users to export import their Estate Master DF Development Feasibility Estate Master DM Development Management Hotel Feasibility HF and Estate Master CE Toso SOL Sever IA Investment Appraisal Cash Flows to TTT from Once the data has been exported to i the Enterprise Database users of the Estate Master CC software are able to create Portfolios
29. C Portfolios El Eg Crows nest Projects All Projects Ea Division Commerical En My Projects ar EFF A user is a creator e Ofa Portfolio when they create that Portfolio within Estate Master CC e Of a Project when they export the first Cash Flow for that Project in the Enterprise Database and they are prompted to Add new project to database during the export process f Add new project to database C Append to existing project Project Number P1000 Project Title Project Mame List of Projects This pane lists all Projects in the Enterprise Database e When a Project is selected it will show the Cash Flows that exist in the Portfolio in the centre of the screen List of Cash Flows and display the outputs for the Project in the Dashboard e To sort the list of Projects either by Number or Name click on the relevant header All Projects j XYZ Airport e When right clicking a Project a menu will appear with certain functions 2015 Estate Master Pty Ltd Operating the Program 15 List of Cash Flows The centre of the Home screen displays the list of the Cash Flows in the selected Project Portfolio e When a Portfolio is selected it will list all the Cash Flows that exist in that Portfolio e When a Project is selected it will list all the Cash Flows that exist in that Project For those Cash Flows the user can o Drag and drop them to any of the Portfo
30. Estate Master Cash Flows are excluded from Sources of Funds e Equity Distributions and Payments in Application of Funds is calculated from the Equity Repayments in the Consolidated Financing e Loan 1 and Senior Loan Repayments in Application of Funds are calculated from the Loan Repayments in the Consolidated Financing e All Loan Repayments for Loans 2 and 3 as calculated in the individual Estate Master Cash Flows are excluded from Application of Funds Profit Share is calculated from the Consolidated Financing settings All other Profit Share to Land Owners and Lenders as calculated in the individual Estate Master Cash Flows are excluded e All other Loan Fees and Interest Charges as calculated in the individual Estate Master Cash Flows are excluded Summary Development DF Interest Received will exclude any Interest Received on Surplus Cash calculated Currency amp DM in the individual Estate Master Cash Flows Comparison Interest Charged on Equity as calculated in the individual Estate Master Cash summary Flows is excluded e Fees and Interest Charges for Loan 1 and Senior Loan are calculated from the Consolidated Financing results All Fees and Interest Charges for Loans 2 and 3 as calculated in the individual Estate Master Cash Flows are excluded Profit Share is calculated from the Consolidated Financing settings All other Profit Share to Land Owners and Lenders
31. Master CC Financing Manual Adjustments Parkside Project Consolidation of the Net Cash Flow Before Interest for all Cash Flows in that Portfolio Oct 07 Now 07 Dec 07 1 430 000 5 000 000 1 430 000 42 500 258 582 46 486 1 558 086 112 969 323 318 194 470 3 570 000 3 527 500 3 268 918 3 222 432 1 664 346 1 551 478 1 228 160 1 033 689 194 470 Manual Inputs Jan 08 92 568 064 1 033 689 0 Feb 08 O O Mar 08 f 0 0 Apr 08 17 825 2 000 000 2 000 000 May 08 i a Jun 08 i 0 O JULOS 86 o Toggle i Sep 08 0 Headers View All Loans O 4 5 O OG OCC GO CCOO Oct 08 fare Toggle Formula Nov 08 Fina ncing Go to the Financing Settings Equity Save Changes 300505010000 e Manual Injections or Repayments The upfront amount as defined in the Financing Settings is injected in the first time period In all other time periods the user can enter a manual injection positive number or repayment negative number e Drawdown to Fund CCF This column shows what funds are drawn down from the Surplus Cash account to fund the cash flow e Surplus Cash When equity is injected into a Portfolio it first feeds into the Surplus Cash account and is then drawn upon from there e Equity Repayments and Profit Once the Portfolio starts to make revenue and all the loans are repaid repayments to equity will be shown here e Profit Share This is profit share that is
32. Upspec TO L9 DI11005 153 159 Clarence Street Sydney 82 Option 1 Upspec TO L8 1011 27 55 Falcon St Crows Nest 100 APARTMENTS Retail 1011 27 55 Falcon St Crows Nest Complying Apartment Mix 1 Stage 1522 27 55 Falcon St Crows Nest Complying Apartment Mix 1 Stage 1011 27 55 Falcon St Crows Nest Isaac s Cashflow AUDINV11001 50 Carrington Street Sydney 50 Carrington Street Sydney 212 82 Collins Street November 2011 Update CHANGE TO PLANT LEVELS u 82 Collins Street November 2011 Update CHANGE TO PLANT LEVELS 123456 Al Ain Stadium Development Build 5 Office 123456 Al Ain Stadium Development Build 6 Hotel 123456 Al Ain Stadium Development Build 7 8811 ResiA 123456 Al Ain Stadium Development Build 9 10 12 Offices A 123456 Al Ain Stadium Development Multideck Parking 123456 Al Ain Stadium Development Phase 1 Infra amp Utilities 123456 Al Ain Stadium Development Sports Facilities 123456 Al Ain Stadium Development Stadium Landscape amp PR UAE1L02003 Al Zahia Phase 24 Al Zahia Phase 2 20yr Appin Vale 20yr Wilton 11602 Appin Wilton 11602 Appin Wilton 544 Aspect 400302 Aurora 534 Stage 10 Aurora 534 Stage 0 400302 Aurora 534 Aurora 534 Stage 178 ul Current user alisbona PDA54 EM Connected to EstateMasterData on EMDEV2K815QL2008 Version 6 93 3 In this view the user can do the following actions Filter Cash Flows Basic Consolidated i Net Cash Flow Before Inter
33. Welcome screen will appear If this is the first time you have come to this screen it will provide you with a quick demonstration on how it works DF Feasibility Welcome to EstateMaster Property Software om picota Managerial Ines bredi LA aaran Dur video demos aro i her E graai wap ho start Choose which solana iing Estaledlastos Hevtal ho stan working with He ta Ca abe icc Consolidation Check out ha alos mars pnd sated a DE Lite T W a ib PROFESSIONALS oftware He Fa sures EstateMaster 2015 Estate Master Pty Ltd to Estate Master CC 3 At the end of the demonstration it will prompt you to replay the demo or set the Regional Settings used for DF DM HF IA files D te so Hotel Ga Feasibility Conporabe jcc Consolidation De Lite C5 Replay Demo ey 2 2 Continue to Regional Setup Fesedback T EMPOWERING i i PROPERTY PROFESSIONALS lick Hera Product Tabs Discower EM sofware atures Pisya bp ail EstateMaster The tabs for each Estate Master product will display different information depending on whether it is installed on the active machine or not To customise the experience for each user each time the Welcome screen is started it will always revert to the last tab selected by that user on that machine Software is Installed When the Estate Master CC software is installed on the active machine the following will be displayed on the product
34. al and the IRR NPV calculation method and on the Portfolio Preferences for the IRR NPV calculation method Cash Flow IRR The highlighted Cash Flow s are discounted to present value at the nominated discount rate Target IRR lt is calculated based on Preferences set at the individual Cash Flow level for the Discount Rate and the IRR NPV calculation method and on the Portfolio Preferences for the IRR NPV calculation method Net Present Value Development Cash Flows Dashboard Item Gross development profit for the highlighted Cash Flows less any profit share split to either the Net Profit land ow ner or lenders Development Margin The ratio of Development Profit to either costs or revenues depending on the relevant KPI setting tt is calculated based on Portfolio Preferences for the Development Margin Method Cash Flow IRR The return on the highlighted Cash Flow s or the discount rate at w hich the NPV equals zero tt is calculated based on Preferences set at the individual Cash Flow level for the Discount Rate Conversion Method p a effective or nominal and the IRR NPV calculation method and on the Portfolio Preferences for the IRR NPV calculation method Equity IRR The IRR of the Equity Cash Flow including the return of equity and realisation of profits It is calculated based on Preferences set at the individual Cash Flow level for the Discount Rate Conversion Method p a effective or nominal Investment Cash Flows Dash
35. alised Terminal Rent Rent Frees Outgoings Letting Fees Fitout and Pre Sale Commissions 2015 Estate Master Pty Ltd DM Profit amp Margin Life to Date DM Profit amp Margin Year to Date DM Summary Life to Date DM Summary Year to Date A report for consolidating Estate Master DM Cash Flow s show ing the Net Development Profit and Development Margin for each Project and their Budgets in a Portfolio Before the report is generated the user is prompted to select w hat Budgets the user w ants to display on the report and w hether to show a variance to the Current Forecast against that Budget Budgets to Display Budgets to Display Show Budget Show Warnance Select All Fl Fl Original Budget W Fl Project Budget El 7j Previous Budget Fl Ei Cancel The report is broken up into 3 main sections 1 Whole of Life The entire project life span 2 Life to Date a k a Cost to Date The start of the project up until the Current Month w hich the user is prompted to select before generating the report Whether Life to Date includes or excludes the Current Month can be set via the Current Month Report Preferences 3 Forecast to Complete From the Current Month until the end of the Project Similar to the DM Profit 4 Margin Life to Date report but broken up into 3 main sections based on the Financial Year End as set in the Report Preferences 1 Current Month As defined by the user before gene
36. and all other currencies must be entered as a ratio to it Enter in the ISO code name and USD rate for the new currency and click OK New Exchange Rate Currency Code Currency Mame Exchange Rate Date Last Updated 2015 Estate Master Pty Ltd Security Permissions 87 10 Security Permissions By default there are no restrictions placed on users in Exporting Importing Cash Flows to from the Enterprise Database or generating reports in the Estate Master CC program It is an open environment where users can read write Cash Flow data that another user created and this may be suitable for smaller organisations or single user envronments Where additional security of data is required a feature is available in the Estate Master CC program to allocate permissions to users to be able to undertake certain actions such as generating reports or editing Cash Flows that they didn t originally create This feature is only available to users who are part of a Windows Domain as it uses Windows Active Directory for user authentication There are 4 levels of Permissions in Estate Master CC 1 Estate Master CC Administration Overall control of the application and the ability to apply permissions at any other subordinate level 2 Portfolio Permissions Control over reporting Portfolio data reports and dashboard editing the preferences and adding removing Cash Flows to from it 3 Project Permission Control over reporting P
37. are displayed when the user right clicks a Project or Portfolio File Menu New Portfolio Import EM File View Menu Home All Cash Flows Refresh Tools Menu Exchange Rates Options 2015 Estate Master Pty Ltd Start the Create New Portfolio wizard Allows the database user to import data from Estate Master source files DF DM HF and IA files This button allows the user to go back to the Home screen Displays the entire listing of all Estate Master Cash Flows stored in the Enterprise Database This button allows the user to refresh the list of Cash Flows that are displayed on the program This is useful if there is a possibility that data is been exported into the Enterprise Database by one user while another user has the Estate Master CC program open Allows the user to edit the exchange rates for defined currencies in the system or to add new currencies and their respective exchange rates Allows the user to edit the preferences and other settings that are used in the Estate Master CC program such as e General Program wide preferences such as automatically checking for software updates online e Portfolio Defaults Allows the user to edit the default preferences that are used in the Portfolios for generating reports Once a Portfolio is created the user can then edit the specific preferences for the selected Portfolio e Report Preferences Allows the user to edit the settings for generating so
38. arison Project Stanwell Gardens Consolidation En Region Domestic Projects Stanwell Gardens Stanwell Gardens Stanwell Gardens Stanwell Gardens Stanwell Gardens Stanwell Gardens Stanwell Gardens Precinct 2 Precinct 3 Precinct 4 Precinct 5 Precinct 6 Precinct 7 Precinct 8 Proposal to Bank Proposal to Bank Proposal to Bank Proposal to Bank Proposal to Bank Proposal to Bank Proposal to Bank i Net Cash Flow After Interest Sources amp Application of Funds i Summary Report i Summary Report By Cash Flow i DF vs DM Summary Currency Comparison Summary Cash Flow Eg Region International Projects Za Sydne List of Cash Flows Proje ct All Projects ist S in selected Project or Portfolio yr pos Financial Year Balance Sheet PV Cash Flow Equinox Square Variable Period Cash Flow EXS Marmion St CBRE Values 3 Acquis i Future Cash Flow Forrest View Apartments Gantt Chart Financial Year Gantt Chart ill Forrest View Apartments Budgets Jacksons Hill SAD2D11P Kellyville 400317 Lakes Edge 551 Stage O D237 1 Mansions Hotel Redevelopment D223 1 Medina Pilgrim Church Mode Consolidated All Portfolio in AUD Project Stanwell Gardens Consolidation _ Dashboard Modes Discount Rate 25 00 Portfolio Start Date Jan 2007 No of Cash Flows l 8 Gross Profit 46 063 653 Portfolio IRR 26 91 Cash Flow Breakeven Dec 2012 Last Updated 08 Sep 2015 Net Profit 46 063 653 Net Prese
39. as calculated in the individual Estate Master Cash Flow s are excluded e Performance Indicators are based on financing calculated from the Consolidated Financing lf an Estate Master IA Investment Cash Flow is part of the Portfolio this 2015 Estate Master Pty Ltd 38 Estate Master CC Summary By Cash Flow DF vs DM Summary Cash Flow Financial Year Cash Flow PV Cash Flow Variable Period Cash Flow Gantt Chart Fin Year Gantt Chart Development DF and DM Cash Flow report will displayed be on a Pre Funding basis o No Fees and Interest Charges will be shown at all o Only the Profit and Development Margin performance indicators pre funding w ill be displayed Development DF e For all columns amp DM o Interest Received will exclude any Interest Received on Surplus Cash calculated in the individual Estate Master Cash Flows o Interest Charged on Equity as calculated in the individual Estate Master Cash Flow s is excluded e For the individual Cash Flow columns o All Fees and Interest Charges as calculated in the individual Estate Master Cash Flows are excluded 3 o Only the Profit and Development Margin performance indicators pre funding w ill be displayed 3 o All other Profit Share to Land Owners and Lenders as calculated in the individual Estate Master Cash Flows are excluded 3 e For the Total All column o Fees and Interest Charges for are calcula
40. ash Flows 25 00 96 per annum Effective Sy Investment Discount Rate 14 Cash Flows 1250 1 per annum Nominal Hotel Discount Rate HF Cash Flows 20 00 56 per annum Effective w 2015 Estate Master Pty Ltd Working with Portfolios 23 Each Discount Rate can also have its own method of conversion from the annual discount rate to the monthly discount rate The difference is given in the following formulae Nominal Conversion D 12 Effective Conversion D 1 1 Where D is the annual discount rate Note o It is imperative that a universal usage for the conversion of the discount rate be adopted for all evaluations o The first formula simply divides the annual discount rate by 12 while the second formula is the effective conversion and takes into account the compounding on a monthly basis o The choice between these two methods of conversion only affects the NPV and IRR calculation not the development margin e IRR Assumption The calculation method for the Internal Rate of Return and Net Present Value They can be calculated on the Cash Flow that 1 Excludes financing costs interest and corporate tax 2 Includes financing costs but excludes interest and corporate tax 3 Includes financing costs and interest but excludes corporate tax 4 Includes financing costs interest and corporate tax 5 Includes corporate tax but excludes financing costs and interest These options are generally not recommen
41. assumptions for Summary Reports o Corporate Equity for Charts o Currency to convert all the selected Cash Flows to Portfolio Settings Portfolio Info Title amp Description Title KPI Settings Currency and Area Description Report Labels e Once the preferences have been set for the report the report will then be generated 2015 Estate Master Pty Ltd MES Estate Master CC Create Portfolios To create a Portfolio from a selection of Cash Flows e Select the Cash Flows using the check boxes All Cash Flows All Cash Flows Advanced F Project Name Equinox Square Equinox Square e Click on Create Portfolio from the Menu Bar e The Create Portfolio wizard will then appear Follow the screens to set all the preferences Portfolio Settings Portfolio Info Title amp Description Title KPI Settings Financing Description Corporate Equity Consolidated By Currency and Area Report Labels Consolidated For Portfolio Logo e Please note that only one version of a specific Cash Flow can be added to a Portfolio If the user attempts to add multiple versions of the same Cash Flow an error message will appear and those particular Cash Flows will be highlighted red Invalid Selections Invalid Cash Flows selected Only one version of a Cash Flow can be added to a Portfolio 2015 Estate Master Pty Ltd s Estate Master CC T 7 1 Reports One of the key advan
42. asted to occur or has occurred prior to the time that the report is generated 3 This data cannot be displayed because there is no way to apportion the fees and interest charges calculated on a consolidated basis across the individual cash flows Dashboard __ Applies To Consolidate All All e Development IRR and NPV DF DM amp IA o If the Portfolio is set to calculate the IRR NPV on a cash flow that includes financing costs and or interest these are calculated fromthe Consolidated Financing results o If an Estate Master lA is part of that Portfolio since this is a Development indicator WA will be displayed along with a warning Cannot calculate result because Portfolio level Consolidated Financing is being used e Investment IRR and NPV o If the Portfolio is set to calculate the IRR NPV on a cash flow that includes financing costs and or interest these are calculated from the Consolidated Financing results o If an Estate Master DF and or DMis part of that Portfolio since this is a Investment indicator N A will be displayed along with a warning Cannot calculate result because Portfolio level Consolidated Financing is being used e Portfolio IRR and NPV o If the Portfolio is set to calculate the IRR NPV on a cash flow that includes financing costs and or interest these are calculated from the Consolidated Financing results 2015 Estate Master Pty Ltd Working with Portfolios 41 Dashboard
43. at was licensed to use the Enterprise Database Integration Module To check this open the file in DF DM IA HF and select the Data gt Export to Database option e lf it is not licensed to use that feature a warning will appear If you wish to use this feature please contact Estate Master to upgrade your licence e lfitis licensed it will attempt to load the Export wizard If this is the case you can either o Continue to export the file to the database using this method or o Save the file and close it then use the Import EM File function within CC to import the data into the database 2015 Estate Master Pty Ltd so Estate Master CC 6 2 All Cash Flows Screen In addition to viewing a list of Portfolios and Projects on the Home screen there is a feature to allow the user to view the entire list of Cash Flows that exist in the Enterprise Database 1 Click View gt All Cash Flows 2 A new screen will then appear listing all Cash Flows cg a 5 ES fs S E All Cash Flows Estate Master CC Main if Q ma a A Y am R RIOGEGIE S x Create Import Home AllCash Refresh Exchange Options Delete Portfolio EM File Flows Rates Selection File View Tools Cash Flow Title 77 Option 1 Upspec L10 Project Number DI11005 153 159 Clarence Street Sydney DI11005 153 159 Clarence Street Sydney 79 Option 1 Upspec TO L9 DI11005 153 159 Clarence Street Sydney 80 Option 1
44. ative Project Cost against the Net Revenue Inventory A monthly consolidated stock report show ing the pre sales sales and settlements handovers occurring on a quantity area and value basis This report can also be run in Variable Period mode Forecast Summary A Summary Report taken at a specific point in time identified as the Current Month that displays Costs and Revenues such as Cost to Date Forecast to Complete Last 12 Months Next 12 Months Year to Date and Balance to Year End The definition of Cost to Date for this report can be set via the Current Month Report Preferences The treatment of DF Development Feasibility Cash Flows for this report can be set via the Forecast Summary Report Preferences DM Cash Flow Variation A report for consolidating Estate Master DM Cash Flows show ing the Latest budget Original or Project Budget w hichever is the more recently stored one and the Previous Forecast stored and their variations to the Current Budget on the follow ing basis Total Spend to Date next 12 months on a monthly basis 12 Month Total and Cost to Complete This report uses the follow ing logic e lf the Project Budget exists then use the most recent Project DM Budget for the Latest Budget e f the Project Budget doesn t exist then use the most recent Original DM Budget for the Latest Budget e lf the no Project or Original Budget exists then leave the Latest
45. ators for Current Projects DM Cash Flow s only Potential Projects DF Cash Flows only and All Projects DF DM Cash Flow s Currency Comparison The Summary Report displayed for up to two additional currencies to compare against the base Summary currency The currencies used can be selected via the Currency Comparison Report Preferences Cash Flow A monthly consolidated Cash Flow table Financial Year Cash Flow A yearly consolidated Cash Flow table based on the Financial Year End as set in the Report Preferences P amp L Statement A monthly consolidated Profit and Loss Statement using the data from the Financials sheet in the DF amp DM Cash Flow models Financial Year P amp L A yearly consolidated P L Statement based on the Financial Year End as set in the Report Statement Preferences Balance Sheet A monthly consolidated Balance Sheet using the data from the Financials sheet in the DF amp DM Cash Flow models Financial Year Balance A yearly consolidated Balance Sheet based on the Financial Year End as set in the Report Sheet Preferences PV Cash Flow A monthly consolidated Cash Flow table w ith all Costs and Revenues discounted to present value using the Portfolio s Discount Rate Variable Period Cash A consolidated Cash Flow table w here 3 phases of the time line can be grouped using Flow different rest periods as defaulted in the Report Preferences These rest periods can be adjusted w h
46. board Item The return on the highlighted Cash Flow s or the discount rate at w hich the NPV equals zero It is Cash Flow IRR calculated based on Preferences set at the individual Cash Flow level for the Discount Rate Conversion Method p a effective or nominal and the IRR NPV calculation method and on the Portfolio Preferences for the IRR NPV calculation method The highlighted Cash Flow s are discounted to present value at the nominated discount rate Target IRR lt is calculated based on Preferences set at the individual Cash Flow level for the Discount Rate and the IRR NPV calculation method and on the Portfolio Preferences for the IRR NPV calculation method Net Present Value Initial Yield Current net passing income as a percentage of the Investment s Adopted Valuation Reversionary Yield Total current market current net income w hat the properties w ould receive if all rents were current market rents and all vacancies w ere leased out as a percentage of the Investment s Adopted Valuation 2015 Estate Master Pty Ltd Dashboard st 8 3 Individual The KPI s displayed on the Individual dashboard are the same as the Consolidated dashboard but only for a single Cash Flow Mode iii Important Notes e All the results such as IRR Development Margin NPV are calculated using the settings that has been applied to the specific Cash Flow in either Estate Master DF DM or IA model itself These settings include o D
47. by the Cash Flows in the Portfolio This is used in the Equity Cash Flow chart report Max Corporate Equity 2015 Estate Master Pty Ltd 28 Estate Master CC e Currency and Area This setting has been preset using the Portfolio Defaults and can be reset for this particular Portfolio here Set the currency and area measurement for the Portfolio All Cash Flows in the selected Portfolio will have all its Cash Flows converted to these settings regardless if the Cash Flows have a mixture of differing currencies and area measurements Portfolio Currency Australian Dollar Portfolio Area Measurement Soh e Report Labels In the DF DM Cash Flow models the user has the ability to overwrite the headings in the Statutory Fees and the 3 Miscellaneous Costs sections By default those headings will appear on all the reports in Estate Master CC if all the Cash Flows in the selected Portfolio have the same headings for these sections i e they are consistent If they are not consistent i e on one Cash Flow the user had overwritten Miscellaneous Cost 1 heading with Landscaping and then on another Cash Flow in the Portfolio that same section was entered as Infrastructure then the program will use the default headings The user then has the option wa this setting overwrite the headings with their own custom labels for reporting in Estate Master CC This does not update the individual DF DM Cash Flow models it is only
48. calculate then re export it back to the Enterprise Database Estate Master CC Scenario Similar to the above scenario the report f is based on data that is only available in newer Thi rt tb ted on Portfolios that contai i QD gt gt Estate Master DF DM Cash Flows 7 O an any varmon Estate Master Cash Flow files and the user is trying You may need to re export your Estate Master DF DM Cash Flows using to run the report on older Cash Flows that did not the latest version of the software to ensure all results can be generated contain that required data when they were exported to the database Solution If this message appears the user does not have the option to run the report The user must import the older cash flows into the latest version of the Estate Master application DF DM etc let it recalculate then re export it back to the Enterprise Database for this report to be able to be generated Estate Mastercc Scenario Similar to the above scenario Some of the selected cash flows have been created in an earlier version Solution If this message appears the user does Ly eaan therefore do not have all the information required for not have the option to run the report The user must import the older cash flows into the latest version of the Estate Master application DF DM etc let it recalculate then re export it back to the Enterprise Database for this report to be able to be generated Estate Mas
49. change Rates follow these steps 1 Click Tools gt Exchange Rate S Options Currency Code Currency Name Afghanistan Afghani 515555 Albanian Leke 236583 Algerian Dinar E POOP reer re semen Bahamian Dollar Bahraini Dinar Bangladeshi Taka Barbados Dollar Bermudian Dollar Boliviano Brazilian Real British Pound Current USD Rate Date Last Update 11 May 2015 02 Apr 2013 04 Oct 2012 04 Oct 2012 04 Jun 2009 04 Jun 2009 08 Apr 2013 04 Jun 2009 04 Oct 2012 26 Mar 2013 26 Jun 2009 31 Mar 2014 3 The US Dollar ISO Code USD is the fixed base rate and all other currencies must be entered as a ratio to it Edit the rate and click OK Edit Exchange Rate Currency Code Currency Mame Exchange Rate Date Last Updated Australian Dollar 1 USD 31 Mar 2014 Cancel 2015 Estate Master Pty Ltd Exchange Rates 85 9 2 Adding Rates To add a new Exchange Rate that is not in the list follow these steps 1 Click Tools gt Exchange Rate S Options Currency Code Currency Name Albanian Leke Algerian Dinar Argentine Peso Australian Dollar 31 Mar 2014 Bahamian Dollar 04 Jun 2009 Bahraini Dinar 04 Jun 2009 Bangladeshi Taka 12 08 Apr 2013 Barbados Dollar EH 04 Jun 2009 Bermudian Dollar 96 04 Oct 2012 Boliviano 28 Mar 2013 Brazilian Real 26 Jun 2009 British Pound 31 Mar 2014 3 The US Dollar ISO Code USD is the fixed base rate
50. ct Project Number PLOOU Project Name Project Title 5 1 Renaming Projects 1 In the Projects pane right click the Project you want to rename and click Edit Project Name This button will only be enabled if the user has sufficient permissions Write or Full on the Project being renamed Projects All Projects Merge Projects Delete Project Permissions 2 A form will appear where the Project Number and Name can be edited Make the changes and press Save Edit Project Name Project Number MAS Project Name Mirage Palace Resort 3 The application will then update all Cash Flows that belong to that Project with the new details in the database a Renaming a Project via this method doesn t update the source files i e the emdf emdm etc lt is recommended that if a Project is renamed in Estate Master CC then the source files be manually updated as well to ensure that when they are next imported they match the renamed Project b If the Cash Flows in the database are ever imported back into their related application i e DF DM IA HF then the updated details will automatically appear in the Intro tab of that application Important things to remember e If you attempt to change the Project Number to one that already exists in the database but keep 2015 Estate Master Pty Ltd Working with Projects 45 the same Project Name you will not be allowed e f you attempt to change the Projec
51. ct Consolidated results i e creating and reporting on a Portfolio It will have no impact when using the Comparison reporting where the financing calculations and results from the individual Estate Master Cash Flows are maintained and used for reporting Therefore the financing results shown on a Consolidate Report for one Portfolio will most likely be different when viewing a Comparison Report for the same Portfolio The reason behind this is that when Consolidated Financing is used it views the group of cash flows as one single consolidated cash flow and therefore it cannot effectively apportion funding costs across the separate individual cash flows Below is an overview of the impact Consolidated Financing will have on reporting in Estate Master CC Applies To Net Cash Flow After All e This is the Net Cash Flow before Interest plus the Loan 1 and Senior Loan Interest Interest DF DM amp IA and Fees calculated from the Consolidated Financing e All other Loan Fees and Interest Charges as calculated in the individual Estate Master Cash Flows are excluded Sources and All e Total Equity in Sources of Funds is calculated from the Equity Injections in the Applications of DF DM amp IA Consolidated Financing Funds e Loan 1 and Senior Loan Draw dow ns in Sources of Funds are calculated from the Loan Draw dow ns in the Consolidated Financing e All Loan Draw dow ns for Loans 2 and 3 as calculated in the individual
52. d in the individual Estate Master Cash Flow s is excluded o Fees and Interest Charges for Loan 1 and Senior Loan are calculated from the Consolidated Financing results o All Fees and Interest Charges for Loans 2 and 3 as calculated in the individual Estate Master Cash Flows are excluded e All other budgets Original Project and Previous are based on separately financed Cash Flows e f an Estate Master IA and or DF Cash Flow is part of the Portfolio this DM report w ill displayed be on a Pre Funding basis and no Fees and Interest Charges will be shown at all DM Cost Code Cash DM e Only the financing costs calculated at the DM Cash Flow level are displayed in the Flow Code Description list for the user to select DM Profit amp Margin DM e The Current Forecast results are based on Cash Flows financed at a consolidated Portfolio level while all other Forecast Budget results are based on separately financed Cash Flows DM Summary DM e The Current Forecast results are based on Cash Flows financed at a consolidated Portfolio level w hile all other Forecast Budget results are based on separately financed Cash Flows 1 This financing feature is currently not available in Portfolio Financing hence why it is currently excluded from cost calculations when Portfolio Financing is enabled even though it may have been included at the individual Cash Flow financing level 2 A historical cost is that which in the Cash Flowis forec
53. dded by mistake select the Cash Flow in the top half of the screen and click Remove Portfolio Division Commerical Select Project Number Project Name Cash Flow Title Description a Ph PAL scenes IN AR A COC COC COO COO CnC C tO Ont Cer Cree O oe One CoCr re one one nneey la MH100 SkyPark Residential Spec Development Speculative Residential with no sales off the plan 4 lin O 6 Once the Cash Flows have been added click on Home and the program will return to the Home screen with the new Portfolios listed Option 2 Creating a Portfolio from the All Cash Flows Screen Follow these instructions to go to the View All Cash Flows screen select a group of Cash Flows to add to the new Portfolio and then set the Portfolio Preferences 2015 Estate Master Pty Ltd Working with Portfolios 31 4 3 Portfolio Financing When a cash flow is initially created in Estate Independently Financed Cash Flows Master DF DM or lA it is independently financed meaning that financing calculations and results in an individual model are based on the costs and revenues in that specific model only and are not i j ive if it Net Cash Flow Net Gash Flow Net Cash Flow impacted by other models irrespective if it is part of paa o a a larger project or other consolidated entity Equity and Debt r Equity and Debt Equity and Debt For example if there are 2 Estate Master DM Funding J Funding Funding models repre
54. ded as discounting an after interest cash flow is a form of double counting interest cost IRR Assumption On cash flow that includes all financing costs interest and corp tax oe e Development Margin Assumption The calculation method for the Development Margin in development Estate Master DF and DM cash flows It is the ratio of Development Profit to either 1 Total Costs after Tax Reclaimed You can select whether or not Selling Costs and or Leasing Costs are included as part of the total costs 2 Total Revenue net of Tax Payments 3 Total Net Sale Proceeds net of Tax Payments and Selling Costs Development Margin Assumption on total revenue net of Tax 2015 Estate Master Pty Ltd 24 Estate Master CC 4 1 2 Financing e Consolidated Financing This is the default setting for applying Portfolio Level Financing for Consolidated reporting purposes e g consolidating stages of a project The 2 options are 1 Use Financing from Individual Cash Flows For all cash flows that exist in a Portfolio assume they are independently financed as per the Financing calculations and results in their individual models and that each cash flow has no financing impact on any other model in the Portfolio e g the profit in one cash flow is not used to fund a later stage 2 Apply Portfolio Level Financing For all cash flows that exist in a Portfolio ignore all Financing calculations and results in their individual m
55. dget available worms F thara de mm Corina Bouedect cat fer a rnare sr DRA Sach El thon tha rra Esmas wll he srian ac tha I example T Tere E mo Orginal BUOQET SET TOT a particulas Life CdS PEC Men TRE LUTE GUDET WN DE appied ab UNE Original Budget for reporting purposes only e Variation Display Select whether the variations to the Current Budget are displayed as an amount or as a percentage Variation Display Show variation as amount 2015 Estate Master Pty Ltd 7 3 5 Current Month e Current Month Select how the Current Month is defined in the various reports where Current Month Life to Date Cost to Date Forecast to Complete Previous x Months Next x Months Year to Date and Balance to Year End is reported lt can be defined as o The current month that the report is being run in o The previous month that the report is being run in o Manually set each time the report is run via a user prompt Current Month Manually set each time the report is run e Cost to Date Select whether the current month Cash Flow items are to be included or excluded from the total Cost to Date or Life to Date o If included it will also include it from the Previous 12 Months and Year to Date reporting o If excluded it will include it in the Forecast to Complete Next 12 Months and Balance to Year End reporting Cost to Date Include Current Month as Cost to Date 7
56. dual investment cash flow s including e Tenant Analysis Charts indicating top 5 tenants by NLA and Gross Passing Income e Weighted Lease Duration Vacant Area analysis and Gross Income and Outgoings e Outputs related to the Capitalisation approach to valuation Capitalised Value Yields etc All Yields are based on the Captilised Value e Outputs related to the DCF approach to valuation NPV IRR Terminal Sale Value etc 2015 Estate Master Pty Ltd Estate Master CC 7 6 Data Validation some reports may only generate if the data required is available There can be several reasons for this including the report being based on data that is only available in newer Estate Master Cash Flow files or the report is based on a specific type of Cash Flow only Below are example messages that may appear EstateMasterCC SSS Scenario The report is based on data that is only e available in newer Estate Master Cash Flow files and O orbe ces the user is trying to run the report on older Cash Do you wish to proceed with the available information for the other Flows that did not contal n that req u j red data when Cash Flows they were exported to the database Yes Solution The user can continue to run the report however the older cash flows will be omitted from it To ensure that all cash flows are included the user can import the older cash flows into the latest version of the Estate Master application DF DM etc let it re
57. e land ow ner or lender at the completion of the project Net Profit Gross development profit for the Project Portfolio less any profit share split to either the land ow ner or lenders Development Margin The ratio of Development Profit to either cost sales or total revenue lt is calculated based on Portfolio Preferences for the Development Margin Method Discount Rate The Development Discount Rate or Target IRR is simplistically the desired returns on funds invested For discounted cash flow analysis the discount rate is the rate at w hich future Development Cash Flows are discounted to present value lt is based on the Portfolio Preference Project Portfolio IRR The return on the Development Cash Flow s or the discount rate at w hich the NPV equals zero tt is calculated based on Portfolio Preferences for the Discount Rate Conversion Method p a effective or nominal and the IRR NPV calculation method Net Present Value The Development Cash Flow s are discounted to present value at the nominated discount rate Target IRR It is calculated based on Portfolio Preferences for the Discount Rate and the IRR NPV calculation method Equity IRR The IRR of the Equity Cash Flow including the return of equity and realisation of profits It is calculated based on Portfolio Preferences for the Discount Rate Conversion Method p a effective or nominal Portfolio Project Start The earliest date that any of the Development Cash Flow s in the Proj
58. e user 2 4 w a to reset them i gt a Delete Portfolio Edit Financing Edit the portfolio financing Cash Flow manually a NE inject repay equity and debt and interest rate En Red Fz Use Latest Cash Flows for Portfolio variations specific to that Portfolio The Manual poed E Paint Reports Adjustments screen will then appear to allow the Permissions user to view the Financing Cash Flow and make changes Clone Portfolio Create a copy of the selected Portfolio including all the Cash Flows it contains and its settings Delete Portfolio Remove the Portfolio from the system This does not delete any Cash Flows from the database it just deletes defined Portfolio and its settings and leaves the Cash Flows that existed in it intact Add Remove Cash Load the screen that allows the user to add 2015 Estate Master Pty Ltd Operating the Program to Flows remove Cash Flows to from the Portfolio Fix current Cash Flows This ensures that the Cash Flows currently in that to Portfolio Portfolio are fixed to that Portfolio and that the Portfolio is not automatically updated when a new version of any on of those Cash Flows are exported to the Enterprise Database This is used when you want to lock down a Portfolio with the current set of Cash Flows in it Use Latest Cash Flow This ensures that always the latest version of all for Portfolio Cash Flows are used for that Portfolio and for reporting purposes This only appli
59. e user is prompted to unlock lock the same Preference for all existing Portfolios 2015 Estate Master Pty Ltd
60. ect the user exports the 4 options they are analysing to another separate Project At this stage the CC Database will contain 4 Projects 3 containing DM Cash Flows for the active projects and 1 containing DF Cash Flows for their prospective project y The User runs the CC Database software to group their Project into Portfolios Q Project A B are Residential Projects so the User creates a Portfolio called Residential Project C and the Prospective Project are Commercial so the User creates a second Portfolio called Commercial Projects Aand C are located in one State so the User decides to create another Portfolio called NSW The User places the Cash Flows in the relevant Portfolios Q 3 Portfolios have now been created in the CC Database The User can now generate numerous reports for the Portfolio of Cash Flows they have made At any time the user can add more Cash Flows to a Portfolio Q The User updates the DF and DM Cash Flows for their Projects and exports them to the database again When they generate the reports in the CC Database the system will use the latest version of the cash flow 13 System Requirements To install and operate Estate Master CC efficiently the following is recommended e Intel Core 2 Duo 3 GHz or Quad 2 4GHz processor or equivalent e Microsoft Windows Vista SP2 Pro or later or Windows Server 2008 or later e Estate Master DF or DM 3 1 or higher IA 2 1 or higher or HF 2 0 or higher
61. ect Portfolio started Date Cash Flow Breakeven The date the Project Portfolio Cumulative Cash flow first turns positive Peak Debt Exposure The date of the maximum cash flow exposure after equity and including capitalised interest Debt Breakeven The payback date for the equity debt facility is the last date w hen total equity debt is repaid in the Project Portfolio 2015 Estate Master Pty Ltd Dashboard Investment Cash Flows Dashboard Item No of Cash Flows Last Updated Net Lettable Area No of Car Spaces Project Portfolio Valuation Vacancy area Vacancy Weighted Lease Duration Investment Period Discount Rate Project Portfolio IRR Net Present Value Net Passing Income Initial Yield Net Market Income Reversionary Yield 2015 Estate Master Pty Ltd The number of Investment Cash Flow s Estate Master lA that are in the selected Project or Portfolio The date of the most recently updated Investment Cash Flow in the selected Project or Portfolio The amalgamated net lettable area of all the Investment Cash Flow s Estate Master IA in the selected Project or Portfolio If Cash Flows have different measurement units for their site area then the program w ill convert it to a common unit and can be changed to another unit as per the drop dow n box available If one of the Investment Cash Flow s in the selected Project or Portfolio does not have a Net Lettable Area entered for it then
62. ect Type DF Residential Spec Development Speculative Residential with no sales off the plan om Current Miscellaneous O Add O Remove All Available Cash Flows All Cash Flows Advanced Filter Project Name Cash Flow Title Description Equinox Square Option 1 Leased up by Dec 08 6 5 ci Equinox Square Option 3 Fully Leased to single tenant EXS Marmion St CBRE Values 3 Acquisition Final Alcoa Building EXS Marmion St CBRE Values 3 Acquisition Final EXS Marmion St CBRE Values 3 Acquisition Final Forrest View Apartments Forrest View Apartments Forrest View Apartments Forrest View Apartments Commercial Tower With Profit Share Resi Tower With 17 Profit Share 200 Lots Detailed DM Detailed DM month Detailed DM gtr 1 1 Option 1 200 Apartments with ground 200 Apartments with ground 200 Apartments with ground Forrest View Apartments Forrest View Phase 1 200 Apartments with ground Increased arner ots Ontinn Forrest View Anartments 4 MA gt Current user alisbona PDA54 EM Connected to EstateMasterData on EMDEV2K8 SQL2008 Version 6 93 4 In the All Available Cash Flows screen select the Cash Flows that to add to the Portfolio and click on Ada All Available Cash Flows All Cash Flows bus Advanced Filter Project Numbe Project N Equinox Square 2015 Estate Master Pty Ltd 30 Estate Master CC 5 Ifa Cash Flows has been a
63. en the report is run along w ith the ability to set a custom start and end date range for the report 5 All Periods Select Range Stat Mar 2011 Sle End Mar 2018 fe Future Cash Flow A summarised consolidated Cash Flow table froma user defined point in time w here all data before the selected month is ignored 2015 Estate Master Pty Ltd Nominated Start Date Nominate the date Month and Year from which this report is to start from Start Date Mar 2011 EA Cancel The cash flow is summarised by Gross Sales Revenue Other Revenue Gross Rental Income Interest Received on Deposits and Other Income and Total Net Costs all development selling and leasing costs excluding loan fees and interest charges Interest Charged and Received on Equity and Profit Share Payments are not displayed on this report Gantt Chart A graphical timeline of the consolidated monthly Cash Flow Financial Year Gantt Chart A graphical timeline of the consolidated financial year Cash Flow Cash Flow Charts Three charts are generated 1 Consolidated Cash Flow Displays the consolidated Overdraft Net Cash Flow and Cumulative Net Cash Flow 2 Consolidated Equity Cash Flow Displays the Equity Cash Flow against the Maximum Equity benchmark as set in the Portfolio Settings It allows the user to see where if their actual equity requirements have exceeded the limit 3 Consolidated Project Costs vs Net Revenue Displays a cumul
64. er Data 6 10 5753 19394 D TFS EM Software Source Main Estate Master Presentation CC bin x86 Debug EstateMaster Data DF 6 10 5753 19394 D TFS EM Software Source Main EstateMaster Presentation CC bin x86 Debug EstateMaster Data DM 6 10 5753 19394 D TFS EM Software Source Main Estate Master Presentation CC bin x86 Debug EstateMaster Data HF 2 0 0 28 D TFS EM Software Source Main Estate Master Presentation CC bin x86 Debug EstateMaster Database 1 0 0 8 D TFS EM Software Source Main Estate Master Presentation CC bin x86 Debug Y 4 m p Copy Info f Close 2015 Estate Master Pty Ltd 3 2 2 Ribbon Menu Operating the Program The Ribbon Menu is located at the top of the application window and provides the user with the functions available in the program CO 18 a A s fs A Main Menu Estate Master CC Main Portfolio l yg lt z ZA l I La ann A pa ES m l 4 New Import Home AllCash Refresh Exchange Options Settings Financing Clone Delete Add Remove Use Use Print Permissions Portfolio EM File Rates Cash Flows Fixed Latest Reports File Tools Active Portfolio The Ribbon Menu has 2 definable parts 1 The Main tab Functions that apply to entire application These are described in more detail below 2 The Portfolio Project tab Functions that apply to the currently selected Project or Portfolio They are identified by an aqua coloured menu button These options are the same that
65. er Pty Ltd Working with Portfolios 25 Portfolio Area Measurement SaFt 2015 Estate Master Pty Ltd 26 Estate Master CC 4 2 Creating Portfolios There are 2 ways of creating a Portfolio Option 1 Creating a Portfolio from the Home screen 1 To begin creating a Portfolio from the Home screen you can either e Go to File gt New Portfolio and following the prompts to set the Portfolio Preferences and add the Cash Flows to it ZO Import EM File e Right click the Portfolio Pane and select New Portfolio from the menu and following the prompts to set the Portfolio Preferences and add the Cash Flows to it Portfolios All Portfolios Portfolio Cash l a Crows nest Project Number Division Commee EA Division Land De oe Edit Settings H Ea Investments E 0 0 2 The Portfolio Settings wizard will then appear Some of these settings will be pre loaded with a default setting as set by the user in the Portfolio Defaults The user will have to complete each step of the wizard to customise the settings for that particular Portfolio They comprise of e Title amp Description Enter the title for the Portfolio a brief description of it who the Portfolio has been created by and who the Portfolio has been created for This information will appear on reports Partfalio Info Title Division Commerical Description All non residential projects Consolidated By John S
66. ersion Method p a effective or nominal The Investment Cash Flows are discounted to present value at the nominated discount rate Target IRR lt is calculated based on Portfolio Preferences for the Discount Rate The amalgamated current net passing income of all the Investment properties in the selected Project or Portfolio Current net passing income as a percentage of the Project Portfolio Valuation The amalgamated net market income of all the Investment properties in the selected Project or Portfolio Total current market current net income w hat the properties w ould receive if all rents were current market rents and all vacancies w ere leased out as a percentage of the Project Portfolio Valuation s Estate Master CC 8 2 Comparison Comparing the Best and Worst Options By clicking on one of the KPI s it will display the Best and Worst Cash Flow in the selected Project Portfolio based on that KPI and highlight it 9 460 084 Met Profit y 9 460 084 api l 29 57 Development Marg k 29 57 Best Option 60 87 Cash Flow IRR 60 87 Worst Optior Precinct 1 MA Equity IRR MA Precinct 1 Selecting a KPI for the Best Worst Options All Cash Flows Dashboard Item The return on the highlighted Cash Flow s or the discount rate at which the NPV equals zero It is calculated based on Preferences set at the individual Cash Flow level for the Discount Rate Conversion Method p a effective or nomin
67. es when there are multiple versions of a specific Cash Flow Cash Flows that have an identical Cash Flow Title stored in the Enterprise Database Print Reports Load the Printing Menu for that Portfolio Permissions Load the Portfolio Permissions editor This will only be enabled if Security Permissions have been enabled Project Pane Context Menu Edit Project Name Allows the user to edit the Project Number and Projects All Projects Name Number do 2 Merge Project Merge the selected Project with another one This Feit Project Name will move the Cash Flows in that selected Project tO usw seres gt Merge Projects another and then delete the empty Project Delete Project Delete Project Removes the Project from the system as long as there are now Cash Flows existing in it If the Cash Flows are to be deleted as well then they must be deleted via the All Cash Flows screen first before attempting to delete the Project they belong to Permissions Load the Project Permissions editor This will only be enabled if Security Permissions have been enabled Cash Flow List Context Menu Use Latest Cash Flow This ensures that always the latest version of Portfolio Cash Flows the selected Cash Flow is used in that Project Number Project Name Cash Flow Title Portfolio and for reporting purposes This only LE se Use Latest Cash Flow a applies when there are multiple versions of tilda the selec
68. est Net Cash Flow After Interest Sources amp Application of Funds g Development Summary Report Summary Report By Cash Flow DF vs DM Summary Currency Comparison Summary Cash Flow Financial Year Cash Flow P amp L Statement Financial Year P amp L Statement Balance Sheet Financial Year Balance Sheet PV Cash Flow Variable Period Cash Flow Future Cash Flow Gantt Chart Financial Year Gantt Chart Cash Flow Chart Inventory Forecast Summary DM Variation DM Cash Flow Variation DM Cost Code Cash Flow There is a basic filter for the Cash Flow List that will allow the user the either show e All Cash Flows that exist in the database irrespective of who created them or e My Cash Flows being those created by the current user of Estate Master CC or e My Projects being those created by the current user of Estate Master CC All Cash Flows All Cash Flows las Advanced Filter Select Project Num All Cash Flows r My Cash Flows 2015 Estate Master Pty Ltd Working with Cash Flows 51 Filter Cash Flows Advanced There is an advanced filter for the Cash Flow List that will allow the user to filter it based on numerous criteria To use the Advanced filter e Click on the Advanced Filter button A form will load with a list of all the criteria that the user can filter the list on For example the screenshot below demonstrates the user wanting to filter the lis
69. fter Interest Sources amp Application of Funds Ed Development E Summary Report Summary Report By Cash Flow DF vs DM Summary Currency Comparison Summary Cash Flow Financial Year Cash Flow PE L Statement Financial Year P amp L Statement Balance Sheet Financial Year Balance Sheet 1 PV Cash Flow 1 Variable Period Cash Flow Future Cash Flow Gantt Chart Financial Year Gantt Chart Cash Flow Chart Inventory Forecast Summary DM Variation DM Cash Flow Variation DM Cost Code Cash Flow Print Tithe Page Select Printer WEMSES2KS SHARP Mx 4100n EM BE Print Contents Page Division Commerical Comparison Reports Ed All 5 Net Cash Flow Before Interest Net Cash Flow After Interest A Sources amp Application of Funds Ed Development Summary Report Cash Flow Financial Year Cash Flow P amp L Statement Financial Year P amp L Statement Balance Sheet Financial Year Balance Sheet 1 PV Cash Flow Variable Period Cash Flow Future Cash Flow Gantt Chart Financial Year Gantt Chart Cash Flow Chart Inventory Ed Investment Financial Year DCF Capitalisation Summary Executive Summary r Preferences Close In addition to printing the various reports the user can also tick the related checkboxes to print a 2015 Estate Master Pty Ltd Estate Master CC e Title Page Includes the corporate logo and the portfolio image e Contents Page Includes a list of all the Projects and their Cash Flow
70. g Currency and Area Once a Portfolio is created the settings can be further edited by using the Edit Portfolio Settings function Report Preferences M To edit or view these defaults click Tools gt Options gt Portfolio Defaults iia ie Preference Permissions If Security Permissions have been enabled on your Estate Master CC then each preference setting will have its own protection toggle e Indicates that the current Preference is locked and cannot be changed e Indicates that the current Preference is unlocked and can be changed lf the user currently running Estate Master CC is in the Administrator Group and has Full Control then these buttons will be enabled and the the user can change the permissions settings for each preference For all other users these buttons will be disabled and they will not be able to change the permission setting regardless of their permission level on Portfolios or Projects KPI Defaults e Corporate Discount Rate The discount rate to apply to the whole Portfolio consolidated cash flow for calculating the Net Present Values There are 3 discount rates available 1 Development Discount Rate applied to Development Estate Master DF and DM cash flows 2 Investment Discount Rate applied to Investment Estate Master IA cash flows 3 Hotel Discount Rate applied to Hotel Estate Master HF cash flows Corporate Discount Rates Development Discount Rate DROM C
71. he return on the Development Cash Flow s or the discount rate at w hich the NPV equals zero tt is calculated based on Portfolio Preferences for the Discount Rate Conversion Method p a effective or nominal and the IRR calculation method Net Present The Development Cash Flows are discounted to present value at the nominated discount rate Value Target IRR It is calculated based on Portfolio Preferences for the Discount Rate and the IRR NPV calculation method Investment Period The start and end dates for the investment period of the selected Project or Portfolio or essentially the earliest start date and the latest end date for all the Investment Cash Flows Estate Master IA Discount Rate The Investment Discount Rate or Target IRR is simplistically the desired returns on funds invested For discounted cash flow analysis the discount rate is the rate at w hich future Investment Cash Flow s are discounted to present value It is based on the Portfolio Preference IRR The return on the Investment Cash Flows or the discount rate at which the NPV equals zero It is calculated based on Portfolio Preferences for the Discount Rate Conversion Method p a effective or nominal and the IRR NPV calculation method Net Present The Investment Cash Flows are discounted to present value at the nominated discount rate Value Target IRR It is calculated based on Portfolio Preferences for the Discount Rate and the IRR NPV calculation method Portfoli
72. heck their Manual Adjustments e A new Cash Flow has been added to the Portfolio requiring additional Equity or Debt funding to be manually injected into the Portfolio Financing cash flow at certain time periods to fund the extra costs e A Cash Flow has been deleted from the Portfolio reducing the requirement for Equity or Debt funding e A Cash Flow has changed in duration possibly equity or debt funding in different time periods e A Cash Flow has been updated with a higher gross profit meaning that either Equity or Loan 1 can be repaid faster with manual repayments lf the user views the Manual Adjustments screen but makes no amendments to them they will receive the following message to confirm that they wish to make no updates The user can ignore this warning and it will not reappear until another change is made to a Portfolio Check Manual Inputs One or more Cash Flows inthe Portfolio have either been 9 added removed updated Do you wish to close without checking and updating Financing Manual Inputs IF You select Yes you will not be prompted until another change haz occurred in the Portfolio 2015 Estate Master Pty Ltd Working with Portfolios 37 4 3 3 Impact on Reporting When Consolidated Financing is enabled it is important for the user to understand not only how it works but how it impacts the results in Estate Master CC such as the Reports and Dashboards As mentioned previously it will only impa
73. iscount Rate o IRR NPV calculation method i e including excluding financing costs interest and corporate tax o Development Margin calculation method i e margin on costs including excluding selling costs leasing costs etc o Discount Rate Annual to Monthly Conversion method i e Nominal or Effective o Area measurement i e sqm saft etc o Currency e Therefore those settings can only be edited while the Cash Flow is in either the Estate Master DF DM or IA program 2015 Estate Master Pty Ltd Exchange Rates 83 9 Exchange Rates The Estate Master CC program has the ability to consolidate Cash Flows that have been developed in different currencies It achieves this by allowing the user to maintain a Currency Exchange Rate table and then selecting what Currency a particular Portfolio should always be converted and reported in The Exchange Rate conversion affects the following areas of the program 1 Generating Reports from a Portfolio If a Portfolio contains Cash Flows based on different currencies then the selected base currency in its Portfolio Settings will convert all Cash Flows to a common currency for reporting purposes 2 Generating Reports from the View All Cash Flows screen If the user is selecting multiple Cash Flows from the View All Cash Flows screen and elect to generate a report they will be prompted to set preferences similar to creating a Portfolio One of these preferences is the
74. lios listed o Drag and drop them to another Project listed e By clicking on any of the column headers in the list you can sort the records appropriately e By selecting on any of the column headers in the list except Project Number Project Name and Cash Flow Title you can move and change the order in which they appear in the grid e Ifa exists next to a Cash Flow in the list it means that there are multiple versions of a specific Cash Flow Cash Flows that have an identical Cash Flow Title stored in the Enterprise Database By clicking and expanding the Cash Flow an additional sub list will appear for that specific Cash Flow e When right clicking a Cash Flow while a Portfolio is selected a menu will appear with certain functions Report Pane This pane lists all the Reports that are available in the program e By clicking on the Consolidate Comparison Report Toggle the list of reports in the pane will change to reflect the options available e By double clicking a Report it will generate the report for the selected Portfolio or group of Cash Flows e By clicking on Print Menu it will load a form to allow the user to select multiple reports and print them directly to a printer or PDF for the selected Portfolio or group of Cash Flows Dashboard The Dashboard provides a snapshot of either a selected Portfolio Project or Cash Flow instantly displaying KPI s such as Profit NPV IRR Breakeven Dates etc wi
75. me of the reports e Permissions Allows the user to set apply a Permissions Security layer over the Enterprise Database that the Estate Master CC program is connected to e Estate Master CC 3 2 3 3 2 4 Quick Access Toolbar The Quick Access Toolbar is located in the top left corner of the application window and provides the user with shortcuts to the various functions available in the program co Ae ttA es Main Portfolio Customising the Quick Access Toolbar e To remove an item from the Toolbar Right click the icon and select Remove from Quick Access Toolbar a x Remove from Quick Access Toolbar e To add an item to the Toolbar Right click the icon in the Ribbon and select Add to Quick Access Toolbar ill Preference alll Addto Quick Access Toolbar e To move the Toolbar below or above the Ribbon Click on the arrow icon and select Show Below Above the Ribbon Show Below the Ribbon Minimize the Ribbon Context Menus Context Menus pop up when right clicking certain objects offering a list of options which vary depending on the item selected Portfolio Pane Context Menu New Portfolio Start the Create New Portfolio wizard Portfolios All Portfolios Port En Cro nest Edit Settings Edit the preferences such as KPI Settings and E New Pontoi Currency specific to that Portfolio The Portfolio Es pon Edit Settings Settings wizard will then appear to allow th
76. mith Consolidated For Board of Directors 2015 Estate Master Pty Ltd Working with Portfolios 27 e KPI Settings These are the settings that have been preset in the Portfoilio Defaults It is at this point that the user can customise them for this particular Portfolio Corporate Discount Rates Development Discount Rate DF DM Cash Flows 20 00 per annum Nominal Investment Discount Rate LA Cash Flows 20 00 96 per annum Effective IRR Assumption On cash flow that includes financing costs but excludes interest and corp tax Development Margin Assumption on total development costs inc selling costs e Financing Some of these settings have been preset using the Portfolio Defaults and can be reset for this particular Portfolio here In addition if the user is adopting Portfolio Level Financing they can set the funding limits for Equity and Loan 1 contributions and Line Fee payments for Loan 1 and Senior Loan The Manual Adjustments feature will be enabled once the Portfolio has been created Consolidated Financing Apply Portfolio Level Financing Sources of Funding Initial Injection Drawdown Rate Me p a Lime Fees pal Equity 1 000 000 Loan 1 1 000 000 6 00 Senior Loan Line of Credit 0 00 0 Manual Adjustments Interest Rate Calculation per annum Effective Profit Share e Corporate Equity The notional Equity limit for the Portfolio to track against the actual equity utilised
77. n Clicking on it will expand the list to show the Portfolios that this Cash Flow belongs to A S56 Bellavista Tower 2 996 Bella Vista Tower Bella 1 Domestic Projects a E SSG Bellavista Tower 2 996 Parramatta Units e Confirm the Cash Flows you want to delete and press the Delete button e The cash flows will then be deleted from the database Please note that this method of deleting Cash Flows doesn t automatically delete the history for the selected Cash Flows as per the Delete one at a time method it will only specifically delete the Cash Flows that were selected so if you want to delete an Cash Flow and all of its history you will need to ensure that all the checkboxes for the historical Cash Flows are also selected 2015 Estate Master Pty Ltd Working with Cash Flows 53 Print Reports To print reports from a selection of Cash Flows e Select the Cash Flows using the check boxes All Cash Flows All Cash Flows Advanced F Select Project Number Project Name Equinox Square Equinox Square ra e Using the Report Toggle select whether a Consolidate or Comparison report is required e From the list in the Report Pane double click the desired report e To generate a report using this method the system will Prompt the user to set some preferences for the reports They will include o Title and Description to display on the reports o KPI Settings as as IRR NPV and Development Margin
78. n successfully found click on OK Select Users or Groups Select this object type Users or Groups From this location Entire Directory Enter the object names to select examples 4 The program will then return to the Permissions for Project screen where the User Group who was just added to the Project Permissions group will appear in the Group or User Names list lt is at this point where there specific permissions can be set Permissions for Project The One and Only Towers Group or user names AEM Development EM EM Development Permissions for EM Development Full Control Admin MOM Read m E Write 2015 Estate Master Pty Ltd Estate Master CC 10 4 Permissions Below are the Permissions Levels required for the various actions at the Project level Please note the following e Any User can create a Project by being the first user to export a DF DM IA HF Cash Flow to a particular Project during the Export Wizard it will prompt the user to create a new Project if required Once they do so the are automatically added to the Permission Group with Full Control permissions e Users have Full Control over any Cash Flow they own these are Cash Flows that were exported by them into the Enterprise Database fonon cca Rea wrie Edit Add Remove Users Groups in Project Permissions Export a Cash Flow to Existing Project Import any Cash Flow from Project into DF DM IA HF
79. n the Portfolio Settings The selected currency will be displayed next to the name of the Portfolio This does not apply to Projects that have Cash Flows with different currencies Mode consolidated All Project in AUDY The currency used to display the Dashboard Note About Dashboards There are instances where the Dashboard will not display any data to the user These are 1 If you don t have permissions for that selected Portfolio Project or Cash Flow 2 If a Project is selected and the Cash Flows in that Project have different currencies exchange rates only apply to Portfolios Settings for Dashboard KPI s Some of the KPI s in the dashboard mainly the IRR NPV and Development Margin are calculated either using the e The application s KPI Defaults If a Project is selected then the KPI Defaults are used for some calculations on the dashboard If this is the case the KPI will be marked with V To edit it the settings go to Tools gt Options and select KPI Defaults The specific KPI Settings for a Portfolio If a Portfolio is selected its specific setting for the KPI is used for this calculation on the dash board These are set when creating a Portfolio and to edit them right click a Portfolio from the Portfolio Pane on the Home screen and select Edit Portfolio Settings The specific KPI Settings of a Cash Flow When viewing an Individual dashboard the relevant KPI s are calculated using the
80. ns is ENABLED and the user running Estate Master CC IS NOT part of the Administrator Group unlock lock buttons will not be displayed and therefore they cannot lock or unlock any setting A Preference Option may be enabled disabled depending on their Current status e f Enable Security Permissions is DISABLED unlock lock buttons will not be displayed and all Preference Options will be ENABLED Corporate Discount Rates General delat Development Discount Rate DF DM Cash Flows Portfolio Defaults Investment Discount Rate LA Cash Flows KPI Defaults IRR Assumption Financing On cash flow that includes all financing costs interest and corp tax Currency and Area Development Margin Assumption Report Preferences pe on total revenue net of Tax Rep issions di Y A e al A A N i i at e A a aa a gue Portfolio Defaults Once any changes are made to the lock status of any setting in the Portfolio Defaults via the Options form 1 For New Portfolios These same Lock settings are replicated to any new Portfolios that are created moving forwar a Only users who are part of the Administrator Group will be able to unlock lock them on an individual Portfolio basis b For any Portfolio Setting that was not available in Portfolio Defaults i e Title amp Description Corporate Equity Report Labels and Portfolio Logo these will remain editable at all times 2 For Existing Portfolios Th
81. nt Value 2 040 696 Peak Debt Exposure Jan 2008 Site Area 553 961 SqM v Development Margin 34 37 Equity IRR N A Debt Breakeven May 2014 Current user Alisbona PDA54 EM Connected to EstateMasterData on EMDEV2K8 SQL2008 Version 6 93 Menus and Toolbars There are 3 main menus and toolbars in the Estate Master CC program 1 The Application Menu This is loaded by clicking on the round Estate Master CC icon at the top left of the program 2 The Ribbon Menu This is the main menu that appears at the top of the program 3 The Quick Access Toolbar This is a small toolbar that contains some of the more commonly used functions List of Portfolios This pane lists all Portfolios in the Enterprise Database e By clicking on it will expand the Portfolio to show the Projects that exist in it e When a Portfolio is selected it will show the Cash Flows that exist in the Portfolio in the centre of the screen List of Cash Flows and display the outputs for the Portfolio in the Dashboard e When right clicking a Portfolio a context menu will appear with certain functions 2015 Estate Master Pty Ltd a Estate Master CC List Filters There are 2 filters for the Portfolio List and the Project List They allow the user the either show e All Portfolios Projects that exist in the database irrespective of who created them or e My Portfolios Projects being those created by the current user of Estate Master C
82. o Period The start and end dates for the selected Project or Portfolio or essentially the earliest start date and the latest end date for all Cash Flows Portfolio NPV All Cash Flows are discounted to present value at the nominated discount rate depending w hether they are a Development or Investment Cash Flow to calculate a consolidated NPV as at 2015 Estate Master Pty Ltd Dashboard Dashboard Item the Portfolio start date 2015 Estate Master Pty Ltd Estate Master CC Development Cash Flows Dashboard Item No of Cash Flows The number of Development Cash Flow s Estate Master DF and DM that are in the selected Project or Portfolio Last Updated The date of the most recently updated Development Cash Flow in the selected Project or Portfolio Site Area The amalgamated site area of all the Development Cash Flow s in the selected Project or Portfolio f Cash Flows have different measurement units for their site area then the program w ill convert it to a common unit and can be changed to another unit as per the drop dow n box available If one of the Development Cash Flow s in the selected Project or Portfolio does not have a Site Area entered for it then WA will be displayed w ith a mouse over message One of the Cash Flows does not have a Site Area entered Gross Profit Total Revenue less Total Costs for the Project Portfolio after Tax paid and reclaimed but before any profit share split has been made to either th
83. odels and apply a centrally controlled financing structure within Estate Master CC to fund the consolidated cash flow Consolidated Financing Consolidated Financing Apply Portfolio Level Financing e Interest Rates This is the default interest rates to be used by Loan 1 and the Senior Lender if Portfolio Level financing is applied The Interest Rates also have a method of conversion from the annual interest rate to the monthly interest rate The difference is given in the following formulae Nominal Conversion i 12 Effective Conversion i 1 13 1 Where i is the annual interest rate Interest Rates Loan 1 Rate 0 00 Senior Loan Rate 0 00 Interest Rates expressed as per annum Effective 4 1 3 Currency and Area e Portfolio Currency The default base currency to be used for all reporting in the Portfolios If Cash Flows in a Portfolio are based on different currencies ie a DM Cash Flow in Australian Dollars and a DF Cash Flow in Euros then this setting will convert all Cash Flows to a common currency for reporting purposes Portfolio Currency Australian Dollar T e Portfolio Area Measurement The default unit of area measurement to be used for all reporting in the Portfolios If Cash Flows in a Portfolio are based on different units of measurement ie a DM Cash Flow in Sqm and a DF Cash Flow in SqFt then this setting will convert all Cash Flows to a common area for reporting purposes 2015 Estate Mast
84. of Cash Flows and generate a selection of consolidation or comparison reports such as periodic Cash Flows summary reports Gantt charts etc ENTERPRISE DATABASE mm eee AA AA ee S ESTATE MASTER i The Program can be used to ne e Archive all input and cash flow data from Estate Master DF DM HF and lA Mult a on a e Generate comparison summary and Currency Aik ln cash flow reports for unlimited Reporting Management Team iiaii number of development options e Generate consolidated summary ae Management and cash flow reports for unlimited Reporting number of development stages CORPORATE digais CONSOLIDATION PePoring N Dashboards Portfolio Management Consolidated Financing 2015 Estate Master Pty Ltd 1 2 Estate Master CC Data Hierarchy The Estate Master CC Database structure works on a hierarchy of Cash Flows that allows the user to group their Estate Master DF Development Feasibility DM Development Management HF Hotel Feasibility and and Estate Master IA Investment Appraisal Cash Flows The hierarchy consists of 1 Cash Flows These are the individual Cash Flows created in the DF prospective development projects DM active development projects HF prospective hotel developments and appraisals and and IA investment projects software 2 Projects These are the groups that contain Cash Flows for a particular development p
85. olio ie IA If the selected Project Portfolio contains development cash flows ie DF or DM then they will be ignored in these reports Switching between Panes Comparison To toggle between the two types of reports click on the relevant button at the bottom of the pane Print Reports Minimising and Maximising the Pane Consolidated The Report Pane can also be minimised to provide the user with a larger 55 Summary Report view of the Portfolio list To do this click on lt lt at the top right of the pane Once it is minimised click on gt gt to maximise the pane 2015 Estate Master Pty Ltd Generating Reports To generate any of the selected reports 1 While on the Main Interface select the relevant Portfolio you wish to generate a report for 2 Select the type of report you wish to generate and double click e Comparison or Consolidated and e All Development or Investment 3 The report for the selected Portfolio will then load in the Report Viewer 7 2 The Report Viewer When generating reports they load into a Report Viewer Report Viewer Exes Cenaida l rm Cennen La on Hi non diana propa Papel pirim col Des dee Calls mr ap ZA METERME AP LLL 144 lia bhi Ea dll dl a Lil iHi j Cia Ala FE LL kh Li Feul irt Lidd Lake gy Lii KETRERTEL ROOM TFET RECERIoO TOE FELALL PR EA 1 p Ladd Ti pub A IMA AA ES ATA Lapa IPad x dh dl Co LOMA dral Carl gara Ercilla lor J Fiki UES
86. orporate Consolidation CC is your key management reporting tool to deliver a corporate level wew of your entire property portfolio or multi staged project with consolidated cash flow forecasts and corporate 7 funding needs Get more information about Hotel Corporate Consolidation through the following Feasibility links i Froduct Not Installed You can install a trial of EstateMaster Corporate Consolidation by clicking an the bution below gt pw 1 Download amp Try EC Video Domo Apecficatiar Contact DE Li te am Sheet Support investment Appraisal 2 3 Connecting CC to Enterprise Database 1 The first time CC is run it may need to be configured to connect to the Estate Master Enterprise Database This is the database that contains all the Cash Flow data that users of Estate Master DF DM HF and IA export to Click Configure to run the Enterprise Database Management Tool 2 If the Enterprise Database Management Tool cannot be found try and locate it on your Windows Start Menu under All Programs or alternatively reinstall it 3 If the Enterprise Database Management Tool is found the following screen will appear where you will be prompted to configure the database ESTATEMMASTER PROPERTY SOFTWARE STEP 1 INSTALL SQL SERVER Enterprise Database Management Utility Install SQL The Enterprise Database needs to be setup on SQL Server Download and install Microsoft s free version SQL Server Express if the
87. ort Officer before attempting any connection Powered by TeamViewer Check for Updates Checks for the latest version of the software online requires internet connection The user can set the program to automatically check fro software updates online on start up via the Options in the Tools menu Database Statistics View information about the database currently connected to such as file size number of cash flows etc About Estate Master Allows the user to view the licence details and re register an existing licence CC About Estate Master CC PT E E CORPORATE ua CC Estate Master CC Estate Master E CONSOLIDATION Version 6 93 0 91 32 bit Licence Details System Details Licence Name Operating System Name Windows 7 64 Bit Operating System Version 6 1 7601 65536 Service Pack 1 Build 7601 Organisation Estate Master Administration METEORO 4 0 30319 18444 Internet Explorer 11 0 9600 18015 Hcn Type Cillent Server oating CAS License Processor Name Intel R CoreTM i7 CPU 870 293 Serial Number RAM 12247 11 MB View End User Licence Agreement Free Harddrive Space 1159 91 GB Deactivate Licence System Info Dependencies Dependency Name Version No Dependency Path 3 DeployLX Licensing v5 5 0 4000 0 D TFS EM Software Source Main Estate Master Presentation CC bin x86 Debug Estate Master Common v3 0 3 2 5 19 D TFS EM Software Source Main Estate Master Presentation CC bin x86 Debug EstateMast
88. paid at the end of the project based on a percentage as defined in the Financing Settings e Equity Cash Flow This shows the inflows and outflows of equity in the Portfolio Loan 1 e Manual Drawdowns or Repayments In all time periods the user can enter a manual drawdown negative number or repayment positive number e Drawdown This shows the amount being drawn down for Loan 1 taking into consideration any manual drawdowns e Interest Rate The initial interest rate as defined in the Financing Settings is shown in the first time period In all other time periods the user can enter vary the interest rate manually e Interest Charged The amount of capitalised interest calculated each period e Line Fees The monthly fee paid in arrears during the period of the loan lt is based on the annual fee as defined in the Financing Settings e Repayment This shows the amount being repaid to Loan 1 taking into consideration any manual repayments e Loan Balance The remaining balance on the loan including any capitalised interest and fees 2015 Estate Master Pty Ltd Working with Portfolios 35 Senior Loan e Drawdown This shows the amount being drawn down for the Senior Loan It cannot be manually adjusted as it automatically draws down the balance of funds once both Equity and Loan 1 have been exhausted e Interest Rate The initial interest rate as defined in the Financing Settings is shown in the first time period
89. ported as they were not stored in the latest version of the application For file Equinox 5q Commercial emdf There are no Options Stages to import One or more pM vi le ode ooo E a alle eo abla ofa sole kbh TANF 2 Opti e noi proT Important Note A common error message that may appear is One or more Options Stages could not be imported as they were not stored in the latest version of the application This relates to DF and HF files only as they have the Options Stages feature and can only be rectified by opening the actual file within the latest version of the DF and HF application recall and store the Options Stages again and save the file before it can be imported into the database again This is to ensure that the Cash Flow data for those files are based on the latest calculation engine in HF DF Assigning the Cash Flow to a Different Project When importing an Estate Master Cash Flow DF 5 x DM 5 x HF 2 x and IA 3 x files from within Estate Master CC the user will be given the option to assign that Cash Flow to a different Project that is already set on the DF DM IA HF model s Intro sheet If the user has elected to change the Project it belongs to Estate Master CC will attempt to save the new Project details back to the DF DM IA HF data file If that data file is read only and Estate Master CC cannot update it the user will get a message and will have to manually update the data file
90. r ftar 20d5 Current user flebenaPOAS EM Connected to Estatea Data on PROSE Version 654 Dashboard Modes There are 9 different Dashboard Mode combinations available through the two drop down list at the top left of the dashboard Mode consolidated a All Comparison Lad Individual List 1 List 1 1 Consolidate Consolidates the Cash Flows for the selected Project Portfolio 2 Comparison Compares the Best and Worst Options in the selected Project Portfolio based on a defined KPI 3 Individual Provides a snapshot for a single specific Cash Flow only List 2 is disabled when this mode is selected 2015 Estate Master Pty Ltd Dashboard List 2 1 All Generates a dashboard to report all Estate Master Cash Flow types in the selected Project Portfolio ie DF DM or IA 2 Development Generates a dashboard to report development cash flows only in the selected Project Portfolio ie DF or DM If the selected Project Portfolio contains investment cash flows ie IA then they will be ignored in this dashboard 3 Investment Generates a dashboard to report investment cash flows only in the selected Project Portfolio ie IA If the selected Project Portfolio contains development cash flows ie DF or DM then they will be ignored in this dashboard Currency Conversion If vewing a dashboard for a Portfolio all Cash Flows in that Portfolio will be converted to the currency set i
91. rating the report 2 Financial Year to Date The start of the Financial Y ear up until the Current Month Whether FY to Date includes or excludes the Current Month can be set via the Current Month Report Preferences 3 Financial Year Total From the start until the end of the current Financial Y ear Similar to the DM Profit 4 Margin Life to Date report but reporting Revenues Costs Profit and Margin for the Portfolio Similar to the DM Profit 8 Margin Year to Date report but reporting Revenues Costs Profit and Margin for the Portfolio Investment Cash Flows Report ETT DCF Financial Year DCF Capitalisation Sum mary Executive Summary 2015 Estate Master Pty Ltd A monthly consolidated Discounted Cash Flow table including the IRR and NPV A yearly consolidated Discounted Cash Flow table including the IRR and NPV based on the Financial Year End as set in the Report Preferences A consolidated Capitalisation Summary report w here the user is prompted to select one of four valuation methods that w ere calculated in the Estate Master lA model A consolidated Executive Summary report detailing the key outputs of an investment cash lfow including e Tenant Analysis Charts indicating top 5 tenants by NLA and Gross Passing Income e Weighted Lease Duration Vacant Area analysis and Gross Income and Outgoings e Outputs related to the Capitalisation approach to valuation Capitalised Value Yields etc
92. re are no existing SQL Servers on the local machine or network to use STEP 2 CREATE THE DATABASE AND CONNECT TOIT Create a new Enterprise Database on SQL Server or connect to an existing one on the local machine or network STEP 3 MANAGE THE DATABASE Check to see if any updates have been installed and need to be applied to the Enterprise Database Backup the Enterprise Database for archiving purposes or to share it with other users not connected to it Restore an Enterprise Database to an existing SQL Server from a backup file Please refer to the manual for the Enterprise Database Management Tool for more information 2015 Estate Master Pty Ltd Operating the Program 13 3 Operating the Program 3 1 Home Screen The Home screen is the first screen that appears when the application is loaded Qt NEO e Access Tooner Home Estate Master CC ax Main Portfolio a s NIE Sy 5 EHE e lt Y Fal A Hi Mm Oye yy ax E Si New Import Home All Cash Refresh Exchange Options Settings Financing Clone Delete Add Remove Use Use Print Permissions Portfolio EM File Flows Rates Cash Flows Fixed Latest Reports File View Tools Portfolios All Portfolios En Crows nest All i gt gt i Net Cash Flow Before Interest Ex Division Commerical En Division Land Development En Doha En Investments En Marinia En Melbourne En Project Greenwood Park Comp
93. rea then the program w ill convert it to a common unit and can be changed to another unit as per the drop dow n box available If one of the Development Cash Flow s in the selected Project or Portfolio does not have a Site Area entered for it then N A will be displayed w ith a mouse over message One of the Cash Flows does not have a Site Area entered Net Lettable Area The amalgamated net lettable area of all the Investment Cash Flow s Estate Master lA in the selected Project or Portfolio f Cash Flows have different measurement units for their site area then the program w ill convert it to a common unit and can be changed to another unit as per the drop dow n box available If one of the Investment Cash Flow s in the selected Project or Portfolio does not have a Net Lettable Area entered for it then WA will be displayed w ith a mouse over message One of the Cash Flows does not have a Net Lettable Area entered Development Period The start and end dates for the development period of the selected Project or Portfolio or essentially the earliest start date and the latest end date for all the Development Cash Flow s Estate Master DF and DM Discount Rate The Development Discount Rate or Target IRR is simplistically the desired returns on funds invested For discounted cash flow analysis the discount rate is the rate at w hich future Development Cash Flows are discounted to present value t is based on the Portfolio Preference IRR T
94. roject The Cash Flows created in DF DM HF and IA are exported to the database after they have been assigned to a Project during the export process refer to the DF DM IA HF Operations Manual for more information about the export process A Project can contain a mixture of DF DM HF and IA Cash Flows and there is essentially no limit to the number of Cash Flows it can contain 3 Portfolios These are the groups that contains numerous Cash Flows for reporting purposes either on a consolidated or comparative basis A Cash Flow can be in more than one Portfolio Portfolios can only be created and managed from within the Estate Master CC program Project A Residential Domestic Portfolio International Portfolio 2015 Estate Master Pty Ltd Introduction to Estate Master CC Example of Using Projects and Portfolios A User has 3 active multi stage development projects each containing 4 stages underway and 1 prospective project they are assessing with 4 different options to consider For the active multi stage developments the user models them in Estate Master DM with 4 separate DM files for each stage of the developments For the prospective project the user models itin one Estate Master DF file using the Options Stage function to store the 4 options they are considering Q For each active project the 4 DM Cash Flows for each stage are exported to the CC Database to a separate Project For the prospective proj
95. roject data reports and dashboard and exporting importing Cash Flows to from it 4 Cash Flow Permissions Importing and deleting Cash Flows owned by a user Enabling Security Functionality 1 To enable this functionality the user logged on must be part of the Domain Administrators group on that network If they are not then this functionality cannot be enabled 2 On the Menu Bar click on Tools gt Options gt Permissions If the software detects that the user is not part of a Windows Domain then the following message will appear Security Disabled i Security has been disabled because you are currently not part of a Windows Domain Estate Master Security will only work on a Windows Domain Contact your 1 7 department for more information C x lf the user is part of a Windows Domain and they are a Domain Administrator then they can tick the Enable Security Permissions checkbox 2015 Estate Master Pty Ltd Estate Master CC Options Application Security Y Enable Security Permissions General Portfolio Defaults Administrator Group Group or user names Report Preferences Permissions Permissions for Administrators 3 The first time the functionality is enabled it will prompt the user whether or not to apply default permissions to Portfolios and Projects that were previously created e If the user selects Yes recommended then whichever user originally created
96. s and apply a a centrally defined financing After Interest After Interest After Interest structure within Estate Master CC to fund the Exported lo Estals Master Enterprise Database consolidated cash flow To enable Consolidated Financing for a Portfolio select the Apply Portfolio Level Financing option either when initially creating the Portfolio or editing Consolidated Net Cash Flow Before Interest the Portfolio settings after it has been created Use Financing from Individual Cash Flows Use Financing from Individual Cash Flows Nee E A angal Cae seme Please Note When this option is enabled all financing calculations and results funding limits interest and fees charged on loans profit share paid to lenders etc in the indivdual Estate Master DF DM or IA cash flows are completely ignored and a new financing scenario is applied over the consolidated Net 2015 Estate Master Pty Ltd 32 Estate Master CC 4 3 1 Cash Flow Before Interest when viewing Consolidation Reports and Dashboards lt has no impact on Comparison Reports and Dashboards where independent financing is maintained Financing Settings Sources of Funding When Consolidated Financing is enabled you will be able to apply the following sources of funding to the Portfolio Report Sort Order Sort by Cash Flow Type bi Then by Cash Flow Title gt Equity e An upfront Equity injection can be defined in the Funding Limit with the
97. s included in the portfolio 2015 Estate Master Pty Ltd Estate Master CC 8 Dashboard An Estate Master CC Dashboard is displayed on the bottom of the Home screen lts aim is to provide the user with a quick snapshot of either a Portfolio Project or Cash Flow without needing to open data files or generate reports SA Tees Hone Estate Master OC i Main Project Exchange we 3 A R OT BELO Mew Cash Refresh Pornfolio ERA File gt Flere Rata File ew Tools ctw Propet Portfolios 41 Porttotos gt Project Cash Flows Consolidated Cash Ho Tile Description UF DM Budget Version Project Type Project Sto 2 All Met Cash Aca Before Interest Met Cash Mow Ofer ime Sources bl Application of Funds a Developer Timmar Report tummar Report By CE Fira DP ys DM Seminary Currenqy Comparison Surman Cai Flora Financial Year Cash Aci Projects AlProjeds P amp L Statement Franca fear FL itsbemer Mumber Name 7 balance Sheet Options import Home A Frarcial rear Balance aei Ma Pe Cash Acw l 4 1 Dashboard Modes Dashboard Results Comparison Print Reports edad Ma Project in AUD Pacific Palms Dinccund Rata 200 i Project Stan Gate Jun 2017 Mio of Cash Picas ras Prat Project FE 605 Y Cash Flow reses ftar 20d5 Last Upoated Met Prot Het Present ale 2340000 0 Peak Debt Esposure Sap 3014 Site Ares Development Magin Equity IRR MA Debt Meske
98. senting 2 stages in a project Net Cash Flow Nat Cash Flow Nat Cash Flow After Interest l After Interest After Interest e The Equity and Debt contributed in the Stage 1 model will only be used to fund the costs that exist in that model i e stage only Exported to Estate Master Enterprise Database e lfthere is any profit in the Stage 1 model it is not not used to fund costs for the Stage 2 model and Consolidated Met Cash Flow After Interest e lf there is any loss in the Stage 1 model it cannot be funded by the financing in the Stage 2 model When grouping these 2 cash flows in Estate Master CC in a Portfolio the consolidated reporting Reports and Dashboards will therefore be based on the 2 stages being independently This may be sufficient in some circumstances Portfolio Level Financed Cash Flows however there may be a need to view the performance of a group of cash flows where a common financing structure needs to be applied to the consolidated Net Cash Flow Before Interest Net Cash Flow Met Cash Flow Net Cash Flow The Consolidated Financing function also referred MRE Stl SIMs Sauce to as Portfolio Level Financing provides the user Equity and Debt Equity and Debt Equity and Debt with the ability to ignore all financing calculations and Funding Funding Funding results in the individual Estate Master DF DM or lA Net Cash Flow P Net Cash Flow Net Cash Flow cash flow
99. set and the option to display variations as amounts or percentages can be set via the DM Variation Report Preferences DM Cost Code Cash Flow A report for consolidating specific cost codes as selected by the user Before the report is generated the user is prompted to select froma list which Costs Codes they wish to include in the report w hether those costs should include exclude tax and w hat components of the Stock Summary should also be included This list is populated based on the actual Codes and Descriptions entered for each cost revenue line item in the DM Cash Flows that make up the active portfolio being printed If the same Code is used for different descriptions then the descriptions w ill be joined comma delimitated The user also has the option to define a custom start and end date range for the report DM Cost Code Cash Flow Description Land Cost Purchase Stamp Duty Vacant Possession Acquisition Fees GST Margin Scheme Diligence Valuation All Professional Consultant Fees All Professional Consultant Fees Certified to Date Certified to Date Forecast Future Costs Forecast Future Costs Masterplan DA Building Architect E Exclude Tax Select Stock Summary Y Quantity Sold 4 Quantity Handed Over Y Area Sold Select Date Range Start Mar 2011 Ele End Mar 2018 ax The following items are always reported inclusive of Tax Project Contingency Construction Contingency Capit
100. sions Below are the Permissions Levels required for the various actions at the Portfolio level Please note the following e Any User can create a Portfolio and once they do so the are automatically added to the Permission Group with Full Control permissions Permissions Required Full Only if the user has Read access to the Project that the Cash Flow belongs to 2015 Estate Master Pty Ltd 94 Estate Master CC 10 3 Project Permissions The Project Permissions level offers control over reporting Project data reports and dashboard and exporting importing Cash Flows to from it Setting Project Permissions 1 In the Project Pane on the Home screen right click the desired Project and select Permissions aon gt Merge Projects i XxX Delete Project MUB es Permissions N 2 A Permissions for Project screen will then pop up Click on Add to add a new user to the Project Permissions Group Permissions for Project The One and Only Towers tm Group or user names Permissions for Administrators 2015 Estate Master Pty Ltd Security Permissions 95 3 A Select Users or Groups screen will then appear Make sure that Object Types has been selected as Users and Groups and Locations has been set to Entire Directory before entering a User Group name in the field provided To ensure that the name exists in the Windows Domain click Check Names Once the User Group has bee
101. step 1 to the Project selected in step 2 removing the original Project from the database 2015 Estate Master Pty Ltd Working with Cash Flows 47 6 Working with Cash Flows The Cash Flow is the lowest hierarchical group in the Estate Master CC program and essentially represent a DM IA file or an Option Stage from a DF HF file that has been exported to the Enterprise Database 6 1 Importing Cash Flows There are several ways that a DF DM IA HF Cash Flow be imported into the Enterprise Database and appear in Estate Master CC The main method is by exporting the Cash Flow from within the DF DM IA HF application itself however there are 2 additional options available from within Estate Master CC without having to load the other applications 1 Import a single DF DM IA HF Cash Flow 2 Do a bulk import of DF DM IA HF Cash Flows that exist in a file directory These function are available in the Ribbon menu New Portfolio Er Single File Import a single EM File ls Folder Import E Import a folder of EM Files Single File Import 1 In the Ribbon menu click File gt Import EM File gt Single File 2 A file browse dialog will appear Select the DF DM IA HF file you wish to import and press Open 3 The database import wizard will appear Follow the prompts to import the file Folder Import This function is useful where multiple files need to be imported on a frequent basis e g monthly providing a
102. t and show only DF and DM Cash Flows of a Commercial development type in the suburb of Docklands by developer ABC Holdings Pty Ltd added to the database by user Administrator e Once the criteria has been selected press Apply Advanced Filter General Project or Property Software J DM Y DF Y IA HF Project Number Type Commercial Project Name a Status Property Name Start Date From 1 09 2003 To 1 02 2023 Account Code a Developer ABC Holdings v Regional City Suburb y Land Owner State Country Property Owner Zip Postcode Prepared By Country Prepared For Y Currency Database Imported Date From 4 14 04 2008 To 22 09 2015 Imported By Administrator PDA12 PDA12 y Cancel Apply e The Cash Flow list will then be applied overriding any filter set by the basic drop down filter To clear the filter and show all the Cash Flows press the Clear Filter button Delete Cash Flows One ata time To delete a Cash Flow from the Enterprise Database permanently e Right click the Cash Flow and a menu will appear and select Delete Cash Flow at Delete Cash Flow e lfthere is more than one version of the selected Cash Flow the program will prompt the user to delete only the selected version or all versions all historical data for that Cash Flow If there is only one version of the selected Cash Flow then it will proceed to the next step Delete Cash Flow
103. t 12 months Yearly Then next 17 months Yearly Thereafter Yearly The Variable Period feature can also be applied to other cashflow style reports not just the Variable Period Cash Flow report itself To select the reports to implement this feature tick the relevant checkbox in the Use for Other Reports section If reports are selected each time they are printed the user will be prompted with the variable period settings for the report Use for Other Reports Sources amp amp Application of Funding Report Inventory Report 2015 Estate Master Pty Ltd 7 3 8 Report Sort Order For reports that list the indivdual Cash Flows i e Cash Flows Gantt etc the user can select how the Cash Flows are to be sorted when reported The user can sort by 1 Project Number Account Code Project Name Cash Flow Title Cash Flow Type i e DF DM etc Project Type i e Residential Commercial etc Status i e Under Review Construction etc 0 N O o Bb WD N Start Date Report Sort Order Sort by Cash Flow Type ps Then by Cash Flow Title hi 7 3 9 Company Logo The user can insert a Company Logo to display on the Title Page for all Portfolios This is in addition to the Portfolio logo that can also be displayed on the Title Page e Only Bitmap PNG JPEG or GIF files can be inserted e There are no file image size restrictions e The program will automatically downscale the image if it is too large to
104. t Name to one that already exists in the database but keep the same Project Number you will be allowed e f you attempt to change both the Project Number and Name to the same combination that already exists in the database you will be prompted to confirm this as all the Cash Flows that exist in the selected Project will be moved to the other Project 5 2 Merging Projects 1 In the Projects pane right click the Project you want to merge to another and click Merge Projects This button will only be enabled if the user has sufficient permissions Write or Full on the Project being merged Projects All Projects Ela Tr ame HOD Musheireb Heaj BEd Edit Project Name 21234 MCF Test y Merge Projects N ML Atem p Newcastle Planni X Delete Project Papo Pacific Palms IPC 14 06 PMH Developme Permissions 2 A form will pop up showing all Projects that the user has sufficient permissions to merge to Select a Project and click Merge Merge Projects Project Number Project Name CWB 73003 Becket St Glenroy P1000 Bella Vista Tower PLOOO 1A Bella Vista Tower 14 CWE 42485 Bluewatte Rasmussen CWER 32539 A Breezes Muirhead Built Porm CWB 32539 Breezes Muirhead Development Merge Cancel 3 A confirmation message will appear Click Yes to continue the merge and the application will then effectively transfer all Cash Flows from the Project selected in
105. tages of the Estate Master CC program is the ability to display the valuable cash flow information in professional reports These reports can be generated instantly via the Report Pane or sent to a printer using the Print Menu The Report Pane The Report Pane is located on the right side of the application window It contains a list of all the different reports that can be generated in the Estate Master CC program They are split into two types 1 Consolidated Reports Consolidate multiple Cash Flows to determine their aggregate performance such as individual stages of a project projects that form a Portfolio or projects that form part of a business division eg Residential Divsion vs Commercial Division 2 Comparison Reports Compare multiple Cash Flows such as different develooment scenarios or options to identify the differences between them or to determine the most viable option The reports are also grouped into three different categories 1 All These are reports that are generated for all Estate Master Cash Flow types in the selected Project Portfolio ie DF DM or IA 2 Development These are reports that are generated for Development cash flows only in the selected Project Portfolio ie DF or DM If the selected Project Portfolio contains investment cash flows ie IA then they will be ignored in these reports 3 Investment These are reports that are generated for Investment cash flows only in the selected Project Portf
106. ted fromthe Consolidated Financing results o If an Estate Master lA Investment Cash Flow is part of the Portfolio this Development DF and DM Cash Flow chart will be shown exclusive of Fees and Interest Charges Forecast Summary Development DF Interest Received will exclude any Interest Received on Surplus Cash calculated amp DM in the individual Estate Master Cash Flows Interest Charged on Equity as calculated in the individual Estate Master Cash Flow s is excluded e Fees and Interest Charges for Loan 1 and Senior Loan are calculated from the Consolidated Financing results All Fees and Interest Charges for Loans 2 and 3 as calculated in the individual Estate Master Cash Flows are excluded e All historical 2 Fees and Interest Charges calculated from Consolidated Financing results will all be classified as a Cost to Date lf an Estate Master IA Investment Cash Flow is part of the Portfolio this Development DF and DM Cash Flow report will displayed be on a Pre Funding basis and no Fees and Interest Charges will be shown at all 2015 Estate Master Pty Ltd 40 Estate Master CC Applies To DM Variation DM e The results for the Current Budget only are based on Consolidated Financing o Interest Received will exclude any Interest Received on Surplus Cash calculated in the individual Estate Master Cash Flows o Interest Charged on Equity as calculate
107. ted Cash Flow Cash Flows that a a have an identical Cash Flow Title stored in the Enterprise Database Use Fixed Cash Flow This option allows the user to select a historical version of the selected Cash Flow to be used in that Portfolio and for reporting purposes Therefore any subsequent updates to that Cash Flow exported from DF DM will be ignored for that Portfolio and only the selected version of that Cash Flow will be used Remove Cash Flow Remove the selected Cash Flow from the from Portfolio Portfolio This does not delete any Cash Flows from the database it just removes that 2015 Estate Master Pty Ltd 20 Estate Master CC Cash Flow as being part of that Portfolio 2015 Estate Master Pty Ltd 22 Estate Master CC 4 4 1 Working with Portfolios The Portfolio is the highest hierarchical group in the Estate Master CC program They are user definable groups that contain numerous Cash Flows for reporting purposes either on a consolidated or comparative basis A Cash Flow can be in more than one Portfolio Portfolios can only be created and managed from within the Estate Master CC program Portfolio Defaults The Portfolio Defaults are the default settings that will be initially loaded when General creating a new Portfolio Portfolio Defaults a During the Create New Portfolio wizard the user can then change these settings to KPI Defaults N suit the individual Portfolio Financin
108. ted from the Consolidated Financing results o Profit Share is calculated from the Consolidated Financing settings o Performance Indicators are based on financing calculated from the Consolidated Financing e f an Estate Master IA Investment Cash Flow is part of the Portfolio this Development DF and DM Cash Flow report will displayed be on a Pre Funding basis o No Fees and Interest Charges will be shown at all o Only the Profit and Development Margin performance indicators pre funding w ill be displayed Development DF e Interest Received on Surplus Cash as calculated in the individual Estate Master Dos Cash Flow s is excluded e Interest Charged on Equity as calculated in the individual Estate Master Cash Flow s is excluded e Outputs Draw dow ns Repayments Fees and Interest Charges for Equity Loan 1 and Senior Loan are calculated from the Consolidated Financing results e Outputs for Loans 2 and 3 as calculated in the individual Estate Master Cash Flow s are excluded e Profit Share is calculated from the Consolidated Financing settings All other Profit Share to Land Owners and Lenders as calculated in the individual Estate Master Cash Flows are excluded e f an Estate Master IA Investment Cash Flow is part of the Portfolio this Development DF and DM Cash Flow report will displayed be on a Pre Funding basis o No Fees and Interest Charges will be shown at all 20
109. ter Scenario The report is based on data that is el specific to a certain Estate Master Cash Flow type beeen not contain any DM cash flows and therefore there is e g DF DM etc and the user iS trying to run the ji report on Cash Flows that are of another type Solution The user must select a Portfolio or group of Cash Flows that contain at least on type of the specific cash flow in order for the report to run 2015 Estate Master Pty Ltd EstateMasterCC 9 SS Scenario Similar to the above scenario the report gt Cannot generate Investment Estate Master IA reports Only Estate Master Development Feasibility DF and Development Management DM Cash Flows exist in the select Portfolio 7 7 Printing Menu is based on data that is specific to a certain Estate Master Cash Flow type e g DF DM etc and the user is trying to run the report on Cash Flows that are of another type Solution The user must select a Portfolio or group of Cash Flows that contain at least on type of the specific cash flow in order for the report to run The Printing Menu allows the user to print reports for either Consolidated or Comparison Cash Flows at a click of a button either straight to a PDF file or to a Printer It is loaded by clicking on the Print Reports button on the Report Pane Print Reports Select Reports to Print Portfolio Consolidated Reports All Net Cash Flow Before Interest Net Cash Flow A
110. the Portfolio or Project will be given Full Control permissions for those objects e lf the user selects No then the permissions for each Portfolio and Project will need to be set manually Set Permissions 1 This is the first time security has been enabled Do you wish to set permissions on existing Portfolios and Projects Whoever created the Portfolio or Project will have Full control 4 Once enabled the user can then commence to set Permissions at the various levels 2015 Estate Master Pty Ltd Security Permissions 89 10 1 Application Administration The Application Administration Permission level offers overall control of the application and the ability to apply permissions at any other subordinate level There are only 2 types of users who can edit the Application Administration settings Add Remove Edit Users or Groups 1 Domain Administrators 2 Other Users Groups in the Application Administration group Setting Application Admin Permissions 1 If the user is not already in the Options screen click on Tools gt Options gt Permissions Once the screen is loaded click on Add to add a new user to the Administrator Group Administrator Group Group or user names Add Remove Permissions for Administrators 2 A Select Users or Groups screen will then appear Make sure that Object Types has been selected as Users and Groups and Locations has been set to Entire Director
111. thout needing to generate a report There are several types of Dashboards which are toggled using the two Dashboard Mode lists Connection Info This displays the details of the current user and what Enterprise Database they are currently connected to It will be shown as Current user username machine name network domain name Connected to EstateMasterData on server where database is located 2015 Estate Master Pty Ltd 16 Estate Master CC 3 2 3 2 1 Menus and Toolbars Application Menu The Application Menu is located in the top left corner of the application window indicated by the Estate Master CC icon and provides the user with access to the various Help functions available in the program ES Main Project Main Menu Estat Exit om ola Estate Master CC Help Opens the Estate Master Help program Remote Help Desk Allow an Estate Master support consultant to connect to your PC Check For Updates Check for the latest version of the software online Database Statistics View information about the database currently connected to such as file size number of Cash Flow etc About Estate Master CC View the license details and re register an existing license Estate Master CC Help Open the Estate Master Help utility Remote Help Desk Allow an Estate Master Support Officer to remotely connect to your PC Server for troubleshooting and assistance You must contact an Estate Master Supp
112. to specific page of the report Refresh the data in the report This is useful if data changes have occurred after the report has been generated and is still displayed in the report viewer Print the report Display the report in Print Layout qg Manually set the page setup of the report before printing such as Orientation Margins and Paper Size Export the report to either Excel or PDF file Whole Page Change the zoom of the report as it is viewed 7 3 Report Preferences ER Many of the reports in the Estate Master CC program offer flexibility in the Report Preferences way outputs are presented or calculated The settings for these can be ie found in the Report Preferences and they apply to all the reports in any Report Detail A OTT Currency Comparison To edit or view these settings click Tools gt Options gt Report Preferences Forecast Summary DM Reporting Current Month Financial Year End Variable Period Cash Flow Report Sort Order Company Logo 2015 Estate Master Pty Ltd 7 3 1 Report Detail Select the level of detail to show on certain Consolidation reports e Detail By Project For each cost and revenue category the individual cash flows that make up the selected Portfolio are grouped in their respective Project and the Project Name and Number is displayed on the report Revenue Gross Sales Revenue BoulV01 Bouznika Med Use JV Feasibility P1000 Greenwood Park Estate
113. user being able to make further manual injections if required e By default equity will start to be repaid once the Senior Loan and Loan 1 has been paid back however the user can make manual repayments if required Loan 1 e This source of funding is optional e A Funding Limit for Loan 1 can be defined and it is automatically progressively drawn down after the defined upfront Equity limit has been reached with the user being able to make further manual drawdowns if required e By default this loan will start to be repaid once the Senior Loan has been paid back however the user can make manual repayments if required e An annual Line Fee can be applied to this loan which is paid monthly in arrears during the period of debt e An annual Interest Rate can be applied to this loan either on a nominal or effective basis The Interest Rate can be manually varied through the life of the loan Senior Loan e This acts as an overdraft facility and will fund costs that have not been funded by Equity or Loan 1 e Being the senior loan by default it will be repaid back first unless any manual repayments have been made to Equity or Loan 1 e An annual Line Fee can be applied to this loan which is paid monthly in arrears during the period of debt e An annual Interest Rate and Line Fees can be applied to this loan either on a nominal or effective basis The Interest Rate can be manually varied through the life of the loan
114. y before entering a User Group name in the field provided To ensure that the name exists in the Windows Domain click Check Names Once the User Group has been successfully found click on OK Select Users or Groups Select this object type Users or Groups From this location Entire Directory Enter the object names to select examples EM Development P 2015 Estate Master Pty Ltd o Estate Master CC 3 The program will then return to the Options screen where the User Group who was just added to the Application Admin group will appear in the Group or User Names list It is at this point where there specific permissions can be set Group or user names AEM Development EMSEM Development Permissions Below are the Permissions Levels required for the various actions at the Application level Permissions Required ead Write O 2 2 J 2015 Estate Master Pty Ltd Security Permissions 91 10 2 Portfolio Permissions The Portfolio Permissions level offers control over reporting Portfolio data reports and dashboard editing the preferences and adding removing Cash Flows to from it Setting Portfolio Permissions 1 In the Portfolio Pane on the Home screen right click the desired Portfolio and select Permissions if E New Portfolio Edit Settings Edit Financing Clone Portfolio Delete Portfolio Add Remove Cash Flows

1 Introduction to Estate Master CC

Contents

Download Pdf Manuals

Related Search

Related Contents