{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["New","Report","201105","201104","201103","201102","201101","Banks"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":25,"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":"New","index":0,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,1,7,2],[11,1,11,2],[9,1,9,2],[10,1,10,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[17,9,17,11],[17,12,17,16],[8,1,8,2],[13,1,13,2],[12,1,12,2],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[4,7,9,14]]}
[null,"REPORT"]
[]
[null,"Loan Participation"]
[null,"Borrower",null,null,null,null,null,null,null,"Comments:"]
[null,"Loan Amount"]
[null,"Loan Number"]
[null,"Date of Participation"]
[null,"Maturity Date"]
[null,"Beg. Interest Rate"]
[null,"Selling Bank"]
[null,"Purchasing Bank"]
[null,"Amount Purchased"]
[null,"% Purchased",null,{"$f":"IF(D12=\"\",\"\",+D12/D5)","v":""}]
[1]
[]
[]
[null,null,"Today's Date",{"$f":"IF(D5=\"\",\"\",TODAY())","v":""}]
[null,"Payment Schedule",null,null,null,null,null,null,null,{"$f":"\"\"& D10","v":""},null,null,{"$f":"\"\"& D11","v":""}]
[null,"Date","Advance","Interest Rate","Accrued Interest"," ","Interest Payment","Principal Payment","Ending Principal","Principal Pmt","Interest Pmt","Balance Owed"," Date","Accrued Int","Prin Payment","Int Payment","Balance","Current %"]
[null,{"$f":"IF(D7=\"\",\"\",+D7)","v":""},{"$f":"IF(B20=\"\",\"\",+D5)","v":""},{"$f":"IF(+D9=\"\",\"\",D9)","v":""},0,null,0,0,{"$f":"C20","v":""},0,0,{"$f":"+D5-D12","v":0},{"$f":"IF(B20=\"\",\"\",B20)","v":""},0,0,0,{"$f":"IF(M20=\"\",\"\",+I20*$D$13)","v":""},{"$f":"IF(B20=\"\",\"\",Q20/I20)","v":""}]
[null,null,null,{"$f":"IF(B21=\"\",\"\",+D20)","v":""},{"$f":"IF(B21=\"\",\"\",ROUND(+I20*D20/365*(B21-B20),2)+E20-G20)","v":""},null,null,{"$f":"IF(B21=\"\",\"\",0)","v":""},{"$f":"IF(B21=\"\",\"\",+C21-H21+I20)","v":""},{"$f":"IF(OR(B21=\"\",H21=0),\"\",H21-O21)","v":""},{"$f":"IF(+OR(G21=\"\",P21=\"\"),\"\",G21-P21)","v":""},{"$f":"IF(+OR(B21=\"\",Q21=\"\"),\"\",I21-Q21)","v":""},{"$f":"IF(B21=\"\",\"\",B21)","v":""},{"$f":"IF(M21=\"\",\"\",Q20*D20/365*(M21-M20)+N20-P20)","v":""},{"$f":"IF(M21=\"\",\"\",IF($A$14=1,+H21*$D$13,IF($A$14=2,H21,0)))","v":""},{"$f":"IF(M21=\"\",\"\",0)","v":""},{"$f":"IF(M21=\"\",\"\",+Q20-O21+(C21*$D$13))","v":""},""]

{"sheet":"Report","index":1,"n_rows":114,"n_cols":14,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,0,1,12],[2,4,2,7]]}
["Report"]
["PARTICIPATIONS SOLD/PURCHASED"]
[null,null,null,null,"PUBLIC BANK & TRUST"]
["Selling Bank",{"$f":"SUM(Selling[[#All],[Column1]])","v":14000000},null,null,null,null,null,null,null,"Purchasing Bank",{"$f":"SUM(Purchasing[[#All],[Column1]])","v":10525000}]
[{"$f":"Banks!B2","v":"FNB"},{"$f":"IF(A5=\"\",\"\",SUMIF($G$16:$G$31,A5,$H$16:$H$31))","v":1725000},null,null,null,null,null,null,null,{"$f":"Banks!D2","v":"FSB"},{"$f":"IF(J5=\"\",\"\",SUMIF($J$16:$J$31,J5,$K$16:$K$31))","v":4250000}]
[{"$f":"Banks!B3","v":"CNB"},1000000,null,null,null,null,null,null,null,{"$f":"Banks!D3","v":"SSB"},275000]
[{"$f":"Banks!B4","v":"SNB"},275000,null,null,null,null,null,null,null,{"$f":"Banks!D4","v":"LNB"},6000000]
[{"$f":"Banks!B5","v":"FFB"},9000000,null,null,null,null,null,null,null,{"$f":"Banks!D5","v":""},""]
["LNB",{"$f":"IF(A9=\"\",\"\",SUMIF($G$16:$G$31,A9,$H$16:$H$31))","v":2000000}]
[]
[]
[null,null,null,null,null,null,"TOTALS",{"$f":"+B4+K4","v":24525000}]
[null,null,null,null,null,null,{"$f":"IF(SUM(Participations[Current \nBalance])+SUM(Participations[Balance\nPurchased])=K4+B4,\"\",\"Does not Balance\")","v":""}]
["Balances as of: ",{"$f":"TODAY()","v":"2012-01-11"}]
["Borrower","Loan No.","    Total \n    Balance","Int. Rate","Maturity Date","Column1","Selling \nBank","Current \nBalance","Column3","Purchasing \nBank","Balance\nPurchased","Payments","% Purchased","Current %"]
[{"$f":"IF(B16=\"\",\"\",INDIRECT(\"'\" &B16& \"'!\" & \"d4\"))","v":"John Q Public"},201101,{"$f":"IF(B16=\"\",\"\",(VLOOKUP(+$B$14,INDIRECT(\"'\"&B16&\"'!\"&\"b19:i325\"),8)))","v":3500000},{"$f":"IF(C16=\"\",\"\",(VLOOKUP(+$B$14,INDIRECT(\"'\"&B16&\"'!\"&\"b19:i325\"),3)))","v":0.05},{"$f":"IF(B16=\"\",\"\",INDIRECT(\"'\" &B16& \"'!\" & \"d7\"))","v":"2011-01-01"},{"$f":"IF(C16=\"\",\"\",0)","v":0},{"$f":"IF(B16=\"\",\"\",INDIRECT(\"'\" &B16& \"'!\" & \"d10\"))","v":"FNB"},{"$f":"IF(B16=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B16&\"'!\"&\"b19:l325\"),11)))","v":1725000},{"$f":"IF(H16=\"\",\"\",0)","v":0},{"$f":"IF(B16=\"\",\"\",INDIRECT(\"'\" &B16& \"'!\" & \"d11\"))","v":"FSB"},{"$f":"IF(B16=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B16&\"'!\"&\"b19:q325\"),16)))","v":1750000},{"$f":"IF(B16=\"\",\"\",IF(INDIRECT(\"'\" &B16& \"'!\" & \"a14\")=1,\"Pro Rata\",IF(INDIRECT(\"'\" &B16& \"'!\" & \"a14\")=2,\"1st Out\",\"Last Out\")))","v":"Pro Rata"},{"$f":"IF(B16=\"\",\"\",INDIRECT(\"'\" &B16& \"'!\" & \"d13\"))","v":0.5},{"$f":"+Participations[[#This Row],[Balance\nPurchased]]/Participations[[#This Row],[    Total \n    Balance]]","v":0.5}]
[{"$f":"IF(B17=\"\",\"\",INDIRECT(\"'\" &B17& \"'!\" & \"d4\"))","v":"James R. Public"},201102,{"$f":"IF(B17=\"\",\"\",(VLOOKUP(+$B$14,INDIRECT(\"'\"&B17&\"'!\"&\"b19:i325\"),8)))","v":2000000},{"$f":"IF(C17=\"\",\"\",(VLOOKUP(+$B$14,INDIRECT(\"'\"&B17&\"'!\"&\"b19:i325\"),3)))","v":0.06},{"$f":"IF(B17=\"\",\"\",INDIRECT(\"'\" &B17& \"'!\" & \"d7\"))","v":"2011-01-01"},{"$f":"IF(C17=\"\",\"\",0)","v":0},{"$f":"IF(B17=\"\",\"\",INDIRECT(\"'\" &B17& \"'!\" & \"d10\"))","v":"CNB"},{"$f":"IF(B17=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B17&\"'!\"&\"b19:l325\"),11)))","v":1000000},{"$f":"IF(H17=\"\",\"\",0)","v":0},{"$f":"IF(B17=\"\",\"\",INDIRECT(\"'\" &B17& \"'!\" & \"d11\"))","v":"FSB"},{"$f":"IF(B17=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B17&\"'!\"&\"b19:q325\"),16)))","v":1000000},{"$f":"IF(B17=\"\",\"\",IF(INDIRECT(\"'\" &B17& \"'!\" & \"a14\")=1,\"Pro Rata\",IF(INDIRECT(\"'\" &B17& \"'!\" & \"a14\")=2,\"1st Out\",\"Last Out\")))","v":"1st Out"},{"$f":"IF(B17=\"\",\"\",INDIRECT(\"'\" &B17& \"'!\" & \"d13\"))","v":0.5},{"$f":"+Participations[[#This Row],[Balance\nPurchased]]/Participations[[#This Row],[    Total \n    Balance]]","v":0.5}]
["Jane Public",201103,550000,5.5E-2,"2011-01-11",0,"SNB",275000,0,"SSB",275000,"Pro Rata",0.5,{"$f":"+Participations[[#This Row],[Balance\nPurchased]]/Participations[[#This Row],[    Total \n    Balance]]","v":0.5}]
["Jason Public",201104,15000000,{"$f":"IF(C19=\"\",\"\",(VLOOKUP(+$B$14,INDIRECT(\"'\"&B19&\"'!\"&\"b19:i325\"),3)))","v":6.5000000000000002E-2},{"$f":"IF(B19=\"\",\"\",INDIRECT(\"'\" &B19& \"'!\" & \"d7\"))","v":"2011-02-01"},{"$f":"IF(C19=\"\",\"\",0)","v":0},{"$f":"IF(B19=\"\",\"\",INDIRECT(\"'\" &B19& \"'!\" & \"d10\"))","v":"FFB"},{"$f":"IF(B19=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B19&\"'!\"&\"b19:l325\"),11)))","v":9000000},{"$f":"IF(H19=\"\",\"\",0)","v":0},"LNB",{"$f":"IF(B19=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B19&\"'!\"&\"b19:q325\"),16)))","v":6000000},{"$f":"IF(B19=\"\",\"\",IF(INDIRECT(\"'\" &B19& \"'!\" & \"a14\")=1,\"Pro Rata\",IF(INDIRECT(\"'\" &B19& \"'!\" & \"a14\")=2,\"1st Out\",\"Last Out\")))","v":"Last Out"},{"$f":"IF(B19=\"\",\"\",INDIRECT(\"'\" &B19& \"'!\" & \"d13\"))","v":0.4},{"$f":"+Participations[[#This Row],[Balance\nPurchased]]/Participations[[#This Row],[    Total \n    Balance]]","v":0.4}]
["Jeremy Public",201105,3500000,{"$f":"IF(C20=\"\",\"\",(VLOOKUP(+$B$14,INDIRECT(\"'\"&B20&\"'!\"&\"b19:i325\"),3)))","v":0.05},{"$f":"IF(B20=\"\",\"\",INDIRECT(\"'\" &B20& \"'!\" & \"d7\"))","v":"2011-03-01"},{"$f":"IF(C20=\"\",\"\",0)","v":0},{"$f":"IF(B20=\"\",\"\",INDIRECT(\"'\" &B20& \"'!\" & \"d10\"))","v":"LNB"},{"$f":"IF(B20=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B20&\"'!\"&\"b19:l325\"),11)))","v":2000000},{"$f":"IF(H20=\"\",\"\",0)","v":0},"FSB",{"$f":"IF(B20=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B20&\"'!\"&\"b19:q325\"),16)))","v":1500000},{"$f":"IF(B20=\"\",\"\",IF(INDIRECT(\"'\" &B20& \"'!\" & \"a14\")=1,\"Pro Rata\",IF(INDIRECT(\"'\" &B20& \"'!\" & \"a14\")=2,\"1st Out\",\"Last Out\")))","v":"Pro Rata"},{"$f":"IF(B20=\"\",\"\",INDIRECT(\"'\" &B20& \"'!\" & \"d13\"))","v":0.42857142857142855},{"$f":"+Participations[[#This Row],[Balance\nPurchased]]/Participations[[#This Row],[    Total \n    Balance]]","v":0.42857142857142855}]
["",null,"","","","","","","",{"$f":"IF(B21=\"\",\"\",INDIRECT(\"'\" &B21& \"'!\" & \"d10\"))","v":""},"","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
[{"$f":"IF(B103=\"\",\"\",INDIRECT(\"'\" &B103& \"'!\" & \"d4\"))","v":""},null,{"$f":"IF(B103=\"\",\"\",(VLOOKUP(+$B$14,INDIRECT(\"'\"&B103&\"'!\"&\"b20:i325\"),8)))","v":""},{"$f":"IF(C103=\"\",\"\",(VLOOKUP(+$B$14,INDIRECT(\"'\"&B103&\"'!\"&\"b20:g325\"),3)))","v":""},{"$f":"IF(B103=\"\",\"\",INDIRECT(\"'\" &B103& \"'!\" & \"d8\"))","v":""},{"$f":"IF(C103=\"\",\"\",0)","v":""},{"$f":"IF(B103=\"\",\"\",INDIRECT(\"'\" &B103& \"'!\" & \"d10\"))","v":""},{"$f":"IF(B103=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B103&\"'!\"&\"b20:l325\"),11)))","v":""},{"$f":"IF(H103=\"\",\"\",0)","v":""},{"$f":"IF(B103=\"\",\"\",INDIRECT(\"'\" &B103& \"'!\" & \"d11\"))","v":""},{"$f":"IF(B103=\"\",\"\",(VLOOKUP($B$14,INDIRECT(\"'\"&B103&\"'!\"&\"b20:q325\"),16)))","v":""},{"$f":"IF(B103=\"\",\"\",IF(INDIRECT(\"'\" &B103& \"'!\" & \"a14\")=1,\"Pro Rata\",IF(INDIRECT(\"'\" &B103& \"'!\" & \"a14\")=2,\"1st Out\",\"Last Out\")))","v":""},{"$f":"IF(B103=\"\",\"\",INDIRECT(\"'\" &B103& \"'!\" & \"d13\"))","v":""}]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]
["",null,"","","","","","","","","","",""]

{"sheet":"201105","index":2,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[13,1,13,2],[17,9,17,11],[17,12,17,16],[10,1,10,2],[10,3,10,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[2,1,2,4],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4],[4,7,9,14],[5,1,5,2],[5,3,5,4],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4]]}
[null,"REPORT"]
[]
[null,"Loan Participation"]
[null,"Borrower",null,"Jeremy Public",null,null,null,null,null,"Comments:"]
[null,"Loan Amount",null,3500000]
[null,"Loan Number",null,"201105"]
[null,"Date of Participation",null,"2011-03-01"]
[null,"Maturity Date",null,"2031-03-01"]
[null,"Beg. Interest Rate",null,0.05]
[null,"Selling Bank",null,"LNB"]
[null,"Purchasing Bank",null,"FSB"]
[null,"Amount Purchased",null,1500000]
[null,"% Purchased",null,{"$f":"IF(D12=\"\",\"\",+D12/D5)","v":0.42857142857142855}]
[1]
[]
[]
[null,null,"Today's Date",{"$f":"IF(D5=\"\",\"\",TODAY())","v":"2012-01-11"}]
[null,"Payment Schedule",null,null,null,null,null,null,null,{"$f":"\"\"& D10","v":"LNB"},null,null,{"$f":"\"\"& D11","v":"FSB"}]
[null,"Date","Advance","Interest Rate","Accrued Interest"," ","Interest Payment","Principal Payment","Ending Principal","Principal Pmt","Interest Pmt","Balance Owed"," Date","Accrued Int","Prin Payment","Int Payment","Balance","Current %"]
[null,{"$f":"IF(D7=\"\",\"\",+D7)","v":"2011-03-01"},{"$f":"IF(D5=\"\",\"\",+D5)","v":3500000},{"$f":"IF(+D9=\"\",\"\",D9)","v":0.05},0,null,0,0,{"$f":"C20","v":3500000},0,0,{"$f":"+D5-D12","v":2000000},{"$f":"+B20","v":"2011-03-01"},0,0,0,{"$f":"IF(M20=\"\",\"\",+I20*$D$13)","v":1500000},{"$f":"IF(B20=\"\",\"\",Q20/I20)","v":0.42857142857142855}]
[null,"2011-04-01",null,{"$f":"IF(B21=\"\",\"\",+D20)","v":0.05},{"$f":"IF(B21=\"\",\"\",ROUND(+I20*D20/365*(B21-B20),2)+E20-G20)","v":14863.01},null,{"$f":"IF(B21=\"\",\"\",0)","v":0},{"$f":"IF(B21=\"\",\"\",0)","v":0},{"$f":"IF(B21=\"\",\"\",+C21-H21+I20)","v":3500000},{"$f":"IF(OR(B21=\"\",H21=0),\"\",H21-O21)","v":""},{"$f":"IF(+OR(G21=\"\",P21=\"\"),\"\",F21-P21)","v":0},{"$f":"IF(+OR(B21=\"\",Q21=\"\"),\"\",I21-Q21)","v":2000000},"2011-04-01",{"$f":"IF(M21=\"\",\"\",Q20*D20/365*(M21-M20)+N20-P20)","v":6369.8630136986294},{"$f":"IF(M21=\"\",\"\",IF($A$14=1,+H21*$D$13,IF($A$14=2,H21,0)))","v":0},{"$f":"IF(M21=\"\",\"\",0)","v":0},{"$f":"IF(M21=\"\",\"\",+Q20-O21+(C21*$D$13))","v":1500000},0.42857142857142855]
[null,null,null,{"$f":"IF(B22=\"\",\"\",+D21)","v":""},{"$f":"IF(B22=\"\",\"\",ROUND(+I21*D21/365*(B22-B21),2)+E21-G21)","v":""},null,{"$f":"IF(B22=\"\",\"\",0)","v":""},{"$f":"IF(B22=\"\",\"\",0)","v":""},{"$f":"IF(B22=\"\",\"\",+C22-H22+I21)","v":""},{"$f":"IF(OR(B22=\"\",H22=0),\"\",H22-O22)","v":""},{"$f":"IF(+OR(G22=\"\",P22=\"\"),\"\",F22-P22)","v":""},{"$f":"IF(+OR(B22=\"\",Q22=\"\"),\"\",I22-Q22)","v":""},{"$f":"IF(B22=\"\",\"\",B22)","v":""},{"$f":"IF(M22=\"\",\"\",Q21*D21/365*(M22-M21)+N21-P21)","v":""},{"$f":"IF(M22=\"\",\"\",IF($A$14=1,+H22*$D$13,IF($A$14=2,H22,0)))","v":""},{"$f":"IF(M22=\"\",\"\",0)","v":""},{"$f":"IF(M22=\"\",\"\",+Q21-O22+(C22*$D$13))","v":""},""]

{"sheet":"201104","index":3,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[13,1,13,2],[17,9,17,11],[17,12,17,16],[10,1,10,2],[10,3,10,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[2,1,2,4],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4],[4,7,9,14],[5,1,5,2],[5,3,5,4],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4]]}
[null,"REPORT"]
[]
[null,"Loan Participation"]
[null,"Borrower",null,"Jason Public",null,null,null,null,null,"Comments:"]
[null,"Loan Amount",null,15000000]
[null,"Loan Number",null,"201104"]
[null,"Date of Participation",null,"2011-02-01"]
[null,"Maturity Date",null,"2021-02-01"]
[null,"Beg. Interest Rate",null,6.5000000000000002E-2]
[null,"Selling Bank",null,"FFB"]
[null,"Purchasing Bank",null,"LNB"]
[null,"Amount Purchased",null,6000000]
[null,"% Purchased",null,{"$f":"IF(D12=\"\",\"\",+D12/D5)","v":0.4}]
[3]
[]
[]
[null,null,"Today's Date",{"$f":"IF(D5=\"\",\"\",TODAY())","v":"2012-01-11"}]
[null,"Payment Schedule",null,null,null,null,null,null,null,{"$f":"\"\"& D10","v":"FFB"},null,null,{"$f":"\"\"& D11","v":"LNB"}]
[null,"Date","Advance","Interest Rate","Accrued Interest"," ","Interest Payment","Principal Payment","Ending Principal","Principal Pmt","Interest Pmt","Balance Owed"," Date","Accrued Int","Prin Payment","Int Payment","Balance","Current %"]
[null,{"$f":"IF(D7=\"\",\"\",+D7)","v":"2011-02-01"},{"$f":"IF(D5=\"\",\"\",+D5)","v":15000000},{"$f":"IF(+D9=\"\",\"\",D9)","v":6.5000000000000002E-2},0,null,0,0,{"$f":"C20","v":15000000},0,0,{"$f":"+D5-D12","v":9000000},{"$f":"+B20","v":"2011-02-01"},0,0,0,{"$f":"IF(M20=\"\",\"\",+I20*$D$13)","v":6000000},{"$f":"IF(B20=\"\",\"\",Q20/I20)","v":0.4}]
[null,null,null,{"$f":"IF(B21=\"\",\"\",+D20)","v":""},{"$f":"IF(B21=\"\",\"\",ROUND(+I20*D20/365*(B21-B20),2)+E20-G20)","v":""},null,{"$f":"IF(B21=\"\",\"\",0)","v":""},{"$f":"IF(B21=\"\",\"\",0)","v":""},{"$f":"IF(B21=\"\",\"\",+C21-H21+I20)","v":""},{"$f":"IF(OR(B21=\"\",H21=0),\"\",H21-O21)","v":""},{"$f":"IF(+OR(G21=\"\",P21=\"\"),\"\",F21-P21)","v":""},{"$f":"IF(+OR(B21=\"\",Q21=\"\"),\"\",I21-Q21)","v":""},{"$f":"IF(New!$B21=\"\",\"\",B21)","v":""},{"$f":"IF(M21=\"\",\"\",Q20*D20/365*(M21-M20)+N20-P20)","v":""},{"$f":"IF(M21=\"\",\"\",IF($A$14=1,+H21*$D$13,IF($A$14=2,H21,0)))","v":""},{"$f":"IF(M21=\"\",\"\",0)","v":""},{"$f":"IF(M21=\"\",\"\",+Q20-O21+(C21*$D$13))","v":""},""]
[null,null,null,{"$f":"IF(B22=\"\",\"\",+D21)","v":""},{"$f":"IF(B22=\"\",\"\",ROUND(+I21*D21/365*(B22-B21),2)+E21-G21)","v":""},null,{"$f":"IF(B22=\"\",\"\",0)","v":""},{"$f":"IF(B22=\"\",\"\",0)","v":""},{"$f":"IF(B22=\"\",\"\",+C22-H22+I21)","v":""},{"$f":"IF(OR(B22=\"\",H22=0),\"\",H22-O22)","v":""},{"$f":"IF(+OR(G22=\"\",P22=\"\"),\"\",F22-P22)","v":""},{"$f":"IF(+OR(B22=\"\",Q22=\"\"),\"\",I22-Q22)","v":""},{"$f":"IF(B22=\"\",\"\",B22)","v":""},{"$f":"IF(M22=\"\",\"\",Q21*D21/365*(M22-M21)+N21-P21)","v":""},{"$f":"IF(M22=\"\",\"\",IF($A$14=1,+H22*$D$13,IF($A$14=2,H22,0)))","v":""},{"$f":"IF(M22=\"\",\"\",0)","v":""},{"$f":"IF(M22=\"\",\"\",+Q21-O22+(C22*$D$13))","v":""},""]

{"sheet":"201103","index":4,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,7,9,14],[5,1,5,2],[5,3,5,4],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4],[2,1,2,4],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4],[13,1,13,2],[17,9,17,11],[17,12,17,16],[10,1,10,2],[10,3,10,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4]]}
[null,"REPORT"]
[]
[null,"Loan Participation"]
[null,"Borrower",null,"Jane Public",null,null,null,null,null,"Comments:"]
[null,"Loan Amount",null,550000]
[null,"Loan Number",null,"201103"]
[null,"Date of Participation",null,"2011-01-11"]
[null,"Maturity Date",null,"2021-01-11"]
[null,"Beg. Interest Rate",null,5.5E-2]
[null,"Selling Bank",null,"SNB"]
[null,"Purchasing Bank",null,"SSB"]
[null,"Amount Purchased",null,275000]
[null,"% Purchased",null,{"$f":"IF(D12=\"\",\"\",+D12/D5)","v":0.5}]
[1]
[]
[]
[null,null,"Today's Date",{"$f":"IF(D5=\"\",\"\",TODAY())","v":"2012-01-11"}]
[null,"Payment Schedule",null,null,null,null,null,null,null,{"$f":"\"\"& D10","v":"SNB"},null,null,{"$f":"\"\"& D11","v":"SSB"}]
[null,"Date","Advance","Interest Rate","Accrued Interest"," ","Interest Payment","Principal Payment","Ending Principal","Principal Pmt","Interest Pmt","Balance Owed"," Date","Accrued Int","Prin Payment","Int Payment","Balance","Current %"]
[null,{"$f":"IF(D7=\"\",\"\",+D7)","v":"2011-01-11"},{"$f":"IF(D5=\"\",\"\",+D5)","v":550000},{"$f":"IF(+D9=\"\",\"\",D9)","v":5.5E-2},0,null,0,0,{"$f":"C20","v":550000},0,0,{"$f":"+D5-D12","v":275000},{"$f":"+B20","v":"2011-01-11"},0,0,0,{"$f":"IF(M20=\"\",\"\",+I20*$D$13)","v":275000},{"$f":"IF(B20=\"\",\"\",Q20/I20)","v":0.5}]
[null,null,null,{"$f":"IF(B21=\"\",\"\",+D20)","v":""},{"$f":"IF(B21=\"\",\"\",ROUND(+I20*D20/365*(B21-B20),2)+E20-G20)","v":""},null,{"$f":"IF(B21=\"\",\"\",0)","v":""},{"$f":"IF(B21=\"\",\"\",0)","v":""},{"$f":"IF(B21=\"\",\"\",+C21-H21+I20)","v":""},{"$f":"IF(OR(B21=\"\",H21=0),\"\",H21-O21)","v":""},{"$f":"IF(+OR(G21=\"\",P21=\"\"),\"\",F21-P21)","v":""},{"$f":"IF(+OR(B21=\"\",Q21=\"\"),\"\",I21-Q21)","v":""},{"$f":"IF(New!$B21=\"\",\"\",B21)","v":""},{"$f":"IF(M21=\"\",\"\",Q20*D20/365*(M21-M20)+N20-P20)","v":""},{"$f":"IF(M21=\"\",\"\",IF($A$14=1,+H21*$D$13,IF($A$14=2,H21,0)))","v":""},{"$f":"IF(M21=\"\",\"\",0)","v":""},{"$f":"IF(M21=\"\",\"\",+Q20-O21+(C21*$D$13))","v":""},""]
[null,null,null,{"$f":"IF(B22=\"\",\"\",+D21)","v":""},{"$f":"IF(B22=\"\",\"\",ROUND(+I21*D21/365*(B22-B21),2)+E21-G21)","v":""},null,{"$f":"IF(B22=\"\",\"\",0)","v":""},{"$f":"IF(B22=\"\",\"\",0)","v":""},{"$f":"IF(B22=\"\",\"\",+C22-H22+I21)","v":""},{"$f":"IF(OR(B22=\"\",H22=0),\"\",H22-O22)","v":""},{"$f":"IF(+OR(G22=\"\",P22=\"\"),\"\",F22-P22)","v":""},{"$f":"IF(+OR(B22=\"\",Q22=\"\"),\"\",I22-Q22)","v":""},{"$f":"IF(B22=\"\",\"\",B22)","v":""},{"$f":"IF(M22=\"\",\"\",Q21*D21/365*(M22-M21)+N21-P21)","v":""},{"$f":"IF(M22=\"\",\"\",IF($A$14=1,+H22*$D$13,IF($A$14=2,H22,0)))","v":""},{"$f":"IF(M22=\"\",\"\",0)","v":""},{"$f":"IF(M22=\"\",\"\",+Q21-O22+(C22*$D$13))","v":""},""]

{"sheet":"201102","index":5,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[13,1,13,2],[17,9,17,11],[17,12,17,16],[10,1,10,2],[10,3,10,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[2,1,2,4],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4],[4,7,9,14],[5,1,5,2],[5,3,5,4],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4]]}
[null,"REPORT"]
[]
[null,"Loan Participation"]
[null,"Borrower",null,"James R. Public",null,null,null,null,null,"Comments:"]
[null,"Loan Amount",null,2000000]
[null,"Loan Number",null,"201102"]
[null,"Date of Participation",null,"2011-01-01"]
[null,"Maturity Date",null,"2021-01-01"]
[null,"Beg. Interest Rate",null,0.06]
[null,"Selling Bank",null,"CNB"]
[null,"Purchasing Bank",null,"FSB"]
[null,"Amount Purchased",null,1000000]
[null,"% Purchased",null,{"$f":"IF(D12=\"\",\"\",+D12/D5)","v":0.5}]
[2]
[]
[]
[null,null,"Today's Date",{"$f":"IF(D5=\"\",\"\",TODAY())","v":"2012-01-11"}]
[null,"Payment Schedule",null,null,null,null,null,null,null,{"$f":"\"\"& D10","v":"CNB"},null,null,{"$f":"\"\"& D11","v":"FSB"}]
[null,"Date","Advance","Interest Rate","Accrued Interest"," ","Interest Payment","Principal Payment","Ending Principal","Principal Pmt","Interest Pmt","Balance Owed"," Date","Accrued Int","Prin Payment","Int Payment","Balance","Current %"]
[null,{"$f":"IF(D7=\"\",\"\",+D7)","v":"2011-01-01"},{"$f":"IF(D5=\"\",\"\",+D5)","v":2000000},{"$f":"IF(+D9=\"\",\"\",D9)","v":0.06},0,null,0,0,{"$f":"C20","v":2000000},0,0,{"$f":"+D5-D12","v":1000000},{"$f":"+B20","v":"2011-01-01"},0,0,0,{"$f":"IF(M20=\"\",\"\",+I20*$D$13)","v":1000000},{"$f":"IF(B20=\"\",\"\",Q20/I20)","v":0.5}]
[null,null,null,{"$f":"IF(B21=\"\",\"\",+D20)","v":""},{"$f":"IF(B21=\"\",\"\",ROUND(+I20*D20/365*(B21-B20),2)+E20-G20)","v":""},null,{"$f":"IF(B21=\"\",\"\",0)","v":""},{"$f":"IF(B21=\"\",\"\",0)","v":""},{"$f":"IF(B21=\"\",\"\",+C21-H21+I20)","v":""},{"$f":"IF(OR(B21=\"\",H21=0),\"\",H21-O21)","v":""},{"$f":"IF(+OR(G21=\"\",P21=\"\"),\"\",F21-P21)","v":""},{"$f":"IF(+OR(B21=\"\",Q21=\"\"),\"\",I21-Q21)","v":""},{"$f":"IF(New!$B21=\"\",\"\",B21)","v":""},{"$f":"IF(M21=\"\",\"\",Q20*D20/365*(M21-M20)+N20-P20)","v":""},{"$f":"IF(M21=\"\",\"\",IF($A$14=1,+H21*$D$13,IF($A$14=2,H21,0)))","v":""},{"$f":"IF(M21=\"\",\"\",0)","v":""},{"$f":"IF(M21=\"\",\"\",+Q20-O21+(C21*$D$13))","v":""},""]
[null,null,null,{"$f":"IF(B22=\"\",\"\",+D21)","v":""},{"$f":"IF(B22=\"\",\"\",ROUND(+I21*D21/365*(B22-B21),2)+E21-G21)","v":""},null,{"$f":"IF(B22=\"\",\"\",0)","v":""},{"$f":"IF(B22=\"\",\"\",0)","v":""},{"$f":"IF(B22=\"\",\"\",+C22-H22+I21)","v":""},{"$f":"IF(OR(B22=\"\",H22=0),\"\",H22-O22)","v":""},{"$f":"IF(+OR(G22=\"\",P22=\"\"),\"\",F22-P22)","v":""},{"$f":"IF(+OR(B22=\"\",Q22=\"\"),\"\",I22-Q22)","v":""},{"$f":"IF(B22=\"\",\"\",B22)","v":""},{"$f":"IF(M22=\"\",\"\",Q21*D21/365*(M22-M21)+N21-P21)","v":""},{"$f":"IF(M22=\"\",\"\",IF($A$14=1,+H22*$D$13,IF($A$14=2,H22,0)))","v":""},{"$f":"IF(M22=\"\",\"\",0)","v":""},{"$f":"IF(M22=\"\",\"\",+Q21-O22+(C22*$D$13))","v":""},""]

{"sheet":"201101","index":6,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[13,1,13,2],[17,9,17,11],[17,12,17,16],[10,1,10,2],[10,3,10,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[2,1,2,4],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4],[4,7,9,14],[5,1,5,2],[5,3,5,4],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4]]}
[null,"REPORT"]
[]
[null,"Loan Participation"]
[null,"Borrower",null,"John Q Public",null,null,null,null,null,"Comments:"]
[null,"Loan Amount",null,1000000]
[null,"Loan Number",null,"201101"]
[null,"Date of Participation",null,"2011-01-01"]
[null,"Maturity Date",null,"2021-01-01"]
[null,"Beg. Interest Rate",null,0.05]
[null,"Selling Bank",null,"FNB"]
[null,"Purchasing Bank",null,"FSB"]
[null,"Amount Purchased",null,500000]
[null,"% Purchased",null,{"$f":"IF(D12=\"\",\"\",+D12/D5)","v":0.5}]
[1]
[]
[]
[null,null,"Today's Date",{"$f":"IF(D5=\"\",\"\",TODAY())","v":"2012-01-11"}]
[null,"Payment Schedule",null,null,null,null,null,null,null,{"$f":"\"\"& D10","v":"FNB"},null,null,{"$f":"\"\"& D11","v":"FSB"}]
[null,"Date","Advance","Interest Rate","Accrued Interest"," ","Interest Payment","Principal Payment","Ending Principal","Principal Pmt","Interest Pmt","Balance Owed"," Date","Accrued Int","Prin Payment","Int Payment","Balance","Current %"]
[null,{"$f":"IF(D7=\"\",\"\",+D7)","v":"2011-01-01"},{"$f":"IF(D5=\"\",\"\",+D5)","v":1000000},{"$f":"IF(+D9=\"\",\"\",D9)","v":0.05},0,null,0,0,{"$f":"C20","v":1000000},0,0,{"$f":"+D5-D12","v":500000},{"$f":"+B20","v":"2011-01-01"},0,0,0,{"$f":"IF(M20=\"\",\"\",+I20*$D$13)","v":500000},{"$f":"IF(B20=\"\",\"\",Q20/I20)","v":0.5}]
[null,"2011-02-01",50000,{"$f":"IF(B21=\"\",\"\",+D20)","v":0.05},{"$f":"IF(B21=\"\",\"\",ROUND(+I20*D20/365*(B21-B20),2)+E20-G20)","v":4246.58},null,{"$f":"IF(B21=\"\",\"\",0)","v":0},{"$f":"IF(B21=\"\",\"\",0)","v":0},{"$f":"IF(B21=\"\",\"\",+C21-H21+I20)","v":1050000},{"$f":"IF(OR(B21=\"\",H21=0),\"\",H21-O21)","v":""},{"$f":"IF(+OR(G21=\"\",P21=\"\"),\"\",F21-P21)","v":0},{"$f":"IF(+OR(B21=\"\",Q21=\"\"),\"\",I21-Q21)","v":525000},"2011-02-01",{"$f":"IF(M21=\"\",\"\",Q20*D20/365*(M21-M20)+N20-P20)","v":2123.2876712328766},{"$f":"IF(M21=\"\",\"\",IF($A$14=1,+H21*$D$13,IF($A$14=2,H21,0)))","v":0},{"$f":"IF(M21=\"\",\"\",0)","v":0},{"$f":"IF(M21=\"\",\"\",+Q20-O21+(C21*$D$13))","v":525000},0.5]
[null,"2011-03-01",2500000,{"$f":"IF(B22=\"\",\"\",+D21)","v":0.05},{"$f":"IF(B22=\"\",\"\",ROUND(+I21*D21/365*(B22-B21),2)+E21-G21)","v":8273.98},null,{"$f":"IF(B22=\"\",\"\",0)","v":0},{"$f":"IF(B22=\"\",\"\",0)","v":0},{"$f":"IF(B22=\"\",\"\",+C22-H22+I21)","v":3550000},{"$f":"IF(OR(B22=\"\",H22=0),\"\",H22-O22)","v":""},{"$f":"IF(+OR(G22=\"\",P22=\"\"),\"\",F22-P22)","v":0},{"$f":"IF(+OR(B22=\"\",Q22=\"\"),\"\",I22-Q22)","v":1775000},"2011-03-01",{"$f":"IF(M22=\"\",\"\",Q21*D21/365*(M22-M21)+N21-P21)","v":4136.9863013698632},{"$f":"IF(M22=\"\",\"\",IF($A$14=1,+H22*$D$13,IF($A$14=2,H22,0)))","v":0},{"$f":"IF(M22=\"\",\"\",0)","v":0},{"$f":"IF(M22=\"\",\"\",+Q21-O22+(C22*$D$13))","v":1775000},0.5]
[null,"2011-04-01",null,{"$f":"IF(B23=\"\",\"\",+D22)","v":0.05},{"$f":"IF(B23=\"\",\"\",ROUND(+I22*D22/365*(B23-B22),2)+E22-G22)","v":23349.32},null,10000,50000,{"$f":"IF(B23=\"\",\"\",+C23-H23+I22)","v":3500000},{"$f":"IF(H23=\"\",\"\",IF($D$14=1,+H23*(1-$D$13),IF($D$14=2,0,H23)))","v":50000},{"$f":"IF(B23=\"\",\"\",0)","v":0},{"$f":"IF(B23=\"\",\"\",IF($D$14=1,L22-((1-$D$13)*H23),IF($D$14=2,L22,+L22-H23)))","v":1725000},"2011-04-01",{"$f":"IF(M23=\"\",\"\",Q22*D22/365*(M23-M22)-P22)","v":7537.6712328767126},25000,{"$f":"IF(M23=\"\",\"\",+G23-K23)","v":10000},{"$f":"IF(M23=\"\",\"\",+Q22-O23)","v":1750000},0.5]

{"sheet":"Banks","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Seller","Seller","Purchaser","Buying"]
[{"$f":"Selling_Bank","v":"FNB"},"FNB",{"$f":"Purchasing__Bank","v":"FSB"},"FSB"]
["CNB","CNB","FSB","SSB",""]
["SNB","SNB","SSB","LNB"]
["FFB","FFB","LNB",""]
["LNB","LNB","FSB"]
["","",""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]