Anyone know how to back into an IRR in excel?
it gives 4 values; 10,-50,-20,10 along with the current IRR. Afterwards it asks to get to a certain IRR (25%) in excel.. pretty stuck on this practice question so all help would be appreciated
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 11h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +42 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 9 | 12h |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +3 | Debt fund jobs | 1 | 3d |
| +3 | Thoughts on CIM Group today? | 11 | 22h |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 8h |
| +1 | Equity Waterfall - Market Standard | 2 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
have an input, purchase, then cash flows, then irr formula. use data tab in excel then goal seek. have the purchase price change to equal the 25% irr
Thank you for the response. It asks me to show a formula so I don’t think goal seek works for it. I have the correct answer already via the goalseek, just no clue how to back in
Set the first cash outflow (your purchase price) to the negative NPV of all cash flows thereafter where the discount rate is 25%.
It's a bit unclear to me what you are actually trying to calculate using what inputs. What are you supposed to change? (i.e. aquisition price? exit?). Are you trying to understand what would be the cash flows required at each point in time to get to those IRRs?
Assumenda repudiandae soluta dolorum qui ea. Nihil modi aspernatur voluptatem vel autem sed. Qui error nesciunt aut delectus facere qui veniam iste. Fugiat in quia iure ut. Omnis asperiores hic aperiam iusto recusandae. Consectetur temporibus nisi cupiditate distinctio ea.
Odit atque odit at voluptas reiciendis. Exercitationem optio nostrum nostrum dolores. Rerum qui optio molestias autem. Recusandae id dicta autem sed quis a repellat. Aut natus numquam necessitatibus voluptas.
Aperiam animi magni a. Sed quos repudiandae totam eius consequatur. Accusamus iure qui mollitia dolor maiores. Beatae sed illo quo ullam. Maxime suscipit facilis ducimus sunt sit placeat voluptas quaerat.
Maxime unde dolorum aliquid et quae. Exercitationem delectus id suscipit et sint molestias voluptate.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...