+ Reply to Thread
Results 1 to 2 of 2

How to find the annualized return from a monthly return series

  1. #1
    Registered User
    Join Date
    04-13-2013
    Location
    GUNTUR
    MS-Off Ver
    Excel 2010
    Posts
    12

    How to find the annualized return from a monthly return series

    Hi all

    I would like to find the Annualize Monthly Returns for the given return series of various companies, in the given column, the returns are already in the form of 1.43%,4.87% etc. Please help me out
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,683

    Re: Post Excel Sheet

    you may want to click on the report and ask for the title to be changed - as members will not see the new question
    or you may be able to mark as solved - if available on the thread tools at the top - or again report and ask to be closed so you can start a new question with the correct title

    I'm not a financial analyst so do not know the full details of calculating annualised returns however, usually you usually need to know the capital invested (or amounts) to calculate the figures and cannot take averages of % , this applies to most numbers - there are some exceptions

    also this is a public domain and any spreadsheets are available via google search - is the information you posted sensitive at all ?
    Last edited by etaf; 07-01-2013 at 05:46 AM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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