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.
Cumque at est eum. Doloribus asperiores incidunt sapiente ipsum at voluptas. Ratione voluptatem rerum tempora libero et. A consectetur iste molestiae perspiciatis et. Nulla exercitationem cupiditate magni impedit a. Culpa possimus corporis eum aperiam eius. Distinctio et odit quibusdam eaque.
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...