{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["PPMT Function Quick View","Capital Payment","Calculating Desired Balance","VBA Macro Code","PPMT PMT IPMT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"PPMT Function Quick View","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,2],[8,5,8,6],[10,5,10,6],[11,5,11,6],[1,1,1,3],[2,1,2,3],[5,2,5,3],[6,2,7,3]]}
[]
[null,"Excel PPMT Function"]
[null,"Quick Overview"]
[]
[null,"Annual Payment (Principal in1st Period)"]
[null,{"$f":"PPMT(D11,D12,D13,-D10)","v":1196.3025572174377},">>Formula>> =PPMT(D11,D12,D13,-D10)"]
[null,null,"**D11=rate, D12=per, D13=nper, D10=pv"]
[]
[null,"Description","Referring Argument","Values",null,"Monthly Payment"]
[null,"Loan Amount","pv",20000,null,"Principal in 1st Period",{"$f":"-PPMT(D11/12,D12,D12*D13,D10)","v":783.32782740271966}]
[null,"Annual Interest Rate","rate",7.0000000000000007E-2,null,"Used Formula= -PPMT(D11/12,D12,D12*D13,D10)"]
[null,"Loan Term (in years)","per",2,null,"**D11=rate, D12=per, D13=nper, D10=pv"]
[null,"Payments Per Year","nper",12]
[null,"Desired Cash Balance (after last payment)","[fv]","---"]
[null,"Payment Type","[type] (0-end of period, 1-beginning of the period)",0]
[]
[null,"**Financial Function"]
[null,"**Get Principal Payment in a Given Period"]

{"sheet":"Capital Payment","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6]]}
[]
[null,"Excel PPMT Function"]
[null,"Calculating Capital Payments During a Period"]
[]
[null,"Description","Argument","Values",null,"Period","Capital Payment"]
[null,"Loan Amount",778.78491539623906,20000,null,1,{"$f":"PPMT($D$7/$D$9,F6,$D$8*$D$9,-$D$6)","v":4870.6473455240239}]
[null,"Annual Interest Rate","rate",7.0000000000000007E-2,null,2,{"$f":"PPMT($D$7/$D$9,F7,$D$8*$D$9,-$D$6)","v":4955.8836740706938}]
[null,"Loan Term (in years)","per",1,null,3,5042.6116383669305]
[null,"Payments Per Year","nper",4,null,4,5130.8573420383527]
[null,"Desired Cash Balance (after last payment)","[fv]","--",null,"Total Sum",{"$f":"SUM(G6:G9)","v":20000}]
[null,"Payment Type","[type] (0-end of period, 1-beginning of the period)",0]

{"sheet":"Calculating Desired Balance","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6]]}
[]
[null,"Excel PPMT Function"]
[null,"Calculates Capital Payments to End Up a Balance"]
[]
[null,"Description","Argument","Values",null,"Period","Capital Payment"]
[null,"Loan Amount","pv",0,null,1,{"$f":"PPMT($D$7/$D$9,F6,$D$8*$D$9,$D$6,$D$10,$D$11)","v":-2350.8584667044747}]
[null,"Annual Interest Rate","rate",7.0000000000000007E-2,null,2,{"$f":"PPMT($D$7/$D$9,F7,$D$8*$D$9,$D$6,$D$10,$D$11)","v":-2391.998489871803}]
[null,"Loan Term (in years)","per",2,null,3,-2433.8584634445601]
[null,"Payments Per Year","nper",4,null,4,-2476.4509865548393]
[null,"Desired Cash Balance (after last payment)","[fv]",20000,null,5,-2519.7888788195492]
[null,"Payment Type","[type] (0-end of period, 1-beginning of the period)",0,null,6,-2563.8851841988912]
[null,null,null,null,null,7,-2608.7531749223717]
[null,null,null,null,null,8,-2654.4063554835134]
[null,null,null,null,null,"Total Sum",{"$f":"SUM(G6:G13)","v":-20000}]

{"sheet":"VBA Macro Code","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3],[6,2,6,3]]}
[]
[null,"Excel PPMT Function"]
[null,"Used in VBA Macro"]
[]
[null,null,"Monthly Payment (Principal in1st Period)"]
[null,null,63.098987503818321]
[]
[null,"Description","Referring Argument","Values"]
[null,"Loan Amount","pv",20000]
[null,"Annual Interest Rate","rate",7.0000000000000007E-2]
[null,"Loan Term (in years)","per",15]
[null,"Payments Per Year","nper",12]
[null,"Desired Cash Balance (after last payment)","[fv]",0]
[null,"Payment Type","[type] (0-end of period, 1-beginning of the period)",0]

{"sheet":"PPMT PMT IPMT","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,12]]}
[]
[null," Differentiate Between PMT, PPMT and IPMT"]
[]
[null,"Description","Argument","Values",null,"Period","PPMT",null,"Period","PMT",null,"Period","IPMT"]
[null,"Loan Amount",778.78491539623906,20000,null,1,{"$f":"PPMT($D$6/$D$8,F5,$D$7*$D$8,-$D$5,0,0)","v":4870.6473455240239},null,1,{"$f":"PMT($D$6/$D$8,$D$7*$D$8,-$D$5,0,0)","v":5220.6473455240239},null,1,{"$f":"IPMT($D$6/$D$8,L5,$D$7*$D$8,-$D$5,0,0)","v":350.00000000000006}]
[null,"Annual Interest Rate","rate",7.0000000000000007E-2,null,2,{"$f":"PPMT($D$6/$D$8,F6,$D$7*$D$8,-$D$5,0,0)","v":4955.8836740706938},null,2,{"$f":"PMT($D$6/$D$8,$D$7*$D$8,-$D$5,0,0)","v":5220.6473455240239},null,2,{"$f":"IPMT($D$6/$D$8,L6,$D$7*$D$8,-$D$5,0,0)","v":264.76367145332961}]
[null,"Loan Term (in years)","per",1,null,3,5042.6116383669305,null,3,5220.6473455240239,null,3,178.03570715709247]
[null,"Payments Per Year","nper",4,null,4,5130.8573420383527,null,4,5220.6473455240239,null,4,89.790003485671178]
[null,"Desired Cash Balance (after last payment)","[fv]","--",null,"Total Sum",{"$f":"SUM(G5:G8)","v":20000},null,"Total Sum",{"$f":"SUM(J5:J8)","v":20882.589382096096},null,"Total Sum",{"$f":"SUM(M5:M8)","v":882.58938209609323}]
[null,"Payment Type","[type] (0-end of period, 1-beginning of the period)",0]