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, forecasting 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, etc.
Returns on funds invested such as debt exposure, payback dates, loan ratios, IRR on equity, etc.
Budget Variance reports of all stored forecasts, showing their performance indicators and any variations that have occurred against the current forecast.
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 for each stored budget and track your current profit against the original forecast.
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
Sensitivity analysis of variables such as construction costs, sale values, interest rates, construction period, rents, etc.
Determine probability profiles of development margin and IRR..
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.