As I understand it, Excel assumes that for purposes of calculating IRR, each
consecutive value is an annual value. If I have a short lived project, say
16 months, Excel assumes that the cash flow in the 16th cell is the 16th
year, thus the IRR is dramatically understated. How do you adjust for this
effect in Excel?