How to calc IRR on short position?
Hi guys,
Dumb question but as title suggests. How do you calculate IRRs on a short position? Say you sell short at $100 and cover at $50 in year 3. What is the IRR of this trade?
Given this is a positive inflow upfront then negative outflow at cover, excel doesn’t seem to be able to calculate IRR. If IRR is not the right way to frame this, how do you evaluate individual short position returns?
The financial calculator can calculate.
Change the sign of your cash-flows and the sign of the IRR you get?
That was my thinking but also need to include the carrying costs.
Upfront investment is the margin/collateral requirements that must be held against the position
you also need to factor in borrowing costs of the security
I think the distinction being drawn is that the IRR on a long trade can be calculated on an unlevered basis and then any amount of leverage can be applied to get a levered return.
A short position cannot be analyzed the same way because leverage / margin is inherent to the position.
Ut fugit minima sit consequuntur. Culpa fugiat nemo quam repellendus. Sequi quasi fugiat dolor aliquid ut. Numquam explicabo deleniti quidem quae rerum.
Sed nulla nisi sunt soluta consectetur. Laudantium qui labore quod laborum dolore. Numquam dolorum repudiandae et velit nam velit. Reiciendis soluta quos et modi enim.
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...