{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INSTRUCTIONS","HMST Project Budget Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS FOR HMSTRUST MULTI-YEAR BUDGET"]
[]
[null,"When you apply to HMSTrust for a grant, you are required to provide a budget for your project using this template."]
[]
[null,"Please save a copy of the budget template to enable you to attach it to your online application once completed. As you save it, we recommend you re-name your template with your organisation name in the title e.g. \"XY org budget\". Make sure you include your organisation name in the field at the top of the template."]
[]
[null,"Make sure that your project budget details are accurate and realistic as you will be required to report against this budget should your application be successful."]
[]
[null,"Only complete the shaded (coloured) areas in the template. Some fields will automatically calculate and fill based on your entries."]
[]
[null,"Please note this template is locked so headings cannot be altered. Extra lines may not be inserted, however cell text will wrap."]
[]
[null,"GST: Note that grants made by HMSTrust are regarded as gifts and are not subject to GST. If you are registered for GST you must not include GST in your income and expenditure figures. If you are not registered for GST you should include GST in your expenditure figures, where applicable."]
[]
[null,"Period (Yr 1/Yr2/Yr3): Please ensure you enter the dates for each project year at the top of each column, e.g. the dates you expect your project to commence and conclude, and what period each year will align to. A ‘year’ does not have to align to a financial, calendar or 12 month year, but needs to work for your project, and fit in with annual reporting against milestones back to the Trust and subsequent payments."]
[]
[null,"Income: Income from both HMSTrust and other sources can be spread across years and does not need to be the same each year. It should reflect the timing of project activities."]
[]
[null,"You must state whether income from other sources is confirmed (Yes) or not confirmed (No). If your budet includes income that is not confirmed (for example, an application to another funding body/foundation), you will need to update us with the results as they become available. Please note HMSTrust only pays out a grant, once all funding for a project has been confirmed. If an application to another funding body is unsuccessful, or other income becomes unavailable, you must advise HMSTrust as soon as possible. You will need to submit a revised budget. If your application is successful, you will be required to report Actuals against your Budget."]
[]
[null,"Totals: The budgeted total income MUST equal the budgeted total expenses. The template will calculate totals as you complete the budget. You will receive a warning in red next to the totals if income and expenditure do not balance.  This will disappear once your budget balances."]
[]
[null,"You will be required to enter your project budget totals into your application form. Ensure that the totals in your application form match with the totals in your completed Project Budget Template."]
[]
[null,"Notes: You may provide additional narrative notes for particular line items if required by putting a number in the 'Note #' column, and include corresponding narrative detail in the Notes section at the end."]
[]
[null,"DEFINITIONS"]
[]
[null," In-kind is non-cash contributions of time, services, equipment, materials etc. The in-kind Income line item must match the in-kind Expense line item.  Only enter the in-kind details in the Income section and it will auto populate in the Expense section."]
[]
[null,"Earned income is income that is expected to be generated from the project (e.g. ticket sales, fee-for-service etc.)"]
[]
[null,"CONTACT US"]
[null,"If you have any questions or issues, please call HMSTrust on 03 9999 3000 or email applications@hmstrust.org.au and we will assist you."]

{"sheet":"HMST Project Budget Template","index":1,"n_rows":79,"n_cols":10,"rows_kept":79,"cut":false,"hidden":false,"merged":[[3,2,5,2],[74,1,77,7],[41,2,43,2],[2,2,2,6],[79,1,85,7]]}
[null,"MULTI-YEAR GRANT PROJECT BUDGET TEMPLATE"]
[]
[null,"ORGANISATION TRADING NAME:","<enter name>"]
[null,null,"Note #"]
[null,null,null,null,"<enter period>","<enter period>","<enter period>",null,"Confirmed  "]
[null,"INCOME",null,"Itemise detail / description","Year 1","Year 2","Year 3","Total","(Yes/No)"]
[null,"Funding request from HMSTrust (exclusive of GST):",null,null,null,null,null,{"$f":"SUM(E7:G7)","v":0},"No"]
[null,"Government funding (itemise):",null,null,null,null,null,{"$f":"SUM(E8:G8)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E9:G9)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Other philanthropic sources (itemise):",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E15:G15)","v":0}]
[null,null,null,null,null,null,null,0]
[null,"Cash contribution from own organisation (itemise):",null,null,null,null,null,0]
[null,"In-kind contribution from own organisation:",null,null,null,null,null,0]
[null,"(Itemise)",null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E20:G20)","v":0}]
[null,null,null,null,null,null,null,0]
[null,"Earned income: ",null,null,null,null,null,0,null,{"$f":"IF(AND(SUM(H22:H23)>0,LEN(B75)=0),\"Please complete EARNED INCOME EXPLANATION BELOW\",\"\")","v":""}]
[null,"(itemise & complete explanation in box below)",null,null,null,null,null,0]
[null,"Other (specify & itemise):",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Cash contribution from project partners:",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E29:G29)","v":0}]
[null,null,null,null,null,null,null,0]
[null,"In-kind contributions from project partners:",null,null,null,null,null,0]
[null,"(itemise and name project partners)",null,null,null,null,null,{"$f":"SUM(E32:G32)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E33:G33)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E34:G34)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,"TOTAL INCOME",{"$f":"SUM(E7:E35)","v":0},{"$f":"SUM(F7:F35)","v":0},{"$f":"SUM(G7:G35)","v":0},{"$f":"SUM(H7:H35)","v":0},{"$f":"IF(H71<>H36,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,null,null,"SUMMARY OF TOTAL INCOME (automatically populated):"]
[null,null,null,"Total confirmed income",null,null,null,{"$f":"SUMIF(I7:I35,\"Yes\",H7:H35)","v":0}]
[null,null,null,"Total unconfirmed income (excluding HMST funding request)",null,null,null,{"$f":"SUMIF(I7:I35,\"No\",H7:H35)-H41","v":0}]
[null,null,null,"HMST funding request",null,null,null,{"$f":"SUM(H7:H7)","v":0}]
[null,null,"Note #",null,null,null,null,{"$f":"SUM(H39:H41)","v":0},{"$f":"IF(H42<>H36,\"Warning: Please make sure Confirmed (Yes/No) is selected for each completed income line\",\"Check OK\")","v":"Check OK"}]
[]
[null,"EXPENSES",null,"Itemise detail / description (Provide detailed information such as hours, rates, quantities, position title, contractor/evaluator name etc)\n","Year 1","Year 2","Year 3"]
[null,"Salaries (including super, payroll tax etc):",null,null,null,null,null,{"$f":"SUM(E45:G45)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E46:G46)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Consultant fees specific to this project:",null,null,null,null,null,0]
[null,"Capital, fit-out, equipment costs (itemise):",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Administration and consumable costs:",null,null,null,null,null,0]
[null,"Travel and accommodation:",null,null,null,null,null,0]
[null,"Marketing/advertising/promotion:",null,null,null,null,null,0]
[null,"Evaluation (specify who conducts):",null,null,null,null,null,0]
[null,"Other (specify & itemise):",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"In-kind contributions from own organisation:",null,{"$f":"IF(D18=\"\",\"\",D18)","v":""},{"$f":"E18","v":0},0,0,{"$f":"SUM(E62:G62)","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D19=\"\",\"\",D19)","v":""},0,0,0,{"$f":"SUM(E63:G63)","v":0}]
[null,null,null,{"$f":"IF(D20=\"\",\"\",D20)","v":""},0,0,0,{"$f":"SUM(E64:G64)","v":0}]
[null,null,null,{"$f":"IF(D21=\"\",\"\",D21)","v":""},{"$f":"E21","v":0},0,0,{"$f":"SUM(E65:G65)","v":0}]
[null,"In-kind contributions from project parters:",null,{"$f":"IF(D31=\"\",\"\",D31)","v":""},{"$f":"E31","v":0},0,0,0]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D32=\"\",\"\",D32)","v":""},0,0,0,0]
[null,null,null,{"$f":"IF(D33=\"\",\"\",D33)","v":""},0,0,0,{"$f":"SUM(E68:G68)","v":0}]
[null,null,null,{"$f":"IF(D34=\"\",\"\",D34)","v":""},0,0,0,{"$f":"SUM(E69:G69)","v":0}]
[null,null,null,{"$f":"IF(D35=\"\",\"\",D35)","v":""},{"$f":"E35","v":0},0,0,0]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E45:E70)","v":0},{"$f":"SUM(F45:F70)","v":0},{"$f":"SUM(G45:G70)","v":0},{"$f":"SUM(H45:H70)","v":0},{"$f":"IF(H71<>H36,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,"EARNED INCOME EXPLANATION"]
[null,"If your project relies on earned income, please provide brief details relating to rationale of revenue assumptions:"]
[]
[]
[]
[]
[null,"NOTES - for additional details on itemised income and expense items, if required. Please ensure corresponding 'Note #' is included."]