{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Income Advantage","AF Value Calculator","HIP Value Calculator & AF"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":13,"comments":1,"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":"Income Advantage","index":0,"n_rows":84,"n_cols":67,"rows_kept":84,"cut":false,"hidden":false,"merged":[[83,1,83,7],[5,1,5,17],[14,7,14,8],[12,5,12,8],[8,5,8,7],[9,5,9,7]]}
[null,{"$f":"CELL(\"filename\")","v":"S:\\Marketing\\REFERRED MARKETING\\2016\\Q1\\Financial Illustration\\FINAL\\[Financial Illustration_IA.xlsm]Income Advantage"},null,null,null,null,null,null,"Annual",2]
[null,null,null,null,null,null,null,null,"Semi Annual"]
[null,null,null,null,null,null,null,null,"Qtrly"]
[null,null,null,null,null,null,null,null,"Mthly"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,null,null,null,null,"Financial Illustration"]
[null,null,null,null,null,"Income Advantage"]
[]
[]
[null,null,null,null,null,"To begin, ensure you clicked \"Enable Content\" at the top of your screen or turned your Macros on. Click here to learn how to enable macros. "]
[]
[null,null,null,null,null,"Inputs",null,"Additional Tools"]
[null,null,null,null,"Estimated Value of Home ",500000,null,null,null,"Click the button to calculate how much your client could receive"]
[null,null,null,null,"HomEquity Bank Mortgage Amount ",300000]
[null,null,null,null,"Initial Advance Amount ",100000,null,null,null,"Click the button to view HomEquity Bank's current rates"]
[null,null,null,null,"Interest Rate for Initial Advance (Lump Sum Account) ",4.99E-2]
[null,null,null,null," "]
[null,null,null,null,"Planned Advance Amount (per Month) ",2000,null,null,null,"Click the button for current home appreciation statistics"]
[null,null,null,null,"Number of Years to Show in Graph (max. 15) ",8,null,null,null,"(Please note this link will take you to an external site.)"]
[null,null,null,null,"Interest Rate for Planned Advances (Planned Advance Account) ",4.2000000000000003E-2]
[null,null,null,null," "]
[null,null,null,null,"Home Appreciation Rate (per annum) ",0.04]
[]
[]
[]
[]
[]
[null,"Year","Lump Sum Account Initial Advance Amount","Lump Sum Account Interest Rate","Planned Advance Account Annual Advance Amount","Planned Advance Account Interest Rate","Accrued Annual Interest","Estimated End of Year Mortgage Balance","Estimated Future Home Value","Estimated Remaining Home Equity",null,null,null,null,null,null,null,null,null,"Int. Accum. Factor",null,null,"End of Year Planned Advance Principal",null,"Beginning of Year Initial Advance Loan Balance","Beginning of Year Planned Advance Loan Balance",null,"Yearly Initial Advance Interest","Yearly Planned Advance Interest","End of Year Initial Advance Loan Balance","End of Year Planned Advance Loan Balance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total End of Year Principal","Beginning of Year Loan Balance"]
[null,0,{"$f":"+$F$18","v":100000},{"$f":"F19","v":4.99E-2},0,{"$f":"+$F$23","v":4.2000000000000003E-2},{"$f":"+AB32+AC32","v":0},{"$f":"+C32","v":100000},{"$f":"F16","v":500000},{"$f":"I32-$H32","v":400000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$C$32+W32","v":100000}]
[null,1,100000,{"$f":"D32","v":4.99E-2},{"$f":"+IF($C$32+$F$21*12*B33<=$F$17,$F$21*12,$F$17-($C$32+$F$21*12*B32))","v":24000},4.2000000000000003E-2,6070.8342499999926,{"$f":"+AE33+AD33","v":130070.83424999999},{"$f":"I32*(1+$F$25)","v":520000},389929.16575000004,null,null,null,null,null,null,null,null,null,2,null,null,{"$f":"+IF(E33>0,E33+W32,W32)","v":24000},null,{"$f":"H32","v":100000},{"$f":"+AE32","v":0},null,{"$f":"(((1+(D33/T33))^T33)*Y33)-Y33","v":5052.2502499999973},{"$f":"((1+EFFECT(F33,2))*E33)-W33","v":1018.5839999999953},{"$f":"+Y33+AB33","v":105052.25025},{"$f":"+W33+AC33","v":25018.583999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124000,{"$f":"+C32","v":100000}]
[null,2,100000,4.99E-2,24000,4.2000000000000003E-2,7387.9002994302355,161458.73454943023,540800,379341.2654505698,null,null,null,null,null,null,null,null,null,2,null,null,48000,null,{"$f":"+AD33","v":105052.25025},25018.583999999995,null,5307.5025758862466,{"$f":"IF(E34>0,(1+EFFECT(F34,2))*(Z34+E34)-(AE33+E34),(1+EFFECT(F34,2))*Z34-Z34)","v":2080.3977235439888},110359.75282588624,{"$f":"+Z34+AC34+W34-W33","v":51098.981723543984},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148000,{"$f":"+Y34+Z34","v":130070.83424999999}]
[null,3,100000,4.99E-2,24000,4.2000000000000003E-2,8762.9267713741283,194221.66132080436,562432,368210.33867919561,null,null,null,null,null,null,null,null,null,2,null,null,72000,null,110359.75282588624,51098.981723543984,null,5575.6508880452166,3187.2758833289117,115935.40371393146,78286.257606872896,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,172000,161458.73454943023]
[null,4,100000,4.99E-2,24000,4.2000000000000003E-2,10198.477783068884,228420.13910387323,584929.28000000003,356509.1408961268,null,null,null,null,null,null,null,null,null,2,null,null,96000,null,115935.40371393146,78286.257606872896,null,5857.3467239756137,4341.1310590932699,121792.75043790707,106627.38866596617,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,196000,194221.66132080436]
[null,5,100000,4.99E-2,24000,4.2000000000000003E-2,11697.231540853289,264117.37064472656,608326.45120000001,344209.08055527345,null,null,null,null,null,null,null,null,null,2,null,null,120000,null,121792.75043790707,106627.38866596617,null,6153.2745384810405,5543.9570023722481,127946.02497638811,136171.34566833841,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220000,228420.13910387323]
[null,6,100000,4.99E-2,24000,4.2000000000000003E-2,13261.985448244523,301379.35609297105,632659.50924799999,331280.15315502894,null,null,null,null,null,null,null,null,null,2,null,null,144000,null,127946.02497638811,136171.34566833841,null,6464.153366734623,6797.8320815098996,134410.17834312274,166969.17774984834,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,244000,264117.37064472656]
[null,7,100000,4.99E-2,24000,4.2000000000000003E-2,14895.661444247118,340275.01753721823,657965.88961792004,317690.87208070181,null,null,null,null,null,null,null,null,2,2,null,null,168000,null,134410.17834312274,166969.17774984834,null,6790.7385713658587,8104.9228728812595,141200.9169144886,199074.10062272963,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,268000,301379.35609297105]
[null,8,100000,4.99E-2,24000,4.2000000000000003E-2,16601.31158234374,380876.32911956194,684284.52520263684,303408.1960830749,null,null,null,null,null,null,null,null,2,2,null,null,192000,null,141200.9169144886,199074.10062272963,null,7133.8236778145365,9467.4879045292037,148334.74059230313,232541.58852725883,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,292000,340275.01753721823]
[null,9,100000,4.99E-2,8000,4.2000000000000003E-2,17703.067861096817,406579.39698065881,711655.90621074231,305076.50923008349,null,null,null,null,null,null,null,null,2,2,null,null,200000,null,148334.74059230313,232541.58852725883,null,7494.2423024114978,10208.825558685319,155828.98289471463,250750.41408594418,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300000,380876.32911956194]
[null,10,100000,4.99E-2,-16000,4.2000000000000003E-2,18514.968502092175,425094.36548275099,740122.14245917206,315027.77697642107,null,null,null,null,null,null,null,null,2,2,null,null,200000,null,155828.98289471463,250750.41408594418,null,7872.8701778706745,10642.098324221501,163701.85307258531,261392.51241016568,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300000,406579.39698065881]
[null,11,100000,4.99E-2,-40000,4.2000000000000003E-2,19364.386900314101,444458.75238306506,769727.02815753897,325268.27577447391,null,null,null,null,null,null,null,null,2,2,null,null,200000,null,163701.85307258531,261392.51241016568,null,8270.6272811143135,11093.759619199787,171972.48035369962,272486.27202936547,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300000,425094.36548275099]
[null,12,100000,4.99E-2,-64000,4.2000000000000003E-2,20253.069939799228,464711.82232286432,800516.10928384052,335804.2869609762,null,null,null,null,null,null,null,null,null,2,null,null,200000,null,171972.48035369962,272486.27202936547,null,8688.4800686009985,11564.58987119823,180660.96042230062,284050.8619005637,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300000,444458.75238306506]
[null,13,100000,4.99E-2,-88000,4.2000000000000003E-2,21182.846454509825,485894.66877737414,832536.75365519419,346642.08487782005,null,null,null,null,null,null,null,null,null,2,null,null,200000,null,180660.96042230062,284050.8619005637,null,9127.4438245880883,12055.402629921737,189788.40424688871,296106.26453048544,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300000,464711.82232286432]
[null,14,100000,4.99E-2,-112000,4.2000000000000003E-2,22155.631100972678,508050.29987834685,865838.22380140203,357787.92392305518,null,null,null,null,null,null,null,null,null,2,null,null,200000,null,189788.40424688871,296106.26453048544,null,9588.5851280344359,12567.045972938242,199376.98937492314,308673.31050342368,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300000,485894.66877737414]
[null,15,100000,4.99E-2,-136000,4.2000000000000003E-2,23173.428415212751,531223.72829355951,900471.7527534581,369248.02445989859,null,null,null,null,null,null,null,null,null,2,null,null,200000,null,199376.98937492314,308673.31050342368,null,10073.024444137031,13100.403971075721,209450.01381906017,321773.7144744994,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300000,508050.29987834685]
[]
[null,"Year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"Initial Advance",{"$f":"+IF(C49<=$F$22,BN32,0)","v":100000},{"$f":"+IF(D49<=$F$22,BN33,0)","v":124000},{"$f":"+IF(E49<=$F$22,BN34,0)","v":148000},{"$f":"+IF(F49<=$F$22,BN35,0)","v":172000},{"$f":"+IF(G49<=$F$22,BN36,0)","v":196000},{"$f":"+IF(H49<=$F$22,BN37,0)","v":220000},{"$f":"+IF(I49<=$F$22,BN38,0)","v":244000},{"$f":"+IF(J49<=$F$22,BN39,0)","v":268000},{"$f":"+IF(K49<=$F$22,BN40,0)","v":292000},{"$f":"+IF(L49<=$F$22,BN41,0)","v":0},{"$f":"+IF(M49<=$F$22,BN42,0)","v":0},{"$f":"+IF(N49<=$F$22,BN43,0)","v":0},{"$f":"+IF(O49<=$F$22,BN44,0)","v":0},{"$f":"+IF(P49<=$F$22,BN45,0)","v":0},{"$f":"+IF(Q49<=$F$22,BN46,0)","v":0},{"$f":"+IF(R49<=$F$22,BN47,0)","v":0}]
[null,"Home Value",{"$f":"+IF(C49<=$F$22,I32,0)","v":500000},{"$f":"+IF(D49<=$F$22,I33,0)","v":520000},{"$f":"+IF(E49<=$F$22,I34,0)","v":540800},{"$f":"+IF(F49<=$F$22,I35,0)","v":562432},{"$f":"+IF(G49<=$F$22,I36,0)","v":584929.28000000003},{"$f":"+IF(H49<=$F$22,I37,0)","v":608326.45120000001},{"$f":"+IF(I49<=$F$22,I38,0)","v":632659.50924799999},{"$f":"+IF(J49<=$F$22,I39,0)","v":657965.88961792004},{"$f":"+IF(K49<=$F$22,I40,0)","v":684284.52520263684},{"$f":"+IF(L49<=$F$22,I41,0)","v":0},{"$f":"+IF(M49<=$F$22,I42,0)","v":0},{"$f":"+IF(N49<=$F$22,I43,0)","v":0},{"$f":"+IF(O49<=$F$22,I44,0)","v":0},{"$f":"+IF(P49<=$F$22,I45,0)","v":0},{"$f":"+IF(Q49<=$F$22,I46,0)","v":0},{"$f":"+IF(R49<=$F$22,I47,0)","v":0}]
[null,"Loan Balance",{"$f":"+IF(C49<=$F$22,H32,0)","v":100000},{"$f":"+IF(D49<=$F$22,H33,0)","v":130070.83424999999},{"$f":"+IF(E49<=$F$22,H34,0)","v":161458.73454943023},{"$f":"+IF(F49<=$F$22,H35,0)","v":194221.66132080436},{"$f":"+IF(G49<=$F$22,H36,0)","v":228420.13910387323},{"$f":"+IF(H49<=$F$22,H37,0)","v":264117.37064472656},{"$f":"+IF(I49<=$F$22,H38,0)","v":301379.35609297105},{"$f":"+IF(J49<=$F$22,H39,0)","v":340275.01753721823},{"$f":"+IF(K49<=$F$22,H40,0)","v":380876.32911956194},{"$f":"+IF(L49<=$F$22,H41,0)","v":0},{"$f":"+IF(M49<=$F$22,H42,0)","v":0},{"$f":"+IF(N49<=$F$22,H43,0)","v":0},{"$f":"+IF(O49<=$F$22,H44,0)","v":0},{"$f":"+IF(P49<=$F$22,H45,0)","v":0},{"$f":"+IF(Q49<=$F$22,H46,0)","v":0},{"$f":"+IF(R49<=$F$22,H47,0)","v":0}]
[null,"Home Equity",{"$f":"+C51-C52","v":400000},{"$f":"+D51-D52","v":389929.16575000004},379341.2654505698,368210.33867919561,356509.1408961268,344209.08055527345,331280.15315502894,317690.87208070181,303408.1960830749,0,0,0,0,0,0,{"$f":"+R51-R52","v":0}]
[null,"Interest",{"$f":"+IF(XStart<=Years,AB32,0)","v":0},{"$f":"+D52-D50","v":6070.8342499999853},{"$f":"+E52-E50","v":13458.734549430228},22221.661320804356,32420.139103873225,44117.370644726558,57379.356092971051,72275.017537218228,88876.329119561939,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*Calculations and chart are for illustration purposes only. External factors not accounted for in the calculations may affect future projections and are based on certain assumptions. HomEquity Bank may change or update calculations without notification.This information is not intended as specific financial, accounting, legal, or tax advice for any individual and should not be relied on as such. "]

{"sheet":"AF Value Calculator","index":1,"n_rows":82,"n_cols":16,"rows_kept":82,"cut":false,"hidden":true,"merged":[[16,10,16,11],[16,12,16,13],[16,14,16,15]]}
[{"$f":"CELL(\"filename\")","v":"S:\\Marketing\\REFERRED MARKETING\\2016\\Q1\\Financial Illustration\\FINAL\\[Financial Illustration_IA.xlsm]Income Advantage"},null,null,null,null,null,null,null,null,null,"Annual",2]
[null,null,null,null,null,null,null,null,null,null,"Semi Annual"]
[null,null,null,null,null,null,null,null,null,null,"Qtrly"]
[null,null,null,null,null,null,null,null,null,null,"Mthly"]
[]
[{"$f":"CELL(\"filename\")","v":"S:\\Marketing\\REFERRED MARKETING\\2016\\Q1\\Financial Illustration\\FINAL\\[Financial Illustration_IA.xlsm]Income Advantage"}]
["Estimated Fair Market Value of Home",350000]
["CHIP Maximum",137000]
["HIP Portion",{"$f":"B8-B10","v":124904}]
["Additional Finance Portion",12096]
["# of AF Payments",98]
["Monthly Payments",171]
["Interest Rate ",8.1500000000000003E-2]
["Reset Date"]
["Interest Accumulation"]
[]
[null,null,null,null,null,null,null,null,null,null,0.02,null,0.04,null,0.06]
["AF Calculator",null,null,null,null,null,null,null,null,null,"Home","Remaining","Home","Remaining","Home","Remaining"]
["Year","Jan 1 Cost","Interest Rate","Int. Accum. Factor","Payback of AF","Yearly Interest","Accumulated Cost","CHIP App","Var","% Var","Value","Home Equity","Value","Home Equity","Value","Home Equity"]
[0,null,{"$f":"B13","v":8.1500000000000003E-2},null,0,0,{"$f":"B8","v":137000},137000,{"$f":"H20-G20","v":0},null,{"$f":"B7","v":350000},{"$f":"K20-$G20","v":213000},{"$f":"B7","v":350000},{"$f":"M20-$G20","v":213000},{"$f":"B7","v":350000},{"$f":"O20-$G20","v":213000}]
[1,{"$f":"G20","v":137000},{"$f":"C20","v":8.1500000000000003E-2},{"$f":"IF($L$1=1,1,IF($L$1=2,2,IF($L$1=3,4,IF($L$1=4,12,0))))","v":2},{"$f":"N67","v":1881},{"$f":"(((1+(C21/D21))^D21)*(B21-E21))-G20","v":9355.5720444375183},{"$f":"G20+F21","v":146355.57204443752},146387,{"$f":"H21-G21","v":31.427955562481657},{"$f":"I21/H21","v":2.1469089169449238E-4},{"$f":"K20*(1+$K$17)","v":357000},210644.42795556248,{"$f":"M20*(1+$M$17)","v":364000},217644.42795556248,{"$f":"O20*(1+$O$17)","v":371000},224644.42795556248]
[2,146355.57204443752,8.6499999999999994E-2,2,2052,10700.187832326221,157055.75987676374,157162,106.24012323626084,{"$f":"I22/H22","v":6.7599116348901673E-4},364140,207084.24012323626,378560,221504.24012323626,393260,236204.24012323626]
[3,157055.75987676374,8.6499999999999994E-2,2,2052,11645.769449924526,168701.52932668827,168893,191.47067331173457,1.1336803379165185E-3,371422.8,202721.27067331172,393702.40000000002,225000.87067331176,416855.60000000003,248154.07067331177]
[4,168701.52932668827,8.4000000000000005E-2,2,2052,12240.530233174126,180942.05955986239,181246,303.94044013760868,1.6769497817199204E-3,378851.25599999999,197909.1964401376,409450.49600000004,228508.43644013765,441866.93600000005,260924.87644013765]
[5,180942.05955986239,8.1500000000000003E-2,2,2052,12824.597978656675,193766.65753851907,194205,438.34246148093371,2.257112131412341E-3,386428.28112,192661.62358148093,425828.51584000007,232061.858301481,468378.95216000004,274612.29462148098]
[6,193766.65753851907,7.9000000000000001E-2,2,2052,13392.580739967525,207159.23827848659,207748,588.7617215134087,2.8340187222664417E-3,394156.84674240003,186997.60846391344,442861.65647360007,235702.41819511348,496481.68928960006,289322.45101111347]
[7,207159.23827848659,7.6499999999999999E-2,2,2052,13938.788437108014,221098.02671559461,221845,746.97328440539422,3.3670954243070353E-3,402039.98367724806,180941.95696165346,460576.12273254409,239478.09601694948,526270.59064697614,305172.56393138156]
[8,221098.02671559461,7.3999999999999996E-2,2,2052,14457.279987527611,235555.30670312222,236458,902.69329687778372,3.8175629366643707E-3,410080.783350793,174525.47664767079,478999.16764184588,243443.86093872366,557846.82608579472,322291.5193826725]
[9,235555.30670312222,7.2499999999999995E-2,2,513,16836.42751712841,252391.73422025063,253507,1115.2657797493739,4.3993490505168454E-3,418282.3990178089,165890.66479755827,498159.13434751972,245767.40012726909,591317.63565094245,338925.90143069183]
[10,252391.73422025063,7.2499999999999995E-2,2,null,{"$f":"(((1+(C30/D30))^D30)*B30)-G29","v":18630.059244216944},271021.79346446757,272220,1198.2065355324303,4.4016109600045197E-3,426648.04699816508,155626.25353369751,518085.49972142052,247063.70625695295,626796.693789999,355774.90032553143]
[11,271021.79346446757,7.2499999999999995E-2,2,null,20005.219601648278,291027.01306611585,null,{"$f":"H31-G31","v":-291027.01306611585},{"$error":"#DIV/0!"},435181.00793812837,144153.99487201252,538808.91971027735,247781.9066441615,664404.49541739898,373377.48235128314]
[12,291027.01306611585,7.2499999999999995E-2,2,null,21481.886131650535,312508.89919776638,null,-312508.89919776638,{"$error":"#DIV/0!"},443884.62809689093,131375.72889912454,560361.2764986885,247852.37730092212,704268.76514244301,391759.86594467663]
[13,312508.89919776638,7.2499999999999995E-2,2,null,23067.551417190116,335576.4506149565,null,-335576.4506149565,{"$error":"#DIV/0!"},452762.32065882877,117185.87004387227,582775.72755863611,247199.27694367961,746524.89105098962,410948.44043603312]
[14,335576.4506149565,7.2499999999999995E-2,2,null,24770.261099220545,360346.71171417704,null,-360346.71171417704,{"$error":"#DIV/0!"},461817.56707200536,101470.85535782832,606086.75666098157,245740.04494680453,791316.38451404904,430969.672799872]
[15,360346.71171417704,7.2499999999999995E-2,2,null,26598.654700139712,386945.36641431676,388656,1710.6335856832447,4.4014078920259683E-3,471053.91841344547,84108.551999128715,630330.22692742082,243384.86051310407,838795.36758489208,451850.00117057533]
[]
[]
["AF Portion"]
["Year","Jan 1 Cost","Pay Periods","Yearly Payments",null,null,null,null,null,null,null,null,"Interest Rate","Int. Accum. Factor","Yearly Interest","Accumulated Cost"]
[0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C20","v":8.1500000000000003E-2},null,0,{"$f":"B10","v":12096}]
[1,{"$f":"P40","v":12096},11,{"$f":"IF(VLOOKUP(A41,$A$66:$N$81,14,FALSE)>0,VLOOKUP(A41,$A$66:$N$81,14,FALSE),0)","v":1881},null,{"$f":"B41-D41","v":10215},{"$f":"F41+G21","v":156570.57204443752},null,null,null,{"$f":"146387-G41","v":-10183.572044437518},null,8.1500000000000003E-2,{"$f":"IF($L$1=1,1,IF($L$1=2,2,IF($L$1=3,4,IF($L$1=4,12,0))))","v":2},{"$f":"P40-(((1+(M41/N41))^N41)*(B41-D41))","v":1031.5148540624996},{"$f":"P40-O41","v":11064.4851459375}]
[2,{"$f":"F41","v":10215},12,2052,null,8163,165218.75987676374,null,null,null,{"$f":"157162-G42","v":-8056.7598767637392},null,8.6499999999999994E-2,2,2180.1162442500008,8884.3689016874996]
[3,8163,12,2052,null,6111,174812.52932668827,null,null,null,{"$f":"168893-G43","v":-5919.5293266882654},null,8.6499999999999994E-2,2,2233.33639425,6651.0325074374996]
[4,6111,12,2052,null,4059,185001.05955986239,null,null,null,{"$f":"181246-G44","v":-3755.0595598623913},null,8.4000000000000005E-2,2,2243.9164314374984,4407.1160760000012]
[5,4059,12,2052,null,2007,195773.65753851907,null,null,null,{"$f":"194205-G45","v":-1568.6575385190663},null,8.1500000000000003E-2,2,2233.2128270625012,2173.9032489374999]
[6,2007,12,2052,null,-45,207114.23827848659,null,null,null,{"$f":"207748-G46","v":633.7617215134087},null,7.9000000000000001E-2,2,2222.5284601875001,-48.62521125000012]
[7,-45,12,2052,null,-2097,219001.02671559461,null,null,null,{"$f":"221845-G47","v":2843.9732844053942},null,7.6499999999999999E-2,2,2211.8633308124995,-2260.4885420624996]
[8,-2097,12,2052,null,-4149,231406.30670312222,null,null,null,{"$f":"236458-G48","v":5051.6932968777837},null,7.3999999999999996E-2,2,2201.2174389374995,-4461.7059809999992]
[9,-4149,12,513,null,-4662,247729.73422025063,null,null,null,{"$f":"253507-G49","v":5777.2657797493739},null,7.2499999999999995E-2,2,544.41517837500032,-5006.1211593749995]
[10,0,12,0,null,null,null,null,null,null,null,null,7.2499999999999995E-2,2,0,0]
[11,0,12,0,null,null,null,null,null,null,null,null,7.2499999999999995E-2,2,{"$f":"P50-(((1+(M51/N51))^N51)*(B51-D51))","v":0},{"$f":"P50-O51","v":0}]
[12,0,12,0,null,null,null,null,null,null,null,null,7.2499999999999995E-2,2,{"$f":"P51-(((1+(M52/N52))^N52)*(B52-D52))","v":0},{"$f":"P51-O52","v":0}]
[13,0,12,0,null,null,null,null,null,null,null,null,7.2499999999999995E-2,2,{"$f":"P52-(((1+(M53/N53))^N53)*(B53-D53))","v":0},{"$f":"P52-O53","v":0}]
[14,0,12,0,null,null,null,null,null,null,null,null,7.2499999999999995E-2,2,{"$f":"P53-(((1+(M54/N54))^N54)*(B54-D54))","v":0},{"$f":"P53-O54","v":0}]
[15,0,12,0,null,null,null,null,null,null,null,null,7.2499999999999995E-2,2,{"$f":"P54-(((1+(M55/N55))^N55)*(B55-D55))","v":0},{"$f":"P54-O55","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["Payments","Month"]
["Year",1,2,3,4,5,6,7,8,9,10,11,12]
[0]
[1,null,{"$f":"$B$12","v":171},{"$f":"$B$12","v":171},171,171,171,171,171,171,171,171,171,{"$f":"SUM(B67:M67)","v":1881}]
[2,{"$f":"$B$12","v":171},{"$f":"$B$12","v":171},171,171,171,171,171,171,171,171,171,171,2052]
[3,{"$f":"$B$12","v":171},171,171,171,171,171,171,171,171,171,171,171,2052]
[4,171,171,171,171,171,171,171,171,171,171,171,171,2052]
[5,171,171,171,171,171,171,171,171,171,171,171,171,2052]
[6,171,171,171,171,171,171,171,171,171,171,171,171,2052]
[7,171,171,171,171,171,171,171,171,171,171,171,171,2052]
[8,171,171,171,171,171,171,171,171,171,171,171,171,2052]
[9,171,171,171,null,null,null,null,null,null,null,null,null,513]
[10,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N67:N81)","v":16758}]

{"sheet":"HIP Value Calculator & AF","index":2,"n_rows":193,"n_cols":13,"rows_kept":193,"cut":false,"hidden":true,"merged":[[86,3,86,6],[86,7,86,10],[13,7,13,8],[13,9,13,10],[13,11,13,12],[33,7,33,8],[33,9,33,10],[33,11,33,12]]}
[{"$f":"CELL(\"filename\")","v":"S:\\Marketing\\REFERRED MARKETING\\2016\\Q1\\Financial Illustration\\FINAL\\[Financial Illustration_IA.xlsm]Income Advantage"},null,null,null,null,null,null,"Annual",2]
[null,null,null,null,null,null,null,"Semi Annual"]
[null,null,null,null,null,null,null,"Qtrly"]
[null,null,null,null,null,null,null,"Mthly"]
[]
[{"$f":"CELL(\"filename\")","v":"S:\\Marketing\\REFERRED MARKETING\\2016\\Q1\\Financial Illustration\\FINAL\\[Financial Illustration_IA.xlsm]Income Advantage"}]
["Estimated Fair Market Value of Home",null,350000]
["CHIP Maximum",null,124904]
["Interest Rate ",null,8.1500000000000003E-2]
["Reset Date"]
["Payment Periods",null,98]
["Interest Accumulation"]
[]
[null,null,null,null,null,null,null,0.06,null,0.04,null,0.02]
["HIP Value",null,null,null,null,null,null,"Home","Remaining","Home","Remaining","Home","Remaining"]
["Year",null,"Jan 1 Cost","Interest Rate","Int. Accum. Factor","Yearly Interest","Accumulated Cost","Value","Home Equity","Value","Home Equity","Value","Home Equity"]
[0,null,null,{"$f":"C9","v":8.1500000000000003E-2},null,0,{"$f":"C8","v":124904},{"$f":"C7","v":350000},{"$f":"H17-$G17","v":225096},{"$f":"C7","v":350000},{"$f":"J17-$G17","v":225096},{"$f":"C7","v":350000},{"$f":"L17-$G17","v":225096}]
[1,null,{"$f":"G17","v":124904},{"$f":"D17","v":8.1500000000000003E-2},{"$f":"IF($I$1=1,1,IF($I$1=2,2,IF($I$1=3,4,IF($I$1=4,12,0))))","v":2},{"$f":"(((1+(D18/E18))^E18)*C18)-G17","v":10387.086898500012},{"$f":"G17+F18","v":135291.08689850001},{"$f":"H17*(1+$H$14)","v":371000},{"$f":"H18-$G18","v":235708.91310149999},{"$f":"J17*(1+$J$14)","v":364000},228708.91310149999,{"$f":"L17*(1+$L$14)","v":357000},221708.91310149999]
[2,null,135291.08689850001,8.6499999999999994E-2,2,11955.749450456817,{"$f":"G18+F19","v":147246.83634895683},393260,246013.16365104317,378560,231313.16365104317,364140,216893.16365104317]
[3,null,147246.83634895683,8.6499999999999994E-2,2,13012.285754502751,160259.12210345958,416855.60000000003,256596.47789654045,393702.40000000002,233443.27789654044,{"$f":"L19*(1+$L$14)","v":371422.8},211163.67789654041]
[4,null,160259.12210345958,8.4000000000000005E-2,2,{"$f":"(((1+(D21/E21))^E21)*C21)-G20","v":13744.463348081132},174003.58545154071,441866.93600000005,267863.35054845933,409450.49600000004,235446.91054845933,378851.25599999999,204847.67054845928]
[5,null,174003.58545154071,8.1500000000000003E-2,2,14470.236043166951,188473.82149470766,468378.95216000004,279905.13066529238,425828.51584000007,237354.6943452924,386428.28112,197954.45962529234]
[6,null,188473.82149470766,7.9000000000000001E-2,2,15183.498178069072,203657.31967277674,496481.68928960006,292824.36961682333,442861.65647360007,239204.33680082334,394156.84674240003,190499.52706962329]
[7,null,203657.31967277674,7.6499999999999999E-2,2,15877.748342231149,219535.06801500788,526270.59064697614,306735.52263196826,460576.12273254409,241041.0547175362,402039.98367724806,182504.91566224018]
[8,null,219535.06801500788,7.3999999999999996E-2,2,16546.138541223074,236081.20655623096,557846.82608579472,321765.61952956376,478999.16764184588,242917.96108561492,410080.783350793,173999.57679456205]
[9,null,236081.20655623096,7.2499999999999995E-2,2,17426.112935817015,253507.31949204797,591317.63565094245,337810.31615889445,498159.13434751972,244651.81485547175,418282.3990178089,164775.07952576093]
[10,null,253507.31949204797,7.2499999999999995E-2,2,18712.405125193443,272219.72461724142,626796.693789999,354576.96917275758,518085.49972142052,245865.77510417911,426648.04699816508,154428.32238092367]
[11,null,272219.72461724142,7.2499999999999995E-2,2,20093.643766629801,292313.36838387122,664404.49541739898,372091.12703352777,538808.91971027735,246495.55132640613,435181.00793812837,142867.63955425716]
[12,null,292313.36838387122,7.2499999999999995E-2,2,21576.837243472575,313890.20562734379,704268.76514244301,390378.55951509922,560361.2764986885,246471.07087134471,443884.62809689093,129994.42246954713]
[13,null,313890.20562734379,7.2499999999999995E-2,2,23169.511256314581,337059.71688365837,746524.89105098962,409465.17416733125,582775.72755863611,245716.01067497773,452762.32065882877,115702.6037751704]
[14,null,337059.71688365837,7.2499999999999995E-2,2,24879.747008282633,361939.46389194101,791316.38451404904,429376.92062210804,606086.75666098157,244147.29276904056,461817.56707200536,99878.103180064354]
[15,null,361939.46389194101,7.2499999999999995E-2,2,26716.222208936175,388655.68610087718,838795.36758489208,450139.6814840149,630330.22692742082,241674.54082654364,471053.91841344547,{"$f":"L32-$G32","v":82398.232312568289}]
[]
[null,null,null,null,null,null,null,0.06,null,0.04,null,0.02]
["CHIP Value",null,null,null,null,null,null,"Home","Remaining","Home","Remaining","Home","Remaining"]
["Year",null,"Jan 1 Cost","Interest Rate","Int. Accum. Factor","Yearly Interest","Accumulated Cost","Value","Home Equity","Value","Home Equity","Value","Home Equity"]
[0,null,null,{"$f":"D17","v":8.1500000000000003E-2},null,null,137000,{"$f":"H17","v":350000},{"$f":"H37-$G37","v":213000},{"$f":"J17","v":350000},{"$f":"J37-$G37","v":213000},{"$f":"L17","v":350000},{"$f":"L37-$G37","v":213000}]
[1,null,{"$f":"G37","v":137000},{"$f":"D18","v":8.1500000000000003E-2},{"$f":"IF($I$1=1,1,IF($I$1=2,2,IF($I$1=3,4,IF($I$1=4,12,0))))","v":2},null,146387,{"$f":"H37*(1+$H$14)","v":371000},{"$f":"H38-$G38","v":224613},{"$f":"J37*(1+$J$14)","v":364000},{"$f":"J38-$G38","v":217613},{"$f":"L37*(1+$L$14)","v":357000},210613]
[2,null,{"$f":"G38","v":146387},8.6499999999999994E-2,2,null,157162,393260,{"$f":"H39-$G39","v":236098},378560,{"$f":"J39-$G39","v":221398},364140,206978]
[3,null,157162,8.6499999999999994E-2,2,null,168893,416855.60000000003,{"$f":"H40-$G40","v":247962.60000000003},393702.40000000002,224809.40000000002,371422.8,202529.8]
[4,null,168893,8.4000000000000005E-2,2,null,181246,441866.93600000005,260620.93600000005,409450.49600000004,228204.49600000004,378851.25599999999,197605.25599999999]
[5,null,181246,8.1500000000000003E-2,2,null,194205,468378.95216000004,{"$f":"H42-$G42","v":274173.95216000004},425828.51584000007,{"$f":"J42-$G42","v":231623.51584000007},386428.28112,192223.28112]
[6,null,194205,7.9000000000000001E-2,2,null,207748,496481.68928960006,288733.68928960006,442861.65647360007,235113.65647360007,394156.84674240003,186408.84674240003]
[7,null,207748,7.6499999999999999E-2,2,null,221845,526270.59064697614,304425.59064697614,460576.12273254409,238731.12273254409,402039.98367724806,180194.98367724806]
[8,null,221845,7.3999999999999996E-2,2,null,236458,557846.82608579472,321388.82608579472,478999.16764184588,242541.16764184588,410080.783350793,173622.783350793]
[9,null,236458,7.2499999999999995E-2,2,null,253507,591317.63565094245,337810.63565094245,498159.13434751972,244652.13434751972,418282.3990178089,164775.3990178089]
[10,null,253507,7.2499999999999995E-2,2,null,272220,626796.693789999,354576.693789999,518085.49972142052,245865.49972142052,426648.04699816508,154428.04699816508]
[11,null,272220,7.2499999999999995E-2,2,{"$f":"G48-C48","v":-272220},null,664404.49541739898,664404.49541739898,538808.91971027735,538808.91971027735,435181.00793812837,435181.00793812837]
[12,null,0,7.2499999999999995E-2,2,{"$f":"G49-C49","v":0},null,704268.76514244301,704268.76514244301,560361.2764986885,560361.2764986885,443884.62809689093,443884.62809689093]
[13,null,0,7.2499999999999995E-2,2,{"$f":"G50-C50","v":0},null,746524.89105098962,746524.89105098962,582775.72755863611,582775.72755863611,452762.32065882877,452762.32065882877]
[14,null,0,7.2499999999999995E-2,2,{"$f":"G51-C51","v":0},null,791316.38451404904,791316.38451404904,606086.75666098157,606086.75666098157,461817.56707200536,461817.56707200536]
[15,null,null,7.2499999999999995E-2,2,null,388656,838795.36758489208,450139.36758489208,630330.22692742082,241674.22692742082,471053.91841344547,82397.91841344547]
[]
[]
["Payback of AF"]
["Year",null,"AF Principle Remaining","Interest Rate","Int. Accum. Factor","Yearly Interest","Payment Periods","Monthly Payments","Yearly Payments","Interest Eligible Payments"]
[0,null,{"$f":"G37-G17","v":12096},{"$f":"D37","v":8.1500000000000003E-2}]
[1,null,11095.913101499988,8.1500000000000003E-2,{"$f":"IF($I$1=1,1,IF($I$1=2,2,IF($I$1=3,4,IF($I$1=4,12,0))))","v":2},{"$f":"(((1+(D58/E58))^E58)*(C57-J58))-(C57-J58)","v":934.80788306249997},{"$f":"IF(C11>11,11,C11)","v":11},171,{"$f":"G58*H58","v":1881},{"$f":"H58*5","v":855}]
[2,null,9915.1636510431708,8.6499999999999994E-2,2,{"$f":"(((1+(D59/E59))^E59)*(C58-J59))-(C58-J59)","v":889.88388510567347},{"$f":"IF($C$11>(G58+12),12,($C$11-G58))","v":12},{"$f":"H58","v":171},{"$f":"G59*H59","v":2052},{"$f":"I59/2","v":1026}]
[3,null,8633.8778965404199,8.6499999999999994E-2,2,{"$f":"(((1+(D60/E60))^E60)*(C59-J60))-(C59-J60)","v":785.54039199723775},{"$f":"IF($C$11>(SUM($G$58:G59)+12),12,($C$11-SUM($G$58:G59)))","v":12},{"$f":"H59","v":171},2052,1026]
[4,null,7242.4145484592882,8.4000000000000005E-2,2,{"$f":"(((1+(D61/E61))^E61)*(C60-J61))-(C60-J61)","v":652.48203991889386},{"$f":"IF($C$11>(SUM($G$58:G60)+12),12,($C$11-SUM($G$58:G60)))","v":12},171,2052,1026]
[5,null,5731.1785052923369,8.1500000000000003E-2,2,516.96053058305824,{"$f":"IF($C$11>(SUM($G$58:G61)+12),12,($C$11-SUM($G$58:G61)))","v":12},171,{"$f":"G62*H62","v":2052},1026]
[6,null,4090.6803272232646,7.9000000000000001E-2,2,379.05035668097844,{"$f":"IF($C$11>(SUM($G$58:G62)+12),12,($C$11-SUM($G$58:G62)))","v":12},171,2052,1026]
[7,null,2309.9319849921158,7.6499999999999999E-2,2,{"$f":"(((1+(D64/E64))^E64)*(C63-J64))-(C63-J64)","v":238.93186389382754},{"$f":"IF($C$11>(SUM($G$58:G63)+12),12,($C$11-SUM($G$58:G63)))","v":12},171,2052,1026]
[8,null,376.79344376904191,7.3999999999999996E-2,2,96.768669776870411,{"$f":"IF($C$11>(SUM($G$58:G64)+12),12,($C$11-SUM($G$58:G64)))","v":12},171,2052,1026]
[9,null,-0.31949204797274433,7.2499999999999995E-2,2,{"$f":"(((1+(D66/E66))^E66)*(C65-J66))-(C65-J66)","v":8.879347776708272},{"$f":"IF($C$11>(SUM($G$58:G65)+12),12,($C$11-SUM($G$58:G65)))","v":3},171,513,256.5]
[10,null,0.27538275858387351,7.2499999999999995E-2,2,null,{"$f":"IF($C$11>(SUM($G$58:G66)+12),12,($C$11-SUM($G$58:G66)))","v":0}]
[11,null,-292313.36838387122,7.2499999999999995E-2,2,null,{"$f":"IF($C$11>(SUM($G$58:G67)+12),12,($C$11-SUM($G$58:G67)))","v":0}]
[12,null,-313890.20562734379,7.2499999999999995E-2,2,null,{"$f":"IF($C$11>(SUM($G$58:G68)+12),12,($C$11-SUM($G$58:G68)))","v":0}]
[13,null,-337059.71688365837,7.2499999999999995E-2,2,null,{"$f":"IF($C$11>(SUM($G$58:G69)+12),12,($C$11-SUM($G$58:G69)))","v":0}]
[14,null,-361939.46389194101,7.2499999999999995E-2,2,null,{"$f":"IF($C$11>(SUM($G$58:G70)+12),12,($C$11-SUM($G$58:G70)))","v":0}]
[15,null,0.3138991228188388,7.2499999999999995E-2,2,null,{"$f":"IF($C$11>(SUM($G$58:G71)+12),12,($C$11-SUM($G$58:G71)))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rate",8.5999999999999993E-2,null,"Additional Finance Portion",null,null,null,"HIP Max Portion"]
["Principle",178275,"Month","AF Interest","Remaining","Accumulated","Accum Interest","Payments","Interest","Remaining","Accum Interest"]
["Value after Year 1",{"$f":"(B88*(1+(B87/2))^2)","v":193936.28047499998},1,null,{"$f":"B93","v":18105},{"$f":"E89","v":18105},{"$f":"D89","v":0},0,{"$f":"B88*(B87/12)","v":1277.6374999999998},{"$f":"I89+B88","v":179552.63750000001},{"$f":"I89","v":1277.6374999999998}]
["Interest per Month",{"$f":"(B89-B88)/12","v":1305.1067062499981},2,null,{"$f":"F89-$B$94","v":17850},{"$f":"E90","v":17850},{"$f":"D90+G89","v":0},0,{"$f":"J89*($B$87/12)","v":1286.7939020833333},{"$f":"I90+J89","v":180839.43140208334},{"$f":"I90+K89","v":2564.4314020833331}]
[null,null,3,null,17595,{"$f":"E91","v":17595},{"$f":"D91+G90","v":0},0,1296.0159250482639,{"$f":"I91+J90","v":182135.44732713161},{"$f":"I91+K90","v":3860.4473271315969}]
["AF Portion",24552,4,null,17340,17340,0,0,1305.3040391777763,183440.75136630939,5165.7513663093732]
["Total AF Payment",{"$f":"B94*B95","v":18105},5,null,17085,17085,0,0,1314.6587181252171,184755.41008443461,6480.4100844345903]
["Monthly Payment",255,6,null,16830,16830,0,0,1324.080438938448,186079.49052337307,7804.4905233730387]
["Payment Periods",71,7,null,16575,16575,0,0,1333.5696820841736,187413.06020545724,9138.0602054572119]
[null,null,8,null,16320,16320,0,0,1343.1269314724434,188756.18713692969,10481.187136929655]
[null,null,9,null,16065,16065,0,0,1352.7526744813292,190108.93981141102,11833.939811410984]
[null,null,10,null,15810,15810,0,0,1362.4474019817787,191471.38721339279,13196.387213392763]
[null,null,11,null,15555,15555,0,0,1372.2116083626481,192843.59882175544,14568.598821755411]
[null,null,12,null,15300,15300,0,0,1382.0457915559139,194225.64461331136,15950.644613311326]
[null,null,13,null,{"$f":"F100","v":15300},15300,0,0,1391.9504530620645,195617.59506637344,17342.595066373389]
[null,null,14,null,{"$f":"F101","v":15300},15300,0,0,1401.9260979756762,197019.52116434911,18744.521164349066]
[null,null,15,null,15300,15300,0,0,1411.9732350111685,198431.49439936026,20156.494399360236]
[null,null,16,null,15300,15300,0,0,1422.0923765287484,199853.58677588901,21578.586775888984]
[null,null,17,null,15300,15300,0,0,1432.2840385605377,201285.87081444956,23010.870814449521]
[null,null,18,null,15300,15300,0,0,1442.5487408368883,202728.41955528644,24453.419555286411]
[null,null,19,null,15300,15300,0,0,1452.8870068128861,204181.30656209931,25906.306562099297]
[null,null,20,null,15300,15300,0,0,1463.2993636950448,205644.60592579437,27369.605925794342]
[null,null,21,null,15300,15300,0,0,1473.7863424681927,207118.39226826257,28843.392268262534]
[null,null,22,null,15300,15300,0,0,1484.3484779225482,208602.74074618513,30327.740746185082]
[null,null,23,null,15300,15300,0,0,1494.9863086809933,210097.72705486612,31822.727054866074]
[null,null,24,null,15300,15300,0,0,1505.7003772265402,211603.42743209266,33328.427432092612]
[null,null,25,null,15300,15300,0,0,1516.4912299299972,213119.91866202265,34844.91866202261]
[null,null,26,null,15300,15300,0,0,1527.3594170778288,214647.27807910048,36372.278079100441]
[null,null,27,null,15300,15300,0,0,1538.3054929002199,216185.5835720007,37910.583572000658]
[null,null,28,null,15300,15300,0,0,1549.3300155993381,217734.91358760005,39459.913587599993]
[null,null,29,null,15300,15300,0,0,1560.4335473778001,219295.34713497784,41020.34713497779]
[null,null,30,null,15300,15300,0,0,1571.616654467341,220866.96378944517,42591.96378944513]
[null,null,31,null,15300,15300,0,0,1582.8799071576902,222449.84369660285,44174.843696602817]
[null,null,32,null,15300,15300,0,0,1594.2238798256535,224044.0675764285,45769.067576428468]
[null,null,33,null,15300,15300,0,0,1605.649150964404,225649.71672739289,47374.716727392872]
[null,null,34,null,15300,15300,0,0,{"$f":"J121*($B$87/12)","v":1617.1563032129823},227266.87303060587,48991.873030605857]
[null,null,35,null,15300,15300,0,0,1628.7459233860086,228895.61895399189,50620.618953991863]
[null,null,36,null,15300,15300,0,0,1640.4186025036083,230536.03755649549,52261.037556495474]
[null,null,37,null,15300,15300,0,0,1652.1749358215509,232188.21249231705,53913.212492317027]
[null,null,38,null,15300,15300,0,0,1664.0155228616054,233852.22801517864,55577.228015178633]
[null,null,39,null,15300,15300,0,0,1675.9409674421133,235528.16898262076,57253.168982620744]
[null,null,40,null,15300,15300,0,0,1687.9518777087819,237216.12086032954,58941.120860329524]
[null,null,41,null,15300,15300,0,0,1700.0488661656948,238916.16972649522,60641.169726495216]
[null,null,42,null,15300,15300,0,0,1712.232549706549,240628.40227620178,62353.402276201763]
[null,null,43,null,15300,15300,0,0,1724.5035496461126,242352.90582584791,64077.905825847876]
[null,null,44,null,15300,15300,0,0,1736.8624917519098,244089.76831759981,65814.768317599781]
[null,null,45,null,15300,15300,0,0,1749.3100062761318,245839.07832387593,67564.078323875918]
[null,null,46,null,15300,15300,0,0,1761.8467279877773,247600.92505186371,69325.925051863698]
[null,null,47,null,15300,15300,0,0,1774.473296205023,249375.39834806873,71100.398348068717]
[null,null,48,null,15300,15300,0,0,1787.1903548278258,251162.58870289655,72887.588702896537]
[null,null,49,null,15300,15300,0,0,1799.9985523707585,252962.58725526731,74687.587255267295]
[null,null,50,null,15300,15300,0,0,1812.8985419960823,254775.48579726339,76500.485797263376]
[null,null,51,null,15300,15300,0,0,1825.890981547054,256601.37677881043,78326.376778810431]
[null,null,52,null,15300,15300,0,0,1838.9765335814745,258440.3533123919,80165.353312391904]
[null,null,53,null,15300,15300,0,0,1852.1558654054752,260292.50917779739,82017.509177797387]
[null,null,54,null,15300,15300,0,0,1865.4296491075477,262157.93882690492,83882.938826904938]
[null,null,55,null,15300,15300,0,0,1878.7985615928185,264036.73738849774,85761.737388497757]
[null,null,56,null,15300,15300,0,0,1892.263284617567,265929.00067311531,87654.000673115326]
[null,null,57,null,15300,15300,0,0,1905.8245048239928,267834.82517793932,89559.825177939318]
[null,null,58,null,15300,15300,0,0,1919.4829137752315,269754.30809171457,91479.308091714556]
[null,null,59,null,15300,15300,0,0,1933.2392079906208,271687.54729970521,93412.547299705184]
[null,null,60,null,15300,15300,0,0,1947.0940889812205,273634.64138868643,95359.641388686403]
[null,null,61,null,15300,15300,0,0,1961.0482632855858,275595.68965197203,97320.689651971988]
[null,null,62,null,15300,15300,0,0,1975.1024425057992,277570.79209447786,99295.792094477787]
[null,null,63,null,15300,15300,0,0,1989.2573433437578,279560.04943782161,101285.04943782155]
[null,null,64,null,15300,15300,0,0,2003.5136876377212,281563.5631254593,103288.56312545927]
[null,null,65,null,15300,15300,0,0,2017.8722023991247,283581.43532785843,105306.4353278584]
[null,null,66,null,15300,15300,0,0,{"$f":"J153*($B$87/12)","v":2032.3336198496518},285613.76894770807,107338.76894770806]
[null,null,67,null,15300,{"$f":"E155","v":15300},{"$f":"D155+G154","v":0},0,2046.8986774585742,{"$f":"I155+J154","v":287660.66762516665},{"$f":"I155+K154","v":109385.66762516664}]
[null,null,68,null,15300,15300,0,0,2061.568117980361,289722.23574314703,111447.235743147]
[null,null,69,null,15300,15300,0,0,2076.3426894925533,291798.5784326396,113523.57843263955]
[null,null,70,null,15300,15300,0,0,2091.2231454339167,293889.80157807353,115614.80157807347]
[null,null,71,null,15300,15300,0,0,2106.2102446428598,295996.01182271639,117721.01182271633]
[null,null,72,null,15300,15300,0,0,2121.3047513961337,298117.31657411251,119842.31657411247]
[null,null,73,null,15300,15300,0,0,2136.5074354478061,300253.82400956034,121978.82400956028]
[null,null,74,null,15300,15300,0,0,2151.8190720685157,302405.64308162883,124130.64308162879]
[null,null,75,null,15300,15300,0,0,2167.2404420850062,304572.88352371386,126297.8835237138]
[null,null,76,null,15300,15300,0,0,2182.772331919949,306755.65585563378,128480.65585563374]
[null,null,77,null,15300,15300,0,0,2198.4155336320418,308954.07138926582,130679.07138926578]
[null,null,78,null,{"$f":"F165","v":15300},15300,0,0,2214.1708449564048,311168.24223422224,132893.24223422218]
[null,null,79,null,15300,15300,0,0,2230.0390693452591,313398.28130356752,135123.28130356743]
[null,null,80,null,15300,15300,0,0,2246.0210160089005,315644.30231957644,137369.30231957632]
[null,null,81,null,15300,15300,0,0,2262.1174999569644,317906.41981953342,139631.4198195333]
[null,null,82,null,15300,15300,0,0,2278.3293420399891,320184.74916157342,141909.7491615733]
[null,null,83,null,15300,15300,0,0,2294.6573689912757,322479.40653056471,144204.40653056456]
[null,null,84,null,15300,15300,0,0,2311.102413469047,324790.50894403376,146515.50894403362]
[null,null,85,null,15300,15300,0,0,2327.6653140989083,327118.1742581327,148843.17425813252]
[null,null,86,null,15300,15300,0,0,2344.3469155166172,329462.52117364929,151187.52117364915]
[null,null,87,null,15300,15300,0,0,2361.148068411153,331823.66924206045,153548.66924206031]
[null,null,88,null,15300,15300,0,0,2378.0696295680996,334201.73887162853,155926.73887162842]
[null,null,89,null,15300,15300,0,0,2395.1124619133375,336596.85133354185,158321.85133354177]
[null,null,90,null,15300,15300,0,0,2412.2774345570497,339009.12876809889,160734.1287680988]
[null,null,91,null,15300,15300,0,0,2429.5654228380417,341438.69419093692,163163.69419093683]
[null,null,92,null,15300,15300,0,0,2446.9773083683808,343885.67149930529,165610.6714993052]
[null,null,93,null,15300,15300,0,0,2464.5139790783542,346350.18547838362,168075.18547838356]
[null,null,94,null,15300,15300,0,0,2482.1763292617488,348832.36180764536,170557.3618076453]
[null,null,95,null,15300,15300,0,0,2499.9652596214582,351332.3270672668,173057.32706726674]
[null,null,96,null,15300,15300,0,0,2517.8816773154117,353850.2087445822,175575.20874458217]
[null,null,97,null,15300,15300,0,0,2535.9264960028386,356386.13524058502,178111.13524058502]
[null,null,98,null,15300,15300,0,0,{"$f":"J185*($B$87/12)","v":2554.1006358908589},358940.23587647587,180665.23587647587]
[null,null,99,null,15300,15300,0,0,2572.4050237814099,361512.64090025728,183237.64090025728]
[null,null,100,null,15300,15300,0,0,2590.8405931185102,364103.48149337579,185828.48149337579]
[null,null,101,null,15300,15300,0,0,2609.4082840358597,366712.88977741165,188437.88977741165]
[null,null,102,null,15300,15300,0,0,2628.1090434047833,369340.99882081646,191065.99882081643]
[null,null,103,null,15300,15300,0,0,2646.9438248825177,371987.94264569896,193712.94264569896]
[null,null,104,null,15300,15300,0,0,2665.9135889608424,374653.85623465979,196378.85623465979]
[null,null,105,null,15300,15300,0,0,2685.0193030150617,377338.87553767487,199063.87553767484]