{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["FVRA Result","Introduction","Accountant's Certificate","Result","1.Provider Details","2.Profit & Loss","3.Balance Sheet","4.Cashflow ","5.Bank, Debtors & Creditors","6.Student Numbers & Course Fees","7.Key Expenses","8. ASQA Review","Risk Settings & Weightings","Grey Rating Calculation","Section Checks & Step 1 Calcs ","Risk Calculations","Data Source"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":57,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FVRA Result","index":0,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"Financial Risk",null,null,{"$f":"'Risk Calculations'!H51","v":10},{"$f":"IF('Risk Calculations'!H51> 3, \"Tool Incomplete\", '8. ASQA Review'!I37)","v":"Tool Incomplete"}]
[]
[null,null,null,null,null,"Non Financial Risk",null,null,{"$f":"'Grey Rating Calculation'!C70","v":10},{"$f":"'Grey Rating Calculation'!C69","v":"Ignore current rating, not yet assessed."}]
[null,"FVRA - Result",null,null,null,"Decision",null,null,{"$f":"IF('8. ASQA Review'!J63=\"\", \"No Decision\", '8. ASQA Review'!J63)","v":"No Decision"}]
[]
[null,"General Information"]
[]
[null,null,"Tool Type",null,{"$f":"App_Type","v":0}]
[]
[null,null,"Legal Entity Type",null,{"$f":"'1.Provider Details'!J14","v":0}]
[null,null,"Legal Entity Name",null,{"$f":"'1.Provider Details'!J15","v":0}]
[]
[null,null,"Type of Training Organisation",null,{"$f":"'1.Provider Details'!J17","v":0}]
[null,null,"What is the organisation's financial year end date ?",null,{"$f":"'1.Provider Details'!J18","v":"00:00:00"}]
[]
[null,null,"Number of Delivery Locations",null,{"$f":"'1.Provider Details'!J34","v":0}]
[]
[null,null,"Initial Assessment & Referral Review Completed By",null,{"$f":"'8. ASQA Review'!J30","v":0}]
[null,null,"Date of Review",null,{"$f":"'8. ASQA Review'!J31","v":"00:00:00"}]
[]
[null,null,"Regulatory Operations Review Completed By",null,{"$f":"'8. ASQA Review'!J61","v":0}]
[null,null,"Date of Review",null,{"$f":"'8. ASQA Review'!J62","v":"00:00:00"}]
[]
[null,"ⓘ Financial Metrics"]
[]
[null,"Profit & Loss "]
[null,null,"Training revenue as % of total revenue",null,{"$f":"'Risk Calculations'!L14","v":0}]
[null,null,"% Government funded",null,{"$f":"'Risk Calculations'!L15","v":0}]
[null,null,"EBIT %",null,{"$f":"'Risk Calculations'!L16","v":0}]
[null,null,"Interest coverage",null,{"$f":"'Risk Calculations'!L17","v":0}]
[null,null,"Break-even (as % of total revenue)",null,{"$f":"'Risk Calculations'!L18","v":0}]
[null,null,"Employee costs as % of revenue",null,{"$f":"'Risk Calculations'!L19","v":0}]
[null,null,"Superannuation as % of employee costs",null,{"$f":"'Risk Calculations'!L20","v":0}]
[null,"Balance Sheet"]
[null,null,"Liquidity Ratio",null,{"$f":"'Risk Calculations'!L21","v":0}]
[null,null,"Debt to Equity (Gearing)",null,{"$f":"'Risk Calculations'!L22","v":0}]
[null,null,"Debt Ratio",null,{"$f":"'Risk Calculations'!L23","v":0}]
[null,null,"Debtor Days",null,{"$f":"'Risk Calculations'!L24","v":0}]
[null,null,"Creditor Days",null,{"$f":"'Risk Calculations'!L25","v":0}]
[null,"Cash flow"]
[null,null,"Working Capital",null,{"$f":"IF(Accrual_Accounting=\"No\", 999999999, 'Risk Calculations'!L26)","v":3}]
[null,null,"Operating cash flow ratio",null,{"$f":"'Risk Calculations'!L27","v":0}]
[]
[null,"ⓘ Non Financial Metrics"]
[]
[null,"Business Hygiene Statistics"]
[null,null,"Business plan",null,{"$f":"IF('Grey Rating Calculation'!F52=1, 4, 'Risk Calculations'!L32)","v":4}]
[null,null,"Financial forecasts",null,{"$f":"IF('Grey Rating Calculation'!F53=1, 4, 'Risk Calculations'!L33)","v":4}]
[null,null,"Management / audited / financial accounts",null,{"$f":"IF('Grey Rating Calculation'!F54=1, 4, 'Risk Calculations'!L34)","v":4}]
[null,null,"Key reconciliations (debtors / creditors / bank)",null,{"$f":"IF('Grey Rating Calculation'!F55=1, 4, 'Risk Calculations'!L35)","v":4}]
[null,null,"Aged debtors",null,{"$f":"'Risk Calculations'!L36","v":3}]
[null,null,"Aged creditors",null,{"$f":"'Risk Calculations'!L37","v":3}]
[null,null,"Protection of student pre-paid fees",null,{"$f":"IF('Grey Rating Calculation'!F56=1, 4, 'Risk Calculations'!L38)","v":4}]
[null,null,"Super obligations up to date",null,{"$f":"IF('Grey Rating Calculation'!F57=1, 4, 'Risk Calculations'!L39)","v":4}]
[null,null,"Tax obligations up to date",null,{"$f":"IF('Grey Rating Calculation'!F58=1, 4, 'Risk Calculations'!L40)","v":4}]
[null,null,"Rent obligations up to date",null,{"$f":"IF('Grey Rating Calculation'!F59=1, 4, 'Risk Calculations'!L41)","v":4}]
[null,null,"Accrual accounting",null,{"$f":"IF('Grey Rating Calculation'!F60=1, 4, 'Risk Calculations'!L42)","v":4}]
[null,null,"Current insurance",null,{"$f":"IF('Grey Rating Calculation'!F61=1, 4, 'Risk Calculations'!L43)","v":4}]
[null,null,"Unresolved legal disputes",null,{"$f":"IF('Grey Rating Calculation'!F62=1, 4, 'Risk Calculations'!L44)","v":4}]
[null,null,"Contingent liabilities",null,{"$f":"IF('Grey Rating Calculation'!F63=1, 4, 'Risk Calculations'!L45)","v":4}]

{"sheet":"Introduction","index":1,"n_rows":67,"n_cols":4,"rows_kept":67,"cut":false,"hidden":false,"merged":[[26,7,26,8],[5,7,5,8],[7,7,7,8]]}
[null,null,null,"V2"]
[]
[]
[]
[]
[]
[]
[]
[null,"Financial Viability Risk Assessment (FVRA) Tool "]
[]
[null,"Introduction"]
[]
[null,"The Financial Viability Risk Assessment (FVRA) tool is used by the Australian Skills Quality Authority (ASQA) to assess whether an applicant or existing RTO/CRICOS provider meets the Financial Viability Risk Assessment Requirements and/or the requirements of section 11 of the ESOS Act. The tool and supporting evidence is used to evaluate the likelihood of business continuity and capacity to achieve quality outcomes. In particular, the assessment informs a judgment about whether the organisation has the financial resources necessary to: \n\n"]
[null,"• acquire the requisite assets and physical resources to deliver all qualifications on its scope of registration"]
[null,"• employ sufficient appropriately qualified staff to cover the courses for which it takes enrolments"]
[null,"• provide appropriate levels of student services to students"]
[null,"• remain in business to ensure that each student can achieve completion "]
[null,"• meet the above requirements, even in an unsure environment."]
[null,"A decision on financial viability risk will be made on the basis of both financial and non-financial metrics from data in the tool and a review of the supporting evidence. An applicant must check the results tab prior to submission of this tool, as it will advise if the applicant meets the base financial requirements and whether to proceed with the submission."]
[null,"Completing the Financial Viability Risk Assessment Tool\n\nWho needs to complete the tool\n\nThe completion of this tool is a requirement for:\n- all applicants seeking initial registration as a Registered Training Organisation (RTO) or as a provider of education services to overseas students (CRICOS provider)\n- any RTO seeking to change their scope of registration within the first two years of their registration\n- any RTO or CRICOS provider who is notifying ASQA of a change of  50% or more of their shareholdings in the previous 12 months\n\nExisting RTOs and CRICOS providers may be required to complete this tool on request. \n\nGovernment agencies, and universities/schools established under Government legislation, are not required to complete the entire tool (complete only sections 1.1, 1.4 and 1.5 of the Provider Details tab and the Student Numbers and Course Fees tab). \n"]
[]
[null,"Before you start, save the tool using the correct file format"]
[]
[null,"This tool needs to be saved as a macro-enabled workbook (a .xlsm file). When you select \"Save As\" the file types to which you can save the Tool have been limited to (.xlsm) to help you avoid saving as the wrong file type."]
[]
[null,"How to complete the tool"]
[]
[null,"This tool comprises seven worksheets which require data input by the organisation, with the assistance of an accountant. All worksheets must be completed."]
[null,"• Tab 1 – Provider Details"]
[null,"• Tab 2 – Profit & Loss"]
[null,"• Tab 3 – Balance Sheet"]
[null,"• Tab 4 – Cash Flow"]
[null,"• Tab 5 – Bank, Debtors and Creditors"]
[null,"• Tab 6 – Student Numbers and Course Fees"]
[null,"• Tab 7 – Key Expenses"]
[null,"\nIt is essential that you complete Tab 1. Provider Details (Sections 1.1 – 1.7), before attempting to complete any other parts of this Tool.\nInformation icons (characterised by ⓘ ) are available to provide guidance in relation to the information that is required in that field.  In addition, cell input messages are provided (where relevant) to provide guidance in relation to the data type that is required. \nAll data entry fields have been colour coded and are characterised as follows:-\n"]
[]
[null,"Please ensure that you select the relevant Tool Type (Question 1 at Section 1.1 Background) before answering any other question. The information below explains which tool type should be selected for each circumstance. \n\nNew Registration (Start Up Business)\n- The organisation seeking registration as a training organisation and/or a CRICOS provider has been trading, in any form, for less than 12 months\n- The RTO seeking to change scope of registration has been trading, either as an RTO and/or in a separate business stream, for less than 12 months\n- The training provider has changed 50% or more of their shareholdings in the previous 12 months \n\nNew Registration (Existing Business)\n- The organisation seeking registration as a training organisation and/or a CRICOS provider has been trading, in any form, for more than 12 months\n- The RTO seeking to change scope of registration has been trading, either as an RTO and/or in a separate business stream, for more than 12 months\n\nMonitoring Review\n- ASQA has requested the organisation complete the FVRA tool as part of a compliance monitoring activity. This option should not be selected by a training provider who is submitting the tool as part of an application to change scope of registration.\n\nWhen completed at the time of making an application for registration, the tool and supporting evidence must be uploaded with the application in asqanet. Supporting evidence must be provided in one zip file. When completed as a monitoring review, ASQA will advise on how to submit the tool and evidence. \n"]
[null,"Actuals and forecasts\n\nIf you have selected the Tool Type New Registration (Start Up Business):\n- The first 12 months of 'forecast' data may include forecasts only or it may be a mix of actuals and forecasts if the financial year has already commenced at the time of completing the tool. Year 2 forecasts should include forecast figures only.\n\nIf you have selected the Tool Type New Registration (Existing Business) or Monitoring Review:\n - Year -2 Actual and Year-1 Actual should reflect historical actuals as per financial statements/management accounts for the last two financial years (or the last financial year where the business was not operating in the previous financial period).\n - The first 12 months of 'forecast' data may include forecasts only or it may be a mix of actuals and forecasts if the financial year has already commenced at the time of completing the tool. Year 2 forecasts should include forecast figures only.\n - If your organisation is not currently an RTO/CRICOS provider and the tool is being completed part way through a financial year, some of the forecast months listed in tab 6 and 7 that relate to student numbers and staff may be blank - to reflect that your organisation has not yet commenced training and assessment."]
[]
[null,"Tool results\n\nAfter you have completed the tool, the Result tab will provide a preliminary financial risk rating and a recommendation as to whether to submit the application or not (where this tool is required as an attachment to an application). \n"]
[null,"Nominated Accountants Certificate"]
[]
[null,"A Nominated Accountant is an external and independent accountant engaged by the organisation.\nThe Nominated Accountant must be:"]
[null,"• a member of one or more of the following professional bodies: CPA Australia, The Institute of Chartered Accountants in Australia or The Institute of Public Accountants, and/ or"]
[null,"• registered with the Australian Securities and Investment Commission as an auditor."]
[null,"The nominated accountant will be able to confirm and assist with the input of data in the tool, but also is required to sign the nominated accountant’s certificate, found in the tab Nominated Accountant’s Certificate. \n\nA signed nominated accountant’s certificate (signed within the last 30 days) is a required attachment for applications for initial VET or CRICOS registration or when requested as part of a monitoring review. It is not a requirement that the certificate is attached when this tool is submitted with an application to change scope of registration.\n"]
[]
[null,"Supporting Evidence"]
[]
[null,"Supporting evidence as outlined in Worksheet 1 – Provider Details must be provided with the tool. If the supporting evidence requested is not relevant to your organisation, provide an explanation. If evidence or an appropriate explanation is not provided with this tool and it is being submitted with an application, the application will be incomplete."]
[]
[null,"Strategic Business Plan "]
[null,"The strategic business plan should address the following requirements:"]
[null,"• Company overview (description of the business) including funding sources, target market (student cohort), key clients and/or industries, courses, locations and equipment and facilities "]
[null,"• Goals and objectives of the organisation"]
[null,"• Strategic/long term direction of organisation"]
[null,"• Market analysis of the industry being entered (including locations and methods of delivery you intend to offer, demand and competitors)"]
[null,"• Basic strengths, weaknesses, opportunities and threats (SWOT) analysis"]
[null,"• Financial projections for at least the next 12 and 24 months "]
[null,"• Organisation structure, including position titles and names of staff members"]
[]
[null,"More information and help"]
[]
[null,"For further assistance, please call the ASQA Info line on 1300 701 801 between Monday and Friday, 9.00 am to 7.00 pm AEST, or email your enquiry to enquiries@asqa.gov.au."]
[]
[null,"Version 3.2"]

{"sheet":"Accountant's Certificate","index":2,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[[48,1,48,2],[5,7,5,8],[9,7,9,8],[8,1,8,2],[22,1,22,2],[20,1,20,2],[24,0,24,2],[25,0,25,2],[19,0,19,2],[18,0,18,2],[14,0,14,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[11,0,11,1],[30,1,30,2],[28,0,28,2],[12,0,12,2],[27,0,27,2],[26,0,26,2],[29,0,29,2]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"Please Print & have this form completed by  the nominated accountant. A signed nominated accountant’s certificate (signed within the last 30 days) is a required attachment. "]
[]
[null,"Nominated Accountant’s Certificate "]
[]
["Identifiers of Entity [Source: Australian Business Register]"]
["Australian Business Number:"]
["Entity Name:"]
["ABN Status:"]
["Entity type:"]
[]
["Conclusion"]
[]
[1,"I, the nominated accountant named below, have reviewed the accompanying ASQA Financial Viability Risk Assessment (FVRA) Tool (“Tool”) which comprises financial and non-financial information presented at Sections 2 through 7, the strategic business plan and other supporting evidence provided to me by the Chief/Principal Executive Officer representing the organisation’s management."]
[]
[2,"Based on my review, which is not an audit, nothing has come to my attention that causes me to believe that: \n \t \n        a.\t   the historical financial information and prospective financial information presented at Sections 2, 3, 4 and 7 of the Tool, is \n              not presented fairly, in all material respects, in accordance with the stated basis of preparation, as described in section 24\n              of the National Vocational Education and Training Regulator Act 2011 and/or section 11 of the Education Services for \n              Overseas Students Act 2000; and  \n\n        b.\t   the non-financial information presented at Sections 5 and 6 of the Tool is not presented fairly, in all material respects, \n               in accordance with the stated basis of preparation, as described in section 24 of the National Vocational Education and \n               Training Regulator Act 2011 and/or section 11 of the Education Services for Overseas Students Act 2000."]
[]
["Management's Responsibility for the Financial Statements\n\nManagement is responsible for the preparation and compilation of the financial and non-financial information contained in the Tool in accordance with the Australian Accounting Standards, and for such internal control as management determines is necessary to enable the population of the Tool free from material misstatement.\n\nBased upon my assessment of the information provided to me by the Chief/Principal Executive Officer, the entity has sufficient financial resources:\n            a. \t  to meet its obligations under paragraph 6 of the National Vocational Education and Training Regulator (Financial Viability\n                  Risk Assessment Requirements) Amendment Instrument 2021; and/or\n            b.\t   such that ASQA would have no reason to believe that the entity does not have the clearly demonstrated capacity to provide\n                  education of a satisfactory standard (as per section 11(e)(i) of the Education Services for Overseas Students Act 2000)."]
["Nominated Accountant's Responsibility\n\nMy responsibility is to conclude based on: \n            a.\t    my review procedures on the historical financial information presented at Sections 2, 3, 4 and 7 of the Tool; and  \n            b.\t    my limited assurance procedures on the non-financial information at Sections 5 and 6 of the Tool and prospective financial \n                   information at Sections 2 through 7 of the Tool."]
["Review of Historical Financial Information\n\nI conducted my review of the historical financial information presented at Sections 2, 3, 4 and 7 of the Tool in accordance with ASRE 2405 Review of Historical Financial Information Other than a Financial Report. \n\nA review consists of making enquiries and applying analytical and other review procedures. A review is substantially less in scope than an audit conducted in accordance with Auditing Standards and consequently does not enable me to obtain assurance that I would become aware of all significant matters that might be identified in an audit. Accordingly, I do not express an audit opinion on the historical financial information presented at Sections 2, 3, 4 and 7 of the Tool.  "]
["Limited Assurance on Financial Information and Prospective Financial Information\n\nI conducted (at least) limited assurance procedures on: \n          a.\t   the non-financial information at Sections 5 and 6 of the Tool in accordance with ASAE 3000 Assurance Engagements \n                Other than Audits or Reviews of Historical Financial Information; and\n          b.\t   the prospective financial information at Sections 2 through 7 of the Tool in accordance with ASAE 3450 Assurance\n                Engagements involving Corporate Fundraisings and/or Prospective Financial Information."]
["A limited assurance engagement is defined by the Auditing and Assurance Standards Board in A guide for Prescribing Assurance and Related Services."]
["The procedures performed in a limited assurance engagement vary in nature and timing from, and are less in extent than for a reasonable assurance engagement; and consequently, the level of assurance obtained in a limited assurance engagement is substantially lower than the assurance that would have been obtained had a reasonable assurance engagement been performed.  \n\nThe applicable Standards require that I comply with relevant ethical requirements and plan and perform my work to obtain limited assurance as to whether anything has come to my attention that causes me to believe that the financial and non-financial information presented at Sections 2 through 7 of the Tool are not materially misstated."]
[null,"Nominated Accountant’s details:"]
[]
[null,"Name"]
[]
[null,"Company Name"]
[]
[null,"Telephone Number"]
[]
[null,"Email"]
[]
[null,"Professional Body Name"]
[]
[null,"Professional Body Membership Number"]
[]
[null,"Signature"]
[]
[null,"Date"]

{"sheet":"Result","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[16,6,16,7],[19,6,19,7],[8,6,9,7],[29,2,29,7],[30,2,31,7],[12,4,12,7],[26,4,26,7]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Financial Risk ",{"$f":"'Risk Calculations'!H51","v":10}]
[]
[null,"FVRA - Result",null,null,null,"Recommendation",{"$f":"'Risk Calculations'!I51","v":"Tool is incomplete. Not ready to submit"}]
[null,null,{"$f":"\" \"","v":" "}]
[null,null,null,null,null,null,null,{"$f":"IF(TRIM(C31)<>\"\", \"(See the botton of page for specific issues to correct)\", \"\")","v":{"$error":"#NAME?"}}]
[]
[]
[null,"General Information"]
[]
[null,null,"Application Type",null,{"$f":"App_Type","v":0}]
[]
[null,null,"Legal Entity Type",null,{"$f":"'1.Provider Details'!J14","v":0}]
[null,null,"Legal Entity Name",null,{"$f":"'1.Provider Details'!J15","v":0}]
[]
[null,null,"Type of Training Organisation",null,{"$f":"'1.Provider Details'!J17","v":0}]
[null,null,"What is the organisation's financial year end date ?",null,{"$f":"'1.Provider Details'!J18","v":"00:00:00"}]
[]
[null,null,"Number of Delivery Locations",null,{"$f":"'1.Provider Details'!J34","v":0}]
[]
[null,null,"Things to check if this tool is incomplete:"]
[null,null,"Tool Type - New Registration (Start Up)\n\nTab 1. Provider Details\n         o ALL fields are completed\n\nTab 2. Profit and Loss\n        o total training revenue  (Cell U22)\n        o total revenue is equal to or greater than 1 (Cell U29)\n        o staff costs, including for non-training staff (Cell U44 and/or U46 must be populated)\n        o total fixed costs are equal to or greater than 1 (Cell U54)\n\nTab 3. Balance Sheet\n        o the balance sheet balances (Cell V60=V67)\n        o total current assets are equal to or greater than 1 (Cell V21)\n        o total current liabilities are equal to or greater than 1 (Cell V47)\n        o total equity is a value other than zero (Cell V67)\n\nTab 4. Cash Flow (only applicable if using accrual accounting)\n        o Net cash flows from “Operating Activities” are a value other than zero (Cell V19)\n \n",null,"Tool Type - New Registration (Existing Business) or Monitoring Review\n\nTab 1. Provider Details\n         o ALL fields are completed\n\nTab 2. Profit and Loss\n        o total training revenue  (Cell U22)\n        o total revenue is equal to or greater than 1 (Cells H29 AND U29)\n        o staff costs, including for non-training staff  (Cells H44 and/or H46 AND Cells U44 and/or U46 must be populated)\n        o total fixed costs are equal to or greater than 1 (Cell H54 AND U54)\n\nTab 3. Balance Sheet\n        o the balance sheet balances (Cells I60=I67 AND V60=V67)\n        o total current assets are equal to or greater than 1 (Cells I21 AND V21)\n        o total current liabilities are equal to or greater than 1 (Cells I47 AND V47)\n        o total equity is a value other than zero (Cell I67 AND V67)\n\nTab 4. Cash Flow (only applicable if using accrual accounting)\n        o Net cash flows from “Operating Activities” are a value other than zero (Cell V19)\n"]
[]
[]
[null,null,{"$f":"IF(TRIM(C31)<>\"\", \"Please correct the following issues:\", \"\")","v":{"$error":"#NAME?"}}]
[null,null,{"$f":"IF(OR(E22<2, TRIM('Grey Rating Calculation'!$B$73)=\"\"), \"\", 'Grey Rating Calculation'!$B$73)","v":{"$error":"#NAME?"}}]

{"sheet":"1.Provider Details","index":4,"n_rows":128,"n_cols":12,"rows_kept":128,"cut":false,"hidden":false,"merged":[[108,3,108,8],[0,12,0,13],[12,3,12,6],[25,3,25,8],[24,3,24,8],[23,3,23,8],[21,3,21,8],[19,3,19,7],[16,3,16,6],[14,3,14,6],[13,3,13,6],[102,3,102,7],[85,3,85,7],[15,3,15,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Provider Details"]
[]
[]
[null,1.1000000000000001,null,"Background",null,null,null,null,null,"Response"]
[null,null,"ⓘ","Tool Type"]
[null,null,"ⓘ","Legal Entity Type"]
[null,null,"ⓘ","Legal Entity Name"]
[null,null,"ⓘ","Australian Business Number (\"ABN\")"]
[null,null,"ⓘ","Type of Training Organisation"]
[null,null,"ⓘ","What is the organisation's financial year end date ?"]
[null,1.2,null,"Group Structure"]
[null,null,"ⓘ","Is the organisation part of a larger group structure ?"]
[null,null,"ⓘ","Please list all related entities"]
[null,null,"ⓘ","Are there (will there) be any financial guarantees in place ?"]
[null,null,"ⓘ","Please provide all details of financial guarantees in place or planned"]
[null,null,"ⓘ","Is this a Cross Guarantee ?"]
[null,null,"ⓘ","Name of Guarantor Entity"]
[null,null,"ⓘ","Name of Entity Guaranteed"]
[null,1.3,null,"Key Personnel"]
[null,null,null,"CEO Name"]
[null,null,"ⓘ","Qualified Accountant"]
[null,null,"ⓘ","Membership Body"]
[null,null,"ⓘ","Membership Number"]
[null,1.4,null,"Delivery sites"]
[null,null,null,"Dropdown Option - For when not a face to face delivery (Hidden from User)",null,null,null,null,null,"N/A"]
[null,null,"ⓘ","Number of Primary Delivery Locations"]
[null,null,"ⓘ","Location address 1"]
[null,null,null,"Location address 2"]
[null,null,null,"Location address 3"]
[null,null,null,"Location address 4"]
[null,null,null,"Location address 5"]
[null,null,null,"Location address 6"]
[null,null,null,"Location address 7"]
[null,null,null,"Location address 8"]
[null,null,null,"Location address 9"]
[null,null,null,"Location address 10"]
[null,null,null,"Location address 11"]
[null,null,null,"Location address 12"]
[null,null,null,"Location address 13"]
[null,null,null,"Location address 14"]
[null,null,null,"Location address 15"]
[null,null,null,"Location address 16"]
[null,null,null,"Location address 17"]
[null,null,null,"Location address 18"]
[null,null,null,"Location address 19"]
[null,null,null,"Location address 20"]
[null,null,null,"Location address 21"]
[null,null,null,"Location address 22"]
[null,null,null,"Location address 23"]
[null,null,null,"Location address 24"]
[null,null,null,"Location address 25"]
[null,null,null,"Location address 26"]
[null,null,null,"Location address 27"]
[null,null,null,"Location address 28"]
[null,null,null,"Location address 29"]
[null,null,null,"Location address 30"]
[null,null,null,"Location address 31"]
[null,null,null,"Location address 32"]
[null,null,null,"Location address 33"]
[null,null,null,"Location address 34"]
[null,null,null,"Location address 35"]
[null,null,null,"Location address 36"]
[null,null,null,"Location address 37"]
[null,null,null,"Location address 38"]
[null,null,null,"Location address 39"]
[null,null,null,"Location address 40"]
[null,null,null,"Location address 41"]
[null,null,null,"Location address 42"]
[null,null,null,"Location address 43"]
[null,null,null,"Location address 44"]
[null,null,null,"Location address 45"]
[null,null,null,"Location address 46"]
[null,null,null,"Location address 47"]
[null,null,null,"Location address 48"]
[null,null,null,"Location address 49"]
[null,null,null,"Location address 50"]
[null,1.5,null,"Pre-paid fees"]
[null,null,"ⓘ","Does/Will your organisation collect more than $1500 of fees in advance from domestic students?"]
[null,null,"ⓘ","if yes, which Protection mechanism is in place?"]
[null,null,"ⓘ",{"$f":"'Data Source'!B35","v":"Option 1 – Policy"}]
[null,null,"ⓘ",{"$f":"'Data Source'!B36","v":"Option 2 – Financial Guarantee"}]
[null,null,"ⓘ",{"$f":"'Data Source'!B37","v":"Option 3 – Tuition Assurance Scheme"}]
[null,null,"ⓘ",{"$f":"'Data Source'!B38","v":"Option 4 - Other"}]
[null,1.6,null,"Statutory liabilities, other key creditors & Other"]
[null,null,"ⓘ","Are all superannuation payments up to date?"]
[null,null,"ⓘ","Please explain."]
[null,null,"ⓘ","Are all tax (PAYG and GST) obligations up to date?"]
[null,null,"ⓘ","Please explain."]
[null,null,"ⓘ","What is the current amount of tax debt outstanding?"]
[null,null,"ⓘ","Do you have a repayment plan in place with the ATO?",null,null,null,null,null,"No"]
[null,null,"ⓘ","Please explain."]
[null,null,"ⓘ","Are all rent obligations up to date?"]
[null,null,"ⓘ","Please explain."]
[null,null,"ⓘ","Does your entity use an accrual basis of accounting?"]
[null,null,"ⓘ","Do you (or will you have) adequate insurance cover, including Public Liability Insurance and WorkCover?"]
[null,null,"ⓘ","Please explain."]
[null,null,"ⓘ","Are there any unresolved legal disputes or litigation against your entity?"]
[null,null,"ⓘ","Please explain."]
[null,null,"ⓘ","Are there any contingent liabilities in existence?"]
[null,null,"ⓘ","Please explain."]
[null,null,"ⓘ","Is there any further access to funding that the business may have, including bank loans, Director loans, capital injection and/or personal guarantees?"]
[null,null,"ⓘ","Please explain."]
[null,1.7,null,"Checklist"]
[null,null,null,"Have the following been attached? If \"Yes\" provide the filename, if \"No\" provide an explanation as to why.",null,null,null,null,null,null,"Explanation","Filename (eg. BusinessPlan.pdf)"]
[null,null,"ⓘ","Business Plan/Strategic Plan"]
[null,null,"ⓘ","Financial statements (last two years - audited if possible)"]
[null,null,"ⓘ","Current management accounts"]
[null,null,"ⓘ","Bank statements - within 1 week of application lodgement"]
[null,null,"ⓘ","Bank statements - as at most recent financial year end"]
[null,null,"ⓘ","Bank statements - as at most recent month end"]
[null,null,"ⓘ","Bank reconciliations - as at most recent financial year end"]
[null,null,"ⓘ","Bank reconciliations - as at most recent month end"]
[null,null,"ⓘ","ATO Portal - integrated client account"]
[null,null,"ⓘ","ATO repayment plan"]
[null,null,"ⓘ","Aged debtors ledger- as at most recent financial year end"]
[null,null,"ⓘ","Aged debtors ledger- as at most recent month end"]
[null,null,"ⓘ","Aged creditors ledger- as at most recent financial year end"]
[null,null,"ⓘ","Aged creditors ledger- as at most recent month end"]
[null,null,"ⓘ","Deed of guarantees or other legally enforceable instruments"]
[null,null,"ⓘ","Signed nominated accountants certificate"]

{"sheet":"2.Profit & Loss","index":5,"n_rows":61,"n_cols":22,"rows_kept":61,"cut":false,"hidden":false,"merged":[[8,8,8,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Profit & Loss Statement ",null,null,null,null,null,null,"Forecast year one columns – contains forecast amounts for future months as well as actual amounts for any months in which trading has already occurred"]
[]
[null,null,null,null,null,"Year -2 (Actual)",{"$f":"'Data Source'!B138","v":"Year -2 (Actual)"},{"$f":"'Data Source'!B139","v":"Year -1 (Actual)"},{"$f":"'Data Source'!B140","v":"Forecast Month 1"},{"$f":"'Data Source'!B141","v":"Forecast Month 2"},{"$f":"'Data Source'!B142","v":"Forecast Month 3"},{"$f":"'Data Source'!B143","v":"Forecast Month 4"},{"$f":"'Data Source'!B144","v":"Forecast Month 5"},{"$f":"'Data Source'!B145","v":"Forecast Month 6"},{"$f":"'Data Source'!B146","v":"Forecast Month 7"},{"$f":"'Data Source'!B147","v":"Forecast Month 8"},{"$f":"'Data Source'!B148","v":"Forecast Month 9"},{"$f":"'Data Source'!B149","v":"Forecast Month 10"},{"$f":"'Data Source'!B150","v":"Forecast Month 11"},{"$f":"'Data Source'!B151","v":"Forecast Month 12"},{"$f":"'Data Source'!B152","v":"Forecast Year 1"},{"$f":"'Data Source'!B153","v":"Forecast Year 2"}]
[null,"REVENUE"]
[null,null,"Training Revenue"]
[null,null,"ⓘ","VET Student Loans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I14:T14)","v":0}]
[null,null,"ⓘ","Government Funding - state based funding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I15:T15)","v":0}]
[null,null,"ⓘ","VET - FFS Domestic Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","VET or ELICOS – FFS International students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Tuition fees from corporate clients",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Payment from third parties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Non Accredited Training Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other Fees and Charges - students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total Training Revenue",null,null,{"$f":"SUM(F14:F21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Other Revenue"]
[null,null,"ⓘ","Non-education related Commercial Activities ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I25:T25)","v":0}]
[null,null,"ⓘ","Other revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I26:T26)","v":0}]
[null,null,"Total Other Revenue",null,null,{"$f":"SUM(F25:F26)","v":0},{"$f":"SUM(G25:G26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL REVENUE",null,null,null,{"$f":"SUM(F22,F27)","v":0},{"$f":"SUM(G22,G27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"EXPENSES"]
[null,null,"Direct costs (variable)"]
[null,null,"ⓘ","Trainers and Assessor Salaries and Related Expenses (Excluding Super)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I33:T33)","v":0}]
[null,null,"ⓘ","Trainers and Assessor Superannuation Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Training Room Hire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Learning and Assessment Resources (Purchase and Maintenance)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Commissions to Third Parties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other Variable Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total Direct costs (variable)",null,null,{"$f":"SUM(F33:F38)","v":0},{"$f":"SUM(G33:G39)","v":0},{"$f":"SUM(H33:H39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"GROSS PROFIT",null,null,null,{"$f":"F29-F40","v":0},{"$f":"G29-G40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Fixed costs"]
[null,null,"ⓘ","Trainers and Assessor Salaries and Related Expenses (Excluding Super)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I44:T44)","v":0}]
[null,null,"ⓘ","Trainers and Assessor Superannuation Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Management and Administrative Staff Salaries and Related Expenses (Excluding Super)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Management and Administrative Staff Superannuation Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Learning and Assessment Materials & Equipment (Purchase, Equipment Lease and Maintenance)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Occupancy Costs (Rent and outgoings)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Marketing and Advertising Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other Repairs & Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Insurances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total Fixed costs",null,null,{"$f":"SUM(F44:F53)","v":0},{"$f":"SUM(G44:G53)","v":0},{"$f":"SUM(H44:H53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBITDA",null,null,null,{"$f":"F42-F54","v":0},{"$f":"G42-G54","v":0},{"$f":"H42-H54","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ⓘ","Depreciation and Amortisation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I56:T56)","v":0}]
[null,"EBIT",null,null,null,{"$f":"F55-F56","v":0},{"$f":"G55-G56","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ⓘ","Interest Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I58:T58)","v":0}]
[null,"ⓘ","Interest Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I59:T59)","v":0}]
[]
[null,"TOTAL PROFIT/(LOSS)",null,null,null,{"$f":"F57-SUM(F58:F59)","v":0},{"$f":"G57+G58-G59","v":0},{"$f":"H57+H58-H59","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"3.Balance Sheet","index":6,"n_rows":67,"n_cols":23,"rows_kept":67,"cut":false,"hidden":false,"merged":[[8,9,8,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Balance Sheet ",null,null,null,null,null,null,null,"Forecast year one columns – contains forecast amounts for future months as well as actual amounts for any months in which trading has already occurred"]
[null,null,null,null,null,null,null,{"$f":"IF(H60<>H67,\"Out of Balance\",\"\")","v":""},{"$f":"IF(I60<>I67,\"Out of Balance\",\"\")","v":""},"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"'Data Source'!B138","v":"Year -2 (Actual)"},{"$f":"'Data Source'!B139","v":"Year -1 (Actual)"},{"$f":"'Data Source'!B140","v":"Forecast Month 1"},{"$f":"'Data Source'!B141","v":"Forecast Month 2"},{"$f":"'Data Source'!B142","v":"Forecast Month 3"},{"$f":"'Data Source'!B143","v":"Forecast Month 4"},{"$f":"'Data Source'!B144","v":"Forecast Month 5"},{"$f":"'Data Source'!B145","v":"Forecast Month 6"},{"$f":"'Data Source'!B146","v":"Forecast Month 7"},{"$f":"'Data Source'!B147","v":"Forecast Month 8"},{"$f":"'Data Source'!B148","v":"Forecast Month 9"},{"$f":"'Data Source'!B149","v":"Forecast Month 10"},{"$f":"'Data Source'!B150","v":"Forecast Month 11"},{"$f":"'Data Source'!B151","v":"Forecast Month 12"},{"$f":"'Data Source'!B152","v":"Forecast Year 1"},{"$f":"'Data Source'!B153","v":"Forecast Year 2"}]
[null,"ASSETS"]
[null,null,"Current Assets"]
[null,null,"ⓘ","Cash and cash equivalents including overdraft accounts\n(Overdraft accounts to be included as a negative whole number)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U14","v":0}]
[null,null,"ⓘ","Related party receivables/loans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U15","v":0}]
[null,null,"ⓘ","Trade debtors and Other Receivables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Accrued income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Pre-payments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Inventories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total current assets",null,null,null,null,{"$f":"SUM(H14:H20)","v":0},{"$f":"SUM(I14:I20)","v":0},{"$f":"SUM(J14:J20)","v":0},{"$f":"SUM(K14:K20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Non-current Assets"]
[null,null,"ⓘ","Related party receivables/loans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U24","v":0}]
[null,null,"ⓘ","Rental bonds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Property, plant and equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","less Accumulated Depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Leasehold Improvements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","less Accumulated Depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Intangible assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","less Accumulated Amortisation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other Investments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total non-current assets",null,null,null,null,{"$f":"SUM(H24:H33)","v":0},{"$f":"SUM(I24:I33)","v":0},{"$f":"SUM(J24:J33)","v":0},{"$f":"SUM(K24:K33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL ASSETS",null,null,null,null,null,{"$f":"SUM(H21,H34)","v":0},{"$f":"SUM(I21,I34)","v":0},{"$f":"SUM(J21,J34)","v":0},{"$f":"SUM(K21,K34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"LIABILITIES"]
[null,null,"Current Liabilities"]
[null,null,"ⓘ","Related party payables/loans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U40","v":0}]
[null,null,"ⓘ","Trade creditors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Borrowings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Provisions - employee entitlements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Provisions - tax (GST, PAYG & Income Tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Income Received in Advance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total current liabilities",null,null,null,null,{"$f":"SUM(H40:H46)","v":0},{"$f":"SUM(I40:I46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Non-current Liabilities"]
[null,null,"ⓘ","Related party payables/loans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U50","v":0}]
[null,null,"ⓘ","Borrowings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Provisions - employee entitlements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Income Received in Advance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Deferred tax liabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"ⓘ","Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total non-current liabilities",null,null,null,null,{"$f":"SUM(H50:H55)","v":0},{"$f":"SUM(I50:I55)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL LIABILITIES",null,null,null,null,null,{"$f":"SUM(H47,H56)","v":0},{"$f":"SUM(I47,I56)","v":0},{"$f":"SUM(J47,J56)","v":0},{"$f":"SUM(K47,K56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"NET ASSETS/(LIABILITIES)",null,null,null,null,null,{"$f":"H36-H58","v":0},{"$f":"I36-I58","v":0},{"$f":"J36-J58","v":0},{"$f":"K36-K58","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"EQUITY"]
[null,"ⓘ","Issued & Paid-up Capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U63","v":0}]
[null,"ⓘ","Reserves",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U64","v":0}]
[null,"ⓘ","Retained earnings/surplus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U65","v":0}]
[null,"ⓘ","Current earnings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U66","v":0}]
[null,"TOTAL EQUITY",null,null,null,null,null,{"$f":"SUM(H63:H66)","v":0},{"$f":"SUM(I63:I66)","v":0},{"$f":"SUM(J63:J66)","v":0},{"$f":"SUM(K63:K66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"4.Cashflow ","index":7,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,7,8,22],[9,9,9,21]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Cash flow ",null,null,null,null,null,"Please enter all cash outflows as negative values"]
[null,null,null,null,null,null,null,null,null,"Forecast year one columns – contains forecast amounts for future months as well as actual amounts for any months in which trading has already occurred"]
[null,null,null,null,null,null,null,{"$f":"'Data Source'!B138","v":"Year -2 (Actual)"},{"$f":"'Data Source'!B139","v":"Year -1 (Actual)"},{"$f":"'Data Source'!B140","v":"Forecast Month 1"},{"$f":"'Data Source'!B141","v":"Forecast Month 2"},{"$f":"'Data Source'!B142","v":"Forecast Month 3"},{"$f":"'Data Source'!B143","v":"Forecast Month 4"},{"$f":"'Data Source'!B144","v":"Forecast Month 5"},{"$f":"'Data Source'!B145","v":"Forecast Month 6"},{"$f":"'Data Source'!B146","v":"Forecast Month 7"},{"$f":"'Data Source'!B147","v":"Forecast Month 8"},{"$f":"'Data Source'!B148","v":"Forecast Month 9"},{"$f":"'Data Source'!B149","v":"Forecast Month 10"},{"$f":"'Data Source'!B150","v":"Forecast Month 11"},{"$f":"'Data Source'!B151","v":"Forecast Month 12"},{"$f":"'Data Source'!B152","v":"Forecast Year 1"},{"$f":"'Data Source'!B153","v":"Forecast Year 2"}]
[]
[null,"CASH FLOWS FROM OPERATING ACTIVITIES"]
[null,"ⓘ","Cash Receipts from Students/Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J14:U14)","v":0}]
[null,"ⓘ","Cash paid to suppliers and employees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Cash generated from other operating activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Interest paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Income tax received/(paid)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"NET CASH INFLOW/(OUTFLOW) FROM OPERATING ACTIVITIES",null,null,null,null,null,{"$f":"SUM(H14:H18)","v":0},{"$f":"SUM(I14:I18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"CASH FLOWS FROM INVESTING ACTIVITIES"]
[null,"ⓘ","Interest received",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J22:U22)","v":0}]
[null,"ⓘ","Dividends received",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Proceeds from sale of property, plant and equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Proceeds from sale of investments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Acquisition of Property Plant & Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Acquisitions - other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"NET CASH INFLOW/(OUTFLOW) FROM INVESTING ACTIVITIES",null,null,null,null,null,{"$f":"SUM(H22:H28)","v":0},{"$f":"SUM(I22:I28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"CASH FLOWS FROM FINANCING ACTIVITIES"]
[null,"ⓘ","Proceeds from borrowings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J32:U32)","v":0}]
[null,"ⓘ","Proceeds from issue of share capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Dividends paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Repayment of borrowings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ⓘ","Loans granted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"NET CASH INFLOW/(OUTFLOW) FROM FINANCING ACTIVITIES",null,null,null,null,null,{"$f":"SUM(H32:H36)","v":0},{"$f":"SUM(I32:I36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"NET INCREASE / (DECREASE) IN CASH AND CASH EQUIVALENTS",null,null,null,null,null,{"$f":"SUM(H37,H29,H19)","v":0},{"$f":"SUM(I37,I29,I19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(J39:U39)","v":0},0]
[]
[null,"CASH AND CASH EQUIVALENTS AT BEGINNING OF THE PERIOD",null,null,null,null,null,null,null,null,{"$f":"J42","v":0},{"$f":"K42","v":0},0,0,0,0,0,0,0,0,0,{"$f":"J41","v":0},{"$f":"V42","v":0}]
[null,"CASH AND CASH EQUIVALENTS AT THE END OF THE PERIOD",null,null,null,null,null,{"$f":"SUM(H39,H41)","v":0},{"$f":"SUM(I39,I41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U39,U41)","v":0},{"$f":"U42","v":0},0]

{"sheet":"5.Bank, Debtors & Creditors","index":8,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"FVRA - Bank Accounts, Debtors & Creditors"]
[]
[null,null,"Bank Accounts",null,null,null,"ⓘ","ⓘ",null,"ⓘ","ⓘ"]
[null,null,"Bank details (including Banking Institution; account name; account number)","Current Bank Balance per most recent Bank Statement","Approved facility limit (if loan / overdraft)","Balance per the accounts as at the last financial year end date","Has the bank account been reconciled to the accounts and the bank reconciliation statement provided?","Bank statement           last financial year","Balance per the accounts as at the last monthly accounts","Has the bank account been reconciled to the accounts and the bank reconciliation statement provided?","Bank statement           last monthly accounts"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Aged Debtors"]
[null,null,"Dated","Current","30 days","60 days",">90 days","Total"]
[null,"ⓘ","Last financial year end",null,null,null,null,{"$f":"SUM(D31:G31)","v":0}]
[null,"ⓘ","Last monthly management accounts",null,null,null,null,{"$f":"SUM(D32:G32)","v":0}]
[]
[null,null,"Aged Creditors"]
[null,null,"Dated","Current","30 days","60 days",">90 days","Total"]
[null,"ⓘ","Last financial year end",null,null,null,null,{"$f":"SUM(D36:G36)","v":0}]
[null,"ⓘ","Last monthly management accounts",null,null,null,null,{"$f":"SUM(D37:G37)","v":0}]

{"sheet":"6.Student Numbers & Course Fees","index":9,"n_rows":117,"n_cols":100,"rows_kept":117,"cut":false,"hidden":false,"merged":[[12,1,12,14],[11,1,11,14],[14,5,14,7],[14,9,14,14],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[97,15,97,16],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[61,15,61,16],[62,15,62,16],[63,15,63,16],[64,15,64,16],[65,15,65,16],[98,15,98,16],[99,15,99,16],[100,15,100,16],[14,68,14,83],[14,84,14,99],[114,15,114,16],[115,15,115,16],[15,15,15,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[113,15,113,16],[102,15,102,16],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[14,16,14,17],[101,15,101,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[71,15,71,16],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[66,15,66,16],[67,15,67,16],[68,15,68,16],[69,15,69,16],[70,15,70,16],[81,15,81,16],[82,15,82,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[76,15,76,16],[77,15,77,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[96,15,96,16],[91,15,91,16],[92,15,92,16],[93,15,93,16],[94,15,94,16],[95,15,95,16],[86,15,86,16],[87,15,87,16],[88,15,88,16],[89,15,89,16],[90,15,90,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Student Numbers & Course Fees - Commencing Students"]
[]
[null,"Instructions"]
[null,"List information in the table below for all courses that you are currently registered to deliver as well as any new courses for which you have applied.\n\nFor each time period, include the total number or students who are or were enrolled during the time period (this includes both existing/continuing students as well as new students who enrolled withing that period).\n\nFor each training product with a different course fee, please complete a new row.\nFor example:"]
[null,"If delivering SIT20316 Certificate II in Hospitality where the online mode of delivery is charged at $1000, but the face to face mode of delivery is charged at $3000, this training product should be listed on two rows to identify this difference. \n"]
[]
[null,null,null,null,"ⓘ","Delivery mode",null,null,"ⓘ","Client cohort",null,null,null,null,null,"ⓘ","Duration",null,"ⓘ Delivery location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Course fees multiplied by student numbers"]
[null,"Course Code","Course Name ","Course Fees","Face to face at RTO premises","Face to face at workplace","Online","Distance","Apprenticeships or trainees","Corporate/business clients","Fee for service (General public)","RPL/Assessment only","School based","Student visa holders","Other government funded (general public)","Weeks",null,"Hours",{"$f":"'1.Provider Details'!$J35","v":0},{"$f":"'1.Provider Details'!$J36","v":0},{"$f":"'1.Provider Details'!$J37","v":0},{"$f":"'1.Provider Details'!$J38","v":0},{"$f":"'1.Provider Details'!$J39","v":0},{"$f":"'1.Provider Details'!J40","v":0},{"$f":"'1.Provider Details'!$J41","v":0},{"$f":"'1.Provider Details'!$J42","v":0},{"$f":"'1.Provider Details'!$J43","v":0},{"$f":"'1.Provider Details'!$J44","v":0},{"$f":"'1.Provider Details'!$J45","v":0},{"$f":"'1.Provider Details'!$J46","v":0},{"$f":"'1.Provider Details'!$J47","v":0},{"$f":"'1.Provider Details'!$J48","v":0},{"$f":"'1.Provider Details'!$J49","v":0},{"$f":"'1.Provider Details'!$J50","v":0},{"$f":"'1.Provider Details'!$J51","v":0},{"$f":"'1.Provider Details'!$J52","v":0},{"$f":"'1.Provider Details'!$J53","v":0},{"$f":"'1.Provider Details'!$J54","v":0},{"$f":"'1.Provider Details'!$J55","v":0},{"$f":"'1.Provider Details'!$J56","v":0},{"$f":"'1.Provider Details'!$J57","v":0},{"$f":"'1.Provider Details'!$J58","v":0},{"$f":"'1.Provider Details'!$J59","v":0},{"$f":"'1.Provider Details'!$J60","v":0},{"$f":"'1.Provider Details'!$J61","v":0},{"$f":"'1.Provider Details'!$J62","v":0},{"$f":"'1.Provider Details'!$J63","v":0},{"$f":"'1.Provider Details'!$J64","v":0},{"$f":"'1.Provider Details'!$J65","v":0},{"$f":"'1.Provider Details'!$J66","v":0},{"$f":"'1.Provider Details'!$J67","v":0},{"$f":"'1.Provider Details'!$J68","v":0},{"$f":"'1.Provider Details'!$J69","v":0},{"$f":"'1.Provider Details'!$J70","v":0},{"$f":"'1.Provider Details'!$J71","v":0},{"$f":"'1.Provider Details'!$J72","v":0},{"$f":"'1.Provider Details'!$J73","v":0},{"$f":"'1.Provider Details'!$J74","v":0},{"$f":"'1.Provider Details'!$J75","v":0},{"$f":"'1.Provider Details'!$J76","v":0},{"$f":"'1.Provider Details'!$J77","v":0},{"$f":"'1.Provider Details'!$J78","v":0},{"$f":"'1.Provider Details'!$J79","v":0},{"$f":"'1.Provider Details'!$J80","v":0},{"$f":"'1.Provider Details'!$J81","v":0},{"$f":"'1.Provider Details'!$J82","v":0},{"$f":"'1.Provider Details'!$J83","v":0},{"$f":"'1.Provider Details'!$J84","v":0},{"$f":"_xlfn.UNICHAR(9432) &   CHAR(10) &'Data Source'!B138","v":"ⓘ\nYear -2 (Actual)"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B139","v":"ⓘ\nYear -1 (Actual)"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B140","v":"ⓘ\nForecast Month 1"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B141","v":"ⓘ\nForecast Month 2"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B142","v":"ⓘ\nForecast Month 3"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B143","v":"ⓘ\nForecast Month 4"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B144","v":"ⓘ\nForecast Month 5"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B145","v":"ⓘ\nForecast Month 6"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B146","v":"ⓘ\nForecast Month 7"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B147","v":"ⓘ\nForecast Month 8"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B148","v":"ⓘ\nForecast Month 9"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B149","v":"ⓘ\nForecast Month 10"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B150","v":"ⓘ\nForecast Month 11"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B151","v":"ⓘ\nForecast Month 12"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B152","v":"ⓘ\nForecast Year 1"},{"$f":"_xlfn.UNICHAR(9432) & CHAR(10) &'Data Source'!B153","v":"ⓘ\nForecast Year 2"},"ⓘ\nYear -2 (Actual)","ⓘ\n Year -1 (Actual)","ⓘ Forecast Month 1","ⓘ Forecast Month 2","ⓘ Forecast Month 3","ⓘ Forecast Month 4","ⓘ Forecast Month 5","ⓘ Forecast Month 6","ⓘ Forecast Month 7","ⓘ Forecast Month 8","ⓘ Forecast Month 9","ⓘ Forecast Month 10","ⓘ Forecast Month 11","ⓘ Forecast Month 12","ⓘ Forecast Year 1","ⓘ Forecast Year 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17*BQ17","v":0},{"$f":"$D$17*BR17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17*BQ18","v":0},{"$f":"$D$17*BR18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17*BQ19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17*BQ20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17*BQ21","v":0},{"$f":"$D$17*BR21","v":0},{"$f":"$D$17*BS21","v":0},{"$f":"$D$17*BT21","v":0},{"$f":"$D$17*BU21","v":0},{"$f":"$D$17*BV21","v":0},{"$f":"$D$17*BW21","v":0},{"$f":"$D$17*BX21","v":0},{"$f":"$D$17*BY21","v":0},{"$f":"$D$17*BZ21","v":0},{"$f":"$D$17*CA21","v":0},{"$f":"$D$17*CB21","v":0},{"$f":"$D$17*CC21","v":0},{"$f":"$D$17*CD21","v":0},{"$f":"$D$17*CE21","v":0},{"$f":"$D$17*CF21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17*BQ85","v":0},{"$f":"$D$17*BR85","v":0},{"$f":"$D$17*BS85","v":0},{"$f":"$D$17*BT85","v":0},{"$f":"$D$17*BU85","v":0},{"$f":"$D$17*BV85","v":0},{"$f":"$D$17*BW85","v":0},{"$f":"$D$17*BX85","v":0},{"$f":"$D$17*BY85","v":0},{"$f":"$D$17*BZ85","v":0},{"$f":"$D$17*CA85","v":0},{"$f":"$D$17*CB85","v":0},{"$f":"$D$17*CC85","v":0},{"$f":"$D$17*CD85","v":0},{"$f":"$D$17*CE85","v":0},{"$f":"$D$17*CF85","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Students ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BQ17:BQ116)","v":0},{"$f":"SUM(BR17:BR116)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"7.Key Expenses","index":10,"n_rows":89,"n_cols":18,"rows_kept":89,"cut":false,"hidden":false,"merged":[[10,1,10,5],[51,1,51,4],[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[45,1,45,4],[44,1,44,4],[43,1,43,4],[42,1,42,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,4],[50,1,50,4],[11,4,11,15],[63,1,63,4],[52,1,52,4],[53,1,53,4],[54,1,54,4],[55,1,55,4],[56,1,56,4],[57,1,57,4],[58,1,58,4],[59,1,59,4],[60,1,60,4],[61,1,61,4],[62,1,62,4],[72,1,72,4],[73,1,73,4],[74,1,74,4],[75,1,75,4],[64,1,64,4],[65,1,65,4],[66,1,66,4],[67,1,67,4],[68,1,68,4],[69,1,69,4],[88,1,88,4],[35,1,35,7],[82,1,82,4],[83,1,83,4],[84,1,84,4],[85,1,85,4],[86,1,86,4],[87,1,87,4],[76,1,76,4],[77,1,77,4],[78,1,78,4],[79,1,79,4],[80,1,80,4],[81,1,81,4],[70,1,70,4],[71,1,71,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Key Expenses"]
[]
[null,"ⓘ Staff Numbers (FTE Basis)\nNote: One Full-time Equivalent (\"FTE\") is equivalent to a full-time worker. If you have one or more part-time workers during any period, you should count them as a decimal value representing their percentage of hours compared to a full-time worker. \n\nFor example: if, during a relevant period, the organisation has a worker who works 50% of the hours of a full-time worker and another who works 70% of the hours of a full-time worker, they would be counted as 0.5 and 0.7 respectively. These numbers should be added to the number of full-time workers during the period to get the total numbers of staff (FTE)."]
[null,null,null,null,"Forecast year one columns – contains forecast amounts for future months as well as actual amounts for any months in which trading has already occurred"]
[null,"Teaching staff",{"$f":"'Data Source'!B138","v":"Year -2 (Actual)"},{"$f":"'Data Source'!B139","v":"Year -1 (Actual)"},{"$f":"'Data Source'!B140","v":"Forecast Month 1"},{"$f":"'Data Source'!B141","v":"Forecast Month 2"},{"$f":"'Data Source'!B142","v":"Forecast Month 3"},{"$f":"'Data Source'!B143","v":"Forecast Month 4"},{"$f":"'Data Source'!B144","v":"Forecast Month 5"},{"$f":"'Data Source'!B145","v":"Forecast Month 6"},{"$f":"'Data Source'!B146","v":"Forecast Month 7"},{"$f":"'Data Source'!B147","v":"Forecast Month 8"},{"$f":"'Data Source'!B148","v":"Forecast Month 9"},{"$f":"'Data Source'!B149","v":"Forecast Month 10"},{"$f":"'Data Source'!B150","v":"Forecast Month 11"},{"$f":"'Data Source'!B151","v":"Forecast Month 12"},{"$f":"'Data Source'!B152","v":"Forecast Year 1"},{"$f":"'Data Source'!B153","v":"Forecast Year 2"}]
[null,"Permanent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P14","v":0}]
[null,"Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P15","v":0}]
[null,"Total Teaching",{"$f":"SUM(C14:C15)","v":0},{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q14:Q15)","v":0},0]
[null,"Non-teaching"]
[null,"Permanent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P18","v":0}]
[null,"Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P19","v":0}]
[null,"Total Non-teaching",{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q18:Q19)","v":0},0]
[null,"TOTAL",{"$f":"SUM(C16,C20)","v":0},{"$f":"SUM(D16,D20)","v":0},{"$f":"SUM(E16,E20)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q16,Q20)","v":0},0]
[]
[null,"ⓘ Staff Costs ($)"]
[]
[null,"Teaching staff",{"$f":"'Data Source'!B138","v":"Year -2 (Actual)"},{"$f":"'Data Source'!B139","v":"Year -1 (Actual)"},{"$f":"'Data Source'!B140","v":"Forecast Month 1"},{"$f":"'Data Source'!B141","v":"Forecast Month 2"},{"$f":"'Data Source'!B142","v":"Forecast Month 3"},{"$f":"'Data Source'!B143","v":"Forecast Month 4"},{"$f":"'Data Source'!B144","v":"Forecast Month 5"},{"$f":"'Data Source'!B145","v":"Forecast Month 6"},{"$f":"'Data Source'!B146","v":"Forecast Month 7"},{"$f":"'Data Source'!B147","v":"Forecast Month 8"},{"$f":"'Data Source'!B148","v":"Forecast Month 9"},{"$f":"'Data Source'!B149","v":"Forecast Month 10"},{"$f":"'Data Source'!B150","v":"Forecast Month 11"},{"$f":"'Data Source'!B151","v":"Forecast Month 12"},{"$f":"'Data Source'!B152","v":"Forecast Year 1"},{"$f":"'Data Source'!B153","v":"Forecast Year 2"}]
[null,"Permanent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:P26)","v":0}]
[null,"Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:P27)","v":0}]
[null,"Total Teaching",{"$f":"SUM(C26:C27)","v":0},{"$f":"SUM(D26:D27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q26:Q27)","v":0},0]
[null,"Non-teaching"]
[null,"Permanent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E30:P30)","v":0}]
[null,"Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E31:P31)","v":0}]
[null,"Total Non-teaching",{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q29:Q31)","v":0},0]
[null,"TOTAL",{"$f":"SUM(C28,C32)","v":0},{"$f":"SUM(D28,D32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q28,Q32)","v":0},0]
[]
[]
[null,"Premises Details"]
[]
[]
[null,"Location",null,null,null,"Type","Monthly Rental Cost","Lease End Date"]
[null,{"$f":"'1.Provider Details'!J35","v":0}]
[null,{"$f":"'1.Provider Details'!J36","v":0}]
[null,{"$f":"'1.Provider Details'!J37","v":0}]
[null,{"$f":"'1.Provider Details'!J38","v":0}]
[null,{"$f":"'1.Provider Details'!J39","v":0}]
[null,{"$f":"'1.Provider Details'!J40","v":0}]
[null,{"$f":"'1.Provider Details'!J41","v":0}]
[null,{"$f":"'1.Provider Details'!J42","v":0}]
[null,{"$f":"'1.Provider Details'!J43","v":0}]
[null,{"$f":"'1.Provider Details'!J44","v":0}]
[null,{"$f":"'1.Provider Details'!J45","v":0}]
[null,{"$f":"'1.Provider Details'!J46","v":0}]
[null,{"$f":"'1.Provider Details'!J47","v":0}]
[null,{"$f":"'1.Provider Details'!J48","v":0}]
[null,{"$f":"'1.Provider Details'!J49","v":0}]
[null,{"$f":"'1.Provider Details'!J50","v":0}]
[null,{"$f":"'1.Provider Details'!J51","v":0}]
[null,{"$f":"'1.Provider Details'!J52","v":0}]
[null,{"$f":"'1.Provider Details'!J53","v":0}]
[null,{"$f":"'1.Provider Details'!J54","v":0}]
[null,{"$f":"'1.Provider Details'!J55","v":0}]
[null,{"$f":"'1.Provider Details'!J56","v":0}]
[null,{"$f":"'1.Provider Details'!J57","v":0}]
[null,{"$f":"'1.Provider Details'!J58","v":0}]
[null,{"$f":"'1.Provider Details'!J59","v":0}]
[null,{"$f":"'1.Provider Details'!J60","v":0}]
[null,{"$f":"'1.Provider Details'!J61","v":0}]
[null,{"$f":"'1.Provider Details'!J62","v":0}]
[null,{"$f":"'1.Provider Details'!J63","v":0}]
[null,{"$f":"'1.Provider Details'!J64","v":0}]
[null,{"$f":"'1.Provider Details'!J65","v":0}]
[null,{"$f":"'1.Provider Details'!J66","v":0}]
[null,{"$f":"'1.Provider Details'!J67","v":0}]
[null,{"$f":"'1.Provider Details'!J68","v":0}]
[null,{"$f":"'1.Provider Details'!J69","v":0}]
[null,{"$f":"'1.Provider Details'!J70","v":0}]
[null,{"$f":"'1.Provider Details'!J71","v":0}]
[null,{"$f":"'1.Provider Details'!J72","v":0}]
[null,{"$f":"'1.Provider Details'!J73","v":0}]
[null,{"$f":"'1.Provider Details'!J74","v":0}]
[null,{"$f":"'1.Provider Details'!J75","v":0}]
[null,{"$f":"'1.Provider Details'!J76","v":0}]
[null,{"$f":"'1.Provider Details'!J77","v":0}]
[null,{"$f":"'1.Provider Details'!J78","v":0}]
[null,{"$f":"'1.Provider Details'!J79","v":0}]
[null,{"$f":"'1.Provider Details'!J80","v":0}]
[null,{"$f":"'1.Provider Details'!J81","v":0}]
[null,{"$f":"'1.Provider Details'!J82","v":0}]
[null,{"$f":"'1.Provider Details'!J83","v":0}]
[null,{"$f":"'1.Provider Details'!J84","v":0}]

{"sheet":"8. ASQA Review","index":11,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":true,"merged":[[58,3,58,7],[9,7,9,8],[10,7,10,8],[47,3,47,7],[46,3,46,7],[45,3,45,7],[44,3,44,7],[43,3,43,7],[42,3,42,7],[41,3,41,7],[21,3,21,7],[39,3,39,7],[40,3,40,7],[36,8,37,9],[48,3,48,7],[57,3,57,7],[51,3,51,7],[50,3,50,7],[49,3,49,7],[56,3,56,7],[55,3,55,7],[54,3,54,7],[53,3,53,7],[52,3,52,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - ASQA Review"]
[]
[]
[null,"Initial Assessment & Referral Review"]
[]
[null,8.1,null,"General"]
[null,null,"ⓘ","Have all required sections been completed?"]
[null,8.1999999999999993,null,"Documentation"]
[null,null,"Have the following items been submitted as part of the Application ? (If no, review explanation provided in Tab 1, Section 1.7 and follow up if necessary )"]
[null,null,"ⓘ","Nominated Accountant’s Certificate ?"]
[null,null,"ⓘ","Business Plan/Strategic Plan"]
[null,null,"ⓘ","Audited / financial statements"]
[null,null,"ⓘ","Current management accounts"]
[null,null,"ⓘ","Have bank statements (as at relevant dates) for all bank accounts been provided?"]
[null,null,"ⓘ","Bank reconciliations - as at most recent financial year end"]
[null,null,"ⓘ","Bank reconciliations - as at most recent month end"]
[null,null,"ⓘ","Has ATO Documentation been provided ?"]
[null,null,"ⓘ","Has the Aged Debtors Ledger been provided at relevant dates?"]
[null,null,"ⓘ","Has the Aged Creditors Ledger been provided at relevant dates?"]
[null,null,"ⓘ","Deed of guarantees or other legally enforceable instruments"]
[null,8.3000000000000007,null,"Other Information"]
[null,null,null,"Review Completed By"]
[null,null,null,"Date of Review"]
[null,null,null,"Final Decision"]
[null,null,null,"Comments"]
[]
[]
[]
[null,"Regulatory Operations Review",null,null,null,null,null,null,{"$f":"IF('Risk Calculations'!G51=Yes, \"Please note:- the “Yellow” rating is due to financial guarantees or additional available funding (refer Section 1.2 and/or 1.6 of Provider Details Tab).  This Provider would otherwise have rated “Red”.\", \"\")","v":""}]
[]
[null,8.4,null,"Review Items"]
[null,null,"ⓘ","Does the explanation of access to further funding provide adequate comfort to allow the assessment to continue?"]
[null,null,"ⓘ","Does the explanation of financial guarantees in place provide adequate comfort to allow the assessment to continue?"]
[null,null,"ⓘ","How well does the Business Plan align to information provided in this pack and other evidence? (overall assessment)"]
[null,null,"ⓘ","Are the financial forecasts consistent with and plausible based other information provided? (overall assessment)"]
[null,null,null,"Are student fees revenue reasonable and consistent with other information provided?"]
[null,null,null,"Are staff expenses reasonable and consistent with other information provided?"]
[null,null,null,"Are the learning and assessment resources, equipment and consumables costs reasonable and consistent with other information provided?"]
[null,null,null,"Are premises costs reasonable and consistent with other information provided?"]
[null,null,"ⓘ","Are the management / audited / financial accounts provided reasonable?"]
[null,null,null,"Are key reconciliations reasonable?"]
[null,null,"ⓘ","Do the aged debtors reports reconcile to accounts?"]
[null,null,"ⓘ","Do the aged creditors reports reconcile to accounts?"]
[null,null,"ⓘ","Do the bank reconciliations accurately reconcile bank statements with accounts?  Note: for ‘start-up’ entities, do bank statement(s) substantiate cash reserves?"]
[null,null,"ⓘ","Is the explanation of superannuation obligations reasonable?"]
[null,null,"ⓘ","Is the explanation of tax obligations reasonable?"]
[null,null,"ⓘ","Is the explanation of rent obligations reasonable?"]
[null,null,"ⓘ","Is the explanation of insurance obligations reasonable?"]
[null,null,"ⓘ","Is the explanation of unresolved legal disputes reasonable?"]
[null,null,"ⓘ","Is the explanation of contingent liabilities reasonable?"]
[null,null,null,"Is the information and data in this tool generally consistent with, and plausible in response to, the supporting evidence, including evidence gathered through the audit process?"]
[null,8.5,null,"Other Information"]
[null,null,null,"Review Completed By"]
[null,null,null,"Date of Review"]
[null,null,null,"Final Decision"]
[null,null,null,"Comments"]

{"sheet":"Risk Settings & Weightings","index":12,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[63,2,63,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Risk Settings & Weightings"]
[]
[]
[null,"Financial Viability Metrics"]
[]
[null,"Profit & Loss"]
[null,"Item","Name ","Purpose","Calculation","Unit","Limit Type (Low)","Low Risk (Green)","Medium Risk (Yellow)","High Risk (Red)","Weight Factor","Comments"]
[null,1,"Training revenue as % of total revenue","Indicates the proportion of total revenue generated from delivering training","Total Training Revenue / Total Revenue","Percentage","Higher",0.75,0.5,0.5,0.25]
[null,2,"% Government funded","Revenue concentration measure","Government sourced training revenue / Total Revenue","Percentage","Lower",0.5,0.75,0.75,1]
[null,3,"EBIT %","Provides an indication of the provider’s ability to manage revenues and control expenses in order to generate a surplus which can be used in the future to support the capacity of the provider to sustain its education operations","EBIT / Total Revenue","Percentage","Higher",0.05,0,0,2]
[null,4,"Interest coverage","Measures how easily the enterprise can pay interest on its outstanding debts.  The lower the ratio, the more the enterprise is burdened by debt expense","EBIT / Interest expense","Decimal","Higher",3,1,1,1,"When No Interest Expense outputs green result"]
[null,5,"Break-even (as % of total revenue)","Provides an indication of the proportion of total revenue required to meet the costs of operation","(Fixed costs / (Gross Profit / Total Revenue)) / Total Revenue","Percentage","Lower",0.8,1,1,1]
[null,6,"Employee costs as % of revenue","Provides an indication of the proportion of revenue required to cover the costs of employment","((Trainers & Assessors Salaries and Related Expenses including Superannuation + Management and Administrative Staff Salaries and Related Expenses including Superannuation) / Total Revenue)","Percentage","Lower",0.5,0.75,0.75,1]
[null,7,"Superannuation as % of employee costs","To provide an indication of the average rate of superannuation paid on employee costs","(Superannuation Expenses / Trainers & Assessors Salaries and Related Expenses excluding Superannuation + Management and Administrative Staff Salaries and Related Expenses excluding Superannuation)","Percentage",null,"Low Risk (Green) = 7-15%","Medium  Risk (Yellow) = 5-7% & 15-20%","High Risk (Red) = <5% & >20%",0.25,"2 Ranges may need additional line "]
[]
[null,"Balance Sheet"]
[null,"Item","Name ","Purpose","Calculation","Unit","Limit Type (Low)","Low Risk (Green)","Medium Risk (Yellow)","High Risk (Red)","Weight Factor","Comments"]
[null,8,"Liquidity Ratio","Provides an indication of the provider’s capacity to meet financial obligations within its ordinary operating cycle","Current assets (excluding related parties) / current liabilities (excluding related parties)","Decimal","Higher",1.5,1,1,2]
[null,9,"Debt to Equity (Gearing)","Indicates the relative proportion of equity and debt used to finance the enterprises assets.","Total liabilities (excluding related parties) / Total equity (treat related party loans as equity)","Decimal","Lower","0-1","1-1.25","< 0 or >1.25",1.5,"Red -If < 0 (ie result is negative) OR if >1.25\nYellow - Between 1 - 1.25\nGreen - Between 0 - 1 (including 0)"]
[null,10,"Debt Ratio","Measures how leveraged the enterprise is by comparing the level of debt relative to assets.  Provides an indication of the assets available to satisfy the providers financial obligations","Total liabilities (excluding related parties) / total assets (excluding related parties and any non-tangible assets such as goodwill)","Decimal","Lower",0.75,1,1,1]
[null,11,"Debtor Days","Measures how quickly cash is being collected from debtors. The longer it takes for an enterprise to collect, the greater the number of debtor days.","(Trade debtors / Total Revenue) x 365 days","Days","Lower",60,90,90,0.5]
[null,12,"Creditor Days","Measures how long the business is taking to pay creditors.  The longer it takes for the enterprise to pay, the greater number of creditor days.","(Trade creditors / total expenses, excluding all employee costs and superannuation costs) x 365 days","Days","Lower",60,90,90,0.5]
[]
[null,"Cash flow "]
[null,"Item","Name ","Purpose","Calculation","Unit","Limit Type (Low)","Low Risk (Green)","Medium Risk (Yellow)","High Risk (Red)","Weight Factor","Comments"]
[null,13,"Working Capital","To provide an indication of how long the organisation can fund operations (fixed costs) with current available cash","How many months of forecast fixed costs does the organisation hold in Cash & Cash equivalents at the beginning of forecast month 1 ","Months ","Higher",6,3,3,0.75,"Forecast Cash at Bank less total fixed costs (P & L Month 1) if >0 Subtract month 2 >0 Subtract month three etc. until 0 or less - metric is how many months have been covered?"]
[null,14,"Operating cash flow ratio","Measure of the number of times an organisation can pay off current debts with cash generated in the same time period","Operating cash flow / current liabilities (excluding related parties)","Times","Higher",2,1,1,1.25,"> 2 green <1 is high - No Application type weighting applied as based on forecasts only "]
[]
[null,"Non Financial Metrics"]
[]
[null,"Business Hygiene Statistics"]
[null,"Item","Name ","Purpose","Calculation","Unit","Limit Type (Low)","Low Risk (Green)","Medium Risk (Yellow)","High Risk (Red)","Weight Factor","Comments"]
[null,1,"Business plan","To assess whether the organisation has an adequate business plan","ASQA Assessor to determine","Good/Average/Poor","N/A","Good","Average","Poor",1.5,"Driven by question on line 42 (ASQA Review)"]
[null,2,"Financial forecasts","To assess whether the organisation has prepared reasonable financial forecasts","ASQA Assessor to determine","Good/Average/Poor","N/A","Good","Average","Poor",1.5,"Driven by question on line 43 (ASQA Review)"]
[null,3,"Management / Audited / Financial Accounts","To assess whether adequate management information systems are in place","ASQA Assessor to determine","Yes/No","N/A","Yes","N/A","No",1,"Driven by question on line 48 (ASQA Review)"]
[null,4,"Key reconciliations (Debtors / Creditors / Bank)","To assess whether adequate management information systems are in place","ASQA Assessor to determine","Yes/No","N/A","Yes","N/A","No",1,"Driven by question on line 49 (ASQA Review)"]
[null,5,"Aged Debtors","To assess debt collection practices","Per aged debtors schedules ","Percentage","Higher",0.8,0.6,0.6,1,"Uses < 60 Days Percentage"]
[null,6,"Aged Creditors","To assess the organisation's ability to pay debts as and when they fall due","Per aged creditors schedules","Percentage","Higher",0.8,0.6,0.6,1.5,"Uses < 60 Days Percentage"]
[null,7,"Protection of student pre-paid fees","To assess whether students prepaid funds are / will be protected","Provider statement per Section 1.5 on Provider Details","Yes/No","N/A","Yes","N/A","No",1,"Driven by question on line 85 (Provider Details)"]
[null,8,"Super obligations up to date","To assess whether the organisation is meeting superannuation obligations","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","Yes/No","N/A","Yes","N/A","No",1,"Driven by question on line 92 (Provider Details) and by question on line 53 (ASQA Review)"]
[null,9,"Tax obligations up to date","To assess whether the organisation is meeting tax obligations","Provider statement per Section 1.6 on Provider Details","Yes/No","N/A","Tax Obligaion up to date - Yes","Tax Obligaion up to date - No\nRepayment Plan - Yes","Tax Obligaion up to date - No\nRepayment Plan - No",1.5,"Driven by questions on lines 94 and 97 (Provider Details)"]
[null,10,"Rent obligations up to date","To assess whether the organisation is meeting rent obligations","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","Yes/No","N/A","Yes","N/A","No",0.5,"Driven by question on line 99 (Provider Details) and by question on line 55 (ASQA Review)"]
[null,11,"Accrual accounting","To check against standard accounting practice","Provider statement per Section 1.6 on Provider Details","Yes/No","N/A","Yes","N/A","No",0.5,"Driven by question on line 101 (Provider Details)"]
[null,12,"Current insurance","To assess whether the organisation has adequate insurance coverage","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","Yes/No","N/A","Yes","N/A","No",0.5,"Driven by question on line 102 (Provider Details) and by question on line 56 (ASQA Review)"]
[null,13,"Unresolved legal disputes","To assess the impact that any unresolved legal disputes may have on the ongoing viability of the entity","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","Yes/No","N/A","Yes","N/A","No",0.75,"Driven by question on line 104 (Provider Details) and by question on line 57 (ASQA Review)"]
[null,14,"Contingent liabilities","To assess the impact that any contingent liabilities may have on the ongoing viability of the entity","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","Yes/No","N/A","Yes","N/A","No",0.75,"Driven by question on line 106 (Provider Details) and by question on line 58 (ASQA Review)"]
[]
[null,"Overall"]
[]
[null,"Business Hygiene Statistics"]
[null,"Category Score Split"]
[null,"Category","Min","Max"]
[null,"Red",1,1.667]
[null,"Yellow",1.667,2.3330000000000002]
[null,"Green",2.3330000000000002,3]
[null,"Grey",10]
[]
[null,"Provider Weighting Split"]
[null,"Provider Type","Provider Result (Actual Last Year)","Provider Result (Forecast Year 1)","Weighting (Actual Last Year)","Weighting (Forecast Year 1)"]
[null,"New Registration (start-up)","N/A","Result",0,1]
[null,"New Registration (existing business)","Result","Result",0.5,0.5]
[null,"Monitoring","Result","Result",0.8,0.2]
[]
[]
[null,"Question Range"]
[]
[null,"Category","Min"]
[null,"Red",1]
[null,"Yellow",2]
[null,"Green",3]

{"sheet":"Grey Rating Calculation","index":13,"n_rows":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":true,"merged":[[66,2,66,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Grey Rating Check"]
[null,null,null,"Original VBA intact?:",{"$f":"testMacrosAvailable()","v":{"$error":"#NAME?"}}]
[null,"Overall Check's - Applicant",null,"error message:",{"$f":"IF(E10=TRUE, \"\", \"The Financial Viability Risk Assessment tool is a \"\".xlsm\"\" file and must only be saved as a \"\".xlsm\"\" filetype. The current file either is not a \"\".xlsm\"\" file or has previously, at some point, been saved as a filetype other than \"\".xlsm\"\"\" & \". Please download a new copy of the Financial Viability Risk Assessment tool from www.asqa.gov.au and complete that file instead.\")","v":{"$error":"#NAME?"}}]
[]
[null,"Number","Name ","Result","Error Message"]
[null,1,"Application Type Check",{"$f":"IF(OR(ISBLANK(App_Type), App_Type = \"-- Select --\"), 1, 0)","v":1},{"$f":"IF(D14=0, \"\", \"You must enter an 'Application Type' at section 1.1 'Background' of tab '1.Provider Details'\")","v":"You must enter an 'Application Type' at section 1.1 'Background' of tab '1.Provider Details'"}]
[null,2,"Non Financial Metrics",{"$f":"IF(SUM(D22:D29)>0, 1, 0)","v":1}]
[null,3,"Financial Values",{"$f":"IF(SUM(F34:F41)>0, 1, 0)","v":1}]
[null,4,"Balance Sheet Balance",{"$f":"D46","v":0},{"$f":"IF(D17=0, \"\", \"You must ensure \"\"NET ASSETS/(LIABILITIES)\"\" equals \"\"TOTAL EQUITY\"\" for each period on tab '3.Balance Sheet'\")","v":""}]
[]
[null,"Check 2 Non-Financial Metrics"]
[]
[null,"Metric","Name ","Result"]
[null,1,"Metric 7 - prepaid fees",{"$f":"IF(ISBLANK('1.Provider Details'!J86), 1, 0)","v":1},{"$f":"IF(D22=0, \"\", \"You must specify, at section 1.5 'Pre-paid fees' of tab '1.Provider Details', whether your organisation will collect more than $1500 of fees in advance from domestic students\")","v":"You must specify, at section 1.5 'Pre-paid fees' of tab '1.Provider Details', whether your organisation will collect more than $1500 of fees in advance from domestic students"}]
[null,2,"Metric 8 - Super",{"$f":"IF('Section Checks & Step 1 Calcs '!D12 = 1, 0, IF(ISBLANK('1.Provider Details'!J93), 1, 0))","v":1},{"$f":"IF(D23=0, \"\", \"You must specify, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether all superannuation payments are up to date\")","v":"You must specify, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether all superannuation payments are up to date"}]
[null,3,"Metric 9 - Tax",{"$f":"IF('Section Checks & Step 1 Calcs '!D12 = 1, 0,IF(ISBLANK('1.Provider Details'!J95), 1, 0))","v":1},{"$f":"IF(D24=0, \"\", \"You must specify, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether all tax (PAYG and GST) obligations up to date\")","v":"You must specify, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether all tax (PAYG and GST) obligations up to date"}]
[null,4,"Metric 10 - Rent",{"$f":"IF('Section Checks & Step 1 Calcs '!D12 = 1, 0,IF(ISBLANK('1.Provider Details'!J100), 1, 0))","v":1},{"$f":"IF(D25=0, \"\", \"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether all rent obligations are up to date\")","v":"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether all rent obligations are up to date"}]
[null,5,"Metric 11 - Accrual Accounting",{"$f":"IF(ISBLANK('1.Provider Details'!J102), 1, 0)","v":1},{"$f":"IF(D26=0, \"\", \"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether your entity uses an accrual basis of accounting\")","v":"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether your entity uses an accrual basis of accounting"}]
[null,6,"Metric 12 - Insurance",{"$f":"IF(ISBLANK('1.Provider Details'!J103), 1, 0)","v":1},{"$f":"IF(D27=0, \"\", \"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether you have (or will have) adequate insurance cover, including Public Liability Insurance and WorkCover\")","v":"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether you have (or will have) adequate insurance cover, including Public Liability Insurance and WorkCover"}]
[null,7,"Metric 13 - Legal Disputes",{"$f":"IF('Section Checks & Step 1 Calcs '!D12 = 1, 0,IF(ISBLANK('1.Provider Details'!J105), 1, 0))","v":1},{"$f":"IF(D28=0, \"\", \"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether there are any unresolved legal disputes or litigation against your entity\")","v":"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether there are any unresolved legal disputes or litigation against your entity"}]
[null,8,"Metric 14 - Contingent liabilities",{"$f":"IF('Section Checks & Step 1 Calcs '!D12 = 1, 0,IF(ISBLANK('1.Provider Details'!J107), 1, 0))","v":1},{"$f":"IF(D29=0, \"\", \"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether there are any contingent liabilities in existence\")","v":"You must indicate, at section 1.6 'Statutory liabilities, other key creditors & Other' of tab '1.Provider Details', whether there are any contingent liabilities in existence"}]
[]
[null,"Check 3 Financial Values"]
[]
[null,"Metric","Name","Result - Existing","Result Startup","Overall Result"]
[null,"Profit & Loss - 3.1","Total Revenue",{"$f":"IF(SUM('2.Profit & Loss'!$U$29, '2.Profit & Loss'!$H$29)=0, 1, 0)","v":1},{"$f":"IF(SUM('2.Profit & Loss'!$U$29, '2.Profit & Loss'!$H$29)=0, 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12 = 1, 'Grey Rating Calculation'!E34, 'Grey Rating Calculation'!D34)","v":1},{"$f":"IF(D14=0, \"\", \"You must enter amounts for \"\"REVENUE\"\" on tab '2.Profit & Loss'\")","v":"You must enter amounts for \"REVENUE\" on tab '2.Profit & Loss'"}]
[null,"Profit & Loss - 3.2","Total Employee Costs including Super",{"$f":"IF(SUM('2.Profit & Loss'!U44:U47, '2.Profit & Loss'!U33:U34)=0, 1, 0)","v":1},{"$f":"IF(SUM('2.Profit & Loss'!U44:U47, '2.Profit & Loss'!U33:U34)=0, 1, 0)","v":1},{"$f":"N(\"The formula:## IF('Section Checks & Step 1 Calcs '!$D$12 = 1, 'Grey Rating Calculation'!E35, 'Grey Rating Calculation'!D35)## was removed on 25 September 2019 so that applicants or providers relying on contract workers only are not caught by this check.\")","v":0},{"$f":"IF(D14=0, \"\", \"You must enter employee expenses under \"\"Expenses\"\" on tab '2.Profit & Loss'\")","v":"You must enter employee expenses under \"Expenses\" on tab '2.Profit & Loss'"}]
[null,"Profit & Loss - 3.3","Total Employee Costs excluding Super",{"$f":"IF(SUM('2.Profit & Loss'!U33,'2.Profit & Loss'!U44,'2.Profit & Loss'!U46)=0, 1, 0)","v":1},{"$f":"IF(SUM('2.Profit & Loss'!U33,'2.Profit & Loss'!U44,'2.Profit & Loss'!U46)=0, 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12 = 1, 'Grey Rating Calculation'!E36, 'Grey Rating Calculation'!D36)","v":1},{"$f":"IF(D14=0, \"\", \"You must enter employee expenses under \"\"Expenses\"\" on tab '2.Profit & Loss'\")","v":"You must enter employee expenses under \"Expenses\" on tab '2.Profit & Loss'"}]
[null,"Profit & Loss - 3.4","Fixed Costs",{"$f":"IF(OR('2.Profit & Loss'!$U$54=0, '2.Profit & Loss'!$H$54=0), 1, 0)","v":1},{"$f":"IF('2.Profit & Loss'!$U$54=0, 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12 = 1, 'Grey Rating Calculation'!E37, 'Grey Rating Calculation'!D37)","v":1},{"$f":"IF(D14=0, \"\", \"You must enter amounts under \"\"Expenses\"\">\"\"Fixed costs\"\" on tab '2.Profit & Loss'\")","v":"You must enter amounts under \"Expenses\">\"Fixed costs\" on tab '2.Profit & Loss'"}]
[null,"Balance Sheet - 3.5","Current Assets",{"$f":"IF(OR('3.Balance Sheet'!I21=0, '3.Balance Sheet'!V21=0), 1, 0)","v":1},{"$f":"IF('3.Balance Sheet'!V21=0, 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12 = 1, 'Grey Rating Calculation'!E38, 'Grey Rating Calculation'!D38)","v":1},{"$f":"IF(D14=0, \"\", \"You must enter amounts for \"\"Current Assets\"\" on tab \"\"3. Balance Sheet\"\"\")","v":"You must enter amounts for \"Current Assets\" on tab \"3. Balance Sheet\""}]
[null,"Balance Sheet - 3.6","Current Liabilities",{"$f":"IF(OR('3.Balance Sheet'!I47=0, '3.Balance Sheet'!V47=0), 1, 0)","v":1},{"$f":"IF('3.Balance Sheet'!V47=0, 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12 = 1, 'Grey Rating Calculation'!E39, 'Grey Rating Calculation'!D39)","v":1},{"$f":"IF(D14=0, \"\", \"You must enter amounts for \"\"Current Liabilities\"\" on tab \"\"3. Balance Sheet\"\"\")","v":"You must enter amounts for \"Current Liabilities\" on tab \"3. Balance Sheet\""}]
[null,"Balance Sheet - 3.7","Total Equity",{"$f":"IF(OR('3.Balance Sheet'!I67=0, '3.Balance Sheet'!V67=0), 1, 0)","v":1},{"$f":"IF('3.Balance Sheet'!V67=0, 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12 = 1, 'Grey Rating Calculation'!E40, 'Grey Rating Calculation'!D40)","v":1},{"$f":"IF(D14=0, \"\", \"You must enter amounts for \"\"Equity\"\" on tab \"\"4.Cashflow\"\"\")","v":"You must enter amounts for \"Equity\" on tab \"4.Cashflow\""}]
[null,"Cashflow - 3.8","Operating Cashflow",{"$f":"IF(OR(AND('4.Cashflow '!I19=0, Accrual_Accounting<>\"No\"), AND('4.Cashflow '!V19=0, Accrual_Accounting<>\"No\")), 1, 0)","v":1},{"$f":"IF(AND('4.Cashflow '!V19=0, Accrual_Accounting<>\"No\"), 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12 = 1, 'Grey Rating Calculation'!E41, 'Grey Rating Calculation'!D41)","v":1},{"$f":"IF(D14=0, \"\", \"You must enter amounts for \"\"CASH FLOWS FROM OPERATING ACTIVITIES\"\" on tab \"\"4.Cashflow\"\"\")","v":"You must enter amounts for \"CASH FLOWS FROM OPERATING ACTIVITIES\" on tab \"4.Cashflow\""}]
[]
[null,"Check 4 - Balance Sheet Balance"]
[]
[null,"Number","Name ","Result - Existing"]
[null,1,"Columns Out of Balance",{"$f":"COUNTIF('3.Balance Sheet'!H10:$W$10, \"Out of Balance\")","v":0}]
[]
[]
[null,"Overall Check's - Regulatory Opps Review"]
[]
[null,"Item","Name ","Result - Existing","Result Startup","Overall Result"]
[null,1,"Business plan",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J42), '8. ASQA Review'!J42= \"-- Select --\"), 1, 0)","v":1},{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J42), '8. ASQA Review'!J42= \"-- Select --\"), 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E52, 'Grey Rating Calculation'!D52)","v":1}]
[null,2,"Financial forecasts",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J43), '8. ASQA Review'!J43= \"-- Select --\"), 1, 0)","v":1},{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J43), '8. ASQA Review'!J43= \"-- Select --\"), 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E53, 'Grey Rating Calculation'!D53)","v":1}]
[null,3,"Management / Audited / Financial Accounts",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J48), '8. ASQA Review'!J48= \"-- Select --\"), 1, 0)","v":1},0,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E54, 'Grey Rating Calculation'!D54)","v":1}]
[null,4,"Key reconciliations (Debtors / Creditors / Bank)",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J49), '8. ASQA Review'!J49= \"-- Select --\"), 1, 0)","v":1},{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J49), '8. ASQA Review'!J49= \"-- Select --\"), 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E55, 'Grey Rating Calculation'!D55)","v":1}]
[null,7,"Protection of student pre-paid fees",{"$f":"IF(OR(ISBLANK('1.Provider Details'!J86), '1.Provider Details'!J86= \"-- Select --\"), 1, 0)","v":1},{"$f":"IF(OR(ISBLANK('1.Provider Details'!J86), '1.Provider Details'!J86= \"-- Select --\"), 1, 0)","v":1},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E56, 'Grey Rating Calculation'!D56)","v":1}]
[null,8,"Super obligations up to date",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J53), '8. ASQA Review'!J53= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D15","v":0},0,{"$f":"IF(D23=1, 1, IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E57, 'Grey Rating Calculation'!D57))","v":1}]
[null,9,"Tax obligations up to date",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J54), '8. ASQA Review'!J54= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D16","v":0},0,{"$f":"IF(D24=1, 1, IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E58, 'Grey Rating Calculation'!D58))","v":1}]
[null,10,"Rent obligations up to date",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J55), '8. ASQA Review'!J55= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D21","v":0},0,{"$f":"IF(D25=1, 1, IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E59, 'Grey Rating Calculation'!D59))","v":1}]
[null,11,"Accrual accounting",{"$f":"IF(ISBLANK('1.Provider Details'!J102), 1, 0)","v":1},{"$f":"IF(ISBLANK('1.Provider Details'!J102), 1, 0)","v":1},{"$f":"IF(D26=1, 1, IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E60, 'Grey Rating Calculation'!D60))","v":1}]
[null,12,"Current insurance",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J56), '8. ASQA Review'!J56= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D22","v":0},{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J56), '8. ASQA Review'!J56= \"-- Select --\", ISBLANK('1.Provider Details'!J103), '1.Provider Details'!J103= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D22","v":0},{"$f":"IF(D27=1, 1, IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E61, 'Grey Rating Calculation'!D61))","v":1}]
[null,13,"Unresolved legal disputes",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J57), '8. ASQA Review'!J57= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D18","v":0},0,{"$f":"IF(D28=1, 1, IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E62, 'Grey Rating Calculation'!D62))","v":1}]
[null,14,"Contingent liabilities",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J58), '8. ASQA Review'!J58= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D19","v":0},0,{"$f":"IF(D29=1, 1, IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E63, 'Grey Rating Calculation'!D63))","v":1}]
[null,"Q 1  - RO Review","Further Funding",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J40), '8. ASQA Review'!J40= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D20","v":0},{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J40), '8. ASQA Review'!J40= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D20","v":0},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E64, 'Grey Rating Calculation'!D64)","v":0}]
[null,"Q 2 - RO Review","Guarantees",{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J41), '8. ASQA Review'!J41= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D14","v":0},{"$f":"IF(OR(ISBLANK('8. ASQA Review'!J41), '8. ASQA Review'!J41= \"-- Select --\"), 1, 0) * 'Section Checks & Step 1 Calcs '!D14","v":0},{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 'Grey Rating Calculation'!E65, 'Grey Rating Calculation'!D65)","v":0}]
[null,null,null,null,"Total Outstanding",{"$f":"SUM(F52:F65)","v":12}]
[null,null,"Substantiated by evidence:",null,null,{"$f":"IF('8. ASQA Review'!J59=\"\", \"\", '8. ASQA Review'!J59)","v":""}]
[null,"Metric","Name "]
[null,"Text on Output",{"$f":"IF('Section Checks & Step 1 Calcs '!D23=0, \"Ignore current rating, not yet assessed.\", IF(OR(F66>0, F67=\"\"), \"Not Yet Assessed\", IF( F67=\"No\", \"FVRA Tool not substantiated by evidence\", \"\")))","v":"Ignore current rating, not yet assessed."}]
[null,"Updated Score",{"$f":"IF(OR(F66>0, F67=\"\"), 10, IF(F67=\"No\", 1, 'Risk Calculations'!O32))","v":10}]
[]
[null,"Combined Error Message"]
[null,{"$f":"IF(E11<>\"\", CHAR(42)&CHAR(32)&E11&CHAR(10)&CHAR(13), \"\") &\nIF(E14<>\"\", CHAR(42)&CHAR(32)&E14&CHAR(10)&CHAR(13), \"\") &\nIF(E22<>\"\", CHAR(42)&CHAR(32)&E22&CHAR(10)&CHAR(13), \"\") &\nIF(E23<>\"\", CHAR(42)&CHAR(32)&E23&CHAR(10)&CHAR(13), \"\") &\nIF(E24<>\"\", CHAR(42)&CHAR(32)&E24&CHAR(10)&CHAR(13), \"\") &\nIF(E25<>\"\", CHAR(42)&CHAR(32)&E25&CHAR(10)&CHAR(13), \"\") &\nIF(E26<>\"\", CHAR(42)&CHAR(32)&E26&CHAR(10)&CHAR(13), \"\") &\nIF(E27<>\"\", CHAR(42)&CHAR(32)&E27&CHAR(10)&CHAR(13), \"\") &\nIF(E28<>\"\", CHAR(42)&CHAR(32)&E28&CHAR(10)&CHAR(13), \"\") &\nIF(E29<>\"\", CHAR(42)&CHAR(32)&E29&CHAR(10)&CHAR(13), \"\") &\nIF(G34<>\"\", CHAR(42)&CHAR(32)&G34&CHAR(10)&CHAR(13), \"\") &\nIF(G35<>\"\", CHAR(42)&CHAR(32)&G35&CHAR(10)&CHAR(13), \"\") &\nIF(G36<>\"\", CHAR(42)&CHAR(32)&G36&CHAR(10)&CHAR(13), \"\") &\nIF(G37<>\"\", CHAR(42)&CHAR(32)&G37&CHAR(10)&CHAR(13), \"\") &\nIF(G38<>\"\", CHAR(42)&CHAR(32)&G38&CHAR(10)&CHAR(13), \"\") &\nIF(G39<>\"\", CHAR(42)&CHAR(32)&G39&CHAR(10)&CHAR(13), \"\") &\nIF(E17<>\"\", CHAR(42)&CHAR(32)&E17&CHAR(10)&CHAR(13), \"\") &\nIF(G40<>\"\", CHAR(42)&CHAR(32)&G40&CHAR(10)&CHAR(13), \"\") &\nIF(G41<>\"\", CHAR(42)&CHAR(32)&G41&CHAR(10)&CHAR(13), \"\")","v":{"$error":"#NAME?"}}]

{"sheet":"Section Checks & Step 1 Calcs ","index":14,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":true,"merged":[[53,2,53,3],[60,2,60,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Section  Checks"]
[]
[null,"Item","Name ","Check"]
[null,1,"Start-up Check",{"$f":"IF('1.Provider Details'!J13='Data Source'!$B$12, 1,0)","v":0}]
[null,2,"Group Structure Check",{"$f":"IF('1.Provider Details'!J20=Yes, 1,0)","v":0}]
[null,3,"Financial Guarantee Check",{"$f":"IF('1.Provider Details'!J22=Yes, 1,0)","v":0}]
[null,4,"Super Check",{"$f":"IF('1.Provider Details'!J93=No, 1, 0)","v":0}]
[null,5,"Tax Check",{"$f":"IF('1.Provider Details'!J95=No, 1, 0)","v":0}]
[null,6,"ATO Check",{"$f":"IF('1.Provider Details'!J98=No, 1, 0)","v":1}]
[null,7,"Legal Check",{"$f":"IF('1.Provider Details'!J105=Yes, 1,0)","v":0}]
[null,8,"Liability Check",{"$f":"IF('1.Provider Details'!J107=Yes, 1,0)","v":0}]
[null,9,"Funding Check",{"$f":"IF('1.Provider Details'!J109=Yes, 1,0)","v":0}]
[null,10,"Rent Check",{"$f":"IF('1.Provider Details'!J100=No, 1,0)","v":0}]
[null,11,"Insurance Check",{"$f":"IF('1.Provider Details'!J103=No, 1,0)","v":0}]
[null,12,"Team 1/2 Check",0]
[null,13,"Balance Sheet Check",{"$f":"IF(ISBLANK('3.Balance Sheet'!$H$10:$W$10),0,1)","v":1}]
[]
[null,"Protection Mechanism Check"]
[null,"Question Required ?",{"$f":"'1.Provider Details'!J86","v":0}]
[null,{"$f":"'Data Source'!B35","v":"Option 1 – Policy"},false]
[null,{"$f":"'Data Source'!B36","v":"Option 2 – Financial Guarantee"},false]
[null,{"$f":"'Data Source'!B37","v":"Option 3 – Tuition Assurance Scheme"},false]
[null,{"$f":"'Data Source'!B38","v":"Option 4 - Other"},false]
[]
[null,"Forecast Month","Running Monthly Cost"]
[null,"Month 1",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:I$54)","v":0}]
[null,"Month 2",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:J$54)","v":0}]
[null,"Month 3",{"$f":" '4.Cashflow '!J41-SUM('2.Profit & Loss'!$I54:K$54)","v":0}]
[null,"Month 4",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:L$54)","v":0}]
[null,"Month 5",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:M$54)","v":0}]
[null,"Month 6",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:N$54)","v":0}]
[null,"Month 7",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:O$54)","v":0}]
[null,"Month 8",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:P$54)","v":0}]
[null,"Month 9",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:Q$54)","v":0}]
[null,"Month 10",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:R$54)","v":0}]
[null,"Month 11",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:S$54)","v":0}]
[null,"Month 12",{"$f":"'4.Cashflow '!J41-SUM('2.Profit & Loss'!$I$54:T$54)","v":0}]
[null,"Number of Months Covered",{"$f":"COUNTIF(C34:C45, \">=0\")","v":12}]
[]
[null,"Debtor Type","% Last financial year end","Last monthly management accounts"]
[null,"Current",{"$f":"IFERROR('5.Bank, Debtors & Creditors'!$D$31/'5.Bank, Debtors & Creditors'!$H$31, 0)","v":0},{"$f":"IFERROR('5.Bank, Debtors & Creditors'!D$32/'5.Bank, Debtors & Creditors'!$H$32, 0)","v":0},">90 days"]
[null,"30 days",{"$f":"IFERROR('5.Bank, Debtors & Creditors'!E$31/'5.Bank, Debtors & Creditors'!$H$31, 0)","v":0},{"$f":"IFERROR('5.Bank, Debtors & Creditors'!E$32/'5.Bank, Debtors & Creditors'!$H$32, 0)","v":0}]
[null,"60 days",{"$f":"IFERROR('5.Bank, Debtors & Creditors'!F$31/'5.Bank, Debtors & Creditors'!$H$31, 0)","v":0},{"$f":"IFERROR('5.Bank, Debtors & Creditors'!F$32/'5.Bank, Debtors & Creditors'!$H$32, 0)","v":0}]
[null,">90 days",{"$f":"IFERROR('5.Bank, Debtors & Creditors'!G$31/'5.Bank, Debtors & Creditors'!$H$31, 0)","v":0},{"$f":"IFERROR('5.Bank, Debtors & Creditors'!G$32/'5.Bank, Debtors & Creditors'!$H$32, 0)","v":0}]
[null,"Total",{"$f":"SUM(C49:C52)","v":0},{"$f":"SUM(D49:D52)","v":0}]
[null,"Blank Cells ?",{"$f":"IF(COUNTBLANK('5.Bank, Debtors & Creditors'!D31:G32) = 8, Yes, No)","v":"Yes"}]
[null,"Creditor Type","% Last financial year end","Last monthly management accounts"]
[null,"Current",{"$f":"IFERROR('5.Bank, Debtors & Creditors'!$D$36/'5.Bank, Debtors & Creditors'!$H$36, 0)","v":0},{"$f":"IFERROR('5.Bank, Debtors & Creditors'!D$37/'5.Bank, Debtors & Creditors'!$H$37, 0)","v":0}]
[null,"30 days",{"$f":"IFERROR('5.Bank, Debtors & Creditors'!E$36/'5.Bank, Debtors & Creditors'!$H$36, 0)","v":0},{"$f":"IFERROR('5.Bank, Debtors & Creditors'!E$37/'5.Bank, Debtors & Creditors'!$H$37, 0)","v":0}]
[null,"60 days",{"$f":"IFERROR('5.Bank, Debtors & Creditors'!F$36/'5.Bank, Debtors & Creditors'!$H$36, 0)","v":0},{"$f":"IFERROR('5.Bank, Debtors & Creditors'!F$37/'5.Bank, Debtors & Creditors'!$H$37, 0)","v":0}]
[null,">90 days",{"$f":"IFERROR('5.Bank, Debtors & Creditors'!G$36/'5.Bank, Debtors & Creditors'!$H$36, 0)","v":0},{"$f":"IFERROR('5.Bank, Debtors & Creditors'!G$37/'5.Bank, Debtors & Creditors'!$H$37, 0)","v":0}]
[null,"Total",{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0}]
[null,"Blank Cells ?",{"$f":"IF(COUNTBLANK('5.Bank, Debtors & Creditors'!D36:G37) = 8, Yes, No)","v":"Yes"}]

{"sheet":"Risk Calculations","index":15,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":true,"merged":[[31,2,44,2],[13,2,19,2],[20,2,24,2],[25,2,26,2],[29,5,29,7],[29,8,29,10],[44,15,44,16],[43,15,43,16],[42,15,42,16],[41,15,41,16],[40,15,40,16],[39,15,39,16],[38,15,38,16],[37,15,37,16],[36,15,36,16],[11,5,11,7],[11,8,11,10],[13,15,26,15],[50,5,51,5],[50,6,51,6],[50,7,51,7],[50,8,51,8],[35,15,35,16],[34,15,34,16],[33,15,33,16],[32,15,32,16],[31,15,31,16],[13,12,26,12],[13,14,26,14],[31,12,44,12],[31,14,44,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Risk Calculation"]
[]
[null,"Financial Viability Metrics"]
[null,null,null,null,null,"Actual Last Year",null,null,"Forecast Year 1"]
[null,"Item","Area ","Name ","Calculation","Provider Result","Score","Weighted Score","Provider Result","Score","Weighted Score","Blended Score","Standard Weighting","Weighted Score","Risk Rating","Decision","Comments"]
[null,1,"P & L",{"$f":"'Risk Settings & Weightings'!C16","v":"Training revenue as % of total revenue"},"Total Training Revenue / Total Revenue",{"$f":"IFERROR('2.Profit & Loss'!H22/'2.Profit & Loss'!$H$29,0)","v":0},{"$f":"IF(F14>='Risk Settings & Weightings'!H16,Green,IF(F14>='Risk Settings & Weightings'!I16,Yellow,IF(F14<'Risk Settings & Weightings'!J16,Red,0)))","v":1},{"$f":"G14*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR('2.Profit & Loss'!U22/'2.Profit & Loss'!$U$29,0)","v":0},{"$f":"IF(I14>='Risk Settings & Weightings'!H16,Green,IF(I14>='Risk Settings & Weightings'!I16,Yellow,IF(I14<'Risk Settings & Weightings'!J16,Red,0)))","v":1},{"$f":"J14*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},{"$f":"SUM(H14,K14)","v":0},{"$f":"1/COUNT(B14:B27)","v":7.1428571428571425E-2},{"$f":"L14*$M$14*'Risk Settings & Weightings'!K16","v":0},{"$f":"SUM(N14:N27)","v":0.1607142857142857},{"$f":"IF(O14>='Risk Settings & Weightings'!C62, \"Submit Application\", \"Do Not Submit Application\")","v":"Do Not Submit Application"}]
[null,2,null,{"$f":"'Risk Settings & Weightings'!C17","v":"% Government funded"},"Government sourced training revenue / Total Revenue",{"$f":"IFERROR(('2.Profit & Loss'!H14+'2.Profit & Loss'!H15)/'2.Profit & Loss'!$H$29,0)","v":0},{"$f":"IF(F15<='Risk Settings & Weightings'!H17,Green,IF(F15<='Risk Settings & Weightings'!I17,Yellow,IF(F15>'Risk Settings & Weightings'!J17,Red,0)))","v":3},{"$f":"G15*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(('2.Profit & Loss'!U14+'2.Profit & Loss'!U15)/'2.Profit & Loss'!$U$29,0)","v":0},{"$f":"IF(I15<='Risk Settings & Weightings'!H17,Green,IF(I15<='Risk Settings & Weightings'!I17,Yellow,IF(I15>'Risk Settings & Weightings'!J17,Red,0)))","v":3},{"$f":"J15*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},{"$f":"SUM(H15,K15)","v":0},null,{"$f":"L15*$M$14*'Risk Settings & Weightings'!K17","v":0}]
[null,3,null,{"$f":"'Risk Settings & Weightings'!C18","v":"EBIT %"},"EBIT / Total Revenue",{"$f":"IFERROR('2.Profit & Loss'!H57/'2.Profit & Loss'!$H$29,0)","v":0},{"$f":"IF(F16>='Risk Settings & Weightings'!H18,Green,IF(F16>='Risk Settings & Weightings'!I18,Yellow,IF(F16<'Risk Settings & Weightings'!J18,Red,0)))","v":2},{"$f":"G16*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR('2.Profit & Loss'!U57/'2.Profit & Loss'!$U$29,0)","v":0},{"$f":"IF(I16>='Risk Settings & Weightings'!H18,Green,IF(I16>='Risk Settings & Weightings'!I18,Yellow,IF(I16<'Risk Settings & Weightings'!J18,Red,0)))","v":2},{"$f":"J16*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L16*$M$14*'Risk Settings & Weightings'!K18","v":0}]
[null,4,null,{"$f":"'Risk Settings & Weightings'!C19","v":"Interest coverage"},"EBIT / Interest expense",{"$f":"IFERROR('2.Profit & Loss'!$H$57/'2.Profit & Loss'!H59,0)","v":0},{"$f":"IF('2.Profit & Loss'!H59=0,Green, IF(F17>='Risk Settings & Weightings'!H19,Green,IF(F17>='Risk Settings & Weightings'!I19,Yellow,IF(F17<'Risk Settings & Weightings'!J19,Red,0))))","v":3},{"$f":"G17*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR('2.Profit & Loss'!$U$57/'2.Profit & Loss'!U59,0)","v":0},{"$f":"IF('2.Profit & Loss'!U59=0,Green,IF(I17>='Risk Settings & Weightings'!H19,Green,IF(I17>='Risk Settings & Weightings'!I19,Yellow,IF(I17<'Risk Settings & Weightings'!J19,Red,0))))","v":3},{"$f":"J17*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L17*$M$14*'Risk Settings & Weightings'!K19","v":0},null,null,"When No Interest Expense outputs green result"]
[null,5,null,{"$f":"'Risk Settings & Weightings'!C20","v":"Break-even (as % of total revenue)"},"(Fixed costs / (Gross Profit / Total Revenue)) / Total Revenue",{"$f":"IFERROR(('2.Profit & Loss'!H54/('2.Profit & Loss'!H42/'2.Profit & Loss'!$H$29))/'2.Profit & Loss'!$H$29,0)","v":0},{"$f":"IF(F18<='Risk Settings & Weightings'!H20,Green,IF(F18<='Risk Settings & Weightings'!I20,Yellow,IF(F18>'Risk Settings & Weightings'!J20,Red,0)))","v":3},{"$f":"G18*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(('2.Profit & Loss'!U54/('2.Profit & Loss'!U42/'2.Profit & Loss'!$U$29))/'2.Profit & Loss'!$U$29,0)","v":0},{"$f":"IF(I18<='Risk Settings & Weightings'!H20,Green,IF(I18<='Risk Settings & Weightings'!I20,Yellow,IF(I18>'Risk Settings & Weightings'!J20,Red,0)))","v":3},{"$f":"J18*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L18*$M$14*'Risk Settings & Weightings'!K20","v":0}]
[null,6,null,{"$f":"'Risk Settings & Weightings'!C21","v":"Employee costs as % of revenue"},"((Trainers & Assessors Salaries and Related Expenses including Superannuation + Management and Administrative Staff Salaries and Related Expenses including Superannuation) / Total Revenue)\"",{"$f":"IFERROR(SUM('2.Profit & Loss'!H44:H47, '2.Profit & Loss'!H33:H34)/'2.Profit & Loss'!H29, 0)","v":0},{"$f":"IF(F19<='Risk Settings & Weightings'!H21,Green,IF(F19<='Risk Settings & Weightings'!I21,Yellow,IF(F19>'Risk Settings & Weightings'!J21,Red,0)))","v":3},{"$f":"G19*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(SUM('2.Profit & Loss'!U44:U47, '2.Profit & Loss'!U33:U34)/'2.Profit & Loss'!U29, 0)","v":0},{"$f":"IF(I19<='Risk Settings & Weightings'!H21,Green,IF(I19<='Risk Settings & Weightings'!I21,Yellow,IF(I19>'Risk Settings & Weightings'!J21,Red,0)))","v":3},{"$f":"J19*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L19*$M$14*'Risk Settings & Weightings'!K21","v":0}]
[null,7,null,{"$f":"'Risk Settings & Weightings'!C22","v":"Superannuation as % of employee costs"},"(Superannuation Expenses / Trainers & Assessors Salaries and Related Expenses excluding Superannuation + Management and Administrative Staff Salaries and Related Expenses excluding Superannuation)",{"$f":"IFERROR(SUM('2.Profit & Loss'!H34,'2.Profit & Loss'!H45,'2.Profit & Loss'!H47)/SUM('2.Profit & Loss'!H33,'2.Profit & Loss'!H44,'2.Profit & Loss'!H46), 0)","v":0},{"$f":"IF(AND(F20>=0.07,F20<=0.15),Green,IF(AND(F20>=0.05,F20<=0.07),Yellow,IF(AND(F20>=0.15,F20<=0.2),Yellow,IF(F20<0.05,Red,IF(F20>0.2,Red,0)))))","v":1},{"$f":"G20*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(SUM('2.Profit & Loss'!U34,'2.Profit & Loss'!U45,'2.Profit & Loss'!U47)/SUM('2.Profit & Loss'!U33,'2.Profit & Loss'!U44,'2.Profit & Loss'!U46), 0)","v":0},{"$f":"IF(AND(I20>=0.07,I20<=0.15),Green,IF(AND(I20>=0.05,I20<=0.07),Yellow,IF(AND(I20>=0.15,I20<=0.2),Yellow,IF(I20<0.05,Red,IF(I20>0.2,Red,0)))))","v":1},{"$f":"J20*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L20*$M$14*'Risk Settings & Weightings'!K22","v":0}]
[null,8,"Balance Sheet",{"$f":"'Risk Settings & Weightings'!C26","v":"Liquidity Ratio"},"Current assets (excluding related parties) / current liabilities (excluding related parties)",{"$f":"IFERROR(('3.Balance Sheet'!I21-'3.Balance Sheet'!I15)/('3.Balance Sheet'!I47-'3.Balance Sheet'!I40),0)","v":0},{"$f":"IF(F21>='Risk Settings & Weightings'!H26,Green,IF(F21>='Risk Settings & Weightings'!I26,Yellow,IF(F21<'Risk Settings & Weightings'!J26,Red,0)))","v":1},{"$f":"G21*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(('3.Balance Sheet'!V21-'3.Balance Sheet'!V15)/('3.Balance Sheet'!V47-'3.Balance Sheet'!V40),0)","v":0},{"$f":"IF(I21>='Risk Settings & Weightings'!H26,Green,IF(I21>='Risk Settings & Weightings'!I26,Yellow,IF(I21<'Risk Settings & Weightings'!J26,Red,0)))","v":1},{"$f":"J21*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L21*$M$14*'Risk Settings & Weightings'!K26","v":0}]
[null,9,null,{"$f":"'Risk Settings & Weightings'!C27","v":"Debt to Equity (Gearing)"},"Total liabilities (excluding related parties) / Total equity (treat related party loans as equity)",{"$f":"IFERROR(('3.Balance Sheet'!I58-'3.Balance Sheet'!I40-'3.Balance Sheet'!I50)/('3.Balance Sheet'!I67+'3.Balance Sheet'!I40+'3.Balance Sheet'!I50-'3.Balance Sheet'!I15-'3.Balance Sheet'!I24),0)","v":0},{"$f":"IF(AND(F22<1,F22>=0),Green,IF(AND(F22>=1,F22<=1.25),Yellow,IF(OR(F22<0,F22>1.25),Red,0)))","v":3},{"$f":"G22*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(('3.Balance Sheet'!V58-'3.Balance Sheet'!V40-'3.Balance Sheet'!V50)/('3.Balance Sheet'!V67+'3.Balance Sheet'!V40+'3.Balance Sheet'!V50-'3.Balance Sheet'!V15-'3.Balance Sheet'!V24),0)","v":0},{"$f":"IF(AND(I22<1,I22>=0),Green,IF(AND(I22>=1,I22<=1.25),Yellow,IF(OR(I22<0,I22>1.25),Red,0)))","v":3},{"$f":"J22*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L22*$M$14*'Risk Settings & Weightings'!K27","v":0},null,null,"Red -If < 0 (ie result is negative) OR if >1.25\nYellow - Between 1 - 1.25\nGreen - Between 0 - 1 (including 0)\n"]
[null,10,null,{"$f":"'Risk Settings & Weightings'!C28","v":"Debt Ratio"},"Total liabilities (excluding related parties) / total assets (excluding related parties and any non-tangible assets such as goodwill)",{"$f":"IFERROR(('3.Balance Sheet'!I58-'3.Balance Sheet'!I40-'3.Balance Sheet'!I50)/('3.Balance Sheet'!I36-'3.Balance Sheet'!I24-'3.Balance Sheet'!I15-SUM('3.Balance Sheet'!I30:I31)),0)","v":0},{"$f":"IF(F23<='Risk Settings & Weightings'!H28,Green,IF(F23<='Risk Settings & Weightings'!I28,Yellow,IF(F23>'Risk Settings & Weightings'!J28,Red,0)))","v":3},{"$f":"G23*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(('3.Balance Sheet'!V58-'3.Balance Sheet'!V40-'3.Balance Sheet'!V50)/('3.Balance Sheet'!V36-'3.Balance Sheet'!V24-'3.Balance Sheet'!V15-SUM('3.Balance Sheet'!V30:V31)),0)","v":0},{"$f":"IF(I23<='Risk Settings & Weightings'!H28,Green,IF(I23<='Risk Settings & Weightings'!I28,Yellow,IF(I23>'Risk Settings & Weightings'!J28,Red,0)))","v":3},{"$f":"J23*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L23*$M$14*'Risk Settings & Weightings'!K28","v":0}]
[null,11,null,{"$f":"'Risk Settings & Weightings'!C29","v":"Debtor Days"},"(Trade debtors / Total Revenue) x 365 days",{"$f":"IFERROR(('3.Balance Sheet'!I16/'2.Profit & Loss'!H29)*365,0)","v":0},{"$f":"IF(F24<='Risk Settings & Weightings'!H29,Green,IF(F24<='Risk Settings & Weightings'!I29,Yellow,IF(F24>'Risk Settings & Weightings'!J29,Red,0)))","v":3},{"$f":"G24*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(('3.Balance Sheet'!V16/'2.Profit & Loss'!U29)*365,0)","v":0},{"$f":"IF(I24<='Risk Settings & Weightings'!H29,Green,IF(I24<='Risk Settings & Weightings'!I29,Yellow,IF(I24>'Risk Settings & Weightings'!J29,Red,0)))","v":3},{"$f":"J24*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L24*$M$14*'Risk Settings & Weightings'!K29","v":0}]
[null,12,null,{"$f":"'Risk Settings & Weightings'!C30","v":"Creditor Days"},"(Trade creditors / total expenses, excluding all employee costs and superannuation costs) x 365 days",{"$f":"IFERROR(('3.Balance Sheet'!I41/(('2.Profit & Loss'!H40+'2.Profit & Loss'!H54)-SUM('2.Profit & Loss'!H44:H47, '2.Profit & Loss'!H33:H34)))*365,0)","v":0},{"$f":"IF(F25<='Risk Settings & Weightings'!H30,Green,IF(F25<='Risk Settings & Weightings'!I30,Yellow,IF(F25>'Risk Settings & Weightings'!J30,Red,0)))","v":3},{"$f":"G25*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR(('3.Balance Sheet'!V41/('2.Profit & Loss'!U54+'2.Profit & Loss'!U40-SUM('2.Profit & Loss'!U33:U34)-SUM('2.Profit & Loss'!U44:U47)))*365,0)","v":0},{"$f":"IF(I25<='Risk Settings & Weightings'!H30,Green,IF(I25<='Risk Settings & Weightings'!I30,Yellow,IF(I25>'Risk Settings & Weightings'!J30,Red,0)))","v":3},{"$f":"J25*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L25*$M$14*'Risk Settings & Weightings'!K30","v":0}]
[null,13,"Cash flow ",{"$f":"'Risk Settings & Weightings'!C34","v":"Working Capital"},"How many months of forecast fixed costs does the organisation hold in Cash & Cash equivalents at the beginning of forecast month 1 ","N/A","N/A","N/A",{"$f":"'Section Checks & Step 1 Calcs '!C46","v":12},"N/A","N/A",{"$f":"IF(I26>='Risk Settings & Weightings'!H34,Green,IF(I26>='Risk Settings & Weightings'!I34,Yellow,IF(I26<'Risk Settings & Weightings'!J34, Red, 0)))","v":3},null,{"$f":"L26*$M$14*'Risk Settings & Weightings'!K34","v":0.1607142857142857},null,null,"Last year vs Forecast year not applicable (No weighting applied)"]
[null,14,null,{"$f":"'Risk Settings & Weightings'!C35","v":"Operating cash flow ratio"},"Operating cash flow / current liabilities (excluding related parties)",{"$f":"IFERROR('4.Cashflow '!I19/('3.Balance Sheet'!I47-'3.Balance Sheet'!I40),0)","v":0},{"$f":"IF(F27>='Risk Settings & Weightings'!H35,Green,IF(F27>='Risk Settings & Weightings'!I35,Yellow,IF(F27<'Risk Settings & Weightings'!J35,Red,0)))","v":1},{"$f":"G27*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$E$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$E$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$E$70, 0)))","v":0},{"$f":"IFERROR('4.Cashflow '!V19/('3.Balance Sheet'!V47-'3.Balance Sheet'!V40),0)","v":0},{"$f":"IF(I27>='Risk Settings & Weightings'!H34,Green,IF(I27>='Risk Settings & Weightings'!I34,Yellow,IF(I27<'Risk Settings & Weightings'!J34,Red,0)))","v":1},{"$f":"J27*IF(App_Type ='Data Source'!$B$12, 'Risk Settings & Weightings'!$F$68, IF(App_Type ='Data Source'!$B$13, 'Risk Settings & Weightings'!$F$69, IF(App_Type ='Data Source'!$B$14, 'Risk Settings & Weightings'!$F$70, 0)))","v":0},0,null,{"$f":"L27*$M$14*'Risk Settings & Weightings'!K35","v":0}]
[]
[null,"Non Financial Metrics"]
[null,null,null,null,null,"Actual Last Year",null,null,"Monthly Management accounts"]
[null,"Item",null,"Name ","Calculation","Provider Result","Score","Weighted Score","Provider Result","Score","Weighted Score","Blended Score","Standard Weighting","Weighted Score","Risk Rating","Comments"]
[null,1,"Business Hygiene Statistics","Business plan","ASQA Assessor to determine","N/A","N/A","N/A","N/A",null,null,{"$f":"IF(BP_Assessment='Risk Settings & Weightings'!H41, Green, IF(BP_Assessment='Risk Settings & Weightings'!I41, Yellow, IF(BP_Assessment='Risk Settings & Weightings'!J41, Red, Green)))","v":3},{"$f":"IF('Section Checks & Step 1 Calcs '!D12 = 1, 1/COUNT(B32:B33,B35,B38,B42:B43),1/COUNT(B32:B45))","v":7.1428571428571425E-2},{"$f":"L32*$M$32*'Risk Settings & Weightings'!K41","v":0.3214285714285714},{"$f":"SUM(N32:N45)","v":2.6785714285714284},"ASQA - T2 - assessment by team 2, poor =  red, average = yellow, good = green"]
[null,2,null,"Financial forecasts","ASQA Assessor to determine","N/A","N/A","N/A","N/A",null,null,{"$f":"IF(FC_Assessment='Risk Settings & Weightings'!H42, Green, IF(FC_Assessment='Risk Settings & Weightings'!I42, Yellow, IF(FC_Assessment='Risk Settings & Weightings'!J42, Red, Green)))","v":3},null,{"$f":"L33*$M$32*'Risk Settings & Weightings'!K42","v":0.3214285714285714},null,"ASQA - T2 - assessment by team 2, poor =  red, average = yellow, good = green"]
[null,3,null,"Management / Audited / Financial Accounts","ASQA Assessor to determine","N/A","N/A","N/A","N/A",null,null,{"$f":"IF(CMA='Risk Settings & Weightings'!H43, Green, IF(CMA='Risk Settings & Weightings'!I43, Yellow, IF(CMA='Risk Settings & Weightings'!J43, Red, Green)))","v":3},null,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 0, L34*$M$32*'Risk Settings & Weightings'!K43)","v":0.21428571428571427},null,"ASQA  Team 2 - IF CMA provided Reasonable green, if not reasonable red otherwise 0 "]
[null,4,null,"Key reconciliations (Debtors / Creditors / Bank)","ASQA Assessor to determine","N/A","N/A","N/A","N/A",null,null,{"$f":"IF(Key_Rec='Risk Settings & Weightings'!H44, Green, IF(Key_Rec='Risk Settings & Weightings'!I44, Yellow, IF(Key_Rec='Risk Settings & Weightings'!J44, Red, Green)))","v":3},null,{"$f":"L35*$M$32*'Risk Settings & Weightings'!K44","v":0.21428571428571427},null,"ASQA Team 2 - IF Key Recs provided Reasonable green, if not reasonable red otherwise 0"]
[null,5,null,"Aged Debtors","Per aged debtors schedules ",{"$f":"IFERROR(SUM('Section Checks & Step 1 Calcs '!C49:C51)/'Section Checks & Step 1 Calcs '!C53, 0)","v":0},{"$f":"F36*0.5","v":0},{"$f":"IFERROR(SUM('Section Checks & Step 1 Calcs '!D49:D51)/'Section Checks & Step 1 Calcs '!D53, 0)","v":0},{"$f":"H36*0.5","v":0},null,null,{"$f":"IF('Section Checks & Step 1 Calcs '!C54=\"Yes\",Green,IF(SUM(G36,I36)>='Risk Settings & Weightings'!H45,Green,IF(SUM(G36,I36)>='Risk Settings & Weightings'!I45,Yellow,IF(SUM(G36,I36)<'Risk Settings & Weightings'!J45,Red,Green))))","v":3},null,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 0, L36*$M$32*'Risk Settings & Weightings'!K45)","v":0.21428571428571427},null,"50% Weighting Applied to the two types"]
[null,6,null,"Aged Creditors","Per aged creditors schedules",{"$f":"IFERROR(SUM('Section Checks & Step 1 Calcs '!$C$56:$C$58)/'Section Checks & Step 1 Calcs '!C60, 0)","v":0},{"$f":"F37*0.5","v":0},{"$f":"IFERROR(SUM('Section Checks & Step 1 Calcs '!$D$56:$D$58)/'Section Checks & Step 1 Calcs '!D60, 0)","v":0},{"$f":"H37*0.5","v":0},null,null,{"$f":"IF('Section Checks & Step 1 Calcs '!C61=\"Yes\",Green,IF(SUM(G37,I37)>='Risk Settings & Weightings'!H46,Green,IF(SUM(G37,I37)>='Risk Settings & Weightings'!I46,Yellow,IF(SUM(G37,I37)<'Risk Settings & Weightings'!J46,Red,Green))))","v":3},null,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 0, L37*$M$32*'Risk Settings & Weightings'!K46)","v":0.3214285714285714},null,"50% Weighting Applied to the two types"]
[null,7,null,"Protection of student pre-paid fees","Provider statement per Section 1.5 on Provider Details","N/A","N/A","N/A","N/A",null,null,{"$f":"IF('Section Checks & Step 1 Calcs '!C27=No,Green,IF('Section Checks & Step 1 Calcs '!C27=0,Green,IF(COUNTIF('Section Checks & Step 1 Calcs '!$C$28:$C$32,\"True\")>0,Green,Red)))","v":3},null,{"$f":"L38*$M$32*'Risk Settings & Weightings'!K47","v":0.21428571428571427},null,"Applicant - IF not collecting prepaid fees, green, if collecting fees and  any of the protection mechanisms are in place, green, if no mechanism, red)"]
[null,8,null,"Super obligations up to date","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","N/A","N/A","N/A","N/A",null,null,{"$f":"IF('Section Checks & Step 1 Calcs '!D15=0, Green, IF(Super='Risk Settings & Weightings'!H48, Green, IF(Super='Risk Settings & Weightings'!J48, Red, 0)))","v":3},null,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 0, L39*$M$32*'Risk Settings & Weightings'!K48)","v":0.21428571428571427},null,"ASQA - T2 If obligations up to date green otherwise if explanation reasonable, green otherwise if explanation not reasonable red, otherwise 0"]
[null,9,null,"Tax obligations up to date","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","N/A","N/A","N/A","N/A",null,null,{"$f":"IF(AND(Tax_Obligation=No,Tax_Plan=Yes),Yellow,IF(AND(Tax_Obligation=No,Tax_Plan=No),Red,IF(Tax_Obligation=Yes,Green,0)))","v":0},null,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 0, L40*$M$32*'Risk Settings & Weightings'!K49)","v":0},null,"Applicant - Obligation not up to date but have plan, yellow, otherwise if  Obligation not up to date and no plan red, otherwise if obligation up to date yes, green, otherwise 0"]
[null,10,null,"Rent obligations up to date","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","N/A","N/A","N/A","N/A",null,null,{"$f":"IF('Section Checks & Step 1 Calcs '!D21=0, Green, IF(Rent='Risk Settings & Weightings'!H50, Green, IF(Rent='Risk Settings & Weightings'!J50, Red, 0)))","v":3},null,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 0, L41*$M$32*'Risk Settings & Weightings'!K50)","v":0.10714285714285714},null,"ASQA - T2 If obligations up to date green otherwise if explanation reasonable, green otherwise if explanation not reasonable red, otherwise 0"]
[null,11,null,"Accrual accounting","Provider statement per Section 1.6 on Provider Details","N/A","N/A","N/A","N/A",null,null,{"$f":"IF(Accrual_Accounting='Risk Settings & Weightings'!H51, Green, IF(Accrual_Accounting='Risk Settings & Weightings'!I51, Yellow, IF(Accrual_Accounting='Risk Settings & Weightings'!J51, Red, Green)))","v":3},null,{"$f":"L42*$M$32*'Risk Settings & Weightings'!K51","v":0.10714285714285714},null,"Applicant - IF Accrual Accounting, Green , if no accrual accounting red, otherwise 0  (Ref 1.8)"]
[null,12,null,"Current insurance","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","N/A","N/A","N/A","N/A",null,null,{"$f":"IF('Section Checks & Step 1 Calcs '!D22=0, Green, IF(Insurance='Risk Settings & Weightings'!H52, Green, IF(Insurance='Risk Settings & Weightings'!J52, Red, 0)))","v":3},null,{"$f":"L43*$M$32*'Risk Settings & Weightings'!K52","v":0.10714285714285714},null,"ASQA - T2 If obligations up to date green otherwise if explanation reasonable, green otherwise if explanation not reasonable red, otherwise 0"]
[null,13,null,"Unresolved legal disputes","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","N/A","N/A","N/A","N/A",null,null,{"$f":"IF('Section Checks & Step 1 Calcs '!D18=0, Green, IF(Legal='Risk Settings & Weightings'!H53, Green, IF(Legal='Risk Settings & Weightings'!J53, Red, 0)))","v":3},null,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 0, L44*$M$32*'Risk Settings & Weightings'!K53)","v":0.1607142857142857}]
[null,14,null,"Contingent liabilities","Provider statement per Section 1.6 on Provider Details with ASQA Assessor to check","N/A","N/A","N/A","N/A",null,null,{"$f":"IF('Section Checks & Step 1 Calcs '!D19=0, Green, IF(Contingent_Liabilities='Risk Settings & Weightings'!H54, Green, IF(Contingent_Liabilities='Risk Settings & Weightings'!J54, Red, 0)))","v":3},null,{"$f":"IF('Section Checks & Step 1 Calcs '!$D$12=1, 0, L45*$M$32*'Risk Settings & Weightings'!K54)","v":0.1607142857142857}]
[]
[]
[null,"Trump Calculation"]
[]
[null,"Item","Section","Question","Applicant Response","Trump Response Given","Trump Triggered ?","Updated Score","Updated reccomendation"]
[null,1,"Group Structure","Are there (will there) be any financial guarantees in place ?",{"$f":"IF('1.Provider Details'!J22=0, \"\", '1.Provider Details'!J22)","v":""},{"$f":"IF(E51=Yes,Yes,IF(E52=Yes,Yes,No))","v":"No"},{"$f":"IF(AND(O14<'Risk Settings & Weightings'!D61, 'Risk Calculations'!F51=Yes), Yes, No)","v":"No"},{"$f":"IF(SUM('Grey Rating Calculation'!D14:D17)>0,'Risk Settings & Weightings'!C64,IF(G51=Yes,'Risk Settings & Weightings'!C62,'Risk Calculations'!O14))","v":10},{"$f":"IF(SUM('Grey Rating Calculation'!D14:D17)>0,\n       \"Tool is incomplete. Not ready to submit\",\n       IF(H51>='Risk Settings & Weightings'!C62,\n            \"Submit tool\",\n            \"Do Not Submit tool\"\n         )\n)","v":"Tool is incomplete. Not ready to submit"}]
[null,2,"Financial forecasts","Is there any further access to funding that the business may have, including bank loans, Director loans, capital injection and/or personal guarantees?",{"$f":"IF('1.Provider Details'!J109=0, \"\", '1.Provider Details'!J109)","v":""}]

{"sheet":"Data Source","index":16,"n_rows":153,"n_cols":2,"rows_kept":153,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"FVRA - Data Source"]
[]
[null,"Application Type"]
[null,"-- Select --"]
[null,"New Registration (Start-up Business)"]
[null,"New Registration (Existing Business)"]
[null,"Monitoring Review"]
[]
[null,"Entity Type"]
[null,"-- Select --"]
[null,"Natural Person (Sole Trader)"]
[null,"Incorporated Association"]
[null,"Cooperative Association"]
[null,"Pty Ltd Company"]
[null,"Partnership"]
[null,"Government Entity"]
[null,"Ltd Company "]
[null,"Trustee "]
[null,"Other"]
[]
[null,"Yes/No"]
[null,"-- Select --"]
[null,"Yes"]
[null,"No"]
[null,"N/A"]
[]
[null,"Protection Mechanism"]
[null,"Option 1 – Policy"]
[null,"Option 2 – Financial Guarantee"]
[null,"Option 3 – Tuition Assurance Scheme"]
[null,"Option 4 - Other"]
[]
[null,"Training Provider Type"]
[null,"-- Select --"]
[null,"School"]
[null,"Community-based adult education provider"]
[null,"University"]
[null,"TAFE or similar public institutions"]
[null,"Enterprise"]
[null,"Other training provider"]
[]
[null,"Counter"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[]
[null,"Counter"]
[null,"-- Select --"]
[null,"Lower"]
[null,"Higher"]
[null,"N/A"]
[]
[]
[null,"IAR Assessment"]
[null,"-- Select --"]
[null,"Do not proceed with RO Assessment"]
[null,"Proceed with RO Assessment"]
[]
[null,"Property Type"]
[null,"-- Select --"]
[null,"Owned"]
[null,"Leased"]
[null,"Hired"]
[]
[null,"Applicant View?"]
[null,1]
[]
[null,"Adequateness Assessment"]
[null,"-- Select --"]
[null,"Good"]
[null,"Average"]
[null,"Poor"]
[]
[null,"Tick Box"]
[null,"-- Select --"]
[null,"x"]
[]
[null,"Reg Ops Final Decision "]
[null,"-- Select --"]
[null,"Does not meet Financial Viability Requirements"]
[null,"Meets Financial Viability Requirements"]
[]
[null,"Timeframes"]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, -24), \"dd-mm-yyyy\") & \" - \" & CHAR(10) &\n        TEXT(EDATE(EOFYDate, -12), \"dd-mm-yyyy\") & CHAR(10) &\n        \"Year -2 (Actual)\",\n        \"Year -2 (Actual)\"),\n        \"Year -2 (Actual)\"\n)","v":"Year -2 (Actual)"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, -12), \"dd-mm-yyyy\") & \" - \" & CHAR(10) &\n        TEXT(EDATE(EOFYDate, 0), \"dd-mm-yyyy\") & CHAR(10) &\n        \"Year -1 (Actual)\",\n        \"Year -1 (Actual)\"),\n        \"Year -1 (Actual)\"\n)","v":"Year -1 (Actual)"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 0), \"mmmm yyyy\"),\n        \"Forecast Month 1\"),\n        \"Forecast Month 1\"\n)","v":"Forecast Month 1"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 1), \"mmmm yyyy\"),\n        \"Forecast Month 2\"),\n        \"Forecast Month 2\"\n)","v":"Forecast Month 2"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 2), \"mmmm yyyy\"),\n        \"Forecast Month 3\"),\n        \"Forecast Month 3\"\n)","v":"Forecast Month 3"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 3), \"mmmm yyyy\"),\n        \"Forecast Month 4\"),\n        \"Forecast Month 4\"\n)","v":"Forecast Month 4"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 4), \"mmmm yyyy\"),\n        \"Forecast Month 5\"),\n        \"Forecast Month 5\"\n)","v":"Forecast Month 5"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 5), \"mmmm yyyy\"),\n        \"Forecast Month 6\"),\n        \"Forecast Month 6\"\n)","v":"Forecast Month 6"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 6), \"mmmm yyyy\"),\n        \"Forecast Month 7\"),\n        \"Forecast Month 7\"\n)","v":"Forecast Month 7"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 7), \"mmmm yyyy\"),\n        \"Forecast Month 8\"),\n        \"Forecast Month 8\"\n)","v":"Forecast Month 8"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 8), \"mmmm yyyy\"),\n        \"Forecast Month 9\"),\n        \"Forecast Month 9\"\n)","v":"Forecast Month 9"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 9), \"mmmm yyyy\"),\n        \"Forecast Month 10\"),\n        \"Forecast Month 10\"\n)","v":"Forecast Month 10"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 10), \"mmmm yyyy\"),\n        \"Forecast Month 11\"),\n        \"Forecast Month 11\"\n)","v":"Forecast Month 11"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n        TEXT(EDATE(EOFYDate+1, 11), \"mmmm yyyy\"),\n        \"Forecast Month 12\"),\n        \"Forecast Month 12\"\n)","v":"Forecast Month 12"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n       TEXT(EDATE(EOFYDate+1, 0), \"dd-mm-yyyy\") & \" - \" & CHAR(10) &\n        TEXT(EDATE(EOFYDate, 12), \"dd-mm-yyyy\") & CHAR(10) &\n        \"(Forecast)\",\n        \"Forecast Year 1\"),\n        \"Forecast Year 1\"\n)","v":"Forecast Year 1"}]
[null,{"$f":"IFERROR(IF(EOFYDate<>\"\",\n       TEXT(EDATE(EOFYDate+1, 12), \"dd-mm-yyyy\") & \" - \" & CHAR(10) &\n        TEXT(EDATE(EOFYDate, 24), \"dd-mm-yyyy\") & CHAR(10) &\n        \"(Forecast)\",\n        \"Forecast Year 2\"),\n        \"Forecast Year 2\"\n)","v":"Forecast Year 2"}]