Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IRR: is there a quickest way?
Hi all!
If i have a series of payment that occur regularly in time (let's say at the end of the year) but not in the amount, is there a way to calculate IRR without writing down the entire plan? I mean, a formula where i can say "this is the first amount for X periods; this is the second amount for Y periods" and so on. In this way, instead of writing a row/column for each period, we could have a row/column for each series. This could be the case of mortgage payment plan, with rate adjustable every year. thanks in advance l |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quickest way to input formulas? | Excel Discussion (Misc queries) | |||
Quickest alternative for shortcut of PasteSpecial then Values | Excel Worksheet Functions | |||
What is quickest way to insert 4000 hyperlink documents? | Excel Worksheet Functions | |||
I want to start Excel in Print Preview. What's the quickest way? | New Users to Excel | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions |