this bug will probably not affect anyone. But here is the report of it anyway.
In worksheets Returns_72_09 and Returns_85_09
In column AQ which calculates Growth of 10000
The formula (for example in Row 7 here):
=IF(AND($A7>=SYear72,$A7<=EYear72),IF($A7=SYear72,$AQ$2,AQ6*(1+AM7%)),"")
should be replaced with
=IF(AND($A7>=SYear72,$A7<=EYear72),IF($A7=SYear72,(1+AM7%),AQ6*(1+AM7%)),"")
The error is that the first calculation is shown to be "1" instead of the actual growth. This could impact results if the first year were negative.
All successive rows should also be replaced in both worksheets.
Small Bug in Returns Worksheets
- Paul Douglas Boyer
- Posts: 130
- Joined: Wed Mar 07, 2007 2:19 pm
- Location: Leesburg, VA