Respondents are required to submit a Financial Model in accordance with the following requirements:
• the Financial Model must be provided in electronic form and compatible with Microsoft Excel ##; [Guidance note: Insert relevant Microsoft Excel version.]
• all amounts must be in thousands of Australian dollars (and must not be rounded);
• all Financial Model functions, formulae and linkages must be operational (including no circular references) and no part of the Financial Model should be password protected (unless the password is clearly provided for each level of protection), nor any cells or worksheets containing input, calculations or output data be hidden from view in any way, nor should any cells contain links to external workbooks or add-ins;
• there must be no hard coded figures in the Financial Model apart from the assumptions used and these should be clearly identified and located in a separate worksheet from the working calculations and outputs in the Financial Model;
• all Visual Basic macros must be fully documented to explain how the macros function and specify the relevant part of the Financial Model to which it relates;
• the process for 'optimising' the Financial Model must also be set out in full and step by step details (refer to Proposal Requirement C5.3 (Financial Close Adjustment Protocols) for further details);
• financial projections must be provided monthly during the Development Phase and quarterly for the Operating Phase. The statement of financial position, statement of financial performance and statement of cash flow must also be summarised on an annual basis assuming a 30 June year end;
• financial projections must be prepared in accordance with Australian Generally Accepted Accounting Principles; and
• Respondents must ensure that the Financial Proformas are completed and incorporated into the same file as the Financial Model. Where possible the Financial Proformas should be linked to the Financial Model workings.