Wow, I can’t believe Microsoft would ship a product like this. Beware, Excel 2008 won’t recalc XIRR correctly and in fact any sheet that has an intentional reference where loan amounts have fees that are dependent. This has worked in versions of Excel for the last 20 years. So sad, it means that Excel 2008 [...]
Excel 2008 bugs make it useless for loans and private equity
August 27th, 2008 · No Comments · Geek
Tags: Circular References·Excel·Formulae·Loan Amounts·Loan Calculations·Loans·Mean Time·Microsoft·Private Equity·Sad Statement·Software Quality·Value Error·Wow·Xirr