Formel der ikke fungerer...
HejFormel på IRR= =IF(ISERROR(IRR(B7:B127;3%));0;IRR(B7:B127;3%))
Hvorfor går min closing balance ikke i 0? Resultat for sidste måned er -1043
På forhånd tak
Mvh
Patrice
Month ACT/ Forecast of Balance sheet Interest Actual Balance sheet Write up/
Number Monthly C/Fs IRR Opening balance Earned Collections Closing Balance depreation
dec-07 -1.997.490 23,334%
dec-07 544.424 1.997.490 466.102 544.424 1.919.168 -78.322
jan-08 1.245.612 1.919.168 447.826 1.245.612 1.121.382 -797.787
feb-08 668.408 1.121.382 261.667 668.408 714.641 -406.741
mar-08 323.072 714.641 166.757 323.072 558.326 -156.315
apr-08 222.087 558.326 130.282 222.087 466.521 -91.805
maj-08 160.582 466.521 108.860 160.582 414.798 -51.722
jun-08 203.234 414.798 96.791 203.234 308.355 -106.443
jul-08 122.304 308.355 71.953 122.304 258.004 -50.352
aug-08 103.975 258.004 60.203 103.975 214.232 -43.772
sep-08 78.021 214.232 49.990 78.021 186.200 -28.032
okt-08 58.132 186.200 43.449 58.132 171.516 -14.684
nov-08 40.511 171.516 40.022 40.511 171.027 -489
dec-08 36.655 171.027 39.908 36.655 174.281 3.253
jan-09 43.906 174.281 40.667 43.906 171.042 -3.238
feb-09 42.332 171.042 39.912 42.332 168.622 -2.420
mar-09 51.267 168.622 39.347 51.267 156.702 -11.920
apr-09 48.654 156.702 36.565 48.654 144.613 -12.089
maj-09 34.394 144.613 33.745 34.394 143.964 -649
jun-09 54.192 143.964 33.593 54.192 123.365 -20.599
jul-09 38.732 123.365 28.786 38.732 113.420 -9.945
aug-09 33.549 113.420 26.466 33.549 106.336 -7.084
sep-09 18.476 106.336 24.813 18.476 112.672 6.336
okt-09 31.206 112.672 26.291 31.206 107.758 -4.914
nov-09 27.364 107.758 25.145 27.364 105.539 -2.219
dec-09 27.613 105.539 24.627 27.613 102.553 -2.986
jan-10 17.554 102.553 23.930 17.554 108.929 6.376
feb-10 31.297 108.929 25.418 31.297 103.049 -5.879
mar-10 32.520 103.049 24.046 32.520 94.575 -8.474
apr-10 39.597 94.575 22.068 39.597 77.046 -17.529
maj-10 20.240 77.046 17.978 20.240 74.784 -2.262
jun-10 26.742 74.784 17.450 26.742 65.493 -9.291
jul-10 28.912 65.493 15.282 28.912 51.863 -13.630
aug-10 14.706 51.863 12.102 14.706 49.259 -2.604
sep-10 11.494 49.259 11.494 11.494 49.259 -0
okt-10 11.494 49.259 11.494 11.494 49.259 -0
nov-10 11.494 49.259 11.494 11.494 49.259 -0
dec-10 11.494 49.259 11.494 11.494 49.259 -0
jan-11 11.494 49.259 11.494 11.494 49.259 -0
feb-11 11.494 49.259 11.494 11.494 49.259 -0
mar-11 11.494 49.259 11.494 11.494 49.259 -0
apr-11 11.494 49.259 11.494 11.494 49.259 -0
maj-11 11.494 49.259 11.494 11.494 49.259 -0
jun-11 11.494 49.259 11.494 11.494 49.259 -0
jul-11 11.494 49.259 11.494 11.494 49.259 -0
aug-11 11.494 49.259 11.494 11.494 49.259 -0
sep-11 11.494 49.259 11.494 11.494 49.259 -0
okt-11 11.494 49.259 11.494 11.494 49.259 -0
nov-11 11.494 49.259 11.494 11.494 49.259 -0
dec-11 11.494 49.259 11.494 11.494 49.259 -0
jan-12 11.494 49.259 11.494 11.494 49.259 -0
feb-12 11.494 49.259 11.494 11.494 49.259 -0
mar-12 11.494 49.259 11.494 11.494 49.259 -0
apr-12 11.494 49.259 11.494 11.494 49.259 -0
maj-12 11.494 49.259 11.494 11.494 49.259 -0
jun-12 11.494 49.259 11.494 11.494 49.259 -0
jul-12 11.494 49.259 11.494 11.494 49.259 -0
aug-12 11.494 49.259 11.494 11.494 49.259 -0
sep-12 11.494 49.259 11.494 11.494 49.259 -0
okt-12 11.494 49.259 11.494 11.494 49.259 -0
nov-12 11.494 49.259 11.494 11.494 49.259 -0
dec-12 11.494 49.259 11.494 11.494 49.259 -0
jan-13 11.494 49.259 11.494 11.494 49.259 -0
feb-13 11.494 49.259 11.494 11.494 49.259 -0
mar-13 11.494 49.259 11.494 11.494 49.259 -0
apr-13 11.494 49.259 11.494 11.494 49.258 -0
maj-13 11.494 49.258 11.494 11.494 49.258 -0
jun-13 11.494 49.258 11.494 11.494 49.258 -0
jul-13 11.494 49.258 11.494 11.494 49.258 -0
aug-13 11.494 49.258 11.494 11.494 49.258 -0
sep-13 11.494 49.258 11.494 11.494 49.257 -0
okt-13 11.494 49.257 11.494 11.494 49.257 -0
nov-13 11.494 49.257 11.494 11.494 49.257 -0
dec-13 11.494 49.257 11.494 11.494 49.256 -0
jan-14 11.494 49.256 11.494 11.494 49.256 -1
feb-14 11.494 49.256 11.493 11.494 49.255 -1
mar-14 11.494 49.255 11.493 11.494 49.254 -1
apr-14 11.494 49.254 11.493 11.494 49.253 -1
maj-14 11.494 49.253 11.493 11.494 49.251 -1
jun-14 11.494 49.251 11.492 11.494 49.250 -2
jul-14 11.494 49.250 11.492 11.494 49.247 -2
aug-14 11.494 49.247 11.492 11.494 49.245 -3
sep-14 11.494 49.245 11.491 11.494 49.242 -3
okt-14 11.494 49.242 11.490 11.494 49.237 -4
nov-14 11.494 49.237 11.489 11.494 49.232 -5
dec-14 11.494 49.232 11.488 11.494 49.226 -6
jan-15 11.494 49.226 11.487 11.494 49.219 -8
feb-15 11.494 49.219 11.485 11.494 49.209 -9
mar-15 11.494 49.209 11.483 11.494 49.198 -12
apr-15 11.494 49.198 11.480 11.494 49.183 -14
maj-15 11.494 49.183 11.477 11.494 49.166 -18
jun-15 11.494 49.166 11.473 11.494 49.144 -22
jul-15 11.494 49.144 11.467 11.494 49.117 -27
aug-15 11.494 49.117 11.461 11.494 49.084 -33
sep-15 11.494 49.084 11.453 11.494 49.043 -41
okt-15 11.494 49.043 11.444 11.494 48.993 -50
nov-15 11.494 48.993 11.432 11.494 48.931 -62
dec-15 11.494 48.931 11.418 11.494 48.855 -76
jan-16 11.494 48.855 11.400 11.494 48.760 -94
feb-16 11.494 48.760 11.378 11.494 48.644 -116
mar-16 11.494 48.644 11.351 11.494 48.500 -143
apr-16 11.494 48.500 11.317 11.494 48.324 -177
maj-16 11.494 48.324 11.276 11.494 48.105 -218
jun-16 11.494 48.105 11.225 11.494 47.836 -269
jul-16 11.494 47.836 11.162 11.494 47.504 -332
aug-16 11.494 47.504 11.085 11.494 47.095 -409
sep-16 11.494 47.095 10.989 11.494 46.590 -505
okt-16 11.494 46.590 10.871 11.494 45.967 -623
nov-16 11.494 45.967 10.726 11.494 45.198 -768
dec-16 11.494 45.198 10.547 11.494 44.251 -947
jan-17 11.494 44.251 10.326 11.494 43.082 -1.169
feb-17 11.494 43.082 10.053 11.494 41.641 -1.441
mar-17 11.494 41.641 9.717 11.494 39.864 -1.778
apr-17 11.494 39.864 9.302 11.494 37.671 -2.192
maj-17 11.494 37.671 8.790 11.494 34.967 -2.704
jun-17 11.494 34.967 8.159 11.494 31.632 -3.335
jul-17 11.494 31.632 7.381 11.494 27.519 -4.113
aug-17 11.494 27.519 6.421 11.494 22.447 -5.073
sep-17 11.494 22.447 5.238 11.494 16.190 -6.256
okt-17 11.494 16.190 3.778 11.494 8.474 -7.716
nov-17 11.494 8.474 1.977 11.494 -1.043 -9.517
