{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Beregning"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Beregning","index":0,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,0,9,0],[8,1,9,1],[8,3,9,3],[8,4,9,4]]}
["Oversigt over kontraktforløb i Sønderjysk Indkøbsforening:"]
[]
["Indtastninger:",null,null,"Omkostninger:"]
["Købssum:",150000,null,"Provision:",{"$f":"IF((G5<500),500,(IF((G5>1500),1500,G5)))","v":1500},null,2]
["Afdragstid år:",5,null,"Udbetaling:",{"$f":"IF((G6<1),0,G6)","v":0},null,{"$f":"B4*G4/100","v":3000}]
["Rentesats:",1,null,"Moms:",{"$f":"(B4*0.25)+(E4*0.25)-(B9*0.25)","v":31625},null,{"$f":"(B4*(B8/100))-B9","v":-2500}]
["Terminer pr. år:",4]
["Udbetaling %:",15]
["Værdi af maskine givet i bytte",25000,null,"Betaling ved underskrift:",{"$f":"SUM(E4:E6)","v":33125}]
[]
[]
[]
["Afdragsoversigt:"]
[null,"Rente","Afdrag","Ydelse","Restgæld"]
["Lån:",null,null,null,{"$f":"B4-E5-B9","v":125000},null,1]
["1. termin",{"$f":"IF((E15<>\"\"),(E15*$B$6/100/$B$7),\"\")","v":312.5},{"$f":"IF((E15>0),($E$15/(B$5*B$7)),0)","v":6250},{"$f":"IF((E15>0),(C16+B16),\"\")","v":6562.5},{"$f":"IF((E15-C16)>0,(E15-C16),0)","v":118750},null,2]
["2. termin",296.875,6250,{"$f":"IF((E16>0),(C17+B17),\"\")","v":6546.875},{"$f":"IF((E16-C17)>0,(E16-C17),0)","v":112500},null,3]
["3. termin",281.25,6250,6531.25,106250,null,4]
["4. termin",265.625,6250,6515.625,100000,null,5]
["5. termin",250,6250,6500,93750,null,6]
["6. termin",234.375,6250,6484.375,87500]
["7. termin",218.75,6250,6468.75,81250]
["8. termin",203.125,6250,6453.125,75000]
["9. termin",187.5,6250,6437.5,68750,null,1]
["10. termin",171.875,6250,6421.875,62500]
["11. termin",156.25,6250,6406.25,56250]
["12. termin",140.625,6250,6390.625,50000,null,4]
["13. termin",125,6250,6375,43750]
["14. termin",109.375,6250,6359.375,37500]
["15. termin",93.75,6250,6343.75,31250,null,15]
["16. termin",78.125,6250,6328.125,25000,null,20]
["17. termin",62.5,6250,6312.5,18750]
["18. termin",46.875,6250,6296.875,12500]
["19. termin",31.25,6250,6281.25,6250]
["20. termin",15.625,6250,6265.625,0]
["21. termin",0,0,"",0]
["22. termin",0,0,"",0]
["23. termin",0,0,"",0]
["24. termin",0,0,{"$f":"IF((E38>0),(C39+B39),\"\")","v":""},{"$f":"IF((E38-C39)>0,(E38-C39),0)","v":0}]
[]
["Samlet betaling incl. provision:",null,null,{"$f":"SUM(D16:D40)+E4","v":129781.25}]
["Samlede omkostninger incl. provision:",null,null,{"$f":"D41-E15","v":4781.25}]