|
Date
of release: December
30, 1999
Major
new features: Bug
fix for Restricted Stock Plan calculations
Details:
Within the RSP section of each Case
sheet, the cell formula in the row labeled "Capital Gain"
is incorrect. If you are not modeling any RSPs, this bug will not
affect you and there is no reason to upgrade.
Depending
on the parameters of a specific RSP, this bug can have a significant
impact on results reported for both RSPs and the model as a whole.
While the exact formula will vary depending on the number and type
of plans in the model, in a model with just a single RSP, the cell
formula for cell "C30" in version 1.00 will read:
=IF(C18=0,0,(C20*BaseCase!C$2)-(C20*(C29/C18)))
The
correct formula, fixed in version 1.01, should read:
=IF(C18=0,0,(C20*BaseCase!C$2)-(C20*(C29/C28)))
The
single difference between the formulas is in the last parameter
("C28" rather than "C18"). All other cell formulas
in that row have the same error, varying only by the column being
referenced.
|
