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%