Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-16-2006, 11:27 PM
aml480 aml480 is offline
Novice
IRR with Changing Signs
 
Join Date: Mar 2006
Posts: 1
aml480
Default 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
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft