{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Annuitätentilgung"],"not_rendered":{"charts":1,"images":1,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Annuitätentilgung","index":0,"n_rows":39,"n_cols":10,"rows_kept":39,"merged":[[1,1,1,15],[4,2,4,4],[5,2,5,4],[5,6,5,7],[6,2,6,4],[6,6,6,7],[8,2,8,4],[30,1,30,8],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[38,0,38,16]]}
[]
[null,"Annuitätentilgung"]
[]
[]
[null,null,"Anfangskapital",null,null,{"v":50000,"d":"50,000.00 "}]
[null,null,"Zinsen (pro Jahr)",null,null,{"v":0.075,"d":"7.50%"},"pro Quartal:",null,{"$f":"F6/4","v":{"v":0.01875,"d":"1.875%"}}]
[null,null,"Jahre",null,null,4,"Quartale",null,{"$f":"F7*4","v":16}]
[]
[null,null,"Annuität",null,null,{"$f":"PMT(I6,I7,F5)*-1","v":{"v":3646.1425355491965,"d":"3,646.14 €"}}]
[]
[]
[null,"Periode","Jahr","Quartal","Anfangs.k","Annuität","Zinsen","Tilung","End.k"]
[null,1,"X1","Q1",{"$f":"F5","v":{"v":50000,"d":"50,000.00 "}},{"$f":"$F$9","v":{"v":3646.1425355491965,"d":"3,646.14 "}},{"$f":"E13*$I$6","v":{"v":937.5,"d":"937.50 "}},{"$f":"F13-G13","v":{"v":2708.6425355491965,"d":"2,708.64 "}},{"$f":"E13-H13","v":{"v":47291.357464450804,"d":"47,291.36 "}}]
[null,{"$f":"B13+1","v":2},"X1","Q2",{"$f":"I13","v":{"v":47291.357464450804,"d":"47,291.36 "}},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":886.7129524584526,"d":"886.71 "},{"$f":"F14-G14","v":{"v":2759.429583090744,"d":"2,759.43 "}},{"$f":"E14-H14","v":{"v":44531.92788136006,"d":"44,531.93 "}}]
[null,{"$f":"B14+1","v":3},"X1","Q3",{"$f":"I14","v":{"v":44531.92788136006,"d":"44,531.93 "}},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":834.9736477755011,"d":"834.97 "},{"$f":"F15-G15","v":{"v":2811.168887773695,"d":"2,811.17 "}},{"$f":"E15-H15","v":{"v":41720.758993586365,"d":"41,720.76 "}}]
[null,4,"X1","Q4",{"v":41720.758993586365,"d":"41,720.76 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":782.2642311297443,"d":"782.26 "},{"v":2863.8783044194524,"d":"2,863.88 "},{"v":38856.880689166916,"d":"38,856.88 "}]
[null,5,"X2","Q1",{"v":38856.880689166916,"d":"38,856.88 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":728.5665129218796,"d":"728.57 "},{"v":2917.576022627317,"d":"2,917.58 "},{"v":35939.304666539596,"d":"35,939.30 "}]
[null,6,"X2","Q2",{"v":35939.304666539596,"d":"35,939.30 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":673.8619624976174,"d":"673.86 "},{"v":2972.2805730515793,"d":"2,972.28 "},{"v":32967.02409348801,"d":"32,967.02 "}]
[null,7,"X2","Q3",{"v":32967.02409348801,"d":"32,967.02 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":618.1317017529002,"d":"618.13 "},{"v":3028.0108337962965,"d":"3,028.01 "},{"v":29939.013259691717,"d":"29,939.01 "}]
[null,8,"X2","Q4",{"v":29939.013259691717,"d":"29,939.01 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":561.3564986192197,"d":"561.36 "},{"v":3084.786036929977,"d":"3,084.79 "},{"v":26854.22722276174,"d":"26,854.23 "}]
[null,9,"X3","Q1",{"v":26854.22722276174,"d":"26,854.23 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":503.5167604267826,"d":"503.52 "},{"v":3142.625775122414,"d":"3,142.63 "},{"v":23711.601447639325,"d":"23,711.60 "}]
[null,10,"X3","Q2",{"v":23711.601447639325,"d":"23,711.60 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":444.5925271432373,"d":"444.59 "},{"v":3201.550008405959,"d":"3,201.55 "},{"v":20510.051439233364,"d":"20,510.05 "}]
[null,11,"X3","Q3",{"v":20510.051439233364,"d":"20,510.05 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":384.56346448562556,"d":"384.56 "},{"v":3261.579071063571,"d":"3,261.58 "},{"v":17248.472368169794,"d":"17,248.47 "}]
[null,12,"X3","Q4",{"v":17248.472368169794,"d":"17,248.47 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":323.4088569031836,"d":"323.41 "},{"v":3322.733678646013,"d":"3,322.73 "},{"v":13925.738689523781,"d":"13,925.74 "}]
[null,13,"X4","Q1",{"v":13925.738689523781,"d":"13,925.74 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":261.1076004285709,"d":"261.11 "},{"v":3385.0349351206255,"d":"3,385.03 "},{"v":10540.703754403155,"d":"10,540.70 "}]
[null,14,"X4","Q2",{"v":10540.703754403155,"d":"10,540.70 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":197.63819539505917,"d":"197.64 "},{"v":3448.5043401541375,"d":"3,448.50 "},{"v":7092.199414249018,"d":"7,092.20 "}]
[null,15,"X4","Q3",{"v":7092.199414249018,"d":"7,092.20 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":132.9787390171691,"d":"132.98 "},{"v":3513.1637965320274,"d":"3,513.16 "},{"v":3579.035617716991,"d":"3,579.04 "}]
[null,16,"X4","Q4",{"v":3579.035617716991,"d":"3,579.04 "},{"v":3646.1425355491965,"d":"3,646.14 "},{"v":67.10691783219357,"d":"67.11 "},{"v":3579.035617717003,"d":"3,579.04 "},{"v":-1.1823431123048067E-11,"d":"-0.00 "}]
[{"$nulls":5},{"$f":"SUM(Tabelle1[Annuität])","v":{"v":58338.28056878714,"d":"58,338.28 "}},{"$f":"SUM(Tabelle1[Zinsen])","v":{"v":8338.280568787137,"d":"8,338.28 "}},{"$f":"SUBTOTAL(109,Tabelle1[Tilung])","v":{"v":50000.00000000001,"d":"50,000.00 "}}]
[]
[null,"Berechnungen für eine spezielle Periode"]
[]
[null,"Periode",null,8,null,"Restschuld zu Beginn von Periode X",null,null,{"$f":"AK*((1+Zins)^PeriodenGesamt-(1+Zins)^(PeriodeX-1))/((1+Zins)^PeriodenGesamt-1)","v":{"v":29939.013259691706,"d":"29,939.01 "}},{"$f":"AnnTilg_RestSchuldBeginnPeriodeX(Zins,PeriodenGesamt,AK,PeriodeX)+(0*NOW())","v":{"v":29939.013259691706,"d":"29,939.01 "}}]
[null,"AK",null,{"$f":"F5","v":{"v":50000,"d":"50,000.00 "}},null,"Zinsen im Periode X",null,null,{"$f":"ABS(PMT(Zins,PeriodenGesamt,AK))*(1-(1+Zins)^(PeriodeX-PeriodenGesamt-1))","v":{"v":561.3564986192193,"d":"561.36 "}},{"$f":"AnnTilg_ZinsenPeriodeX(Zins,PeriodenGesamt,AK,PeriodeX)+(0*NOW())","v":{"v":561.3564986192193,"d":"561.36 "}}]
[null,"Zinsen/Periode",null,{"$f":"I6","v":{"v":0.01875,"d":"1.875%"}},null,"Tilgung in Periode X",null,null,{"$f":"ABS(PMT(Zins,PeriodenGesamt,AK))*(1+Zins)^(PeriodeX-PeriodenGesamt-1)","v":{"v":3084.786036929977,"d":"3,084.79 "}},{"$f":"AnnTilg_TilgungPeriodeX(Zins,PeriodenGesamt,AK,PeriodeX)+(0*NOW())","v":{"v":3084.786036929977,"d":"3,084.79 "}}]
[null,"Perioden",null,{"$f":"I7","v":16}]
[{"$nulls":5},"Gesamtzinsen",null,null,{"$f":"Summe2(\"ABS(PMT(Zins;PeriodenGesamt;AK))*(1-(1+Zins)^(x-PeriodenGesamt-1))\",\"x\",1,PeriodenGesamt)+(0*NOW())","v":{"v":8338.280568787133,"d":"8,338.28 "}},{"$f":"AnnTilg_GesamtZinsen(Zins,PeriodenGesamt,AK)+(0*NOW())","v":{"v":8338.280568787133,"d":"8,338.28 "}}]
[]
["© Erhard Rainer - www.erhard-rainer.com"]