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 - 240) 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.