New Features in DF and DM Version 4 - Estate Master

Whats New in DF and DM Version 4

General Inputs and Preferences

Cost and Revenue Inputs

Financing

Project Reporting

Financial and Tax Reporting

Risk Analysis Reporting

Development Management Reporting

Options and Stages Analysis

Other Software Functions

• Up to 85 difference currencies to select from for reporting

• Adjustable financial year end month (for Financial reporting)

• An option to apply the annual escalation rates for costs and revenues either on a financial year basis or from the project start date

• Ability to lock the Code and Descriptions columns for all cost and revenue line items for secure template creation

• Ability to password lock all Preferences to ensure standardised modelling and avoid accidental changing of settings

• A printable 'Assumptions Report' to allow for easy checking of settings/preferences applied to the model

• Select an appropriate terminology for Floor Area Ratios (e.g. Floor Space Ratio, Floor Space Index, etc) and an input for the ratio to calculate a gross floor area for the development

• Additional project 'Types' added, such as 'Retirement Village', 'Affordable Housing' and 'Child Care'

• Classify Construction Costs line items with custom categories, each with their own different escalation profile

• Apply S-Curve profiles to all major development costs sections, not just Construction costs

• 2 additional customisable S-Curve profiles (5 in total)

• More cash flow span options for Development Management Fee and other costs.

• Express cost items in the 3 Miscellaneous Costs sections as either % of Construction Costs, Gross Sales or Net Sale Proceeds

• Select whether pre-sale commissions are reported as a 'Project Cost' or part of 'Project Revenue'

• A new 'Other Leasing Costs' section, where up too 100 cost items can be entered as either an amount or a % of gross rental income

• A new 'Other Income' section, where up too 100 miscellaneous revenue items (other than Sales or Rental revenue) can be entered

• Ability to enter in a Pre-Commitment Month for leases and a % of the Letting Fee to be paid at that time

• The escalated rent at the lease start date displayed for each tenant before reviews are applied.

• Separate GST/VAT inputs for Rental Income and associated costs (e.g. Outgoings, Letting Fees, Incentives) - rents may be entered inclusive of GST/VAT, while the costs may be entered in exclusive of GST/VAT

• 4 additional Sales Revenue Collection Profiles (8 in total)

• An option to enter in Sales Revenue Collection instalments based on specific months or from the date of pre-sale exchange

• The Sales Rate (units/area sold per period) displayed for each sales revenue item

• A new loan facility that can be used for either an equity or debt facility (5 sources of funding now available)

• Pay profit share either in full at the end of the project, or progressively as the project makes a profit

• Calculate Loan Ratios based on cumulative loan draw downs or the loan balance

• An option to apply a Principal and Interest facility on any equity/loan facility

• Repay equity either in full at the end of the project, repay it when funds are available, with the ability to retain cash to fund any future costs

• Allow equity to pay any outstanding debts at the project end

• Toggle between Equity and the Senior Loan what is to be used as the overdraft facility

• Ability to set a facility limit to the Senior Loan

• Loan Application and Line Fees that can be entered as either an amount or a % of the loan facility limit.

• Opening Balance inputs for Interest and Loan Fees.

• Maintain a certain leverage on the Senior Loan based on a % of unsold stock to enable quicker repayments to equity and hence improve the return on equity.

• Ability to password lock all Finance Preferences to ensure standardised modelling and avoid accidental changing of settings

• A Sales and Handover summary report, detailing what product is exchanged and settled by quantity, area and value on a periodic basis

• More detail displayed for the Joint Venture Cash Flow

• Ability to have a variable discount rate throughout the project life

• Option to report Sales Revenue on either a per area or per quantity basis

• The Average Yield reported for Capitalised Sales

• More customisable reporting options on the Summary Report with 3 columns that can report costs and revenues on a different basis

• Ability to input a desired Equity IRR to calculate the Weighted Average Cost of Capital (WACC)

• A new 'Financials' sheet with 5 individual reports:
  • Revenue Recognition and Profit Realisation
  • Profit and Loss Statement
  • Corporate Tax Statement
  • Cash Flow and IRR Statement 
  • Balance Sheet

• Ability to recognise revenue for Profit and Loss reporting based on % completed or on completion

• Identify what cost components are regarded as 'Works in Progress' or 'Expensed' for purposes of Profit and Loss reporting

• Apply a Corporate Tax Rate to project profits, and allow the tax to be funded by the loan facilities.

• A Scenario Analysis table that instantly shows how a % variation equates to in actual values

• 2 additional 'Low' and 'High' ranges for the One-Way What-If Analysis (4 in total)

• Warn the user on File Save and Export if there is a variation between the Input Assumptions and the Cash Flow

• Warn the user on File Save and Export if there the Commitments exceed the Current Budget or Forecast To Complete

• Ability to clear any of the stored budgets (Orginal, Project or Previous) at a click of a button

• Roll Forward or Back more than one time period at a time

• New Cash Flow Reports that include the Current Budget totals and Forecast Summary

• New Budget Variance Reports that report the cost and revenue line items that have varied from the Original or Previous Forecasts

• Ability to enter in a budget/forecast manually in the Summary Report and lock it down.

• Switch between a Comparison or Consolidate Report at a simple click of a button

• Ability to hide Options/Stages on the Consolidate report from printing

• Ability to clear an Options/Stages at a click of a button

• Print more than one Option/Stage at a time

• Ability to save in XLSM format (Excel 2007 required), thus allowing the user to take advantage of the benefits of Excel 2007 such as smaller file sizes and faster calculation

• Easily rename user-inserted worksheets

• Print multiple copies of a report at a time

•  Sort the order that reports are printed