{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["7 Year  Balloon Loan Amort."],"not_rendered":{"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"7 Year  Balloon Loan Amort.","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[32,1,32,7]]}
[]
[]
[]
[null,"7 Year Balloon Loan Amortization"]
[null,"Prepared by Your Name"]
[null,{"$f":"NOW()","v":"2010-04-19T20:51:36.450"}]
[]
[]
[null,"Name",null,"Billie Bob Jones",null,null,"Financial Inputs"]
[null,"Address",null,"808 Gun Street",null,null,"Loan Amount",{"v":100000,"d":"$100,000"}]
[null,"City, State, Zip",null,"Selma, SC 02777",null,null,"Interest Rate",{"v":0.08,"d":"8.000%"}]
[null,"Telephone",null,"555-555-5555",null,null,"Period (in years)",30]
[]
[{"$nulls":6},"Loan Summary Information"]
[null,"Loan Date",null,"2009-01-04",null,null,"Monthly Payment",{"$f":"IF(AND(H10>0,H11,H12),PMT(H11/12,H12*12,-H10),\"\")","v":{"v":733.7645738793775,"d":"$733.76"}}]
[null,"Loan Number",null,16899,null,null,"Total Interest",{"$f":"IF(AND(H10>0,H11,H12),SUM(F25:F31),\"\")","v":{"v":54113.65588753512,"d":"$54,113.66"}}]
[null,"Miscellaneous",null,"Single Family",null,null,"Total Payments",{"$f":"IF(SUM(H15),H15*12*7,\"\")","v":{"v":61636.22420586771,"d":"$61,636.22"}}]
[null,"Appraised Value",null,{"v":150000,"d":"$150,000"},null,null,"Balloon Payment ",{"$f":"IF(SUM(H31),H31,\"\")","v":{"v":92477.43168166741,"d":"$92,477.43"}}]
[]
[]
[null,"Amortization Schedule of 7 Year Balloon Loan"]
[null,null,"Beginning","Total",null,"Total","Total","Ending"]
[null,null,"Mortgage","Monthly",null,"Interest","Principal","Mortgage"]
[null,"Year","Balance","Payment",null,"Portion","Portion","Balance"]
[null,{"$f":"IF(AND(H10>0,H11,H12),1,\"\")","v":1},{"$f":"IF(H10,+H10,\"\")","v":{"v":100000,"d":"$100,000.00"}},{"$f":"IF(SUM($H$15),$H$15*12,\"\")","v":{"v":8805.17488655253,"d":"$8,805.17"}},null,{"$f":"IF(AND(SUM(D25)>0,SUM(G25)),D25-G25,\"\")","v":{"v":7969.810905581835,"d":"$7,969.81"}},{"$f":"IF(AND(SUM(C25)>0,H25),C25-H25,\"\")","v":{"v":835.3639809706947,"d":"$835.36"}},{"$f":"IF(AND($H$10>0,$H$11,$H$12),PV($H$11/12,($H$12-B25)*12,-$H$15),\"\")","v":{"v":99164.6360190293,"d":"$99,164.64"}}]
[null,{"$f":"IF(AND($H$10>0,$H$11,$H$12),2,\"\")","v":2},{"$f":"IF(SUM(H25),H25,\"\")","v":{"v":99164.6360190293,"d":"$99,164.64"}},{"$f":"IF(SUM($H$15),$H$15*12,\"\")","v":{"v":8805.17488655253,"d":"$8,805.17"}},null,{"$f":"IF(AND(SUM(D26)>0,G26),+D26-G26,\"\")","v":{"v":7900.476107156574,"d":"$7,900.48"}},{"$f":"IF(AND(SUM(C26)>0,H26),+C26-H26,\"\")","v":{"v":904.6987793959561,"d":"$904.70"}},{"v":98259.93723963335,"d":"$98,259.94"}]
[null,{"$f":"IF(AND($H$10>0,$H$11,$H$12),3,\"\")","v":3},{"v":98259.93723963335,"d":"$98,259.94"},{"v":8805.17488655253,"d":"$8,805.17"},null,{"v":7825.386554657307,"d":"$7,825.39"},{"v":979.7883318952227,"d":"$979.79"},{"v":97280.14890773813,"d":"$97,280.15"}]
[null,{"$f":"IF(AND($H$10>0,$H$11,$H$12),4,\"\")","v":4},{"v":97280.14890773813,"d":"$97,280.15"},{"v":8805.17488655253,"d":"$8,805.17"},null,{"v":7744.064606334272,"d":"$7,744.06"},{"v":1061.1102802182577,"d":"$1,061.11"},{"v":96219.03862751987,"d":"$96,219.04"}]
[null,{"$f":"IF(AND($H$10>0,$H$11,$H$12),5,\"\")","v":5},{"v":96219.03862751987,"d":"$96,219.04"},{"v":8805.17488655253,"d":"$8,805.17"},null,{"v":7655.992976407768,"d":"$7,655.99"},{"v":1149.1819101447618,"d":"$1,149.18"},{"v":95069.8567173751,"d":"$95,069.86"}]
[null,{"$f":"IF(AND($H$10>0,$H$11,$H$12),6,\"\")","v":6},{"v":95069.8567173751,"d":"$95,069.86"},{"v":8805.17488655253,"d":"$8,805.17"},null,{"v":7560.611444633643,"d":"$7,560.61"},{"v":1244.5634419188864,"d":"$1,244.56"},{"v":93825.29327545622,"d":"$93,825.29"}]
[null,{"$f":"IF(AND($H$10>0,$H$11,$H$12),7,\"\")","v":7},{"v":93825.29327545622,"d":"$93,825.29"},{"v":8805.17488655253,"d":"$8,805.17"},null,{"v":7457.31329276372,"d":"$7,457.31"},{"v":1347.8615937888098,"d":"$1,347.86"},{"v":92477.43168166741,"d":"$92,477.43"}]