{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Loan Information","Schedule","TIL Info"],"not_rendered":{"charts":1,"images":6,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,1,3,5],[6,1,6,11]]}
["Joe's Loans"]
["Loan Application"]
[]
[null,"Use this application to prepare a Loan Application for a potential borrower. Use the menu below to open the data entry form to enter and edit information about the borrower, the collateral, and the proposed loan."]
[]
[]
[null,"Use the menu buttons below to complete a loan proposal. From this menu you can\nenter and edit the required information and display the payment schedule"]
[]
[]
[null,null,"1. Enter Borrower, Property, and Loan Information"]
[]
[]
[]
[null,null,"2. Create and/or View the Loan Repayment Schedule"]
[]
[]
[]
[null,null,"3. Create and/or View the Truth-in-Lending Disclosure"]

{"sheet":"Loan Information","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Joe's Loans"]
["Loan Information Sheet"]
[]
["Customer Name:","Joe",null,null,"Loan Principal:",1000]
["Customer ID:","Joe"]
[null,null,null,null,"Loan Rate:",0.19500000000000001]
["Street Address:",123]
["City:","Conway",null,null,"Loan Term:",2]
["State:","sc"]
["Zip Code:",29427]
["Home Telephone:","555-1212",null,null,"Collateral:","Camper/Motorhome"]

{"sheet":"Schedule","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Joe's Loans"]
[]
[null,"Loan Principal:",{"$f":"'Loan Information'!F4","v":1000}]
[null,"Loan Rate:",{"$f":"'Loan Information'!F6","v":0.19500000000000001}]
[null,"Loan Term:",{"$f":"'Loan Information'!F8","v":2}]
[null,"Payment:",50.651876602106277]
[]
[]
["Payment Number","Principal Payment","Interest Payment","Cumulative Principal","Cumulative Interest","Total Paid","Balance"]
[1,34.4,16.25,34.4,16.25,50.65,965.6]
[2,34.96,15.69,69.36,31.94,101.3,930.64]
[3,35.53,15.12,104.89,47.06,151.94999999999999,895.11]
[4,36.11,14.55,141,61.61,202.61,859]
[5,36.69,13.96,177.69,75.569999999999993,253.26,822.31]
[6,37.29,13.36,214.98,88.93,303.91000000000003,785.02]
[7,37.9,12.76,252.88,101.69,354.57,747.12]
[8,38.51,12.14,291.39,113.83,405.22,708.61]
[9,39.14,11.52,330.53,125.35,455.88,669.47]
[10,39.770000000000003,10.88,370.3,136.22999999999999,506.53,629.70000000000005]
[11,40.42,10.23,410.72,146.46,557.17999999999995,589.28]
[12,41.08,9.58,451.8,156.04,607.84,548.20000000000005]
[13,41.74,8.91,493.54,164.95,658.49,506.46]
[14,42.42,8.23,535.96,173.18,709.14,464.04]
[15,43.11,7.54,579.07000000000005,180.72,759.79,420.93]
[16,43.81,6.84,622.88,187.56,810.44,377.12]
[17,44.52,6.13,667.4,193.69,861.09,332.6]
[18,45.25,5.4,712.65,199.09,911.74,287.35000000000002]
[19,45.98,4.67,758.63,203.76,962.39,241.37]
[20,46.73,3.92,805.36,207.68,1013.04,194.64]
[21,47.49,3.16,852.85,210.84,1063.69,147.15]
[22,48.26,2.39,901.11,213.23,1114.3399999999999,98.89]
[23,49.05,1.61,950.16,214.84,1165,49.84]
[24,49.84,0.81,1000,215.65,1215.6500000000001,0]

{"sheet":"TIL Info","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,0,12,3],[14,0,15,0],[14,1,15,1],[13,2,13,3]]}
["Joe's Loans"]
[]
[]
["Date:",{"$f":"NOW()","v":"2011-06-20T12:41:57"}]
["Creditor:","Joe's Loans"]
["Borrower:",{"$f":"'Loan Information'!B4","v":"Joe"}]
["Collateral:",{"$f":"'Loan Information'!F11","v":"Camper/Motorhome"}]
[null,null,null,null,null,"`"]
[]
["Annual Percentage Rate\nThe cost of your credit as a yearly Rate","Finance Charge\nThe dollar amount the credit will cost you","Amount Financed\nThe amount of credit provided to you on your behalf","Total of Payments\nThe amount you will have paid after you have made all scheduled payments"]
[{"$f":"'Loan Information'!F6","v":0.19500000000000001},{"$f":"-CUMIPMT(A11/12,A15,C11,1,A15,0)","v":215.64503845055629},{"$f":"'Loan Information'!F4","v":1000},{"$f":"B11+C11","v":1215.6450384505563}]
[]
["Payment Schedule"]
["Number of Payments","Amount of Payments","When Payments are Due"]
[{"$f":"'Loan Information'!F8*12","v":24},{"$f":"Schedule!C6","v":50.651876602106277},"First:",{"$f":"B4+15","v":"2011-07-05T12:41:57"}]
[null,null,"Last:",{"$f":"DATE(YEAR(D15),MONTH(D15)+A15,DAY(D15))","v":"2013-07-05"}]