{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["£1000","£2000","£4000","GT_Custom"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"£1000","index":0,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[13,4,13,5],[12,4,12,5],[2,10,2,11]],"flags":["formulas_cached_only"]}
[]
[null,"Starting salary",25000,"Assume individual commences work September following graduation"]
[{"$nulls":10},"Debt at university"]
[null,"Total borrowed",39000,"at graduation debt + RPI+3% interest is (D BIS figure - see right)",{"$nulls":4},43031.625,null,"Debt interest = RPI + supp."]
[{"$nulls":8},"Tuition","Maintenance","Loan","Debt "]
[null,"Annual wage growth",0.04,"(assumed for life of loan)",{"$nulls":4},9000,4000,13000,13650]
[{"$nulls":10},13000,27982.5]
[null,"Repayment",0.09,{"$nulls":7},13000,43031.625]
[null,"max RPI supplement",0.03]
[null,"RPI",0.02,"(assumed for life of the loan)"]
[]
[null,"assume real salary increase on top of wage growth is",{"$nulls":4},1000,"each year"]
[{"$nulls":4},"Threshold"]
[{"$nulls":4},"(uprated with wages)",null,"Interest"]
["age","year","debt at start","Salary","Lower ","Upper","RPI+supp","interest added","repayment","debt at yr end"]
[]
[22,1,43031.625,25000,21000,41000,0.025714285714285714,1106.5275,360,43778.1525]
[23,2,43778.1525,27000,21840,42640,0.027087912087912086,1185.8587462912087,464.4,44499.611246291206]
[24,3,44499.611246291206,29080,22713.6,44345.6,0.028408706677937445,1264.1764031781331,572.9759999999998,45190.81164946934]
[25,4,45190.81164946934,31243.2,23622.144000000004,46119.424,0.02967870147603875,1341.2046084044948,685.8950399999997,45846.12121787383]
[26,5,45846.12121787383,33492.928,24567.029760000005,47964.20096,0.030899850320366927,1416.6382834016995,803.3308415999995,46459.42865967553]
[27,6,46459.42865967553,35832.64512,25549.710950400007,49882.7689984,0.03207403190145171,1490.1411969536525,925.4640752639993,47024.10578136518]
[28,7,47024.10578136518,38265.9509248,26571.699388416007,51878.079758336,0.03320305265249478,1561.343860195152,1052.4826382745596,47532.96700328577]
[29,8,47532.96700328577,40796.588961792004,27634.56736395265,53953.202948669445,0.03428864952849772,1629.8412466253124,1184.5819438055419,47978.22630610554]
[30,9,47978.22630610554,43428.45252026369,28739.950058510756,56111.33106661622,0.03533249267850056,1695.190329687917,1321.9652215577637,48351.45141423569]
[31,10,48351.45141423569,46165.59062107423,29889.548060851186,58355.78430928087,0.036336188015041744,1756.907429387824,1464.843830420074,48643.51501320344]
[32,11,48643.51501320344,49012.2142459172,31085.129983285235,60690.015681652105,0.03730127968479288,1814.465358358923,1613.437583636877,48844.542787925486]
[33,12,48844.542787925486,51972.702815753895,32328.535182616644,63117.616308918194,0.038229252444168985,1867.290356759617,1767.9750869823524,48943.858057702746]
[34,13,48943.858057702746,55051.610928384056,33621.67658992131,65642.32096127492,0.03912153394356908,1914.7588043336448,1928.6940904616467,48929.92277157474]
[35,14,48929.92277157474,58253.67536551942,34966.543653518165,68268.01379972592,0.03997949692376147,1956.1936969260587,2095.8418540801126,48790.27461442068]
[36,15,48790.27461442068,61583.8223801402,36365.205399658895,70998.73435171496,0.04080446132779263,1990.8608736765111,2269.6755282433173,48511.45995985388]
[37,16,48511.45995985388,65047.175275345806,37819.81361564525,73838.68372578356,0.04159769633166873,2017.9649800159082,2450.4625493730496,48078.96239049674]
[38,17,48078.96239049674,68649.06228635964,39332.60616027106,76792.2310748149,0.042360422296934215,2036.6451504598595,2638.4810513479715,47477.12648960862]
[39,18,47477.12648960862,72395.02477781402,40905.910406681905,79863.9203178075,0.04309381264815103,2045.9703940157622,2834.02029340189,46689.076590222496]
[40,19,46689.076590222496,76290.82576892659,42542.14682294918,83058.4771305198,0.0437989956781672,2044.9346637927727,3037.3811051379666,45696.6301488773]
[41,20,45696.6301488773,80342.45879968365,44243.832695867146,86380.81621574059,0.04447705628395198,2032.4515911185529,3248.8763493434853,44480.205390652365]
[42,21,44480.205390652365,84556.157151671,46013.586003701836,89836.04886437021,0.04512903763566811,2007.3488631169982,3468.831403317224,43018.72285045214]
[43,22,43018.72285045214,88938.40343773784,47854.12944384991,93429.49081894502,0.04575594278154901,1968.3622212806029,3697.5846594499135,41289.500412282825]
[44,23,41289.500412282825,93495.93957524736,49768.294621603905,97166.67045170283,0.046358736191049875,1914.1290570732644,3935.4880458279113,39268.141423528185]
[45,24,39268.141423528185,98235.77715825726,51759.02640646807,101053.33726977094,0.04693834523864686,1843.1815790175756,4182.907567661027,36928.41543488473]
[46,25,36928.41543488473,103165.20824458756,53829.387462726794,105095.47076056179,0.047495661630567024,1753.9395240482936,4440.223870367468,34242.131088565555]
[47,26,34242.131088565555,108291.81657437106,55982.56296123587,109299.28959098426,0.048031542776644114,1644.7023841438918,4707.832825182167,31179.000647527282]
[48,27,31179.000647527282,113623.4892373459,58221.86547968531,113671.26117462364,0.048546813109410544,1513.6411173736974,4986.146138189453,27706.495626711527]
[49,28,27706.495626711527,119168.42880683974,60550.740098872724,118218.11162160858,0.05,1385.3247813355765,5275.591983717031,23816.228424330075]
[50,29,23816.228424330075,124935.16595911334,62972.76970282764,122946.83608647293,0.05,1190.8114212165037,5576.615663065712,19430.424182480863]
[51,30,19430.424182480863,130932.57259747788,65491.680490940744,127864.70952993186,0.05,971.5212091240433,5889.680289588342,14512.265102016565]
[]
[null,"Loan is written off after 30 years",{"$nulls":5},"Total paid in cash",78881.68752929686]
[]
["© Paul Lewis 2011"]

{"sheet":"£2000","index":1,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,10,1,11],[11,4,11,5],[12,4,12,5]],"flags":["formulas_cached_only"]}
[null,"Starting salary",25000,"Assume individual commences work September following graduation"]
[{"$nulls":10},"Debt at university"]
[null,"Total borrowed",39000,"at graduation debt + RPI+3% interest is (D BIS figure - see right)",{"$nulls":4},43031.625,null,"Debt interest = RPI + supp."]
[{"$nulls":8},"Tuition","Maintenance","Loan","Debt "]
[null,"Annual wage growth",0.04,"(assumed for life of loan)",{"$nulls":4},9000,4000,13000,13650]
[{"$nulls":10},13000,27982.5]
[null,"Repayment",0.09,{"$nulls":7},13000,43031.625]
[null,"max RPI supplement",0.03]
[null,"RPI",0.02,"(assumed for life of the loan)"]
[]
[null,"assume real salary increase on top of wage growth is",{"$nulls":4},2000,"each year"]
[{"$nulls":4},"Threshold"]
[{"$nulls":4},"(uprated with wages)",null,"Interest"]
["age","year","debt at start","Salary","Lower ","Upper","RPI+supp","interest added","repayment","debt at yr end"]
[]
[22,1,43031.625,25000,21000,41000,0.025714285714285714,1106.5275,360,43778.1525]
[23,2,43778.1525,28000,21840,42640,0.02846153846153846,1245.993571153846,554.4,44469.746071153844]
[24,3,44469.746071153844,31120,22713.6,44345.6,0.031103127641589175,1383.1481882401567,756.5759999999998,45096.318259394]
[25,4,45096.318259394,34364.8,23622.144000000004,46119.424,0.03364311723779179,1517.180722193563,966.8390399999998,45646.65994158756]
[26,5,45646.65994158756,37739.39200000001,24567.029760000005,47964.20096,0.03608541492644815,1647.1786639986667,1185.5126016000002,46108.32600398623]
[27,6,46108.32600398623,41248.96768000001,25549.710950400007,49882.7689984,0.038433778088617726,1772.1171696748488,1412.933105664,46467.51006799708]
[28,7,46467.51006799708,44898.92638720001,26571.699388416007,51878.079758336,0.04069181959070386,1890.8475365161523,1649.45042989056,46708.90717462267]
[29,8,46708.90717462267,48694.88344268801,27634.56736395265,53953.202948669445,0.042863013342709755,2002.0845114492429,1895.4284470861826,46815.56323898573]
[30,9,46815.56323898573,52642.67878039554,28739.950058510756,56111.33106661622,0.04495069964271542,2104.392321760197,2151.2455849696303,46768.7099757763]
[31,10,46768.7099757763,56748.38593161136,29889.548060851186,58355.78430928087,0.0469580903157978,2196.169306995857,2417.2954083684153,46547.58387440374]
[32,11,46547.58387440374,61018.32136887582,31085.129983285235,60690.015681652105,0.05,2327.3791937201872,2693.9872247031526,46180.975843420776]
[33,12,46180.975843420776,65459.054223630854,32328.535182616644,63117.616308918194,0.05,2309.0487921710387,2981.7467136912787,45508.27792190053]
[34,13,45508.27792190053,70077.4163925761,33621.67658992131,65642.32096127492,0.05,2275.4138960950268,3281.0165822389304,44502.67523575663]
[35,14,44502.67523575663,74880.51304827914,34966.543653518165,68268.01379972592,0.05,2225.1337617878316,3592.257245528488,43135.55175201597]
[36,15,43135.55175201597,79875.73357021032,36365.205399658895,70998.73435171496,0.05,2156.7775876007986,3915.9475353496277,41376.38180426714]
[37,16,41376.38180426714,85070.76291301873,37819.81361564525,73838.68372578356,0.05,2068.819090213357,4252.585436763613,39192.615457716885]
[38,17,39192.615457716885,90473.59342953948,39332.60616027106,76792.2310748149,0.05,1959.6307728858444,4602.688854234158,36549.557376368575]
[39,18,36549.557376368575,96092.53716672107,40905.910406681905,79863.9203178075,0.05,1827.4778688184288,4966.796408403525,33410.23883678348]
[40,19,33410.23883678348,101936.23865338991,42542.14682294918,83058.4771305198,0.05,1670.5119418391741,5345.468264739666,29735.28251388299]
[41,20,29735.28251388299,108013.68819952551,44243.832695867146,86380.81621574059,0.05,1486.7641256941497,5739.286995329253,25482.759644247886]
[42,21,25482.759644247886,114334.23572750653,46013.586003701836,89836.04886437021,0.05,1274.1379822123945,6148.858475142423,20608.03915131786]
[43,22,20608.03915131786,120907.60515660679,47854.12944384991,93429.49081894502,0.05,1030.4019575658929,6574.812814148119,15063.628294735632]
[44,23,15063.628294735632,127743.90936287107,49768.294621603905,97166.67045170283,0.05,753.1814147367817,7017.805326714045,8799.004382758369]
[45,24,8799.004382758369,134853.66573738592,51759.02640646807,101053.33726977094,0.05,439.95021913791845,7478.517539782606,1760.4370621136804]
[46,25,1760.4370621136804,142247.81236688135,53829.387462726794,105095.47076056179,0.05,88.02185310568403,1848.4589152193644,0]
[47,26,0,149937.7248615566,55982.56296123587,109299.28959098426,0.05,0,0,0]
[48,27,0,157935.23385601887,58221.86547968531,113671.26117462364,0.05,0,0,0]
[49,28,0,166252.64321025962,60550.740098872724,118218.11162160858,0.05,0,0,0]
[50,29,0,174902.74893867,62972.76970282764,122946.83608647293,0.05,0,0,0]
[51,30,0,183898.8588962168,65491.680490940744,127864.70952993186,0.05,0,0,0]
[]
[null,"Loan is written off after 30 years",{"$nulls":5},"Total paid in cash",83789.91494956704]
[]
[]
[]
["© Paul Lewis 2011"]

{"sheet":"£4000","index":2,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,10,1,11],[11,4,11,5],[12,4,12,5]],"flags":["formulas_cached_only"]}
[null,"Starting salary",25000,"Assume individual commences work September following graduation"]
[{"$nulls":10},"Debt at university"]
[null,"Total borrowed",39000,"at graduation debt + RPI+3% interest is (D BIS figure - see right)",{"$nulls":4},43031.625,null,"Debt interest = RPI + supp."]
[{"$nulls":8},"Tuition","Maintenance","Loan","Debt "]
[null,"Annual wage growth",0.04,"(assumed for life of loan)",{"$nulls":4},9000,4000,13000,13650]
[{"$nulls":10},13000,27982.5]
[null,"Repayment",0.09,{"$nulls":7},13000,43031.625]
[null,"max RPI supplement",0.03]
[null,"RPI",0.02,"(assumed for life of the loan)"]
[]
[null,"assume real salary increase on top of wage growth is",{"$nulls":4},4000,"each year"]
[{"$nulls":4},"Threshold"]
[{"$nulls":4},"(uprated with wages)",null,"Interest"]
["age","year","debt at start","Salary","Lower ","Upper","RPI+supp","interest added","repayment","debt at yr end"]
[]
[22,1,43031.625,25000,21000,41000,0.025714285714285714,1106.5275,360,43778.1525]
[23,2,43778.1525,30000,21840,42640,0.03120879120879121,1366.2632208791208,734.4,44410.01572087911]
[24,3,44410.01572087911,35200,22713.6,44345.6,0.03649196956889264,1620.6089422403643,1123.7759999999998,44906.84866311948]
[25,4,44906.84866311948,40608,23622.144000000004,46119.424,0.04157194876129786,1866.8652116545607,1528.7270399999995,45244.98683477405]
[26,5,45244.98683477405,46232.32,24567.029760000005,47964.20096,0.046456544138610584,2101.925727940535,1949.8761215999994,45397.036441114586]
[27,6,45397.036441114586,52081.6128,25549.710950400007,49882.7689984,0.05,2269.8518220557294,2387.8711664639995,45279.01709670632]
[28,7,45279.01709670632,58164.877312000004,26571.699388416007,51878.079758336,0.05,2263.950854835316,2843.3860131225597,44699.581938419076]
[29,8,44699.581938419076,64491.47240448001,27634.56736395265,53953.202948669445,0.05,2234.979096920954,3317.121453647462,43617.43958169257]
[30,9,43617.43958169257,71071.13130065921,28739.950058510756,56111.33106661622,0.05,2180.8719790846285,3809.8063117933602,41988.505248983834]
[31,10,41988.505248983834,77913.97655268558,29889.548060851186,58355.78430928087,0.05,2099.425262449192,4322.198564265095,39765.73194716793]
[32,11,39765.73194716793,85030.535614793,31085.129983285235,60690.015681652105,0.05,1988.2865973583966,4855.086506835698,36898.932037690625]
[33,12,36898.932037690625,92431.75703938473,32328.535182616644,63117.616308918194,0.05,1844.9466018845314,5409.289967109127,33334.58867246603]
[34,13,33334.58867246603,100129.02732096011,33621.67658992131,65642.32096127492,0.05,1666.7294336233017,5985.661565793493,29015.65654029584]
[35,14,29015.65654029584,108134.18841379852,34966.543653518165,68268.01379972592,0.05,1450.782827014792,6585.088028425232,23881.3513388854]
[36,15,23881.3513388854,116459.55595035046,36365.205399658895,70998.73435171496,0.05,1194.06756694427,7208.491549562241,17866.92735626743]
[37,16,17866.92735626743,125117.93818836448,37819.81361564525,73838.68372578356,0.05,893.3463678133717,7856.831211544731,10903.442512536072]
[38,17,10903.442512536072,134122.65571589908,39332.60616027106,76792.2310748149,0.05,545.1721256268037,8531.10446000652,2917.5101781563553]
[39,18,2917.5101781563553,143487.56194453503,40905.910406681905,79863.9203178075,0.05,145.87550890781776,3063.385687064173,0]
[40,19,0,153227.06442231644,42542.14682294918,83058.4771305198,0.05,0,0,0]
[41,20,0,163356.1469992091,44243.832695867146,86380.81621574059,0.05,0,0,0]
[42,21,0,173890.39287917747,46013.586003701836,89836.04886437021,0.05,0,0,0]
[43,22,0,184846.00859434457,47854.12944384991,93429.49081894502,0.05,0,0,0]
[44,23,0,196239.84893811838,49768.294621603905,97166.67045170283,0.05,0,0,0]
[45,24,0,208089.44289564312,51759.02640646807,101053.33726977094,0.05,0,0,0]
[46,25,0,220413.02061146885,53829.387462726794,105095.47076056179,0.05,0,0,0]
[47,26,0,233229.54143592762,55982.56296123587,109299.28959098426,0.05,0,0,0]
[48,27,0,246558.72309336474,58221.86547968531,113671.26117462364,0.05,0,0,0]
[49,28,0,260421.07201709933,60550.740098872724,118218.11162160858,0.05,0,0,0]
[50,29,0,274837.9148977833,62972.76970282764,122946.83608647293,0.05,0,0,0]
[51,30,0,289831.43149369466,65491.680490940744,127864.70952993186,0.05,0,0,0]
[]
[null,"Loan is written off after 30 years",{"$nulls":5},"Total paid in cash",71872.10164723369]
[]
[]
[]
["© Paul Lewis 2011"]

{"sheet":"GT_Custom","index":3,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["C1","Custom 1"]
["C2","Custom 2"]
["C3","Custom 3"]
["C4","Custom 4"]
["C5","Custom 5"]
["C6","Custom 6"]
["C7","Custom 7"]
["C8","Custom 8"]