New Features in DF and DM Version 4
General Inputs and Preferences
New Feature
|
 |
|
Screenshot
|
- 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'
|
 |
 |
 |
Back to Top
|
|
|
|
Cost and Revenue Inputs
New Feature
|
 |
|
Screenshot
|
- 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
|
 |
|
 |
| Back to Top |
|
|
|
Financing
New Feature
|
 |
|
Screenshot
|
- 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
|
 |
 |
 |
| Back to Top |
|
|
|
Project Reporting
New Feature
|
 |
|
Screenshot
|
- 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)
|
 |
 |
 |
| Back to Top |
|
|
|
Financial and Tax Reporting
New Feature
|
 |
|
Screenshot
|
- 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.
|
 |
 |
 |
| Back to Top |
|
|
|
Risk Analysis Reporting
New Feature
|
 |
|
Screenshot
|
- 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)
|
 |
 |
 |
| Back to Top |
|
|
|
Development Management Reporting
New Feature
|
 |
|
Screenshot
|
- 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.
|
|
 |
 |
| Back to Top |
|
|
|
Options and Stages Analysis
New Feature
|
 |
|
Screenshot
|
- 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
|
 |
|
 |
| Back to Top |
|
|
|
Other Software Functions
New Feature
|
 |
|
Screenshot
|
- 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
|
 |
 |
|
| Back to Top |
|
|
|