{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Assumptions","Income Statement"],"not_rendered":{"charts":1,"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":"Assumptions","index":0,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["THE CARE TEAM"]
[]
[null,null,"Scenario",7]
[]
[null,null,null,"Model","Inflation link",null,1,2,3,null,5,6,7]
[null,null,null,null,null,null,"Base","Low inflation","High Inflation",null,"Best","Worst","Random"]
[]
["Income",null,"Donations",{"$f":"OFFSET(F8,0,$D$3)","v":375000},3,null,425000,425000,425000,null,375000,375000,{"$f":"(RAND()*(MAX(K8:L8)-MIN(K8:L8)))+MIN(K8:L8)","v":375000}]
[null,null,"Donation growth",{"$f":"OFFSET(F9,0,$D$3)","v":9.6547049649492747E-2},null,null,0.05,0.05,0.05,null,0,0.1,{"$f":"(RAND()*(MAX(K9:L9)-MIN(K9:L9)))+MIN(K9:L9)","v":9.6547049649492747E-2}]
[null,null,"Local Authority grant",186568.4846076892,0,null,180000,180000,180000,null,180000,200000,186568.4846076892]
[null,null,"Legacies",63579.27750932231,0,null,130000,130000,130000,null,0,200000,63579.27750932231]
[]
["Direct cost",null,"Staff per £ Income",63172.803406140207,3,null,65000,65000,65000,null,60000,75000,63172.803406140207]
[null,null,"Salaries and on cost",30000,4,null,30000,30000,30000,null,30000,30000,30000]
[null,null,"Travel per person",750,1,null,750,750,750,null,750,750,750]
[]
["Indirect cost",null,"Staff per £ Income",115000,3,null,125000,125000,125000,null,115000,115000,115000]
[null,null,"Salaries and on cost",30000,4,null,30000,30000,30000,null,30000,30000,30000]
[null,null,"Energy",25000,2,null,25000,25000,25000,null,25000,25000,25000]
[null,null,"Stationery",15000,1,null,15000,15000,15000,null,15000,15000,15000]
[null,null,"Insurance",12000,1,null,12000,12000,12000,null,12000,12000,12000]
[null,null,"Communication",26000,1,null,26000,26000,26000,null,26000,26000,26000]
[null,null,"Building Maintenance",28000,1,null,28000,28000,28000,null,28000,28000,28000]
[]
["Inflation",0,"No change",0,null,null,0,0,0,null,0,0,0]
[null,1,"RPI",6.9920593995581357E-2,null,null,0.1,0.06,0.13,null,0.06,0.12,6.9920593995581357E-2]
[null,2,"Energy",0.13413390646871262,null,null,0.2,0.1,0.25,null,0.1,0.25,0.13413390646871262]
[null,3,"Donations",4.7324123846727732E-2,null,null,0.02,0,0.04,null,0,0.05,4.7324123846727732E-2]
[null,4,"Pay rise",4.4102600271005175E-2,null,null,0.08,0.04,0.1,null,0.04,0.12,4.4102600271005175E-2]

{"sheet":"Income Statement","index":1,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Assumptions!A1","v":"THE CARE TEAM"}]
[]
[null,null,2022,{"$f":"C3+1","v":2023},{"$f":"D3+1","v":2024},{"$f":"E3+1","v":2025},2026,2027]
[]
["Inflation rates","No change",{"$f":"Assumptions!D25","v":0},{"$f":"1*(1+$C5)","v":1},{"$f":"D5*(1+$C5)","v":1},{"$f":"E5*(1+$C5)","v":1},1,1]
[null,"RPI",{"$f":"Assumptions!D26","v":6.9920593995581357E-2},{"$f":"1*(1+$C6)","v":1.0699205939955814},{"$f":"D6*(1+$C6)","v":1.1447300774558578},1.2247702844361792,1.3104069502320941,1.4020313825682604]
[null,"Energy",{"$f":"Assumptions!D27","v":0.13413390646871262},1.1341339064687126,{"$f":"D7*(1+$C7)","v":1.2862597178019826},1.4587907584841064,1.6544640616400359,1.8763837893399069]
[null,"Donations",{"$f":"Assumptions!D28","v":4.7324123846727732E-2},1.0473241238467277,{"$f":"D8*(1+$C8)","v":1.0968878203913157},1.1487970754494816,1.2031628905228116,1.2601015201616999]
[null,"Pay rise",{"$f":"Assumptions!D29","v":4.4102600271005175E-2},1.0441026002710052,{"$f":"D9*(1+$C9)","v":1.0901502398926746},1.1382287001580016,1.1884275455380557,1.2408402905299725]
[]
[]
["Income",{"$f":"_xlfn.CONCAT(\"Donations - Growing at \",TEXT(Assumptions!D9,\"0.0%\"),\" plus \",TEXT(Assumptions!D28,\"0.0%\"),\" inflation\")","v":"Donations - Growing at 9.7% plus 4.7% inflation"},{"$f":"Assumptions!D8","v":375000},{"$f":"C12*(1+Assumptions!$D$9)*(1+OFFSET($C$5,Assumptions!$E$8,0))","v":430665.06676157593},{"$f":"D12*(1+Assumptions!$D$9)*(1+OFFSET($C$5,Assumptions!$E$8,0))","v":494593.06594334042},{"$f":"E12*(1+Assumptions!$D$9)*(1+OFFSET($C$5,Assumptions!$E$8,0))","v":568010.54870480322},{"$f":"F12*(1+Assumptions!$D$9)*(1+OFFSET($C$5,Assumptions!$E$8,0))","v":652326.13567795581},{"$f":"G12*(1+Assumptions!$D$9)*(1+OFFSET($C$5,Assumptions!$E$8,0))","v":749157.54339218047}]
[null,"Local Authority grant",180000,{"$f":"C13*(1+OFFSET($C$5,Assumptions!$E$10,0))","v":180000},{"$f":"D13*(1+OFFSET($C$5,Assumptions!$E$10,0))","v":180000},{"$f":"E13*(1+OFFSET($C$5,Assumptions!$E$10,0))","v":180000},{"$f":"F13*(1+OFFSET($C$5,Assumptions!$E$10,0))","v":180000},{"$f":"G13*(1+OFFSET($C$5,Assumptions!$E$10,0))","v":180000}]
[null,"Legacies",130000,{"$f":"(RAND()*(MAX(Assumptions!$K$11:$L$11)-MIN(Assumptions!$K$11:$L$11)))+MIN(Assumptions!$K$11:$L$11)","v":90640.201233621425},{"$f":"(RAND()*(MAX(Assumptions!$K$11:$L$11)-MIN(Assumptions!$K$11:$L$11)))+MIN(Assumptions!$K$11:$L$11)","v":77142.477458226916},{"$f":"(RAND()*(MAX(Assumptions!$K$11:$L$11)-MIN(Assumptions!$K$11:$L$11)))+MIN(Assumptions!$K$11:$L$11)","v":75638.343734523427},{"$f":"(RAND()*(MAX(Assumptions!$K$11:$L$11)-MIN(Assumptions!$K$11:$L$11)))+MIN(Assumptions!$K$11:$L$11)","v":140351.59805982505},{"$f":"(RAND()*(MAX(Assumptions!$K$11:$L$11)-MIN(Assumptions!$K$11:$L$11)))+MIN(Assumptions!$K$11:$L$11)","v":101774.96285688164}]
["Total Income",null,{"$f":"SUM(C12:C14)","v":685000},{"$f":"SUM(D12:D14)","v":701305.26799519733},751735.54340156738,823648.89243932662,972677.73373778083,1030932.5062490621]
[]
["Direct cost","Number of staff",12,{"$f":"ROUND(D15/(Assumptions!$D$13*OFFSET(D$5,Assumptions!$E$13,0)),0)","v":11},{"$f":"ROUND(E15/(Assumptions!$D$13*OFFSET(E$5,Assumptions!$E$13,0)),0)","v":11},{"$f":"ROUND(F15/(Assumptions!$D$13*OFFSET(F$5,Assumptions!$E$13,0)),0)","v":11},{"$f":"ROUND(G15/(Assumptions!$D$13*OFFSET(G$5,Assumptions!$E$13,0)),0)","v":13},{"$f":"ROUND(H15/(Assumptions!$D$13*OFFSET(H$5,Assumptions!$E$13,0)),0)","v":13}]
[null,"Salaries and on cost",30000,{"$f":"C18*(1+OFFSET($C$5,Assumptions!$E$14,0))","v":31323.078008130156},{"$f":"D18*(1+OFFSET($C$5,Assumptions!$E$14,0))","v":32704.507196780236},{"$f":"E18*(1+OFFSET($C$5,Assumptions!$E$14,0))","v":34146.861004740051},{"$f":"F18*(1+OFFSET($C$5,Assumptions!$E$14,0))","v":35652.826366141679},{"$f":"G18*(1+OFFSET($C$5,Assumptions!$E$14,0))","v":37225.208715899178}]
[null,"Travel per person",750,{"$f":"C19*(1+OFFSET($C$5,Assumptions!$E$15,0))","v":802.44044549668604},{"$f":"D19*(1+OFFSET($C$5,Assumptions!$E$15,0))","v":858.54755809189328},{"$f":"E19*(1+OFFSET($C$5,Assumptions!$E$15,0))","v":918.57771332713435},{"$f":"F19*(1+OFFSET($C$5,Assumptions!$E$15,0))","v":982.80521267407039},{"$f":"G19*(1+OFFSET($C$5,Assumptions!$E$15,0))","v":1051.523536926195}]
["Total",null,{"$f":"SUM(C18:C19)*C17","v":369000},{"$f":"SUM(D18:D19)*D17","v":353380.70298989525},369193.60230359342,385719.82589873904,476263.21052460477,497597.51928672986]
[]
["Indirect cost","Number of staff",6,{"$f":"ROUND(D15/(Assumptions!$D$17*OFFSET(D$5,Assumptions!$E$17,0)),0)","v":6},{"$f":"ROUND(E15/(Assumptions!$D$17*OFFSET(E$5,Assumptions!$E$17,0)),0)","v":6},{"$f":"ROUND(F15/(Assumptions!$D$17*OFFSET(F$5,Assumptions!$E$17,0)),0)","v":6},{"$f":"ROUND(G15/(Assumptions!$D$17*OFFSET(G$5,Assumptions!$E$17,0)),0)","v":7},{"$f":"ROUND(H15/(Assumptions!$D$17*OFFSET(H$5,Assumptions!$E$17,0)),0)","v":7}]
[null,"Salaries and on cost",30000,{"$f":"C23*(1+OFFSET($C$5,Assumptions!$E$18,0))","v":31323.078008130156},{"$f":"D23*(1+OFFSET($C$5,Assumptions!$E$18,0))","v":32704.507196780236},{"$f":"E23*(1+OFFSET($C$5,Assumptions!$E$18,0))","v":34146.861004740051},{"$f":"F23*(1+OFFSET($C$5,Assumptions!$E$18,0))","v":35652.826366141679},{"$f":"G23*(1+OFFSET($C$5,Assumptions!$E$18,0))","v":37225.208715899178}]
[null,"Pay cost",{"$f":"C22*C23","v":180000},{"$f":"D22*D23","v":187938.46804878092},196227.04318068142,204881.16602844029,249569.78456299176,260576.46101129425,null,"Loop run",null,100]
[null,"Energy",{"$f":"Assumptions!D19","v":25000},{"$f":"C25*(1+OFFSET($C$5,Assumptions!$E$19,0))","v":28353.347661717813},{"$f":"D25*(1+OFFSET($C$5,Assumptions!$E$19,0))","v":32156.492945049562},{"$f":"E25*(1+OFFSET($C$5,Assumptions!$E$19,0))","v":36469.768962102658},{"$f":"F25*(1+OFFSET($C$5,Assumptions!$E$19,0))","v":41361.601541000891},{"$f":"G25*(1+OFFSET($C$5,Assumptions!$E$19,0))","v":46909.594733497666}]
[null,"Stationary",{"$f":"Assumptions!D20","v":15000},{"$f":"C26*(1+OFFSET($C$5,Assumptions!$E$20,0))","v":16048.808909933721},{"$f":"D26*(1+OFFSET($C$5,Assumptions!$E$20,0))","v":17170.951161837867},{"$f":"E26*(1+OFFSET($C$5,Assumptions!$E$20,0))","v":18371.554266542687},{"$f":"F26*(1+OFFSET($C$5,Assumptions!$E$20,0))","v":19656.104253481408},{"$f":"G26*(1+OFFSET($C$5,Assumptions!$E$20,0))","v":21030.470738523902},null,"Activate"]
[null,"Insurance",{"$f":"Assumptions!D21","v":12000},{"$f":"C27*(1+OFFSET($C$5,Assumptions!$E$21,0))","v":12839.047127946977},{"$f":"D27*(1+OFFSET($C$5,Assumptions!$E$21,0))","v":13736.760929470292},{"$f":"E27*(1+OFFSET($C$5,Assumptions!$E$21,0))","v":14697.24341323415},{"$f":"F27*(1+OFFSET($C$5,Assumptions!$E$21,0))","v":15724.883402785126},{"$f":"G27*(1+OFFSET($C$5,Assumptions!$E$21,0))","v":16824.37659081912}]
[null,"Communication",{"$f":"Assumptions!D22","v":26000},{"$f":"C28*(1+OFFSET($C$5,Assumptions!$E$22,0))","v":27817.935443885115},{"$f":"D28*(1+OFFSET($C$5,Assumptions!$E$22,0))","v":29762.982013852299},{"$f":"E28*(1+OFFSET($C$5,Assumptions!$E$22,0))","v":31844.027395340658},{"$f":"F28*(1+OFFSET($C$5,Assumptions!$E$22,0))","v":34070.580706034445},{"$f":"G28*(1+OFFSET($C$5,Assumptions!$E$22,0))","v":36452.815946774768},null,"Av time before a Loss",null,null,null,2.7200002670288086,null,{"$f":" _xlfn.CONCAT(INT(ROUND(N28*12,0)/12)+2022,\" years \", ROUND(N28*12,0)-(INT(ROUND(N28*12,0)/12)*12),\" months\")","v":"2024 years 9 months"}]
[null,"Building Maintenance",{"$f":"Assumptions!D23","v":28000},{"$f":"C29*(1+OFFSET($C$5,Assumptions!$E$23,0))","v":29957.776631876277},{"$f":"D29*(1+OFFSET($C$5,Assumptions!$E$23,0))","v":32052.442168764013},{"$f":"E29*(1+OFFSET($C$5,Assumptions!$E$23,0))","v":34293.567964213013},{"$f":"F29*(1+OFFSET($C$5,Assumptions!$E$23,0))","v":36691.394606498623},{"$f":"G29*(1+OFFSET($C$5,Assumptions!$E$23,0))","v":39256.878711911275},null,"Number of times negative in 2027",null,null,null,88,null,{"$f":"_xlfn.CONCAT(TEXT(N29/L24,\"0.0%\"),\" of values\")","v":"88.0% of values"}]
["Total",null,{"$f":"SUM(C24:C29)","v":286000},{"$f":"SUM(D24:D29)","v":302955.38382414088},{"$f":"SUM(E24:E29)","v":321106.67239965545},340557.32802987349,397074.34907279222,421050.59773282101]
[]
["Total cost",null,{"$f":"C30+C20","v":655000},{"$f":"D30+D20","v":656336.08681403613},{"$f":"E30+E20","v":690300.27470324887},726277.15392861259,873337.55959739699,918648.11701955087]
["Result",null,{"$f":"C15-C32","v":30000},{"$f":"D15-D32","v":44969.181181161199},{"$f":"E15-E32","v":61435.268698318512},97371.738510714029,99340.174140383839,112284.38922951126]