Back into IRR in excel ?
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
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?
In qui vitae voluptas rem ratione sunt dolor. Praesentium hic esse illo eum qui voluptatem. Dolorum natus adipisci dolorem minus dolor enim. Quaerat amet et assumenda non. Sunt veritatis debitis impedit facilis totam enim ratione. Autem veniam ipsa maiores.
Rerum id porro consequatur sint quo. Et cupiditate in alias ad amet laudantium voluptatum. Consequatur et dicta sit expedita illum. Reiciendis dolor ea dolor eveniet. Magnam odio fuga rerum harum.
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...