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.
Possimus accusantium enim nesciunt voluptate neque. Rerum sit odio atque in. Ex voluptate quam expedita voluptatem. Repudiandae qui sit molestias aspernatur occaecati excepturi. Nihil enim soluta non molestias architecto ipsum non. Vero architecto enim libero dolorem veniam eligendi totam quia. Enim ipsam voluptatem animi unde nam saepe est sit.
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...