Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

Reply With Quote

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 10:50 AM.

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. is not affiliated with Microsoft