Calculating a Rolling IRR in Excel

0 votes

I have two columns that I'd like to use to calculate a rolling monthly IRR with. The data looks like this:

Date          Net Cash Flow   Principal    IRR
2023-01-31    0               0            idk
2023-02-28    -62             62           ...
2023-03-31    1.4             62           
2023-04-30    1.3             62
2023-05-31    1.3             62
2023-06-30    -62             124
...           ...             ...

For the duration of the fund, assuming the principal is fully repaid, I want to generate a rolling IRR that will continue to recalculate each month. It would essentially be a "point in time" IRR that would change when additional cash flows were added, the principal was written down, or the principal's value increased. How can I accomplish this with just one column (or helper columns)?

Jan 3, 2023 in Others by Kithuzzz
• 38,000 points
1,100 views

1 answer to this question.

0 votes

I'm assuming a little bit here, but wouldn't get the desired result come from having the IRR formula always start at cell R2C2 and terminate at the corresponding cell RC3?

Original table plus columns with the IRR formulas and values.

answered Jan 3, 2023 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,600 points
1,117 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,600 points
894 views
0 votes
1 answer

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 63,600 points
2,040 views
0 votes
1 answer

I want to include a pdf to excel converter in my template?

You're app hosted locally only?  But even ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 63,600 points
600 views
0 votes
1 answer

Goal Seek in Excel

The pmt function we are using, which ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,600 points
902 views
0 votes
1 answer

How do I calculate Interest rate (R) from EMI formula if I know EMI, Principal (P) and Time (N)?

Try this: #include <iostream> #include <cmath> #include <boost/date_time/posix_time/posix_time.hpp> #include <boost/thread/thread.hpp> #define TOLERANCE ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,600 points
646 views
0 votes
1 answer

Historical Yahoo Finance API On Fritz Again?

It appears that Yahoo updated its finance ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,600 points
2,153 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,251 views
0 votes
1 answer

Calculating the week number of a year in Excel

Here is my excel formula. =IF(AND(A1>=DATE(YEAR(A1),1,1),A1< ...READ MORE

answered Dec 25, 2022 in Others by narikkadan
• 63,600 points
509 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
3,755 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP