{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Private Company >>","Template a","Template a Explanation","Not for Profit >>","Template b","Template b Explanation","Supporting Information >>","Template Checklist","Template b Worked Example","Ratio Calculations","Thresholds"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"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":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,2,31,9],[4,2,4,9],[7,2,7,9],[10,2,10,9],[24,2,24,9],[27,2,27,9]]}
[]
[null,"Financial Analysis Template - Evidence Centre - Instructions"]
[]
[null,"0. Purpose"]
[null,null,"The purpose of this financial template is to ensure that applicants have the capacity and financial stability to service a grant of this size and nature. By entering metrics from applicant's financial statements, thresholds are calculated which assess the financial health of the organisation (with a Red/Amber/Green rating) and therefore the risk exposure to the grant funder. Any red ratings must be justifiably explained in the supporting commentary in order to provide confidence that the applicant has the financial stability to service the contract."]
[]
[null,"1. Financial Template"]
[null,null,"All entities (excluding subcontractors) must fill in a financial template. Two templates are provided:\na. Private Limited Company / Publically Listed Company\nb. Not for Profit/Voluntary Organisation\nEach template has fields appropriate to each organisation, and associated metrics"]
[]
[null,"2. Thresholds"]
[null,null,"Standard thresholds are defined based on the UK Government Financial Viability Risk Assessment as per the UK Government Sourcing and Consultancy Playbook: https://www.gov.uk/government/publications/the-sourcing-and-consultancy-playbooks\nThresholds are as follows:"]
[null,null,null,"Red","Amber","Green"]
[null,null,"Turnover Ratio",1.5,null,2,"Higher the better"]
[null,null,"Operating Margin",0.05,null,0.1,"Higher the better"]
[null,null,"Cash Ratio",1,null,1,"Higher the better"]
[null,null,"Debt Ratio",1.2,null,1,"Lower the better"]
[null,null,"Acid Ratio",0.8,null,1,"Higher the better"]
[null,null,"Net Asset Value",0,null,0,"Higher the better"]
[null,null,"Net Debt to EBITDA Ratio",3.5,null,2.5,"Lower the better"]
[null,null,"Net Debt + Net Pension to EBITDA Ratio",5,null,4,"Lower the better"]
[null,null,"Interest Cover ",3,null,4.5,"Higher the better"]
[]
[null,"3. Explanation"]
[]
[null,null,"For all metrics which are measured either Amber or Red, please provide justification for these figures in the 'explanation' tab. Achieving a 'Red' in any metric does not mean that the applicant will be automatically excluded from the competition. Adverse metrics are expected to be discussed through a dialogue process."]
[null,"4. Checklist"]
[]
[null,null,"A checklist has been included for information - applicants are NOT EXPECTED to fill this in. These are the areas that will be checked during evaluation of the financial template. The grant funder may come back to applicants requesting additional information, based on questions in the checklist."]
[]
[null,"5. Worked Example"]
[]
[null,null,"A worked example has been filled in to aid understanding of the template."]
[]
[null,null,"Note: if your profit and loss data represents a period other than 12 months, please present your best 12 month estimate and explain how this was calculated."]

{"sheet":"Private Company >>","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Template a","index":2,"n_rows":155,"n_cols":12,"rows_kept":155,"cut":false,"hidden":false,"merged":[[0,0,2,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"v0.4"]
[]
[]
[]
["Company Name:"]
["Date:"]
[]
[]
[null,"Approximate Annual Grant Value (£000s)",1000,null,"Fixed Cell based on estimated grant value"]
[null,"Approximate percentage share of partner",0.5]
[]
[null,null,"RAG Rating",null,"RAG Rating",null,"RAG Rating"]
[null,null,"2018/19",null,"2019/20",null,"2020/21"]
[null,"Turnover Ratio",{"$f":"C30/($C$9*$C$10)","v":2.6680000000000001},null,{"$f":"E30/($C$9*$C$10)","v":0},null,{"$f":"G30/($C$9*$C$10)","v":0},"Ratio of  company turnover to grant size"]
[null,"Operating Margin",{"$f":"C39/C30","v":6.8965517241379309E-2},null,{"$f":"E39/E30","v":{"$error":"#DIV/0!"}},null,{"$f":"G39/G30","v":{"$error":"#DIV/0!"}},"Percentage operating margin "]
[null,"Cash Ratio",{"$f":"C145","v":0.2},null,{"$f":"E145","v":{"$error":"#DIV/0!"}},null,{"$f":"G145","v":{"$error":"#DIV/0!"}},"Ratio of cash and equivalents over current liabilities"]
[null,"Debt Ratio",{"$f":"C146","v":1.0504201680672269},null,{"$f":"E146","v":{"$error":"#DIV/0!"}},null,{"$f":"G146","v":{"$error":"#DIV/0!"}},"Ratio of liabilities (exc. Pension) over total Assets"]
[null,"Acid Ratio",{"$f":"C144","v":0.68},null,{"$f":"E144","v":{"$error":"#DIV/0!"}},null,{"$f":"G144","v":{"$error":"#DIV/0!"}},"Total current assets over Total current liabilities"]
[null,"Net Asset Value",{"$f":"C111","v":304},null,{"$f":"E111","v":0},null,{"$f":"G111","v":0},"Total assets minus total liabilities"]
[null,"Net Debt to EBITDA Ratio",{"$f":"C147","v":0.55970149253731338},null,{"$f":"E147","v":{"$error":"#DIV/0!"}},null,{"$f":"G147","v":{"$error":"#DIV/0!"}},"Net debt divided by EBITDA "]
[null,"Net Debt + Net Pension to EBITDA Ratio",{"$f":"C148","v":1.0074626865671641},null,{"$f":"E148","v":{"$error":"#DIV/0!"}},null,{"$f":"G148","v":{"$error":"#DIV/0!"}},"(Net debt add net pension liability) divided by EBITDA "]
[null,"Interest Cover ",{"$f":"C149","v":9.1999999999999993},null,{"$f":"E149","v":{"$error":"#DIV/0!"}},null,{"$f":"G149","v":{"$error":"#DIV/0!"}},"Earnings before interest and tax / net interest paid "]
[]
[]
[null,null,"2018/19",null,"2019/20",null,"2020/21"]
[null,null,"£'000",null,"£'000",null,"£'000"]
[]
[null,"Income/(Expenditure)"]
[]
[null,"Revenue ",1334,null,0,null,0]
[null,"Cost of sales",-1000,null,0,null,0]
[null,"Gross Profit",{"$f":"SUM(C30:C31)","v":334},null,{"$f":"SUM(E30:E31)","v":0},null,{"$f":"SUM(G30:G31)","v":0}]
[]
[null,"Other operating income/(expense)"]
[null,"Admin expenses ",-200,null,0,null,0]
[null,"Depreciation",-30,null,0,null,0]
[null,"Amortisation ",-12]
[null,"Other operating income/(expense)",0,null,0,null,0]
[null,"Operating Profit",{"$f":"SUM(C32:C38)","v":92},null,{"$f":"SUM(E32:E38)","v":0},null,{"$f":"SUM(G32:G38)","v":0}]
[]
[null,"Other income/(expense)"]
[null,"Interest paid ",-70,null,0,null,0]
[null,"Interest income ",60,null,0,null,0]
[null,"Other income/(expense)",0,null,0,null,0]
[null,"Profit Before Tax",{"$f":"SUM(C39:C44)","v":82},null,{"$f":"SUM(E39:E44)","v":0},null,{"$f":"SUM(G39:G44)","v":0}]
[]
[null,"Income (Tax)/Credit",-25,null,0,null,0]
[null,"Profit After Tax",{"$f":"SUM(C45:C47)","v":57},null,{"$f":"SUM(E45:E47)","v":0},null,{"$f":"SUM(G45:G47)","v":0}]
[]
[null,"Other comprehensive income/(expense) and dividends"]
[null,"Other comprehensive income",0,null,0,null,0]
[null,"Dividends",0,null,0,null,0]
[null,"Other",0,null,0,null,0]
[null,"Retained Profit",{"$f":"SUM(C48:C53)","v":57},null,{"$f":"SUM(E48:E53)","v":0},null,{"$f":"SUM(G48:G53)","v":0}]
[]
[null,"Headline Trends"]
[]
[null,"% Annual Revenue Growth",null,null,{"$f":"(E30/C30)-1","v":-1},null,{"$f":"(G30/E30)-1","v":{"$error":"#DIV/0!"}}]
[null,"% Annual Operating Profit Growth",null,null,{"$f":"(E39/C39)-1","v":-1},null,{"$f":"(G39/E39)-1","v":{"$error":"#DIV/0!"}}]
[null,"% Annual Profit Before Tax Growth ",null,null,{"$f":"(E45/C45)-1","v":-1},null,{"$f":"(G45/E45)-1","v":{"$error":"#DIV/0!"}}]
[]
[null,"Assets and Liabilities"]
[]
[null,"Non-current assets "]
[null,"Property, plant and equipment ",5,null,0,null,0]
[null,"Intangible assets ",7,null,0,null,0]
[null,"Investments ",2,null,0,null,0]
[null,"Trade and other receivables ",0,null,0,null,0]
[null,"Deferred tax assets",10,null,0,null,0]
[null,"Pension asset ",10,null,0,null,0]
[null,"Other non-current assets ",0,null,0,null,0]
[]
[null,"Total Non-Current Assets ",{"$f":"SUM(C65:C71)","v":34},null,{"$f":"SUM(E65:E71)","v":0},null,{"$f":"SUM(G65:G71)","v":0}]
[]
[null,"Current assets"]
[null,"Trade and other receivables ",50,null,0,null,0]
[null,"Investments ",10,null,0,null,0]
[null,"Cash and cash equivalents ",25,null,0,null,0]
[null,"Inventories ",10,null,0,null,0]
[null,"Other current assets ",0,null,0,null,0]
[]
[null,"Total Current Assets",{"$f":"SUM(C76:C80)","v":95},null,{"$f":"SUM(E76:E80)","v":0},null,{"$f":"SUM(G76:G80)","v":0}]
[]
[null,"Total Assets",{"$f":"SUM(C73,C82)","v":129},null,{"$f":"SUM(E73,E82)","v":0},null,{"$f":"SUM(G73,G82)","v":0}]
[]
[null,"Current liabilities "]
[null,"Trade and other payables ",0,null,0,null,0]
[null,"Provisions ",0,null,0,null,0]
[null,"Current tax payable",-15,null,0,null,0]
[null,"Deferred income ",0,null,0,null,0]
[null,"Bank overdraft",-10,null,0,null,0]
[null,"Intercompany borrowings ",-100,null,0,null,0]
[null,"External borrowings ",0,null,0,null,0]
[null,"Other current liabilities",0,null,0,null,0]
[]
[null,"Total Current Liabilities",{"$f":"SUM(C87:C94)","v":-125},null,{"$f":"SUM(E87:E94)","v":0},null,{"$f":"SUM(G87:G94)","v":0}]
[]
[null,"Non-current liabilities "]
[null,"Trade and other payables ",0,null,0,null,0]
[null,"Provisions ",0,null,0,null,0]
[null,"Intercompany borrowings ",0,null,0,null,0]
[null,"External borrowings ",0,null,0,null,0]
[null,"Employee benefits ",-50,null,0,null,0]
[null,"Deferred tax liabilities",0,null,0,null,0]
[null,"Other non-current liabilities ",0,null,0,null,0]
[]
[null,"Total Non-Current Liabilities",{"$f":"SUM(C99:C105)","v":-50},null,{"$f":"SUM(E99:E105)","v":0},null,{"$f":"SUM(G99:G105)","v":0}]
[]
[null,"Total Liabilities ",{"$f":"SUM(C96,C107)","v":-175},null,{"$f":"SUM(E96,E107)","v":0},null,{"$f":"SUM(G96,G107)","v":0}]
[]
[null,"Total Net Assets",{"$f":"C84-C109","v":304},null,{"$f":"E84-E109","v":0},null,{"$f":"G84-G109","v":0}]
[]
[]
[null,"Cash Flow and Liquidity"]
[]
[null,"Net Cash Flow From Operating Activities",0,null,0,null,0]
[]
[null,"Investing activities "]
[null,"Purchases of property, plant and equipment",0,null,0,null,0]
[null,"Proceeds from sale of property, plant and equipment",0,null,0,null,0]
[null,"Purchases of intangible assets ",0,null,0,null,0]
[null,"Other cash flows from investing activities ",0,null,0,null,0]
[]
[null,"Net Cash Flows From Investing Activities",{"$f":"SUM(C119:C122)","v":0},null,{"$f":"SUM(E119:E122)","v":0},null,{"$f":"SUM(G119:G122)","v":0}]
[]
[null,"Financing activities "]
[null,"Dividends paid ",0,null,0,null,0]
[null,"Repayment of borrowings",0,null,0,null,0]
[null,"Other cash flows from financing activities ",0,null,0,null,0]
[]
[null,"Net Cash Flows From Financing Activities",{"$f":"SUM(C127:C129)","v":0},null,{"$f":"SUM(E127:E129)","v":0},null,{"$f":"SUM(G127:G129)","v":0}]
[]
[null,"Net Increase/Decrease in Cash and Equivalents",{"$f":"SUM(C131,C124,C116)","v":0},null,{"$f":"SUM(E131,E124,E116)","v":0},null,{"$f":"SUM(G131,G124,G116)","v":0}]
[]
[null,"Cash and Equivalents Brought Forwards",0,null,0,null,0]
[]
[null,"Cash and Equivalents Carried Forwards",{"$f":"C135+C133","v":0},null,{"$f":"E135+E133","v":0},null,{"$f":"G135+G133","v":0}]
[]
[null,"Net Debt ",{"$f":"((C91+C92+C93+C101+C102)*-1)-(C78+C77)","v":75},null,{"$f":"((E91+E92+E93+E101+E102)*-1)-(E78+E77)","v":0},null,{"$f":"((G91+G92+G93+G101+G102)*-1)-(G78+G77)","v":0}]
[null,"Net Pension Deficit ",{"$f":"((C103*-1)+C70)","v":60},null,{"$f":"((E103*-1)+E70)","v":0},null,{"$f":"((G103*-1)+G70)","v":0}]
[null,"EBITDA ",{"$f":"(C39-C36-C37)","v":134},null,{"$f":"(E39-E36-E37)","v":0},null,{"$f":"(G39-G36-G37)","v":0}]
[]
[null,"Current Ratio",{"$f":"ABS(C82/C96)","v":0.76},null,{"$f":"ABS(E82/E96)","v":{"$error":"#DIV/0!"}},null,{"$f":"ABS(G82/G96)","v":{"$error":"#DIV/0!"}}]
[null,"Acid Ratio",{"$f":"(C82-C79)/(C96*-1)","v":0.68},null,{"$f":"(E82-E79)/(E96*-1)","v":{"$error":"#DIV/0!"}},null,{"$f":"(G82-G79)/(G96*-1)","v":{"$error":"#DIV/0!"}}]
[null,"Cash Ratio",{"$f":"ABS(C78/C96)","v":0.2},null,{"$f":"ABS(E78/E96)","v":{"$error":"#DIV/0!"}},null,{"$f":"ABS(G78/G96)","v":{"$error":"#DIV/0!"}}]
[null,"Debt Ratio (Excl. Pension Liabilities)",{"$f":"(((C109-C103)*-1))/(C84-C70)","v":1.0504201680672269},null,{"$f":"(((E109-E103)*-1))/(E84-E70)","v":{"$error":"#DIV/0!"}},null,{"$f":"(((G109-G103)*-1))/(G84-G70)","v":{"$error":"#DIV/0!"}}]
[null,"Net Debt to EBITDA Ratio",{"$f":"C139/C141","v":0.55970149253731338},null,{"$f":"E139/E141","v":{"$error":"#DIV/0!"}},null,{"$f":"G139/G141","v":{"$error":"#DIV/0!"}}]
[null,"Net Debt + Net Pension to EBITDA Ratio",{"$f":"(C139+C140)/C141","v":1.0074626865671641},null,{"$f":"(E139+E140)/E141","v":{"$error":"#DIV/0!"}},null,{"$f":"(G139+G140)/G141","v":{"$error":"#DIV/0!"}}]
[null,"Interest Cover ",{"$f":"C39/((C42+C43)*-1)","v":9.1999999999999993},null,{"$f":"E39/((E42+E43)*-1)","v":{"$error":"#DIV/0!"}},null,{"$f":"G39/((G42+G43)*-1)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Have these accounts been audited? (Yes/No)"]
[null,"Was the audit report modified? (Yes/No)"]
[null,"Are there any post balance sheet events that could be expected to materially alter the ratios above?  If so, please explain and manually adjust."]

{"sheet":"Template a Explanation","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Due Diligence - Financial Analysis Justification Template a"]
[]
[null,"Metric","Description","RAG Rating","Justification"]
[null,"Turnover Ratio",{"$f":"'Template b'!C12","v":"Ratio of  company turnover to grant size"},"R/A/G"]
[null,"Operating Margin",{"$f":"'Template b'!C13","v":"Percentage operating margin "},"R/A/G"]
[null,"Cash Ratio","Ratio of cash and equivalents over current liabilities","R/A/G"]
[null,"Debt Ratio",{"$f":"'Template b'!C15","v":"Ratio of liabilities (exc. Pension) over total Assets"},"R/A/G"]
[null,"Acid Ratio",{"$f":"'Template b'!C16","v":"Total current assets over Total current liabilities"},"R/A/G"]
[null,"Net Asset Value",{"$f":"'Template b'!C17","v":"Total assets minus total liabilities"},"R/A/G"]
[null,"Net Debt to EBITDA Ratio","Net debt divided by EBITDA ","R/A/G"]
[null,"Net Debt + Net Pension to EBITDA Ratio","(Net debt add net pension liability) divided by EBITDA ","R/A/G"]
[null,"Interest Cover ","Earnings before interest and tax / net interest paid ","R/A/G"]

{"sheet":"Not for Profit >>","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Template b","index":5,"n_rows":171,"n_cols":24,"rows_kept":171,"cut":false,"hidden":false,"merged":[[0,0,2,2],[19,2,19,5],[19,12,19,15],[19,7,19,10],[19,17,19,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v0.4"]
[]
[]
[]
["Charity Name:"]
["Date:"]
[]
[]
[null,"Approximate Annual Grant Value (£000s)",1000]
[null,"Approximate percentage share of partner",0.5,null,null,"RAG Rating",null,null,null,null,"RAG Rating",null,null,null,null,"RAG Rating"]
[null,null,null,null,null,"2018/19",null,null,null,null,"2019/20",null,null,null,null,"2020/21"]
[null,"Turnover Ratio","Ratio of  company turnover to grant size",null,null,{"$f":"F25/($C$9*$C$10)","v":0},null,null,null,null,{"$f":"K25/($C$9*$C$10)","v":0},null,null,null,null,{"$f":"P25/($C$9*$C$10)","v":0}]
[null,"Operating Margin","Percentage operating margin ",null,null,{"$f":"IF((F28/F25)-1<0,(F28/F25)+1,(F28/F25)-1)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF((K28/K25)-1<0,(K28/K25)+1,(K28/K25)-1)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF((P28/P25)-1<0,(P28/P25)+1,(P28/P25)-1)","v":{"$error":"#DIV/0!"}}]
[null,"Cash Ratio","Ratio of cash and equivalents over liabilities",null,null,{"$f":"F171","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"K171","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"P171","v":{"$error":"#DIV/0!"}}]
[null,"Debt Ratio","Ratio of liabilities (exc. Pension) over total Assets",null,null,{"$f":"F144","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"K144","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"P144","v":{"$error":"#DIV/0!"}}]
[null,"Current Acid Ratio","Total current assets over Total current liabilities",null,null,{"$f":"F169","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"K169","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"P169","v":{"$error":"#DIV/0!"}}]
[null,"Net Asset Value","Total assets minus total liabilities",null,null,{"$f":"F127","v":0},null,null,null,null,{"$f":"K127","v":0},null,null,null,null,{"$f":"P127","v":0}]
[]
[]
[null,null,"2018/19",null,null,null,null,"2019/20",null,null,null,null,"2020/21",null,null,null,null,"Total Funds"]
[null,null,"Unrestricted\n£'000","Designated\n£'000","Restricted\n£'000","Total Funds\n£'000",null,"Unrestricted\n£'000","Designated\n£'000","Restricted\n£'000","Total Funds\n£'000",null,"Unrestricted\n£'000","Designated\n£'000","Restricted\n£'000","Total Funds\n£'000",null,"Last Year Variance\n£'000","3 Year Variance\n£'000","3 Year Average\n£'000"]
[]
[null,"Headline Income/(Expenditure)"]
[]
[null,"Total Income",0,0,0,{"$f":"SUM(C25:E25)","v":0},null,0,0,0,{"$f":"SUM(H25:J25)","v":0},null,0,0,0,{"$f":"SUM(M25:O25)","v":0},null,{"$f":"P25-K25","v":0},{"$f":"P25-F25","v":0},{"$f":"AVERAGE(P25,K25,F25)","v":0}]
[null,"Total Expenditure",0,0,0,{"$f":"SUM(C26:E26)","v":0},null,0,0,0,{"$f":"SUM(H26:J26)","v":0},null,0,0,0,{"$f":"SUM(M26:O26)","v":0},null,{"$f":"P26-K26","v":0},{"$f":"P26-F26","v":0},{"$f":"AVERAGE(P26,K26,F26)","v":0}]
[]
[null,"Net Income/Expenditure",{"$f":"SUM(C25:C26)","v":0},{"$f":"SUM(D25:D26)","v":0},{"$f":"SUM(E25:E26)","v":0},{"$f":"SUM(C28:E28)","v":0},null,{"$f":"SUM(H25:H26)","v":0},{"$f":"SUM(I25:I26)","v":0},{"$f":"SUM(J25:J26)","v":0},{"$f":"SUM(H28:J28)","v":0},null,{"$f":"SUM(M25:M26)","v":0},{"$f":"SUM(N25:N26)","v":0},{"$f":"SUM(O25:O26)","v":0},{"$f":"SUM(M28:O28)","v":0},null,{"$f":"P28-K28","v":0},{"$f":"P28-F28","v":0},{"$f":"AVERAGE(P28,K28,F28)","v":0}]
[]
[null,"Taxation",0,0,0,{"$f":"SUM(C30:E30)","v":0},null,0,0,0,{"$f":"SUM(H30:J30)","v":0},null,0,0,0,{"$f":"SUM(M30:O30)","v":0},null,{"$f":"P30-K30","v":0},{"$f":"P30-F30","v":0},{"$f":"AVERAGE(P30,K30,F30)","v":0}]
[null,"Gains/Losses on Investments",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,{"$f":"P31-K31","v":0},{"$f":"P31-F31","v":0},{"$f":"AVERAGE(P31,K31,F31)","v":0}]
[null,"Other Gains/Losses",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,{"$f":"P32-K32","v":0},{"$f":"P32-F32","v":0},{"$f":"AVERAGE(P32,K32,F32)","v":0}]
[null,"Transfer Between Funds",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0]
[]
[null,"Net Movement in Funds",{"$f":"SUM(C30:C33,C28)","v":0},{"$f":"SUM(D30:D33,D28)","v":0},{"$f":"SUM(E30:E33,E28)","v":0},{"$f":"SUM(C35:E35)","v":0},null,{"$f":"SUM(H30:H33,H28)","v":0},{"$f":"SUM(I30:I33,I28)","v":0},{"$f":"SUM(J30:J33,J28)","v":0},{"$f":"SUM(H35:J35)","v":0},null,{"$f":"SUM(M30:M33,M28)","v":0},{"$f":"SUM(N30:N33,N28)","v":0},{"$f":"SUM(O30:O33,O28)","v":0},{"$f":"SUM(M35:O35)","v":0},null,{"$f":"P35-K35","v":0},{"$f":"P35-F35","v":0},{"$f":"AVERAGE(P35,K35,F35)","v":0}]
[]
[null,"Funds Brought Forwards",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(C37:E37)","v":{"$error":"#REF!"}},null,null,{"$f":"D39","v":{"$error":"#REF!"}},null,{"$f":"SUM(H37:J37)","v":{"$error":"#REF!"}},null,{"$f":"H39","v":0},{"$f":"I39","v":{"$error":"#REF!"}},{"$f":"J39","v":0},{"$f":"SUM(M37:O37)","v":{"$error":"#REF!"}},null,{"$f":"P37-K37","v":{"$error":"#REF!"}},{"$f":"P37-F37","v":{"$error":"#REF!"}},{"$f":"AVERAGE(P37,K37,F37)","v":{"$error":"#REF!"}}]
[null,"Net Movement in Funds",{"$f":"C35","v":0},0,0,0,null,{"$f":"H35","v":0},0,0,0,null,{"$f":"M35","v":0},0,0,0,null,0,0,0]
[null,"Funds Carried forwards",{"$f":"C37+C38","v":0},{"$f":"D37+D38","v":{"$error":"#REF!"}},{"$f":"E37+E38","v":0},{"$error":"#REF!"},null,{"$f":"H37+H38","v":0},{"$f":"I37+I38","v":{"$error":"#REF!"}},{"$f":"J37+J38","v":0},{"$error":"#REF!"},null,{"$f":"M37+M38","v":0},{"$f":"N37+N38","v":{"$error":"#REF!"}},{"$f":"O37+O38","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Net Inc/Exp as % of Total Income",{"$f":"C28/C25","v":{"$error":"#DIV/0!"}},{"$f":"D28/D25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"H28/H25","v":{"$error":"#DIV/0!"}},{"$f":"I28/I25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"M28/M25","v":{"$error":"#DIV/0!"}},{"$f":"N28/N25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"P41-K41","v":{"$error":"#DIV/0!"}},{"$f":"P41-F41","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P41,K41,F41)","v":{"$error":"#DIV/0!"}}]
[null,"Net Inc/Exp as % of Funds Carried",{"$f":"C28/C39","v":{"$error":"#DIV/0!"}},{"$f":"D28/D39","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,{"$f":"H28/H39","v":{"$error":"#DIV/0!"}},{"$f":"I28/I39","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,{"$f":"M28/M39","v":{"$error":"#DIV/0!"}},{"$f":"N28/N39","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Headline Trends"]
[]
[null,"% Annual Income Growth",{"$f":"(C25/#REF!)-1","v":{"$error":"#REF!"}},{"$f":"(D25/#REF!)-1","v":{"$error":"#REF!"}},{"$f":"(E25/#REF!)-1","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"(H25/C25)-1","v":{"$error":"#DIV/0!"}},{"$f":"(I25/D25)-1","v":{"$error":"#DIV/0!"}},{"$f":"(J25/E25)-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"(M25/H25)-1","v":{"$error":"#DIV/0!"}},{"$f":"(N25/I25)-1","v":{"$error":"#DIV/0!"}},{"$f":"(O25/J25)-1","v":{"$error":"#DIV/0!"}},{"$f":"(P25/K25)-1","v":{"$error":"#DIV/0!"}},null,{"$f":"P46-K46","v":{"$error":"#DIV/0!"}},{"$f":"P46-F46","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P46,K46,F46)","v":{"$error":"#DIV/0!"}}]
[null,"% Annual Expenditure Growth",{"$f":"(C26/#REF!)-1","v":{"$error":"#REF!"}},{"$f":"(D26/#REF!)-1","v":{"$error":"#REF!"}},{"$f":"(E26/#REF!)-1","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"(H26/C26)-1","v":{"$error":"#DIV/0!"}},{"$f":"(I26/D26)-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"(M26/H26)-1","v":{"$error":"#DIV/0!"}},{"$f":"(N26/I26)-1","v":{"$error":"#DIV/0!"}},{"$f":"(O26/J26)-1","v":{"$error":"#DIV/0!"}},{"$f":"(P26/K26)-1","v":{"$error":"#DIV/0!"}},null,{"$f":"P47-K47","v":{"$error":"#DIV/0!"}},{"$f":"P47-F47","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P47,K47,F47)","v":{"$error":"#DIV/0!"}}]
[null,"% Fund Growth",{"$f":"(C39/#REF!)-1","v":{"$error":"#REF!"}},{"$f":"(D39/#REF!)-1","v":{"$error":"#REF!"}},{"$f":"(E39/#REF!)-1","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"(H39/C39)-1","v":{"$error":"#DIV/0!"}},{"$f":"(I39/D39)-1","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,{"$f":"(M39/H39)-1","v":{"$error":"#DIV/0!"}},{"$f":"(N39/I39)-1","v":{"$error":"#REF!"}},{"$f":"(O39/J39)-1","v":{"$error":"#DIV/0!"}},{"$f":"(P39/K39)-1","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Income Review"]
[]
[null,"Fundraised Income",0,0,0,{"$f":"SUM(C52:E52)","v":0},null,0,0,0,{"$f":"SUM(H52:J52)","v":0},null,0,0,0,{"$f":"SUM(M52:O52)","v":0},null,{"$f":"P52-K52","v":0},{"$f":"P52-F52","v":0},{"$f":"AVERAGE(P52,K52,F52)","v":0}]
[null,"Other Voluntary Income",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,{"$f":"P53-K53","v":0},{"$f":"P53-F53","v":0},{"$f":"AVERAGE(P53,K53,F53)","v":0}]
[null,"Charitable Activities",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0]
[null,"Other Trading Activities",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0]
[null,"Investments",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0]
[null,"Other Income",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0]
[]
[null,"Total Income",{"$f":"SUM(C52:C57)","v":0},0,{"$f":"SUM(E52:E57)","v":0},{"$f":"SUM(C59:E59)","v":0},null,{"$f":"SUM(H52:H57)","v":0},{"$f":"SUM(I52:I57)","v":0},{"$f":"SUM(J52:J57)","v":0},0,null,{"$f":"SUM(M52:M57)","v":0},{"$f":"SUM(N52:N57)","v":0},{"$f":"SUM(O52:O57)","v":0},0,null,0,0,0]
[]
[null,"Income as % of Fund Income"]
[]
[null,"Fundraised Income",{"$f":"C52/C$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"H52/H$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"M52/M$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"P63-K63","v":{"$error":"#DIV/0!"}},{"$f":"P63-F63","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P63,K63,F63)","v":{"$error":"#DIV/0!"}}]
[null,"Other Voluntary Income",{"$f":"C53/C$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"P64-K64","v":{"$error":"#DIV/0!"}},{"$f":"P64-F64","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P64,K64,F64)","v":{"$error":"#DIV/0!"}}]
[null,"Charitable Activities",{"$f":"C54/C$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"F54/F$59","v":{"$error":"#DIV/0!"}},null,{"$f":"H54/H$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"K54/K$59","v":{"$error":"#DIV/0!"}},null,{"$f":"M54/M$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"P54/P$59","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Other Trading Activities",{"$f":"C55/C$59","v":{"$error":"#DIV/0!"}},{"$f":"D55/D$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"F55/F$59","v":{"$error":"#DIV/0!"}},null,{"$f":"H55/H$59","v":{"$error":"#DIV/0!"}},{"$f":"I55/I$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"K55/K$59","v":{"$error":"#DIV/0!"}},null,{"$f":"M55/M$59","v":{"$error":"#DIV/0!"}},{"$f":"N55/N$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P55/P$59","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Investments",{"$f":"C56/C$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"H56/H$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"M56/M$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Other Income",{"$f":"C57/C$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"H57/H$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"M57/M$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Fund Income as % of Total Income",{"$f":"C59/$K59","v":{"$error":"#DIV/0!"}},{"$f":"D59/$K59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"F59/$K59","v":{"$error":"#DIV/0!"}},null,{"$f":"H59/$K59","v":{"$error":"#DIV/0!"}},{"$f":"I59/$K59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"K59/$K59","v":{"$error":"#DIV/0!"}},null,{"$f":"M59/$P59","v":{"$error":"#DIV/0!"}},{"$f":"N59/$P59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"P70-K70","v":{"$error":"#DIV/0!"}},{"$f":"P70-F70","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P70,K70,F70)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Expenditure Review"]
[]
[null,"Fundraising Expenditure",0,0,0,{"$f":"SUM(C74:E74)","v":0},null,0,0,0,{"$f":"SUM(H74:J74)","v":0},null,0,0,0,{"$f":"SUM(M74:O74)","v":0},null,{"$f":"P74-K74","v":0},{"$f":"P74-F74","v":0},{"$f":"AVERAGE(P74,K74,F74)","v":0}]
[null,"Other 'Raising Funds' Expenditure",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0]
[null,"Charitable Activity Expenditure",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0]
[null,"Other Expenditure",0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,{"$f":"P77-K77","v":0},{"$f":"P77-F77","v":0},{"$f":"AVERAGE(P77,K77,F77)","v":0}]
[]
[null,"Total Expenditure",{"$f":"SUM(C74:C77)","v":0},{"$f":"SUM(D74:D77)","v":0},{"$f":"SUM(E74:E77)","v":0},{"$f":"SUM(C79:E79)","v":0},null,{"$f":"SUM(H74:H77)","v":0},{"$f":"SUM(I74:I77)","v":0},{"$f":"SUM(J74:J77)","v":0},0,null,{"$f":"SUM(M74:M77)","v":0},{"$f":"SUM(N74:N77)","v":0},{"$f":"SUM(O74:O77)","v":0},{"$f":"SUM(P74:P77)","v":0},null,0,0,0]
[]
[null,"Expenditure as % of Total Fund Expenditure"]
[]
[null,"Fundraising Expenditure",{"$f":"C74/C$79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"H74/H$79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"M74/M$79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"P83-K83","v":{"$error":"#DIV/0!"}},{"$f":"P83-F83","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P83,K83,F83)","v":{"$error":"#DIV/0!"}}]
[null,"Other 'Raising Funds' Expenditure",{"$f":"C75/C$79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGE(P84,K84,F84)","v":{"$error":"#DIV/0!"}}]
[null,"Charitable Activity Expenditure",{"$f":"C76/C$79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Other Expenditure",{"$f":"C77/C$79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"P86-K86","v":{"$error":"#DIV/0!"}},{"$f":"P86-F86","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P86,K86,F86)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Fund Expenditure as % of Total Expenditure",{"$f":"C79/$K79","v":{"$error":"#DIV/0!"}},{"$f":"D79/$K79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"H79/$K79","v":{"$error":"#DIV/0!"}},{"$f":"I79/$K79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"M79/$P79","v":{"$error":"#DIV/0!"}},{"$f":"N79/$P79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"P88-K88","v":{"$error":"#DIV/0!"}},{"$f":"P88-F88","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P88,K88,F88)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Fundraising Ratio",{"$f":"C52/C74","v":{"$error":"#DIV/0!"}},{"$f":"D52/D74","v":{"$error":"#DIV/0!"}},{"$f":"E52/E74","v":{"$error":"#DIV/0!"}},{"$f":"F52/F74","v":{"$error":"#DIV/0!"}},null,{"$f":"H52/H74","v":{"$error":"#DIV/0!"}},{"$f":"I52/I74","v":{"$error":"#DIV/0!"}},{"$f":"J52/J74","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"M52/M74","v":{"$error":"#DIV/0!"}},{"$f":"N52/N74","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"P90-K90","v":{"$error":"#DIV/0!"}},{"$f":"P90-F90","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P90,K90,F90)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Assets and Liabilities"]
[]
[null,"Tangible Fixed Assets",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P94-K94","v":0},{"$f":"P94-F94","v":0},{"$f":"AVERAGE(P94,K94,F94)","v":0}]
[null,"Intangible Fixed Assets",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[null,"Non-Current Asset Investments",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P96-K96","v":0},{"$f":"P96-F96","v":0},{"$f":"AVERAGE(P96,K96,F96)","v":0}]
[]
[null,"Total Fixed Assets",null,null,null,{"$f":"SUM(F94:F96)","v":0},null,null,null,null,{"$f":"SUM(K94:K96)","v":0},null,null,null,null,{"$f":"SUM(P94:P96)","v":0},null,{"$f":"P98-K98","v":0},{"$f":"P98-F98","v":0},{"$f":"AVERAGE(P98,K98,F98)","v":0}]
[]
[null,"Debtors",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P100-K100","v":0},{"$f":"P100-F100","v":0},{"$f":"AVERAGE(P100,K100,F100)","v":0}]
[null,"Current Asset Investments",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[null,"Other Current Assets",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[null,"Cash and Cash Equivalents",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P103-K103","v":0},{"$f":"P103-F103","v":0},{"$f":"AVERAGE(P103,K103,F103)","v":0}]
[]
[null,"Total Current Assets",null,null,null,{"$f":"SUM(F100:F103)","v":0},null,null,null,null,{"$f":"SUM(K100:K103)","v":0},null,null,null,null,{"$f":"SUM(P100:P103)","v":0},null,{"$f":"P105-K105","v":0},{"$f":"P105-F105","v":0},{"$f":"AVERAGE(P105,K105,F105)","v":0}]
[]
[null,"Total Assets",null,null,null,{"$f":"SUM(F98,F105)","v":0},null,null,null,null,{"$f":"SUM(K98,K105)","v":0},null,null,null,null,{"$f":"SUM(P98,P105)","v":0},null,{"$f":"P107-K107","v":0},{"$f":"P107-F107","v":0},{"$f":"AVERAGE(P107,K107,F107)","v":0}]
[]
[null,"Creditors: Amounts due within one year",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P109-K109","v":0},{"$f":"P109-F109","v":0},{"$f":"AVERAGE(P109,K109,F109)","v":0}]
[null,"Other Current Liabilities",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[]
[null,"Total Current Liabilities",null,null,null,{"$f":"SUM(F109:F110)","v":0},null,null,null,null,{"$f":"SUM(K109:K110)","v":0},null,null,null,null,{"$f":"SUM(P109:P110)","v":0},null,{"$f":"P112-K112","v":0},{"$f":"P112-F112","v":0},{"$f":"AVERAGE(P112,K112,F112)","v":0}]
[]
[null,"Creditors: Amounts falling due after one year",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P114-K114","v":0},{"$f":"P114-F114","v":0},{"$f":"AVERAGE(P114,K114,F114)","v":0}]
[null,"Other Non-Current Liabilities",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[]
[null,"Total Non-Current Liabilities",null,null,null,{"$f":"SUM(F114:F115)","v":0},null,null,null,null,{"$f":"SUM(K114:K115)","v":0},null,null,null,null,{"$f":"SUM(P114:P115)","v":0},null,{"$f":"P117-K117","v":0},{"$f":"P117-F117","v":0},{"$f":"AVERAGE(P117,K117,F117)","v":0}]
[]
[null,"Provisions",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P119-K119","v":0},{"$f":"P119-F119","v":0},{"$f":"AVERAGE(P119,K119,F119)","v":0}]
[]
[null,"Total Liabilities - Excluding Pension",null,null,null,{"$f":"SUM(F117,F112,F119)","v":0},null,null,null,null,{"$f":"SUM(K117,K112,K119)","v":0},null,null,null,null,{"$f":"SUM(P117,P112,P119)","v":0},null,{"$f":"P121-K121","v":0},{"$f":"P121-F121","v":0},{"$f":"AVERAGE(P121,K121,F121)","v":0}]
[]
[null,"Total Assets Less Liabilities - Excl. Pension",null,null,null,{"$f":"F107+F121","v":0},null,null,null,null,{"$f":"K107+K121","v":0},null,null,null,null,{"$f":"P107+P121","v":0},null,{"$f":"P123-K123","v":0},{"$f":"P123-F123","v":0},{"$f":"AVERAGE(P123,K123,F123)","v":0}]
[]
[null,"Pension Liability",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P125-K125","v":0},{"$f":"P125-F125","v":0},{"$f":"AVERAGE(P125,K125,F125)","v":0}]
[]
[null,"Total Net Assets",null,null,null,{"$f":"F123+F125","v":0},null,null,null,null,{"$f":"K123+K125","v":0},null,null,null,null,{"$f":"P123+P125","v":0},null,{"$f":"P127-K127","v":0},{"$f":"P127-F127","v":0},{"$f":"AVERAGE(P127,K127,F127)","v":0}]
[]
[null,"Total Funds",{"$f":"C39","v":0},{"$f":"D39","v":{"$error":"#REF!"}},{"$f":"E39","v":0},{"$f":"SUM(C129:E129)","v":{"$error":"#REF!"}},null,{"$f":"H39","v":0},{"$f":"I39","v":{"$error":"#REF!"}},{"$f":"J39","v":0},{"$f":"SUM(H129:J129)","v":{"$error":"#REF!"}},null,{"$f":"M39","v":0},{"$f":"N39","v":{"$error":"#REF!"}},{"$f":"O39","v":0},{"$f":"SUM(M129:O129)","v":{"$error":"#REF!"}},null,{"$f":"P129-K129","v":{"$error":"#REF!"}},{"$f":"P129-F129","v":{"$error":"#REF!"}},{"$f":"AVERAGE(P129,K129,F129)","v":{"$error":"#REF!"}}]
[]
[null,"Basic Reserves (Cur. Assets - Cur. Liabilities)",{"$f":"C105-C112","v":0},{"$f":"D105-D112","v":0},{"$f":"E105-E112","v":0},{"$f":"F105-F112","v":0},null,{"$f":"H105-H112","v":0},{"$f":"I105-I112","v":0},{"$f":"J105-J112","v":0},{"$f":"K105-K112","v":0},null,{"$f":"M105-M112","v":0},{"$f":"N105-N112","v":0},{"$f":"O105-O112","v":0},{"$f":"P105-P112","v":0},null,{"$f":"P131-K131","v":0},{"$f":"P131-F131","v":0},{"$f":"AVERAGE(P131,K131,F131)","v":0}]
[]
[null,"Months of Fund Expenditure Held",{"$f":"C131/(C26/12)","v":{"$error":"#DIV/0!"}},{"$f":"D131/(D26/12)","v":{"$error":"#DIV/0!"}},{"$f":"E131/(E26/12)","v":{"$error":"#DIV/0!"}},{"$f":"ABS(F131/(F26/12))","v":{"$error":"#DIV/0!"}},null,{"$f":"H131/(H26/12)","v":{"$error":"#DIV/0!"}},{"$f":"I131/(I26/12)","v":{"$error":"#DIV/0!"}},{"$f":"J131/(J26/12)","v":{"$error":"#DIV/0!"}},{"$f":"ABS(K131/(K26/12))","v":{"$error":"#DIV/0!"}},null,{"$f":"M131/(M26/12)","v":{"$error":"#DIV/0!"}},{"$f":"N131/(N26/12)","v":{"$error":"#DIV/0!"}},{"$f":"O131/(O26/12)","v":{"$error":"#DIV/0!"}},{"$f":"P131/(P26/12)","v":{"$error":"#DIV/0!"}},null,{"$f":"P133-K133","v":{"$error":"#DIV/0!"}},{"$f":"P133-F133","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P133,K133,F133)","v":{"$error":"#DIV/0!"}}]
[null,"Months of Total Expenditure Held",{"$f":"C131/($K26/12)","v":{"$error":"#DIV/0!"}},{"$f":"D131/($K26/12)","v":{"$error":"#DIV/0!"}},{"$f":"E131/($K26/12)","v":{"$error":"#DIV/0!"}},{"$f":"ABS(F131/($F26/12))","v":{"$error":"#DIV/0!"}},null,{"$f":"H131/($K26/12)","v":{"$error":"#DIV/0!"}},{"$f":"I131/($K26/12)","v":{"$error":"#DIV/0!"}},{"$f":"J131/($K26/12)","v":{"$error":"#DIV/0!"}},{"$f":"ABS(K131/($F26/12))","v":{"$error":"#DIV/0!"}},null,{"$f":"M131/($P26/12)","v":{"$error":"#DIV/0!"}},{"$f":"N131/($P26/12)","v":{"$error":"#DIV/0!"}},{"$f":"O131/($P26/12)","v":{"$error":"#DIV/0!"}},{"$f":"P131/($P26/12)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Unrestricted Reserves as % of total",null,null,null,{"$f":"C131/F131","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"H131/K131","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"M131/P131","v":{"$error":"#DIV/0!"}},null,{"$f":"P136-K136","v":{"$error":"#DIV/0!"}},{"$f":"P136-F136","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P136,K136,F136)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Free Reserves (Exc. Designated Funds)",null,null,null,{"$f":"F129-SUM(D129:E129)-C98","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"K129-SUM(I129:J129)-H98","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"P129-SUM(N129:O129)-M98","v":{"$error":"#REF!"}},null,{"$f":"P138-K138","v":{"$error":"#REF!"}},{"$f":"P138-F138","v":{"$error":"#REF!"}},{"$f":"AVERAGE(P138,K138,F138)","v":{"$error":"#REF!"}}]
[]
[null,"Months Unrestricted Exp. Held in Free Reserves",null,null,null,{"$f":"ABS(F138/(C26/12))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"ABS(K138/(H26/12))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"ABS(P138/(M26/12))","v":{"$error":"#REF!"}},null,{"$f":"P140-K140","v":{"$error":"#REF!"}},{"$f":"P140-F140","v":{"$error":"#REF!"}},{"$f":"AVERAGE(P140,K140,F140)","v":{"$error":"#REF!"}}]
[]
[null,"Months Total Exp. Held in Free Reserves",null,null,null,{"$f":"ABS(F138/(F26/12))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"ABS(K138/(K26/12))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"ABS(P138/(P26/12))","v":{"$error":"#REF!"}},null,{"$f":"P142-K142","v":{"$error":"#REF!"}},{"$f":"P142-F142","v":{"$error":"#REF!"}},{"$f":"AVERAGE(P142,K142,F142)","v":{"$error":"#REF!"}}]
[]
[null,"Debt Ratio (Excl. Pension Liabilities)",null,null,null,{"$f":"ABS(F121/F107)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"ABS(K121/K107)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"ABS(P121/P107)","v":{"$error":"#DIV/0!"}},null,{"$f":"P144-K144","v":{"$error":"#DIV/0!"}},{"$f":"P144-F144","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P144,K144,F144)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Cash Flow and Liquidity"]
[]
[null,"Net Cash Flow From Operating Activities",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P148-K148","v":0},{"$f":"P148-F148","v":0},{"$f":"AVERAGE(P148,K148,F148)","v":0}]
[]
[null,"Interest Receivable",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P150-K150","v":0},{"$f":"P150-F150","v":0},{"$f":"AVERAGE(P150,K150,F150)","v":0}]
[null,"Purchase of Tangible Fixed Assets",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[null,"Proceeds From Sale of Tangible Fixed Assets",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[null,"Other Cash Flows from Investing Activities",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[]
[null,"Net Cash Flows From Investing Activities",null,null,null,{"$f":"SUM(F150:F153)","v":0},null,null,null,null,{"$f":"SUM(K150:K153)","v":0},null,null,null,null,{"$f":"SUM(P150:P153)","v":0},null,{"$f":"P155-K155","v":0},{"$f":"P155-F155","v":0},{"$f":"AVERAGE(P155,K155,F155)","v":0}]
[]
[null,"Cash Inflows From Borrowing",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P157-K157","v":0},{"$f":"P157-F157","v":0},{"$f":"AVERAGE(P157,K157,F157)","v":0}]
[null,"Repayment of Borrowings",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[null,"Other Cash Flows From Financing Activities",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[]
[null,"Net Cash Flows From Financing Activities",null,null,null,{"$f":"SUM(F157:F159)","v":0},null,null,null,null,{"$f":"SUM(K157:K159)","v":0},null,null,null,null,{"$f":"SUM(P157:P159)","v":0},null,{"$f":"P161-K161","v":0},{"$f":"P161-F161","v":0},{"$f":"AVERAGE(P161,K161,F161)","v":0}]
[]
[null,"Net Increase/Decrease in Cash and Equivalents",null,null,null,{"$f":"SUM(F161,F155,F148)","v":0},null,null,null,null,{"$f":"SUM(K161,K155,K148)","v":0},null,null,null,null,{"$f":"SUM(P161,P155,P148)","v":0},null,{"$f":"P163-K163","v":0},{"$f":"P163-F163","v":0},{"$f":"AVERAGE(P163,K163,F163)","v":0}]
[]
[null,"Cash and Equivalents Brought Forwards",null,null,null,{"$f":"A167","v":0},null,null,null,null,{"$f":"F167","v":0},null,null,null,null,{"$f":"K167","v":0},null,{"$f":"P165-K165","v":0},{"$f":"P165-F165","v":0},{"$f":"AVERAGE(P165,K165,F165)","v":0}]
[]
[null,"Cash and Equivalents Carried Forwards",null,null,null,{"$f":"F165+F163","v":0},null,null,null,null,{"$f":"K165+K163","v":0},null,null,null,null,{"$f":"P165+P163","v":0},null,{"$f":"P167-K167","v":0},{"$f":"P167-F167","v":0},{"$f":"AVERAGE(P167,K167,F167)","v":0}]
[]
[null,"Current Ratio",null,null,null,{"$f":"ABS(F105/F112)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"ABS(K105/K112)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"ABS(P105/P112)","v":{"$error":"#DIV/0!"}},null,{"$f":"P169-K169","v":{"$error":"#DIV/0!"}},{"$f":"P169-F169","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P169,K169,F169)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Cash Ratio",null,null,null,{"$f":"ABS(F103/F112)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"ABS(K103/K112)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"ABS(P103/P112)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Template b Explanation","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Due Diligence - Financial Analysis Justification Template b"]
[]
[null,"Metric","Description","RAG Rating","Justification"]
[null,{"$f":"'Template b'!B12","v":"Turnover Ratio"},{"$f":"'Template b'!C12","v":"Ratio of  company turnover to grant size"},"R/A/G"]
[null,{"$f":"'Template b'!B13","v":"Operating Margin"},{"$f":"'Template b'!C13","v":"Percentage operating margin "},"R/A/G"]
[null,{"$f":"'Template b'!B14","v":"Cash Ratio"},{"$f":"'Template b'!C14","v":"Ratio of cash and equivalents over liabilities"},"R/A/G"]
[null,{"$f":"'Template b'!B15","v":"Debt Ratio"},{"$f":"'Template b'!C15","v":"Ratio of liabilities (exc. Pension) over total Assets"},"R/A/G"]
[null,{"$f":"'Template b'!B16","v":"Current Acid Ratio"},{"$f":"'Template b'!C16","v":"Total current assets over Total current liabilities"},"R/A/G"]
[null,{"$f":"'Template b'!B17","v":"Net Asset Value"},{"$f":"'Template b'!C17","v":"Total assets minus total liabilities"},"R/A/G"]
[null,"Other"]

{"sheet":"Supporting Information >>","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Template Checklist","index":8,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[33,1,37,1],[1,1,1,3],[4,1,6,1],[7,1,16,1],[17,1,18,1],[19,1,24,1],[25,1,32,1]]}
[]
[null,"Due Diligence - Financial Analysis Checklist"]
[]
[null,"Area","Consideration","Further Detail","Finding","Potential Risk Area? (Y/N)"]
[null,"Headline Income/Expenditure","What has the organisation's end of year position been over the last three years? How do restricted and unrestricted funds compare?","Surplus or deficit? Fluctuating or consistent? Trend in either direction? Any consistent deficit in unrestricted funds warrants further investigation."]
[null,null,"Is the end of year position significant as a % of income, or as a % of reserves for each fund?","Significant surplus may indicate an inability to scale operational activity to match fundraising, or vice versa. A consistent deficit need not necessarily be concerning if it is of little consequence in the grand scheme."]
[null,null,"If the surplus/deficit position is significant, is there reasonable justification?","Potential justifications such as a deliberate deficit to reduce reserves, or that the organisation is accumulating funds for capital expenditure."]
[null,"Review of Income","Is income consistently dominated by one stream, or split across multiple areas?","What is the % split across voluntary, generated, investment, and income from activities? How has this varied over the last three years?"]
[null,null,"How reliable are the organisation's income streams?","Does the % contribution of each stream fluctuate significantly each year?  Are streams secure in the medium/long term, or at risk of withdrawal (government cuts, grant income reliant on conditions that cannot be met etc.)"]
[null,null,"Are there trends across income streams over the last three years?","Has the organisation's income seen a concerted shift in any particular direction? A shift towards trading activities makes forecasting considerably more difficult, an increase in grants may provide security in the short term, but may be limited to restricted funding, leaving core costs vulnerable."]
[null,null,"What percentage of income is from statutory sources? Is this income at risk from changes in policy?","Is statutory funding in the form of a grant or payment for services? If payment for services then how secure are the service level agreements? How regularly are the agreements refreshed? Is funding reliant on achievement, and therefore vulnerable if conditions are not met? If a grant then what is the duration? Is the source of the funding itself vulnerable?"]
[null,null,"What percentage of income is generated, i.e. from fundraising activities or investment?","To what extent is the organisation self sufficient? How heavily is it reliant on other funding streams? If the most vulnerable funding streams were to fall away then what would the organisation's position be?"]
[null,null,"What percentage of income is from legacies?","Legacies can provide a significant income stream, but one that is highly unreliable. A string of high value legacies can distort income figures in the short term. "]
[null,null,"What percentage of income is made up of gifts in kind?","Are any of these gifts in kind vulnerable to withdrawal? How would this affect the cost base of the charity?"]
[null,null,"What percentage of income is restricted vs unrestricted?","Low levels of unrestricted income may leave the organisation unable to sufficiently cover core costs. This can have a significant impact on its effectiveness, and its ability to respond to emerging risks and opportunities."]
[null,null,"Does the organisation have a profitable income stream?","If so is the margin significant? What is the overall trend in the margin? Has income from this stream increased or decreased in recent year, and has the margin remained the same throughout?"]
[null,null,"Seek to understand the nature of any transfers between funds.","Significant transfers from restricted to unrestricted funds may be cause for concern, however are justifiable in some circumstances such as if the restricted funding includes a cut to cover core costs. If the transfer is not justifiable then the organisation may be in breach of trust. Equally transfers between different restricted funds may be concerning. "]
[null,"Review of Expenditure","What percentage of expenditure is on charitable activities?","It is expected that the majority of expenditure (~80%) should be on charitable activities. If this is not the case then you should seek to understand why."]
[null,null,"What is the rate of return for fundraising expenditure?","Donated income from non-fundraising responsive activities should be excluded where possible. This may include donations from subsidiaries, legacies if not actively sought etc."]
[null,"Reserves","Does the organisation maintain a reserves policy requiring at least 3 months ongoing expenditure to be held? Does the organisation confirm whether this policy is being met? ","3 months  would be considered a minimum acceptable position, more than a year may be excessive without justification (capital appeal or endowment). The key consideration here is \"ongoing\" expenditure. This would include all core costs, and charitable activity supported by the organisation itself. Expenditure the organisation carries out on behalf of another party (i.e. disseminating grant funding (Motability's former SVF)) should be separated if possible, as when funding ceases the grants programme immediately ends. Care should be taken to still consider staff costs associated with the program however, as these costs may well continue in the short term."]
[null,null,"What has the trend in the reserves position been over the last three years?","Any significant trends should be justified, reserves should also increase in line with core activity if the charity is in a period of growth."]
[null,null,"How many months of expenditure are held in reserves?","(Current Assets + Realisable Investments - Current Liabilities)/Average Monthly Expenditure\n\nConsider the above as to what can be classified as average monthly expenditure."]
[null,null,"What proportion of these reserves are restricted vs unrestricted, compared to the proportion of ongoing expenditure?","High levels of restricted reserves may not reflect stability if unrestricted reserves cannot cover core costs."]
[null,null,"What is the organisation's level of free reserves?","Total funds less restricted funds, endowments, fixed assets, and potentially designated funds depending on the designation. Consider carefully the makeup of the free reserves in question, a predominance of debtors and lack of cash at bank may indicate an inability to meet its short-term liabilities. Also bear in mind that while fixed assets are excluded, any borrowing associated with that asset is included, which can turn free reserves negative."]
[null,null,"Does the organisation have pension fund liabilities?","If so, it may be appropriate to subtract the deficit from the numerator of the reserves calculation."]
[null,"Assets and Liabilities","What is the relative split of asset types?","Land, buildings and equipment, fixed asset investments, debtors, cash at bank etc. If significant fixed assets held in the form of land or buildings, have these been utilised appropriately to generate income?"]
[null,null,"Is the return on cash and investments reasonable?","Income from investments/(Cash + Investments)\n\nShould be slightly above current bank rate, significantly more may indicate excessive level of risk, significantly less may equally require further investigation."]
[null,null,"Has there been a trend in short term liabilities over the last three years?","Increasing in proportion with other activities? Increasing with a decrease in activity?"]
[null,null,"Compare the organisation's current and cash ratios.","Current Ratio = Current Assets/Current Liabilities, Cash Ratio = Cash and Equivalents/Current Liabilities\n\nRatios will differ considerably with circumstances/operating model, so a versus-self multi-year comparison is most informative. Cash ratio is more conservative liquidity measure, difference between the two highlights potential reliance on non-cash current assets such as debtors. "]
[null,null,"What is the organisation's debt ratio?","Total liabilities/Total assets\n\nA higher ratio indicates a less robust organisation, any ratio more than 1 shows that the organisation is entirely unable to cover the costs of its liabilities."]
[null,null,"Are any long term liabilities made up of Social Investments?","If so seek to better understand the terms. Is this a loan or a bond? Who is the investor? Is this mixed motive or programme related investment?"]
[null,null,"Does the organisation have significant pension liabilities?","Does the organisation lay out how it intends to address these liabilities over the long term? Has action been taken already (increased contribution rates, closing the defined benefit scheme to new members, closing the scheme to future accrual)?"]
[null,null,"Consider whether the fixed assets turnover ratio can be utilised.","Income from trading or generated income/Fixed assets\n\nConsider appropriateness carefully - if in doubt consult with Finance. Potentially useful with modification to assess effective utilisation of new fixed assets. E.g. \"Journeys provided/fixed assets\" for a CT operator that has invested in additional vehicles."]
[null,"Cash Flow and Liquidity","What was the overall movement in cash and cash equivalents (This year and over the last three years)?","Seek to understand further any overall trend in the cash position over the last three years."]
[null,null,"What is the balance of cash and cash equivalents available across fund types?","Lack of unrestricted cash and equivalents poses a considerable risk to the core operations of an organisation."]
[null,null,"What is the impact of the purchase/sale of fixed assets on cash flow?","Has cash flow been generated from the sale of fixed assets? Are these assets being replaced? Using the sale of fixed assets to generate cash for operational expenditure is a potential red flag."]
[null,null,"Is the organisation covering short term cash requirements through financing?","Consistent use of financing activity to generate cash suggests an issue with short-term cash flow."]
[null,null,"Do the organisation's management accounts indicate either concentrated income or expenditure over specific periods that may pose a cash flow problem?","If the primary form of income is grants, all of which are provided at the beginning of the calendar year, then cash flow in other months may prove problematic. Compare any short term deficit figures to the overall cash and cash equivalents available."]

{"sheet":"Template b Worked Example","index":9,"n_rows":159,"n_cols":24,"rows_kept":159,"cut":false,"hidden":false,"merged":[[0,0,2,2],[7,2,7,5],[7,7,7,10],[7,12,7,15],[7,17,7,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v0.4"]
[]
[]
[]
["Charity Name:","Motability "]
["Date:","2020-06-25"]
[]
[null,null,"2016/17",null,null,null,null,"2017/18",null,null,null,null,"2018/19",null,null,null,null,"Total Funds"]
[null,null,"Unrestricted\n£'000","Designated\n£'000","Restricted\n£'000","Total Funds\n£'000",null,"Unrestricted\n£'000","Designated\n£'000","Restricted\n£'000","Total Funds\n£'000",null,"Unrestricted\n£'000","Designated\n£'000","Restricted\n£'000","Total Funds\n£'000",null,"Last Year Variance\n£'000","3 Year Variance\n£'000","3 Year Average\n£'000"]
[]
[null,"Headline Income/Expenditure"]
[]
[null,"Total Income",32243,0,21082,{"$f":"SUM(C13:E13)","v":53325},null,48881,0,23243,{"$f":"SUM(H13:J13)","v":72124},null,407490,0,21184,{"$f":"SUM(M13:O13)","v":428674},null,{"$f":"P13-K13","v":356550},{"$f":"P13-F13","v":375349},{"$f":"AVERAGE(P13,K13,F13)","v":184707.66666666666}]
[null,"Total Expenditure",-12192,0,-106342,{"$f":"SUM(C14:E14)","v":-118534},null,-7391,0,-17807,{"$f":"SUM(H14:J14)","v":-25198},null,-21195,0,-16145,{"$f":"SUM(M14:O14)","v":-37340},null,{"$f":"P14-K14","v":-12142},{"$f":"P14-F14","v":81194},{"$f":"AVERAGE(P14,K14,F14)","v":-60357.333333333336}]
[]
[null,"Net Income/Expenditure",{"$f":"SUM(C13:C14)","v":20051},{"$f":"SUM(D13:D14)","v":0},{"$f":"SUM(E13:E14)","v":-85260},{"$f":"SUM(C16:E16)","v":-65209},null,{"$f":"SUM(H13:H14)","v":41490},{"$f":"SUM(I13:I14)","v":0},{"$f":"SUM(J13:J14)","v":5436},{"$f":"SUM(H16:J16)","v":46926},null,{"$f":"SUM(M13:M14)","v":386295},{"$f":"SUM(N13:N14)","v":0},{"$f":"SUM(O13:O14)","v":5039},{"$f":"SUM(M16:O16)","v":391334},null,{"$f":"P16-K16","v":344408},{"$f":"P16-F16","v":456543},{"$f":"AVERAGE(P16,K16,F16)","v":124350.33333333333}]
[]
[null,"Taxation",0,0,0,{"$f":"SUM(C18:E18)","v":0},null,0,0,0,{"$f":"SUM(H18:J18)","v":0},null,0,0,0,{"$f":"SUM(M18:O18)","v":0},null,{"$f":"P18-K18","v":0},{"$f":"P18-F18","v":0},{"$f":"AVERAGE(P18,K18,F18)","v":0}]
[null,"Gains/Losses on Investments",0,0,0,0,null,-993,0,-1610,-2603,null,424,0,-725,-301,null,{"$f":"P19-K19","v":2302},{"$f":"P19-F19","v":-301},{"$f":"AVERAGE(P19,K19,F19)","v":-968}]
[null,"Other Gains/Losses",0,0,790,790,null,0,0,1798,1798,null,0,0,-1662,-1662,null,-3460,-2452,308.66666666666669]
[null,"Transfer Between Funds",0,0,0,0,null,0,0,0,0,null,-1891,0,1891,0,null,0,0,0]
[]
[null,"Net Movement in Funds",{"$f":"SUM(C18:C21,C16)","v":20051},{"$f":"SUM(D18:D21,D16)","v":0},{"$f":"SUM(E18:E21,E16)","v":-84470},{"$f":"SUM(C23:E23)","v":-64419},null,{"$f":"SUM(H18:H21,H16)","v":40497},{"$f":"SUM(I18:I21,I16)","v":0},{"$f":"SUM(J18:J21,J16)","v":5624},{"$f":"SUM(H23:J23)","v":46121},null,{"$f":"SUM(M18:M21,M16)","v":384828},{"$f":"SUM(N18:N21,N16)","v":0},{"$f":"SUM(O18:O21,O16)","v":4543},{"$f":"SUM(M23:O23)","v":389371},null,{"$f":"P23-K23","v":343250},{"$f":"P23-F23","v":453790},{"$f":"AVERAGE(P23,K23,F23)","v":123691}]
[]
[null,"Funds Brought Forwards",874,0,126449,{"$f":"SUM(C25:E25)","v":127323},null,{"$f":"C27","v":20925},{"$f":"D27","v":0},{"$f":"E27","v":41979},{"$f":"SUM(H25:J25)","v":62904},null,{"$f":"H27","v":61422},{"$f":"I27","v":0},{"$f":"J27","v":47603},{"$f":"SUM(M25:O25)","v":109025},null,{"$f":"P25-K25","v":46121},{"$f":"P25-F25","v":-18298},{"$f":"AVERAGE(P25,K25,F25)","v":99750.666666666672}]
[null,"Net Movement in Funds",{"$f":"C23","v":20051},{"$f":"D23","v":0},-84470,-64419,null,{"$f":"H23","v":40497},0,5624,46121,null,{"$f":"M23","v":384828},0,4543,389371,null,343250,453790,123691]
[null,"Funds Carried forwards",{"$f":"C25+C26","v":20925},{"$f":"D25+D26","v":0},{"$f":"E25+E26","v":41979},{"$f":"F25+F26","v":62904},null,{"$f":"H25+H26","v":61422},{"$f":"I25+I26","v":0},{"$f":"J25+J26","v":47603},109025,null,{"$f":"M25+M26","v":446250},{"$f":"N25+N26","v":0},{"$f":"O25+O26","v":52146},498396,null,389371,435492,223441.66666666666]
[]
[null,"Net Inc/Exp as % of Total Income",{"$f":"C16/C13","v":0.62187141395031476},{"$f":"D16/D13","v":{"$error":"#DIV/0!"}},-4.0442083293805142,-1.2228598218471636,null,{"$f":"H16/H13","v":0.8487960557271742},{"$f":"I16/I13","v":{"$error":"#DIV/0!"}},0.23387686615325043,0.65062947146580885,null,{"$f":"M16/M13","v":0.94798645365530443},{"$f":"N16/N13","v":{"$error":"#DIV/0!"}},0.23786820241691842,0.91289418065942884,null,{"$f":"P29-K29","v":0.26226470919361999},{"$f":"P29-F29","v":2.1357540025065926},{"$f":"AVERAGE(P29,K29,F29)","v":0.11355461009269141}]
[null,"Net Inc/Exp as % of Funds Carried",{"$f":"C16/C27","v":0.95823178016726407},{"$f":"D16/D27","v":{"$error":"#DIV/0!"}},-2.0310155077538767,-1.0366431387511128,null,{"$f":"H16/H27","v":0.67549086646478462},{"$f":"I16/I27","v":{"$error":"#DIV/0!"}},0.1141944835409533,0.43041504242146295,null,{"$f":"M16/M27","v":0.86564705882352944},{"$f":"N16/N27","v":{"$error":"#DIV/0!"}},9.6632531737813068E-2,0.78518687950946642,null,0.35477183708800347,1.8218300182605791,5.9652927726605499E-2]
[]
[null,"Headline Trends"]
[]
[null,"% Annual Income Growth",{"$f":"(32243-2737)/2737","v":10.78041651443186},0,{"$f":"(21082-64396)/64396","v":-0.67261941735511521},{"$f":"(53325-67133)/67133","v":-0.20568125958917374},null,{"$f":"(H13/C13)-1","v":0.51601898086406361},{"$f":"(I13/D13)-1","v":{"$error":"#DIV/0!"}},{"$f":"(J13/E13)-1","v":0.10250450621383167},0.35253633380215654,null,{"$f":"(M13/H13)-1","v":7.3363679139133815},{"$f":"(N13/I13)-1","v":{"$error":"#DIV/0!"}},{"$f":"(O13/J13)-1","v":-8.858581078174077E-2},{"$f":"(P13/K13)-1","v":4.9435694082413617},null,{"$f":"P34-K34","v":4.5910330744392054},{"$f":"P34-F34","v":5.1492506678305352},{"$f":"AVERAGE(P34,K34,F34)","v":1.6968081608181149}]
[null,"% Annual Expenditure Growth",{"$f":"(12192-29848)/2984","v":-5.9168900804289546},0,{"$f":"(106342-63100)/63100","v":0.68529318541996831},{"$f":"(118534-66084)/66084","v":0.79368682283154768},null,{"$f":"(H14/C14)-1","v":-0.39378280839895008},{"$error":"#DIV/0!"},-0.83254969814372493,-0.78741964330909275,null,{"$f":"(M14/H14)-1","v":1.8676769043431198},{"$f":"(N14/I14)-1","v":{"$error":"#DIV/0!"}},{"$f":"(O14/J14)-1","v":-9.3334082102543903E-2},{"$f":"(P14/K14)-1","v":0.48186363997142623},null,1.269283283280519,-0.31182318286012145,0.16271027316462705]
[null,"% Fund Growth",{"$f":"(20925-874)/874","v":22.941647597254004},0,{"$f":"(41979-126449)/126449","v":-0.66801635441956841},{"$f":"(62904-127323)/127323","v":-0.50594943568718931},null,{"$f":"(H27/C27)-1","v":1.9353405017921146},{"$f":"(I27/D27)-1","v":{"$error":"#DIV/0!"}},0.13397174777865128,0.73319661706727701,null,{"$f":"(M27/H27)-1","v":6.265312103155221},{"$f":"(N27/I27)-1","v":{"$error":"#DIV/0!"}},9.5435161649475964E-2,3.5713918825957345,null,2.8381952655284577,4.0773413182829241,1.266213021325274]
[]
[null,"Income Review"]
[]
[null,"Fundraised Income",1329,0,2073,{"$f":"SUM(C40:E40)","v":3402},null,464,0,24,{"$f":"SUM(H40:J40)","v":488},null,97,0,15,{"$f":"SUM(M40:O40)","v":112},null,{"$f":"P40-K40","v":-376},{"$f":"P40-F40","v":-3290},{"$f":"AVERAGE(P40,K40,F40)","v":1334}]
[null,"Other Voluntary Income",30000,0,6827,36827,null,46793,0,11762,58555,null,405052,0,10345,415397,null,356842,378570,170259.66666666666]
[null,"Charitable Activities",0,0,9750,9750,null,0,0,9440,9440,null,0,0,9334,9334,null,-106,-416,9508]
[null,"Other Trading Activities",908,0,0,908,null,546,0,0,546,null,540,0,0,540,null,-6,-368,664.66666666666663]
[null,"Investments",6,0,2423,2429,null,1078,0,2017,3095,null,1801,0,1482,3283,null,188,854,2935.6666666666665]
[null,"Other Income",0,0,9,9,null,0,0,0,0,null,0,0,8,8,null,8,-1,5.666666666666667]
[]
[null,"Total Income",{"$f":"SUM(C40:C45)","v":32243},0,{"$f":"SUM(E40:E45)","v":21082},53325,null,{"$f":"SUM(H40:H45)","v":48881},0,{"$f":"SUM(J40:J45)","v":23243},72124,null,{"$f":"SUM(M40:M45)","v":407490},0,{"$f":"SUM(O40:O45)","v":21184},428674,null,356550,375349,184707.66666666666]
[]
[null,"Income as % of Fund Income"]
[]
[null,"Fundraised Income",{"$f":"C40/C$47","v":4.1218248922246688E-2},{"$error":"#DIV/0!"},9.8330329190778859E-2,6.3797468354430384E-2,null,{"$f":"H40/H$47","v":9.4924408256786899E-3},{"$error":"#DIV/0!"},1.0325689454889644E-3,6.7661250069325054E-3,null,{"$f":"M40/M$47","v":2.3804265135340746E-4},{"$error":"#DIV/0!"},7.0808157099697881E-4,2.6127080252126323E-4,null,{"$f":"P51-K51","v":-6.5048542044112423E-3},{"$f":"P51-F51","v":-6.3536197551909118E-2},{"$f":"AVERAGE(P51,K51,F51)","v":2.3608288054628054E-2}]
[null,"Other Voluntary Income",0.93043451291753254,{"$error":"#DIV/0!"},0.32383075609524714,0.69061415846225971,null,0.95728401628444593,{"$error":"#DIV/0!"},0.50604483070171669,0.81186567578060009,null,0.99401703109278761,{"$error":"#DIV/0!"},0.48834025679758308,0.96902774602611774,null,0.15716207024551765,0.27841358756385803,0.82383586008965926]
[null,"Charitable Activities",{"$f":"C42/C$47","v":0},{"$error":"#DIV/0!"},0.46247984062233183,{"$f":"F42/F$47","v":0.18284106891701829},null,{"$f":"H42/H$47","v":0},{"$error":"#DIV/0!"},0.40614378522565936,{"$f":"K42/K$47","v":0.13088569685541568},null,{"$f":"M42/M$47","v":0},{"$error":"#DIV/0!"},0.44061555891238668,{"$f":"P42/P$47","v":2.1774122060120277E-2},null,-0.1091115747952954,-0.16106694685689801,0.1118336292775181]
[null,"Other Trading Activities",{"$f":"C43/C$47","v":2.8161151257637317E-2},{"$error":"#DIV/0!"},0,{"$f":"F43/F$47","v":1.7027660571964368E-2},null,{"$f":"H43/H$47","v":1.1169984247458112E-2},{"$error":"#DIV/0!"},0,{"$f":"K43/K$47","v":7.5702956020187451E-3},null,{"$f":"M43/M$47","v":1.3251858941323714E-3},{"$error":"#DIV/0!"},0,{"$f":"P43/P$47","v":1.2596985121560906E-3},null,-6.3105970898626549E-3,-1.5767962059808276E-2,8.6192182287130673E-3]
[null,"Investments",{"$f":"C44/C$47","v":1.8608690258350649E-4},{"$error":"#DIV/0!"},0.11493216962337539,4.5550867323019224E-2,null,{"$f":"H44/H$47","v":2.2053558642417301E-2},{"$error":"#DIV/0!"},8.6778815127135048E-2,4.2912206755032996E-2,null,{"$f":"M44/M$47","v":4.4197403617266678E-3},{"$error":"#DIV/0!"},6.9958459214501514E-2,7.6585003989045287E-3,null,-3.525370635612847E-2,-3.7892366924114698E-2,3.2040524825652249E-2]
[null,"Other Income",0,{"$error":"#DIV/0!"},4.2690446826676784E-4,1.6877637130801687E-4,null,0,{"$error":"#DIV/0!"},0,0,null,0,{"$error":"#DIV/0!"},3.7764350453172205E-4,1.8662200180090232E-5,null,1.8662200180090232E-5,-1.5011417112792663E-4,6.2479523829369037E-5]
[]
[null,"Fund Income as % of Total Income",{"$f":"C47/$F47","v":0.60465072667604314},{"$f":"D47/$F47","v":0},0.39534927332395686,{"$f":"F47/$F47","v":1},null,{"$f":"H47/$K47","v":0.67773556652431921},{"$f":"I47/$K47","v":0},0.32226443347568079,{"$f":"K47/$K47","v":1},null,{"$f":"M47/$P47","v":0.95058249392312111},{"$f":"N47/$P47","v":0},4.9417506076878934E-2,1,null,{"$f":"P58-K58","v":0},{"$f":"P58-F58","v":0},{"$f":"AVERAGE(P58,K58,F58)","v":1}]
[]
[null,"Expenditure Review"]
[]
[null,"Fundraising Expenditure",-194,0,0,{"$f":"SUM(C62:E62)","v":-194},null,-49,0,0,{"$f":"SUM(H62:J62)","v":-49},null,-33,0,0,{"$f":"SUM(M62:O62)","v":-33},null,{"$f":"P62-K62","v":16},{"$f":"P62-F62","v":161},{"$f":"AVERAGE(P62,K62,F62)","v":-92}]
[null,"Other 'Raising Funds' Expenditure",-558,0,-18,-576,null,-377,null,-146,-523,null,-247,0,-123,-370,null,153,206,-489.66666666666669]
[null,"Charitable Activity Expenditure",-11440,null,-105803,-117243,null,-6965,0,-17661,-24626,null,-20915,0,-16022,-36937,null,-12311,80306,-59602]
[null,"Other Expenditure",0,0,-521,-521,null,0,0,0,0,null,0,0,0,0,null,0,521,-173.66666666666666]
[]
[null,"Total Expenditure",{"$f":"SUM(C62:C65)","v":-12192},{"$f":"SUM(D62:D65)","v":0},{"$f":"SUM(E62:E65)","v":-106342},{"$f":"SUM(C67:E67)","v":-118534},null,{"$f":"SUM(H62:H65)","v":-7391},{"$f":"SUM(I62:I65)","v":0},{"$f":"SUM(J62:J65)","v":-17807},-25198,null,{"$f":"SUM(M62:M65)","v":-21195},{"$f":"SUM(N62:N65)","v":0},{"$f":"SUM(O62:O65)","v":-16145},{"$f":"SUM(P62:P65)","v":-37340},null,-12142,81194,-60357.333333333336]
[]
[null,"Expenditure as % of Total Fund Expenditure"]
[]
[null,"Fundraising Expenditure",{"$f":"C62/C$67","v":1.5912073490813649E-2},{"$error":"#DIV/0!"},0,1.6366612111292963E-3,null,{"$f":"H62/H$67","v":6.6296847517250714E-3},{"$error":"#DIV/0!"},0,1.9445987776807684E-3,null,{"$f":"M62/M$67","v":1.556970983722576E-3},{"$error":"#DIV/0!"},0,8.8377075522228172E-4,null,{"$f":"P71-K71","v":-1.0608280224584867E-3},{"$f":"P71-F71","v":-7.528904559070146E-4},{"$f":"AVERAGE(P71,K71,F71)","v":1.4883435813441155E-3}]
[null,"Other 'Raising Funds' Expenditure",4.5767716535433073E-2,{"$error":"#DIV/0!"},1.6926520095540803E-4,4.8593652454148178E-3,null,5.1007982681639835E-2,{"$error":"#DIV/0!"},8.1990228561801531E-3,2.0755615525041671E-2,null,1.1653691908468978E-2,{"$error":"#DIV/0!"},7.6184577268504179E-3,9.9089448312801292E-3,null,-1.0846670693761542E-2,5.0495795858653113E-3,{"$f":"AVERAGE(P72,K72,F72)","v":1.1841308533912206E-2}]
[null,"Charitable Activity Expenditure",0.93832020997375332,{"$error":"#DIV/0!"},0.99493144759361307,0.98910861018779417,null,0.94236233256663504,{"$error":"#DIV/0!"},0.99180097714381987,0.9772997856972776,null,0.98678933710780847,{"$error":"#DIV/0!"},0.99238154227314956,0.98920728441349759,null,1.1907498716219989E-2,9.8674225703421214E-5,0.98520522676618982]
[null,"Other Expenditure",0,{"$error":"#DIV/0!"},4.8992872054315325E-3,4.395363355661667E-3,null,0,{"$error":"#DIV/0!"},0,0,null,0,{"$error":"#DIV/0!"},0,0,null,0,-4.395363355661667E-3,1.4651211185538889E-3]
[]
[null,"Fund Expenditure as % of Total Expenditure",{"$f":"C67/$F67","v":0.10285656436128031},{"$f":"D67/$F67","v":0},0.89714343563871968,1,null,{"$f":"H67/$K67","v":0.29331692991507263},{"$f":"I67/$K67","v":0},0.70668307008492737,1,null,{"$f":"M67/$P67","v":0.56762185324049275},{"$f":"N67/$P67","v":0},0.43237814675950725,1,null,{"$f":"P76-K76","v":0},{"$f":"P76-F76","v":0},{"$f":"AVERAGE(P76,K76,F76)","v":1}]
[]
[null,"Fundraising Ratio",{"$f":"ABS(C40/C62)","v":6.8505154639175254},{"$f":"ABS(D40/D62)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"ABS(F40/F62)","v":17.536082474226806},null,{"$f":"H40/H62","v":-9.4693877551020407},{"$f":"I40/I62","v":{"$error":"#DIV/0!"}},{"$f":"J40/J62","v":{"$error":"#DIV/0!"}},-9.9591836734693882,null,{"$f":"M40/M62","v":-2.9393939393939394},{"$f":"N40/N62","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},-3.393939393939394,null,{"$f":"P78-K78","v":6.5652442795299937},{"$f":"P78-F78","v":-20.9300218681662},{"$f":"AVERAGE(P78,K78,F78)","v":1.3943198022726744}]
[]
[null,"Assets and Liabilities"]
[]
[null,"Tangible Fixed Assets",null,null,null,2409,null,null,null,null,2640,null,null,null,null,2370,null,{"$f":"P82-K82","v":-270},{"$f":"P82-F82","v":-39},{"$f":"AVERAGE(P82,K82,F82)","v":2473}]
[null,"Intangible Fixed Assets",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[null,"Non-Current Asset Investments",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[]
[null,"Total Fixed Assets",null,null,null,{"$f":"SUM(F82:F84)","v":2409},null,null,null,null,{"$f":"SUM(K82:K84)","v":2640},null,null,null,null,{"$f":"SUM(P82:P84)","v":2370},null,{"$f":"P86-K86","v":-270},{"$f":"P86-F86","v":-39},{"$f":"AVERAGE(P86,K86,F86)","v":2473}]
[]
[null,"Debtors",null,null,null,5954,null,null,null,null,12772,null,null,null,null,15703,null,{"$f":"P88-K88","v":2931},{"$f":"P88-F88","v":9749},{"$f":"AVERAGE(P88,K88,F88)","v":11476.333333333334}]
[null,"Current Asset Investments",null,null,null,124094,null,null,null,null,130931,null,null,null,null,407336,null,276405,283242,220787]
[null,"Other Current Assets",null,null,null,3000,null,null,null,null,2000,null,null,null,null,1000,null,-1000,-2000,2000]
[null,"Cash and Cash Equivalents",null,null,null,28358,null,null,null,null,24318,null,null,null,null,118102,null,{"$f":"P91-K91","v":93784},{"$f":"P91-F91","v":89744},{"$f":"AVERAGE(P91,K91,F91)","v":56926}]
[]
[null,"Total Current Assets",null,null,null,{"$f":"SUM(F88:F91)","v":161406},null,null,null,null,{"$f":"SUM(K88:K91)","v":170021},null,null,null,null,{"$f":"SUM(P88:P91)","v":542141},null,{"$f":"P93-K93","v":372120},{"$f":"P93-F93","v":380735},{"$f":"AVERAGE(P93,K93,F93)","v":291189.33333333331}]
[]
[null,"Total Assets",null,null,null,{"$f":"SUM(F86,F93)","v":163815},null,null,null,null,{"$f":"SUM(K86,K93)","v":172661},null,null,null,null,{"$f":"SUM(P86,P93)","v":544511},null,{"$f":"P95-K95","v":371850},{"$f":"P95-F95","v":380696},{"$f":"AVERAGE(P95,K95,F95)","v":293662.33333333331}]
[]
[null,"Creditors: Amounts due within one year",null,null,null,-15965,null,null,null,null,-18552,null,null,null,null,-25992,null,{"$f":"P97-K97","v":-7440},{"$f":"P97-F97","v":-10027},{"$f":"AVERAGE(P97,K97,F97)","v":-20169.666666666668}]
[null,"Other Current Liabilities",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[]
[null,"Total Current Liabilities",null,null,null,{"$f":"SUM(F97:F98)","v":-15965},null,null,null,null,{"$f":"SUM(K97:K98)","v":-18552},null,null,null,null,{"$f":"SUM(P97:P98)","v":-25992},null,{"$f":"P100-K100","v":-7440},{"$f":"P100-F100","v":-10027},{"$f":"AVERAGE(P100,K100,F100)","v":-20169.666666666668}]
[]
[null,"Creditors: Amounts falling due after one year",null,null,null,-82,null,null,null,null,-94,null,null,null,null,-97,null,{"$f":"P102-K102","v":-3},{"$f":"P102-F102","v":-15},{"$f":"AVERAGE(P102,K102,F102)","v":-91}]
[null,"Other Non-Current Liabilities",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[]
[null,"Total Non-Current Liabilities",null,null,null,{"$f":"SUM(F102:F103)","v":-82},null,null,null,null,{"$f":"SUM(K102:K103)","v":-94},null,null,null,null,{"$f":"SUM(P102:P103)","v":-97},null,{"$f":"P105-K105","v":-3},{"$f":"P105-F105","v":-15},{"$f":"AVERAGE(P105,K105,F105)","v":-91}]
[]
[null,"Provisions",null,null,null,-79028,null,null,null,null,-41951,null,null,null,null,-16326,null,{"$f":"P107-K107","v":25625},{"$f":"P107-F107","v":62702},{"$f":"AVERAGE(P107,K107,F107)","v":-45768.333333333336}]
[]
[null,"Total Liabilities - Excluding Pension",null,null,null,{"$f":"SUM(F105,F100,F107)","v":-95075},null,null,null,null,{"$f":"SUM(K105,K100,K107)","v":-60597},null,null,null,null,{"$f":"SUM(P105,P100,P107)","v":-42415},null,{"$f":"P109-K109","v":18182},{"$f":"P109-F109","v":52660},{"$f":"AVERAGE(P109,K109,F109)","v":-66029}]
[]
[null,"Total Assets Less Liabilities - Excl. Pension",null,null,null,{"$f":"F95+F109","v":68740},null,null,null,null,{"$f":"K95+K109","v":112064},null,null,null,null,{"$f":"P95+P109","v":502096},null,{"$f":"P111-K111","v":390032},{"$f":"P111-F111","v":433356},{"$f":"AVERAGE(P111,K111,F111)","v":227633.33333333334}]
[]
[null,"Pension Liability",null,null,null,-5836,null,null,null,null,-3039,null,null,null,null,-3700,null,{"$f":"P113-K113","v":-661},{"$f":"P113-F113","v":2136},{"$f":"AVERAGE(P113,K113,F113)","v":-4191.666666666667}]
[]
[null,"Total Net Assets",null,null,null,{"$f":"F111+F113","v":62904},null,null,null,null,{"$f":"K111+K113","v":109025},null,null,null,null,{"$f":"P111+P113","v":498396},null,{"$f":"P115-K115","v":389371},{"$f":"P115-F115","v":435492},{"$f":"AVERAGE(P115,K115,F115)","v":223441.66666666666}]
[]
[null,"Total Funds",{"$f":"C27","v":20925},{"$f":"D27","v":0},{"$f":"E27","v":41979},{"$f":"SUM(C117:E117)","v":62904},null,{"$f":"H27","v":61422},{"$f":"I27","v":0},{"$f":"J27","v":47603},{"$f":"SUM(H117:J117)","v":109025},null,{"$f":"M27","v":446250},{"$f":"N27","v":0},{"$f":"O27","v":52146},{"$f":"SUM(M117:O117)","v":498396},null,{"$f":"P117-K117","v":389371},{"$f":"P117-F117","v":435492},{"$f":"AVERAGE(P117,K117,F117)","v":223441.66666666666}]
[]
[null,"Basic Reserves (Cur. Assets - Cur. Liabilities)",{"$f":"C93-C100","v":0},{"$f":"D93-D100","v":0},{"$f":"E93-E100","v":0},{"$f":"F93-F100","v":177371},null,{"$f":"H93-H100","v":0},{"$f":"I93-I100","v":0},{"$f":"J93-J100","v":0},{"$f":"K93-K100","v":188573},null,{"$f":"M93-M100","v":0},{"$f":"N93-N100","v":0},{"$f":"O93-O100","v":0},{"$f":"P93-P100","v":568133},null,{"$f":"P119-K119","v":379560},{"$f":"P119-F119","v":390762},{"$f":"AVERAGE(P119,K119,F119)","v":311359}]
[]
[null,"Months of Fund Expenditure Held",{"$f":"C119/(C14/12)","v":0},{"$f":"D119/(D14/12)","v":{"$error":"#DIV/0!"}},{"$f":"E119/(E14/12)","v":0},{"$f":"ABS(F119/(F14/12))","v":17.956468186343159},null,{"$f":"H119/(H14/12)","v":0},{"$f":"I119/(I14/12)","v":{"$error":"#DIV/0!"}},{"$f":"J119/(J14/12)","v":0},{"$f":"ABS(K119/(K14/12))","v":89.803793951900943},null,{"$f":"M119/(M14/12)","v":0},{"$f":"N119/(N14/12)","v":{"$error":"#DIV/0!"}},{"$f":"O119/(O14/12)","v":0},{"$f":"P119/(P14/12)","v":-182.58157471880023},null,{"$f":"P121-K121","v":-272.38536867070115},{"$f":"P121-F121","v":-200.53804290514339},{"$f":"AVERAGE(P121,K121,F121)","v":-24.94043752685204}]
[null,"Months of Total Expenditure Held",{"$f":"C119/($F14/12)","v":0},{"$f":"D119/($F14/12)","v":0},{"$f":"E119/($F14/12)","v":0},{"$f":"ABS(F119/($F14/12))","v":17.956468186343159},null,{"$f":"H119/($K14/12)","v":0},{"$f":"I119/($K14/12)","v":0},{"$f":"J119/($K14/12)","v":0},{"$f":"ABS(K119/($F14/12))","v":19.090522550491841},null,{"$f":"M119/($P14/12)","v":0},{"$f":"N119/($P14/12)","v":0},{"$f":"O119/($P14/12)","v":0},{"$f":"P119/($P14/12)","v":-182.58157471880023},null,-201.67209726929207,-200.53804290514339,-48.511527993988409]
[]
[null,"Unrestricted Reserves as % of total",null,null,null,{"$f":"F119/F119","v":1},null,null,null,null,{"$f":"H119/K119","v":0},null,null,null,null,{"$f":"M119/P119","v":0},null,{"$f":"P124-K124","v":0},{"$f":"P124-F124","v":-1},{"$f":"AVERAGE(P124,K124,F124)","v":0.33333333333333331}]
[]
[null,"Free Reserves (Exc. Designated Funds)",null,null,null,{"$f":"F117-SUM(D117:E117)-C86","v":20925},null,null,null,null,{"$f":"K117-SUM(I117:J117)-H86","v":61422},null,null,null,null,{"$f":"P117-SUM(N117:O117)-M86","v":446250},null,{"$f":"P126-K126","v":384828},{"$f":"P126-F126","v":425325},{"$f":"AVERAGE(P126,K126,F126)","v":176199}]
[]
[null,"Months Unrestricted Exp. Held in Free Reserves",null,null,null,{"$f":"ABS(F126/(C14/12))","v":20.595472440944881},null,null,null,null,{"$f":"ABS(K126/(H14/12))","v":99.724529833581386},null,null,null,null,{"$f":"ABS(P126/(M14/12))","v":252.65392781316348},null,{"$f":"P128-K128","v":152.92939797958209},{"$f":"P128-F128","v":232.05845537221859},{"$f":"AVERAGE(P128,K128,F128)","v":124.32464336256326}]
[]
[null,"Months Total Exp. Held in Free Reserves",null,null,null,{"$f":"ABS(F126/(F14/12))","v":2.118379536673022},null,null,null,null,{"$f":"ABS(K126/(K14/12))","v":29.250892928010156},null,null,null,null,{"$f":"ABS(P126/(P14/12))","v":143.41189073379755},null,{"$f":"P130-K130","v":114.16099780578739},{"$f":"P130-F130","v":141.29351119712453},{"$f":"AVERAGE(P130,K130,F130)","v":58.260387732826906}]
[]
[null,"Debt Ratio (Excl. Pension Liabilities)",null,null,null,{"$f":"ABS(F109/F95)","v":0.58038030705368859},null,null,null,null,{"$f":"ABS(K109/K95)","v":0.35095939442028018},null,null,null,null,{"$f":"ABS(P109/P95)","v":7.7895579703623985E-2},null,{"$f":"P132-K132","v":-0.27306381471665619},{"$f":"P132-F132","v":-0.50248472735006455},{"$f":"AVERAGE(P132,K132,F132)","v":0.3364117603925309}]
[]
[null,"Cash Flow and Liquidity"]
[]
[null,"Net Cash Flow From Operating Activities",null,null,null,-8517,null,null,null,null,-7345,null,null,null,null,366262,null,{"$f":"P136-K136","v":373607},{"$f":"P136-F136","v":374779},{"$f":"AVERAGE(P136,K136,F136)","v":116800}]
[]
[null,"Interest Receivable",null,null,null,187,null,null,null,null,76,null,null,null,null,524,null,{"$f":"P138-K138","v":448},{"$f":"P138-F138","v":337},{"$f":"AVERAGE(P138,K138,F138)","v":262.33333333333331}]
[null,"Purchase of Tangible Fixed Assets",null,null,null,-305,null,null,null,null,-790,null,null,null,null,-364,null,426,-59,-486.33333333333331]
[null,"Proceeds From Sale of Tangible Fixed Assets",null,null,null,9,null,null,null,null,0,null,null,null,null,8,null,8,-1,5.666666666666667]
[null,"Other Cash Flows from Investing Activities",null,null,null,16842,null,null,null,null,4019,null,null,null,null,{"$f":"-276405+1000+2759","v":-272646},null,-276665,-289488,-83928.333333333328]
[]
[null,"Net Cash Flows From Investing Activities",null,null,null,{"$f":"SUM(F138:F141)","v":16733},null,null,null,null,{"$f":"SUM(K138:K141)","v":3305},null,null,null,null,{"$f":"SUM(P138:P141)","v":-272478},null,{"$f":"P143-K143","v":-275783},{"$f":"P143-F143","v":-289211},{"$f":"AVERAGE(P143,K143,F143)","v":-84146.666666666672}]
[]
[null,"Cash Inflows From Borrowing",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,{"$f":"P145-K145","v":0},{"$f":"P145-F145","v":0},{"$f":"AVERAGE(P145,K145,F145)","v":0}]
[null,"Repayment of Borrowings",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[null,"Other Cash Flows From Financing Activities",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0,0,0]
[]
[null,"Net Cash Flows From Financing Activities",null,null,null,{"$f":"SUM(F145:F147)","v":0},null,null,null,null,{"$f":"SUM(K145:K147)","v":0},null,null,null,null,{"$f":"SUM(P145:P147)","v":0},null,{"$f":"P149-K149","v":0},{"$f":"P149-F149","v":0},{"$f":"AVERAGE(P149,K149,F149)","v":0}]
[]
[null,"Net Increase/Decrease in Cash and Equivalents",null,null,null,{"$f":"SUM(F149,F143,F136)","v":8216},null,null,null,null,{"$f":"SUM(K149,K143,K136)","v":-4040},null,null,null,null,{"$f":"SUM(P149,P143,P136)","v":93784},null,{"$f":"P151-K151","v":97824},{"$f":"P151-F151","v":85568},{"$f":"AVERAGE(P151,K151,F151)","v":32653.333333333332}]
[]
[null,"Cash and Equivalents Brought Forwards",null,null,null,20142,null,null,null,null,{"$f":"F155","v":28358},null,null,null,null,{"$f":"K155","v":24318},null,{"$f":"P153-K153","v":-4040},{"$f":"P153-F153","v":4176},{"$f":"AVERAGE(P153,K153,F153)","v":24272.666666666668}]
[]
[null,"Cash and Equivalents Carried Forwards",null,null,null,{"$f":"F153+F151","v":28358},null,null,null,null,{"$f":"K153+K151","v":24318},null,null,null,null,{"$f":"P153+P151","v":118102},null,{"$f":"P155-K155","v":93784},{"$f":"P155-F155","v":89744},{"$f":"AVERAGE(P155,K155,F155)","v":56926}]
[]
[null,"Current Ratio",null,null,null,{"$f":"ABS(F93/F100)","v":10.109990604447228},null,null,null,null,{"$f":"ABS(K93/K100)","v":9.1645644674428635},null,null,null,null,{"$f":"ABS(P93/P100)","v":20.857994767620806},null,{"$f":"P157-K157","v":11.693430300177942},{"$f":"P157-F157","v":10.748004163173578},{"$f":"AVERAGE(P157,K157,F157)","v":13.377516613170298}]
[]
[null,"Cash Ratio",null,null,null,{"$f":"ABS(F91/F100)","v":1.7762605699968681},null,null,null,null,{"$f":"ABS(K91/K100)","v":1.3108020698576972},null,null,null,null,{"$f":"ABS(P91/P100)","v":4.5437827023699597},null,3.2329806325122625,2.7675221323730916,2.5436151140748415]

{"sheet":"Ratio Calculations","index":10,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[14,1,17,1],[18,1,20,1],[1,1,1,2],[4,1,5,1],[11,1,13,1]]}
[]
[null,"Ratio Calculation Detail "]
[]
[null,"Ratio ","Calculation Method "]
[null,"Turnover Ratio =  Revenue / Grant Funding Received ","Revenue can be found on the face of standard financial statements. It should exclude the entity’s share of the revenue of joint ventures or associates."]
[null,null,"Grant funding is the total grant, multiplied by percentage partner."]
[null,"Operating Margin = Operating Profit / Revenue ","All figures required can be found on the face of standard financial statements. Figures for Operating Profit and Revenue should exclude the entity’s share of the results of joint ventures or associates."]
[null,"Cash Ratio = Cash and cash equivalents / current liabilities ","All figures required can be found on the face of standard financial statements."]
[null,"Debt Ratio = (Total Liabilities - Pension Liabilities) / (Total Assets - Pension Assets)","All figures required can be found on the face of standard financial statements."]
[null,"Acid Ratio = (Current Assets - Inventories) / Current Liabilities ","All figures required can be found on the face of standard financial statements."]
[null,"Net Assets ","Balance should be displayed on the face of the balance sheet, and represents shareholders funds."]
[null,"Net Debt to EBITDA Ratio = Net Debt / EBITDA","Majority of elements likely to be found in standard financial statements, further definitions below:"]
[null,null,"Net Debt = Bank overdrafts + Loans and borrowings, including balances owed to other group\nmembers + Finance leases + Deferred consideration payable – Cash and cash equivalents,\nincluding short-term financial investments"]
[null,null,"EBITDA = Operating profit + Depreciation charge + Amortisation charge"]
[null,"Net Debt + Net Pension to EBITDA Ratio = (Net Debt + Net Pension Deficit)/EBITDA","Majority of elements likely to be found in standard financial statements, further definitions below:"]
[null,null,"Net Debt = Bank overdrafts + Loans and borrowings, including balances owed to other group\nmembers + Finance leases + Deferred consideration payable – Cash and cash equivalents,\nincluding short-term financial investments"]
[null,null,"Net Pension Deficit = Retirement Benefit Obligations – Retirement Benefit Assets"]
[null,null,"EBITDA = Operating profit + Depreciation charge + Amortisation charge"]
[null,"Interest Cover = Earnings Before Interest and Tax / Net Interest Paid ","Majority of elements likely to be found in standard financial statements, further definitions below:"]
[null,null,"Earnings before interest and tax = Operating profit "]
[null,null,"Net interest paid = Interest paid - interest received "]

{"sheet":"Thresholds","index":11,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Financial Thresholds"]
[null,null,null,"Red","Amber","Green"]
[null,null,"Turnover Ratio",1.5,null,2,"Higher the better"]
[null,null,"Operating Margin",0.05,null,0.1,"Higher the better"]
[null,null,"Cash Ratio",0.05,null,0.15,"Higher the better"]
[null,null,"Debt Ratio",1.2,null,1,"Lower the better"]
[null,null,"Current Acid Ratio",0.8,null,1,"Higher the better"]
[null,null,"Net Asset Value",0,null,0,"Higher the better"]