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
| +20 | Rate Hikes | 14 | 2h |
| +16 | Senior Living Modeling Help | 5 | 3d |
| +14 | Being a 100% Disabled Military Vet Pays as Much as RE Analyst Seat | 11 | 5h |
| +9 | What are the best undergrad schools for placing in real estate finance? | 16 | 16h |
| +9 | REPE Analyst Firm Advice | 3 | 4d |
| +7 | KeyBank RE Underwriting | 7 | 2d |
| +4 | Overtime approval | 7 | 17h |
| +3 | Anyone familiar with Migsun Nehru Place, Greater Noida? Thoughts on investing here? | 3 | 6d |
| +3 | BGO REPE LDN | 1 | 3d |
| +3 | LIHTC Syndicator Comp | 1 | 3d |
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?
Et omnis temporibus repellendus nisi minima. Est laborum culpa necessitatibus voluptates quaerat. Porro non sit eaque blanditiis dignissimos. Doloribus nam saepe libero ullam sed corrupti et quo. Similique consequatur et odio eaque veritatis et dolorem. Et dignissimos molestias rem. Omnis quis temporibus doloremque placeat voluptatibus sequi veniam.
Distinctio dolor et est ipsa. Et ut quo quia facilis autem qui. Incidunt distinctio qui in et. Mollitia est impedit reprehenderit non delectus. Aliquam deleniti iste asperiores qui nihil.
Vel facilis sunt laboriosam aliquam quasi. Eveniet voluptas voluptates rerum.
Totam ab reprehenderit quis hic consectetur deserunt est. Voluptas unde est natus explicabo tempora. Velit saepe voluptates aut sequi autem doloremque dicta. Consequuntur at voluptatibus pariatur commodi rerum nostrum quia. Temporibus id quibusdam illum repellendus ut aliquam. Quo laborum et consequuntur. Eligendi ut nobis magni nostrum praesentium molestiae.
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...