Key Features of Estate Master DF

Data Inputs

• User friendly spreadsheet input environment allowing you to create custom formulas, links to other worksheets or run Excel functions.
• Variable cash flow rest periods - months, quarters, half-years and years.
• Input preference tool to set currency and tax options, joint venture settings, hurdle rate assumptions and other general preferences.
• Insert additional worksheets to assist you in customising the program.
• ‘Resize Model' feature allowing the user to expand or contract the size of the model by setting the number of Time Periods (between 45 - 150) and cost and revenue input items.
• Enter project costs such as:
  • Land Acquisition
  • Professional Fees
  • Construction Costs
  • Statutory Fees
  • Land Holding Costs
  • Miscellaneous Costs
  • Selling and Leasing Costs
• Enter project revenues such as:
  • Sales Revenue
  • Rental Income and Capitalised Sales
  • Interest on Deposits
  • Other Income
• Apply construction and/or project contingencies.
• Create custom s-curve profiles and apply to all project cost payments.
• Apply up to 10 years of annual rent reviews for individual rental tenancies.
• Apply up to 10 years of escalation rates on all costs and sales revenues.
• Inbuilt calculators for Stamp Duty and Land Tax.
• Automatic and flexible GST/VAT input credit and liability calculation.
• Nominate when GST/VAT liabilities are paid and credits are reclaimed.
• Lower risk of errors with background calculations checking and correcting input errors, cell validation and warnings to highlight data input errors.
  

Financing

• 5 sources of project finance:
  • Equity
  • Loans 1, 2 & 3 (other equity debt lenders)
  • Senior Loan (line of credit facility)
• Calculate loan limits on various cash flow components such as percentage of total project costs or value of pre-sales.
• Calculate fees as a percentage of the loan or a fixed amount.
• Nominate equity/debt drawdown and repayment methods.
• Flexibility in loan commencement, maturity and refinancing.
• Multiple methods to calculate how interest is calculated and paid for.
• Provide profit share to lenders.

Performance Analysis

• Summary Report which analyses
  • Project Costs and Revenues
  • Tax Credits and Liabilities
  • Development Yields and Revenue Rates
• Key performance indicators such as such as development profit, NPV, IRR, residual land values, etc.
• Returns on funds invested such as debt exposure, payback dates, loan ratios, IRR on equity, etc.
• Dynamic landscape cash flow table, allowing the user to view the occurrence of cash inflows and outflows and manipulate the financing.
• Various project cash flow charts that graphically display the position of equity and debt.
• Cash Flow report that can display full detail line-by-line or at a summary level.
• Generate a project timeline (Gantt Chart) at a click of a button and make adjustments to timing instantly.

Financial Accounting

• Profit and Loss and Balance Sheet reports.
• Multiple methods for revenue recognition and profit realisation thresholds.
• Calculate corporate tax on profits.

Advanced Functions

• Ability to store and recall up to 8 options or stages in one file for comparison/consolidation purposes.
• Consolidate report to enable the user to compare multiple development options or view consolidated stages of a single project.
• Sensitivity analysis of variables such as construction costs, sale values, interest rates, construction period, rents, etc.
• Determine probability profiles of development margin and IRR.
• Ability to model different joint venture arrangements between a land owner and developer, splitting costs, revenues and profit to either party at any pre-determined ratio.

Other Features

• Insert your company logo on reports.
• Print menu allowing the user to select any of reports to print.
• Export input data and cash flows to a central and secure SQL database.

For a printable version of our Key Features, please download our Datasheet