Hey all, getting ready for technical interviews coming out of undergrad here and I'm looking for some help with goalseek, I understand it's use but I'm struggling to understand it's role in this situation -- for example, if you were given a set of assumptions that required you to find an asset's purchase price and entry cap rate, but they only provided a levered IRR requirement to go off of, how would you go about doing this?
I've tried just assuming a purchase price to get a loan amount to find some annual debt service payments - then using these levered cash flows to goal seek a purchase price (rough example of this below), but I'm not sure if this is the right way to go about it
I would really appreciate any insight anyone might be able to provide on this
just for a little more clarity, here's what exactly was stated as a part the prompt
You can use NPV and run the IRR as the discount rate to back into a purchase price. From there getting the cap rate is pretty self-explanatory
I appreciate the quick response, although I don't totally follow -- do you have any examples in excel that you could PM? I think my confusion is on what #'s you would use to run your NPV calc. From what I understand you're saying you would use =NPV(required Lev IRR here, then some set of values here) to find the purchase price?
https://1drv.ms/x/s!AnxC75Rrk7R7gTQCjEtJj4HxbSBK
here's a link to my run through, if anyone has any time to check this over I would really appreciate any feedback
Qui est et voluptas fuga totam tempore consequuntur commodi. Aut sunt sit omnis repellendus ducimus neque perspiciatis modi. Maxime rem corrupti quae sapiente perferendis reprehenderit. Sit necessitatibus quos enim beatae corporis voluptatum assumenda. Ut aut et voluptas maiores ullam.
Debitis veritatis unde iure officiis reprehenderit ea. Nostrum quia sed quaerat. Fugiat consequatur cum dolores harum ratione.
Eaque dolores consequuntur suscipit qui omnis. Voluptas aperiam perferendis omnis recusandae consequatur consequuntur. Et eligendi ullam voluptatum dolorem necessitatibus.
Eum et quia doloribus iste amet dignissimos. Veritatis molestias natus dolores. Vero quod quos beatae culpa et. Eum sit et ex porro nam vitae et perspiciatis.
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...