Small Bug in Returns Worksheets

Discuss all general (i.e. non-personal) investing questions and issues, investing news, and theory.
Post Reply
User avatar
Topic Author
Paul Douglas Boyer
Posts: 130
Joined: Wed Mar 07, 2007 2:19 pm
Location: Leesburg, VA

Small Bug in Returns Worksheets

Post by Paul Douglas Boyer »

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.
Post Reply