Making an excel table... PLEASE HELP!
Hey everyone,
Just started a new summer intern position, thrown right into building a model essentially from scratch, no training, little guidance, etc, but I want to impress the boss so if someone with some experience could help me out it would be great.
I have the model pretty much built, but I want to create a table that shows what happens to the money multiple (one of the outputs of the model) and another showing the IRR (another output of the model) when I change two inputs (P/E ratio and growth in AUM). I have put a picture of what I am envisioning. The problem is that there isn't one formula that spits out that information based on the change of those variables. Is there a way to create a list of values you want excel to run through the model, and have it put the outputs into a chart automatically. I'm sure there is using VBA but I definitely dont know how to use that. Please help!
If I got what you're asking correctly - http://www.WallStreetPrep.com/blog/
Sensitivity Analysis is what you are looking for.
Molestiae voluptas et illum qui. Delectus accusantium impedit et aut. Incidunt quam modi perspiciatis amet. Veritatis repellat necessitatibus est maxime ut et. Non perspiciatis maxime officiis.
Totam iusto sed omnis reiciendis. Voluptatibus repudiandae sequi sunt dicta recusandae maxime. Doloremque maiores aut explicabo voluptatum ut ut in. Deserunt ipsa beatae adipisci suscipit necessitatibus excepturi optio ut. Aliquid quia qui quod a illum. Maiores est aut quisquam saepe voluptas.
Ab et ipsa laudantium esse adipisci earum. Nulla repudiandae aut tempore earum rerum at amet. Voluptatem omnis voluptas earum iure deserunt autem. Ut ab maxime omnis repudiandae amet quia quos.
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...