|
|
#1
03-16-2006, 11:27 PM
|
|||
|
|||
IRR with Changing Signs
I'm trying to annualize a monthly IRR calculation where each of months 1-5 reflect negative cash flow, each of months 6-10 reflect positive cash flow, each of months 11-15 reflect negative cash flow, and each of months 16-20 reflect positive cash flow. I've been told that Excel's IRR function cannot accommodate changing signs such as these; is this correct? If not, what formula should I use to compute the monthly IRR and what formula should I use to annualize that monthly IRR on a compound basis?
Many thanks in advance. Alan 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Changing Port on Project Server PWA | danny_boy328 | Project | 0 | 09-25-2007 08:27 AM |
| Same As Previous - changing default when inserting/pasting | LdeMarais | Word | 0 | 09-21-2007 11:07 AM |
| Changing DataSource | ntfirewall | Mail Merge | 0 | 03-30-2007 06:01 AM |
| Recurring Appointment randomly changing time | rkryd03 | Outlook | 0 | 03-06-2007 10:25 AM |
| Programmatically changing folder item selection | Richard Cook | Outlook | 0 | 02-09-2007 02:25 PM |
Linear Mode
