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,010 points
845 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,700 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,700 points
836 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,700 points
523 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,700 points
1,457 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,700 points
465 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,700 points
551 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,700 points
526 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,700 points
1,826 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
980 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,700 points
321 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,700 points
3,287 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