|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 12th, 2010, 10:00 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Claculating Annual Turnover forma Quarter
Hi All
Does anyone know the formula to calculate the annual turnover rate based on a current quarterly percentage??? Thanks Caz 
|
|
#2
March 12th, 2010, 10:36 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Claculating Annual Turnover forma Quarter
Formulae are presented in greater detail at time value of money.
In the formula below, i is the effective interest rate per period. FV and PV represent the future and present value of a sum. n represents the number of periods. These are the most basic formula: The above calculates the future value (FV) of an investment's present value (PV) accruing at a fixed interest rate (i) for n periods. The above calculates what present value (PV) would be needed to produce a certain future value (FV) if interest (i) accrues for n periods. The above calculates the compound interest rate achieved if an initial investment of PV returns a value of FV after n accrual periods. The above formula calculates the number of periods required to get FV given the PV and the interest rate (i). The log function can be in any base, e.g. natural log (ln) [edit] Compound Formula for calculating compound interest: "Caz H" wrote: Hi All Does anyone know the formula to calculate the annual turnover rate based on a current quarterly percentage??? Thanks Caz
|
|
#3
March 12th, 2010, 10:48 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Claculating Annual Turnover forma Quarter
Hi
Thanks for your reply - unfortunately there is no formula showing in your message??? Thanks Caz "Caz H" wrote: Hi All Does anyone know the formula to calculate the annual turnover rate based on a current quarterly percentage??? Thanks Caz
|
|
#4
March 12th, 2010, 04:43 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Claculating Annual Turnover forma Quarter
If you annual turnover is in A1, use:
=FV(A1,4,0,-1)-1 Regards, Fred "Caz H" wrote in message ... Hi All Does anyone know the formula to calculate the annual turnover rate based on a current quarterly percentage??? Thanks Caz
|
|
#5
March 12th, 2010, 09:16 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Claculating Annual Turnover forma Quarter
Errata: If your quarterly turnover is in A1, use:
=FV(A1,4,0,-1)-1 Fred "Fred Smith" wrote in message ... If you annual turnover is in A1, use: =FV(A1,4,0,-1)-1 Regards, Fred "Caz H" wrote in message ... Hi All Does anyone know the formula to calculate the annual turnover rate based on a current quarterly percentage??? Thanks Caz
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
