{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Important Information","1 Organisation Information","2.1 Provider List","2.2 Total Services","2.3 Services Purchased & Opened","2.4 Services Sold & Closed","2.5 Planned Service Movements","3 Financial Information","4 Document Checklist","5 Declaration"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":85,"comments":6,"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":"Instructions","index":0,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,1,9,20],[19,3,19,5],[18,3,18,5],[17,3,17,5],[42,5,42,8],[23,3,23,5],[24,3,24,5],[25,3,25,5],[20,3,20,5],[21,3,21,5],[37,1,37,4],[22,3,22,5]]}
[]
[]
[]
[]
[]
[]
[null,"Instructions | Large Provider Financial Input Report"]
[]
[null,"Introduction"]
[null,"From 1 July 2023, it is required by law that all large child care providers provide certain financial information. For the purposes of meeting financial reporting obligations, this Large Provider Financial Input Report is considered to be the report required under section 203BA of the A New Tax System (Family Assistance) (Administration) Act 1999 (Administration Act). It is a condition for continued approval that a provider is financially viable and likely to remain so. \n\nYou will need to provide financial information as listed in section 54AA of the Child Care Subsidy Minister's Rules 2017, including a statement of financial position (i.e., profit and loss statements, balance sheet etc.), a statement of comprehensive income (cash flow statements), changes in equity statement, among other things. This information is used by the Department of Education to assess the financial viability of large child care providers as required by the Family Assistance Law. \n\nInformation will be stored on the Department of Education's Protected System. Certain information you provide may be provided to the Australian Children's Education & Care Quality Authority (ACECQA), and published online on the Starting Blocks website under section 162B of the Family Assistance Administration Act. "]
[]
[null,"Completing the report"]
[null,"How to save the file"]
[null,"Before you start, save the file as a macro-enabled workbook (.xlsm file). Please save as \"[Insert Organisation name]_LPFIR_end of reporting period.xlsm\" e.g. Child care provider_LPFIR_31 December 2023.xlsm"]
[]
[null,"How to complete the report"]
[null,"This report contains 9 tabs that require input by the organisation. All tabs and questions must be completed."]
[null,null,"Tab 1","1 Organisation Information"]
[null,null,"Tab 2","2.1 Provider List"]
[null,null,"Tab 3","2.2 Total Services"]
[null,null,"Tab 4","2.3 Services Purchased & Opened"]
[null,null,"Tab 5","2.4 Services Sold & Closed"]
[null,null,"Tab 6","2.5 Planned Service Movements"]
[null,null,"Tab 7","3 Financial Information"]
[null,null,"Tab 8","4 Document Checklist"]
[null,null,"Tab 9","5 Declaration"]
[]
[null,"All data entry fields have been colour coded as follows:"]
[null,null,null,"Manual entry"]
[null,null,null,"Select from the drop down list"]
[null,null,null,"Completed automatically"]
[null,null,null,"Check cell and ensure that this says \"TRUE\""]
[]
[null,"Some cells contain a note with more guidance on the type of input required (see picture across)."]
[]
[null,"Next steps once complete"]
[null,"Once complete, please email the Large Provider Financial Input Report, along with any other financial information you are providing (i.e., financial statements, Director's report, organisational structure etc.) to:"]
[null,"ECECFinancialViability@education.gov.au"]
[]
[null,"Please ensure that you complete the declaration and document checklist prior to emailing your response. "]
[]
[null,"Questions and assistance "]
[null,"For further assistance, please email:",null,null,null,"ECECFinancialViability@education.gov.au"]

{"sheet":"Important Information","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[33,1,33,5],[30,1,30,5],[13,1,14,11]]}
[]
[]
[]
[]
[]
[]
[null,"Authority and Relevant Reporting Period"]
[]
[null,"All information provided must be in relation to the below reporting period:"]
[null,"Period commencing:",null,"2023-01-01"]
[null,"Period ending:",null,"2023-12-31"]
[]
[null,"All references to ‘organisation’ in this worksheet are to the large provider specified in Section 1a – Organisation details"]
[null,"Financial information required \nFinancial information which must be reported to the department includes: \n•     A statement of financial position (for example, profit and loss statement, balance sheet (equity, assets, liabilities), cash flow statement)\n•     A statement of comprehensive income\n•     A statement of changes in equity\n•     A statement of cash flows\n•     Details of rental arrangements for each child care service in respect of which the approved provider is approved\n•     The amount of rent paid for each child care service in respect of which the approved provider is approved\n•     If a Director’s report is produced, the Director’s report\n•     If an Auditor’s report is produced, the Auditor’s report\n•     Information necessary for assessing whether the provider is and will remain financially viable\n•     Any other information necessary to assist in the understanding of the financial information listed in the dot points above. \n\nExamples of information that can be provided to assess a provider's financial viability may include information on the provider’s ability to meet all liabilities payable, debt guarantees from parent entities, movement in holdings of the provider’s child care services, impacts of events outside the provider’s control, other forms of business support available to the provider, changes in operating environment, and strategies the provider has implemented to maintain or improve its financial position.\n\nAny financial information disclosed should be true and accurate. Under the Criminal Code Act 1995 it is an offence to provide false or misleading information, or documents to the Commonwealth. The penalty for such an offence is 12 months imprisonment. \n\nWhat is a large provider? \nA large provider is one that:\n•     Operates 25 or more services\n•     Shares operation of 25 or more services with another provider\n•     Plans to operate or share operation of 25 or more services.\n\nWhen do large providers need to report?\nYou must report within 3 months of the end of the financial reporting period. If you are a large provider and you report on a financial year, you must report within 3 months of 30 June (1 October). If you do your financial reporting on a calendar year, you must report within 3 months of 31 December (1 April). \n\nWhat are the consequences if large providers do not comply? \nWe may take compliance action if you fail to meet your obligations. Compliance action may include:\n•     Putting conditions on your CCS approval\n•     Issuing an infringement\n•     Engaging in an independent audit\n•     Suspending or cancelling your CCS approval."]

{"sheet":"1 Organisation Information","index":2,"n_rows":135,"n_cols":5,"rows_kept":135,"cut":false,"hidden":false,"merged":[[93,9,93,15],[34,1,34,7],[86,9,86,15],[31,1,31,7],[36,4,36,7],[37,4,37,7],[38,4,38,7],[39,4,39,7],[40,4,40,7],[41,4,41,7],[42,4,42,7],[43,4,43,7],[44,4,44,7],[45,4,45,7],[46,4,46,7],[47,4,47,7],[53,4,53,7],[54,4,54,7],[55,4,55,7],[48,4,48,7],[49,4,49,7],[50,4,50,7],[51,4,51,7],[52,4,52,7]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",D6),LEN(CELL(\"filename\",D6))-FIND(\"]\",CELL(\"filename\",D6)))","v":"1 Organisation Information"}]
[]
[null,"Part 1"]
[null,"Section 1a - Organisation details"]
[null,"Legal name of organisation: "]
[null,"Registered trading name of organisation:"]
[null,"Registered address of organisation (not a PO Box): "]
[null,"Postal address of organisation:"]
[null,"Australian Business Number (ABN):"]
[null,"Australian Company Number (ACN), if applicable:"]
[null,"Entity structure (e.g. private company, public company, State/Territory Government, Unincorporated Body):"]
[null,"Type of organisation:"]
[null,"Organisation's Contact Details"]
[null,"Name:"]
[null,"Position:"]
[null,"Email:"]
[null,"Phone number:"]
[null,"Ultimate Holding Entity"]
[null,"Did the organisation have an Ultimate Holding Entity at any time during the reporting period? "]
[null,"If Yes, please provide details of the legal name and ABN or ACN of the Ultimate Holding Entity (if applicable)"]
[null,"If Yes, does this entity guarantee the payment of the provider's obligations?"]
[]
[null,"Did ownership of the organisation change at any time during the reporting period? "]
[null,"If Yes, please provide details."]
[]
[null,"For organisations with an Ultimate Holding Entity only -  please attach a diagram to your response email illustrating the ownership structure of the organisation and percentage of ownership held by each person/entity at the end of the reporting period."]
[]
[null,"Directors and Relevant Persons"]
[null,"Note: ‘Relevant persons’ are persons who have a direct or indirect interest in the organisation, with the potential to exert influence over the management or operation of the organisation. This includes owners, Directors, Partners, Office Bearers, Councillors, and Trustees."]
[]
[null,"Full Name","Date of Birth \n(DD/MM/YYYY)","Years in Position","Position"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For additional Relevant Persons, please include in a list as a further attachment to your report and note this in tab 4. Document List."]
[]
[null,"Section 1b - Trust details"]
[null,"Was the organisation associated with a trust, and/or acted as trustee for that trust, at any time during the reporting period? "]
[null,"If Yes, please provide details of the trust (name and type [e.g. Discretionary, Unit Trust, Public Benevolent Institution])."]
[]
[null,"Does the organisation plan to become associated with a trust, or act as trustee for that trust, at any time during the upcoming 12 months? "]
[null,"If Yes, please provide details of the trust (name and type [e.g. Discretionary, Unit Trust, Public Benevolent Institution])."]
[]
[null,"Section 1c - Debt"]
[null,"Did the organisation fail to pay an instalment of a debt on time at any time during the reporting period? "]
[null,"If Yes, please provide details of what occurred, including mitigating actions the organisation may have taken and how the situation has been resolved."]
[]
[null,"Is there a likelihood that the organisation will fail to pay an instalment of a debt on time at any time during the upcoming 12 months? "]
[null,"If Yes, please provide details of what is expected to occur, including  mitigating actions the organisation may take and how the situation will be resolved."]
[]
[null,"Did the organisation guarantee the debts of any person at any time during the reporting period? "]
[null,"If Yes, please provide a description of the guarantee and the amount that was guaranteed."]
[]
[null,"Is the organisation planning to guarantee the debts of any person at any time during the upcoming 12 months? "]
[null,"If Yes, please provide a description of the guarantee and the amount that will be guaranteed."]
[]
[null,"Did the organisation owe a debt to, or was it owed a debt by, another person that was associated with the organisation at any time during the reporting period?"]
[null,"If Yes, provide details of the debt(s) and the name and ABN or ACN of the other person(s)."]
[]
[null,"Is the organisation likely to owe a debt to, or be owed a debt by, another person who is associated with the organisation at any time during the upcoming 12 months? "]
[null,"If Yes, provide details of the debt(s) and the name and ABN or ACN of the other person(s)."]
[]
[null,"Section 1d - Insolvency"]
[null,"Was any owner or relevant persons (as defined in 1a) of the organisation involved in insolvency proceedings at any time during the reporting period? "]
[null,"If Yes, please provide the name of the owner of the organisation, a description of the insolvency event, and state the effect of this, if any, on the child care services provided by the organisation."]
[]
[null,"Is any owner or relevant persons (as defined in 1a) of the organisation likely to be involved in insolvency proceedings at any time during the upcoming 12 months?"]
[null,"If Yes, please provide the name of the owner of the organisation, a description of the insolvency event, and state the effect of this, if any, on the child care services provided by the organisation."]
[]
[null,"Section 1e - Changes in Financial Position"]
[null,"Have any material changes to the financial situation of the organisation occurred since the organisation last provided financial information to the department?"]
[null,"If Yes, please provide a description of the material changes to the financial situation."]
[]
[null,"Are any material changes to the financial situation of the organisation likely to arise during the upcoming 12 months?"]
[null,"If Yes, please provide a description of the material changes to the financial situation."]
[]
[null,"Section 1f - Business Activities"]
[null,"Please list other business activities the organisation undertakes outside of child care and the percentage of total revenue. If the exact percentage is not known, please provide an estimate."]
[]
[null,"Other Business Activities","% of Total Revenue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Section 1g - Funding Sources"]
[null,"Is the provider able to rely on other forms of business support to facilitate business continuity?"]
[null,"If yes, please provide details."]
[]
[null,"Section 1h - Events Outside the Provider's Control"]
[null,"Was the provider subject to the impacts of natural events such as floods, bushfires, pandemics or workforce issues?"]
[null,"If Yes, please provide details."]
[]
[null,"Did these events have a significant effect on the business operation?"]
[null,"If Yes, please provide details."]
[]
[null,"Section 1i - Compliance and Risk"]
[null,"Has the organisation had any compliance issues or breaches with other state or federal government agencies such as the ATO and ASIC?"]
[null,"If yes, please provide details."]
[]
[null,"What are the demographic factors, government initiatives, market trends/changes or social changes that are likely to affect the organisation? "]
[]
[null,"What mitigation strategies and/or contingency plans does the organisation have in place (or are considering) to deal with unforeseen events (pandemics, natural disasters) or changes (such as demographic factors, government initiatives, social changes) that may impact an organisations' operations or financial viability?"]

{"sheet":"2.1 Provider List","index":3,"n_rows":165,"n_cols":6,"rows_kept":165,"cut":false,"hidden":false,"merged":[[10,1,10,5]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",D6),LEN(CELL(\"filename\",D6))-FIND(\"]\",CELL(\"filename\",D6)))","v":"2.1 Provider List"}]
[]
[]
[null,"Section 2a - Provider details"]
[null,"Please provide details for your provider and all other related providers. A related provider is a provider that shares 25% or more of the persons in management, a provider that owns 15% or more of your provider (or vice versa), or a provider entitled to receive 15% or more of dividends paid by your provider (or vice versa)."]
[]
[null,"Name of provider","Number of services ","ABN","ACN","Type of organisation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For additional providers, please include in a list as a further attachment to your report and note this in tab 4. Document List."]

{"sheet":"2.2 Total Services","index":4,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,3,13,9],[14,3,14,9]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",D6),LEN(CELL(\"filename\",D6))-FIND(\"]\",CELL(\"filename\",D6)))","v":"2.2 Total Services"}]
[]
[]
[null,"Section 2b  - Child Care Services - Summary"]
[null,"Please provide a response of '0' where applicable. Do not leave any cells blank. "]
[]
[null,{"$f":"\"Number of services operating as at \" & TEXT('Important Information'!$D$10,\"dd-mmm-yy\")","v":"Number of services operating as at 01-Jan-23"}]
[null,{"$f":"\"Number of services purchased between \"&TEXT('Important Information'!$D$10,\"dd-mmm-yy\")&\" and \"&TEXT('Important Information'!$D$11,\"dd-mmm-yy\")","v":"Number of services purchased between 01-Jan-23 and 31-Dec-23"}]
[null,{"$f":"\"Number of services opened between \"&TEXT('Important Information'!$D$10,\"dd-mmm-yy\")&\" and \"&TEXT('Important Information'!$D$11,\"dd-mmm-yy\")","v":"Number of services opened between 01-Jan-23 and 31-Dec-23"}]
[null,{"$f":"\"Number of services closed between \"&TEXT('Important Information'!$D$10,\"dd-mmm-yy\")&\" and \"&TEXT('Important Information'!$D$11,\"dd-mmm-yy\")","v":"Number of services closed between 01-Jan-23 and 31-Dec-23"}]
[null,{"$f":"\"Number of services sold between \"&TEXT('Important Information'!$D$10,\"dd-mmm-yy\")&\" and \"&TEXT('Important Information'!$D$11,\"dd-mmm-yy\")","v":"Number of services sold between 01-Jan-23 and 31-Dec-23"}]
[null,{"$f":"\"Number of services operating as at \" & TEXT('Important Information'!$D$11,\"dd-mmm-yy\")","v":"Number of services operating as at 31-Dec-23"}]
[null,null,{"$f":"SUM($C$13:$C$15)-SUM($C$16:$C$17)","v":0},{"$f":"($C$18=$C$19)","v":true}]

{"sheet":"2.3 Services Purchased & Opened","index":5,"n_rows":169,"n_cols":10,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",D6),LEN(CELL(\"filename\",D6))-FIND(\"]\",CELL(\"filename\",D6)))","v":"2.3 Services Purchased & Opened"}]
[]
[]
[null,"Section 2b  - Child Care Services"]
[]
[null,"Services Purchased or Opened","Opened is defined as the operator having constructed or established a new child care facility, which was operational at any time during the reporting period. For the purpose of reporting OSHC services, \"opened\" includes winning tenders at schools. "]
[]
[null,"Did the provider purchase or open any services during the reporting period?"]
[null,"If Yes, please complete the table below. "]
[]
[null,"Name of service","Address of service","ABN","ACN","Maximum number of licensed places","Date the service commenced operation \n(DD/MM/YYYY)","Reason(s) for purchase/opening","Previous provider name (if purchased, otherwise leave blank)","Care Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For additional services purchased or opened, please include in a list as a further attachment to your report and note this in tab 4. Document List."]

{"sheet":"2.4 Services Sold & Closed","index":6,"n_rows":169,"n_cols":10,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",D6),LEN(CELL(\"filename\",D6))-FIND(\"]\",CELL(\"filename\",D6)))","v":"2.4 Services Sold & Closed"}]
[]
[]
[null,"Section 2b  - Child Care Services"]
[]
[null,"Services Sold or Closed"]
[]
[null,"Did the provider sell or close any services during the reporting period?"]
[null,"If Yes, please complete the table below. "]
[]
[null,"Name of service","Address of service","ABN","ACN","Maximum number of licensed places","Date the service was sold or closed \n(DD/MM/YYYY)","Reason(s) for selling/closing","If sold, who bought the service (include ABN or ACN if applicable)","Care Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For additional services sold or closed, please include in a list as a further attachment to your report and note this in tab 4. Document List."]

{"sheet":"2.5 Planned Service Movements","index":7,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[13,1,13,8]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",C6),LEN(CELL(\"filename\",C6))-FIND(\"]\",CELL(\"filename\",C6)))","v":"2.5 Planned Service Movements"}]
[]
[]
[null,"Section 2b  - Child Care Services"]
[null,"Planned movements in Child Care Services"]
[null,{"$f":"\"Please provide further details for planned or actioned movements of services planned for the 12 months following \" & TEXT('Important Information'!$D$11,\"dd-mmm-yy\") & \".\"","v":"Please provide further details for planned or actioned movements of services planned for the 12 months following 31-Dec-23."}]
[null,"Please provide a response of '0' where applicable. Do not leave any cells blank. "]
[null,"Planned movements includes a plan of the organisation:\n•     To commence operating or cease operating a child care service\n•     To relocate one of its child care services\n•     To expand or reduce the capacity of one of its services.\n\nPlanned movements should be reported where they involve real or actual steps taken by the organisation, or formal planning, for example:\n•     A provider enters into an agreement for the planned movement (e.g., a business sale agreement)\n•     A provider enters an agreement that is preparatory to the movement (e.g., purchases property or enters a lease for a child care service; seeks Expressions of Interest for the sale of a child care service)\n•     The planned movement is included in a plan that has been endorsed by a person with management or control of the provider (e.g., in a business plan or budget)."]
[]
[null,"Type of Planned Movement","Centre-Based Day Care\n(CBDC)","Outside School Hours Care\n(OSHC)","Family Day Care \n(FDC)","In Home Care\n(IHC)","Kindergarten/\nPreschool","Other","Totals"]
[null,"Planned number of services to be purchased",null,null,null,null,null,null,{"$f":"SUM($C$17:$H$17)","v":0}]
[null,"Planned number of services to be opened",null,null,null,null,null,null,{"$f":"SUM($C$18:$H$18)","v":0}]
[null,"Planned number of services to be sold",null,null,null,null,null,null,{"$f":"SUM($C$19:$H$19)","v":0}]
[null,"Planned number of services to be closed",null,null,null,null,null,null,{"$f":"SUM($C$20:$H$20)","v":0}]

{"sheet":"3 Financial Information","index":8,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[38,2,38,13]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",D6),LEN(CELL(\"filename\",D6))-FIND(\"]\",CELL(\"filename\",D6)))","v":"3 Financial Information"}]
[]
[null,"Part 3"]
[null,"Section 3a - Financial Statement Information"]
[null,{"$f":"\"Please complete the following for the whole organisation for the reporting period \"&TEXT('Important Information'!$D$10,\"dd-mmm-yy\")&\" to \"&TEXT('Important Information'!$D$11,\"dd-mmm-yy\")","v":"Please complete the following for the whole organisation for the reporting period 01-Jan-23 to 31-Dec-23"}]
[]
[null,"Statement of Profit or Loss"]
[null,"Revenue"]
[null,"EBIT",null,"  EBIT - Earnings before interest and taxes"]
[null,"Depreciation and Amortisation Expense"]
[null,"EBITDA",null,"  EBITDA - Earnings before interest, taxes, depreciation and amortisation"]
[null,"Interest Expense "]
[null,"Income Tax "]
[null,"NPAT",null,"  NPAT - Net Profit After Tax"]
[]
[null,"Statement of Financial Position"]
[null,"Opening Total Assets",null,"  Total Assets at the start of the reporting period"]
[null,"Current Assets"]
[null,"Intangible Assets"]
[null,"Closing Total Assets",null,"  Total Assets at the end of the reporting period"]
[null,"Total Debt",null,"  Debt encompasses financial obligations or liabilities that arise from borrowing activities. Provide information regarding debt as it would be presented in your financial statements."]
[null,"Current Liabilities"]
[null,"Total Liabilities"]
[null,"Total Equity"]
[]
[null,"Statement of Cash Flows"]
[null,"Net Cash Flow ",null,"  Net Cash Flow at the end of the reporting period"]
[null,"Cash and Cash Equivalents at Year End",null,"  Total Cash and Cash Equivalents at the end of the reporting period"]
[]
[null,"Section 3b - Figures for Child Care services"]
[null,"Note: Please ignore surplus columns if your reporting period is only six months."]
[]
[null,null,"Month"]
[null,null,{"$f":"TEXT(EOMONTH('Important Information'!$D$10,0),\"mmm-YY\")","v":"Jan-23"},{"$f":"TEXT(EDATE(C40,1),\"mmm-yy\")","v":"Feb-23"},"Mar-23","Apr-23","May-23","Jun-23","Jul-23","Aug-23","Sep-23","Oct-23","Nov-23","Dec-23","Total"]
[null,"Number of child care related staff (fulltime equivalent basis)",null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"Total salaries paid for child care related staff",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C42:N42)","v":0}]
[null,"Total rental/leasing costs to occupy the premises attributed to child care services",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C43:N43)","v":0}]
[null,"Total monthly revenue earned from the provision of child care services",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C44:N44)","v":0}]
[null,"Occupancy rate for all child care services (percentage of all available licensed places)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(C45:N45),0)","v":0}]

{"sheet":"4 Document Checklist","index":9,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",D6),LEN(CELL(\"filename\",D6))-FIND(\"]\",CELL(\"filename\",D6)))","v":"4 Document Checklist"}]
[]
[null,"Please complete the table below to identify and confirm the documents you are providing as part of your report."]
[]
[null,"Supporting Document","Attached to Email","Not Applicable"]
[null,"Financial Statements"]
[null,"Director’s Report"]
[null,"Auditor’s Report (if one is produced)"]
[null,"Ultimate Holding Entity diagram/organisation structure "]
[null,"List of Additional Providers"]
[null,"List of Additional Services Purchased & Opened"]
[null,"List of Additional Services Sold & Closed"]
[]
[null,"Please list any other attachments not listed above in the table below."]
[]
[null,"Supporting Document","Attached to Email"]

{"sheet":"5 Declaration","index":10,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,1,8,16]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",D6),LEN(CELL(\"filename\",D6))-FIND(\"]\",CELL(\"filename\",D6)))","v":"5 Declaration"}]
[]
[null,"I understand I am required to provide a report and other financial information to the Department of Education (the department), as required under the A New Tax System (Family Assistance) (Administration) Act 1999 (Administration Act), to assist the department in determining whether, I, as a large provider, am financially viable and will be likely to remain so. \n\nI understand the department may disclose some of my information to the Australian Children's Education and Care Quality Authority (ACECQA), which will be published on the Starting Blocks website (StartingBlocks.gov.au) to uplift transparency in the child care sector and equip families with more information about the child care services they access.\n\nI declare that: \n•\t     The information I have given on the Large Provider Financial Input Report and on any other attachments is true and accurate\n•\t     I am aware financial information provided may be shared to ACECQA and published on the Starting Blocks website\n•\t     I am aware that knowingly providing a false or misleading statement is a criminal offence and may carry a penalty of up to 12 months imprisonment.\n"]
[]
[]
[null,null,null,null,"Full name of person making declaration:"]
[null,null,null,null,"Title:"]
[null,null,null,null,"Signature:"]
[null,null,null,null,"Date:"]