| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compound Average Annual Growth Rate
What is the CAGR formula (I don't believe I've heard of it before)? Have you
looked at the formulas provided under the "Financial" category in the "Insert Function" window? Is it something like the following? ISPMT(rate,per,nper,pv) - Rate is the interest rate for the investment. - Per is the period for which you want to find the interest, and must be between 1 and nper. - Nper is the total number of payment periods for the investment. - Pv is the present value of the investment. For a loan, pv is the loan amount. Jim -- I appreciate any feedback. Please don''t be scared to say that "Yes" I/someone else did answer your question. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Annual Growth Rate | Excel Worksheet Functions | |||
| How to get compound annual growth rates in pivot tables. | Excel Worksheet Functions | |||
| Compound Annual Growth Rate | Excel Discussion (Misc queries) | |||
| What formula do I use to calculate compound annual growth rate (C. | Excel Discussion (Misc queries) | |||
| Compound annual growth rate [CAGR] | Excel Discussion (Misc queries) | |||
Threaded Mode
