{"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":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,3,7,3],[6,4,7,4]]}
["Oversigt over kontraktforløb i Indkøbsforeningen Fyn:"]
[]
["Indtastninger:",null,null,"Omkostninger:"]
["Købssum:",150000,null,"Provision:",{"$f":"IF((G5<1500),1500,(IF((G5>4500),4500,G5)))","v":3000},null,2]
["Afdragstid år:",5,null,"Udbetaling:",{"$f":"(B4*(B8/100))","v":30000},null,{"$f":"B4*G4/100","v":3000}]
["Rentesats:",1.5,null,"Moms:",{"$f":"(B4*0.25)+(E4*0.25)","v":38250}]
["Terminer pr. år:",4,null,"Betaling ved underskrift:",{"$f":"SUM(E4:E6)","v":71250}]
["Udbetaling %:",20]
[]
[]
["Afdragsoversigt:"]
[null,"Rente","Afdrag","Ydelse","Restgæld"]
["Lån:",null,null,null,{"$f":"B4-E5","v":120000}]
["1. termin",{"$f":"IF((E13<>\"\"),(E13*$B$6/100/$B$7),\"\")","v":450},{"$f":"IF((E13>0),($E$13/(B$5*B$7)),0)","v":6000},{"$f":"IF((E13>0),(C14+B14),\"\")","v":6450},{"$f":"IF((E13-C14)>0,(E13-C14),0)","v":114000},null,1]
["2. termin",427.5,6000,{"$f":"IF((E14>0),(C15+B15),\"\")","v":6427.5},{"$f":"IF((E14-C15)>0,(E14-C15),0)","v":108000},null,2]
["3. termin",405,6000,6405,102000,null,3]
["4. termin",382.5,6000,6382.5,96000,null,4]
["5. termin",360,6000,6360,90000,null,5]
["6. termin",337.5,6000,6337.5,84000,null,6]
["7. termin",315,6000,6315,78000]
["8. termin",292.5,6000,6292.5,72000]
["9. termin",270,6000,6270,66000,null,1.5]
["10. termin",247.5,6000,6247.5,60000]
["11. termin",225,6000,6225,54000]
["12. termin",202.5,6000,6202.5,48000,null,4]
["13. termin",180,6000,6180,42000]
["14. termin",157.5,6000,6157.5,36000]
["15. termin",135,6000,6135,30000,null,20]
["16. termin",112.5,6000,6112.5,24000,null,25]
["17. termin",90,6000,6090,18000]
["18. termin",67.5,6000,6067.5,12000]
["19. termin",45,6000,6045,6000]
["20. termin",22.5,6000,6022.5,0]
["21. termin",0,0,"",0]
["22. termin",0,0,"",0]
["23. termin",0,0,"",0]
["24. termin",{"$f":"IF((E36<>\"\"),(E36*$B$6/100/$B$7),\"\")","v":0},0,{"$f":"IF((E36>0),(C37+B37),\"\")","v":""},{"$f":"IF((E36-C37)>0,(E36-C37),0)","v":0}]
[]
["Samlet betaling incl. provision:",null,null,{"$f":"SUM(D14:D38)+E4","v":127725}]
["Samlede omkostninger incl. provision:",null,null,{"$f":"D39-E13","v":7725}]