{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Calculation","index":0,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,3,29,7],[30,3,44,7],[5,11,7,11],[0,6,0,7],[1,6,1,7],[15,3,15,4],[5,4,5,5],[10,3,10,4],[11,3,11,4],[6,4,6,5],[13,3,13,4],[14,3,14,4]]}
[null,null,null,"Hire Purchase Interest on Early Payout",null,null,"Client Name"]
[null,null,null,"Year Ended 30 June 2017",null,null,"Preparer Name"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Calculation of Interest Paid"]
[null,null,null,"Lending Institution",null,null,"Date Acquired",null,null,null,null,"Exclude any borrowing expenses from repayments and amount borrowed if they have been claimed separately."]
[null,null,null,"Asset Purchased",null,null,"Date Paid Out"]
[]
[]
[null,null,null,"Calculation of Interest Paid on Finance",null,"Amount","Number"]
[null,null,null,"First Payment",null,null,1,{"$f":"F11*G11","v":0}]
[null,null,null,"Regular Monthly Repayments",null,null,null,{"$f":"F12*G12","v":0}]
[null,null,null,"Structured/Lump Sum Repayments (total)"]
[null,null,null,"Final Payment (payout amount)",null,null,1,{"$f":"F14*G14","v":0}]
[null,null,null,"Total Repayments Made",null,null,null,{"$f":"SUM(H11:H14)","v":0}]
[null,null,null,"Less Amount Borrowed"]
[null,null,null,"Interest Paid on Finance",null,null,null,{"$f":"H15-H16","v":0}]
[]
[null,null,null,"Less Interest Claimed in Prior Years",null,{"$f":"IF(AND(H6>0,MONTH(H6)<=6),YEAR(H6),IF(H6>0,YEAR(H6)+1,0))","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(F19<2016,F19>1900),F19+1,0)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,{"$f":"SUM(G19:G26)","v":0}]
[null,null,null,"Interest Claimable in the Year of Payout",null,null,null,{"$f":"H17-H26","v":0}]
[]
[]
[null,null,null,"Notes"]