{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["Customize Your Loan Manager","Loan Data","Loan Amortization Table","Summary Graph","Macros","Lock","ChgLoan","Intl Data Table"],"not_rendered":{"charts":1,"images":2,"macros":1,"defined_names":74,"comments":33},"unopened":[{"sheet":"Macros","index":4,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Customize Your Loan Manager","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"Hover Your Pointer"]
[{"$nulls":7},"HERE for a Useful Tip!"]
[]
[{"$nulls":3},"Type Personal Information Here..."]
[]
[{"$nulls":4},"Family Name  ","FAMILY NAME","Phone Number  ","Phone Number"]
[{"$nulls":4},"Address  ","Family Address","Fax Number  ","Fax Number"]
[{"$nulls":4},"City  ","City"]
[{"$nulls":4},"State  ","State"]
[{"$nulls":4},"ZIP Code  ","ZIP Code"]
[]
[]
[{"$nulls":3},"Specify Default Loan Information Here..."]
[]
[{"$nulls":4},"Enter the number of periods the table should contain:  ",null,48,"  periods (Maximum of 720)"]
[]
[]
[{"$nulls":3},"Formatted Information"]

{"sheet":"Loan Data","index":1,"n_rows":65,"n_cols":10,"rows_kept":65,"flags":["formulas_cached_only"]}
{"$rows_empty":12}
[{"$nulls":4},"Lender Name",""]
[]
[{"$nulls":4},"Basic Loan Information"]
[{"$nulls":4},"Amount","",null,"Annual Interest Rate   ",""]
[{"$nulls":4},"Beginning of Loan",null,null,"Length of Loan, Years"]
[{"$nulls":7},"Payments Per Year",12,12]
[{"$nulls":4},"Payment Information"]
[{"$nulls":4},"Total Payments",0,null,"Calculated Payment",{"v":0,"d":"$0.00"}]
[{"$nulls":7},"Entered Payment"]
[{"$nulls":4},"Summary Information"]
[{"$nulls":4},"Total Paid",{"v":0,"d":"$0.00"},null,"Interest Paid",{"v":0,"d":"$0.00"}]
[{"$nulls":4},"",null,null,""]
[{"$nulls":3},""]
[{"$nulls":3},""]
{"$rows_empty":8}
[{"$nulls":4},1]
[{"$nulls":4},0]
[{"$nulls":4},true]
[]
[{"$nulls":4},"Loan Data"]
{"$rows_empty":18}
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]

{"sheet":"Loan Amortization Table","index":2,"n_rows":63,"n_cols":13,"rows_kept":63,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"What is the Loan Amortization Table Sheet?"]
[]
[]
[null,null,0]
[null,null,0]
[null,null,0,null,null,"1995-06-28",{"$nulls":4},""]
[null,null,0]
[{"$nulls":4},"Pmnt\n#","Start of Period","Annual Interest Rate","Scheduled Balance","Actual Balance","Scheduled Payment","Interest Portion","Principal Portion","Additional Principal"]
[]
[{"$nulls":4},1,"1995-06-28","",0,0,0,0,0]
[{"$nulls":4},2,"","",0,0,0,0,0]
[{"$nulls":4},3,"","",0,0,0,0,0]
[{"$nulls":4},4,"","",0,0,0,0,0]
[{"$nulls":4},5,"","",0,0,0,0,0]
[{"$nulls":4},6,"","",0,0,0,0,0]
[{"$nulls":4},7,"","",0,0,0,0,0]
[{"$nulls":4},8,"","",0,0,0,0,0]
[{"$nulls":4},9,"","",0,0,0,0,0]
[{"$nulls":4},10,"","",0,0,0,0,0]
[{"$nulls":4},11,"","",0,0,0,0,0]
[{"$nulls":4},12,"","",0,0,0,0,0]
[{"$nulls":4},13,"","",0,0,0,0,0]
[{"$nulls":4},14,"","",0,0,0,0,0]
[{"$nulls":4},15,"","",0,0,0,0,0]
[{"$nulls":4},16,"","",0,0,0,0,0]
[{"$nulls":4},17,"","",0,0,0,0,0]
[{"$nulls":4},18,"","",0,0,0,0,0]
[{"$nulls":4},19,"","",0,0,0,0,0]
[{"$nulls":4},20,"","",0,0,0,0,0]
[{"$nulls":4},21,"","",0,0,0,0,0]
[{"$nulls":4},22,"","",0,0,0,0,0]
[{"$nulls":4},23,"","",0,0,0,0,0]
[{"$nulls":4},24,"","",0,0,0,0,0]
[{"$nulls":4},25,"","",0,0,0,0,0]
[{"$nulls":4},26,"","",0,0,0,0,0]
[{"$nulls":4},27,"","",0,0,0,0,0]
[{"$nulls":4},28,"","",0,0,0,0,0]
[{"$nulls":4},29,"","",0,0,0,0,0]
[{"$nulls":4},30,"","",0,0,0,0,0]
[{"$nulls":4},31,"","",0,0,0,0,0]
[{"$nulls":4},32,"","",0,0,0,0,0]
[{"$nulls":4},33,"","",0,0,0,0,0]
[{"$nulls":4},34,"","",0,0,0,0,0]
[{"$nulls":4},35,"","",0,0,0,0,0]
[{"$nulls":4},36,"","",0,0,0,0,0]
[{"$nulls":4},37,"","",0,0,0,0,0]
[{"$nulls":4},38,"","",0,0,0,0,0]
[{"$nulls":4},39,"","",0,0,0,0,0]
[{"$nulls":4},40,"","",0,0,0,0,0]
[{"$nulls":4},41,"","",0,0,0,0,0]
[{"$nulls":4},42,"","",0,0,0,0,0]
[{"$nulls":4},43,"","",0,0,0,0,0]
[{"$nulls":4},44,"","",0,0,0,0,0]
[{"$nulls":4},45,"","",0,0,0,0,0]
[{"$nulls":4},46,"","",0,0,0,0,0]
[{"$nulls":4},47,"","",0,0,0,0,0]
[{"$nulls":4},48,"","",0,0,0,0,0]

{"sheet":"Summary Graph","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Lock","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"ChgLoan","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Intl Data Table","index":7,"n_rows":10,"n_cols":28,"rows_kept":10,"hidden":true,"flags":["formulas_cached_only"]}
[]
[{"$nulls":3},"US","UK","Canada","Australia","New Zealand","Ireland","Arabic Countries","Austria","China","Denmark","France","Germany","Israel","Italy","Japan","Korea","Luxembourg","Netherlands","Norway","South Africa","Spain","Sweden","Switzerland","Taiwan","Venezuela"]
["Sheet Name","Cell Address","Action Code",-999,44,2,61,64,353,785,43,86,45,33,49,972,39,81,82,352,31,47,27,34,46,41,886,58]
["Loan Data","F16",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Loan Data","I20:I21",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Loan Data","I23",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Loan Data","F23",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Loan Data","A1",4,1,9,1,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9]
["Loan Amortization Table","A1",4,1,9,1,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9]
["Summary Graph","A1",4,1,9,1,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9]