Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you calculate annualised return?
Hi - Anyone out there have the way to calculate the annualised return for an
investment? Many thanks for your assistance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you calculate annualised return?
We need a lot more information to be able to answer that question.
But maybe you can answer it yourself by reading this: http://office.microsoft.com/en-us/ex...117451033.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "YC" wrote in message ... | Hi - Anyone out there have the way to calculate the annualised return for an | investment? Many thanks for your assistance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you calculate annualised return?
Fri, 29 Feb 2008 11:06:49 +0100 from Niek Otten :
We need a lot more information to be able to answer that question. But maybe you can answer it yourself by reading this: http://office.microsoft.com/en-us/ex...117451033.aspx Bloody Microsoft. "One Moment Please... To help optimize how your Web pages are displayed, we are checking to see if a 2007 Microsoft Office program is installed. If this page does not automatically redirect, you have scripts disabled. See more information on scripts. Follow this link if the page is not redirected." And of course "this link" does nothing at all. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you calculate annualised return?
Yes. The most common method, although there are others, is to use the XIRR
function. Post back if you need more help with it. Regards, Fred. "YC" wrote in message ... Hi - Anyone out there have the way to calculate the annualised return for an investment? Many thanks for your assistance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you calculate annualised return?
"YC" wrote:
Hi - Anyone out there have the way to calculate the annualised return for an investment? That depends on exactly what you mean. If you have a series of activity (monetary amounts of investments and returns) on irregular dates, then yes, XIRR is one way to compute an annual return rate. Be sure to assign opposite signs to the different types of amounts -- typically, negative numbers for investments and positive numbers for returns. But if you mean that you have a periodic return rate (e.g. the return rate for a quarter), and you want to annualize it, XIRR is overkill and somewhat contorted to use. The "most common" Excel function to use would be FV, although many people simply use an exponential expression. In general, if the periodic rate is "r" and there are "n" periods in a year, the annualized rate can be computed with either of the following equivalent formulas (formatting the cell as Percentage): =fv(r, n, 0, -1) - 1 =(1+r)^n - 1 By the way, if you compare those results with XIRR, you will usually see some difference. This is because XIRR uses 365/(D2-D1) for "n", where D1 and D2 are the starting and ending dates of the period. You could do the same in the formulas above; but that is not how periodic rates are "commonly" annualized. Caveat: Some financial engineers use the number of trading days between starting and ending dates of the period, not the number of calendar days. On average, there are 252 trading days per year. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate Return on Investment in Excel | Excel Worksheet Functions | |||
template for Annualised (Annualized) hours timesheet | Excel Discussion (Misc queries) | |||
Calculate the return of irregular deposits | Excel Worksheet Functions | |||
Annualised interest rate | Excel Worksheet Functions | |||
Pivot Table - Running Total Annualised | Excel Discussion (Misc queries) |