{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["LÅN MED STOR ENGÅNGSAMORTERING"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"LÅN MED STOR ENGÅNGSAMORTERING","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[1,1,1,2],[6,1,6,2]]}
["                                                                                                                                                                                                                                                                                                                                                            ","LÅN MED STOR SLUTLIG ENGÅNGSAMORTERING","DATUM"]
[null,"ANTAGANDEN"]
[null,"LÅNEBELOPP",{"v":10000,"d":"10,000.00 kr"}]
[null,"ÅRSRÄNTA",{"v":0.0585,"d":"5.85%"}]
[null,"AMORTERINGSPERIOD (I ÅR)",15]
[null,"ÅR TILL ENGÅNGSAMORTERING",5]
[null,"VIKTIGA FINANSIELLA DATA"]
[null,"MÅNADSBETALNING",{"$f":"IFERROR(IF(SUM(Antaganden)>0,ROUND(PMT(Räntesats/12,Period*12,-Belopp),2),\"\"),\"\")","v":{"v":83.58,"d":"83.58 kr"}}]
[null,"TOTALA MÅNADSBETALNINGAR",{"$f":"IFERROR(IF(AND(Månadsbetalning>0,ÅrTillBetalning>0),ÅrTillBetalning*12*Månadsbetalning,\"\"),\"\")","v":{"v":5014.8,"d":"5,014.80 kr"}}]
[null,"TOTALT BETALAT BELOPP",{"$f":"IFERROR(IF(AND(Månadsbetalning>0,ÅrTillBetalning>0),TotalaMånadsbetalningar+Engångsamortering,\"\"),\"\")","v":{"v":12594.464455242689,"d":"12,594.46 kr"}}]
[null,"TOTAL RÄNTA",{"$f":"IFERROR(IF(OR(TotaltBetalatBelopp>0,ÅrTillBetalning>0),TotaltBetalatBelopp-Belopp,\"\"),\"\")","v":{"v":2594.464455242689,"d":"2,594.46 kr"}}]
[null,"ENGÅNGSARMORTERING",{"$f":"IFERROR(IF(AND(SUM(Antaganden2)>0,SUM(Månadsbetalning)>0),PV(Räntesats/12,(Period-ÅrTillBetalning)*12,-Månadsbetalning),\"\"),\"\")","v":{"v":7579.664455242689,"d":"7,579.66 kr"}}]