{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["dataset","quick view","yearly","optional argument","optional1","semi-annual","Quarterly","Monthly","weekly","Table","VBA","practice"],"not_rendered":{"charts":0,"images":0,"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":"dataset","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Bank Statement of a Company"]
[]
[null,"Loan (PV)","Loan (FV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)"]
[null,1000,500,0.05,7]
[null,5000,2000,0.04,8]
[null,8000,3000,0.05,4]
[null,9000,2000,0.03,6]
[null,4000,1000,7.0000000000000007E-2,10]
[null,7000,2000,0.03,9]

{"sheet":"quick view","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,1,1,8],[14,1,14,8]]}
[null,"IPMT Function"]
[null,"=IPMT(rate,per,nper,pv,[fv],[type])"]
[]
[null,"rate","per","nper","pv","[fv]","[type]","Formula","Output"]
[null,0.05,1,8,5000,null,null,{"$f":"_xlfn.FORMULATEXT(I5)","v":"=IPMT(B5,C5,D5,E5)"},{"$f":"IPMT(B5,C5,D5,E5)","v":-250}]
[null,0.05,1,8,5000,2000,null,{"$f":"_xlfn.FORMULATEXT(I6)","v":"=IPMT(B6,C6,D6,E6,F6)"},{"$f":"IPMT(B6,C6,D6,E6,F6)","v":-249.99999999999997}]
[null,0.05,1,8,5000,2000,0,{"$f":"_xlfn.FORMULATEXT(I7)","v":"=IPMT(B7,C7,D7,E7,F7,G7)"},{"$f":"IPMT(B7,C7,D7,E7,F7,G7)","v":-249.99999999999997}]
[null,0.05,1,8,5000,2000,1,{"$f":"_xlfn.FORMULATEXT(I8)","v":"=IPMT(B8,C8,D8,E8,F8,G8)"},{"$f":"IPMT(B8,C8,D8,E8,F8,G8)","v":0}]
[null,0.06,1,8,5000,null,null,{"$f":"_xlfn.FORMULATEXT(I9)","v":"=IPMT(B9,C9,D9,E9)"},{"$f":"IPMT(B9,C9,D9,E9)","v":-300}]
[null,0.06,4,8,5000,null,1,{"$f":"_xlfn.FORMULATEXT(I10)","v":"=IPMT(B10,C10,D10,E10,,G10)"},{"$f":"IPMT(B10,C10,D10,E10,,G10)","v":-191.98357726002345}]
[null,0.06,10,8,5000,null,null,{"$f":"_xlfn.FORMULATEXT(I11)","v":"=IPMT(B11,C11,D11,E11)"},{"$f":"IPMT(B11,C11,D11,E11)","v":{"$error":"#NUM!"}}]
[null,0.06,3,8,10000,2000,1,{"$f":"_xlfn.FORMULATEXT(I12)","v":"=IPMT(B12,C12,D12,E12,F12,G12)"},{"$f":"IPMT(B12,C12,D12,E12,F12,G12)","v":-424.66366968329703}]
[null,0.06,3,8,10000,2000,0,{"$f":"_xlfn.FORMULATEXT(I13)","v":"=IPMT(B13,C13,D13,E13,F13,G13)"},{"$f":"IPMT(B13,C13,D13,E13,F13,G13)","v":-450.14348986429491}]
[]
[null,"The IPMT Function returns interest payment for a certain period"]

{"sheet":"yearly","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Without Optional Argument"]
[]
[null,"Loan (PV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,0.05,7,{"$f":"IPMT(C5,1,D5,B5)","v":-50}]
[null,5000,0.04,8,-200]
[null,8000,0.05,4,-400]
[null,9000,0.03,6,-270]
[null,4000,7.0000000000000007E-2,10,-280]
[null,7000,0.03,9,-210]

{"sheet":"optional argument","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"With Optional Argument"]
[]
[null,"Loan (PV)","Loan (FV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,500,0.05,7,{"$f":"IPMT(D5,2,E5,B5,C5,0)","v":-40.788513616537195}]
[null,5000,2000,0.04,8,{"$f":"IPMT(D6,2,E6,B6,C6,0)","v":-169.6122070269204}]
[null,8000,3000,0.05,4,-272.3934920680955]
[null,9000,2000,0.03,6,-218.98282485144145]
[null,4000,1000,7.0000000000000007E-2,10,-254.66787404542239]
[null,7000,2000,0.03,9,-183.42285860511211]

{"sheet":"optional1","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"With Optional Argument"]
[]
[null,"Loan (PV)","Loan (FV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,500,0.05,7,{"$f":"IPMT(D5,2,E5,B5,C5,1)","v":-38.846203444321134}]
[null,5000,2000,0.04,8,{"$f":"IPMT(D6,2,E6,B6,C6,1)","v":-163.08866060280809}]
[null,8000,3000,0.05,4,-259.42237339818615]
[null,9000,2000,0.03,6,-212.6046843217878]
[null,4000,1000,7.0000000000000007E-2,10,-238.00735892095551]
[null,7000,2000,0.03,9,-178.08044524768164]

{"sheet":"semi-annual","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"For Semi-Annually Interest Payment"]
[]
[null,"Loan (PV)","Loan (FV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,500,0.05,7,{"$f":"IPMT(D5/2,2,E5*2,B5)","v":-23.486586877283678}]
[null,5000,2000,0.04,8,{"$f":"IPMT(D6/2,2,E6*2,B6)","v":-94.634987413173846}]
[null,8000,3000,0.05,4,-177.10653083358048]
[null,9000,2000,0.03,6,-124.64820095765907]
[null,4000,1000,7.0000000000000007E-2,10,-135.04944925037634]
[null,7000,2000,0.03,9,-99.875392914652636]

{"sheet":"Quarterly","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"For Quarterly Interest Payment"]
[]
[null,"Loan (PV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,0.05,7,{"$f":"IPMT(C5/4,3,D5*4,B5)","v":-11.744089079859922}]
[null,5000,0.04,8,{"$f":"IPMT(C6/4,3,D6*4,B6)","v":-47.319575982159954}]
[null,8000,0.05,4,-88.559597187408144]
[null,9000,0.03,6,-62.325728766532798]
[null,4000,7.0000000000000007E-2,10,-67.532503938021165]
[null,7000,0.03,9,-49.938960050971374]

{"sheet":"Monthly","index":7,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"For Monthly Interest Payment"]
[]
[null,"Loan (PV)","Loan (FV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,500,0.05,7,{"$f":"IPMT(D5/12,6,E5*12,B5,C5,1)","v":-3.8365980425819317}]
[null,5000,2000,0.04,8,{"$f":"IPMT(D6/12,6,E6*12,B6,C6,1)","v":-15.574646993966962}]
[null,8000,3000,0.05,4,-28.854249178962068]
[null,9000,2000,0.03,6,-20.694135489437201]
[null,4000,1000,7.0000000000000007E-2,10,-22.350513818174058]
[null,7000,2000,0.03,9,-16.54542599420494]

{"sheet":"weekly","index":8,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"For Weekly Interest Payment"]
[]
[null,"Loan (PV)","Loan (FV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,500,0.05,7,{"$f":"IPMT(D5/52,14,E5*52,B5,C5,1)","v":-0.91736131762068707}]
[null,5000,2000,0.04,8,{"$f":"IPMT(D6/52,14,E6*52,B6,C6,1)","v":-3.6998029337692011}]
[null,8000,3000,0.05,4,-7.0845657917757903]
[null,9000,2000,0.03,6,-4.9472014812083245]
[null,4000,1000,7.0000000000000007E-2,10,-5.2602909810973379]
[null,7000,2000,0.03,9,-3.9100936570788516]

{"sheet":"Table","index":9,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Table option"]
[]
[null,"Loan (PV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,0.05,7,{"$f":"IPMT(Table1[[#This Row],[Rate of Interest\n(Annual)]],1,Table1[[#This Row],[Total Payment\n(Annual)]],Table1[[#This Row],[Loan (PV)]])","v":-50}]
[null,5000,0.04,8,{"$f":"IPMT(Table1[[#This Row],[Rate of Interest\n(Annual)]],1,Table1[[#This Row],[Total Payment\n(Annual)]],Table1[[#This Row],[Loan (PV)]])","v":-200}]
[null,8000,0.05,4,{"$f":"IPMT(Table1[[#This Row],[Rate of Interest\n(Annual)]],1,Table1[[#This Row],[Total Payment\n(Annual)]],Table1[[#This Row],[Loan (PV)]])","v":-400}]
[null,9000,0.03,6,{"$f":"IPMT(Table1[[#This Row],[Rate of Interest\n(Annual)]],1,Table1[[#This Row],[Total Payment\n(Annual)]],Table1[[#This Row],[Loan (PV)]])","v":-270}]
[null,4000,7.0000000000000007E-2,10,{"$f":"IPMT(Table1[[#This Row],[Rate of Interest\n(Annual)]],1,Table1[[#This Row],[Total Payment\n(Annual)]],Table1[[#This Row],[Loan (PV)]])","v":-280}]
[null,7000,0.03,9,{"$f":"IPMT(Table1[[#This Row],[Rate of Interest\n(Annual)]],1,Table1[[#This Row],[Total Payment\n(Annual)]],Table1[[#This Row],[Loan (PV)]])","v":-210}]

{"sheet":"VBA","index":10,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"VBA Code"]
[]
[null,"Loan (PV)","Loan (FV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,500,0.05,7,-50]
[null,5000,2000,0.04,8,-200]
[null,8000,3000,0.05,4,-400]
[null,9000,2000,0.03,6,-269.99999999999994]
[null,4000,1000,7.0000000000000007E-2,10,-280]
[null,7000,2000,0.03,9,-210]

{"sheet":"practice","index":11,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Practice"]
[]
[null,"Loan (PV)","Loan (FV)","Rate of Interest\n(Annual)","Total Payment\n(Annual)","Interest\nPayment"]
[null,1000,500,0.05,7]
[null,5000,2000,0.04,8]
[null,8000,3000,0.05,4]
[null,9000,2000,0.03,6]
[null,4000,1000,7.0000000000000007E-2,10]
[null,7000,2000,0.03,9]