Spreadsheet: 748526d1632190838-irr-function-comming-out-as-number-irr-function-comming-out-as-number-
Sheet: Sheet1

 |  | Discount rate | 0.1 |  |  | Data Table
 | Year | Cash Flow | Time Value Factor | Discounted Cash Flow |  | Current |  | +/-
 | 0 | 429 |  |  |  | 0
 | 1 | -1005 |  |  |  |  | 21.14782864425058
 | 2 | 599 |  |  |  |  | 19.44598231449447
 | Total |  |  |  |  |  | 17.88679423131293
 |  |  |  |  |  |  | 16.46301775147924
 |  |  | NPV |  |  |  | 15.1678004535147
 |  |  | IRR |  |  |  | 13.99466002135989
 |  |  |  |  |  |  | 12.93746178705555
 |  |  |  |  |  |  | 11.99039780521275
 | https://www.excelforum.com/excel-formulas-and-functions/1359527-irr-function-comming-out-as-number.html |  |  |  |  |  | 11.14796734281623
 |  |  |  |  |  |  | 10.4049586776859
 |  |  |  |  |  |  | 9.75643210778344
 |  |  |  |  |  |  | 9.19770408163265
 |  |  |  |  |  |  | 8.724332367452462
 |  |  |  |  |  |  | 8.332102185287738
 |  |  |  |  |  |  | 8.017013232514103
 |  |  |  |  |  |  | 7.775267538644471
 |  |  |  |  |  |  | 7.603258090437578
 |  |  |  |  |  |  | 7.497558172938795
 |  |  |  |  |  |  | 7.454911376315238
 |  |  |  |  |  |  | 7.472222222222229
 |  |  |  |  |  |  | 7.546547366983134
 |  |  |  |  |  |  | 7.675087342112363
 |  |  |  |  |  |  | 7.855178795690506
 |  |  |  |  |  |  | 8.08428720083242
 |  |  |  |  |  |  | 8.360000000000014
 |  |  |  |  |  |  | 8.680020156210617
 |  |  |  |  |  |  | 9.042160084320244
 |  |  |  |  |  |  | 9.4443359375
 |  |  |  |  |  |  | 9.884562225827779
 |  |  |  |  |  |  | 10.36094674556216
 |  |  |  |  |  |  | 10.87168579919592
 |  |  |  |  |  |  | 11.41505968778694
 |  |  |  |  |  |  | 11.98942845836399
 |  |  |  |  |  |  | 12.59322789039885
 |  |  |  |  |  |  | 13.22496570644711
 |  |  |  |  |  |  | 13.8832179930796
 |  |  |  |  |  |  | 14.56662581916987
 |  |  |  |  |  |  | 15.27389203948758
 |  |  |  |  |  |  | 16.0037782723461
 |  |  |  |  |  |  | 16.75510204081633
 |  |  |  |  |  |  | 17.52673406770282
 |  |  |  |  |  |  | 18.31759571513584
 |  |  |  |  |  |  | 19.1266565602229
 |  |  |  |  |  |  | 19.95293209876553
 |  |  |  |  |  |  | 20.79548156956008
 |  |  |  |  |  |  | 21.65340589228748
 |  |  |  |  |  |  | 22.52584571243472
 |  |  |  |  |  |  | 23.4119795471147
 |  |  |  |  |  |  | 24.31102202603483
 |  |  |  |  |  |  | 25.22222222222223
 |  |  |  |  |  |  | 26.14486206745312
 |  |  |  |  |  |  | 27.07825484764538
 |  |  |  |  |  |  | 28.02174377376224
 |  |  |  |  |  |  | 28.97470062405128
 |  |  |  |  |  |  | 29.93652445369412
 |  |  |  |  |  |  | 30.90664036817896
 |  |  |  |  |  |  | 31.88449835693132
 |  |  |  |  |  |  | 32.86957218394483
 |  |  |  |  |  |  | 33.86135833234442
 |  |  |  |  |  |  | 34.859375
 |  |  |  |  |  |  | 35.8631611434744
 |  |  |  |  |  |  | 36.87227556774891
 |  |  |  |  |  |  | 37.88629605931723
 |  |  |  |  |  |  | 38.90481856038079
 |  |  |  |  |  |  | 39.92745638200185
 |  |  |  |  |  |  | 40.95383945420241
 |  |  |  |  |  |  | 41.98361361110122
 |  |  |  |  |  |  | 43.01643990929711
 |  |  |  |  |  |  | 44.05199397780186
 |  |  |  |  |  |  | 45.08996539792381
 |  |  |  |  |  |  | 46.13005711158993
 |  |  |  |  |  |  | 47.17198485667939
 |  |  |  |  |  |  | 48.21547662801976
 |  |  |  |  |  |  | 49.26027216276918
 |  |  |  |  |  |  | 50.30612244897966
 |  |  |  |  |  |  | 51.35278925619835
 |  |  |  |  |  |  | 52.40004468703123
 |  |  |  |  |  |  | 53.44767074864288
 |  |  |  |  |  |  | 54.49545894322907
 |  |  |  |  |  |  | 55.54320987654333
 |  |  |  |  |  |  | 56.59073288361168
 |  |  |  |  |  |  | 57.63784567081277
 |  |  |  |  |  |  | 58.68437397354364
 |  |  |  |  |  |  | 59.73015122873352
 |  |  |  |  |  |  | 60.77501826150487
 |  |  |  |  |  |  | 61.81882298531627
 |  |  |  |  |  |  | 62.86142011495906
 |  |  |  |  |  |  | 63.90267089180631
 |  |  |  |  |  |  | 64.94244282074976
 |  |  |  |  |  |  | 65.9806094182826
 |  |  |  |  |  |  | 67.01704997121792
 |  |  |  |  |  |  | 68.05164930555569
 |  |  |  |  |  |  | 69.08429756503534
 |  |  |  |  |  |  | 70.11488999893729
 |  |  |  |  |  |  | 71.1433267587114
 |  |  |  |  |  |  | 72.16951270304048
 |  |  |  |  |  |  | 73.19335721095626
 |  |  |  |  |  |  | 74.21477400265286
 |  |  |  |  |  |  | 75.23368096765239
 |  |  |  |  |  |  | 76.25000000000009