Quicken 2003 Investment performance by security avg return calculationDifference between my calculation and Quicken 3.7% Calculation seems to be in error

Mar 18, 2005 1 Replies

I am having a problem with the avg return calculation on the investment return report.



Example: Beg Mkt Val $31,200.00 End Mkt Val $ 32,640.00. Dividends -0- Avg return 32.2% This is for February YTD



My calculation :



Difference in value: 32,640.00 - 31,200.00 + 1,440.00 for 59 days (Jan + Feb) Return % : 1,440/31,200.00 = .04615384615 this is for 29 days Return per day :.04615384615/59 = .00078226857 Return for year: .00078226837 x 365 = 28.5 Difference in calculations 3.7%


Try daily compounding:

31200 x 1.000765^59 power = 32640

1.000765^365 = 32.2

ie. .0765 daily compounding for 365 days gets you 32.2%

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required