{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Query","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Query","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Input ","Yearly Amount ",10000]
[null,null,"Rate of Interest ",7.0000000000000007E-2]
[null,null,"No of Years ",8]
[]
[]
[null,null,"Principals Paid","Interest ","Total"]
[null,"Total Return",{"$f":"SUBTOTAL(9,C11:C18)","v":80000},{"$f":"SUBTOTAL(9,D11:D18)","v":29779.88},{"$f":"C7+D7","v":109779.88}]
[]
[]
["Year","Opening","Add","Interest","Total"]
[1,0,10000,{"$f":"ROUND(C11*$D$2,2)","v":700},{"$f":"ROUND(C11+D11,2)","v":10700}]
[2,{"$f":"+E11","v":10700},{"$f":"+C11","v":10000},{"$f":"ROUND((C12+B12)*$D$2,2)","v":1449},{"$f":"ROUND(B12+C12+D12,2)","v":22149}]
[3,{"$f":"+E12","v":22149},{"$f":"+C12","v":10000},{"$f":"ROUND((C13+B13)*$D$2,2)","v":2250.4299999999998},{"$f":"ROUND(B13+C13+D13,2)","v":34399.43}]
[4,34399.43,10000,{"$f":"ROUND((C14+B14)*$D$2,2)","v":3107.96},47507.39]
[5,47507.39,10000,{"$f":"ROUND((C15+B15)*$D$2,2)","v":4025.52},61532.91]
[6,61532.91,10000,{"$f":"ROUND((C16+B16)*$D$2,2)","v":5007.3},76540.210000000006]
[7,76540.210000000006,10000,{"$f":"ROUND((C17+B17)*$D$2,2)","v":6057.81},92598.02]
[8,92598.02,10000,{"$f":"ROUND((C18+B18)*$D$2,2)","v":7181.86},109779.88]
[]
[]
[null,"Total",{"$f":"SUM(C11:C20)","v":80000},{"$f":"SUM(D11:D20)","v":29779.88}]

{"sheet":"Sheet1","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Respected  All Excel Guru's "]
[]
[null,"In my attached file I want that in D3 column if I change years "]
[null,"i.e. -- if I write 10 Years then automatically"]
[null,"10 Years calculation done "]
[]
[null,"that is it calculate from raw 11 to 20 & show final in total"]
[]
[null,"The same way it automatically caluclate what ever we put value "]
[]
[null,"If we put 20 years . It shows for 21 Years "]
[]
[]
[null,"Thanks a lot & have a nice day to all "]
[]
[]
[]
[null,"Interest calculation as per we put years in -- D3"]