Gut checks
How do you guys check your increase or decrease in IRR/NPV/whatever when changing multiple leasing assumptions (market rent, RCD, market rent growth) for multiple tenants in argus?
If I have enough time, I try to see where the change comes (cash flow or reversion) and what the change is...and then try to use my new assumptions to backsolve for that number to make sure they match or are at least close. It works, but it is inefficient sometimes. I think I'm approaching it the wrong way. How do you guys usually gut check your IRR changes?
Not sure if I get what the solution should be, but I would just start picking variables and work through a set of sensitivity analyses. You can probably find a guide for this with a simple Google search.
On another note: I saw that you wrote that you're looking to do this in Argus. Maybe this doesn't apply then.
Save each version of your model as you change inputs and name them in a unique manner so that you can identify what is what.
I would: 1). make the changes in Argus (save a copy of the model), 2). Export the cash flows to excel, 3). Build an excel model for your waterfall, 4). use the excel model to build a sensitivity table. This is pretty standard. Don't use Argus for your levered IRR / equity multiples, etc, use Argus to get cash flows
Doloremque qui aspernatur non minus. Nihil commodi non in eos tempora et et mollitia. Architecto nihil omnis ut doloribus. Quis rerum ab eius porro qui in. Illo dignissimos rem qui iure. Ea quis eius magnam omnis non voluptatum laborum.
Quo voluptatibus sunt eveniet deleniti. Tempore fugiat dolores quaerat expedita voluptas molestias nesciunt.
Tenetur cupiditate laborum quaerat voluptates consequatur quos. Laboriosam autem praesentium culpa sit perspiciatis. Esse repudiandae quis omnis natus voluptas consequatur. Velit nihil aliquid delectus dolor.
Deleniti culpa ullam necessitatibus eum. Provident excepturi officia ut vel sit molestias explicabo consectetur. Quia consequatur incidunt et rerum incidunt temporibus ut blanditiis. Debitis facilis cumque rerum. Fugiat doloribus sit ex reprehenderit.
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...