{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Standard Car Loan Analysis"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Standard Car Loan Analysis","index":0,"n_rows":57,"n_cols":9,"rows_kept":57,"merged":[[0,0,0,9],[1,0,2,8],[3,1,15,4],[16,1,16,8],[17,1,17,7]],"flags":["formulas_cached_only"]}
["Standard Car Loan Analysis"]
[]
[]
[null,"This worksheet can help you analyze a standard car loan. Enter values into the yellow boxes, writing over the sample values. Results will be shown in the green boxes.\n\nOnce you set the duration of the loan, you may need to extend the Amortization Table. If you decrease the duration, you may need to start again from a new worksheet.\n\nThis worksheet is locked to preserve the formulas that calculate your results. To unlock the worksheet, go to the Tools menu, select Protection, then choose Unprotect Sheet. This sheet does not use a password.",{"$nulls":3},"Analysis"]
[{"$nulls":5},"Amount financed",null,null,{"v":12500,"d":"$12,500.00"}]
[{"$nulls":5},"Annual interest (e.g., 8.25)",null,null,{"v":0.0825,"d":"8.25%"}]
[{"$nulls":5},"Duration of loan (in years)",null,null,3]
[{"$nulls":5},"Start date of loan",null,null,"2000-08-01"]
[]
[{"$nulls":5},"Monthly payments",null,null,{"v":393.1477930689367,"d":"$393.15"}]
[{"$nulls":5},"Total number of payments",null,null,36]
[]
[{"$nulls":5},"Principal amount",null,"",{"v":12500,"d":"$12,500.00"}]
[{"$nulls":5},"Finance charges",null,null,{"v":1653.3205504817215,"d":"$1,653.32"}]
[{"$nulls":5},"Total cost",null,null,{"v":14153.320550481722,"d":"$14,153.32"}]
[]
[null,""]
[null,"",{"$nulls":6},""]
[]
[null,"Amortization Table"]
[null,"Pmt No.","Payment Date","Beginning Balance","Interest","Principal","Balance","Accumulative Interest","Accumulative Principal"]
[null,1,"2000-08-01",{"v":12500,"d":"12,500.00"},{"v":85.9375,"d":"85.94"},{"v":307.2102930689367,"d":"307.21"},{"v":12192.789706931064,"d":"12,192.79"},{"v":85.9375,"d":"85.94"},{"v":307.2102930689367,"d":"307.21"}]
[null,2,"2000-09-01",{"v":12192.789706931064,"d":"12,192.79"},{"v":83.82542923515108,"d":"83.83"},{"v":309.32236383378563,"d":"309.32"},{"v":11883.467343097278,"d":"11,883.47"},{"v":169.7629292351511,"d":"169.76"},{"v":616.5326569027224,"d":"616.53"}]
[null,3,"2000-10-01",{"v":11883.467343097278,"d":"11,883.47"},{"v":81.69883798379384,"d":"81.70"},{"v":311.44895508514287,"d":"311.45"},{"v":11572.018388012135,"d":"11,572.02"},{"v":251.46176721894494,"d":"251.46"},{"v":927.9816119878652,"d":"927.98"}]
[null,4,"2000-11-01",{"v":11572.018388012135,"d":"11,572.02"},{"v":79.55762641758353,"d":"79.56"},{"v":313.5901666513532,"d":"313.59"},{"v":11258.428221360782,"d":"11,258.43"},{"v":331.0193936365285,"d":"331.02"},{"v":1241.5717786392183,"d":"1,241.57"}]
[null,5,"2000-12-01",{"v":11258.428221360782,"d":"11,258.43"},{"v":77.40169402185545,"d":"77.40"},{"v":315.74609904708126,"d":"315.75"},{"v":10942.682122313701,"d":"10,942.68"},{"v":408.42108765838395,"d":"408.42"},{"v":1557.3178776862997,"d":"1,557.32"}]
[null,6,"2001-01-01",{"v":10942.682122313701,"d":"10,942.68"},{"v":75.2309395909068,"d":"75.23"},{"v":317.9168534780299,"d":"317.92"},{"v":10624.765268835672,"d":"10,624.77"},{"v":483.65202724929077,"d":"483.65"},{"v":1875.2347311643296,"d":"1,875.23"}]
[null,7,"2001-02-01",{"v":10624.765268835672,"d":"10,624.77"},{"v":73.04526122324533,"d":"73.05"},{"v":320.1025318456914,"d":"320.10"},{"v":10304.66273698998,"d":"10,304.66"},{"v":556.6972884725361,"d":"556.70"},{"v":2195.337263010021,"d":"2,195.34"}]
[null,8,"2001-03-01",{"v":10304.66273698998,"d":"10,304.66"},{"v":70.84455631680626,"d":"70.84"},{"v":322.3032367521305,"d":"322.30"},{"v":9982.35950023785,"d":"9,982.36"},{"v":627.5418447893423,"d":"627.54"},{"v":2517.6404997621516,"d":"2,517.64"}]
[null,9,"2001-04-01",{"v":9982.35950023785,"d":"9,982.36"},{"v":68.62872156413536,"d":"68.63"},{"v":324.51907150480133,"d":"324.52"},{"v":9657.840428733049,"d":"9,657.84"},{"v":696.1705663534777,"d":"696.17"},{"v":2842.159571266953,"d":"2,842.16"}]
[null,10,"2001-05-01",{"v":9657.840428733049,"d":"9,657.84"},{"v":66.3976529475399,"d":"66.40"},{"v":326.75014012139684,"d":"326.75"},{"v":9331.090288611651,"d":"9,331.09"},{"v":762.5682193010176,"d":"762.57"},{"v":3168.90971138835,"d":"3,168.91"}]
[null,11,"2001-06-01",{"v":9331.090288611651,"d":"9,331.09"},{"v":64.15124573420532,"d":"64.15"},{"v":328.9965473347314,"d":"329.00"},{"v":9002.09374127692,"d":"9,002.09"},{"v":826.7194650352229,"d":"826.72"},{"v":3497.9062587230815,"d":"3,497.91"}]
[null,12,"2001-07-01",{"v":9002.09374127692,"d":"9,002.09"},{"v":61.8893944712791,"d":"61.89"},{"v":331.2583985976576,"d":"331.26"},{"v":8670.835342679262,"d":"8,670.84"},{"v":888.608859506502,"d":"888.61"},{"v":3829.164657320739,"d":"3,829.16"}]
[null,13,"2001-08-01",{"v":8670.835342679262,"d":"8,670.84"},{"v":59.61199298092013,"d":"59.61"},{"v":333.5358000880166,"d":"333.54"},{"v":8337.299542591245,"d":"8,337.30"},{"v":948.2208524874221,"d":"948.22"},{"v":4162.700457408756,"d":"4,162.70"}]
[null,14,"2001-09-01",{"v":8337.299542591245,"d":"8,337.30"},{"v":57.3189343553151,"d":"57.32"},{"v":335.8288587136216,"d":"335.83"},{"v":8001.470683877624,"d":"8,001.47"},{"v":1005.5397868427373,"d":"1,005.54"},{"v":4498.529316122377,"d":"4,498.53"}]
[null,15,"2001-10-01",{"v":8001.470683877624,"d":"8,001.47"},{"v":55.01011095165894,"d":"55.01"},{"v":338.1376821172778,"d":"338.14"},{"v":7663.333001760346,"d":"7,663.33"},{"v":1060.5498977943962,"d":"1,060.55"},{"v":4836.666998239655,"d":"4,836.67"}]
[null,16,"2001-11-01",{"v":7663.333001760346,"d":"7,663.33"},{"v":52.68541438710269,"d":"52.69"},{"v":340.462378681834,"d":"340.46"},{"v":7322.870623078512,"d":"7,322.87"},{"v":1113.2353121814988,"d":"1,113.24"},{"v":5177.129376921489,"d":"5,177.13"}]
[null,17,"2001-12-01",{"v":7322.870623078512,"d":"7,322.87"},{"v":50.34473553366505,"d":"50.34"},{"v":342.80305753527165,"d":"342.80"},{"v":6980.067565543241,"d":"6,980.07"},{"v":1163.5800477151638,"d":"1,163.58"},{"v":5519.93243445676,"d":"5,519.93"}]
[null,18,"2002-01-01",{"v":6980.067565543241,"d":"6,980.07"},{"v":47.98796451311006,"d":"47.99"},{"v":345.15982855582666,"d":"345.16"},{"v":6634.907736987414,"d":"6,634.91"},{"v":1211.5680122282738,"d":"1,211.57"},{"v":5865.092263012587,"d":"5,865.09"}]
[null,19,"2002-02-01",{"v":6634.907736987414,"d":"6,634.91"},{"v":45.6149906917888,"d":"45.61"},{"v":347.5328023771479,"d":"347.53"},{"v":6287.374934610266,"d":"6,287.37"},{"v":1257.1830029200626,"d":"1,257.18"},{"v":6212.625065389735,"d":"6,212.63"}]
[null,20,"2002-03-01",{"v":6287.374934610266,"d":"6,287.37"},{"v":43.22570267544595,"d":"43.23"},{"v":349.92209039349075,"d":"349.92"},{"v":5937.452844216775,"d":"5,937.45"},{"v":1300.4087055955085,"d":"1,300.41"},{"v":6562.547155783226,"d":"6,562.55"}]
[null,21,"2002-04-01",{"v":5937.452844216775,"d":"5,937.45"},{"v":40.81998830399067,"d":"40.82"},{"v":352.32780476494605,"d":"352.33"},{"v":5585.125039451828,"d":"5,585.13"},{"v":1341.2286938994991,"d":"1,341.23"},{"v":6914.874960548173,"d":"6,914.87"}]
[null,22,"2002-05-01",{"v":5585.125039451828,"d":"5,585.13"},{"v":38.39773464623177,"d":"38.40"},{"v":354.75005842270497,"d":"354.75"},{"v":5230.374981029124,"d":"5,230.37"},{"v":1379.626428545731,"d":"1,379.63"},{"v":7269.625018970877,"d":"7,269.63"}]
[null,23,"2002-06-01",{"v":5230.374981029124,"d":"5,230.37"},{"v":35.95882799457564,"d":"35.96"},{"v":357.1889650743611,"d":"357.19"},{"v":4873.186015954762,"d":"4,873.19"},{"v":1415.5852565403065,"d":"1,415.59"},{"v":7626.813984045239,"d":"7,626.81"}]
[null,24,"2002-07-01",{"v":4873.186015954762,"d":"4,873.19"},{"v":33.50315385968947,"d":"33.50"},{"v":359.64463920924726,"d":"359.64"},{"v":4513.541376745515,"d":"4,513.54"},{"v":1449.088410399996,"d":"1,449.09"},{"v":7986.458623254486,"d":"7,986.46"}]
[null,25,"2002-08-01",{"v":4513.541376745515,"d":"4,513.54"},{"v":31.03059696512586,"d":"31.03"},{"v":362.11719610381084,"d":"362.12"},{"v":4151.424180641704,"d":"4,151.42"},{"v":1480.119007365122,"d":"1,480.12"},{"v":8348.575819358297,"d":"8,348.58"}]
[null,26,"2002-09-01",{"v":4151.424180641704,"d":"4,151.42"},{"v":28.541041241912197,"d":"28.54"},{"v":364.60675182702454,"d":"364.61"},{"v":3786.8174288146793,"d":"3,786.82"},{"v":1508.660048607034,"d":"1,508.66"},{"v":8713.182571185322,"d":"8,713.18"}]
[null,27,"2002-10-01",{"v":3786.8174288146793,"d":"3,786.82"},{"v":26.034369823101425,"d":"26.03"},{"v":367.1134232458353,"d":"367.11"},{"v":3419.704005568844,"d":"3,419.70"},{"v":1534.6944184301353,"d":"1,534.69"},{"v":9080.295994431157,"d":"9,080.30"}]
[null,28,"2002-11-01",{"v":3419.704005568844,"d":"3,419.70"},{"v":23.510465038286373,"d":"23.51"},{"v":369.63732803065034,"d":"369.64"},{"v":3050.0666775381937,"d":"3,050.07"},{"v":1558.2048834684217,"d":"1,558.20"},{"v":9449.933322461808,"d":"9,449.93"}]
[null,29,"2002-12-01",{"v":3050.0666775381937,"d":"3,050.07"},{"v":20.969208408075584,"d":"20.97"},{"v":372.17858466086113,"d":"372.18"},{"v":2677.8880928773324,"d":"2,677.89"},{"v":1579.1740918764972,"d":"1,579.17"},{"v":9822.11190712267,"d":"9,822.11"}]
[null,30,"2003-01-01",{"v":2677.8880928773324,"d":"2,677.89"},{"v":18.4104806385323,"d":"18.41"},{"v":374.7373124304044,"d":"374.74"},{"v":2303.150780446928,"d":"2,303.15"},{"v":1597.5845725150295,"d":"1,597.58"},{"v":10196.849219553074,"d":"10,196.85"}]
[null,31,"2003-02-01",{"v":2303.150780446928,"d":"2,303.15"},{"v":15.834161615573251,"d":"15.83"},{"v":377.3136314533635,"d":"377.31"},{"v":1925.8371489935644,"d":"1,925.84"},{"v":1613.4187341306028,"d":"1,613.42"},{"v":10574.162851006438,"d":"10,574.16"}]
[null,32,"2003-03-01",{"v":1925.8371489935644,"d":"1,925.84"},{"v":13.240130399331386,"d":"13.24"},{"v":379.9076626696053,"d":"379.91"},{"v":1545.929486323959,"d":"1,545.93"},{"v":1626.6588645299341,"d":"1,626.66"},{"v":10954.070513676044,"d":"10,954.07"}]
[null,33,"2003-04-01",{"v":1545.929486323959,"d":"1,545.93"},{"v":10.628265218477871,"d":"10.63"},{"v":382.51952785045887,"d":"382.52"},{"v":1163.4099584735002,"d":"1,163.41"},{"v":1637.287129748412,"d":"1,637.29"},{"v":11336.590041526502,"d":"11,336.59"}]
[null,34,"2003-05-01",{"v":1163.4099584735002,"d":"1,163.41"},{"v":7.998443464505947,"d":"8.00"},{"v":385.14934960443077,"d":"385.15"},{"v":778.2606088690694,"d":"778.26"},{"v":1645.285573212918,"d":"1,645.29"},{"v":11721.739391130934,"d":"11,721.74"}]
[null,35,"2003-06-01",{"v":778.2606088690694,"d":"778.26"},{"v":5.350541685975594,"d":"5.35"},{"v":387.7972513829611,"d":"387.80"},{"v":390.4633574861083,"d":"390.46"},{"v":1650.6361148988935,"d":"1,650.64"},{"v":12109.536642513895,"d":"12,109.54"}]
[null,36,"2003-07-01",{"v":390.4633574861083,"d":"390.46"},{"v":2.6844355827177755,"d":"2.68"},{"v":390.46335748621897,"d":"390.46"},{"v":-1.106741365219932e-10,"d":"-0.00"},{"v":1653.3205504816112,"d":"1,653.32"},{"v":12500.000000000113,"d":"12,500.00"}]