{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Savings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"defined_names":23,"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":"Savings","index":0,"n_rows":31,"n_cols":31,"rows_kept":31,"cut":false,"hidden":false,"merged":[[11,16,12,27],[3,14,3,16],[4,14,4,16],[4,20,7,24],[5,6,5,8],[5,14,5,16],[6,14,6,16],[7,6,7,8],[7,14,7,16],[14,14,30,14],[1,3,2,7],[11,1,11,2],[11,3,11,8],[11,14,12,15],[1,9,2,10]]}
[]
[null,null,null,"Investments & Loans     ©Rocketwaveuk.  ",null,null,null,null,null,"Locked"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Interest Rate               >>>>",null,null,2.5000000000000001E-3]
[null,null,null,"Yearly Interest %",2.75E-2,null,null,null,null,null,null,null,null,null,"      Years                            >>>>",null,null,{"$f":"Q14","v":5}]
[null,null,null,{"$f":"IF(E6=E5,\"Yearly Rate Set\",\"Period Rate\")","v":"Period Rate"},{"$f":"E5/E7","v":2.2916666666666667E-3},null,"THESE COLOURED CELLS ARE VARIABLES THAT CAN BE CHANGED",null,null,null,null,null,null,null,"      Loan Amount             >>>>",null,null,100000]
[null,null,null,"Compounded By",12,null,null,null,null,null,null,null,null,null,"      Monthly payment    >>>>",null,null,{"$f":"PMT(R4/12,R5*12,-R6)","v":1677.2786374887501}]
[null,null,null,"Your Investment",10000,null,null,null,null,null,null,null,null,null,"      Total Paid                    >>>>",null,null,{"$f":"R7*R5*12","v":100636.71824932501}]
[null,null,null,"Number   Years",5,null,null,null,null,null,null,null,null,null,1,2,5]
[null,null,null,{"$f":"IF(B12=\"Investment Return\",\"Expected Profit\",\"Investment Return\")","v":"Investment Return"},{"$f":"IF(B12=\"Total Investment\",(E8*(1+E6)^(E9*E7))-E8,(E8*(1+E6)^(E9*E7)))","v":11472.212203505134}]
[]
[null,"Investment Total",null,{"$f":" \"Saving Over \"&D13&\"  Year Steps - At \"&(E5*100)&\"% Annual Interest Rates - And Compounded At \"&(12/E7)&\" Monthly Periods\"","v":"Saving Over 1  Year Steps - At 2.75% Annual Interest Rates - And Compounded At 1 Monthly Periods"},null,null,null,null,null,null,null,null,null,null,"Payments",null,{"$f":"IF(O12=\"Payments\",\">>>>>      Years Below                            >>>>>    Monthly  Payments\",\">>>>>      Years Below                             >>>>>   Total Amount Paid\")","v":">>>>>      Years Below                            >>>>>    Monthly  Payments"}]
[null,"Annual %",{"$f":"IF(B12=\"Investment Total\",(E8*(1+E6)^(E9*E7)),(E8*(1+E6)^(E9*E7))-E8)","v":11472.212203505134},1,{"$f":"D13+D13","v":2},{"$f":"E13+D13","v":3},{"$f":"F13+D13","v":4},{"$f":"G13+D13","v":5},{"$f":"H13+D13","v":6}]
[null,{"$f":"E5-2%","v":7.4999999999999997E-3},{"$f":"IF((B14/$E$7)<0.001,0,(B14/$E$7))","v":0},10000,10000,10000,10000,10000,10000,null,null,null,null,null,null,{"$f":"IF(O12=\"Payments\",R7,R8)","v":1677.2786374887501},5,{"$f":"Q14+Q14","v":10},{"$f":"R14+Q14","v":15},{"$f":"S14+Q14","v":20},{"$f":"T14+Q14","v":25},{"$f":"U14+Q14","v":30},{"$f":"V14+Q14","v":35},{"$f":"W14+Q14","v":40},{"$f":"X14+Q14","v":45},{"$f":"Y14+Q14","v":50},{"$f":"Z14+Q14","v":55},{"$f":"AA14+Q14","v":60}]
[null,{"$f":"E5-1.75%","v":9.9999999999999985E-3},{"$f":"IF((B15/$E$7)<0.001,0,(B15/$E$7))","v":0},10000,10000,10000,10000,10000,10000,null,null,null,null,null,"Interest Rates",{"$f":"R4","v":2.5000000000000001E-3},1677.2786374887501,843.88020034692852,566.09518644386651,427.21352750314895,343.89320959846003,288.35356119524425,248.68858001384152,218.94526474527149,195.81639228986089,177.31762865269675,162.18621571431464,149.58031461604003]
[null,{"$f":"E5-1.5%","v":1.2500000000000001E-2},1.0416666666666667E-3,10125.718638288545,10253.017794178406,10381.917337721639,10512.4373887739,10644.598320134928,10778.420760728517,null,null,null,null,null,null,{"$f":"R4+0.25%","v":5.0000000000000001E-3},1687.9339846869118,854.5138334472349,576.76495962643253,437.93389161251105,354.66993075452837,299.18950723402122,259.58537376229452,229.90390400593824,206.83752539639232,188.40169225472033,173.33350994008833,160.79104692478191,null,null,""]
[null,{"$f":"E5-1.25%","v":1.4999999999999999E-2},1.25E-3,10151.035558984162,10304.352291976091,10459.984652814926,10617.967615715294,10778.336683126823,10941.127893712381,null,null,null,null,null,null,{"$f":"R4+0.5%","v":7.4999999999999997E-3},1709.3747445455115,876.04121370164137,598.49451451834466,459.89430695785285,376.87245423060261,321.63952044650722,282.28569893671732,252.8560444080014,230.04221705864649,211.85918028146637,197.04369966981713,184.75359256510205]
[null,{"$f":"E5-1%","v":1.7500000000000002E-2},1.4583333333333334E-3,10176.410491552911,10355.933049258814,10538.622573229692,10724.534932073095,10913.726979977433,11106.256574098639,null,null,null,null,null,null,{"$f":"R4+0.75%","v":0.01},1741.8607740129876,908.98159581551852,632.06134707843057,494.12881268233582,411.78911611825271,357.24344741722348,318.57759802867139,289.83409646711851,267.7029218016649,250.19779038968161,236.05446913543074,224.42993302573842]
[null,{"$f":"$E$5-0.75%","v":0.02},1.6666666666666668E-3,10201.84355681502,10407.761195772819,10617.835149596431,10832.149310823443,11050.789265308238,11273.842326400547,null,null,null,null,null,null,{"$f":"R4+1%","v":1.2500000000000001E-2},1785.7810332712395,954.11030631199105,678.62163742602752,542.1663066886972,461.3108552425216,408.24118099885266,371.03458262731544,343.72779369790953,323.00634455017962,306.88031915205653,294.08243426433808,283.76708333905515]
[null,{"$f":"$E$5-0.5%","v":2.2499999999999999E-2},1.8749999999999999E-3,10227.334875817189,10459.837866210657,10697.626460448948,10940.820818741429,11189.543832958097,11443.921188729746,null,null,null,null,null,null,{"$f":"R4+1.25%","v":1.5000000000000001E-2},1841.65220552659,1012.4513816487928,739.68792560925579,605.98032929940814,527.83684029776896,477.41529546545291,442.77474103330974,417.93846940380962,399.58176269105081,385.70700228987539,375.04141892889686,366.73591324509164]
[null,{"$f":"$E$5-0.25%","v":2.5000000000000001E-2},2.0833333333333333E-3,10252.884569832902,10512.164200231764,10778.000612410609,11050.55961726343,11330.011218785883,11616.529720112347,null,null,null,null,null,null,{"$f":"R4+1.5%","v":1.7499999999999998E-2},1910.1162171782219,1085.2627796048059,817.08345462113823,687.88730785923792,614.08749228146962,567.78900134700257,537.01627922260764,515.77028132377518,500.71387962249264,489.84547351293241,481.89540460855824,476.02345892949108]
[null,{"$f":"$E$5","v":2.75E-2},{"$f":"B22/$E$7","v":2.2916666666666667E-3},10278.492760362775,10564.741342482992,10858.961740381672,11161.375963356937,11472.212203505134,11791.705007907296,null,null,null,null,null,null,{"$f":"R4+1.75%","v":0.02},1991.9361352682729,1174.0104115708257,912.86288103398556,790.37598491767631,722.80686409716554,682.17628005619179,656.46724497389823,639.67192165156234,628.46976567600507,620.89439332934398,615.7237164954322,612.17194515664141]
[null,{"$f":"$E$5+0.25%","v":0.03},2.5000000000000001E-3,10304.159569135067,10617.570442619777,10940.514007728625,11273.280210399316,11616.16781555271,11969.484675330625,null,null,null,null,null,null,{"$f":"R4+2%","v":2.2499999999999999E-2},2087.9898294733916,1280.3272197704771,1029.1922897932718,915.86683384157527,856.38184274095102,822.67542550427402,802.74432025980832,790.6605645902315,783.22319720579219,778.60306646187246,775.71650535657079,773.9065736816857]
[null,{"$f":"$E$5+0.5%","v":3.2500000000000001E-2},2.7083333333333334E-3,10329.8851181059,10670.652655326574,11022.661606473519,11386.282809062806,11761.899333988291,12149.906889082533,null,null,null,null,null,null,{"$f":"R4+2.25%","v":2.4999999999999998E-2},2199.2607374870418,1405.9544397898039,1168.1898099079986,1066.4296315128593,1016.4689649781312,990.29143313906661,976.10733253537126,968.28186608575834,963.92148973386611,961.47844519807029,960.10542066375433,959.33242417199699]
[null,{"$f":"$E$5+0.75%","v":3.5000000000000003E-2},2.9166666666666668E-3,10355.669529459705,10723.989140338017,11105.408757485518,11500.394308208772,11909.428291428942,12333.010367083602,null,null,null,null,null,null,{"$f":"R4+2.5%","v":2.75E-2},2326.8250849387646,1552.6643504091426,1331.7413878748855,1243.5208110352378,1203.7610432711485,1184.8717510565343,1175.6732808188017,1171.1400622596775,1168.8928284382425,1167.7755732754745,1167.2193057629456,1166.9421479060002]
[null,{"$f":"$E$5+1%","v":3.7499999999999999E-2},3.1249999999999997E-3,10381.512925609639,10777.581062460002,11188.759710673419,11615.625355789645,12058.776477016929,12518.834386318869,null,null,null,null,null,null,{"$f":"R4+2.75%","v":0.03},2471.8350054524235,1722.1672950182824,1521.3210692656908,1447.8195618994707,1417.9970540082968,1405.395567771068,1399.9797795688635,1397.6352786103228,1396.6171573825884,1396.1744275519743,1395.9817928017576,1395.8979545731324]
[null,{"$f":"$E$5+1.25%","v":0.04},3.3333333333333335E-3,10407.415429197908,10831.429591590666,11272.718745179149,11731.986699758596,12209.965939421225,12707.418790791338,null,null,null,null,null,null,{"$f":"R4+3%","v":3.2500000000000001E-2},2635.4972029004325,1916.0101765542208,1737.8547562063941,1679.2227579125322,1658.214641250813,1650.4609373015116,1647.568013617408,1646.4843001342983,1646.0777195672363,1645.9250950701098,1645.8677898729213,1645.8462720480625]
[null,{"$f":"$E$5+1.5%","v":4.2499999999999996E-2},3.5416666666666665E-3,10433.377163096169,10885.535902741667,11357.290169572836,11849.489188987785,12363.01898987401,12898.803999587581,null,null,null,null,null,null,{"$f":"R4+3.25%","v":3.5000000000000003E-2},2819.0471089894418,2135.4779834151332,1981.6634588541594,1937.0033314656234,1923.1298326346007,1918.7308016360707,1917.3269153650097,1916.8779635981834,1916.7342980047958,1916.6883150217134,1916.673596278494,1916.6688848384722]
[null,{"$f":"$E$5+1.75%","v":4.4999999999999998E-2},3.7499999999999999E-3,10459.398250405895,10939.901176059389,11442.478322048899,11968.143774194565,12517.958205241686,13093.0310150559,null,null,null,null,null,null,{"$f":"R4+3.5%","v":3.7500000000000006E-2},3023.7189133725988,2381.5126894245518,2252.5036314832796,2220.0729437606692,2211.4868302375653,2209.1828292994269,2208.5623467551873,2208.3950851380391,2208.3499851797051,2208.3378236980229,2208.3345442174414,2208.3336598640308]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R4+3.75%","v":0.04},3250.7123574430461,2654.6635456741792,2549.6939142732176,2527.2563442092642,2522.2726413079322,2521.1563566139089,2520.9058542041271,2520.8496160048676,2520.8369892461224,2520.8341541906602,2520.8335176395185,2520.8333747154047]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R4+4%","v":4.2500000000000003E-2},3501.157737199479,2955.0785347676647,2872.2921014100862,2857.4988777606782,2854.7818520016981,2854.2803289249828,2854.1876700273879,2854.1705479271918,2854.167383897453,2854.1667992062016,2854.1666911591051,2854.1666711927091]