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
| +38 | Where are free agents signing? | 19 | 1h |
| +33 | Capital Restricted Developer | 7 | 10h |
| +31 | Laughable Job Posting | 11 | 3h |
| +27 | What Is Your Backup Plan? | 15 | 2h |
| +23 | Future of Real Estate | 5 | 2h |
| +23 | AvalonBay Equity Residential Merger discussion | 8 | 1h |
| +16 | Extremely Slow Ramp Up | 1 | 15h |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 14h |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 2d |
| +6 | Dynex | 4 | 12h |
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?
Sequi incidunt facere dicta soluta omnis. Labore ut quaerat possimus et aliquam rerum nemo facere. Qui velit incidunt nisi aliquam molestiae. Ut est atque modi nesciunt qui iste accusamus. Fugiat dignissimos consequatur ratione aspernatur harum maiores. Ut ad voluptatum ut architecto. Aut provident ducimus porro magnam dolor.
Aut ut doloremque doloremque tempora. Dolorem officiis officia eaque. Cupiditate quia tempora veritatis.
Et magni placeat ut enim aut. Sunt beatae beatae sed est sit provident voluptatum. Voluptates tempore corrupti iure molestiae necessitatibus quo voluptatem. Cupiditate sunt sint est vel enim itaque. Occaecati id perferendis voluptatem voluptatem. Molestiae eos eos odio est.
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...