{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Computation","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Data","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,2],[10,0,10,2],[14,0,14,2],[0,0,0,2],[1,0,1,2],[12,0,12,2],[13,0,13,2],[11,0,11,2]]}
["National Housing Bank"]
["Subsidy Calculator for Pradhan Mantri Awas Yojana – Credit Linked Subsidy Scheme (MIG I)"]
["First Disbursement Date","2017-01-01","Date should be on or after 01-jan-2017"]
["Current Disbursement Date (for which subsidy claimed)","2017-01-01","Date should  be on or after first disbursement date"]
["Loan Tenure (in months)",240,"Numeric Integer only"]
["Current Disbursement Installment (in Rs.)",900000,"Numeric Integer only"]
["Amount Disbursed before this installment (in Rs.)",0,"Numeric Integer only"]
["Applied Interest Rate for subsidy calculation (in % p.a)",4,"NO input data"]
["Subsidy Amount",235068.07794235193]
[]
["Assumptions:"]
["a. Interest for calculation of subsidy is arrived at by applying interest @ 4% p.a. on the disbursed amount and on monthly rest basis"]
["b. Subsidy is calculated for a maximum tenure of 240 months (20 years) from first disbursement."]
["c. NPV is calculated at the discount rate of 9% and on monthly rest basis."]
["d. Interest Subsidy is calculated for eligible disbursement amount  upto first Rs 9 lakh of loan amount."]
["e. Paisa is rounded off to the nearest rupee in the total"]

{"sheet":"Computation","index":1,"n_rows":243,"n_cols":14,"rows_kept":243,"cut":false,"hidden":false,"merged":[]}
["Parameters",null,"Loan Amount",{"$f":"IF((Data!B7+Data!B6)>900000,900000-Data!B7,Data!B6)","v":900000},"Loan Tenure",{"$f":"IF(Data!B5>240,240,Data!B5)","v":240},"Cur Inst Tenure",{"$f":"IF(Data!B4=\"\",0, F1-((YEAR(Data!B4)-YEAR(Data!B3))*12+MONTH(Data!B4)-MONTH(Data!B3)))","v":240},"Int Rate",{"$f":"IF(Data!B8>4,4,Data!B8)","v":4},"r ",{"$f":"J1/1200","v":3.3333333333333335E-3},"(1+r)^n-1",{"$f":"((1+L1)^H1)-1","v":1.2225820869664372}]
[null,"BALANCE","EMI","INTEREST","principal repayment","CL BALANCE","NPV(By Formula)",null,null,"EMI",{"$f":"IF($N$1=0,0,($D$1*$L$1)*((1+$L$1)^$H$1)/$N$1)","v":5453.8229636946717}]
[1,{"$f":"D1","v":900000},{"$f":"K2","v":5453.8229636946717},{"$f":"B3*$J$1/(1200)","v":3000},{"$f":"C3-D3","v":2453.8229636946717},{"$f":"B3-E3","v":897546.17703630531},{"$f":"D3/POWER(1+9/1200,A3)","v":2977.6674937965258}]
[{"$f":"A3+1","v":2},{"$f":"IF(F3>0,F3,0)","v":897546.17703630531},{"$f":"IF(B4>0,C3,0)","v":5453.8229636946717},{"$f":"B4*$J$1/1200","v":2991.8205901210176},{"$f":"C4-D4","v":2462.002373573654},{"$f":"B4-E4","v":895084.1746627317},{"$f":"D4/POWER(1+9/1200,A4)","v":2947.4431492057874}]
[{"$f":"A4+1","v":3},{"$f":"IF(F4>0,F4,0)","v":895084.1746627317},{"$f":"IF(B5>0,C4,0)","v":5453.8229636946717},{"$f":"B5*$J$1/1200","v":2983.6139155424389},2470.2090481522328,892613.9656145795,2917.4771251510092]
[4,892613.9656145795,5453.8229636946717,2975.3798853819317,2478.44307831274,890135.52253626671,2887.7673608283039]
[5,890135.52253626671,5453.8229636946717,2967.1184084542224,2486.7045552404493,887648.81798102625,2858.3118113447431]
[6,887648.81798102625,5453.8229636946717,2958.8293932700876,2494.993570424584,885153.82441060164,2829.1084475975499]
[7,885153.82441060164,5453.8229636946717,2950.512748035339,2503.3102156593327,882650.51419494231,2800.1552561542148]
[8,882650.51419494231,5453.8229636946717,2942.1683806498077,2511.654583044864,880138.8596118975,2771.4502391334986]
[9,880138.8596118975,5453.8229636946717,2933.796198706325,2520.0267649883467,877618.83284690918,2742.991414087342]
[10,877618.83284690918,5453.8229636946717,2925.3961094896972,2528.4268542049745,875090.40599270421,2714.7768138836573,"Total NPV as per Manual Formula",{"$f":"SUM(G3:G242)","v":235068.07794235193}]
[11,875090.40599270421,5453.8229636946717,2916.9680199756808,2536.8549437189909,872553.55104898522,2686.8044865900083,"NPV by Excel Formula",{"$f":"NPV(9/1200,D3:D242)","v":235068.07794235231}]
[12,872553.55104898522,5453.8229636946717,2908.5118368299509,2545.3111268647208,870008.23992212047,2659.0724953581594]
[13,870008.23992212047,5453.8229636946717,2900.027466407068,2553.7954972876037,867454.44442483282,2631.5789183094962]
[14,867454.44442483282,5453.8229636946717,2891.5148147494428,2562.3081489452288,864892.13627588761,2604.3218484213107]
[15,864892.13627588761,5453.8229636946717,2882.973787586292,2570.8491761083797,862321.28709977923,2577.2993934139399]
[16,862321.28709977923,5453.8229636946717,2874.4042903325976,2579.4186733620741,859741.86842641712,2550.5096756387538]
[17,859741.86842641712,5453.8229636946717,2865.8062280880572,2588.0167356066145,857153.85169081052,2523.9508319669853]
[18,857153.85169081052,5453.8229636946717,2857.1795056360352,2596.6434580586365,854557.20823275193,2497.6210136794048]
[19,854557.20823275193,5453.8229636946717,2848.5240274425064,2605.2989362521653,851951.9092964998,2471.5183863568141]
[20,851951.9092964998,5453.8229636946717,2839.8396976549993,2613.9832660396723,849337.92603046016,2445.6411297713721]
[21,849337.92603046016,5453.8229636946717,2831.1264201015338,2622.6965435931379,846715.22948686697,2419.9874377787378]
[22,846715.22948686697,5453.8229636946717,2822.3840982895567,2631.4388654051149,844083.79062146181,2394.5555182110211]
[23,844083.79062146181,5453.8229636946717,2813.6126354048729,2640.2103282897988,841443.58029317204,2369.3435927705486]
[24,841443.58029317204,5453.8229636946717,2804.8119343105736,2649.011029384098,838794.56926378794,2344.3498969244174]
[25,838794.56926378794,5453.8229636946717,2795.9818975459598,2657.8410661487119,836136.72819763923,2319.5726797998514]
[26,836136.72819763923,5453.8229636946717,2787.1224273254643,2666.7005363692074,833470.02766127,2295.0102040803449]
[27,833470.02766127,5453.8229636946717,2778.2334255375667,2675.5895381571049,830794.43812311289,2270.6607459025849]
[28,830794.43812311289,5453.8229636946717,2769.3147937437097,2684.5081699509619,828109.92995316198,2246.5225947541512]
[29,828109.92995316198,5453.8229636946717,2760.3664331772065,2693.4565305174651,825416.47342264454,2222.594053371989]
[30,825416.47342264454,5453.8229636946717,2751.3882447421483,2702.4347189525233,822714.03870369203,2198.8734376416414]
[31,822714.03870369203,5453.8229636946717,2742.380129012307,2711.4428346823647,820002.59586900962,2175.3590764972469]
[32,820002.59586900962,5453.8229636946717,2733.341986230032,2720.4809774646396,817282.11489154503,2152.0493118222848]
[33,817282.11489154503,5453.8229636946717,2724.2737163051502,2729.5492473895215,814552.56564415549,2128.9424983510712]
[34,814552.56564415549,5453.8229636946717,2715.1752188138516,2738.64774488082,811813.91789927462,2106.0370035709948]
[35,811813.91789927462,5453.8229636946717,2706.0463929975822,2747.7765706970895,809066.14132857753,2083.3312076254952]
[36,809066.14132857753,5453.8229636946717,2696.8871377619253,2756.9358259327464,806309.20550264476,2060.8235032177613]
[37,806309.20550264476,5453.8229636946717,2687.6973516754824,2766.1256120191892,803543.07989062555,2038.5122955151644]
[38,803543.07989062555,5453.8229636946717,2678.476932968752,2775.3460307259197,800767.73385989969,2016.3960020544093]
[39,800767.73385989969,5453.8229636946717,2669.2257795329988,2784.5971841616729,797983.13667573803,1994.4730526473966]
[40,797983.13667573803,5453.8229636946717,2659.9437889191267,2793.8791747755449,795189.25750096247,1972.741889287799]
[41,795189.25750096247,5453.8229636946717,2650.6308583365417,2803.19210535813,792386.06539560435,1951.2009660583358]
[42,792386.06539560435,5453.8229636946717,2641.2868846520146,2812.5360790426571,789573.52931656165,1929.8487490387527]
[43,789573.52931656165,5453.8229636946717,2631.9117643885388,2821.9111993061329,786751.61811725551,1908.6837162144905]
[44,786751.61811725551,5453.8229636946717,2622.5053937241851,2831.3175699704866,783920.30054728501,1887.7043573860431]
[45,783920.30054728501,5453.8229636946717,2613.0676684909499,2840.7552952037217,781079.54525208124,1866.9091740789993]
[46,781079.54525208124,5453.8229636946717,2603.598484173604,2850.2244795210677,778229.3207725602,1846.2966794547613]
[47,778229.3207725602,5453.8229636946717,2594.0977359085341,2859.7252277861376,775369.59554477409,1825.8653982219384]
[48,775369.59554477409,5453.8229636946717,2584.5653184825801,2869.2576452120916,772500.33789956197,1805.6138665484045]
[49,772500.33789956197,5453.8229636946717,2575.0011263318734,2878.8218373627983,769621.51606219914,1785.5406319740234]
[50,769621.51606219914,5453.8229636946717,2565.4050535406636,2888.417910154008,766733.09815204516,1765.6442533240267]
[51,766733.09815204516,5453.8229636946717,2555.7769938401507,2898.045969854521,763835.05218219059,1745.923300623052]
[52,763835.05218219059,5453.8229636946717,2546.116840607302,2907.7061230873696,760927.34605910326,1726.3763550098179]
[53,760927.34605910326,5453.8229636946717,2536.4244868636774,2917.3984768309942,758009.94758227223,1707.0020086524557]
[54,758009.94758227223,5453.8229636946717,2526.699825274241,2927.1231384204307,755082.82444385183,1687.7988646644678]
[55,755082.82444385183,5453.8229636946717,2516.9427481461726,2936.8802155484991,752145.94422830339,1668.7655370213261]
[56,752145.94422830339,5453.8229636946717,2507.1531474276781,2946.6698162669936,749199.27441203641,1649.9006504776983]
[57,749199.27441203641,5453.8229636946717,2497.330914706788,2956.4920489878837,746242.78236304852,1631.2028404852954]
[58,746242.78236304852,5453.8229636946717,2487.4759412101616,2966.34702248451,743276.435340564,1612.6707531113432]
[59,743276.435340564,5453.8229636946717,2477.5881178018799,2976.2348458927918,740300.20049467124,1594.3030449576654]
[60,740300.20049467124,5453.8229636946717,2467.6673349822377,2986.155628712434,737314.04486595886,1576.0983830803771]
[61,737314.04486595886,5453.8229636946717,2457.7134828865296,2996.1094808081421,734317.93538515072,1558.0554449101853]
[62,734317.93538515072,5453.8229636946717,2447.7264512838356,3006.0965124108361,731311.83887273993,1540.1729181732874]
[63,731311.83887273993,5453.8229636946717,2437.7061295757999,3016.1168341188718,728295.72203862108,1522.4495008128738]
[64,728295.72203862108,5453.8229636946717,2427.6524067954037,3026.1705568992679,725269.55148172181,1504.8839009112114]
[65,725269.55148172181,5453.8229636946717,2417.5651716057396,3036.2577920889321,722233.2936896329,1487.4748366123231]
[66,722233.2936896329,5453.8229636946717,2407.4443122987764,{"$f":"C68-D68","v":3046.3786513958953},{"$f":"B68-E68","v":719186.915038237},{"$f":"D68/POWER(1+9/1200,A68)","v":1470.2210360452489}]
[{"$f":"A68+1","v":67},{"$f":"IF(F68>0,F68,0)","v":719186.915038237},{"$f":"IF(B69>0,C68,0)","v":5453.8229636946717},{"$f":"B69*$J$1/1200","v":2397.2897167941233},3056.5332469005484,716130.38179133646,1453.121237247884]
[68,716130.38179133646,5453.8229636946717,2387.101272637788,3066.7216910568836,713063.66010027961,1436.1741880913933]
[69,713063.66010027961,5453.8229636946717,2376.8788670009321,3076.9440966937395,709986.71600358584,1419.3786462051942]
[70,709986.71600358584,5453.8229636946717,2366.6223866786195,3087.2005770160522,706899.51542656973,1402.7333789025058]
[71,706899.51542656973,5453.8229636946717,2356.3317180885656,3097.4912456061061,703802.02418096364,1386.2371631064636]
[72,703802.02418096364,5453.8229636946717,2346.0067472698788,3107.8162164247929,700694.20796453883,1369.8887852767864]
[73,700694.20796453883,5453.8229636946717,2335.6473598817961,3118.1756038128756,697576.03236072592,1353.6870413369968]
[74,697576.03236072592,5453.8229636946717,2325.2534412024197,3128.569522492252,694447.46283823368,1337.6307366021958]
[75,694447.46283823368,5453.8229636946717,2314.8248761274458,3138.9980875672259,691308.4647506664,1321.7186857073789]
[76,691308.4647506664,5453.8229636946717,2304.3615491688879,3149.4614145257838,688159.00333614065,1305.9497125362909]
[77,688159.00333614065,5453.8229636946717,2293.8633444538023,3159.9596192408694,684999.04371689982,1290.3226501508243]
[78,684999.04371689982,5453.8229636946717,2283.3301457229995,3170.4928179716721,681828.5508989282,1274.8363407209422]
[79,681828.5508989282,5453.8229636946717,2272.7618363297606,3181.061127364911,678647.48977156333,1259.4896354551379]
[80,678647.48977156333,5453.8229636946717,2262.1582992385443,3191.6646644561274,675455.82510710717,1244.2813945314144]
[81,675455.82510710717,5453.8229636946717,2251.5194170236905,3202.3035466709812,672253.52156043623,1229.2104870287858]
[82,672253.52156043623,5453.8229636946717,2240.8450718681206,3212.9778918265511,669040.54366860969,1214.2757908592969]
[83,669040.54366860969,5453.8229636946717,2230.1351455620324,3223.6878181326392,665816.855850477,1199.4761927005568]
[84,665816.855850477,5453.8229636946717,2219.3895195015898,3234.4334441930819,662582.42240628391,1184.8105879287768]
[85,662582.42240628391,5453.8229636946717,2208.6080746876132,3245.2148890070584,659337.20751727687,1170.2778805523221]
[86,659337.20751727687,5453.8229636946717,2197.7906917242562,3256.0322719704154,656081.17524530645,1155.8769831457557]
[87,656081.17524530645,5453.8229636946717,2186.937250817688,3266.8857128769837,652814.28953242942,1141.6068167843894]
[88,652814.28953242942,5453.8229636946717,2176.0476317747648,3277.7753319199069,649536.51420050953,1127.4663109793219]
[89,649536.51420050953,5453.8229636946717,2165.1217140016984,3288.7012496929733,646247.81295081659,1113.4544036129701]
[90,646247.81295081659,5453.8229636946717,2154.1593765027219,3299.6635871919498,642948.14936362463,1099.5700408750899]
[91,642948.14936362463,5453.8229636946717,2143.1604978787486,3310.662465815923,639637.48689780873,1085.8121771992753]
[92,639637.48689780873,5453.8229636946717,2132.124956326029,3321.6980073686427,636315.78889044013,1072.1797751999395]
[93,636315.78889044013,5453.8229636946717,2121.0526296348003,3332.7703340598714,632983.0185563803,1058.6718056097732]
[94,632983.0185563803,5453.8229636946717,2109.9433951879341,3343.8795685067375,629639.13898787356,1045.2872472176716]
[95,629639.13898787356,5453.8229636946717,2098.7971299595783,3355.0258337350933,626284.11315413844,1032.0250868071355]
[96,626284.11315413844,5453.8229636946717,2087.613710513795,3366.2092531808767,622917.90390095755,1018.8843190951327]
[97,622917.90390095755,5453.8229636946717,2076.3930130031918,3377.4299506914799,619540.47395026602,1005.8639466714218]
[98,619540.47395026602,5453.8229636946717,2065.1349131675533,3388.6880505271183,616151.7858997389,992.96297993834003]
[99,616151.7858997389,5453.8229636946717,2053.839286332463,3399.9836773622087,612751.80222237669,980.18043705103867]
[100,612751.80222237669,5453.8229636946717,2042.5060074079222,3411.3169562867497,609340.48526608991,967.51534385817376]
[101,609340.48526608991,5453.8229636946717,2031.1349508869664,3422.6880128077055,605917.79725328216,954.96673384304381]
[102,605917.79725328216,5453.8229636946717,2019.7259908442738,3434.0969728503978,602483.70028043177,942.53364806517391]
[103,602483.70028043177,5453.8229636946717,2008.2790009347725,3445.5439627598989,599038.15631767188,930.2151351023391]
[104,599038.15631767188,5453.8229636946717,1996.7938543922396,3457.0291093024321,595581.12720836943,918.01025099302717]
[105,595581.12720836943,5453.8229636946717,1985.2704240278981,3468.5525396667736,592112.57466870267,905.9180591793355]
[106,592112.57466870267,5453.8229636946717,1973.7085822290089,3480.1143814656625,588632.46028723696,893.93763045030028]
[107,588632.46028723696,5453.8229636946717,1962.1082009574566,3491.7147627372151,585140.7455244998,882.06804288565354]
[108,585140.7455244998,5453.8229636946717,1950.4691517483327,3503.3538119463392,581637.39171255345,870.30838180000546]
[109,581637.39171255345,5453.8229636946717,1938.7913057085116,3515.0316579861601,578122.36005456734,858.65773968744782]
[110,578122.36005456734,5453.8229636946717,1927.0745335152244,3526.7484301794475,574595.61162438791,847.11521616657728]
[111,574595.61162438791,5453.8229636946717,1915.3187054146263,3538.5042582800452,571057.10736610787,835.67991792593455]
[112,571057.10736610787,5453.8229636946717,1903.5236912203595,3550.2992724743121,567506.8080936335,824.35095866985387]
[113,567506.8080936335,5453.8229636946717,1891.6893603121116,3562.1336033825601,563944.674490251,813.12745906472412]
[114,563944.674490251,5453.8229636946717,1879.81558163417,3574.0073820605016,560370.66710819048,802.00854668565557]
[115,560370.66710819048,5453.8229636946717,1867.9022236939682,3585.9207400007035,556784.74636818981,790.99335596354933]
[116,556784.74636818981,5453.8229636946717,1855.9491545606327,3597.8738091340392,553186.8725590558,780.0810281325671]
[117,553186.8725590558,5453.8229636946717,1843.9562418635194,3609.8667218311521,549577.00583722466,769.27071117800006]
[118,549577.00583722466,5453.8229636946717,1831.9233527907488,3621.8996109039226,545955.10622632073,758.56155978452784]
[119,545955.10622632073,5453.8229636946717,1819.8503540877357,3633.9726096069362,542321.13361671381,747.95273528487382]
[120,542321.13361671381,5453.8229636946717,1807.7371120557127,3646.085851638959,538675.04776507488,737.44340560884473]
[121,538675.04776507488,5453.8229636946717,1795.5834925502495,3658.2394711444222,535016.80829393049,727.03274523275763]
[122,535016.80829393049,5453.8229636946717,1783.3893609797683,3670.4336027149034,531346.37469121558,716.71993512924951]
[123,531346.37469121558,5453.8229636946717,1771.1545823040519,3682.6683813906197,527663.70630982495,706.50416271746496]
[124,527663.70630982495,5453.8229636946717,1758.8790210327497,3694.9439426619219,523968.76236716303,696.38462181362286]
[125,523968.76236716303,5453.8229636946717,1746.5625412238767,3707.2604224707948,520261.50194469222,686.36051258195607]
[126,520261.50194469222,5453.8229636946717,1734.2050064823075,3719.6179572123642,516541.88398747984,676.43104148602004]
[127,516541.88398747984,5453.8229636946717,1721.806279958266,3732.0166837364059,512809.86730374343,666.59542124037432]
[128,512809.86730374343,5453.8229636946717,1709.3662243458114,3744.4567393488605,509065.41056439455,656.85287076262728]
[129,509065.41056439455,5453.8229636946717,1696.8847018813151,3756.9382618133568,505308.47230258118,647.20261512584079]
[130,505308.47230258118,5453.8229636946717,1684.3615743419373,{"$f":"C132-D132","v":3769.4613893527344},{"$f":"B132-E132","v":501539.01091322844},{"$f":"D132/POWER(1+9/1200,A132)","v":637.64388551130116}]
[{"$f":"A132+1","v":131},{"$f":"IF(F132>0,F132,0)","v":501539.01091322844},{"$f":"IF(B133>0,C132,0)","v":5453.8229636946717},{"$f":"B133*$J$1/1200","v":1671.7967030440948},3782.0262606505767,497756.98465257784,628.17591916164292]
[132,497756.98465257784,5453.8229636946717,1659.189948841926,3794.6330148527459,493962.35163772508,618.79795933432877]
[133,493962.35163772508,5453.8229636946717,1646.5411721257503,3807.2817915689211,490155.06984615617,609.50925525548155]
[134,490155.06984615617,5453.8229636946717,1633.8502328205207,3819.9727308741512,486335.09711528203,600.30906207406565]
[135,486335.09711528203,5453.8229636946717,1621.1169903842733,3832.7059733103983,482502.39114197163,591.19664081641577]
[136,482502.39114197163,5453.8229636946717,1608.3413038065721,3845.4816598880998,478656.90948208352,582.1712583411088]
[137,478656.90948208352,5453.8229636946717,1595.5230316069451,3858.2999320877266,474798.6095499958,573.23218729417795]
[138,474798.6095499958,5453.8229636946717,1582.6620318333194,3871.1609318613523,470927.44861813443,564.37870606466618]
[139,470927.44861813443,5453.8229636946717,1569.7581620604481,3884.0648016342238,467043.38381650019,555.6100987405157]
[140,467043.38381650019,5453.8229636946717,1556.811279388334,3897.0116843063379,463146.37213219388,546.92565506479173]
[141,463146.37213219388,5453.8229636946717,1543.8212404406463,3910.0017232540254,459236.37040893984,538.32467039223764]
[142,459236.37040893984,5453.8229636946717,1530.7879013631327,3923.0350623315389,455313.33534660831,529.80644564615807]
[143,455313.33534660831,5453.8229636946717,1517.7111178220277,3936.1118458726442,451377.22350073565,521.37028727563154]
[144,451377.22350073565,5453.8229636946717,1504.5907450024522,3949.2322186922192,447427.99128204345,513.01550721304329]
[145,447427.99128204345,5453.8229636946717,1491.4266376068115,3962.39632608786,443465.59495595557,504.74142283194232]
[146,443465.59495595557,5453.8229636946717,1478.2186498531853,3975.6043138414861,439489.99064211408,496.54735690521659]
[147,439489.99064211408,5453.8229636946717,1464.9666354737135,3988.8563282209579,435501.1343138931,488.43263756358601]
[148,435501.1343138931,5453.8229636946717,1451.670447712977,4002.1525159816947,431498.9817979114,480.39659825440822]
[149,431498.9817979114,5453.8229636946717,1438.3299393263712,4015.4930243683002,427483.4887735431,472.43857770079813]
[150,427483.4887735431,5453.8229636946717,1424.9449625784771,4028.8780011161944,423454.61077242688,464.55791986105567]
[151,423454.61077242688,5453.8229636946717,1411.5153692414228,4042.3075944532488,419412.3031779736,456.75397388840258]
[152,419412.3031779736,5453.8229636946717,1398.0410105932453,4055.7819531014266,415356.52122487215,449.02609409102269]
[153,415356.52122487215,5453.8229636946717,1384.5217374162405,4069.3012262784314,411287.21999859373,441.37363989240561]
[154,411287.21999859373,5453.8229636946717,1370.9573999953125,4082.865563699359,407204.3544348944,433.79597579199179]
[155,407204.3544348944,5453.8229636946717,1357.3478481163147,4096.475115578357,403107.87931931607,426.2924713261142]
[156,403107.87931931607,5453.8229636946717,1343.6929310643868,4110.1300326302844,398997.74928668578,418.86250102923697]
[157,398997.74928668578,5453.8229636946717,1329.992497622286,4123.8304660723861,394873.91882061341,411.50544439548838]
[158,394873.91882061341,5453.8229636946717,1316.2463960687114,4137.5765676259598,390736.34225298744,404.2206858404835]
[159,390736.34225298744,5453.8229636946717,1302.4544741766249,4151.3684895180468,386584.97376346937,397.00761466343891]
[160,386584.97376346937,5453.8229636946717,1288.6165792115646,4165.2063844831073,382419.76737898629,389.865625009572]
[161,382419.76737898629,5453.8229636946717,1274.7325579299543,4179.0904057647176,378240.67697322159,382.79411583278699]
[162,378240.67697322159,5453.8229636946717,1260.8022565774054,4193.0207071172663,374047.65626610431,375.79249085864308]
[163,374047.65626610431,5453.8229636946717,1246.8255208870144,4206.9974428076575,369840.65882329666,368.86015854760416]
[164,369840.65882329666,5453.8229636946717,1232.8021960776555,4221.0207676170157,365619.63805567962,361.99653205856612]
[165,365619.63805567962,5453.8229636946717,1218.7321268522653,4235.0908368424061,361384.54721883719,355.20102921266141]
[166,361384.54721883719,5453.8229636946717,1204.615157396124,4249.2078062985474,357135.33941253863,348.47307245733811]
[167,357135.33941253863,5453.8229636946717,1190.4511313751289,4263.3718323195426,352871.96758021909,341.81208883071116]
[168,352871.96758021909,5453.8229636946717,1176.2398919340637,4277.5830717606077,348594.38450845849,335.21750992618422]
[169,348594.38450845849,5453.8229636946717,1161.9812816948615,4291.8416819998101,344302.5428264587,328.68877185733919]
[170,344302.5428264587,5453.8229636946717,1147.6751427548622,4306.1478209398092,339996.39500551886,322.22531522309362]
[171,339996.39500551886,5453.8229636946717,1133.3213166850628,4320.5016470096089,335675.89335850923,315.82658507312038]
[172,335675.89335850923,5453.8229636946717,1118.9196445283642,4334.9033191663075,331340.9900393429,309.49203087353123]
[173,331340.9900393429,5453.8229636946717,1104.4699667978095,4349.3529968968624,326991.63704244606,303.22110647282017]
[174,326991.63704244606,5453.8229636946717,1089.9721234748201,4363.8508402198513,322627.78620222618,297.0132700680652]
[175,322627.78620222618,5453.8229636946717,1075.4259540074206,4378.3970096872508,318249.38919253892,290.86798417138675]
[176,318249.38919253892,5453.8229636946717,1060.831297308463,4392.9916663862086,313856.39752615272,284.78471557665995]
[177,313856.39752615272,5453.8229636946717,1046.1879917538424,4407.634971940829,309448.76255421189,278.76293532648077]
[178,309448.76255421189,5453.8229636946717,1031.4958751807062,4422.3270885139655,305026.4354656979,272.80211867938146]
[179,305026.4354656979,5453.8229636946717,1016.7547848856597,4437.0681788090124,300589.36728688888,266.90174507729631]
[180,300589.36728688888,5453.8229636946717,1001.964557622963,4451.8584060717085,296137.50888081716,261.06129811327253]
[181,{"$f":"IF(F182>0,F182,0)","v":296137.50888081716},{"$f":"IF(B183>0,C182,0)","v":5453.8229636946717},{"$f":"B183*$J$1/1200","v":987.12502960272388},{"$f":"C183-D183","v":4466.6979340919479},{"$f":"B183-E183","v":291670.81094672519},{"$f":"D183/POWER(1+9/1200,A183)","v":255.2802654994282}]
[182,291670.81094672519,5453.8229636946717,972.23603648908397,4481.5869272055879,287189.22401951958,249.55813903515192]
[183,287189.22401951958,5453.8229636946717,957.29741339839859,4496.5255502962727,282692.69846922328,243.89441457554486]
[184,282692.69846922328,5453.8229636946717,942.30899489741091,4511.5139687972605,278181.184500426,238.2885920001018]
[185,278181.184500426,5453.8229636946717,927.27061500141997,4526.5523486932516,273654.63215173275,232.74017518163038]
[186,273654.63215173275,5453.8229636946717,912.18210717244244,4541.6408565222291,269112.99129521049,227.24867195540614]
[187,269112.99129521049,5453.8229636946717,897.04330431736832,4556.7796593773037,264556.2116358332,221.81359408856184]
[188,264556.2116358332,5453.8229636946717,881.85403878611066,4571.9689249085613,259984.24271092465,216.43445724970945]
[189,259984.24271092465,5453.8229636946717,866.61414236974883,4587.2088213249226,255397.03388959973,211.11078097879258]
[190,255397.03388959973,5453.8229636946717,851.32344629866577,4602.499517396006,250794.53437220372,205.84208865716778]
[191,250794.53437220372,5453.8229636946717,835.98178124067908,4617.8411824539926,246176.69318974973,200.62790747791382]
[192,246176.69318974973,5453.8229636946717,820.58897729916578,4633.2339863955058,241543.45920335423,195.46776841636586]
[193,241543.45920335423,5453.8229636946717,805.14486401118074,4648.6780996834914,236894.78110367074,190.36120620087337]
[194,236894.78110367074,5453.8229636946717,789.64927034556911,4664.1736933491029,232230.60741032165,185.30775928378091]
[{"$f":"A196+1","v":195},232230.60741032165,5453.8229636946717,774.1020247010722,4679.7209389935997,227550.88647132806,180.30696981262889]
[196,227550.88647132806,5453.8229636946717,758.50295490442693,4695.3200087902451,222855.56646253783,175.35838360157331]
[197,222855.56646253783,5453.8229636946717,742.8518882084594,4710.9710754862126,218144.59538705161,170.46155010302246]
[198,218144.59538705161,5453.8229636946717,727.14865129017198,4726.6743124044997,213417.92107464711,165.61602237948983]
[199,213417.92107464711,5453.8229636946717,711.39307024882373,4742.4298934458475,208675.49118120127,160.82135707566025]
[200,208675.49118120127,5453.8229636946717,695.5849706040043,4758.2379930906673,203917.2531881106,156.07711439066853]
[201,203917.2531881106,5453.8229636946717,679.72417729370204,4774.0987864009694,199143.15440170962,151.38285805058911]
[202,199143.15440170962,5453.8229636946717,663.81051467236534,4790.0124490223061,194353.14195268732,146.73815528113454]
[203,194353.14195268732,5453.8229636946717,647.84380650895775,4805.979157185714,189547.16279550162,142.14257678056188]
[204,189547.16279550162,5453.8229636946717,631.82387598500543,4821.9990877096661,184725.16370779194,137.59569669278454]
[205,184725.16370779194,5453.8229636946717,615.75054569263978,4838.0724180020316,179887.09128978991,133.09709258068904]
[206,179887.09128978991,5453.8229636946717,599.62363763263306,4854.1993260620384,175032.89196372786,128.64634539965445]
[207,175032.89196372786,5453.8229636946717,583.44297321242618,4870.3799904822454,170162.51197324562,124.24303947127356]
[208,170162.51197324562,5453.8229636946717,567.20837324415209,4886.6145904505192,165275.89738279511,119.88676245727335]
[209,165275.89738279511,5453.8229636946717,550.91965794265036,4902.903305752021,160372.99407704308,115.57710533363412]
[210,160372.99407704308,5453.8229636946717,534.57664692347691,4919.2463167711949,155453.74776027189,111.31366236490564]
[211,155453.74776027189,5453.8229636946717,518.17915920090627,4935.6438044937659,150518.10395577812,107.09603107871851]
[212,150518.10395577812,5453.8229636946717,501.72701318592704,4952.0959505087449,145566.00800526937,102.92381224048927]
[213,145566.00800526937,5453.8229636946717,485.22002668423124,4968.6029370104407,140597.40506825893,98.796609828318367]
[214,140597.40506825893,5453.8229636946717,468.65801689419641,4985.1649468004753,135612.24012145845,94.714031008078607]
[215,135612.24012145845,5453.8229636946717,452.0408004048615,5001.7821632898103,130610.45795816864,90.67568610869381]
[216,130610.45795816864,5453.8229636946717,435.36819319389548,5018.4547705007762,125592.00318766787,86.681188597604816]
[217,125592.00318766787,5453.8229636946717,418.64001062555957,5035.182953069112,120556.82023459875,82.73015505642293]
[218,120556.82023459875,5453.8229636946717,401.85606744866249,5051.9668962460091,115504.85333835274,78.822205156768248]
[219,115504.85333835274,5453.8229636946717,385.01617779450913,5068.8067859001621,110436.04655245258,74.956961636292093]
[220,110436.04655245258,5453.8229636946717,368.12015517484195,5085.7028085198299,105350.34374393275,71.134050274881787]
[221,105350.34374393275,5453.8229636946717,351.16781247977582,5102.6551512148963,100247.68859271785,67.353099871046766]
[222,100247.68859271785,5453.8229636946717,334.15896197572619,5119.6640017189457,95128.024590998903,63.613742218484362]
[223,95128.024590998903,5453.8229636946717,317.09341530332966,5136.7295483913422,89991.295042607555,59.915612082824133]
[224,89991.295042607555,5453.8229636946717,299.97098347535854,5153.8519802193132,84837.443062388236,56.258347178549137]
[225,84837.443062388236,5453.8229636946717,282.79147687462745,5171.0314868200439,79666.4115755682,52.641588146092943]
[226,79666.4115755682,5453.8229636946717,265.55470525189401,5188.2682584427776,74478.143317125418,49.06497852911135]
[227,74478.143317125418,5453.8229636946717,248.26047772375139,5205.5624859709205,69272.580831154497,45.528164751926859]
[228,69272.580831154497,5453.8229636946717,230.90860277051499,5222.9143609241564,64049.666470230339,42.030796097145149]
[229,64049.666470230339,5453.8229636946717,213.49888823410112,5240.3240754605704,58809.342394769767,38.572524683442026]
[230,58809.342394769767,5453.8229636946717,196.03114131589922,5257.7918223787728,53551.550572390996,35.153005443519611]
[231,53551.550572390996,5453.8229636946717,178.50516857463666,5275.317795120035,48276.232777270961,31.771896102230482]
[232,48276.232777270961,5453.8229636946717,160.92077592423655,5292.9021877704354,42983.330589500525,28.428857154868403]
[233,42983.330589500525,5453.8229636946717,143.27776863166841,5310.5451950630031,37672.785394437524,25.123551845624661]
[234,37672.785394437524,5453.8229636946717,125.57595131479175,5328.2470123798803,32344.538382057643,21.855646146208436]
[235,32344.538382057643,5453.8229636946717,107.81512794019214,5346.0078357544799,26998.530546303162,18.624808734630165]
[236,26998.530546303162,5453.8229636946717,89.995101821010536,5363.8278618736613,21634.7026844295,15.430710974146621]
[237,21634.7026844295,5453.8229636946717,72.115675614764996,5381.7072880799069,16252.995396349594,12.273026892366493]
[238,16252.995396349594,5453.8229636946717,54.176651321165309,5399.6463123735066,10853.349083976087,9.1514331605152304]
[239,{"$f":"IF(F240>0,F240,0)","v":10853.349083976087},{"$f":"IF(B241>0,C240,0)","v":5453.8229636946717},{"$f":"B241*$J$1/1200","v":36.177830279920293},{"$f":"C241-D241","v":5417.6451334147514},{"$f":"B241-E241","v":5435.7039505613357},{"$f":"D241/POWER(1+9/1200,A241)","v":6.0656090728579901}]
[240,5435.7039505613357,5453.8229636946717,18.119013168537787,5435.7039505261337,3.5201992432121187E-8,3.0152365262794549]
[null,null,{"$f":"SUM(C3:C242)","v":1308917.5112867195},{"$f":"SUM(D3:D242)","v":408917.51128675655},899999.99999996461]

{"sheet":"Sheet1","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Please enable macros"]