Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

calculations and rounding

[ Q4-Q1 00 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

Posted by Daniel Comeau on January 24, 2000 at 17:50:00:


I'm trying to figure out what I'm doing wrong. I'm trying to manually calculate
the "Tax Basis AVG (end)" using excel, and comparing it to Fund Manager.
I'm pretty darned close, but there appears to be some rounding differences.

I have 3 decimal points for my shares, and 4 for share prices, and dollar values
only go to the $0.01.

My values for "End Shares", "Average Purchase Price (btw)", "Purchases (btw)",
and "Redemptions (btw)" all match my number crunching, but the
"Tax Basis AVG (end)" value is slightly different.

This should just be

"Purchases (btw)" - ("Redemptions (btw)" * "Average Purchase Price (btw)")

shouldn't it? Not sure why the differences.

Thanks,
Daniel




Replies:



FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy