I'm trying to create an IRR table for property investments with a 5 year time
horizon, based on a series of negative cash outflows (representing the
initial outlay and subsequent monthly loan payments), followed by a cash
inflow in the future when I sell the asset.

My table looks something like this:

Year Cash Flow IRR
0 -10,000
1 -1,000
2 -1,000
3 -1,000
4 -1,000
5 -1,000

What I would like to do is find the IRR for each year, assuming I can sell
the property that year for $20,000. So, what is the IRR if I sell it in Year
3, Year 4, etc.

Thanks in advance!