Navigator User Forums
  Investment Reports
  Apprec% Column in Security Portfolio Analysis report

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Apprec% Column in Security Portfolio Analysis report
FN_User
Member
posted 04-28-2008 04:27 PM     Click Here to See the Profile for FN_User     Edit/Delete Message
I was looking at this column with one of my investors and he was asking about the calculation within FN for this. It looks to me like it is calculated with a time factor from the date of acquisition rather than annualized. For example if a stock gained 10% in one month on an annualized basis (gain $ divided by investment), the appreciation % reflected on the report would be much much higher since it was 10% over only 30 days. Conversely, if it was more than 12 months, a return would be over that period rather than only 12 mths. Are these correct assumptions?

IP: Logged

David
Administrator
posted 04-28-2008 04:28 PM     Click Here to See the Profile for David     Edit/Delete Message
The appreciation percentage that appears on Security Portfolio Analysis reports is the annualized, compounded return since purchase. It is based on the change form cost basis to the balance in the report month.

For instance, if I paid $1,000 for a security on 1/1/2000 and it is worth $1,100 on 12/31/08, that is a 10% change but the Apprec % on the report is 1.1%. If you compound 1.1% continually for 8 years, you get 10%. It doesn’t matter if the 10% gain was in one month or spread over the 8 year period.

Or if the 10% gain was in a single month, you bought the security in that month, and the report was for a single month, the Apprec % would be 219.1%. Note that GIPS does not recognize gains to be annualized for investments help less than a year, so this number, while mathematically correct, is not meaningful. Navigator ROI leaves similar numbers out of reports when the period is less than a year.

See page 368 of the Navigator 8.2 Reference Guide or Search for “Apprec” on Navigator 8.2 help for the formula that Navigator uses.

Navigator ROI looks at the investment for the period being reported on, not since purchase. So a Navigator ROI report for the 12 month period that includes the 10% would show a 10% compounded time-weighted return as you might expect. This is simply the gain divided by the beginning balance. Navigator ROI also shows a annualized time-weighted return of 9.5% which is the return (before compounding) which when compounded daily yields a 10% gain. Note that ROI uses daily compounding whereas Security Portfolio Analysis reports use continuous compounding.

Navigator ROI also reports a 10% IRR (dollar-weighted return) and a 10% annualized IRR for a one-year period. For a two year period, the annualized IRR is 4.9%.

- David

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e