{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Financial Model","Chart1","Chart2","Spider"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart1","index":2,"reason":"not_a_worksheet"},{"sheet":"Chart2","index":3,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Add Sensitivities to the Financial Model -- this is already completed"]
[]
[null,null,null,"Add Sheet and Inputs for Number of Variables and for Scenario Number"]
[]
[null,null,null,"Copy and Transpose Titles of the Variables"]
[]
[null,null,null,"Create a series of percentages with a middle value of 100% -- e.g. begin with 160% and subtract 10% until you get to 40%"]
[]
[null,null,null,"Copy the Series to each column with different variables"]
[]
[null,null,null,"Use Index Key with Scenarios"]
[]
[null,null,null,"Create Counter for Variable Number"]
[]
[null,null,null,"Create TRUE/FALSE Test"]
[]
[null,null,null,"Create If test that uses scenario when true and 100% when false"]
[]
[null,null,null,"Use TRANSPOSE Command to transfer variables"]
[]
[null,null,null,"Make Two Way Data Table using the variable numbers for the row and the scenarios for the column"]
[]
[null,null,null,"Insert vertical and horizontal titles on the table"]
[]
[null,null,null,"Use SHIFT,ALT,--> to hide the vertical and horizontal numbers and Use F11 to Make Graph; Modify type to be line"]
[]
[null,null,null,"Change the inputs to reflect realistic ranges of different variables -- all variables should be centred on a value of 100%"]
[]
[null,null,null,"Change the style of the chart using the custom charts"]

{"sheet":"Financial Model","index":1,"n_rows":50,"n_cols":24,"rows_kept":50,"cut":false,"hidden":false,"merged":[[17,3,17,23]]}
[]
[null,null,null,null,null,"Base",null,null,null,"Sensitivity"]
[]
[null,null,null,"Investment",null,1000,null,{"$f":"D4&\"_\"&$J$2","v":"Investment_Sensitivity"},null,{"$f":"TRANSPOSE(Spider!D26:J26)","v":1},null,null,"Note: Colours made from the fm.xls file"]
[null,null,null,"Price",null,10,null,"Price_Sensitivity",null,1.1499999999999999]
[null,null,null,"Quantity",null,15,null,"Quantity_Sensitivity",null,1]
[null,null,null,"Cost",null,5,null,"Cost_Sensitivity",null,1]
[null,null,null,"Inflation",null,0.05,null,"Inflation_Sensitivity",null,1]
[null,null,null,"Terminal",null,3000,null,"Terminal_Sensitivity",null,1]
[null,null,null,"Life",null,10,null,"Life_Sensitivity",null,1]
[]
[]
[null,null,null,null,null,"Base Investment",null,{"$f":"Investment","v":1000}]
[null,null,null,null,null,"Investment Sensitivity",null,{"$f":"Investment_Sensitivity","v":1}]
[null,null,null,null,null,"Adjusted Investment",null,{"$f":"H13*H14","v":1000}]
[]
[]
[null,null,null,"Very Simple Financial Model"]
[]
[null,null,null,"Period","Life Switch","Inflation Rate","Inflation\nSensitivity","Adjusted Inflation Rate","Base Price","Price Sensitivity","Adjusted\nPrice","Base Quantity","Quantity\nSensitivty","Adjusted\nQuantity","Base\nCost","Cost\nSensitivity","Adjusted\nCost","Base\nLife","Life\nSensitivity","Adjusted\nLife","Base\nTerminal","Terminal\nSensitivity","Adjusted\nSensitivity","Cash\nFlow"]
[]
[null,null,null,"Period","Life",null,null,"Infalation","Investment","Price","Quantity",null,null,"Cost",null,null,"Terminal",null,null,null,null,null,"Cash Flow"]
[null,null,null,0,{"$f":"D23<=Life*Life_Sensitivity","v":true},{"$f":"Inflation","v":0.05},{"$f":"Inflation_Sensitivity","v":1},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-H15","v":-1000}]
[null,null,null,{"$f":"D23+1","v":1},true,{"$f":"F23*(1+Inflation)","v":5.2500000000000005E-2},1,{"$f":"H23*(1+F24*G24)","v":1.0525},{"$f":"Price","v":10},{"$f":"Price_Sensitivity","v":1.1499999999999999},{"$f":"I24*H24*J24","v":12.10375},{"$f":"Quantity","v":15},{"$f":"Quantity_Sensitivity","v":1},{"$f":"L24*M24","v":15},{"$f":"Cost","v":5},{"$f":"Cost_Sensitivity","v":1},{"$f":"O24*P24*H24","v":5.2625000000000002},{"$f":"Life","v":10},{"$f":"Life_Sensitivity","v":1},{"$f":"ROUND(S24*R24,0)","v":10},{"$f":"Terminal","v":3000},{"$f":"Terminal_Sensitivity","v":1},{"$f":"(T24=D24)*U24*V24","v":0},{"$f":"(K24*N24-Q24+W24)*E24","v":176.29375000000002}]
[null,null,null,2,true,5.5125000000000007E-2,1,1.1105190625000001,10,1.1499999999999999,{"$f":"I25*H25*J25","v":12.77096921875},15,1,{"$f":"L25*M25","v":15},5,1,{"$f":"O25*P25*H25","v":5.5525953125000003},10,1,{"$f":"ROUND(S25*R25,0)","v":10},3000,1,{"$f":"(T25=D25)*U25*V25","v":0},{"$f":"(K25*N25-Q25+W25)*E25","v":186.01194296875002}]
[null,null,null,3,true,5.7881250000000009E-2,1,1.1747972939863283,10,1.1499999999999999,13.510168880842775,15,1,15,5,1,5.8739864699316415,10,1,10,3000,1,0,196.77854674270998]
[null,null,null,4,true,6.0775312500000012E-2,1,1.246195966652502,10,1.1499999999999999,14.331253616503773,15,1,15,5,1,6.2309798332625101,10,1,10,3000,1,0,208.73782441429407]
[null,null,null,5,true,6.3814078125000021E-2,1,1.3257208134275247,10,1.1499999999999999,15.245789354416534,15,1,15,5,1,6.6286040671376236,10,1,10,3000,1,0,222.05823624911039]
[null,null,null,6,true,6.7004782031250029E-2,1,1.4145504475655275,10,1.1499999999999999,16.267330147003566,15,1,15,5,1,7.072752237827638,10,1,10,3000,1,0,236.93719996722584]
[null,null,null,7,true,7.0355021132812529E-2,1,1.5140711741974298,10,1.1499999999999999,17.411818503270439,15,1,15,5,1,7.5703558709871484,10,1,10,3000,1,0,253.60692167806945]
[null,null,null,8,true,7.3872772189453165E-2,1,1.6259198091275344,10,1.1499999999999999,18.698077804966644,15,1,15,5,1,8.1295990456376721,10,1,10,3000,1,0,272.34156802886196]
[null,null,null,9,true,7.7566410798925831E-2,1,1.7520365729684317,10,1.1499999999999999,20.148420589136965,15,1,15,5,1,8.7601828648421591,10,1,10,3000,1,0,293.46612597221235]
[null,null,null,10,true,8.1444731338872131E-2,1,1.8947307209497239,10,1.1499999999999999,21.789403290921825,15,1,15,5,1,9.4736536047486197,10,1,10,3000,1,3000,3317.3673957590786]
[null,null,null,11,false,8.5516967905815741E-2,1,2.0567623472033443,10,1.1499999999999999,23.652766992838458,15,1,15,5,1,10.283811736016721,10,1,10,3000,1,0,0]
[null,null,null,12,false,8.9792816301106526E-2,1,2.2414448308208068,10,1.1499999999999999,25.776615554439278,15,1,15,5,1,11.207224154104034,10,1,10,3000,1,0,0]
[null,null,null,13,false,9.4282457116161858E-2,1,2.4527737569609123,10,1.1499999999999999,28.206898205050489,15,1,15,5,1,12.263868784804561,10,1,10,3000,1,0,0]
[null,null,null,14,false,9.899657997196995E-2,1,2.6955899703450421,10,1.1499999999999999,30.99928465896798,15,1,15,5,1,13.47794985172521,10,1,10,3000,1,0,0]
[null,null,null,15,false,0.10394640897056845,1,2.9757868678194903,10,1.1499999999999999,34.221548979924137,15,1,15,5,1,14.878934339097452,10,1,10,3000,1,0,0]
[null,null,null,16,false,0.10914372941909688,1,3.3005753445296828,10,1.1499999999999999,37.956616462091347,15,1,15,5,1,16.502876722648413,10,1,10,3000,1,0,0]
[null,null,null,17,false,0.11460091589005172,1,3.6788243019769071,10,1.1499999999999999,42.306479472734424,15,1,15,5,1,18.394121509884535,10,1,10,3000,1,0,0]
[null,null,null,18,false,0.12033096168455432,1,4.1215007681022975,10,1.1499999999999999,47.397258833176416,15,1,15,5,1,20.607503840511487,10,1,10,3000,1,0,0]
[null,null,null,19,false,0.12634750976878203,1,4.6422421266621452,10,1.1499999999999999,53.385784456614672,15,1,15,5,1,23.211210633310728,10,1,10,3000,1,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRR",{"$f":"IRR(X23:X42)","v":0.26558301583179267}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate",0.1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPV",{"$f":"NPV(X48,X23:X42)","v":1396.9742662216654}]

{"sheet":"Spider","index":4,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Variable Number",null,2,null,null,null,null,null,null,null,"IRR",{"$f":"'Financial Model'!X46","v":0.26558301583179267}]
[null,null,"Scenario Number",null,1,null,null,null,null,null,null,null,"NPV",{"$f":"'Financial Model'!X50","v":1396.9742662216654}]
[]
[]
[null,null,null,1,{"$f":"D7+1","v":2},3,4,5,6,7,null,null,null,"Investment","Price","Quantity","Cost","Inflation","Terminal","Life"]
[null,null,null,"Investment","Price","Quantity","Cost","Inflation","Terminal","Life",null,null,{"$f":"N4","v":1396.9742662216654},1,{"$f":"N8+1","v":2},3,4,5,6,7]
[null,1,1.6,1.6,1.1499999999999999,1.3,1.6,1.3,1.6,1.6,null,"Very High",1,682.99358208330545,1396.9742662216654,1565.5004049054803,1205.9779757133424,1332.020072614607,1859.3371466043568,1335.4825759683572]
[null,{"$f":"B9+1","v":2},{"$f":"C9-10%","v":1.5},{"$f":"D9-10%","v":1.5},{"$f":"E9-2.5%","v":1.125},{"$f":"F9-5%","v":1.25},{"$f":"G9-10%","v":1.5},{"$f":"H9-5%","v":1.25},{"$f":"I9-10%","v":1.5},{"$f":"J9-10%","v":1.5},null,null,{"$f":"M9+1","v":2},773.90267299239645,1368.8865764410298,1509.3250253442088,1209.7230010174271,1313.9880061874944,1754.1889767599391,1300.150797386726]
[null,{"$f":"B10+1","v":3},1.4,1.4,1.1000000000000001,1.2,1.4,1.2,1.4,1.4,null,null,3,864.81176390148721,1340.7988866603941,1453.1496457829371,1213.4680263215116,1296.2714112675023,1649.0408069155214,1271.5349390945828]
[null,4,1.2999999999999998,1.2999999999999998,1.0750000000000002,1.1499999999999999,1.2999999999999998,1.1499999999999999,1.2999999999999998,1.2999999999999998,null,"High",4,955.7208548105782,1312.7111968797585,1396.9742662216654,1217.2130516255966,1278.8646356503784,1543.8926370711035,1249.7836468526516]
[null,5,1.1999999999999997,1.1999999999999997,1.0500000000000003,1.0999999999999999,1.1999999999999997,1.0999999999999999,1.1999999999999997,1.1999999999999997,null,null,5,1046.6299457196694,1284.6235070991227,1340.7988866603937,1220.9580769296813,1261.7621227090626,1438.7444672266859,1235.1286846017906]
[null,6,1.0999999999999996,1.0999999999999996,1.0250000000000004,1.0499999999999998,1.0999999999999996,1.0499999999999998,1.0999999999999996,1.0999999999999996,null,null,6,1137.5390366287602,1256.535817318487,1284.6235070991224,1224.703102233766,1244.9584099415681,1333.5962973822682,1227.8843231609085]
[null,7,0.99999999999999967,0.99999999999999967,1.0000000000000004,0.99999999999999978,0.99999999999999967,0.99999999999999978,0.99999999999999967,0.99999999999999967,null,"Base",7,1228.4481275378512,1228.4481275378516,1228.4481275378505,1228.4481275378507,1228.4481275378505,1228.4481275378505,1228.4481275378507]
[null,8,0.89999999999999969,0.89999999999999969,0.97500000000000042,0.94999999999999973,0.89999999999999969,0.94999999999999973,0.89999999999999969,0.89999999999999969,null,null,8,1319.3572184469419,1200.3604377572155,1172.272747976579,1232.1931528419354,1212.2259969654644,1123.2999576934328,1237.303021348604]
[null,9,0.79999999999999971,0.79999999999999971,0.9500000000000004,0.89999999999999969,0.79999999999999971,0.89999999999999969,0.79999999999999971,0.79999999999999971,null,null,9,1410.2663093560329,1172.2727479765797,1116.0973684153073,1235.9381781460204,1196.2868295737967,1018.1517878490152,1255.0205463637153]
[null,10,0.69999999999999973,0.69999999999999973,0.92500000000000038,0.84999999999999964,0.69999999999999973,0.84999999999999964,0.69999999999999973,0.69999999999999973,null,"Low",10,1501.1754002651237,1144.1850581959441,1059.9219888540358,1239.6832034501051,1180.6255252166882,913.00361800459746,1282.265267661694]
[null,11,0.59999999999999976,0.59999999999999976,0.90000000000000036,0.7999999999999996,0.59999999999999976,0.7999999999999996,0.59999999999999976,0.59999999999999976,null,null,11,1592.0844911742145,1116.0973684153082,1003.7466092927642,1243.4282287541901,1165.2370708932349,807.85544816018,1319.8003020703559]
[null,12,0.49999999999999978,0.49999999999999978,0.87500000000000033,0.74999999999999956,0.49999999999999978,0.74999999999999956,0.49999999999999978,0.49999999999999978,null,null,12,1682.9935820833055,1088.0096786346724,947.57122973149262,1247.1732540582748,1150.1165394065799,702.70727831576232,1368.4939708963745]
[null,13,0.3999999999999998,0.3999999999999998,0.85000000000000031,0.69999999999999951,0.3999999999999998,0.69999999999999951,0.3999999999999998,0.3999999999999998,null,"Very Low",13,1773.9026729923962,1059.9219888540367,891.39585017022114,1250.9182793623595,1135.2590880404964,597.55910847134476,1429.3275984446266]
[]
[null,null,null,{"$f":"INDEX(D9:D21,$E$4)","v":1.6},1.1499999999999999,1.3,1.6,1.3,1.6,1.6]
[null,null,"Variable",1,2,3,4,5,6,7]
[null,null,"Boolean",{"$f":"D24=$E$3","v":false},true,false,false,false,false,false]
[null,null,"Scenario",{"$f":"IF(D25,D23,100%)","v":1},1.1499999999999999,1,1,1,1,1]