{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rentabilitet","InveKK","Cashflow","Forudsætninger"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Rentabilitet","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,2,1,6],[27,1,27,4],[3,1,3,6],[4,1,4,3],[12,1,12,3],[14,1,14,2],[25,3,25,5],[34,1,34,5],[36,1,36,6],[37,1,37,5],[38,1,38,5],[39,1,39,5]]}
[]
[null,"Investering:"]
[]
[null,"Ændret indtjening"]
[null,"Produktion",null,null,"Enheder","DB pr. enhed","Årlig indtjening"]
[null,null,null,null,null,null,{"$f":"E6*F6","v":0},null,{"$f":"IF(G6<>0,1,2)","v":2}]
[null,null,null,null,null,null,0,null,2]
[null,null,null,null,null,null,{"$f":"E8*F8","v":0},null,{"$f":"IF(G8<>0,1,2)","v":2}]
[null,null,null,null,null,null,0,null,2]
[null,null,null,null,null,null,0,null,2]
[null,null,null,null,null,null,0,null,2]
[null,null,null,null,null,null,0,null,2]
[null,"I alt",null,null,null,null,{"$f":"SUM(G6:G12)","v":0},null,1]
[null,null,null,null,null,null,null,null,1]
[null,"Ændrede gns. kapitalomk.",null,"Kalk.rente:",0.05,"Intern rente:",0,null,1]
[null,"Investering","Beløb","Levetid","Scrap","Kap.ind.fakt.","Årlig omkost.",null,1]
[null,"Bygninger",null,25,null,{"$f":"IF(G17=0,\"\",G17/C17*100)","v":""},{"$f":"PMT($E$15,D17,C17,-E17)","v":0},null,{"$f":"IF(G17<>0,1,2)","v":2}]
[null,"Inventar",null,12.5,null,{"$f":"IF(G18=0,\"\",G18/C18*100)","v":""},{"$f":"PMT($E$15,D18,C18,-E18)","v":0},null,2]
[null,"Besætning",null,"∞",{"$f":"C19","v":0},{"$f":"$E$15*-100","v":-5},{"$f":"C19*F19/100","v":0},null,2]
[null,"Jord",null,"∞",{"$f":"C20","v":0},{"$f":"$E$15*-100","v":-5},{"$f":"C20*F20/100","v":0},null,2]
[null,"Beholdninger",null,"∞",{"$f":"C21","v":0},{"$f":"$E$15*-100","v":-5},{"$f":"C21*F21/100","v":0},null,2]
[null,null,null,12.5,null,{"$f":"IF(G22=0,\"\",G22/C22*100)","v":""},{"$f":"PMT($E$15,D22,C22,-E22)","v":0},null,2]
[null,null,null,12.5,null,{"$f":"IF(G23=0,\"\",G23/C23*100)","v":""},{"$f":"PMT($E$15,D23,C23,-E23)","v":0},null,2]
[null,null,null,12.5,null,{"$f":"IF(G24=0,\"\",G24/C24*100)","v":""},{"$f":"PMT($E$15,D24,C24,-E24)","v":0},null,2]
[null,"Indkøringstab",null,12.5,null,{"$f":"IF(G25=0,\"\",G25/C25*100)","v":""},{"$f":"PMT($E$15,D25,C25,-E25)","v":0},null,2]
[null,"Investeringssum i alt>",{"$f":"SUM(C17:C25)","v":0},"Kapitalomkostninger i alt>",null,null,{"$f":"SUM(G17:G25)","v":0},null,1]
[null,null,null,null,null,null,null,null,1]
[null,"Ændrede kontante kapacitetsomkostninger",null,null,null,null,"Årlig omkost.",null,1]
[null,"Energi",null,null,null,null,null,null,{"$f":"IF(G29<>0,1,2)","v":2}]
[null,"Maskinstation",null,null,null,null,null,null,2]
[null,"Vedligehold",null,null,null,null,null,null,2]
[null,"Lønomkostninger",null,null,null,null,null,null,{"$f":"IF(G32<>0,1,2)","v":2}]
[null,"Ejd. skat og forsikringer",null,null,null,null,null,null,2]
[null,"Diverse omkostninger",null,null,null,null,null,null,2]
[null,"I alt ",null,null,null,null,{"$f":"SUM(G29:G34)*-1","v":0}]
[]
[null,"Årligt overskud/underskud"]
[null,"Gennemsnitlig øget indtjening",null,null,null,null,{"$f":"G13","v":0}]
[null,"Ændrede gns. kapitalomkostninger",null,null,null,null,{"$f":"G26","v":0}]
[null,"Ændrede gns. kontante kapacitetsomkostninger",null,null,null,null,{"$f":"G35","v":0}]
[null,"Årligt overskud/underskud i",{"$f":"MAX(D17:D25)","v":25},null,null,null,{"$f":"SUM(G38:G40)","v":0}]
[null,null,null,null,null,null,"© CHA 21.09.2023"]

{"sheet":"InveKK","index":1,"n_rows":425,"n_cols":59,"rows_kept":425,"cut":false,"hidden":false,"merged":[[2,37,4,37],[2,14,2,16],[2,17,2,18],[2,11,2,13],[63,6,63,8],[60,0,60,14],[4,9,4,10],[4,17,4,18],[41,0,41,1],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[4,13,4,15],[5,13,5,15],[62,0,62,3],[63,1,63,2],[62,11,62,13],[62,5,62,9],[0,1,0,4],[0,11,0,15],[1,1,1,4],[1,11,1,18]]}
[2,"RENTABILITET FØR SKAT",null,null,null,null,null,null,null,null,null,"RENTABILITET EFTER SKAT",null,null,null,null,null,null,null,null,1,"Jordbrug","Udbytte","Stykomk.","Kap.omk.",null,null,1,null,null,null,null,null,"Forklaring af skattevirkningen"]
[null,null,null,null,null,null,null,null,null,null,null,"Fortjeneste og tab medregnes i slutår. Forudsætter anden positiv indkomst for sparet skat",null,null,null,null,null,null,null,null,2,"Erhverv","Omsætning","Var. omk.","Faste omk.",null,null,null,null,null,null,null,null,null,"    Kapitalværdi før skat",null,null,{"$f":"$D$4","v":3374986.0780470343},null,null," fra beregningen i InveKK, celle D4"]
[null,"Kalkulationsrente",null,"KAPITALVÆRDI",null,"INTERN RENTE",null,"ANNUITETSMETODE",null,"Gns. afkast",{"$f":"PMT(B4,B9,NPV(B4,H12:H41),0)*-1","v":656332.99999999988},"KAPITALVÆRDI EFTER SKAT",null,null,"INTERN RENTE EFTER SKAT",null,null,"ANNUITETSMETODE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," + Nutidsværdi beskatning af afkast (1)",null,null,{"$f":"NPV($B$4,BF12:BF41)","v":-2027211.7805106617},null,null,null," nutidsværdi med rente før skat af \"skat afkast\", kolonne BF"]
[null,0.05,null,{"$f":"NPV(B4,I12:I41)+I11","v":3374986.0780470343},"kr.",{"$f":"IRR(I11:I41)*100","v":31.154837688739544},"%",{"$f":"K3+K4","v":437076.1375518149},"kr.","GKO",{"$f":"PMT(B4,B9,B6,-C11)","v":-219256.86244818498},{"$f":"NPV(L9,Q12:Q41)+Q11","v":2300297.7064326378},"kr.",null,{"$f":"IRR(Q11:Q41)*100","v":22.23163736968452},"%",null,{"$f":"PMT(L9,B9,-L4)","v":269665.06546778476},"kr. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," + Nutidsværdi sparet skat af afskr. (2)",null,null,{"$f":"NPV($B$4,BG12:BG41)","v":548493.56436299579},null,null,null," nutidsværdi med rente før skat af \"sparet skat af afskr.\", kolonne BG"]
[null,"Investering","Scrapværdi",{"$f":"VLOOKUP($AB$1,$U$1:$Z$2,3)","v":"Udbytte"},{"$f":"VLOOKUP($AB$1,$U$1:$Z$2,4)","v":"Stykomk."},"DB",{"$f":"VLOOKUP($AB$1,$U$1:$Z$2,5)","v":"Kap.omk."},"Nettobet.","Pay back","LIKVIDITET",null,"Afskr.-metode:","s"," \"s\" for saldo \"l\" for lineær",null,null,"Pay back","LIKVIDITET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," + Nutidsværdi sparet skat af renter (3)",null,null,{"$f":"AL7-AK4-AK3-AL2","v":404029.84453326929},null,null,null," beregnet som forskellen i kapitalværdi som følge af rente før og efter skat (*)"]
[null,2000000,500000,2000000,1332667,{"$f":"D6-E6","v":667333},11000,{"$f":"F6-G6","v":656333},{"$f":"IF(AG10=0,\"\",AG10)","v":4},"Slutsaldo",{"$f":"VLOOKUP($B$9,A11:K41,11)","v":5497496.6879794858},"Afskr.-procent:",25,"Indtast afskrivnings%",null,null,{"$f":"AF10","v":5},"Slutsaldo",{"$f":"VLOOKUP($B$9,A11:S41,19)","v":3091407.7650425378},null,null,null,null,null,null,null,null,null,null,null,null,null,null," = Skattevirkning i alt",null,null,{"$f":"SUM(AK3:AK5)","v":-1074688.3716143966},{"$f":"AK6","v":-1074688.3716143966},null,null," sum af de tre faktorer i skattevirkningen"]
[null,{"$f":"B6+D4","v":5374986.0780470343},{"$f":"(D4*((1+B4)/(1+C9))^B9)*-1+C6","v":-4997496.6879794849},{"$f":"PMT((1+$B$4)/(1+D9)-1,$B$9,$D$4)+D6","v":1562923.8624481852},{"$f":"PMT((1+$B$4)/(1+E9)-1,$B$9,$D$4)*-1+E6","v":1769743.1375518148},{"$f":"F6+PMT((1+$B$4)/(1+F9)-1,$B$9,$D$4)","v":230256.8624481851},{"$f":"PMT((1+$B$4)/(1+G9)-1,$B$9,$D$4)*-1+G6","v":448076.1375518149},{"$f":"H6+PMT((1+$B$4)/(1+H9)-1,$B$9,$D$4)","v":219256.8624481851},"Tilbage-"," =k.værdi år",{"$f":"B9","v":10},"Efter skat","Afskr. %",null," = Kolonner ","Skatte"," = Kolonner"," =k.værdi år",{"$f":"B9","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," = Kapitalværdi efter skat",null,null,{"$f":"$L$4","v":2300297.7064326378},null,null," fra beregningen i InveKK, celle L4"]
[null,"Levetid i år","Prisstign.%","Prisstign.%","Prisstign.%","Prisstign.%","Prisstign.%","Prisstign.%","betaling i år","K.værdi år 0",{"$f":"K6/(1+B4)^B9","v":3374986.0780470348},"rente %",{"$f":"M6","v":25},1,"H + M + N","procent","C + H + P","K.værdi år 0",{"$f":"S6/(1+L9)^B9","v":2300297.7064326378},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Til forklaring af skattevirkning"]
[null,10,null,null,null,{"$f":"(F12/F6)-1","v":0},null,{"$f":"IF(AND(A9=2,B6>0),\"Ej relevant\",((H12/H6)-1))","v":0},null,null,null,{"$f":"B4*(1-P9)","v":0.03},{"$f":"IF(M8=0,\"Ingen\",IF(M5=\"l\",\"Lineær\",IF(M5=\"s\",\"Saldo\",\"\")))","v":"Saldo"},"Genvundne","Beskatnings-",0.4,"Nettobet.","Rente","Saldo",null,null,null,null,null,null,null,null,null,null,null,null,"Efter skat","Før skat",null,null,null,null,null,null,null,"*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skat af","Sparet"]
["År","Investering",{"$f":"IF($C$11<>0,-RATE($B$9,0,$B$6,-$C$11),\"Scrapværdi\")","v":0.12944943670386772},"Udbytte","Stykomk.","DB","Kap.omk.","Afkast","Bet.strøm","Rente","Saldo","Afskr-saldo","Afskrivning","afskrivninger","grundlag","Skat","efter skat","efter skat","efter skat",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(AF11:AF41)","v":5},{"$f":"MIN(AG11:AG41)","v":4},null,null,null,null,null,null,null,"Nutidsværdien af rentefradragsretten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto-","afkast","skat af"]
[0,{"$f":"B6*-1","v":-2000000},{"$f":"VLOOKUP(B9,A12:C41,3)","v":500000},null,null,null,null,null,{"$f":"B11","v":-2000000},null,{"$f":"I11","v":-2000000},null,null,null,null,null,{"$f":"I11","v":-2000000},null,{"$f":"I11","v":-2000000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K11>0.2,A11,\"\")","v":""},null,null,null,null,null,null,null,"Renten efter skat indarbejder rentefradragsretten i renten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betaling",{"$f":"P9","v":0.4},"afskrivning"]
[1,null,{"$f":"IF($B$9=$A12,C$6*(1+C$9)^A12,0)","v":0},{"$f":"IF($B$9>=$A12,D$6*(1+D$9)^A12,0)","v":2000000},{"$f":"IF($B$9>=$A12,-E$6*(1+E$9)^$A12,0)","v":-1332667},{"$f":"D12+E12","v":667333},{"$f":"IF($B$9>=$A12,-G$6*(1+G$9)^$A12,0)","v":-11000},{"$f":"F12+G12","v":656333},{"$f":"H12+C12","v":656333},{"$f":"IF(B$9>=A12,K11*B$4,0)","v":-100000},{"$f":"IF(B$9>=A12,K11+J12+I12,0)","v":-1443667},{"$f":"B11*-1","v":2000000},{"$f":"IF($B$9>=A12+1,-L12*M$8/100)","v":-500000},{"$f":"IF(M$8>0,IF(A12=B$9,(C12-(L12+M12))*$N$8,0),0)","v":0},{"$f":"H12+M12+N12","v":156333},{"$f":"O12*$P$9*-1","v":-62533.200000000004},{"$f":"H12+P12+C12","v":593799.80000000005},{"$f":"IF(A12<=B$9,S11*L$9,0)","v":-60000},{"$f":"IF(B$9>=A12,S11+R12+Q12,0)","v":-1466200.2},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"Skal man isolere værdien af rentefradragsretten, kan man gøre det ved at ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H12","v":656333},{"$f":"BE12*$BF$11*-1","v":-262533.2},{"$f":"(M12+N12)*$BF$11*-1","v":200000}]
[2,null,{"$f":"IF($B$9=$A13,C$6*(1+C$9)^A13,0)","v":0},{"$f":"IF($B$9>=$A13,D$6*(1+D$9)^A13,0)","v":2000000},{"$f":"IF($B$9>=$A13,-E$6*(1+E$9)^$A13,0)","v":-1332667},667333,{"$f":"IF($B$9>=$A13,-G$6*(1+G$9)^$A13,0)","v":-11000},656333,656333,{"$f":"IF(B$9>=A13,K12*B$4,0)","v":-72183.350000000006},{"$f":"IF(B$9>=A13,K12+J13+I13,0)","v":-859517.35000000009},{"$f":"IF(B$9>=A13,L12+M12,0)","v":1500000},{"$f":"IF($B$9>=A13,IF(M$5=\"l\",IF(M12*-1<=L13,M12,0),-L13*M$8/100),0)","v":-375000},0,281333,{"$f":"O13*$P$9*-1","v":-112533.20000000001},{"$f":"H13+P13+C13","v":543799.80000000005},-43986.005999999994,{"$f":"IF(B$9>=A13,S12+R13+Q13,0)","v":-966386.40599999996},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"beregne en nutidsværdi med før-skat-renten og beregne en nutidsværdi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,656333,-262533.2,150000]
[3,null,0,2000000,-1332667,667333,-11000,656333,656333,-42975.867500000008,-246160.21750000014,1125000,-281250,0,375083,-150033.20000000001,506299.8,-28991.592179999996,-489078.19818000001,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S14>0.2,A14,\"\")","v":""},"",null,null,null,null,null,null,null,"med efter-skat-renten. Forskellen på de to er er nutidsværdien af rentefradragsretten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,656333,-262533.2,112500]
[4,null,0,2000000,-1332667,667333,-11000,656333,656333,-12308.010875000007,397864.77162499982,843750,-210937.5,0,445395.5,-178158.2,478174.8,-14672.3459454,-25575.74412540003,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S15>0.2,A15,\"\")","v":""},{"$f":"IF(K15>0.2,A15,\"\")","v":4},null,null,null,null,null,null,null,"på den pengestrøm.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,656333,-262533.2,84375]
[5,null,0,2000000,-1332667,667333,-11000,656333,656333,19893.238581249992,1074091.0102062498,632812.5,-158203.125,0,498129.875,-199251.95,457081.05,-767.27232376200084,430738.03355083795,null,null,null,null,null,null,null,null,null,null,null,null,5,5,null,null,null,null,null,null,null,"Ko efter skat uden rentefradragsret",null,null,{"$f":"NPV(B4,$Q$12:$Q$41)+Q11","v":1896267.8618993685},null,"nutidsværdien af betalingsstrømmen efter skat med renten før skat",null,null,null,null,null,null,null,null,null,null,656333,-262533.2,63281.25]
[6,null,0,2000000,-1332667,667333,-11000,656333,656333,53704.550510312489,1784128.5607165622,474609.375,-118652.34375,0,537680.65625,-215072.26250000001,441260.73749999999,12922.141006525138,884920.91205736308,null,null,null,null,null,null,null,null,null,null,null,null,6,6,null,null,null,null,null,null,null,"Ko efter skat (med rentefradragsret)",null,null,{"$f":"NPV(L9,$Q$12:$Q$41)+Q11","v":2300297.7064326378},null,"nutidsværdien af betalingsstrømmen efter skat med renten efter skat, svarende til Ko efter skat",null,null,null,null,null,null,null,null,null,null,656333,-262533.2,47460.9375]
[7,null,0,2000000,-1332667,667333,-11000,656333,656333,89206.42803582811,2529667.9887523903,355957.03125,-88989.2578125,0,567343.7421875,-226937.49687500001,429395.50312499999,26547.62736172089,1340864.0425440839,null,null,null,null,null,null,null,null,null,null,null,null,7,7,null,null,null,null,null,null,null,"Ko forskel",null,null,{"$f":"AR17-AR16","v":404029.84453326929},null,"forskel i kapitalværdi af beløb efter skat, hvis du regner med før og efter skat rente",null,null,null,null,null,null,null,null,null,null,656333,-262533.2,35595.703125]
[8,null,0,2000000,-1332667,667333,-11000,656333,656333,126483.39943761952,3312484.3881900096,266967.7734375,-66741.943359375,0,589591.056640625,-235836.42265625001,420496.57734374999,40225.921276322515,1801586.5411641565,null,null,null,null,null,null,null,null,null,null,null,null,8,8,null,null,null,null,null,null,null,"Manglende beløb i skattevirkning",null,null,{"$f":"AL7-AL2-AK3-AK4","v":404029.84453326929},null,"beregnet som det, der mangler i forklaringen ovenfor",null,null,null,null,null,null,null,null,null,null,656333,-262533.2,26696.77734375]
[9,null,0,2000000,-1332667,667333,-11000,656333,656333,165624.21940950048,4134441.6075995099,200225.830078125,-50056.45751953125,0,606276.54248046875,-242510.61699218751,413822.38300781249,54047.596234924691,2269456.5204068935,null,null,null,null,null,null,null,null,null,null,null,null,9,9,null,null,null,null,null,null,null,"Forskel",null,null,{"$f":"AR19-AR18","v":0},null,"Kontrol, skal være nul ",null,null,null,null,null,null,null,null,null,null,656333,-262533.2,20022.5830078125]
[10,null,500000,2000000,-1332667,667333,-11000,656333,1156333,206722.08037997549,5497496.6879794858,150169.37255859375,-37542.343139648438,387372.97058105469,1006163.6274414063,-402465.45097656251,753867.54902343755,68083.695612206808,3091407.7650425378,null,null,null,null,null,null,null,null,null,null,null,null,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,656333,-262533.2,-139932.2509765625]
[11,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[12,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[13,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[14,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[15,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[16,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[17,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[18,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[19,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[20,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[21,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[22,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[23,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[25,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[26,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[27,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[28,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[29,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[30,null,0,0,0,0,0,0,0,{"$f":"IF(B$9>=A41,K40*B$4,0)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Rentabilitet!G42","v":"© CHA 21.09.2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$9>=A43,M42*M$8/100*1,0)","v":0},null,{"$f":"(N43-O43)*P$9/100","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S56+I57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["År for år omkostning ved maskinstation, ny maskine og gammel maskine"]
[]
["Maskinstation (udbytte)",null,null,null,null,"Nye maskine fra rentabilitetsberegning",null,null,null,null,null,"Gamle maskine"]
[null,"Gns. årlige omkostninger",null,"Gns.",null,null,"Gns. årlige omkostninger",null,null,"Gns.",null,null,"Maskinens","Afskrivning","Forrentning","År for år","År for år","År for år","År for år"]
["År","Udbytte","Korrektion","årlige omk",null,"År","Stykomk.","Kap. omk.","GKO","årlige omk",null,"År","Værdi",0.15,{"$f":"B4","v":0.05},"Stykomk.","Kap. omk.","KO","omk. i alt"]
[1,{"$f":"D12","v":2000000},null,{"$f":"B66+C66","v":2000000},null,1,{"$f":"E12*-1","v":1332667},{"$f":"G12*-1","v":11000},{"$f":"IF(F66<=$B$9,$K$4,0)*-1","v":219256.86244818498},{"$f":"SUM(G66:I66)","v":1562923.862448185},null,{"$f":"F66","v":1},500000,{"$f":"M66*$N$65","v":75000},{"$f":"M66*$O$65","v":25000},null,null,{"$f":"N66+O66","v":100000},{"$f":"N66+O66+P66+Q66","v":100000}]
[2,{"$f":"D13","v":2000000},null,{"$f":"B67+C67","v":2000000},null,2,{"$f":"E13*-1","v":1332667},{"$f":"G13*-1","v":11000},{"$f":"IF(F67<=$B$9,$K$4,0)*-1","v":219256.86244818498},{"$f":"SUM(G67:I67)","v":1562923.862448185},null,2,{"$f":"IF(F67<=$B$9,M66-N66,0)","v":425000},63750,21250,null,null,{"$f":"N67+O67","v":85000},{"$f":"N67+O67+P67+Q67","v":85000}]
[3,2000000,null,2000000,null,3,1332667,11000,219256.86244818498,1562923.862448185,null,3,361250,54187.5,18062.5,null,null,72250,72250]
[4,2000000,null,2000000,null,4,1332667,11000,219256.86244818498,1562923.862448185,null,4,307062.5,46059.375,15353.125,null,null,61412.5,61412.5]
[5,2000000,null,2000000,null,5,1332667,11000,219256.86244818498,1562923.862448185,null,5,261003.125,39150.46875,13050.15625,null,null,52200.625,52200.625]
[6,2000000,null,2000000,null,6,1332667,11000,219256.86244818498,{"$f":"SUM(G71:I71)","v":1562923.862448185},null,6,221852.65625,33277.8984375,11092.6328125,null,null,44370.53125,44370.53125]
[7,2000000,null,2000000,null,7,1332667,11000,219256.86244818498,1562923.862448185,null,7,188574.7578125,28286.213671875001,9428.7378906249996,null,null,37714.951562499999,37714.951562499999]
[8,2000000,null,2000000,null,8,1332667,11000,219256.86244818498,1562923.862448185,null,8,160288.54414062499,24043.281621093749,8014.42720703125,null,null,32057.708828125,32057.708828125]
[9,2000000,null,2000000,null,9,1332667,11000,219256.86244818498,1562923.862448185,null,9,136245.26251953124,20436.789377929686,6812.2631259765622,null,null,27249.052503906249,27249.052503906249]
[10,2000000,null,2000000,null,10,1332667,11000,219256.86244818498,1562923.862448185,null,10,115808.47314160156,17371.270971240232,5790.4236570800786,null,null,23161.694628320311,23161.694628320311]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,-123456,1234567891,123456789]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Afskrining","Forrentning"," Stykomk. "]
[]
[]
[null,null,null,null,null,null,null,null,null,0,{"$f":"K11","v":-2000000},null,"Maskinstation","Nye","Gamle",null,null,null,{"$f":"S11","v":-2000000}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"K12","v":-1443667},null,{"$f":"D66","v":2000000},{"$f":"J66","v":1562923.862448185},{"$f":"S66","v":100000},null,null,null,{"$f":"S12","v":-1466200.2}]
[null,null,null,null,null,null,null,null,null,2,-859517.35000000009,null,{"$f":"D67","v":2000000},{"$f":"J67","v":1562923.862448185},{"$f":"S67","v":85000},null,null,null,-966386.40599999996]
[null,null,null,null,null,null,null,null,null,3,-246160.21750000014,null,{"$f":"D68","v":2000000},{"$f":"J68","v":1562923.862448185},{"$f":"S68","v":72250},null,null,null,-489078.19818000001]
[null,null,null,null,null,null,null,null,null,4,397864.77162499982,null,{"$f":"D69","v":2000000},{"$f":"J69","v":1562923.862448185},{"$f":"S69","v":61412.5},null,null,null,-25575.74412540003]
[null,null,null,null,null,null,null,null,null,5,1074091.0102062498,null,{"$f":"D70","v":2000000},{"$f":"J70","v":1562923.862448185},{"$f":"S70","v":52200.625},null,null,null,430738.03355083795]
[null,null,null,null,null,null,null,null,null,6,1784128.5607165622,null,{"$f":"D71","v":2000000},{"$f":"J71","v":1562923.862448185},{"$f":"S71","v":44370.53125},null,null,null,884920.91205736308]
[null,null,null,null,null,null,null,null,null,7,2529667.9887523903,null,2000000,1562923.862448185,37714.951562499999,null,null,null,1340864.0425440839]
[null,null,null,null,null,null,null,null,null,8,3312484.3881900096,null,2000000,1562923.862448185,32057.708828125,null,null,null,1801586.5411641565]
[null,null,null,null,null,null,null,null,null,9,4134441.6075995099,null,2000000,1562923.862448185,27249.052503906249,null,null,null,2269456.5204068935]
[null,null,null,null,null,null,null,null,null,10,5497496.6879794858,null,2000000,1562923.862448185,23161.694628320311,null,null,null,3091407.7650425378]
[null,null,null,null,null,null,null,null,null,11,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,12,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,13,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,14,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,15,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,16,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,17,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,18,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,19,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,20,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,21,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,22,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,23,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,24,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,25,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,26,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,27,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,28,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,29,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,30,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K76","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"S78","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K140","v":0},null,null,null,null,null,null,null,{"$f":"S140","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K204","v":0},null,null,null,null,null,null,null,{"$f":"S204","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K268","v":0},null,null,null,null,null,null,null,{"$f":"S268","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]

{"sheet":"Cashflow","index":2,"n_rows":111,"n_cols":33,"rows_kept":111,"cut":false,"hidden":false,"merged":[[0,1,7,1],[0,2,7,2],[0,3,7,3],[0,4,7,4],[0,5,7,5],[5,10,5,11],[7,10,7,11],[0,13,0,14],[1,13,1,15],[2,8,2,9],[2,13,2,16],[4,8,4,9],[4,10,4,11],[0,7,0,9]]}
[null,"Investering","Udbytte","Stykomkostninger","Scrap",null,null,"Cashflow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Arket er beskyttet men uden kode."]
[null,null,null,null,null,null,null,"Rente","KAPITALVÆRDI",null,"Likviditet",null,null,"Indsæt evt. flere kolonner til ind- og udbetalinger."]
[null,null,null,null,null,null,null,0.06,{"$f":"NPV(H4,AE10:AE39)+AE9","v":3236365.9771302091},"kr.","Slutsaldo år",{"$f":"H6","v":8},{"$f":"VLOOKUP($H$6,G9:J39,4)","v":5158275.6811261103}]
[null,null,null,null,null,null,null,"Levetid i år","INTERN RENTE",null,"  / forrentningsfaktor",null,{"$f":"(1+H4)^H6","v":1.5938480745308423}]
[null,null,null,null,null,null,null,{"$f":"MAX(AD9:AD39)","v":8},{"$f":"IF(MIN(B9:F39)<0,IRR(H9:H39,H4/100)*100,\"\")","v":80.529835895740803},"%"," = kapitalværdi år 0",null,{"$f":"M4/M5","v":3236365.9771302082}]
[null,null,null,null,null,null,null,null,"Pay back",{"$f":"IF(MIN(AC9:AC39)>H6,\"\",MIN(AC9:AC39))","v":2}]
["År",null,null,null,null,null,"År","Pengestrøm","Rente","KK-saldo","/ Forretningsfaktor =",null,"Opsum K0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skygge",null,"termin","år"]
[{"$f":"IF(ISBLANK($M$1),AF9,AG9)","v":0},-800000,null,null,null,null,0,{"$f":"SUM(B9:F9)","v":-800000},null,{"$f":"H9","v":-800000},{"$f":"IF(L9<>0,\"/\",\"\")","v":"/"},1,{"$f":"H9","v":-800000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9>0.2,AF9,\"\")","v":""},{"$f":"IF(H9<>0,A9,\"\")","v":0},{"$f":"H9","v":-800000},0,{"$f":"M1","v":0}]
[1,null,650000,null,null,null,1,{"$f":"SUM(B10:F10)","v":650000},{"$f":"IF($H$6>=$AF10,J9*H$4,0)","v":-48000},{"$f":"IF($H$6>=$AF10,J9+I10+H10,0)","v":-198000},{"$f":"IF($H$6>=$AF10,\"/\",\"\")","v":"/"},{"$f":"IF($H$6>=$AF10,J10/M10,\"\")","v":1.06},{"$f":"IF($H$6>=$AF10,J10/(1+H$4)^AF10,\"\")","v":-186792.45283018867},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(H10<>0,AF10,\"\")","v":1},650000,1,{"$f":"AG9+1","v":1}]
[2,null,650000,null,null,null,2,650000,-11880,440120,{"$f":"IF($H$6>=$AF11,\"/\",\"\")","v":"/"},{"$f":"IF($H$6>=$AF11,J11/M11,\"\")","v":1.1236000000000002},391705.2331790672,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,650000,2,{"$f":"AG10+1","v":2}]
[3,null,650000,null,null,null,3,650000,26407.200000000001,1116527.2,"/",1.1910160000000003,937457.76715006318,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,650000,3,3]
[4,null,650000,null,",",null,4,650000,66991.631999999998,1833518.8319999999,"/",1.2624769600000003,1452318.6482547764,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,650000,4,4]
[5,null,650000,null,null,null,5,650000,110011.12991999999,2593529.9619199997,"/",1.3382255776000005,1938036.4606177132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,650000,5,5]
[6,null,650000,null,null,null,6,650000,155611.79771519997,3399141.7596351998,"/",1.4185191122560006,2396260.8119035028,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,650000,6,6]
[7,null,650000,null,null,null,7,650000,203948.50557811197,4253090.2652133116,"/",1.5036302589913608,2828547.9357580207,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,650000,7,7]
[8,null,650000,null,null,null,8,650000,255185.41591279869,5158275.6811261103,"/",1.5938480745308423,3236365.9771302082,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,650000,8,8]
[9,null,null,null,null,null,9,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,9,9]
[10,null,null,null,null,null,10,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,10,10]
[11,null,null,null,null,null,11,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,11,11]
[12,null,null,null,null,null,12,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,12,12]
[13,null,null,null,null,null,13,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,13,13]
[14,null,null,null,null,null,14,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,14,14]
[15,null,null,null,null,null,15,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,15,15]
[16,null,null,null,null,null,16,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,16,16]
[17,null,null,null,null,null,17,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,17,17]
[18,null,null,null,null,null,18,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,18,18]
[19,null,null,null,null,null,19,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,19,19]
[20,null,null,null,null,null,20,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,20,20]
[21,null,null,null,null,null,21,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,21,21]
[22,null,null,null,null,null,22,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,22,22]
[23,null,null,null,null,null,23,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,23,23]
[24,null,null,null,null,null,24,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,24,24]
[25,null,null,null,null,null,25,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,25,25]
[26,null,null,null,null,null,26,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,26,26]
[27,null,null,null,null,null,27,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,27,27]
[28,null,null,null,null,null,28,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,28,28]
[29,null,null,null,null,null,29,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,29,29]
[30,null,null,null,null,null,30,0,0,0,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,30,30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Rentabilitet!G42","v":"© CHA 21.09.2023"}]
[]
[]
[]
[]
[]
[0,null,null,null,null,null,null,null,null,{"$f":"J9","v":-800000}]
[1,null,null,null,null,null,null,null,null,{"$f":"J10","v":-198000}]
[2,null,null,null,null,null,null,null,null,440120]
[3,null,null,null,null,null,null,null,null,1116527.2]
[4,null,null,null,null,null,null,null,null,1833518.8319999999]
[5,null,null,null,null,null,null,null,null,2593529.9619199997]
[6,null,null,null,null,null,null,null,null,3399141.7596351998]
[7,null,null,null,null,null,null,null,null,4253090.2652133116]
[8,null,null,null,null,null,null,null,null,5158275.6811261103]
[9,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Forudsætninger","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Her kan du lave forudsætninger og mellemregninger til brug for rentabilitetsarkene"]