Search results

Hi Hui, One other thing: the data table doesn't match my model's output for IRR. In the image I posted, for example, the data table shows $3M equity and price of $179 yield a 10.58% IRR, but my model shows an 11.8% (hence the upper left cell shows 11.8%). Any thoughts on this? Thanks! MR06

Hi Hui, I have followed your steps and am experiencing 2 issues: 1) this is not a linear function but I'm 100% positive that the higher the equity, the higher the resulting IRR. However, as you'll see in the attached image, for whatever reason the data table is incorrectly spitting out results...

Hi Hui, The example I provided is very simplified from the real thing. My actual models have much more complicated models that don't all operate the same way, although they do all have a price input, an equity input, and an IRR output. What I'm really looking for is a way to cut and paste the...

Hi Hui, Thank you for continuing to help. This last little bit, the table of solutions, is exactly what I need. Can you let me know the steps to recreate this? Thanks so much!

Hi Hui, Thanks for your continued help. I need the 25% IRR to be fixed, so I'm not looking for a sensitivity analysis on how slightly differing equity levels impact IRR. What I'm looking for is how pricing levels impact the equity required for a 25% IRR. In other words, your data table is...

Hi Hui, Thank you for this. I think I must be misleading in my explanation. What I am looking to do is set up a table that says "if year 3 price is X, what amount of equity do I need to input in order to yield a 25% IRR." The manual process is 1) hard code the price in year 3, which then...

Hi Eloise, The issue isn't calculating the IRR, that's working fine. The problem is currently I need to manually adjust the unit price in order to goal seek the equity that yields a 25% IRR, and repeat that for each different unit price. I am looking for a way to automate that. Thanks!

Hi all, I am trying to create a sensitivity table that tells me what amount of equity I need to include in a deal in order to get a fixed IRR as the year 3 sales price changes. I have created a simplified version of my problem in the attached spreadsheet. Assuming I want the IRR to be 25%, I...