Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

IRR w/ Periodic Investments

0

Is there a formula for calculating IRR with periodic investments as well as periodic cash flow?  For example:

Date:           Investment         Date:             Cash Flow

1/1/2017     (10,000)          12/31/2017       1,000

1/1/2018     (15,000)          12/31/2018        2,000

                                           12/31/2019       3,000

                                           12/31/2020       40,000

Answer
Discuss

Answers

0

Excel's IRR function seems to be what you want. Read about it at this link.

Discuss

Discussion

The IRR function, as far as I can tell, only allows for one initial investment.  I am trying to solve for an IRR where there are periodic investments in addition to the initial investment.  I tried the XIRR but same issue.  
mrandall (rep: 4) Aug 2, '17 at 12:47 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login