{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Macros and What if analysis"],"not_rendered":{"charts":0,"images":1,"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":"Macros and What if analysis","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Company ABCD","One Education Drive","Garden City, NY 11710","516-572-____","2013-05-05","11:25:00"]
["Company ABCD","One Education Drive","Garden City, NY 11710",{"$f":"NOW()","v":"2013-05-05T21:01:55.260"}]
[]
[]
["price",300000]
["tax",{"$f":"B5*0.0825","v":24750}]
["down pmt",{"$f":"B5*0.2","v":60000}]
["interest rate",0.08]
["months",360]
[]
["amount financed",{"$f":"B5+B6-B7","v":264750}]
["monthly pmt",{"$f":"-PMT(B8/12,B9,B11,0,1)","v":1929.7765324625645}]
[]
[null,null,"Down  Payment"]
[null,{"$f":"$B$12","v":1929.7765324625645},60000,{"$f":"C15+5000","v":65000},{"$f":"D15+5000","v":70000},75000,80000,85000,90000,95000]
[null,30,9701.5070230699148,9518.2868715482928,9335.0667200266707,9151.8465685050469,8968.6264169834249,8785.4062654618028,8602.1861139401808,8418.965962418557]
[null,60,5332.6245574743589,5231.913989816675,5131.2034221589911,5030.4928545013072,4929.7822868436233,4829.0717191859403,4728.3611515282564,4627.6505838705725]
[null,120,3190.8755568457691,3130.6135066692677,3070.3514564927659,3010.0894063162636,2949.8273561397623,2889.5653059632605,2829.3032557867587,2769.0412056102568]
["Months",240,2199.8096847617808,2158.2646482223704,2116.71961168296,2075.1745751435496,2033.6295386041393,1992.0845020647289,1950.5394655253183,1908.9944289859079]
[null,360,1929.7765324625645,1893.3312721705424,1856.8860118785208,1820.4407515864987,1783.9954912944768,1747.5502310024547,1711.1049707104326,1674.6597104184107]
[null,480,1828.6467205416604,1794.1113717117896,1759.576022881919,1725.040674052048,1690.5053252221771,1655.9699763923063,1621.4346275624355,1586.8992787325647]