Results 1 to 14 of 14

Help with calculating portfolio returns over rolling 30 yr periods

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2007
    MS-Off Ver
    365
    Posts
    48

    Help with calculating portfolio returns over rolling 30 yr periods

    Hi All

    Attached is workbook in which annual data for stocks, bonds and inflation. I'd like to calculate rolling 30 yr portfolio returns from 1928 thru 2019. The portfolio starts at 90% stocks and 10% bonds The bond portion starts increasing as shown starting in the 17th year. The portfolio starts with $1000 and an inflation adjusted $1000 is added each year. I've calculated the results for the first 30 year period. I don't know how to combine the rolling periods with the annual bond adjustments. Any help is greatly appreciated!

    Charlie
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Standard Deviation, Portfolio Returns Shortcuts
    By davidvanpatten in forum Excel General
    Replies: 2
    Last Post: 06-16-2015, 03:49 AM
  2. [SOLVED] Rolling 12 month return by portfolio using product(if()) array
    By spcw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2014, 04:47 PM
  3. [SOLVED] How to calculate a rolling average over X periods
    By Johnex777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2013, 10:37 AM
  4. Comparing attendance occurrences with rolling periods
    By amybrown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2012, 01:19 AM
  5. Performance of a stock over 20 day rolling periods
    By yamar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2009, 04:26 AM
  6. Rolling Time Periods
    By mttlltt75 in forum Excel General
    Replies: 4
    Last Post: 06-13-2008, 09:46 AM
  7. average rolling periods
    By RobPatrick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2007, 05:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1