{"text_format":"1","workbook":"xlsx","n_sheets":39,"sheets":["DISCLAIMER","Agenda","Part 1","1.1 Intro","1.2 Basic","1.3 Basic (labelled)","Part 2","2.1 Overview","2.2 Model Unlinked","2.3 Scenario Manager","2.3 Model Linked","2.4.1 Scenario Manager (Ex)","2.4.2 Model (Ex)","Part 3","3.1 Conditional Formatting","3.2 Defaults","3.2.1 Defaults + CondFmt","3.3.1 Timeline Data","3.3.2 Nested","3.3.3 Updated Source","3.4 Form Controls","3.4.1 Other Sheet","3.5 Form Controls (Ex)","3.5.1 Other Sheet (Ex)","3.5.2 Other Sheet (Ex)","Part 4","4.1 Macro","4.1.1 Model NPV","Part 5","5.1 Data Table","5.1.1 Model","5.2 Data Table (Ex)","5.2.1 Model (Ex)","Part 6","6.1 Pitfalls","Part 7","7.1 Conclusion","7.2 Data Table (Ex Spare)","7.2.1 Model (Ex Spare)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":13,"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":"DISCLAIMER","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["The information provided by RSM Corporate Finance LLP (“we,” “us” or “our”) in this file is for general informational, instructional and illustrative purposes only. All information contained is shared in good faith, however we make no representation or warranty of any kind, express or implied, regarding the accuracy, adequacy, validity, reliability, availability or completeness of any information contained in this file.\n\nUnder no circumstance shall we have any liability to you for any loss or damage of any kind incurred as a result of the use of this file or reliance on any information provided in this file. Your use of this file and your reliance on any information contained herein is solely at your own risk and no duty of care is intended, created or to be inferred."]

{"sheet":"Agenda","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["0.1 Agenda"]
[]
[null,null,"1.0 Introduction to Scenarios"]
[]
[null,null,"2.0 Basic Implementations"]
[]
[null,null,"3.0 Advanced Implementations"]
[]
[null,null,"4.0 Macros"]
[]
[null,null,"5.0 Data Tables"]
[]
[null,null,"6.0 Pitfalls"]
[]
[null,null,"7.0 Conclusion"]
[]
[null,null,"8.0 Q+A"]

{"sheet":"Part 1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1.1 Intro","index":3,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["1.1 Introduction"]
[]
[null,null,"What is the purpose of a financial model?"]
[]
[]
[]
[null,null,"What is a \"Sensitivity\" input?"]
[]
[]
[]
[null,null,"Most variables are not independent…"]
[]
[]
[]
[null,null,"Why are multiple versions of a model bad?"]
[]
[]
[]
[null,null,"How can a scenario manager help?"]

{"sheet":"1.2 Basic","index":4,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["1.2 Basic Scenario Manager"]
[]
[]
[]
[null,null,"Selected Scenario",null,3]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G10:K10,$E$6)","v":"Downside"},null,"Base Case","Upside","Downside","GFC","Moon Shot"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"INDEX(G12:K12,$E$6)","v":800},null,1000,1200,800,450,1800]
[null,null,"Revenue Y2","[£'000]",{"$f":"INDEX(G13:K13,$E$6)","v":960},null,1200,1440,960,540,2160]
[null,null,"Revenue Y3","[£'000]",{"$f":"INDEX(G14:K14,$E$6)","v":1200},null,1500,1800,1200,675,2700]
[null,null,"Revenue Y4","[£'000]",{"$f":"INDEX(G15:K15,$E$6)","v":1440},null,1800,2160,1440,810,3240]
[]
[null,null,"CoS% Y1","[%]",{"$f":"INDEX(G17:K17,$E$6)","v":0.7},null,0.7,0.65,0.7,0.8,0.7]
[null,null,"CoS% Y2","[%]",{"$f":"INDEX(G18:K18,$E$6)","v":0.69},null,0.69,0.65,0.69,0.8,0.69]
[null,null,"CoS% Y3","[%]",{"$f":"INDEX(G19:K19,$E$6)","v":0.68},null,0.68,0.65,0.68,0.8,0.68]
[null,null,"CoS% Y4","[%]",{"$f":"INDEX(G20:K20,$E$6)","v":0.67},null,0.67,0.65,0.67,0.8,0.67]
[]
[null,null,"Interest Rate Y1","[%]",{"$f":"INDEX(G22:K22,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y2","[%]",{"$f":"INDEX(G23:K23,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y3","[%]",{"$f":"INDEX(G24:K24,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y4","[%]",{"$f":"INDEX(G25:K25,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]

{"sheet":"1.3 Basic (labelled)","index":5,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["1.3 Basic Scenario Manager (labelled)"]
[]
[]
[]
[null,null,"Selected Scenario",null,3]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G10:K10,$E$6)","v":"Downside"},null,"Base Case","Upside","Downside","GFC","Moon Shot"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"INDEX(G12:K12,$E$6)","v":800},null,1000,1200,800,450,1800]
[null,null,"Revenue Y2","[£'000]",{"$f":"INDEX(G13:K13,$E$6)","v":960},null,1200,1440,960,540,2160]
[null,null,"Revenue Y3","[£'000]",{"$f":"INDEX(G14:K14,$E$6)","v":1200},null,1500,1800,1200,675,2700]
[null,null,"Revenue Y4","[£'000]",{"$f":"INDEX(G15:K15,$E$6)","v":1440},null,1800,2160,1440,810,3240]
[]
[null,null,"CoS% Y1","[%]",{"$f":"INDEX(G17:K17,$E$6)","v":0.7},null,0.7,0.65,0.7,0.8,0.7]
[null,null,"CoS% Y2","[%]",{"$f":"INDEX(G18:K18,$E$6)","v":0.69},null,0.69,0.65,0.69,0.8,0.69]
[null,null,"CoS% Y3","[%]",{"$f":"INDEX(G19:K19,$E$6)","v":0.68},null,0.68,0.65,0.68,0.8,0.68]
[null,null,"CoS% Y4","[%]",{"$f":"INDEX(G20:K20,$E$6)","v":0.67},null,0.67,0.65,0.67,0.8,0.67]
[]
[null,null,"Interest Rate Y1","[%]",{"$f":"INDEX(G22:K22,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y2","[%]",{"$f":"INDEX(G23:K23,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y3","[%]",{"$f":"INDEX(G24:K24,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y4","[%]",{"$f":"INDEX(G25:K25,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]

{"sheet":"Part 2","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2.1 Overview","index":7,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["2.1 Implementation Overview"]
[]
[null,null,"Step 1 - Build model with normal inputs"]
[]
[]
[]
[null,null,"Step 2 - Decide which ones will be input via scenario manager"]
[]
[]
[]
[null,null,"Step 3 - Build scenario manager sheet"]
[]
[]
[]
[null,null,"Step 4 - Link the original inputs to the scenario manager outputs"]
[]
[]
[]
[null,null,"Step 5 - Test"]

{"sheet":"2.2 Model Unlinked","index":8,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
[]
["2.2 Basic Model (not linked)"]
[]
[null,null,"Timeline"]
[]
[null,null,"Year",null,"Year 0","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"Input Assumptions"]
[null,null,"P&L Assumptions"]
[]
[null,null,"Revenue","[£'000]",null,10000,10000,10000,10000]
[null,null,"CoS %","[%]",null,0.2,0.2,0.2,0.2]
[null,null,"Overheads Pct of Revenue","[%]",null,0.1,0.1,0.1,0.1]
[null,null,"Tax Rate","[%]",null,0.19,0.19,0.19,0.19]
[]
[null,null,"Fixed Assets"]
[]
[null,null,"Depreciation Rate",null,null,0.1,0.1,0.1,0.1]
[]
[null,null,"Working Capital"]
[]
[null,null,"Debtors Days",null,null,30,30,30,30]
[null,null,"Creditors Days",null,null,45,45,45,45]
[]
[null,null,"Loan"]
[]
[null,null,"Capital Drawdown","[£'000]",null,1000]
[null,null,"Capital Repayment","[£'000]",null,null,null,null,-1000]
[null,null,"Interest Rate","[%]",null,0.1,0.1,0.1,0.1]
[]
[null,null,"Workings"]
[null,null,"Fixed Assets"]
[]
[null,null,{"$f":"C32&\" b/f\"","v":"Fixed Assets b/f"},null,null,{"$f":"E36","v":10000},{"$f":"F36","v":9000},8100,7290]
[null,null,"Depreciation",null,null,{"$f":"-F34*F18","v":-1000},{"$f":"-G34*G18","v":-900},-810,-729]
[null,null,{"$f":"C32&\" c/f\"","v":"Fixed Assets c/f"},null,{"$f":"E$92","v":10000},{"$f":"SUM(F34:F35)","v":9000},{"$f":"SUM(G34:G35)","v":8100},7290,6561]
[]
[null,null,"Debtors"]
[]
[null,null,{"$f":"C38&\" b/f\"","v":"Debtors b/f"},null,null,{"$f":"E43","v":900},{"$f":"F43","v":821.91780821917803},821.91780821917803,821.91780821917803]
[null,null,"Sales",null,null,{"$f":"F77","v":10000},{"$f":"G77","v":10000},{"$f":"H77","v":10000},{"$f":"I77","v":10000}]
[null,null,"Cash",null,null,{"$f":"F43-F40-F41","v":-10078.082191780823},{"$f":"G43-G40-G41","v":-10000},-10000,-10000]
[null,null,{"$f":"C38&\" c/f\"","v":"Debtors c/f"},null,{"$f":"E$94","v":900},{"$f":"F41*F22/365","v":821.91780821917803},{"$f":"G41*G22/365","v":821.91780821917803},821.91780821917803,821.91780821917803]
[]
[null,null,"Creditors"]
[]
[null,null,{"$f":"C45&\" b/f\"","v":"Creditors b/f"},null,null,{"$f":"E50","v":-400},{"$f":"F50","v":-369.86301369863014},-369.86301369863014,-369.86301369863014]
[null,null,"Costs",null,null,{"$f":"F78+F81","v":-3000},{"$f":"G78+G81","v":-3000},{"$f":"H78+H81","v":-3000},{"$f":"I78+I81","v":-3000}]
[null,null,"Cash",null,null,{"$f":"F50-F47-F48","v":3030.1369863013697},{"$f":"G50-G47-G48","v":3000},{"$f":"H50-H47-H48","v":3000},{"$f":"I50-I47-I48","v":3000}]
[null,null,{"$f":"C45&\" c/f\"","v":"Creditors c/f"},null,{"$f":"E98","v":-400},{"$f":"F48*F23/365","v":-369.86301369863014},{"$f":"G48*G23/365","v":-369.86301369863014},-369.86301369863014,-369.86301369863014]
[]
[null,null,"Loan"]
[]
[null,null,{"$f":"C52&\" b/f\"","v":"Loan b/f"},null,null,{"$f":"E59","v":0},{"$f":"F59","v":-1000},-1000,-1000]
[null,null,"Capital Drawn",null,null,{"$f":"-F27","v":-1000},{"$f":"-G27","v":0},0,0]
[null,null,"Capital Repaid",null,null,{"$f":"-F28","v":0},0,0,1000]
[null,null,"Interest Charged",null,null,{"$f":"(F54+SUM(F55:F56)/2)*F29","v":-50},{"$f":"(G54+SUM(G55:G56)/2)*G29","v":-100},-100,-50]
[null,null,"Interest Paid",null,null,{"$f":"-F57","v":50},{"$f":"-G57","v":100},100,50]
[null,null,{"$f":"C52&\" c/f\"","v":"Loan c/f"},null,{"$f":"E100","v":0},{"$f":"SUM(F54:F58)","v":-1000},{"$f":"SUM(G54:G58)","v":-1000},-1000,0]
[]
[null,null,"Tax"]
[]
[null,null,{"$f":"C61&\" b/f\"","v":"Tax b/f"},null,null,{"$f":"E66","v":-500},{"$f":"F66","v":-565.25},-570,-578.54999999999995]
[null,null,"Charge",null,null,{"$f":"F87","v":-1130.5},{"$f":"G87","v":-1140},{"$f":"H87","v":-1157.0999999999999},{"$f":"I87","v":-1181.99}]
[null,null,"Cash",null,null,{"$f":"-F64/2-E66","v":1065.25},{"$f":"-F64/2-G64/2","v":1135.25},{"$f":"-G64/2-H64/2","v":1148.55},1169.5450000000001]
[null,null,{"$f":"C61&\" c/f\"","v":"Tax c/f"},null,{"$f":"E99","v":-500},{"$f":"SUM(F63:F65)","v":-565.25},{"$f":"SUM(G63:G65)","v":-570},-578.54999999999995,-590.99499999999989]
[]
[null,null,"Reserves"]
[]
[null,null,{"$f":"C68&\" b/f\"","v":"Reserves b/f"},null,null,{"$f":"E72","v":16000},{"$f":"F72","v":20819.5},25679.5,30612.400000000001]
[null,null,"Profit in period",null,null,{"$f":"F88","v":4819.5},{"$f":"G88","v":4860},{"$f":"H88","v":4932.8999999999996},{"$f":"I88","v":5039.01}]
[null,null,{"$f":"C68&\" c/f\"","v":"Reserves c/f"},null,{"$f":"E107","v":16000},{"$f":"SUM(F70:F71)","v":20819.5},{"$f":"SUM(G70:G71)","v":25679.5},30612.400000000001,35651.410000000003]
[]
[null,null,"Financial Statements"]
[null,null,"P&L"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"F11","v":10000},{"$f":"G11","v":10000},{"$f":"H11","v":10000},{"$f":"I11","v":10000}]
[null,null,"Cost of Sales","[£'000]",null,{"$f":"-F77*F12","v":-2000},{"$f":"-G77*G12","v":-2000},{"$f":"-H77*H12","v":-2000},{"$f":"-I77*I12","v":-2000}]
[null,null,"Gross Margin","[£'000]",null,{"$f":"SUM(F77:F78)","v":8000},{"$f":"SUM(G77:G78)","v":8000},8000,8000]
[null,null,"Gross Margin Pct","[%]",null,{"$f":"IF(F77=0,0,F79/F77)","v":0.8},{"$f":"IF(G77=0,0,G79/G77)","v":0.8},0.8,0.8]
[null,null,"Overheads","[£'000]",null,{"$f":"-F77*F13","v":-1000},{"$f":"-G77*G13","v":-1000},{"$f":"-H77*H13","v":-1000},{"$f":"-I77*I13","v":-1000}]
[null,null,"Depreciation","[£'000]",null,{"$f":"F35","v":-1000},{"$f":"G35","v":-900},{"$f":"H35","v":-810},{"$f":"I35","v":-729}]
[null,null,"EBIT","[£'000]",null,{"$f":"F79+F81+F82","v":6000},{"$f":"G79+G81+G82","v":6100},6190,6271]
[null,null,"EBIT Pct","[%]",null,{"$f":"IF(F77=0,0,F83/F77)","v":0.6},{"$f":"IF(G77=0,0,G83/G77)","v":0.61},0.61899999999999999,0.62709999999999999]
[null,null,"Interest","[£'000]",null,{"$f":"F57","v":-50},{"$f":"G57","v":-100},{"$f":"H57","v":-100},{"$f":"I57","v":-50}]
[null,null,"PBT","[£'000]",null,{"$f":"SUM(F83,F85)","v":5950},{"$f":"SUM(G83,G85)","v":6000},6090,6221]
[null,null,"Tax","[£'000]",null,{"$f":"-F86*F14","v":-1130.5},{"$f":"-G86*G14","v":-1140},{"$f":"-H86*H14","v":-1157.0999999999999},{"$f":"-I86*I14","v":-1181.99}]
[null,null,"PAT","[£'000]",null,{"$f":"SUM(F86:F87)","v":4819.5},{"$f":"SUM(G86:G87)","v":4860},4932.8999999999996,5039.01]
[]
[null,null,"Balance Sheet"]
[]
[null,null,"Fixed Assets","[£'000]",10000,{"$f":"F36","v":9000},{"$f":"G36","v":8100},{"$f":"H36","v":7290},{"$f":"I36","v":6561}]
[]
[null,null,"Debtors","[£'000]",900,{"$f":"F43","v":821.91780821917803},{"$f":"G43","v":821.91780821917803},{"$f":"H43","v":821.91780821917803},{"$f":"I43","v":821.91780821917803}]
[null,null,"Cash","[£'000]",6000,{"$f":"F119","v":12932.695205479453},{"$f":"G119","v":18697.445205479453},24448.895205479454,29229.350205479452]
[null,null,"Current Assets","[£'000]",{"$f":"SUM(E94:E95)","v":6900},{"$f":"SUM(F94:F95)","v":13754.61301369863},19519.363013698632,25270.813013698633,30051.268013698631]
[]
[null,null,"Creditors","[£'000]",-400,{"$f":"F50","v":-369.86301369863014},{"$f":"G50","v":-369.86301369863014},{"$f":"H50","v":-369.86301369863014},{"$f":"I50","v":-369.86301369863014}]
[null,null,"Tax","[£'000]",-500,{"$f":"F66","v":-565.25},{"$f":"G66","v":-570},{"$f":"H66","v":-578.54999999999995},{"$f":"I66","v":-590.99499999999989}]
[null,null,"Loans","[£'000]",0,{"$f":"F59","v":-1000},{"$f":"G59","v":-1000},{"$f":"H59","v":-1000},{"$f":"I59","v":0}]
[null,null,"Current Liabilities","[£'000]",{"$f":"SUM(E98:E100)","v":-900},{"$f":"SUM(F98:F100)","v":-1935.1130136986301},-1939.8630136986301,-1948.41301369863,-960.85801369862997]
[]
[null,null,"Net Current Assets","[£'000]",{"$f":"E96+E101","v":6000},{"$f":"F96+F101","v":11819.5},17579.500000000004,23322.400000000001,29090.41]
[]
[null,null,"Net Assets","[£'000]",{"$f":"E103+E92","v":16000},{"$f":"F103+F92","v":20819.5},25679.500000000004,30612.400000000001,35651.410000000003]
[]
[null,null,"Retained Earnings","[£'000]",{"$f":"E105","v":16000},{"$f":"F72","v":20819.5},{"$f":"G72","v":25679.5},{"$f":"H72","v":30612.400000000001},{"$f":"I72","v":35651.410000000003}]
[null,null,"Shareholders Funds","[£'000]",{"$f":"E107","v":16000},{"$f":"F107","v":20819.5},25679.5,30612.400000000001,35651.410000000003]
[]
[null,null,"Cashflow"]
[]
[null,null,"Receipts from Debtors","[£'000]",null,{"$f":"-F42","v":10078.082191780823},{"$f":"-G42","v":10000},{"$f":"-H42","v":10000},{"$f":"-I42","v":10000}]
[null,null,"Payment to Creditors","[£'000]",null,{"$f":"-F49","v":-3030.1369863013697},{"$f":"-G49","v":-3000},{"$f":"-H49","v":-3000},{"$f":"-I49","v":-3000}]
[null,null,"Payment to Loans","[£'000]",null,{"$f":"-SUM(F55:F56,F58)","v":950},{"$f":"-SUM(G55:G56,G58)","v":-100},{"$f":"-SUM(H55:H56,H58)","v":-100},{"$f":"-SUM(I55:I56,I58)","v":-1050}]
[null,null,"Payment to Tax","[£'000]",null,{"$f":"-F65","v":-1065.25},{"$f":"-G65","v":-1135.25},{"$f":"-H65","v":-1148.55},{"$f":"-I65","v":-1169.5450000000001}]
[null,null,"Net Cashflow","[£'000]",null,{"$f":"SUM(F112:F115)","v":6932.6952054794529},{"$f":"SUM(G112:G115)","v":5764.75},5751.45,4780.4549999999999]
[]
[null,null,"Cash b/f","[£'000]",null,{"$f":"E119","v":6000},{"$f":"F119","v":12932.695205479453},18697.445205479453,24448.895205479454]
[null,null,"Cash c/f","[£'000]",{"$f":"E95","v":6000},{"$f":"F116+F118","v":12932.695205479453},{"$f":"G116+G118","v":18697.445205479453},24448.895205479454,29229.350205479452]
[]
[null,null,"Checks"]
[]
[null,null,"Balance Sheet Balances",null,null,{"$f":"F108-F105","v":0},{"$f":"G108-G105","v":0},0,0]
[null,null,"Reserves matches P&L",null,null,{"$f":"F107-E107-F88","v":0},{"$f":"G107-F107-G88","v":0},0,0]
[null,null,"Cashflow matches balance Sheet",null,null,{"$f":"F119-F95","v":0},{"$f":"G119-G95","v":0},0,0]
[]
[{"$f":"REPT(\"End of Sheet                                                                                                                             \",10)","v":"End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             "}]

{"sheet":"2.3 Scenario Manager","index":9,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["2.3 Scenario Manager"]
[]
[]
[]
[null,null,"Selected Scenario",null,1]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G10:K10,$E$6)","v":"Base Case"},null,"Base Case","Upside","Downside","GFC","Moon Shot"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"INDEX(G12:K12,$E$6)","v":1000},null,1000,1200,800,450,1800]
[null,null,"Revenue Y2","[£'000]",{"$f":"INDEX(G13:K13,$E$6)","v":1200},null,1200,1440,960,540,2160]
[null,null,"Revenue Y3","[£'000]",{"$f":"INDEX(G14:K14,$E$6)","v":1500},null,1500,1800,1200,675,2700]
[null,null,"Revenue Y4","[£'000]",{"$f":"INDEX(G15:K15,$E$6)","v":1800},null,1800,2160,1440,810,3240]
[]
[null,null,"CoS% Y1","[%]",{"$f":"INDEX(G17:K17,$E$6)","v":0.7},null,0.7,0.65,0.7,0.8,0.7]
[null,null,"CoS% Y2","[%]",{"$f":"INDEX(G18:K18,$E$6)","v":0.69},null,0.69,0.65,0.69,0.8,0.69]
[null,null,"CoS% Y3","[%]",{"$f":"INDEX(G19:K19,$E$6)","v":0.68},null,0.68,0.65,0.68,0.8,0.68]
[null,null,"CoS% Y4","[%]",{"$f":"INDEX(G20:K20,$E$6)","v":0.67},null,0.67,0.65,0.67,0.8,0.67]
[]
[null,null,"Interest Rate Y1","[%]",{"$f":"INDEX(G22:K22,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y2","[%]",{"$f":"INDEX(G23:K23,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y3","[%]",{"$f":"INDEX(G24:K24,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y4","[%]",{"$f":"INDEX(G25:K25,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]

{"sheet":"2.3 Model Linked","index":10,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
[]
["2.3 Basic Model (linked to scenario manager)"]
[]
[null,null,"Timeline"]
[]
[null,null,"Year",null,"Year 0","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"Input Assumptions"]
[null,null,"P&L Assumptions"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"TRANSPOSE('2.3 Scenario Manager'!E12:E15)","v":1000},1200,1500,1800]
[null,null,"CoS %","[%]",null,{"$f":"TRANSPOSE('2.3 Scenario Manager'!E17:E20)","v":0.7},0.69,0.68,0.67]
[null,null,"Overheads Pct of Revenue","[%]",null,0.1,0.1,0.1,0.1]
[null,null,"Tax Rate","[%]",null,0.19,0.19,0.19,0.19]
[]
[null,null,"Fixed Assets"]
[]
[null,null,"Depreciation Rate",null,null,0.1,0.1,0.1,0.1]
[]
[null,null,"Working Capital"]
[]
[null,null,"Debtors Days",null,null,30,30,30,30]
[null,null,"Creditors Days",null,null,45,45,45,45]
[]
[null,null,"Loan"]
[]
[null,null,"Capital Drawdown","[£'000]",null,1000]
[null,null,"Capital Repayment","[£'000]",null,null,null,null,-1000]
[null,null,"Interest Rate","[%]",null,{"$f":"TRANSPOSE('2.3 Scenario Manager'!E22:E25)","v":0.03},0.03,0.03,0.03]
[]
[null,null,"Workings"]
[null,null,"Fixed Assets"]
[]
[null,null,{"$f":"C32&\" b/f\"","v":"Fixed Assets b/f"},null,null,{"$f":"E36","v":10000},{"$f":"F36","v":9000},8100,7290]
[null,null,"Depreciation",null,null,{"$f":"-F34*F18","v":-1000},{"$f":"-G34*G18","v":-900},-810,-729]
[null,null,{"$f":"C32&\" c/f\"","v":"Fixed Assets c/f"},null,{"$f":"E$92","v":10000},{"$f":"SUM(F34:F35)","v":9000},{"$f":"SUM(G34:G35)","v":8100},7290,6561]
[]
[null,null,"Debtors"]
[]
[null,null,{"$f":"C38&\" b/f\"","v":"Debtors b/f"},null,null,{"$f":"E43","v":900},{"$f":"F43","v":82.191780821917803},98.630136986301366,123.28767123287672]
[null,null,"Sales",null,null,{"$f":"F77","v":1000},{"$f":"G77","v":1200},{"$f":"H77","v":1500},{"$f":"I77","v":1800}]
[null,null,"Cash",null,null,{"$f":"F43-F40-F41","v":-1817.8082191780823},{"$f":"G43-G40-G41","v":-1183.5616438356165},-1475.3424657534247,-1775.3424657534247]
[null,null,{"$f":"C38&\" c/f\"","v":"Debtors c/f"},null,{"$f":"E$94","v":900},{"$f":"F41*F22/365","v":82.191780821917803},{"$f":"G41*G22/365","v":98.630136986301366},123.28767123287672,147.94520547945206]
[]
[null,null,"Creditors"]
[]
[null,null,{"$f":"C45&\" b/f\"","v":"Creditors b/f"},null,null,{"$f":"E50","v":-400},{"$f":"F50","v":-98.630136986301366},-116.8767123287671,-144.24657534246575]
[null,null,"Costs",null,null,{"$f":"F78+F81","v":-800},{"$f":"G78+G81","v":-947.99999999999989},{"$f":"H78+H81","v":-1170},{"$f":"I78+I81","v":-1386}]
[null,null,"Cash",null,null,{"$f":"F50-F47-F48","v":1101.3698630136987},{"$f":"G50-G47-G48","v":929.7534246575342},1142.6301369863013,1359.3698630136987]
[null,null,{"$f":"C45&\" c/f\"","v":"Creditors c/f"},null,{"$f":"E98","v":-400},{"$f":"F48*F23/365","v":-98.630136986301366},{"$f":"G48*G23/365","v":-116.8767123287671},-144.24657534246575,-170.87671232876713]
[]
[null,null,"Loan"]
[]
[null,null,{"$f":"C52&\" b/f\"","v":"Loan b/f"},null,null,{"$f":"E59","v":0},{"$f":"F59","v":-1000},-1000,-1000]
[null,null,"Capital Drawn",null,null,{"$f":"-F27","v":-1000},{"$f":"-G27","v":0},0,0]
[null,null,"Capital Repaid",null,null,{"$f":"-F28","v":0},0,0,1000]
[null,null,"Interest Charged",null,null,{"$f":"(F54+SUM(F55:F56)/2)*F29","v":-15},{"$f":"(G54+SUM(G55:G56)/2)*G29","v":-30},-30,-15]
[null,null,"Interest Paid",null,null,{"$f":"-F57","v":15},{"$f":"-G57","v":30},30,15]
[null,null,{"$f":"C52&\" c/f\"","v":"Loan c/f"},null,{"$f":"E100","v":0},{"$f":"SUM(F54:F58)","v":-1000},{"$f":"SUM(G54:G58)","v":-1000},-1000,0]
[]
[null,null,"Tax"]
[]
[null,null,{"$f":"C61&\" b/f\"","v":"Tax b/f"},null,null,{"$f":"E66","v":-500},{"$f":"F66","v":77.425000000000011},64.410000000000025,48.450000000000045]
[null,null,"Charge",null,null,{"$f":"F87","v":154.85},{"$f":"G87","v":128.82},{"$f":"H87","v":96.90000000000002},{"$f":"I87","v":62.7}]
[null,null,"Cash",null,null,{"$f":"-F64/2-E66","v":422.57499999999999},{"$f":"-F64/2-G64/2","v":-141.83499999999998},{"$f":"-G64/2-H64/2","v":-112.86000000000001},-79.800000000000011]
[null,null,{"$f":"C61&\" c/f\"","v":"Tax c/f"},null,{"$f":"E99","v":-500},{"$f":"SUM(F63:F65)","v":77.425000000000011},{"$f":"SUM(G63:G65)","v":64.410000000000025},48.450000000000045,31.350000000000037]
[]
[null,null,"Reserves"]
[]
[null,null,{"$f":"C68&\" b/f\"","v":"Reserves b/f"},null,null,{"$f":"E72","v":16000},{"$f":"F72","v":15339.85},14790.67,14377.57]
[null,null,"Profit in period",null,null,{"$f":"F88","v":-660.15},{"$f":"G88","v":-549.17999999999984},{"$f":"H88","v":-413.10000000000008},{"$f":"I88","v":-267.3}]
[null,null,{"$f":"C68&\" c/f\"","v":"Reserves c/f"},null,{"$f":"E107","v":16000},{"$f":"SUM(F70:F71)","v":15339.85},{"$f":"SUM(G70:G71)","v":14790.67},14377.57,14110.27]
[]
[null,null,"Financial Statements"]
[null,null,"P&L"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"F11","v":1000},{"$f":"G11","v":1200},{"$f":"H11","v":1500},{"$f":"I11","v":1800}]
[null,null,"Cost of Sales","[£'000]",null,{"$f":"-F77*F12","v":-700},{"$f":"-G77*G12","v":-827.99999999999989},{"$f":"-H77*H12","v":-1020.0000000000001},{"$f":"-I77*I12","v":-1206}]
[null,null,"Gross Margin","[£'000]",null,{"$f":"SUM(F77:F78)","v":300},{"$f":"SUM(G77:G78)","v":372.00000000000011},479.99999999999989,594]
[null,null,"Gross Margin Pct","[%]",null,{"$f":"IF(F77=0,0,F79/F77)","v":0.3},{"$f":"IF(G77=0,0,G79/G77)","v":0.31000000000000011},0.31999999999999995,0.33]
[null,null,"Overheads","[£'000]",null,{"$f":"-F77*F13","v":-100},{"$f":"-G77*G13","v":-120},{"$f":"-H77*H13","v":-150},{"$f":"-I77*I13","v":-180}]
[null,null,"Depreciation","[£'000]",null,{"$f":"F35","v":-1000},{"$f":"G35","v":-900},{"$f":"H35","v":-810},{"$f":"I35","v":-729}]
[null,null,"EBIT","[£'000]",null,{"$f":"F79+F81+F82","v":-800},{"$f":"G79+G81+G82","v":-647.99999999999989},-480.00000000000011,-315]
[null,null,"EBIT Pct","[%]",null,{"$f":"IF(F77=0,0,F83/F77)","v":-0.8},{"$f":"IF(G77=0,0,G83/G77)","v":-0.53999999999999992},-0.32000000000000006,-0.17499999999999999]
[null,null,"Interest","[£'000]",null,{"$f":"F57","v":-15},{"$f":"G57","v":-30},{"$f":"H57","v":-30},{"$f":"I57","v":-15}]
[null,null,"PBT","[£'000]",null,{"$f":"SUM(F83,F85)","v":-815},{"$f":"SUM(G83,G85)","v":-677.99999999999989},-510.00000000000011,-330]
[null,null,"Tax","[£'000]",null,{"$f":"-F86*F14","v":154.85},{"$f":"-G86*G14","v":128.82},{"$f":"-H86*H14","v":96.90000000000002},{"$f":"-I86*I14","v":62.7}]
[null,null,"PAT","[£'000]",null,{"$f":"SUM(F86:F87)","v":-660.15},{"$f":"SUM(G86:G87)","v":-549.17999999999984},-413.10000000000008,-267.3]
[]
[null,null,"Balance Sheet"]
[]
[null,null,"Fixed Assets","[£'000]",10000,{"$f":"F36","v":9000},{"$f":"G36","v":8100},{"$f":"H36","v":7290},{"$f":"I36","v":6561}]
[]
[null,null,"Debtors","[£'000]",900,{"$f":"F43","v":82.191780821917803},{"$f":"G43","v":98.630136986301366},{"$f":"H43","v":123.28767123287672},{"$f":"I43","v":147.94520547945206}]
[null,null,"Cash","[£'000]",6000,{"$f":"F119","v":7278.8633561643837},{"$f":"G119","v":7644.506575342466},8060.0789041095895,7540.8515068493152]
[null,null,"Current Assets","[£'000]",{"$f":"SUM(E94:E95)","v":6900},{"$f":"SUM(F94:F95)","v":7361.0551369863015},7743.1367123287673,8183.3665753424666,7688.7967123287672]
[]
[null,null,"Creditors","[£'000]",-400,{"$f":"F50","v":-98.630136986301366},{"$f":"G50","v":-116.8767123287671},{"$f":"H50","v":-144.24657534246575},{"$f":"I50","v":-170.87671232876713}]
[null,null,"Tax","[£'000]",-500,{"$f":"F66","v":77.425000000000011},{"$f":"G66","v":64.410000000000025},{"$f":"H66","v":48.450000000000045},{"$f":"I66","v":31.350000000000037}]
[null,null,"Loans","[£'000]",0,{"$f":"F59","v":-1000},{"$f":"G59","v":-1000},{"$f":"H59","v":-1000},{"$f":"I59","v":0}]
[null,null,"Current Liabilities","[£'000]",{"$f":"SUM(E98:E100)","v":-900},{"$f":"SUM(F98:F100)","v":-1021.2051369863013},-1052.466712328767,-1095.7965753424658,-139.52671232876708]
[]
[null,null,"Net Current Assets","[£'000]",{"$f":"E96+E101","v":6000},{"$f":"F96+F101","v":6339.85},6690.67,7087.5700000000006,7549.27]
[]
[null,null,"Net Assets","[£'000]",{"$f":"E103+E92","v":16000},{"$f":"F103+F92","v":15339.85},14790.67,14377.57,14110.27]
[]
[null,null,"Retained Earnings","[£'000]",{"$f":"E105","v":16000},{"$f":"F72","v":15339.85},{"$f":"G72","v":14790.67},{"$f":"H72","v":14377.57},{"$f":"I72","v":14110.27}]
[null,null,"Shareholders Funds","[£'000]",{"$f":"E107","v":16000},{"$f":"F107","v":15339.85},14790.67,14377.57,14110.27]
[]
[null,null,"Cashflow"]
[]
[null,null,"Receipts from Debtors","[£'000]",null,{"$f":"-F42","v":1817.8082191780823},{"$f":"-G42","v":1183.5616438356165},{"$f":"-H42","v":1475.3424657534247},{"$f":"-I42","v":1775.3424657534247}]
[null,null,"Payment to Creditors","[£'000]",null,{"$f":"-F49","v":-1101.3698630136987},{"$f":"-G49","v":-929.7534246575342},{"$f":"-H49","v":-1142.6301369863013},{"$f":"-I49","v":-1359.3698630136987}]
[null,null,"Payment to Loans","[£'000]",null,{"$f":"-SUM(F55:F56,F58)","v":985},{"$f":"-SUM(G55:G56,G58)","v":-30},{"$f":"-SUM(H55:H56,H58)","v":-30},{"$f":"-SUM(I55:I56,I58)","v":-1015}]
[null,null,"Payment to Tax","[£'000]",null,{"$f":"-F65","v":-422.57499999999999},{"$f":"-G65","v":141.83499999999998},{"$f":"-H65","v":112.86000000000001},{"$f":"-I65","v":79.800000000000011}]
[null,null,"Net Cashflow","[£'000]",null,{"$f":"SUM(F112:F115)","v":1278.8633561643835},{"$f":"SUM(G112:G115)","v":365.64321917808223},415.57232876712339,-519.22739726027407]
[]
[null,null,"Cash b/f","[£'000]",null,{"$f":"E119","v":6000},{"$f":"F119","v":7278.8633561643837},7644.506575342466,8060.0789041095895]
[null,null,"Cash c/f","[£'000]",{"$f":"E95","v":6000},{"$f":"F116+F118","v":7278.8633561643837},{"$f":"G116+G118","v":7644.506575342466},8060.0789041095895,7540.8515068493152]
[]
[null,null,"Checks"]
[]
[null,null,"Balance Sheet Balances",null,null,{"$f":"F108-F105","v":0},{"$f":"G108-G105","v":0},0,0]
[null,null,"Reserves matches P&L",null,null,{"$f":"F107-E107-F88","v":0},{"$f":"G107-F107-G88","v":0},0,7.3896444519050419E-13]
[null,null,"Cashflow matches balance Sheet",null,null,{"$f":"F119-F95","v":0},{"$f":"G119-G95","v":0},0,0]
[]
[{"$f":"REPT(\"End of Sheet                                                                                                                             \",10)","v":"End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             "}]

{"sheet":"2.4.1 Scenario Manager (Ex)","index":11,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["2.4.1 Scenario Manager (Example)"]
[]
[]
[]
[null,null,"Selected Scenario"]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]"]
[]
[null,null,"Revenue Y1","[£'000]"]
[null,null,"Revenue Y2","[£'000]"]
[null,null,"Revenue Y3","[£'000]"]
[null,null,"Revenue Y4","[£'000]"]
[]
[null,null,"CoS% Y1","[%]"]
[null,null,"CoS% Y2","[%]"]
[null,null,"CoS% Y3","[%]"]
[null,null,"CoS% Y4","[%]"]
[]
[null,null,"Interest Rate Y1","[%]"]
[null,null,"Interest Rate Y2","[%]"]
[null,null,"Interest Rate Y3","[%]"]
[null,null,"Interest Rate Y4","[%]"]

{"sheet":"2.4.2 Model (Ex)","index":12,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
[]
["2.4.1 Basic Model (Example)"]
[]
[null,null,"Timeline"]
[]
[null,null,"Year",null,"Year 0","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"Input Assumptions"]
[null,null,"P&L Assumptions"]
[]
[null,null,"Revenue","[£'000]",null,10000,10000,10000,10000]
[null,null,"CoS %","[%]",null,0.2,0.2,0.2,0.2]
[null,null,"Overheads Pct of Revenue","[%]",null,0.1,0.1,0.1,0.1]
[null,null,"Tax Rate","[%]",null,0.19,0.19,0.19,0.19]
[]
[null,null,"Fixed Assets"]
[]
[null,null,"Depreciation Rate",null,null,0.1,0.1,0.1,0.1]
[]
[null,null,"Working Capital"]
[]
[null,null,"Debtors Days",null,null,30,30,30,30]
[null,null,"Creditors Days",null,null,45,45,45,45]
[]
[null,null,"Loan"]
[]
[null,null,"Capital Drawdown","[£'000]",null,1000]
[null,null,"Capital Repayment","[£'000]",null,null,null,null,-1000]
[null,null,"Interest Rate","[%]",null,0.1,0.1,0.1,0.1]
[]
[null,null,"Workings"]
[null,null,"Fixed Assets"]
[]
[null,null,{"$f":"C32&\" b/f\"","v":"Fixed Assets b/f"},null,null,{"$f":"E36","v":10000},{"$f":"F36","v":9000},8100,7290]
[null,null,"Depreciation",null,null,{"$f":"-F34*F18","v":-1000},{"$f":"-G34*G18","v":-900},-810,-729]
[null,null,{"$f":"C32&\" c/f\"","v":"Fixed Assets c/f"},null,{"$f":"E$92","v":10000},{"$f":"SUM(F34:F35)","v":9000},{"$f":"SUM(G34:G35)","v":8100},7290,6561]
[]
[null,null,"Debtors"]
[]
[null,null,{"$f":"C38&\" b/f\"","v":"Debtors b/f"},null,null,{"$f":"E43","v":900},{"$f":"F43","v":821.91780821917803},821.91780821917803,821.91780821917803]
[null,null,"Sales",null,null,{"$f":"F77","v":10000},{"$f":"G77","v":10000},{"$f":"H77","v":10000},{"$f":"I77","v":10000}]
[null,null,"Cash",null,null,{"$f":"F43-F40-F41","v":-10078.082191780823},{"$f":"G43-G40-G41","v":-10000},-10000,-10000]
[null,null,{"$f":"C38&\" c/f\"","v":"Debtors c/f"},null,{"$f":"E$94","v":900},{"$f":"F41*F22/365","v":821.91780821917803},{"$f":"G41*G22/365","v":821.91780821917803},821.91780821917803,821.91780821917803]
[]
[null,null,"Creditors"]
[]
[null,null,{"$f":"C45&\" b/f\"","v":"Creditors b/f"},null,null,{"$f":"E50","v":-400},{"$f":"F50","v":-369.86301369863014},-369.86301369863014,-369.86301369863014]
[null,null,"Costs",null,null,{"$f":"F78+F81","v":-3000},{"$f":"G78+G81","v":-3000},{"$f":"H78+H81","v":-3000},{"$f":"I78+I81","v":-3000}]
[null,null,"Cash",null,null,{"$f":"F50-F47-F48","v":3030.1369863013697},{"$f":"G50-G47-G48","v":3000},3000,3000]
[null,null,{"$f":"C45&\" c/f\"","v":"Creditors c/f"},null,{"$f":"E98","v":-400},{"$f":"F48*F23/365","v":-369.86301369863014},{"$f":"G48*G23/365","v":-369.86301369863014},-369.86301369863014,-369.86301369863014]
[]
[null,null,"Loan"]
[]
[null,null,{"$f":"C52&\" b/f\"","v":"Loan b/f"},null,null,{"$f":"E59","v":0},{"$f":"F59","v":-1000},-1000,-1000]
[null,null,"Capital Drawn",null,null,{"$f":"-F27","v":-1000},{"$f":"-G27","v":0},0,0]
[null,null,"Capital Repaid",null,null,{"$f":"-F28","v":0},0,0,1000]
[null,null,"Interest Charged",null,null,{"$f":"(F54+SUM(F55:F56)/2)*F29","v":-50},{"$f":"(G54+SUM(G55:G56)/2)*G29","v":-100},-100,-50]
[null,null,"Interest Paid",null,null,{"$f":"-F57","v":50},{"$f":"-G57","v":100},100,50]
[null,null,{"$f":"C52&\" c/f\"","v":"Loan c/f"},null,{"$f":"E100","v":0},{"$f":"SUM(F54:F58)","v":-1000},{"$f":"SUM(G54:G58)","v":-1000},-1000,0]
[]
[null,null,"Tax"]
[]
[null,null,{"$f":"C61&\" b/f\"","v":"Tax b/f"},null,null,{"$f":"E66","v":-500},{"$f":"F66","v":-565.25},-570,-578.54999999999995]
[null,null,"Charge",null,null,{"$f":"F87","v":-1130.5},{"$f":"G87","v":-1140},{"$f":"H87","v":-1157.0999999999999},{"$f":"I87","v":-1181.99}]
[null,null,"Cash",null,null,{"$f":"-F64/2-E66","v":1065.25},{"$f":"-F64/2-G64/2","v":1135.25},{"$f":"-G64/2-H64/2","v":1148.55},1169.5450000000001]
[null,null,{"$f":"C61&\" c/f\"","v":"Tax c/f"},null,{"$f":"E99","v":-500},{"$f":"SUM(F63:F65)","v":-565.25},{"$f":"SUM(G63:G65)","v":-570},-578.54999999999995,-590.99499999999989]
[]
[null,null,"Reserves"]
[]
[null,null,{"$f":"C68&\" b/f\"","v":"Reserves b/f"},null,null,{"$f":"E72","v":16000},{"$f":"F72","v":20819.5},25679.5,30612.400000000001]
[null,null,"Profit in period",null,null,{"$f":"F88","v":4819.5},{"$f":"G88","v":4860},{"$f":"H88","v":4932.8999999999996},{"$f":"I88","v":5039.01}]
[null,null,{"$f":"C68&\" c/f\"","v":"Reserves c/f"},null,{"$f":"E107","v":16000},{"$f":"SUM(F70:F71)","v":20819.5},{"$f":"SUM(G70:G71)","v":25679.5},30612.400000000001,35651.410000000003]
[]
[null,null,"Financial Statements"]
[null,null,"P&L"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"F11","v":10000},{"$f":"G11","v":10000},{"$f":"H11","v":10000},{"$f":"I11","v":10000}]
[null,null,"Cost of Sales","[£'000]",null,{"$f":"-F77*F12","v":-2000},{"$f":"-G77*G12","v":-2000},{"$f":"-H77*H12","v":-2000},{"$f":"-I77*I12","v":-2000}]
[null,null,"Gross Margin","[£'000]",null,{"$f":"SUM(F77:F78)","v":8000},{"$f":"SUM(G77:G78)","v":8000},8000,8000]
[null,null,"Gross Margin Pct","[%]",null,{"$f":"IF(F77=0,0,F79/F77)","v":0.8},{"$f":"IF(G77=0,0,G79/G77)","v":0.8},0.8,0.8]
[null,null,"Overheads","[£'000]",null,{"$f":"-F77*F13","v":-1000},{"$f":"-G77*G13","v":-1000},{"$f":"-H77*H13","v":-1000},{"$f":"-I77*I13","v":-1000}]
[null,null,"Depreciation","[£'000]",null,{"$f":"F35","v":-1000},{"$f":"G35","v":-900},{"$f":"H35","v":-810},{"$f":"I35","v":-729}]
[null,null,"EBIT","[£'000]",null,{"$f":"F79+F81+F82","v":6000},{"$f":"G79+G81+G82","v":6100},6190,6271]
[null,null,"EBIT Pct","[%]",null,{"$f":"IF(F77=0,0,F83/F77)","v":0.6},{"$f":"IF(G77=0,0,G83/G77)","v":0.61},0.61899999999999999,0.62709999999999999]
[null,null,"Interest","[£'000]",null,{"$f":"F57","v":-50},{"$f":"G57","v":-100},{"$f":"H57","v":-100},{"$f":"I57","v":-50}]
[null,null,"PBT","[£'000]",null,{"$f":"SUM(F83,F85)","v":5950},{"$f":"SUM(G83,G85)","v":6000},6090,6221]
[null,null,"Tax","[£'000]",null,{"$f":"-F86*F14","v":-1130.5},{"$f":"-G86*G14","v":-1140},{"$f":"-H86*H14","v":-1157.0999999999999},{"$f":"-I86*I14","v":-1181.99}]
[null,null,"PAT","[£'000]",null,{"$f":"SUM(F86:F87)","v":4819.5},{"$f":"SUM(G86:G87)","v":4860},4932.8999999999996,5039.01]
[]
[null,null,"Balance Sheet"]
[]
[null,null,"Fixed Assets","[£'000]",10000,{"$f":"F36","v":9000},{"$f":"G36","v":8100},{"$f":"H36","v":7290},{"$f":"I36","v":6561}]
[]
[null,null,"Debtors","[£'000]",900,{"$f":"F43","v":821.91780821917803},{"$f":"G43","v":821.91780821917803},{"$f":"H43","v":821.91780821917803},{"$f":"I43","v":821.91780821917803}]
[null,null,"Cash","[£'000]",6000,{"$f":"F119","v":12932.695205479453},{"$f":"G119","v":18697.445205479453},24448.895205479454,29229.350205479452]
[null,null,"Current Assets","[£'000]",{"$f":"SUM(E94:E95)","v":6900},{"$f":"SUM(F94:F95)","v":13754.61301369863},19519.363013698632,25270.813013698633,30051.268013698631]
[]
[null,null,"Creditors","[£'000]",-400,{"$f":"F50","v":-369.86301369863014},{"$f":"G50","v":-369.86301369863014},{"$f":"H50","v":-369.86301369863014},{"$f":"I50","v":-369.86301369863014}]
[null,null,"Tax","[£'000]",-500,{"$f":"F66","v":-565.25},{"$f":"G66","v":-570},{"$f":"H66","v":-578.54999999999995},{"$f":"I66","v":-590.99499999999989}]
[null,null,"Loans","[£'000]",0,{"$f":"F59","v":-1000},{"$f":"G59","v":-1000},{"$f":"H59","v":-1000},{"$f":"I59","v":0}]
[null,null,"Current Liabilities","[£'000]",{"$f":"SUM(E98:E100)","v":-900},{"$f":"SUM(F98:F100)","v":-1935.1130136986301},-1939.8630136986301,-1948.41301369863,-960.85801369862997]
[]
[null,null,"Net Current Assets","[£'000]",{"$f":"E96+E101","v":6000},{"$f":"F96+F101","v":11819.5},17579.500000000004,23322.400000000001,29090.41]
[]
[null,null,"Net Assets","[£'000]",{"$f":"E103+E92","v":16000},{"$f":"F103+F92","v":20819.5},25679.500000000004,30612.400000000001,35651.410000000003]
[]
[null,null,"Retained Earnings","[£'000]",{"$f":"E105","v":16000},{"$f":"F72","v":20819.5},{"$f":"G72","v":25679.5},{"$f":"H72","v":30612.400000000001},{"$f":"I72","v":35651.410000000003}]
[null,null,"Shareholders Funds","[£'000]",{"$f":"E107","v":16000},{"$f":"F107","v":20819.5},25679.5,30612.400000000001,35651.410000000003]
[]
[null,null,"Cashflow"]
[]
[null,null,"Receipts from Debtors","[£'000]",null,{"$f":"-F42","v":10078.082191780823},{"$f":"-G42","v":10000},{"$f":"-H42","v":10000},{"$f":"-I42","v":10000}]
[null,null,"Payment to Creditors","[£'000]",null,{"$f":"-F49","v":-3030.1369863013697},{"$f":"-G49","v":-3000},{"$f":"-H49","v":-3000},{"$f":"-I49","v":-3000}]
[null,null,"Payment to Loans","[£'000]",null,{"$f":"-SUM(F55:F56,F58)","v":950},{"$f":"-SUM(G55:G56,G58)","v":-100},{"$f":"-SUM(H55:H56,H58)","v":-100},{"$f":"-SUM(I55:I56,I58)","v":-1050}]
[null,null,"Payment to Tax","[£'000]",null,{"$f":"-F65","v":-1065.25},{"$f":"-G65","v":-1135.25},{"$f":"-H65","v":-1148.55},{"$f":"-I65","v":-1169.5450000000001}]
[null,null,"Net Cashflow","[£'000]",null,{"$f":"SUM(F112:F115)","v":6932.6952054794529},{"$f":"SUM(G112:G115)","v":5764.75},5751.45,4780.4549999999999]
[]
[null,null,"Cash b/f","[£'000]",null,{"$f":"E119","v":6000},{"$f":"F119","v":12932.695205479453},18697.445205479453,24448.895205479454]
[null,null,"Cash c/f","[£'000]",{"$f":"E95","v":6000},{"$f":"F116+F118","v":12932.695205479453},{"$f":"G116+G118","v":18697.445205479453},24448.895205479454,29229.350205479452]
[]
[null,null,"Checks"]
[]
[null,null,"Balance Sheet Balances",null,null,{"$f":"F108-F105","v":0},{"$f":"G108-G105","v":0},0,0]
[null,null,"Reserves matches P&L",null,null,{"$f":"F107-E107-F88","v":0},{"$f":"G107-F107-G88","v":0},0,0]
[null,null,"Cashflow matches balance Sheet",null,null,{"$f":"F119-F95","v":0},{"$f":"G119-G95","v":0},0,0]
[]
[{"$f":"REPT(\"End of Sheet                                                                                                                             \",10)","v":"End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             "}]

{"sheet":"Part 3","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"3.1 Conditional Formatting","index":14,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["3.0 Conditional Formatting"]
[]
[]
[]
[null,null,"Selected Scenario",null,2]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G10:K10,$E$6)","v":"Upside"},null,"Base Case","Upside","Downside","GFC","Moon Shot"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"INDEX(G12:K12,$E$6)","v":1200},null,1000,1200,800,450,1800]
[null,null,"Revenue Y2","[£'000]",{"$f":"INDEX(G13:K13,$E$6)","v":1440},null,1200,1440,960,540,2160]
[null,null,"Revenue Y3","[£'000]",{"$f":"INDEX(G14:K14,$E$6)","v":1800},null,1500,1800,1200,675,2700]
[null,null,"Revenue Y4","[£'000]",{"$f":"INDEX(G15:K15,$E$6)","v":2160},null,1800,2160,1440,810,3240]
[]
[null,null,"CoS% Y1","[%]",{"$f":"INDEX(G17:K17,$E$6)","v":0.65},null,0.7,0.65,0.7,0.8,0.7]
[null,null,"CoS% Y2","[%]",{"$f":"INDEX(G18:K18,$E$6)","v":0.65},null,0.69,0.65,0.69,0.8,0.69]
[null,null,"CoS% Y3","[%]",{"$f":"INDEX(G19:K19,$E$6)","v":0.65},null,0.68,0.65,0.68,0.8,0.68]
[null,null,"CoS% Y4","[%]",{"$f":"INDEX(G20:K20,$E$6)","v":0.65},null,0.67,0.65,0.67,0.8,0.67]
[]
[null,null,"Interest Rate Y1","[%]",{"$f":"INDEX(G22:K22,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y2","[%]",{"$f":"INDEX(G23:K23,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y3","[%]",{"$f":"INDEX(G24:K24,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]
[null,null,"Interest Rate Y4","[%]",{"$f":"INDEX(G25:K25,$E$6)","v":0.03},null,0.03,0.03,0.03,0.05,0.03]

{"sheet":"3.2 Defaults","index":15,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["3.2 Blanks default to base case"]
[]
[]
[]
[null,null,"Selected Scenario",null,3]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G10:K10,$E$6)","v":"Downside"},null,"Base Case","Upside","Downside","GFC","Moon Shot"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G12:K12,$E$6)=\"\",G12,INDEX(G12:K12,$E$6))","v":800},null,1000,1200,800,450,1800]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G13:K13,$E$6)=\"\",G13,INDEX(G13:K13,$E$6))","v":960},null,1200,1440,960,540,2160]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G14:K14,$E$6)=\"\",G14,INDEX(G14:K14,$E$6))","v":1200},null,1500,1800,1200,675,2700]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G15:K15,$E$6)=\"\",G15,INDEX(G15:K15,$E$6))","v":1440},null,1800,2160,1440,810,3240]
[null,null,null,null,null,null,null,"","","",""]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G17:K17,$E$6)=\"\",G17,INDEX(G17:K17,$E$6))","v":0.7},null,0.7,0.65,"",0.8,""]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G18:K18,$E$6)=\"\",G18,INDEX(G18:K18,$E$6))","v":0.69},null,0.69,0.65,"",0.8,""]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G19:K19,$E$6)=\"\",G19,INDEX(G19:K19,$E$6))","v":0.68},null,0.68,0.65,"",0.8,""]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G20:K20,$E$6)=\"\",G20,INDEX(G20:K20,$E$6))","v":0.67},null,0.67,0.65,"",0.8,""]
[null,null,null,null,null,null,null,"","","",""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G22:K22,$E$6)=\"\",G22,INDEX(G22:K22,$E$6))","v":0.03},null,0.03,"","",0.05,""]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G23:K23,$E$6)=\"\",G23,INDEX(G23:K23,$E$6))","v":0.03},null,0.03,"","",0.05,""]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G24:K24,$E$6)=\"\",G24,INDEX(G24:K24,$E$6))","v":0.03},null,0.03,"","",0.05,""]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G25:K25,$E$6)=\"\",G25,INDEX(G25:K25,$E$6))","v":0.03},null,0.03,"","",0.05,""]

{"sheet":"3.2.1 Defaults + CondFmt","index":16,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["3.2 Blanks default to base case + Conditional Formatting"]
[]
[]
[]
[null,null,"Selected Scenario",null,3]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G10:K10,$E$6)","v":"Downside"},null,"Base Case","Upside","Downside","GFC","Moon Shot"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G12:K12,$E$6)=\"\",G12,INDEX(G12:K12,$E$6))","v":800},null,1000,1200,800,450,1800]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G13:K13,$E$6)=\"\",G13,INDEX(G13:K13,$E$6))","v":960},null,1200,1440,960,540,2160]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G14:K14,$E$6)=\"\",G14,INDEX(G14:K14,$E$6))","v":1200},null,1500,1800,1200,675,2700]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G15:K15,$E$6)=\"\",G15,INDEX(G15:K15,$E$6))","v":1440},null,1800,2160,1440,810,3240]
[null,null,null,null,null,null,null,"","","",""]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G17:K17,$E$6)=\"\",G17,INDEX(G17:K17,$E$6))","v":0.7},null,0.7,0.65,"",0.8,""]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G18:K18,$E$6)=\"\",G18,INDEX(G18:K18,$E$6))","v":0.69},null,0.69,0.65,"",0.8,""]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G19:K19,$E$6)=\"\",G19,INDEX(G19:K19,$E$6))","v":0.68},null,0.68,0.65,"",0.8,""]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G20:K20,$E$6)=\"\",G20,INDEX(G20:K20,$E$6))","v":0.67},null,0.67,0.65,"",0.8,""]
[null,null,null,null,null,null,null,"","","",""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G22:K22,$E$6)=\"\",G22,INDEX(G22:K22,$E$6))","v":0.03},null,0.03,"","",0.05,""]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G23:K23,$E$6)=\"\",G23,INDEX(G23:K23,$E$6))","v":0.03},null,0.03,"","",0.05,""]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G24:K24,$E$6)=\"\",G24,INDEX(G24:K24,$E$6))","v":0.03},null,0.03,"","",0.05,""]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G25:K25,$E$6)=\"\",G25,INDEX(G25:K25,$E$6))","v":0.03},null,0.03,"","",0.05,""]

{"sheet":"3.3.1 Timeline Data","index":17,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["3.3.1 Timeline data to choose in Scenario"]
[]
[null,"Month",null,null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13","M14","M15","M16","M17","M18","M19","M20","M21","M22","M23","M24"]
[]
[null,"Cashflow Profiles"]
[]
[null,"Options"]
[null,"Traditional",null,null,1000000,null,null,null,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[null,"Modular",null,null,1000000,null,null,null,500000,null,null,500000,null,null,null,null,null,null,null,null,20000,20000,20000,20000]
[null,"Spare 1"]
[null,"Spare 2"]
[null,"Spare 3"]

{"sheet":"3.3.2 Nested","index":18,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["3.3.2 Scenarios within Scenarios"]
[]
[]
[]
[null,null,"Selected Scenario",null,3]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G10:K10,$E$6)","v":"Modular + Int"},null,"Traditional Build","Modular Build","Modular + Int"]
[]
[null,null,"Build Profile","[Text]",{"$f":"IF(INDEX(G12:K12,$E$6)=\"\",G12,INDEX(G12:K12,$E$6))","v":"Modular"},null,"Traditional","Modular","Modular"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G14:K14,$E$6)=\"\",G14,INDEX(G14:K14,$E$6))","v":1000},null,1000]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G15:K15,$E$6)=\"\",G15,INDEX(G15:K15,$E$6))","v":1200},null,1200]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G16:K16,$E$6)=\"\",G16,INDEX(G16:K16,$E$6))","v":1500},null,1500]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G17:K17,$E$6)=\"\",G17,INDEX(G17:K17,$E$6))","v":1800},null,1800]
[]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G19:K19,$E$6)=\"\",G19,INDEX(G19:K19,$E$6))","v":0.7},null,0.7]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G20:K20,$E$6)=\"\",G20,INDEX(G20:K20,$E$6))","v":0.69},null,0.69]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G21:K21,$E$6)=\"\",G21,INDEX(G21:K21,$E$6))","v":0.68},null,0.68]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G22:K22,$E$6)=\"\",G22,INDEX(G22:K22,$E$6))","v":0.67},null,0.67]
[null,null,null,null,null,null,null,""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G24:K24,$E$6)=\"\",G24,INDEX(G24:K24,$E$6))","v":0.04},null,0.03,"",0.04]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G25:K25,$E$6)=\"\",G25,INDEX(G25:K25,$E$6))","v":0.04},null,0.03,"",0.04]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G26:K26,$E$6)=\"\",G26,INDEX(G26:K26,$E$6))","v":0.04},null,0.03,"",0.04]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G27:K27,$E$6)=\"\",G27,INDEX(G27:K27,$E$6))","v":0.04},null,0.03,"",0.04]

{"sheet":"3.3.3 Updated Source","index":19,"n_rows":16,"n_cols":28,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["3.3.3 Updated Source Sheet"]
[]
[null,"Month",null,null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13","M14","M15","M16","M17","M18","M19","M20","M21","M22","M23","M24"]
[]
[null,"Cashflow Profiles"]
[]
[null,"Options"]
[null,"Traditional",null,null,1000000,null,null,null,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[null,"Modular",null,null,1000000,null,null,null,500000,null,null,500000,null,null,null,null,null,null,null,null,20000,20000,20000,20000]
[null,"Spare 1"]
[null,"Spare 2"]
[null,"Spare 3"]
[]
[null,"Selected"]
[null,{"$f":"'3.3.2 Nested'!E12","v":"Modular"},{"$f":"MATCH(B16,B9:B13,0)","v":2},null,{"$f":"INDEX(E9:E13,$C16)","v":1000000},{"$f":"INDEX(F9:F13,$C16)","v":0},{"$f":"INDEX(G9:G13,$C16)","v":0},{"$f":"INDEX(H9:H13,$C16)","v":0},{"$f":"INDEX(I9:I13,$C16)","v":500000},{"$f":"INDEX(J9:J13,$C16)","v":0},{"$f":"INDEX(K9:K13,$C16)","v":0},{"$f":"INDEX(L9:L13,$C16)","v":500000},{"$f":"INDEX(M9:M13,$C16)","v":0},{"$f":"INDEX(N9:N13,$C16)","v":0},{"$f":"INDEX(O9:O13,$C16)","v":0},{"$f":"INDEX(P9:P13,$C16)","v":0},{"$f":"INDEX(Q9:Q13,$C16)","v":0},{"$f":"INDEX(R9:R13,$C16)","v":0},{"$f":"INDEX(S9:S13,$C16)","v":0},{"$f":"INDEX(T9:T13,$C16)","v":0},{"$f":"INDEX(U9:U13,$C16)","v":20000},{"$f":"INDEX(V9:V13,$C16)","v":20000},{"$f":"INDEX(W9:W13,$C16)","v":20000},{"$f":"INDEX(X9:X13,$C16)","v":20000},{"$f":"INDEX(Y9:Y13,$C16)","v":0},{"$f":"INDEX(Z9:Z13,$C16)","v":0},{"$f":"INDEX(AA9:AA13,$C16)","v":0},{"$f":"INDEX(AB9:AB13,$C16)","v":0}]

{"sheet":"3.4 Form Controls","index":20,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
["3.4 Form Controls"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"TRANSPOSE(G17:K17)","v":"Traditional Build"}]
[null,null,null,null,"Modular Build"]
[null,null,null,null,"Modular + Int"]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[null,null,"Selected Scenario",null,1]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G17:K17,$E$13)","v":"Traditional Build"},null,"Traditional Build","Modular Build","Modular + Int"]
[]
[null,null,"Build Profile","[Text]",{"$f":"IF(INDEX(G19:K19,$E$13)=\"\",G19,INDEX(G19:K19,$E$13))","v":"Traditional"},null,"Traditional","Modular","Modular"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G21:K21,$E$13)=\"\",G21,INDEX(G21:K21,$E$13))","v":1000},null,1000]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G22:K22,$E$13)=\"\",G22,INDEX(G22:K22,$E$13))","v":1200},null,1200]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G23:K23,$E$13)=\"\",G23,INDEX(G23:K23,$E$13))","v":1500},null,1500]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G24:K24,$E$13)=\"\",G24,INDEX(G24:K24,$E$13))","v":1800},null,1800]
[]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G26:K26,$E$13)=\"\",G26,INDEX(G26:K26,$E$13))","v":0.7},null,0.7]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G27:K27,$E$13)=\"\",G27,INDEX(G27:K27,$E$13))","v":0.69},null,0.69]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G28:K28,$E$13)=\"\",G28,INDEX(G28:K28,$E$13))","v":0.68},null,0.68]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G29:K29,$E$13)=\"\",G29,INDEX(G29:K29,$E$13))","v":0.67},null,0.67]
[null,null,null,null,null,null,null,""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G31:K31,$E$13)=\"\",G31,INDEX(G31:K31,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G32:K32,$E$13)=\"\",G32,INDEX(G32:K32,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G33:K33,$E$13)=\"\",G33,INDEX(G33:K33,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G34:K34,$E$13)=\"\",G34,INDEX(G34:K34,$E$13))","v":0.03},null,0.03,"",0.04]

{"sheet":"3.4.1 Other Sheet","index":21,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["3.4.1 Another Sheet"]

{"sheet":"3.5 Form Controls (Ex)","index":22,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["3.5 Form Controls Example"]
[]
[]
[]
[]
[null,null,"Selected Scenario",null,1]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G11:K11,$E$7)","v":"Traditional Build"},null,"Traditional Build","Modular Build","Modular + Int"]
[]
[null,null,"Build Profile","[Text]",{"$f":"IF(INDEX(G13:K13,$E$7)=\"\",G13,INDEX(G13:K13,$E$7))","v":"Traditional"},null,"Traditional","Modular","Modular"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G15:K15,$E$7)=\"\",G15,INDEX(G15:K15,$E$7))","v":1000},null,1000]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G16:K16,$E$7)=\"\",G16,INDEX(G16:K16,$E$7))","v":1200},null,1200]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G17:K17,$E$7)=\"\",G17,INDEX(G17:K17,$E$7))","v":1500},null,1500]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G18:K18,$E$7)=\"\",G18,INDEX(G18:K18,$E$7))","v":1800},null,1800]
[]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G20:K20,$E$7)=\"\",G20,INDEX(G20:K20,$E$7))","v":0.7},null,0.7]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G21:K21,$E$7)=\"\",G21,INDEX(G21:K21,$E$7))","v":0.69},null,0.69]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G22:K22,$E$7)=\"\",G22,INDEX(G22:K22,$E$7))","v":0.68},null,0.68]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G23:K23,$E$7)=\"\",G23,INDEX(G23:K23,$E$7))","v":0.67},null,0.67]
[null,null,null,null,null,null,null,""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G25:K25,$E$7)=\"\",G25,INDEX(G25:K25,$E$7))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G26:K26,$E$7)=\"\",G26,INDEX(G26:K26,$E$7))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G27:K27,$E$7)=\"\",G27,INDEX(G27:K27,$E$7))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G28:K28,$E$7)=\"\",G28,INDEX(G28:K28,$E$7))","v":0.03},null,0.03,"",0.04]

{"sheet":"3.5.1 Other Sheet (Ex)","index":23,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["3.5.1 Another Sheet"]

{"sheet":"3.5.2 Other Sheet (Ex)","index":24,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["3.5.2 Another Sheet"]

{"sheet":"Part 4","index":25,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"4.1 Macro","index":26,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["4.1 Macros"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"TRANSPOSE(G17:K17)","v":"Traditional Build"}]
[null,null,null,null,"Modular Build"]
[null,null,null,null,"Modular + Int"]
[null,null,null,null,"Extra Revenue"]
[null,null,null,null,0]
[]
[null,null,"Selected Scenario",null,2]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G17:K17,$E$13)","v":"Modular Build"},null,"Traditional Build","Modular Build","Modular + Int","Extra Revenue"]
[]
[null,null,"Build Profile","[Text]",{"$f":"IF(INDEX(G19:K19,$E$13)=\"\",G19,INDEX(G19:K19,$E$13))","v":"Modular"},null,"Traditional","Modular","Modular"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G21:K21,$E$13)=\"\",G21,INDEX(G21:K21,$E$13))","v":10000},null,10000,null,null,50000]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G22:K22,$E$13)=\"\",G22,INDEX(G22:K22,$E$13))","v":12000},null,12000,null,null,60000]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G23:K23,$E$13)=\"\",G23,INDEX(G23:K23,$E$13))","v":15000},null,15000,null,null,100000]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G24:K24,$E$13)=\"\",G24,INDEX(G24:K24,$E$13))","v":18000},null,18000,null,null,120000]
[]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G26:K26,$E$13)=\"\",G26,INDEX(G26:K26,$E$13))","v":0.2},null,0.2]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G27:K27,$E$13)=\"\",G27,INDEX(G27:K27,$E$13))","v":0.21},null,0.21]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G28:K28,$E$13)=\"\",G28,INDEX(G28:K28,$E$13))","v":0.22},null,0.22]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G29:K29,$E$13)=\"\",G29,INDEX(G29:K29,$E$13))","v":0.23},null,0.23]
[null,null,null,null,null,null,null,""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G31:K31,$E$13)=\"\",G31,INDEX(G31:K31,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G32:K32,$E$13)=\"\",G32,INDEX(G32:K32,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G33:K33,$E$13)=\"\",G33,INDEX(G33:K33,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G34:K34,$E$13)=\"\",G34,INDEX(G34:K34,$E$13))","v":0.03},null,0.03,"",0.04]
[]
[null,null,"Discount Rate","[%]",{"$f":"IF(INDEX(G36:K36,$E$13)=\"\",G36,INDEX(G36:K36,$E$13))","v":0.04},null,0.04,""]
[]
[null,null,"NPV","[£'000]",{"$f":"'4.1.1 Model NPV'!E91","v":24740.855460680647},null,24740.855460680647,24740.855460680647,24718.809497107064,160290.86164262454,24740.855460680647]

{"sheet":"4.1.1 Model NPV","index":27,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
[]
["4.1.1 Basic Model (linked to scenario manager)"]
[]
[null,null,"Timeline"]
[]
[null,null,"Year",null,"Year 0","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"Input Assumptions"]
[null,null,"P&L Assumptions"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"TRANSPOSE('4.1 Macro'!E21:E24)","v":10000},12000,15000,18000]
[null,null,"CoS %","[%]",null,{"$f":"TRANSPOSE('4.1 Macro'!E26:E29)","v":0.2},0.21,0.22,0.23]
[null,null,"Overheads Pct of Revenue","[%]",null,0.1,0.1,0.1,0.1]
[null,null,"Tax Rate","[%]",null,0.19,0.19,0.19,0.19]
[]
[null,null,"Fixed Assets"]
[]
[null,null,"Depreciation Rate",null,null,0.1,0.1,0.1,0.1]
[]
[null,null,"Working Capital"]
[]
[null,null,"Debtors Days",null,null,30,30,30,30]
[null,null,"Creditors Days",null,null,45,45,45,45]
[]
[null,null,"Loan"]
[]
[null,null,"Capital Drawdown","[£'000]",null,1000]
[null,null,"Capital Repayment","[£'000]",null,null,null,null,-1000]
[null,null,"Interest Rate","[%]",null,{"$f":"TRANSPOSE('4.1 Macro'!E31:E34)","v":0.03},0.03,0.03,0.03]
[]
[null,null,"Workings"]
[null,null,"Fixed Assets"]
[]
[null,null,{"$f":"C32&\" b/f\"","v":"Fixed Assets b/f"},null,null,{"$f":"E36","v":10000},{"$f":"F36","v":9000},8100,7290]
[null,null,"Depreciation",null,null,{"$f":"-F34*F18","v":-1000},{"$f":"-G34*G18","v":-900},-810,-729]
[null,null,{"$f":"C32&\" c/f\"","v":"Fixed Assets c/f"},null,{"$f":"E$95","v":10000},{"$f":"SUM(F34:F35)","v":9000},{"$f":"SUM(G34:G35)","v":8100},7290,6561]
[]
[null,null,"Debtors"]
[]
[null,null,{"$f":"C38&\" b/f\"","v":"Debtors b/f"},null,null,{"$f":"E43","v":900},{"$f":"F43","v":821.91780821917803},986.30136986301375,1232.8767123287671]
[null,null,"Sales",null,null,{"$f":"F77","v":10000},{"$f":"G77","v":12000},{"$f":"H77","v":15000},{"$f":"I77","v":18000}]
[null,null,"Cash",null,null,{"$f":"F43-F40-F41","v":-10078.082191780823},{"$f":"G43-G40-G41","v":-11835.616438356165},-14753.424657534246,-17753.424657534248]
[null,null,{"$f":"C38&\" c/f\"","v":"Debtors c/f"},null,{"$f":"E$97","v":900},{"$f":"F41*F22/365","v":821.91780821917803},{"$f":"G41*G22/365","v":986.30136986301375},1232.8767123287671,1479.4520547945206]
[]
[null,null,"Creditors"]
[]
[null,null,{"$f":"C45&\" b/f\"","v":"Creditors b/f"},null,null,{"$f":"E50","v":-400},{"$f":"F50","v":-369.86301369863014},-458.63013698630135,-591.78082191780823]
[null,null,"Costs",null,null,{"$f":"F78+F81","v":-3000},{"$f":"G78+G81","v":-3720},{"$f":"H78+H81","v":-4800},{"$f":"I78+I81","v":-5940}]
[null,null,"Cash",null,null,{"$f":"F50-F47-F48","v":3030.1369863013697},{"$f":"G50-G47-G48","v":3631.232876712329},4666.8493150684935,5799.4520547945203]
[null,null,{"$f":"C45&\" c/f\"","v":"Creditors c/f"},null,{"$f":"E101","v":-400},{"$f":"F48*F23/365","v":-369.86301369863014},{"$f":"G48*G23/365","v":-458.63013698630135},-591.78082191780823,-732.32876712328766]
[]
[null,null,"Loan"]
[]
[null,null,{"$f":"C52&\" b/f\"","v":"Loan b/f"},null,null,{"$f":"E59","v":0},{"$f":"F59","v":-1000},-1000,-1000]
[null,null,"Capital Drawn",null,null,{"$f":"-F27","v":-1000},{"$f":"-G27","v":0},0,0]
[null,null,"Capital Repaid",null,null,{"$f":"-F28","v":0},0,0,1000]
[null,null,"Interest Charged",null,null,{"$f":"(F54+SUM(F55:F56)/2)*F29","v":-15},{"$f":"(G54+SUM(G55:G56)/2)*G29","v":-30},-30,-15]
[null,null,"Interest Paid",null,null,{"$f":"-F57","v":15},{"$f":"-G57","v":30},30,15]
[null,null,{"$f":"C52&\" c/f\"","v":"Loan c/f"},null,{"$f":"E103","v":0},{"$f":"SUM(F54:F58)","v":-1000},{"$f":"SUM(G54:G58)","v":-1000},-1000,0]
[]
[null,null,"Tax"]
[]
[null,null,{"$f":"C61&\" b/f\"","v":"Tax b/f"},null,null,{"$f":"E66","v":-500},{"$f":"F66","v":-568.57500000000005},-698.25,-889.2]
[null,null,"Charge",null,null,{"$f":"F87","v":-1137.1500000000001},{"$f":"G87","v":-1396.5},{"$f":"H87","v":-1778.4},{"$f":"I87","v":-2150.04}]
[null,null,"Cash",null,null,{"$f":"-F64/2-E66","v":1068.575},{"$f":"-F64/2-G64/2","v":1266.825},{"$f":"-G64/2-H64/2","v":1587.45},1964.22]
[null,null,{"$f":"C61&\" c/f\"","v":"Tax c/f"},null,{"$f":"E102","v":-500},{"$f":"SUM(F63:F65)","v":-568.57500000000005},{"$f":"SUM(G63:G65)","v":-698.25},-889.2,-1075.0199999999998]
[]
[null,null,"Reserves"]
[]
[null,null,{"$f":"C68&\" b/f\"","v":"Reserves b/f"},null,null,{"$f":"E72","v":16000},{"$f":"F72","v":20847.849999999999},26801.35,34382.949999999997]
[null,null,"Profit in period",null,null,{"$f":"F88","v":4847.8500000000004},{"$f":"G88","v":5953.5},{"$f":"H88","v":7581.6},{"$f":"I88","v":9165.9599999999991}]
[null,null,{"$f":"C68&\" c/f\"","v":"Reserves c/f"},null,{"$f":"E110","v":16000},{"$f":"SUM(F70:F71)","v":20847.849999999999},{"$f":"SUM(G70:G71)","v":26801.35},34382.949999999997,43548.909999999996]
[]
[null,null,"Financial Statements"]
[null,null,"P&L"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"F11","v":10000},{"$f":"G11","v":12000},{"$f":"H11","v":15000},{"$f":"I11","v":18000}]
[null,null,"Cost of Sales","[£'000]",null,{"$f":"-F77*F12","v":-2000},{"$f":"-G77*G12","v":-2520},{"$f":"-H77*H12","v":-3300},{"$f":"-I77*I12","v":-4140}]
[null,null,"Gross Margin","[£'000]",null,{"$f":"SUM(F77:F78)","v":8000},{"$f":"SUM(G77:G78)","v":9480},11700,13860]
[null,null,"Gross Margin Pct","[%]",null,{"$f":"IF(F77=0,0,F79/F77)","v":0.8},{"$f":"IF(G77=0,0,G79/G77)","v":0.79},0.78,0.77]
[null,null,"Overheads","[£'000]",null,{"$f":"-F77*F13","v":-1000},{"$f":"-G77*G13","v":-1200},{"$f":"-H77*H13","v":-1500},{"$f":"-I77*I13","v":-1800}]
[null,null,"Depreciation","[£'000]",null,{"$f":"F35","v":-1000},{"$f":"G35","v":-900},{"$f":"H35","v":-810},{"$f":"I35","v":-729}]
[null,null,"EBIT","[£'000]",null,{"$f":"F79+F81+F82","v":6000},{"$f":"G79+G81+G82","v":7380},9390,11331]
[null,null,"EBIT Pct","[%]",null,{"$f":"IF(F77=0,0,F83/F77)","v":0.6},{"$f":"IF(G77=0,0,G83/G77)","v":0.61499999999999999},0.626,0.62949999999999995]
[null,null,"Interest","[£'000]",null,{"$f":"F57","v":-15},{"$f":"G57","v":-30},{"$f":"H57","v":-30},{"$f":"I57","v":-15}]
[null,null,"PBT","[£'000]",null,{"$f":"SUM(F83,F85)","v":5985},{"$f":"SUM(G83,G85)","v":7350},9360,11316]
[null,null,"Tax","[£'000]",null,{"$f":"-F86*F14","v":-1137.1500000000001},{"$f":"-G86*G14","v":-1396.5},{"$f":"-H86*H14","v":-1778.4},{"$f":"-I86*I14","v":-2150.04}]
[null,null,"PAT","[£'000]",null,{"$f":"SUM(F86:F87)","v":4847.8500000000004},{"$f":"SUM(G86:G87)","v":5953.5},7581.6,9165.9599999999991]
[]
[null,null,"Discount Rate","[%]",{"$f":"'4.1 Macro'!E36","v":0.04}]
[null,null,"NPV","[£'000]",{"$f":"NPV(E90,F88:I88)","v":24740.855460680647}]
[]
[null,null,"Balance Sheet"]
[]
[null,null,"Fixed Assets","[£'000]",10000,{"$f":"F36","v":9000},{"$f":"G36","v":8100},{"$f":"H36","v":7290},{"$f":"I36","v":6561}]
[]
[null,null,"Debtors","[£'000]",900,{"$f":"F43","v":821.91780821917803},{"$f":"G43","v":986.30136986301375},{"$f":"H43","v":1232.8767123287671},{"$f":"I43","v":1479.4520547945206}]
[null,null,"Cash","[£'000]",6000,{"$f":"F122","v":12964.370205479452},{"$f":"G122","v":19871.928767123289},28341.05410958904,37315.806712328769]
[null,null,"Current Assets","[£'000]",{"$f":"SUM(E97:E98)","v":6900},{"$f":"SUM(F97:F98)","v":13786.28801369863},20858.230136986302,29573.930821917806,38795.25876712329]
[]
[null,null,"Creditors","[£'000]",-400,{"$f":"F50","v":-369.86301369863014},{"$f":"G50","v":-458.63013698630135},{"$f":"H50","v":-591.78082191780823},{"$f":"I50","v":-732.32876712328766}]
[null,null,"Tax","[£'000]",-500,{"$f":"F66","v":-568.57500000000005},{"$f":"G66","v":-698.25},{"$f":"H66","v":-889.2},{"$f":"I66","v":-1075.0199999999998}]
[null,null,"Loans","[£'000]",0,{"$f":"F59","v":-1000},{"$f":"G59","v":-1000},{"$f":"H59","v":-1000},{"$f":"I59","v":0}]
[null,null,"Current Liabilities","[£'000]",{"$f":"SUM(E101:E103)","v":-900},{"$f":"SUM(F101:F103)","v":-1938.4380136986301},-2156.8801369863013,-2480.9808219178085,-1807.3487671232874]
[]
[null,null,"Net Current Assets","[£'000]",{"$f":"E99+E104","v":6000},{"$f":"F99+F104","v":11847.849999999999},18701.349999999999,27092.949999999997,36987.910000000003]
[]
[null,null,"Net Assets","[£'000]",{"$f":"E106+E95","v":16000},{"$f":"F106+F95","v":20847.849999999999},26801.35,34382.949999999997,43548.91]
[]
[null,null,"Retained Earnings","[£'000]",{"$f":"E108","v":16000},{"$f":"F72","v":20847.849999999999},{"$f":"G72","v":26801.35},{"$f":"H72","v":34382.949999999997},{"$f":"I72","v":43548.909999999996}]
[null,null,"Shareholders Funds","[£'000]",{"$f":"E110","v":16000},{"$f":"F110","v":20847.849999999999},26801.35,34382.949999999997,43548.909999999996]
[]
[null,null,"Cashflow"]
[]
[null,null,"Receipts from Debtors","[£'000]",null,{"$f":"-F42","v":10078.082191780823},{"$f":"-G42","v":11835.616438356165},{"$f":"-H42","v":14753.424657534246},{"$f":"-I42","v":17753.424657534248}]
[null,null,"Payment to Creditors","[£'000]",null,{"$f":"-F49","v":-3030.1369863013697},{"$f":"-G49","v":-3631.232876712329},{"$f":"-H49","v":-4666.8493150684935},{"$f":"-I49","v":-5799.4520547945203}]
[null,null,"Payment to Loans","[£'000]",null,{"$f":"-SUM(F55:F56,F58)","v":985},{"$f":"-SUM(G55:G56,G58)","v":-30},{"$f":"-SUM(H55:H56,H58)","v":-30},{"$f":"-SUM(I55:I56,I58)","v":-1015}]
[null,null,"Payment to Tax","[£'000]",null,{"$f":"-F65","v":-1068.575},{"$f":"-G65","v":-1266.825},{"$f":"-H65","v":-1587.45},{"$f":"-I65","v":-1964.22}]
[null,null,"Net Cashflow","[£'000]",null,{"$f":"SUM(F115:F118)","v":6964.370205479453},{"$f":"SUM(G115:G118)","v":6907.5585616438357},8469.1253424657516,8974.7526027397271]
[]
[null,null,"Cash b/f","[£'000]",null,{"$f":"E122","v":6000},{"$f":"F122","v":12964.370205479452},19871.928767123289,28341.05410958904]
[null,null,"Cash c/f","[£'000]",{"$f":"E98","v":6000},{"$f":"F119+F121","v":12964.370205479452},{"$f":"G119+G121","v":19871.928767123289},28341.05410958904,37315.806712328769]
[]
[null,null,"Checks"]
[]
[null,null,"Balance Sheet Balances",null,null,{"$f":"F111-F108","v":0},{"$f":"G111-G108","v":0},0,0]
[null,null,"Reserves matches P&L",null,null,{"$f":"F110-E110-F88","v":0},{"$f":"G110-F110-G88","v":0},0,0]
[null,null,"Cashflow matches balance Sheet",null,null,{"$f":"F122-F98","v":0},{"$f":"G122-G98","v":0},0,0]
[]
[{"$f":"REPT(\"End of Sheet                                                                                                                             \",10)","v":"End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             "}]

{"sheet":"Part 5","index":28,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"5.1 Data Table","index":29,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
["5.1 Data Table"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"TRANSPOSE(G17:K17)","v":"Traditional Build"}]
[null,null,null,null,"Modular Build"]
[null,null,null,null,"Modular + Int"]
[null,null,null,null,"Extra Revenue"]
[null,null,null,null,0]
[]
[null,null,"Selected Scenario",null,4]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G17:K17,$E$13)","v":"Extra Revenue"},null,"Traditional Build","Modular Build","Modular + Int","Extra Revenue"]
[]
[null,null,"Build Profile","[Text]",{"$f":"IF(INDEX(G19:K19,$E$13)=\"\",G19,INDEX(G19:K19,$E$13))","v":"Traditional"},null,"Traditional","Modular","Modular"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G21:K21,$E$13)=\"\",G21,INDEX(G21:K21,$E$13))","v":50000},null,10000,null,null,50000]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G22:K22,$E$13)=\"\",G22,INDEX(G22:K22,$E$13))","v":60000},null,12000,null,null,60000]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G23:K23,$E$13)=\"\",G23,INDEX(G23:K23,$E$13))","v":100000},null,15000,null,null,100000]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G24:K24,$E$13)=\"\",G24,INDEX(G24:K24,$E$13))","v":120000},null,18000,null,null,120000]
[]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G26:K26,$E$13)=\"\",G26,INDEX(G26:K26,$E$13))","v":0.2},null,0.2]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G27:K27,$E$13)=\"\",G27,INDEX(G27:K27,$E$13))","v":0.21},null,0.21]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G28:K28,$E$13)=\"\",G28,INDEX(G28:K28,$E$13))","v":0.22},null,0.22]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G29:K29,$E$13)=\"\",G29,INDEX(G29:K29,$E$13))","v":0.23},null,0.23]
[null,null,null,null,null,null,null,""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G31:K31,$E$13)=\"\",G31,INDEX(G31:K31,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G32:K32,$E$13)=\"\",G32,INDEX(G32:K32,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G33:K33,$E$13)=\"\",G33,INDEX(G33:K33,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G34:K34,$E$13)=\"\",G34,INDEX(G34:K34,$E$13))","v":0.03},null,0.03,"",0.04]
[]
[null,null,"Discount Rate","[%]",{"$f":"IF(INDEX(G36:K36,$E$13)=\"\",G36,INDEX(G36:K36,$E$13))","v":0.04},null,0.04,""]
[]
[null,null,null,null,null,null,{"$f":"G15","v":1},{"$f":"H15","v":2},3,4,5]
[null,null,"NPV","[£'000]",null,{"$f":"'5.1.1 Model'!E91","v":160290.86164262454},24740.855460680647,24740.855460680647,24718.809497107064,160290.86164262454,24740.855460680647]

{"sheet":"5.1.1 Model","index":30,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
[]
["5.1.1 Basic Model (linked to scenario manager)"]
[]
[null,null,"Timeline"]
[]
[null,null,"Year",null,"Year 0","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"Input Assumptions"]
[null,null,"P&L Assumptions"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"TRANSPOSE('5.1 Data Table'!E21:E24)","v":50000},60000,100000,120000]
[null,null,"CoS %","[%]",null,{"$f":"TRANSPOSE('5.1 Data Table'!E26:E29)","v":0.2},0.21,0.22,0.23]
[null,null,"Overheads Pct of Revenue","[%]",null,0.1,0.1,0.1,0.1]
[null,null,"Tax Rate","[%]",null,0.19,0.19,0.19,0.19]
[]
[null,null,"Fixed Assets"]
[]
[null,null,"Depreciation Rate",null,null,0.1,0.1,0.1,0.1]
[]
[null,null,"Working Capital"]
[]
[null,null,"Debtors Days",null,null,30,30,30,30]
[null,null,"Creditors Days",null,null,45,45,45,45]
[]
[null,null,"Loan"]
[]
[null,null,"Capital Drawdown","[£'000]",null,1000]
[null,null,"Capital Repayment","[£'000]",null,null,null,null,-1000]
[null,null,"Interest Rate","[%]",null,{"$f":"TRANSPOSE('5.1 Data Table'!E31:E34)","v":0.03},0.03,0.03,0.03]
[]
[null,null,"Workings"]
[null,null,"Fixed Assets"]
[]
[null,null,{"$f":"C32&\" b/f\"","v":"Fixed Assets b/f"},null,null,{"$f":"E36","v":10000},{"$f":"F36","v":9000},8100,7290]
[null,null,"Depreciation",null,null,{"$f":"-F34*F18","v":-1000},{"$f":"-G34*G18","v":-900},-810,-729]
[null,null,{"$f":"C32&\" c/f\"","v":"Fixed Assets c/f"},null,{"$f":"E$95","v":10000},{"$f":"SUM(F34:F35)","v":9000},{"$f":"SUM(G34:G35)","v":8100},7290,6561]
[]
[null,null,"Debtors"]
[]
[null,null,{"$f":"C38&\" b/f\"","v":"Debtors b/f"},null,null,{"$f":"E43","v":900},{"$f":"F43","v":4109.58904109589},4931.5068493150684,8219.17808219178]
[null,null,"Sales",null,null,{"$f":"F77","v":50000},{"$f":"G77","v":60000},{"$f":"H77","v":100000},{"$f":"I77","v":120000}]
[null,null,"Cash",null,null,{"$f":"F43-F40-F41","v":-46790.410958904111},{"$f":"G43-G40-G41","v":-59178.082191780821},-96712.328767123283,-118356.16438356164]
[null,null,{"$f":"C38&\" c/f\"","v":"Debtors c/f"},null,{"$f":"E$97","v":900},{"$f":"F41*F22/365","v":4109.58904109589},{"$f":"G41*G22/365","v":4931.5068493150684},8219.17808219178,9863.0136986301368]
[]
[null,null,"Creditors"]
[]
[null,null,{"$f":"C45&\" b/f\"","v":"Creditors b/f"},null,null,{"$f":"E50","v":-400},{"$f":"F50","v":-1849.3150684931506},-2293.1506849315069,-3945.205479452055]
[null,null,"Costs",null,null,{"$f":"F78+F81","v":-15000},{"$f":"G78+G81","v":-18600},{"$f":"H78+H81","v":-32000},{"$f":"I78+I81","v":-39600}]
[null,null,"Cash",null,null,{"$f":"F50-F47-F48","v":13550.68493150685},{"$f":"G50-G47-G48","v":18156.164383561645},30347.945205479453,38663.013698630137]
[null,null,{"$f":"C45&\" c/f\"","v":"Creditors c/f"},null,{"$f":"E101","v":-400},{"$f":"F48*F23/365","v":-1849.3150684931506},{"$f":"G48*G23/365","v":-2293.1506849315069},-3945.205479452055,-4882.1917808219177]
[]
[null,null,"Loan"]
[]
[null,null,{"$f":"C52&\" b/f\"","v":"Loan b/f"},null,null,{"$f":"E59","v":0},{"$f":"F59","v":-1000},-1000,-1000]
[null,null,"Capital Drawn",null,null,{"$f":"-F27","v":-1000},{"$f":"-G27","v":0},0,0]
[null,null,"Capital Repaid",null,null,{"$f":"-F28","v":0},0,0,1000]
[null,null,"Interest Charged",null,null,{"$f":"(F54+SUM(F55:F56)/2)*F29","v":-15},{"$f":"(G54+SUM(G55:G56)/2)*G29","v":-30},-30,-15]
[null,null,"Interest Paid",null,null,{"$f":"-F57","v":15},{"$f":"-G57","v":30},30,15]
[null,null,{"$f":"C52&\" c/f\"","v":"Loan c/f"},null,{"$f":"E103","v":0},{"$f":"SUM(F54:F58)","v":-1000},{"$f":"SUM(G54:G58)","v":-1000},-1000,0]
[]
[null,null,"Tax"]
[]
[null,null,{"$f":"C61&\" b/f\"","v":"Tax b/f"},null,null,{"$f":"E66","v":-500},{"$f":"F66","v":-3228.5749999999998},-3844.6499999999996,-6380.1999999999989]
[null,null,"Charge",null,null,{"$f":"F87","v":-6457.15},{"$f":"G87","v":-7689.3},{"$f":"H87","v":-12760.4},{"$f":"I87","v":-15134.64}]
[null,null,"Cash",null,null,{"$f":"-F64/2-E66","v":3728.5749999999998},{"$f":"-F64/2-G64/2","v":7073.2250000000004},{"$f":"-G64/2-H64/2","v":10224.85},13947.52]
[null,null,{"$f":"C61&\" c/f\"","v":"Tax c/f"},null,{"$f":"E102","v":-500},{"$f":"SUM(F63:F65)","v":-3228.5749999999998},{"$f":"SUM(G63:G65)","v":-3844.6499999999996},-6380.1999999999989,-7567.3199999999961]
[]
[null,null,"Reserves"]
[]
[null,null,{"$f":"C68&\" b/f\"","v":"Reserves b/f"},null,null,{"$f":"E72","v":16000},{"$f":"F72","v":43527.85},76308.549999999988,130708.15]
[null,null,"Profit in period",null,null,{"$f":"F88","v":27527.85},{"$f":"G88","v":32780.699999999997},{"$f":"H88","v":54399.6},{"$f":"I88","v":64521.36}]
[null,null,{"$f":"C68&\" c/f\"","v":"Reserves c/f"},null,{"$f":"E110","v":16000},{"$f":"SUM(F70:F71)","v":43527.85},{"$f":"SUM(G70:G71)","v":76308.549999999988},130708.15,195229.51]
[]
[null,null,"Financial Statements"]
[null,null,"P&L"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"F11","v":50000},{"$f":"G11","v":60000},{"$f":"H11","v":100000},{"$f":"I11","v":120000}]
[null,null,"Cost of Sales","[£'000]",null,{"$f":"-F77*F12","v":-10000},{"$f":"-G77*G12","v":-12600},{"$f":"-H77*H12","v":-22000},{"$f":"-I77*I12","v":-27600}]
[null,null,"Gross Margin","[£'000]",null,{"$f":"SUM(F77:F78)","v":40000},{"$f":"SUM(G77:G78)","v":47400},78000,92400]
[null,null,"Gross Margin Pct","[%]",null,{"$f":"IF(F77=0,0,F79/F77)","v":0.8},{"$f":"IF(G77=0,0,G79/G77)","v":0.79},0.78,0.77]
[null,null,"Overheads","[£'000]",null,{"$f":"-F77*F13","v":-5000},{"$f":"-G77*G13","v":-6000},{"$f":"-H77*H13","v":-10000},{"$f":"-I77*I13","v":-12000}]
[null,null,"Depreciation","[£'000]",null,{"$f":"F35","v":-1000},{"$f":"G35","v":-900},{"$f":"H35","v":-810},{"$f":"I35","v":-729}]
[null,null,"EBIT","[£'000]",null,{"$f":"F79+F81+F82","v":34000},{"$f":"G79+G81+G82","v":40500},67190,79671]
[null,null,"EBIT Pct","[%]",null,{"$f":"IF(F77=0,0,F83/F77)","v":0.68},{"$f":"IF(G77=0,0,G83/G77)","v":0.67500000000000004},0.67190000000000005,0.66392499999999999]
[null,null,"Interest","[£'000]",null,{"$f":"F57","v":-15},{"$f":"G57","v":-30},{"$f":"H57","v":-30},{"$f":"I57","v":-15}]
[null,null,"PBT","[£'000]",null,{"$f":"SUM(F83,F85)","v":33985},{"$f":"SUM(G83,G85)","v":40470},67160,79656]
[null,null,"Tax","[£'000]",null,{"$f":"-F86*F14","v":-6457.15},{"$f":"-G86*G14","v":-7689.3},{"$f":"-H86*H14","v":-12760.4},{"$f":"-I86*I14","v":-15134.64}]
[null,null,"PAT","[£'000]",null,{"$f":"SUM(F86:F87)","v":27527.85},{"$f":"SUM(G86:G87)","v":32780.699999999997},54399.6,64521.36]
[]
[null,null,"Discount Rate","[%]",{"$f":"'5.1 Data Table'!E36","v":0.04}]
[null,null,"NPV","[£'000]",{"$f":"NPV(E90,F88:I88)","v":160290.86164262454}]
[]
[null,null,"Balance Sheet"]
[]
[null,null,"Fixed Assets","[£'000]",10000,{"$f":"F36","v":9000},{"$f":"G36","v":8100},{"$f":"H36","v":7290},{"$f":"I36","v":6561}]
[]
[null,null,"Debtors","[£'000]",900,{"$f":"F43","v":4109.58904109589},{"$f":"G43","v":4931.5068493150684},{"$f":"H43","v":8219.17808219178},{"$f":"I43","v":9863.0136986301368}]
[null,null,"Cash","[£'000]",6000,{"$f":"F122","v":36496.151027397267},{"$f":"G122","v":70414.843835616455},126524.37739726028,191255.00808219178]
[null,null,"Current Assets","[£'000]",{"$f":"SUM(E97:E98)","v":6900},{"$f":"SUM(F97:F98)","v":40605.740068493156},75346.350684931531,134743.55547945207,201118.0217808219]
[]
[null,null,"Creditors","[£'000]",-400,{"$f":"F50","v":-1849.3150684931506},{"$f":"G50","v":-2293.1506849315069},{"$f":"H50","v":-3945.205479452055},{"$f":"I50","v":-4882.1917808219177}]
[null,null,"Tax","[£'000]",-500,{"$f":"F66","v":-3228.5749999999998},{"$f":"G66","v":-3844.6499999999996},{"$f":"H66","v":-6380.1999999999989},{"$f":"I66","v":-7567.3199999999961}]
[null,null,"Loans","[£'000]",0,{"$f":"F59","v":-1000},{"$f":"G59","v":-1000},{"$f":"H59","v":-1000},{"$f":"I59","v":0}]
[null,null,"Current Liabilities","[£'000]",{"$f":"SUM(E101:E103)","v":-900},{"$f":"SUM(F101:F103)","v":-6077.8900684931505},-7137.8006849315061,-11325.405479452054,-12449.511780821915]
[]
[null,null,"Net Current Assets","[£'000]",{"$f":"E99+E104","v":6000},{"$f":"F99+F104","v":34527.850000000006},68208.550000000017,123418.15000000002,188668.50999999998]
[]
[null,null,"Net Assets","[£'000]",{"$f":"E106+E95","v":16000},{"$f":"F106+F95","v":43527.850000000006},76308.550000000017,130708.15000000002,195229.50999999998]
[]
[null,null,"Retained Earnings","[£'000]",{"$f":"E108","v":16000},{"$f":"F72","v":43527.85},{"$f":"G72","v":76308.549999999988},{"$f":"H72","v":130708.15},{"$f":"I72","v":195229.51}]
[null,null,"Shareholders Funds","[£'000]",{"$f":"E110","v":16000},{"$f":"F110","v":43527.85},76308.549999999988,130708.15,195229.51]
[]
[null,null,"Cashflow"]
[]
[null,null,"Receipts from Debtors","[£'000]",null,{"$f":"-F42","v":46790.410958904111},{"$f":"-G42","v":59178.082191780821},{"$f":"-H42","v":96712.328767123283},{"$f":"-I42","v":118356.16438356164}]
[null,null,"Payment to Creditors","[£'000]",null,{"$f":"-F49","v":-13550.68493150685},{"$f":"-G49","v":-18156.164383561645},{"$f":"-H49","v":-30347.945205479453},{"$f":"-I49","v":-38663.013698630137}]
[null,null,"Payment to Loans","[£'000]",null,{"$f":"-SUM(F55:F56,F58)","v":985},{"$f":"-SUM(G55:G56,G58)","v":-30},{"$f":"-SUM(H55:H56,H58)","v":-30},{"$f":"-SUM(I55:I56,I58)","v":-1015}]
[null,null,"Payment to Tax","[£'000]",null,{"$f":"-F65","v":-3728.5749999999998},{"$f":"-G65","v":-7073.2250000000004},{"$f":"-H65","v":-10224.85},{"$f":"-I65","v":-13947.52}]
[null,null,"Net Cashflow","[£'000]",null,{"$f":"SUM(F115:F118)","v":30496.151027397264},{"$f":"SUM(G115:G118)","v":33918.692808219181},56109.533561643831,64730.630684931501]
[]
[null,null,"Cash b/f","[£'000]",null,{"$f":"E122","v":6000},{"$f":"F122","v":36496.151027397267},70414.843835616455,126524.37739726028]
[null,null,"Cash c/f","[£'000]",{"$f":"E98","v":6000},{"$f":"F119+F121","v":36496.151027397267},{"$f":"G119+G121","v":70414.843835616455},126524.37739726028,191255.00808219178]
[]
[null,null,"Checks"]
[]
[null,null,"Balance Sheet Balances",null,null,{"$f":"F111-F108","v":0},{"$f":"G111-G108","v":0},0,0]
[null,null,"Reserves matches P&L",null,null,{"$f":"F110-E110-F88","v":0},{"$f":"G110-F110-G88","v":0},0,0]
[null,null,"Cashflow matches balance Sheet",null,null,{"$f":"F122-F98","v":0},{"$f":"G122-G98","v":0},0,0]
[]
[{"$f":"REPT(\"End of Sheet                                                                                                                             \",10)","v":"End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             "}]

{"sheet":"5.2 Data Table (Ex)","index":31,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
["5.2 Data Table (Example)"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"TRANSPOSE(G17:K17)","v":"Traditional Build"}]
[null,null,null,null,"Modular Build"]
[null,null,null,null,"Modular + Int"]
[null,null,null,null,"Extra Revenue"]
[null,null,null,null,0]
[]
[null,null,"Selected Scenario",null,4]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G17:K17,$E$13)","v":"Extra Revenue"},null,"Traditional Build","Modular Build","Modular + Int","Extra Revenue"]
[]
[null,null,"Build Profile","[Text]",{"$f":"IF(INDEX(G19:K19,$E$13)=\"\",G19,INDEX(G19:K19,$E$13))","v":"Traditional"},null,"Traditional","Modular","Modular"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G21:K21,$E$13)=\"\",G21,INDEX(G21:K21,$E$13))","v":50000},null,10000,null,null,50000]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G22:K22,$E$13)=\"\",G22,INDEX(G22:K22,$E$13))","v":60000},null,12000,null,null,60000]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G23:K23,$E$13)=\"\",G23,INDEX(G23:K23,$E$13))","v":100000},null,15000,null,null,100000]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G24:K24,$E$13)=\"\",G24,INDEX(G24:K24,$E$13))","v":120000},null,18000,null,null,120000]
[]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G26:K26,$E$13)=\"\",G26,INDEX(G26:K26,$E$13))","v":0.2},null,0.2]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G27:K27,$E$13)=\"\",G27,INDEX(G27:K27,$E$13))","v":0.21},null,0.21]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G28:K28,$E$13)=\"\",G28,INDEX(G28:K28,$E$13))","v":0.22},null,0.22]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G29:K29,$E$13)=\"\",G29,INDEX(G29:K29,$E$13))","v":0.23},null,0.23]
[null,null,null,null,null,null,null,""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G31:K31,$E$13)=\"\",G31,INDEX(G31:K31,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G32:K32,$E$13)=\"\",G32,INDEX(G32:K32,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G33:K33,$E$13)=\"\",G33,INDEX(G33:K33,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G34:K34,$E$13)=\"\",G34,INDEX(G34:K34,$E$13))","v":0.03},null,0.03,"",0.04]
[]
[null,null,"Discount Rate","[%]",{"$f":"IF(INDEX(G36:K36,$E$13)=\"\",G36,INDEX(G36:K36,$E$13))","v":0.04},null,0.04,""]
[]
[]
[null,null,"NPV","[£'000]",{"$f":"'5.2.1 Model (Ex)'!E91","v":160290.86164262454}]

{"sheet":"5.2.1 Model (Ex)","index":32,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
[]
["5.2.1 Basic Model (linked to scenario manager)"]
[]
[null,null,"Timeline"]
[]
[null,null,"Year",null,"Year 0","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"Input Assumptions"]
[null,null,"P&L Assumptions"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"TRANSPOSE('5.2 Data Table (Ex)'!E21:E24)","v":50000},60000,100000,120000]
[null,null,"CoS %","[%]",null,{"$f":"TRANSPOSE('5.2 Data Table (Ex)'!E26:E29)","v":0.2},0.21,0.22,0.23]
[null,null,"Overheads Pct of Revenue","[%]",null,0.1,0.1,0.1,0.1]
[null,null,"Tax Rate","[%]",null,0.19,0.19,0.19,0.19]
[]
[null,null,"Fixed Assets"]
[]
[null,null,"Depreciation Rate",null,null,0.1,0.1,0.1,0.1]
[]
[null,null,"Working Capital"]
[]
[null,null,"Debtors Days",null,null,30,30,30,30]
[null,null,"Creditors Days",null,null,45,45,45,45]
[]
[null,null,"Loan"]
[]
[null,null,"Capital Drawdown","[£'000]",null,1000]
[null,null,"Capital Repayment","[£'000]",null,null,null,null,-1000]
[null,null,"Interest Rate","[%]",null,{"$f":"TRANSPOSE('5.2 Data Table (Ex)'!E31:E34)","v":0.03},0.03,0.03,0.03]
[]
[null,null,"Workings"]
[null,null,"Fixed Assets"]
[]
[null,null,{"$f":"C32&\" b/f\"","v":"Fixed Assets b/f"},null,null,{"$f":"E36","v":10000},{"$f":"F36","v":9000},8100,7290]
[null,null,"Depreciation",null,null,{"$f":"-F34*F18","v":-1000},{"$f":"-G34*G18","v":-900},-810,-729]
[null,null,{"$f":"C32&\" c/f\"","v":"Fixed Assets c/f"},null,{"$f":"E$95","v":10000},{"$f":"SUM(F34:F35)","v":9000},{"$f":"SUM(G34:G35)","v":8100},7290,6561]
[]
[null,null,"Debtors"]
[]
[null,null,{"$f":"C38&\" b/f\"","v":"Debtors b/f"},null,null,{"$f":"E43","v":900},{"$f":"F43","v":4109.58904109589},4931.5068493150684,8219.17808219178]
[null,null,"Sales",null,null,{"$f":"F77","v":50000},{"$f":"G77","v":60000},{"$f":"H77","v":100000},{"$f":"I77","v":120000}]
[null,null,"Cash",null,null,{"$f":"F43-F40-F41","v":-46790.410958904111},{"$f":"G43-G40-G41","v":-59178.082191780821},-96712.328767123283,-118356.16438356164]
[null,null,{"$f":"C38&\" c/f\"","v":"Debtors c/f"},null,{"$f":"E$97","v":900},{"$f":"F41*F22/365","v":4109.58904109589},{"$f":"G41*G22/365","v":4931.5068493150684},8219.17808219178,9863.0136986301368]
[]
[null,null,"Creditors"]
[]
[null,null,{"$f":"C45&\" b/f\"","v":"Creditors b/f"},null,null,{"$f":"E50","v":-400},{"$f":"F50","v":-1849.3150684931506},-2293.1506849315069,-3945.205479452055]
[null,null,"Costs",null,null,{"$f":"F78+F81","v":-15000},{"$f":"G78+G81","v":-18600},{"$f":"H78+H81","v":-32000},{"$f":"I78+I81","v":-39600}]
[null,null,"Cash",null,null,{"$f":"F50-F47-F48","v":13550.68493150685},{"$f":"G50-G47-G48","v":18156.164383561645},30347.945205479453,38663.013698630137]
[null,null,{"$f":"C45&\" c/f\"","v":"Creditors c/f"},null,{"$f":"E101","v":-400},{"$f":"F48*F23/365","v":-1849.3150684931506},{"$f":"G48*G23/365","v":-2293.1506849315069},-3945.205479452055,-4882.1917808219177]
[]
[null,null,"Loan"]
[]
[null,null,{"$f":"C52&\" b/f\"","v":"Loan b/f"},null,null,{"$f":"E59","v":0},{"$f":"F59","v":-1000},-1000,-1000]
[null,null,"Capital Drawn",null,null,{"$f":"-F27","v":-1000},{"$f":"-G27","v":0},0,0]
[null,null,"Capital Repaid",null,null,{"$f":"-F28","v":0},0,0,1000]
[null,null,"Interest Charged",null,null,{"$f":"(F54+SUM(F55:F56)/2)*F29","v":-15},{"$f":"(G54+SUM(G55:G56)/2)*G29","v":-30},-30,-15]
[null,null,"Interest Paid",null,null,{"$f":"-F57","v":15},{"$f":"-G57","v":30},30,15]
[null,null,{"$f":"C52&\" c/f\"","v":"Loan c/f"},null,{"$f":"E103","v":0},{"$f":"SUM(F54:F58)","v":-1000},{"$f":"SUM(G54:G58)","v":-1000},-1000,0]
[]
[null,null,"Tax"]
[]
[null,null,{"$f":"C61&\" b/f\"","v":"Tax b/f"},null,null,{"$f":"E66","v":-500},{"$f":"F66","v":-3228.5749999999998},-3844.6499999999996,-6380.1999999999989]
[null,null,"Charge",null,null,{"$f":"F87","v":-6457.15},{"$f":"G87","v":-7689.3},{"$f":"H87","v":-12760.4},{"$f":"I87","v":-15134.64}]
[null,null,"Cash",null,null,{"$f":"-F64/2-E66","v":3728.5749999999998},{"$f":"-F64/2-G64/2","v":7073.2250000000004},{"$f":"-G64/2-H64/2","v":10224.85},13947.52]
[null,null,{"$f":"C61&\" c/f\"","v":"Tax c/f"},null,{"$f":"E102","v":-500},{"$f":"SUM(F63:F65)","v":-3228.5749999999998},{"$f":"SUM(G63:G65)","v":-3844.6499999999996},-6380.1999999999989,-7567.3199999999961]
[]
[null,null,"Reserves"]
[]
[null,null,{"$f":"C68&\" b/f\"","v":"Reserves b/f"},null,null,{"$f":"E72","v":16000},{"$f":"F72","v":43527.85},76308.549999999988,130708.15]
[null,null,"Profit in period",null,null,{"$f":"F88","v":27527.85},{"$f":"G88","v":32780.699999999997},{"$f":"H88","v":54399.6},{"$f":"I88","v":64521.36}]
[null,null,{"$f":"C68&\" c/f\"","v":"Reserves c/f"},null,{"$f":"E110","v":16000},{"$f":"SUM(F70:F71)","v":43527.85},{"$f":"SUM(G70:G71)","v":76308.549999999988},130708.15,195229.51]
[]
[null,null,"Financial Statements"]
[null,null,"P&L"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"F11","v":50000},{"$f":"G11","v":60000},{"$f":"H11","v":100000},{"$f":"I11","v":120000}]
[null,null,"Cost of Sales","[£'000]",null,{"$f":"-F77*F12","v":-10000},{"$f":"-G77*G12","v":-12600},{"$f":"-H77*H12","v":-22000},{"$f":"-I77*I12","v":-27600}]
[null,null,"Gross Margin","[£'000]",null,{"$f":"SUM(F77:F78)","v":40000},{"$f":"SUM(G77:G78)","v":47400},78000,92400]
[null,null,"Gross Margin Pct","[%]",null,{"$f":"IF(F77=0,0,F79/F77)","v":0.8},{"$f":"IF(G77=0,0,G79/G77)","v":0.79},0.78,0.77]
[null,null,"Overheads","[£'000]",null,{"$f":"-F77*F13","v":-5000},{"$f":"-G77*G13","v":-6000},{"$f":"-H77*H13","v":-10000},{"$f":"-I77*I13","v":-12000}]
[null,null,"Depreciation","[£'000]",null,{"$f":"F35","v":-1000},{"$f":"G35","v":-900},{"$f":"H35","v":-810},{"$f":"I35","v":-729}]
[null,null,"EBIT","[£'000]",null,{"$f":"F79+F81+F82","v":34000},{"$f":"G79+G81+G82","v":40500},67190,79671]
[null,null,"EBIT Pct","[%]",null,{"$f":"IF(F77=0,0,F83/F77)","v":0.68},{"$f":"IF(G77=0,0,G83/G77)","v":0.67500000000000004},0.67190000000000005,0.66392499999999999]
[null,null,"Interest","[£'000]",null,{"$f":"F57","v":-15},{"$f":"G57","v":-30},{"$f":"H57","v":-30},{"$f":"I57","v":-15}]
[null,null,"PBT","[£'000]",null,{"$f":"SUM(F83,F85)","v":33985},{"$f":"SUM(G83,G85)","v":40470},67160,79656]
[null,null,"Tax","[£'000]",null,{"$f":"-F86*F14","v":-6457.15},{"$f":"-G86*G14","v":-7689.3},{"$f":"-H86*H14","v":-12760.4},{"$f":"-I86*I14","v":-15134.64}]
[null,null,"PAT","[£'000]",null,{"$f":"SUM(F86:F87)","v":27527.85},{"$f":"SUM(G86:G87)","v":32780.699999999997},54399.6,64521.36]
[]
[null,null,"Discount Rate","[%]",{"$f":"'5.2 Data Table (Ex)'!E36","v":0.04}]
[null,null,"NPV","[£'000]",{"$f":"NPV(E90,F88:I88)","v":160290.86164262454}]
[]
[null,null,"Balance Sheet"]
[]
[null,null,"Fixed Assets","[£'000]",10000,{"$f":"F36","v":9000},{"$f":"G36","v":8100},{"$f":"H36","v":7290},{"$f":"I36","v":6561}]
[]
[null,null,"Debtors","[£'000]",900,{"$f":"F43","v":4109.58904109589},{"$f":"G43","v":4931.5068493150684},{"$f":"H43","v":8219.17808219178},{"$f":"I43","v":9863.0136986301368}]
[null,null,"Cash","[£'000]",6000,{"$f":"F122","v":36496.151027397267},{"$f":"G122","v":70414.843835616455},126524.37739726028,191255.00808219178]
[null,null,"Current Assets","[£'000]",{"$f":"SUM(E97:E98)","v":6900},{"$f":"SUM(F97:F98)","v":40605.740068493156},75346.350684931531,134743.55547945207,201118.0217808219]
[]
[null,null,"Creditors","[£'000]",-400,{"$f":"F50","v":-1849.3150684931506},{"$f":"G50","v":-2293.1506849315069},{"$f":"H50","v":-3945.205479452055},{"$f":"I50","v":-4882.1917808219177}]
[null,null,"Tax","[£'000]",-500,{"$f":"F66","v":-3228.5749999999998},{"$f":"G66","v":-3844.6499999999996},{"$f":"H66","v":-6380.1999999999989},{"$f":"I66","v":-7567.3199999999961}]
[null,null,"Loans","[£'000]",0,{"$f":"F59","v":-1000},{"$f":"G59","v":-1000},{"$f":"H59","v":-1000},{"$f":"I59","v":0}]
[null,null,"Current Liabilities","[£'000]",{"$f":"SUM(E101:E103)","v":-900},{"$f":"SUM(F101:F103)","v":-6077.8900684931505},-7137.8006849315061,-11325.405479452054,-12449.511780821915]
[]
[null,null,"Net Current Assets","[£'000]",{"$f":"E99+E104","v":6000},{"$f":"F99+F104","v":34527.850000000006},68208.550000000017,123418.15000000002,188668.50999999998]
[]
[null,null,"Net Assets","[£'000]",{"$f":"E106+E95","v":16000},{"$f":"F106+F95","v":43527.850000000006},76308.550000000017,130708.15000000002,195229.50999999998]
[]
[null,null,"Retained Earnings","[£'000]",{"$f":"E108","v":16000},{"$f":"F72","v":43527.85},{"$f":"G72","v":76308.549999999988},{"$f":"H72","v":130708.15},{"$f":"I72","v":195229.51}]
[null,null,"Shareholders Funds","[£'000]",{"$f":"E110","v":16000},{"$f":"F110","v":43527.85},76308.549999999988,130708.15,195229.51]
[]
[null,null,"Cashflow"]
[]
[null,null,"Receipts from Debtors","[£'000]",null,{"$f":"-F42","v":46790.410958904111},{"$f":"-G42","v":59178.082191780821},{"$f":"-H42","v":96712.328767123283},{"$f":"-I42","v":118356.16438356164}]
[null,null,"Payment to Creditors","[£'000]",null,{"$f":"-F49","v":-13550.68493150685},{"$f":"-G49","v":-18156.164383561645},{"$f":"-H49","v":-30347.945205479453},{"$f":"-I49","v":-38663.013698630137}]
[null,null,"Payment to Loans","[£'000]",null,{"$f":"-SUM(F55:F56,F58)","v":985},{"$f":"-SUM(G55:G56,G58)","v":-30},{"$f":"-SUM(H55:H56,H58)","v":-30},{"$f":"-SUM(I55:I56,I58)","v":-1015}]
[null,null,"Payment to Tax","[£'000]",null,{"$f":"-F65","v":-3728.5749999999998},{"$f":"-G65","v":-7073.2250000000004},{"$f":"-H65","v":-10224.85},{"$f":"-I65","v":-13947.52}]
[null,null,"Net Cashflow","[£'000]",null,{"$f":"SUM(F115:F118)","v":30496.151027397264},{"$f":"SUM(G115:G118)","v":33918.692808219181},56109.533561643831,64730.630684931501]
[]
[null,null,"Cash b/f","[£'000]",null,{"$f":"E122","v":6000},{"$f":"F122","v":36496.151027397267},70414.843835616455,126524.37739726028]
[null,null,"Cash c/f","[£'000]",{"$f":"E98","v":6000},{"$f":"F119+F121","v":36496.151027397267},{"$f":"G119+G121","v":70414.843835616455},126524.37739726028,191255.00808219178]
[]
[null,null,"Checks"]
[]
[null,null,"Balance Sheet Balances",null,null,{"$f":"F111-F108","v":0},{"$f":"G111-G108","v":0},0,0]
[null,null,"Reserves matches P&L",null,null,{"$f":"F110-E110-F88","v":0},{"$f":"G110-F110-G88","v":0},0,0]
[null,null,"Cashflow matches balance Sheet",null,null,{"$f":"F122-F98","v":0},{"$f":"G122-G98","v":0},0,0]
[]
[{"$f":"REPT(\"End of Sheet                                                                                                                             \",10)","v":"End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             "}]

{"sheet":"Part 6","index":33,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"6.1 Pitfalls","index":34,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["6.1 Pitfalls"]
[]
[null,null,"Too much nesting"]
[]
[]
[]
[null,null,"Data tables can be slow"]
[]
[]
[]
[null,null,"Too many variables"]
[]
[]
[]
[null,null,"Excels built in Scenario Manager"]

{"sheet":"Part 7","index":35,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"7.1 Conclusion","index":36,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["7.0 Conclusion"]
[]
[null,null,"1.0 Introduction to Scenarios"]
[]
[null,null,"2.0 Basic Implementations"]
[]
[null,null,"3.0 Advanced Implementations"]
[]
[null,null,"4.0 Macros"]
[]
[null,null,"5.0 Data Tables"]
[]
[null,null,"6.0 Pitfalls"]
[]
[null,null,"7.0 Conclusion"]
[]
[null,null,"8.0 Q+A"]

{"sheet":"7.2 Data Table (Ex Spare)","index":37,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
["7.2 Data Table (Example Spare)"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"TRANSPOSE(G17:K17)","v":"Traditional Build"}]
[null,null,null,null,"Modular Build"]
[null,null,null,null,"Modular + Int"]
[null,null,null,null,"Extra Revenue"]
[null,null,null,null,0]
[]
[null,null,"Selected Scenario",null,4]
[]
[null,null,"Variable","Units","Live",null,1,2,3,4,5]
[]
[null,null,"Scenario Name","[text]",{"$f":"INDEX(G17:K17,$E$13)","v":"Extra Revenue"},null,"Traditional Build","Modular Build","Modular + Int","Extra Revenue"]
[]
[null,null,"Build Profile","[Text]",{"$f":"IF(INDEX(G19:K19,$E$13)=\"\",G19,INDEX(G19:K19,$E$13))","v":"Traditional"},null,"Traditional","Modular","Modular"]
[]
[null,null,"Revenue Y1","[£'000]",{"$f":"IF(INDEX(G21:K21,$E$13)=\"\",G21,INDEX(G21:K21,$E$13))","v":5000},null,1000,null,null,5000]
[null,null,"Revenue Y2","[£'000]",{"$f":"IF(INDEX(G22:K22,$E$13)=\"\",G22,INDEX(G22:K22,$E$13))","v":6000},null,1200,null,null,6000]
[null,null,"Revenue Y3","[£'000]",{"$f":"IF(INDEX(G23:K23,$E$13)=\"\",G23,INDEX(G23:K23,$E$13))","v":10000},null,1500,null,null,10000]
[null,null,"Revenue Y4","[£'000]",{"$f":"IF(INDEX(G24:K24,$E$13)=\"\",G24,INDEX(G24:K24,$E$13))","v":12000},null,1800,null,null,12000]
[]
[null,null,"CoS% Y1","[%]",{"$f":"IF(INDEX(G26:K26,$E$13)=\"\",G26,INDEX(G26:K26,$E$13))","v":0.7},null,0.7]
[null,null,"CoS% Y2","[%]",{"$f":"IF(INDEX(G27:K27,$E$13)=\"\",G27,INDEX(G27:K27,$E$13))","v":0.69},null,0.69]
[null,null,"CoS% Y3","[%]",{"$f":"IF(INDEX(G28:K28,$E$13)=\"\",G28,INDEX(G28:K28,$E$13))","v":0.68},null,0.68]
[null,null,"CoS% Y4","[%]",{"$f":"IF(INDEX(G29:K29,$E$13)=\"\",G29,INDEX(G29:K29,$E$13))","v":0.67},null,0.67]
[null,null,null,null,null,null,null,""]
[null,null,"Interest Rate Y1","[%]",{"$f":"IF(INDEX(G31:K31,$E$13)=\"\",G31,INDEX(G31:K31,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y2","[%]",{"$f":"IF(INDEX(G32:K32,$E$13)=\"\",G32,INDEX(G32:K32,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y3","[%]",{"$f":"IF(INDEX(G33:K33,$E$13)=\"\",G33,INDEX(G33:K33,$E$13))","v":0.03},null,0.03,"",0.04]
[null,null,"Interest Rate Y4","[%]",{"$f":"IF(INDEX(G34:K34,$E$13)=\"\",G34,INDEX(G34:K34,$E$13))","v":0.03},null,0.03,"",0.04]
[]
[null,null,"Discount Rate","[%]",{"$f":"IF(INDEX(G36:K36,$E$13)=\"\",G36,INDEX(G36:K36,$E$13))","v":0.04},null,0.04,""]
[]
[]
[null,null,"NPV","[£'000]",{"$f":"'7.2.1 Model (Ex Spare)'!E91","v":2610.6306239277314}]

{"sheet":"7.2.1 Model (Ex Spare)","index":38,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
[]
["7.2.1 Basic Model (linked to scenario manager Spare)"]
[]
[null,null,"Timeline"]
[]
[null,null,"Year",null,"Year 0","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"Input Assumptions"]
[null,null,"P&L Assumptions"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"TRANSPOSE('7.2 Data Table (Ex Spare)'!E21:E24)","v":5000},6000,10000,12000]
[null,null,"CoS %","[%]",null,{"$f":"TRANSPOSE('7.2 Data Table (Ex Spare)'!E26:E29)","v":0.7},0.69,0.68,0.67]
[null,null,"Overheads Pct of Revenue","[%]",null,0.1,0.1,0.1,0.1]
[null,null,"Tax Rate","[%]",null,0.19,0.19,0.19,0.19]
[]
[null,null,"Fixed Assets"]
[]
[null,null,"Depreciation Rate",null,null,0.1,0.1,0.1,0.1]
[]
[null,null,"Working Capital"]
[]
[null,null,"Debtors Days",null,null,30,30,30,30]
[null,null,"Creditors Days",null,null,45,45,45,45]
[]
[null,null,"Loan"]
[]
[null,null,"Capital Drawdown","[£'000]",null,1000]
[null,null,"Capital Repayment","[£'000]",null,null,null,null,-1000]
[null,null,"Interest Rate","[%]",null,{"$f":"TRANSPOSE('7.2 Data Table (Ex Spare)'!E31:E34)","v":0.03},0.03,0.03,0.03]
[]
[null,null,"Workings"]
[null,null,"Fixed Assets"]
[]
[null,null,{"$f":"C32&\" b/f\"","v":"Fixed Assets b/f"},null,null,{"$f":"E36","v":10000},{"$f":"F36","v":9000},8100,7290]
[null,null,"Depreciation",null,null,{"$f":"-F34*F18","v":-1000},{"$f":"-G34*G18","v":-900},-810,-729]
[null,null,{"$f":"C32&\" c/f\"","v":"Fixed Assets c/f"},null,{"$f":"E$95","v":10000},{"$f":"SUM(F34:F35)","v":9000},{"$f":"SUM(G34:G35)","v":8100},7290,6561]
[]
[null,null,"Debtors"]
[]
[null,null,{"$f":"C38&\" b/f\"","v":"Debtors b/f"},null,null,{"$f":"E43","v":900},{"$f":"F43","v":410.95890410958901},493.15068493150687,821.91780821917803]
[null,null,"Sales",null,null,{"$f":"F77","v":5000},{"$f":"G77","v":6000},{"$f":"H77","v":10000},{"$f":"I77","v":12000}]
[null,null,"Cash",null,null,{"$f":"F43-F40-F41","v":-5489.0410958904113},{"$f":"G43-G40-G41","v":-5917.8082191780823},-9671.232876712329,-11835.616438356165]
[null,null,{"$f":"C38&\" c/f\"","v":"Debtors c/f"},null,{"$f":"E$97","v":900},{"$f":"F41*F22/365","v":410.95890410958901},{"$f":"G41*G22/365","v":493.15068493150687},821.91780821917803,986.30136986301375]
[]
[null,null,"Creditors"]
[]
[null,null,{"$f":"C45&\" b/f\"","v":"Creditors b/f"},null,null,{"$f":"E50","v":-400},{"$f":"F50","v":-493.15068493150687},-584.38356164383561,-961.64383561643854]
[null,null,"Costs",null,null,{"$f":"F78+F81","v":-4000},{"$f":"G78+G81","v":-4740},{"$f":"H78+H81","v":-7800.0000000000009},{"$f":"I78+I81","v":-9240}]
[null,null,"Cash",null,null,{"$f":"F50-F47-F48","v":3906.8493150684931},{"$f":"G50-G47-G48","v":4648.767123287671},7422.7397260273983,9062.465753424658]
[null,null,{"$f":"C45&\" c/f\"","v":"Creditors c/f"},null,{"$f":"E101","v":-400},{"$f":"F48*F23/365","v":-493.15068493150687},{"$f":"G48*G23/365","v":-584.38356164383561},-961.64383561643854,-1139.1780821917807]
[]
[null,null,"Loan"]
[]
[null,null,{"$f":"C52&\" b/f\"","v":"Loan b/f"},null,null,{"$f":"E59","v":0},{"$f":"F59","v":-1000},-1000,-1000]
[null,null,"Capital Drawn",null,null,{"$f":"-F27","v":-1000},{"$f":"-G27","v":0},0,0]
[null,null,"Capital Repaid",null,null,{"$f":"-F28","v":0},0,0,1000]
[null,null,"Interest Charged",null,null,{"$f":"(F54+SUM(F55:F56)/2)*F29","v":-15},{"$f":"(G54+SUM(G55:G56)/2)*G29","v":-30},-30,-15]
[null,null,"Interest Paid",null,null,{"$f":"-F57","v":15},{"$f":"-G57","v":30},30,15]
[null,null,{"$f":"C52&\" c/f\"","v":"Loan c/f"},null,{"$f":"E103","v":0},{"$f":"SUM(F54:F58)","v":-1000},{"$f":"SUM(G54:G58)","v":-1000},-1000,0]
[]
[null,null,"Tax"]
[]
[null,null,{"$f":"C61&\" b/f\"","v":"Tax b/f"},null,null,{"$f":"E66","v":-500},{"$f":"F66","v":1.4250000000000114},-31.349999999999991,-129.19999999999987]
[null,null,"Charge",null,null,{"$f":"F87","v":2.85},{"$f":"G87","v":-62.7},{"$f":"H87","v":-258.39999999999981},{"$f":"I87","v":-383.03999999999985}]
[null,null,"Cash",null,null,{"$f":"-F64/2-E66","v":498.57499999999999},{"$f":"-F64/2-G64/2","v":29.925000000000001},{"$f":"-G64/2-H64/2","v":160.5499999999999},320.7199999999998]
[null,null,{"$f":"C61&\" c/f\"","v":"Tax c/f"},null,{"$f":"E102","v":-500},{"$f":"SUM(F63:F65)","v":1.4250000000000114},{"$f":"SUM(G63:G65)","v":-31.349999999999991},-129.19999999999987,-191.51999999999998]
[]
[null,null,"Reserves"]
[]
[null,null,{"$f":"C68&\" b/f\"","v":"Reserves b/f"},null,null,{"$f":"E72","v":16000},{"$f":"F72","v":15987.85},16255.15,17356.75]
[null,null,"Profit in period",null,null,{"$f":"F88","v":-12.15},{"$f":"G88","v":267.3},{"$f":"H88","v":1101.5999999999992},{"$f":"I88","v":1632.9599999999991}]
[null,null,{"$f":"C68&\" c/f\"","v":"Reserves c/f"},null,{"$f":"E110","v":16000},{"$f":"SUM(F70:F71)","v":15987.85},{"$f":"SUM(G70:G71)","v":16255.15},17356.75,18989.71]
[]
[null,null,"Financial Statements"]
[null,null,"P&L"]
[]
[null,null,"Revenue","[£'000]",null,{"$f":"F11","v":5000},{"$f":"G11","v":6000},{"$f":"H11","v":10000},{"$f":"I11","v":12000}]
[null,null,"Cost of Sales","[£'000]",null,{"$f":"-F77*F12","v":-3500},{"$f":"-G77*G12","v":-4140},{"$f":"-H77*H12","v":-6800.0000000000009},{"$f":"-I77*I12","v":-8040.0000000000009}]
[null,null,"Gross Margin","[£'000]",null,{"$f":"SUM(F77:F78)","v":1500},{"$f":"SUM(G77:G78)","v":1860},3199.9999999999991,3959.9999999999991]
[null,null,"Gross Margin Pct","[%]",null,{"$f":"IF(F77=0,0,F79/F77)","v":0.3},{"$f":"IF(G77=0,0,G79/G77)","v":0.31},0.3199999999999999,0.3299999999999999]
[null,null,"Overheads","[£'000]",null,{"$f":"-F77*F13","v":-500},{"$f":"-G77*G13","v":-600},{"$f":"-H77*H13","v":-1000},{"$f":"-I77*I13","v":-1200}]
[null,null,"Depreciation","[£'000]",null,{"$f":"F35","v":-1000},{"$f":"G35","v":-900},{"$f":"H35","v":-810},{"$f":"I35","v":-729}]
[null,null,"EBIT","[£'000]",null,{"$f":"F79+F81+F82","v":0},{"$f":"G79+G81+G82","v":360},1389.9999999999991,2030.9999999999991]
[null,null,"EBIT Pct","[%]",null,{"$f":"IF(F77=0,0,F83/F77)","v":0},{"$f":"IF(G77=0,0,G83/G77)","v":0.06},0.1389999999999999,0.16924999999999993]
[null,null,"Interest","[£'000]",null,{"$f":"F57","v":-15},{"$f":"G57","v":-30},{"$f":"H57","v":-30},{"$f":"I57","v":-15}]
[null,null,"PBT","[£'000]",null,{"$f":"SUM(F83,F85)","v":-15},{"$f":"SUM(G83,G85)","v":330},1359.9999999999991,2015.9999999999991]
[null,null,"Tax","[£'000]",null,{"$f":"-F86*F14","v":2.85},{"$f":"-G86*G14","v":-62.7},{"$f":"-H86*H14","v":-258.39999999999981},{"$f":"-I86*I14","v":-383.03999999999985}]
[null,null,"PAT","[£'000]",null,{"$f":"SUM(F86:F87)","v":-12.15},{"$f":"SUM(G86:G87)","v":267.3},1101.5999999999992,1632.9599999999991]
[]
[null,null,"Discount Rate","[%]",{"$f":"'7.2 Data Table (Ex Spare)'!E36","v":0.04}]
[null,null,"NPV","[£'000]",{"$f":"NPV(E90,F88:I88)","v":2610.6306239277314}]
[]
[null,null,"Balance Sheet"]
[]
[null,null,"Fixed Assets","[£'000]",10000,{"$f":"F36","v":9000},{"$f":"G36","v":8100},{"$f":"H36","v":7290},{"$f":"I36","v":6561}]
[]
[null,null,"Debtors","[£'000]",900,{"$f":"F43","v":410.95890410958901},{"$f":"G43","v":493.15068493150687},{"$f":"H43","v":821.91780821917803},{"$f":"I43","v":986.30136986301375}]
[null,null,"Cash","[£'000]",6000,{"$f":"F122","v":8068.6167808219179},{"$f":"G122","v":9277.732876712329},11335.67602739726,12773.106712328767]
[null,null,"Current Assets","[£'000]",{"$f":"SUM(E97:E98)","v":6900},{"$f":"SUM(F97:F98)","v":8479.5756849315076},9770.8835616438355,12157.593835616437,13759.40808219178]
[]
[null,null,"Creditors","[£'000]",-400,{"$f":"F50","v":-493.15068493150687},{"$f":"G50","v":-584.38356164383561},{"$f":"H50","v":-961.64383561643854},{"$f":"I50","v":-1139.1780821917807}]
[null,null,"Tax","[£'000]",-500,{"$f":"F66","v":1.4250000000000114},{"$f":"G66","v":-31.349999999999991},{"$f":"H66","v":-129.19999999999987},{"$f":"I66","v":-191.51999999999998}]
[null,null,"Loans","[£'000]",0,{"$f":"F59","v":-1000},{"$f":"G59","v":-1000},{"$f":"H59","v":-1000},{"$f":"I59","v":0}]
[null,null,"Current Liabilities","[£'000]",{"$f":"SUM(E101:E103)","v":-900},{"$f":"SUM(F101:F103)","v":-1491.7256849315067},-1615.7335616438356,-2090.8438356164384,-1330.6980821917807]
[]
[null,null,"Net Current Assets","[£'000]",{"$f":"E99+E104","v":6000},{"$f":"F99+F104","v":6987.85},8155.15,10066.749999999998,12428.71]
[]
[null,null,"Net Assets","[£'000]",{"$f":"E106+E95","v":16000},{"$f":"F106+F95","v":15987.85},16255.15,17356.75,18989.71]
[]
[null,null,"Retained Earnings","[£'000]",{"$f":"E108","v":16000},{"$f":"F72","v":15987.85},{"$f":"G72","v":16255.15},{"$f":"H72","v":17356.75},{"$f":"I72","v":18989.71}]
[null,null,"Shareholders Funds","[£'000]",{"$f":"E110","v":16000},{"$f":"F110","v":15987.85},16255.15,17356.75,18989.71]
[]
[null,null,"Cashflow"]
[]
[null,null,"Receipts from Debtors","[£'000]",null,{"$f":"-F42","v":5489.0410958904113},{"$f":"-G42","v":5917.8082191780823},{"$f":"-H42","v":9671.232876712329},{"$f":"-I42","v":11835.616438356165}]
[null,null,"Payment to Creditors","[£'000]",null,{"$f":"-F49","v":-3906.8493150684931},{"$f":"-G49","v":-4648.767123287671},{"$f":"-H49","v":-7422.7397260273983},{"$f":"-I49","v":-9062.465753424658}]
[null,null,"Payment to Loans","[£'000]",null,{"$f":"-SUM(F55:F56,F58)","v":985},{"$f":"-SUM(G55:G56,G58)","v":-30},{"$f":"-SUM(H55:H56,H58)","v":-30},{"$f":"-SUM(I55:I56,I58)","v":-1015}]
[null,null,"Payment to Tax","[£'000]",null,{"$f":"-F65","v":-498.57499999999999},{"$f":"-G65","v":-29.925000000000001},{"$f":"-H65","v":-160.5499999999999},{"$f":"-I65","v":-320.7199999999998}]
[null,null,"Net Cashflow","[£'000]",null,{"$f":"SUM(F115:F118)","v":2068.6167808219184},{"$f":"SUM(G115:G118)","v":1209.1160958904113},2057.943150684931,1437.4306849315067]
[]
[null,null,"Cash b/f","[£'000]",null,{"$f":"E122","v":6000},{"$f":"F122","v":8068.6167808219179},9277.732876712329,11335.67602739726]
[null,null,"Cash c/f","[£'000]",{"$f":"E98","v":6000},{"$f":"F119+F121","v":8068.6167808219179},{"$f":"G119+G121","v":9277.732876712329},11335.67602739726,12773.106712328767]
[]
[null,null,"Checks"]
[]
[null,null,"Balance Sheet Balances",null,null,{"$f":"F111-F108","v":0},{"$f":"G111-G108","v":0},0,0]
[null,null,"Reserves matches P&L",null,null,{"$f":"F110-E110-F88","v":3.6415315207705135E-13},{"$f":"G110-F110-G88","v":-7.3896444519050419E-13},0,0]
[null,null,"Cashflow matches balance Sheet",null,null,{"$f":"F122-F98","v":0},{"$f":"G122-G98","v":0},0,0]
[]
[{"$f":"REPT(\"End of Sheet                                                                                                                             \",10)","v":"End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             End of Sheet                                                                                                                             "}]