irr calculation

I am trying to build a formula that will return my year 0 cash outflow to achieve a 12% IRR on a series of future cashflows. The cashflows would be: Year 0: X (some negative value) Year 1: 400K Year 2: 450K year 3: 475K year 4: 500K IRR: 12% I am struggling to come up with a formula that...

Hi everyone, I am trying to create a formula to calculate the IRR for multiple properties each with a different start and end date. The properties are combined into one spreadsheet, each column represents a different month and each row represents a different property. The cash flow for each...

Hello, all. I'm trying to calculate the IRR (Internal Rate of Return) of a stock portfolio but my cash flow data is monthly. I used both IRR and XIRR but it seems like the way I'm calculating them is wrong. How should I go about calculating the monthly IRR accurately? Since I can't attached...

I am getting different returns when calculating for IRR. The far right is the "desired" ending return that should be populating in the IRR column as well (I pasted these numbers in the desired column and am using the formula below for the IRR column). I was able to get the first year to match...

I would like to calculate the IRR of multiple different projects, I try to take array of cashflow and dates of different projects, then using XIRR, but XIRR can only calculate continuous data. Below is a simplify sample, I can manually put all the data of one project together, but I can't do...

I am trying to calculate IRR on a one time transaction as follows initial investment $6.1 Million Return captured 120 days later $17.5 Million our investment partner has an IRR threshold at which point we receive an equity claw back and higher percentage of the proceeds. I am having...