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

{"sheet":"Standard Loan Analysis","index":0,"n_rows":58,"n_cols":9,"rows_kept":58,"merged":[[0,0,0,9],[1,0,2,9],[3,1,15,4],[17,1,17,8],[18,1,18,7]],"flags":["formulas_cached_only"]}
["Standard Loan Analysis"]
[]
[]
[null,"This worksheet can help you analyze a standard loan. Enter values into the yellow boxes, replacing sample data. 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":50000,"d":"$50,000.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-10-01"]
[]
[{"$nulls":5},"Monthly payments",null,null,{"v":1572.5911722757469,"d":"$1,572.59"}]
[{"$nulls":5},"Total number of payments",null,null,36]
[{"$nulls":5},"Yearly principal + interest",null,null,{"v":18871.094067308964,"d":"$18,871.09"}]
[]
[{"$nulls":5},"Principal amount",null,null,{"v":50000,"d":"$50,000.00"}]
[{"$nulls":5},"Finance charges",null,"",{"v":6613.282201926893,"d":"$6,613.28"}]
[{"$nulls":5},"Total cost",null,null,{"v":56613.28220192689,"d":"$56,613.28"}]
[]
[null,""]
[null,"",{"$nulls":6},""]
[]
[null,"Amortization Table"]
[null,"Pmt No.","Payment Date","Beginning Balance","Interest","Principal","Balance","Accumulative Interest","Accumulative Principal"]
[null,1,"2000-10-01",{"v":50000,"d":"50,000.00"},343.75,{"v":1228.8411722757469,"d":"1,228.84"},{"v":48771.158827724255,"d":"48,771.16"},343.75,{"v":1228.8411722757469,"d":"1,228.84"}]
[null,2,"2000-11-01",{"v":48771.158827724255,"d":"48,771.16"},{"v":335.3017169406043,"d":"335.30"},{"v":1237.2894553351425,"d":"1,237.29"},{"v":47533.86937238911,"d":"47,533.87"},{"v":679.0517169406044,"d":"679.05"},{"v":2466.1306276108894,"d":"2,466.13"}]
[null,3,"2000-12-01",{"v":47533.86937238911,"d":"47,533.87"},{"v":326.79535193517535,"d":"326.80"},{"v":1245.7958203405715,"d":"1,245.80"},{"v":46288.07355204854,"d":"46,288.07"},{"v":1005.8470688757798,"d":"1,005.85"},{"v":3711.926447951461,"d":"3,711.93"}]
[null,4,"2001-01-01",{"v":46288.07355204854,"d":"46,288.07"},{"v":318.23050567033414,"d":"318.23"},{"v":1254.3606666054127,"d":"1,254.36"},{"v":45033.71288544313,"d":"45,033.71"},{"v":1324.077574546114,"d":"1,324.08"},{"v":4966.287114556873,"d":"4,966.29"}]
[null,5,"2001-02-01",{"v":45033.71288544313,"d":"45,033.71"},{"v":309.6067760874218,"d":"309.61"},{"v":1262.984396188325,"d":"1,262.98"},{"v":43770.728489254805,"d":"43,770.73"},{"v":1633.6843506335358,"d":"1,633.68"},{"v":6229.271510745199,"d":"6,229.27"}]
[null,6,"2001-03-01",{"v":43770.728489254805,"d":"43,770.73"},{"v":300.9237583636272,"d":"300.92"},{"v":1271.6674139121196,"d":"1,271.67"},{"v":42499.06107534269,"d":"42,499.06"},{"v":1934.608108997163,"d":"1,934.61"},{"v":7500.938924657318,"d":"7,500.94"}]
[null,7,"2001-04-01",{"v":42499.06107534269,"d":"42,499.06"},{"v":292.18104489298133,"d":"292.18"},{"v":1280.4101273827655,"d":"1,280.41"},{"v":41218.65094795992,"d":"41,218.65"},{"v":2226.7891538901445,"d":"2,226.79"},{"v":8781.349052040085,"d":"8,781.35"}]
[null,8,"2001-05-01",{"v":41218.65094795992,"d":"41,218.65"},{"v":283.37822526722505,"d":"283.38"},{"v":1289.212947008522,"d":"1,289.21"},{"v":39929.4380009514,"d":"39,929.44"},{"v":2510.1673791573694,"d":"2,510.17"},{"v":10070.561999048607,"d":"10,070.56"}]
[null,9,"2001-06-01",{"v":39929.4380009514,"d":"39,929.44"},{"v":274.51488625654144,"d":"274.51"},{"v":1298.0762860192053,"d":"1,298.08"},{"v":38631.361714932194,"d":"38,631.36"},{"v":2784.682265413911,"d":"2,784.68"},{"v":11368.638285067813,"d":"11,368.64"}]
[null,10,"2001-07-01",{"v":38631.361714932194,"d":"38,631.36"},{"v":265.5906117901596,"d":"265.59"},{"v":1307.0005604855874,"d":"1,307.00"},{"v":37324.361154446604,"d":"37,324.36"},{"v":3050.2728772040705,"d":"3,050.27"},{"v":12675.6388455534,"d":"12,675.64"}]
[null,11,"2001-08-01",{"v":37324.361154446604,"d":"37,324.36"},{"v":256.6049829368213,"d":"256.60"},{"v":1315.9861893389257,"d":"1,315.99"},{"v":36008.37496510768,"d":"36,008.37"},{"v":3306.8778601408917,"d":"3,306.88"},{"v":13991.625034892326,"d":"13,991.63"}]
[null,12,"2001-09-01",{"v":36008.37496510768,"d":"36,008.37"},{"v":247.5575778851164,"d":"247.56"},{"v":1325.0335943906305,"d":"1,325.03"},{"v":34683.34137071705,"d":"34,683.34"},{"v":3554.435438026008,"d":"3,554.44"},{"v":15316.658629282956,"d":"15,316.66"}]
[null,13,"2001-10-01",{"v":34683.34137071705,"d":"34,683.34"},{"v":238.4479719236805,"d":"238.45"},{"v":1334.1432003520663,"d":"1,334.14"},{"v":33349.19817036498,"d":"33,349.20"},{"v":3792.8834099496885,"d":"3,792.88"},{"v":16650.801829635024,"d":"16,650.80"}]
[null,14,"2001-11-01",{"v":33349.19817036498,"d":"33,349.20"},{"v":229.2757374212604,"d":"229.28"},{"v":1343.3154348544865,"d":"1,343.32"},{"v":32005.882735510495,"d":"32,005.88"},{"v":4022.159147370949,"d":"4,022.16"},{"v":17994.11726448951,"d":"17,994.12"}]
[null,15,"2001-12-01",{"v":32005.882735510495,"d":"32,005.88"},{"v":220.04044380663575,"d":"220.04"},{"v":1352.5507284691112,"d":"1,352.55"},{"v":30653.332007041383,"d":"30,653.33"},{"v":4242.199591177585,"d":"4,242.20"},{"v":19346.66799295862,"d":"19,346.67"}]
[null,16,"2002-01-01",{"v":30653.332007041383,"d":"30,653.33"},{"v":210.74165754841076,"d":"210.74"},{"v":1361.849514727336,"d":"1,361.85"},{"v":29291.482492314048,"d":"29,291.48"},{"v":4452.941248725995,"d":"4,452.94"},{"v":20708.517507685956,"d":"20,708.52"}]
[null,17,"2002-02-01",{"v":29291.482492314048,"d":"29,291.48"},{"v":201.3789421346602,"d":"201.38"},{"v":1371.2122301410866,"d":"1,371.21"},{"v":27920.270262172962,"d":"27,920.27"},{"v":4654.320190860655,"d":"4,654.32"},{"v":22079.72973782704,"d":"22,079.73"}]
[null,18,"2002-03-01",{"v":27920.270262172962,"d":"27,920.27"},{"v":191.95185805244023,"d":"191.95"},{"v":1380.6393142233067,"d":"1,380.64"},{"v":26539.630947949656,"d":"26,539.63"},{"v":4846.272048913095,"d":"4,846.27"},{"v":23460.369052050348,"d":"23,460.37"}]
[null,19,"2002-04-01",{"v":26539.630947949656,"d":"26,539.63"},{"v":182.4599627671552,"d":"182.46"},{"v":1390.1312095085916,"d":"1,390.13"},{"v":25149.499738441064,"d":"25,149.50"},{"v":5028.73201168025,"d":"5,028.73"},{"v":24850.50026155894,"d":"24,850.50"}]
[null,20,"2002-05-01",{"v":25149.499738441064,"d":"25,149.50"},{"v":172.9028107017838,"d":"172.90"},{"v":1399.688361573963,"d":"1,399.69"},{"v":23749.8113768671,"d":"23,749.81"},{"v":5201.634822382034,"d":"5,201.63"},{"v":26250.188623132904,"d":"26,250.19"}]
[null,21,"2002-06-01",{"v":23749.8113768671,"d":"23,749.81"},{"v":163.27995321596268,"d":"163.28"},{"v":1409.3112190597842,"d":"1,409.31"},{"v":22340.500157807313,"d":"22,340.50"},{"v":5364.914775597997,"d":"5,364.91"},{"v":27659.49984219269,"d":"27,659.50"}]
[null,22,"2002-07-01",{"v":22340.500157807313,"d":"22,340.50"},{"v":153.59093858492707,"d":"153.59"},{"v":1419.0002336908199,"d":"1,419.00"},{"v":20921.499924116495,"d":"20,921.50"},{"v":5518.505714182924,"d":"5,518.51"},{"v":29078.50007588351,"d":"29,078.50"}]
[null,23,"2002-08-01",{"v":20921.499924116495,"d":"20,921.50"},{"v":143.83531197830257,"d":"143.84"},{"v":1428.7558602974443,"d":"1,428.76"},{"v":19492.74406381905,"d":"19,492.74"},{"v":5662.341026161226,"d":"5,662.34"},{"v":30507.255936180954,"d":"30,507.26"}]
[null,24,"2002-09-01",{"v":19492.74406381905,"d":"19,492.74"},{"v":134.01261543875788,"d":"134.01"},{"v":1438.578556836989,"d":"1,438.58"},{"v":18054.16550698206,"d":"18,054.17"},{"v":5796.353641599984,"d":"5,796.35"},{"v":31945.834493017945,"d":"31,945.83"}]
[null,25,"2002-10-01",{"v":18054.16550698206,"d":"18,054.17"},{"v":124.12238786050344,"d":"124.12"},{"v":1448.4687844152434,"d":"1,448.47"},{"v":16605.696722566816,"d":"16,605.70"},{"v":5920.476029460488,"d":"5,920.48"},{"v":33394.30327743319,"d":"33,394.30"}]
[null,26,"2002-11-01",{"v":16605.696722566816,"d":"16,605.70"},{"v":114.16416496764879,"d":"114.16"},{"v":1458.4270073080982,"d":"1,458.43"},{"v":15147.269715258717,"d":"15,147.27"},{"v":6034.640194428136,"d":"6,034.64"},{"v":34852.73028474129,"d":"34,852.73"}]
[null,27,"2002-12-01",{"v":15147.269715258717,"d":"15,147.27"},{"v":104.1374792924057,"d":"104.14"},{"v":1468.4536929833412,"d":"1,468.45"},{"v":13678.816022275376,"d":"13,678.82"},{"v":6138.777673720541,"d":"6,138.78"},{"v":36321.18397772463,"d":"36,321.18"}]
[null,28,"2003-01-01",{"v":13678.816022275376,"d":"13,678.82"},{"v":94.04186015314549,"d":"94.04"},{"v":1478.5493121226013,"d":"1,478.55"},{"v":12200.266710152775,"d":"12,200.27"},{"v":6232.819533873687,"d":"6,232.82"},{"v":37799.73328984723,"d":"37,799.73"}]
[null,29,"2003-02-01",{"v":12200.266710152775,"d":"12,200.27"},{"v":83.87683363230234,"d":"83.88"},{"v":1488.7143386434445,"d":"1,488.71"},{"v":10711.55237150933,"d":"10,711.55"},{"v":6316.696367505989,"d":"6,316.70"},{"v":39288.44762849068,"d":"39,288.45"}]
[null,30,"2003-03-01",{"v":10711.55237150933,"d":"10,711.55"},{"v":73.6419225541292,"d":"73.64"},{"v":1498.9492497216177,"d":"1,498.95"},{"v":9212.603121787712,"d":"9,212.60"},{"v":6390.338290060118,"d":"6,390.34"},{"v":40787.3968782123,"d":"40,787.40"}]
[null,31,"2003-04-01",{"v":9212.603121787712,"d":"9,212.60"},{"v":63.336646462293004,"d":"63.34"},{"v":1509.254525813454,"d":"1,509.25"},{"v":7703.3485959742575,"d":"7,703.35"},{"v":6453.674936522411,"d":"6,453.67"},{"v":42296.65140402575,"d":"42,296.65"}]
[null,32,"2003-05-01",{"v":7703.3485959742575,"d":"7,703.35"},{"v":52.960521597325545,"d":"52.96"},{"v":1519.6306506784213,"d":"1,519.63"},{"v":6183.717945295836,"d":"6,183.72"},{"v":6506.6354581197365,"d":"6,506.64"},{"v":43816.28205470418,"d":"43,816.28"}]
[null,33,"2003-06-01",{"v":6183.717945295836,"d":"6,183.72"},{"v":42.513060873911485,"d":"42.51"},{"v":1530.0781114018355,"d":"1,530.08"},{"v":4653.639833894001,"d":"4,653.64"},{"v":6549.148518993648,"d":"6,549.15"},{"v":45346.36016610601,"d":"45,346.36"}]
[null,34,"2003-07-01",{"v":4653.639833894001,"d":"4,653.64"},{"v":31.993773858023786,"d":"31.99"},{"v":1540.597398417723,"d":"1,540.60"},{"v":3113.0424354762777,"d":"3,113.04"},{"v":6581.142292851672,"d":"6,581.14"},{"v":46886.957564523735,"d":"46,886.96"}]
[null,35,"2003-08-01",{"v":3113.0424354762777,"d":"3,113.04"},{"v":21.402166743902377,"d":"21.40"},{"v":1551.1890055318445,"d":"1,551.19"},{"v":1561.8534299444332,"d":"1,561.85"},{"v":6602.544459595574,"d":"6,602.54"},{"v":48438.14657005558,"d":"48,438.15"}]
[null,36,"2003-09-01",{"v":1561.8534299444332,"d":"1,561.85"},{"v":10.737742330871102,"d":"10.74"},{"v":1561.8534299448759,"d":"1,561.85"},{"v":-4.426965460879728e-10,"d":"-0.00"},{"v":6613.282201926445,"d":"6,613.28"},{"v":50000.00000000045,"d":"50,000.00"}]