{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Aufgabe 1","Sheet2","Sheet3"],"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":"Aufgabe 1","index":0,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Jahr","Restdarlehen","Tilgung","Kredit-Zinsen","jaehrlicher Rueckzahlbetrag",null,"Mit Excel-FV()-Funktion:",null,"Mit VBA:"]
[null,0,100000,null,0.04]
[null,1,{"$f":"C6*(1+$E$6)-F7","v":94000},{"$f":"F7-E7","v":6000},{"$f":"C6*$E$6","v":4000},10000,null,{"$f":"FV($E$6,B7,-F7,$C$6)","v":-93999.999999999985},null,-94000]
[null,2,{"$f":"C7*(1+$E$6)-F8","v":87760},{"$f":"F8-E8","v":6240},{"$f":"C7*$E$6","v":3760},10000,null,{"$f":"FV($E$6,B8,-F8,$C$6)","v":-87759.999999999985},null,-87759.999999999985]
[null,3,81270.400000000009,6489.6,3510.4,10000,null,-81270.399999999994,null,-81270.399999999994]
[null,4,74521.216000000015,6749.1839999999993,3250.8160000000003,10000,null,-74521.215999999957,null,-74521.215999999971]
[null,5,67502.064640000011,7019.1513599999998,2980.8486400000006,10000,null,-67502.064639999939,null,-67502.064639999982]
[null,6,60202.147225600012,7299.917414399999,2700.0825856000006,10000,null,-60202.14722559994,null,-60202.147225599947]
[null,7,52610.233114624018,7591.9141109759994,2408.0858890240006,10000,null,-52610.233114623974,null,-52610.233114623959]
[null,8,44714.642439208983,7895.5906754150392,2104.4093245849608,10000,null,-44714.642439208881,null,-44714.642439208917]
[null,9,36503.228136777347,8211.41430243164,1788.5856975683594,10000,null,-36503.228136777208,null,-36503.228136777259]
[null,10,27963.357262248443,8539.8708745289059,1460.1291254710939,10000,null,-27963.357262248319,null,-27963.357262248348]

{"sheet":"Sheet2","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"`"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}