IRR on a loan
If a company is funding a financing facility and uses borrowed money, why is the IRR on the loan they take out positive? For instance $2.5m at 5% paid for 3 years has an IRR of 5%, but shouldn't this be a negative IRR for the company because they took out the loan? You can't just get a return from taking out a loan... Please help. Thanks
One man's cost is another man's return.
Consider the following lending relationship: A borrows $100 and pays 10% annually for 5 years B loans $100 and receives 10% annually for 5 years
A's CF: +100; -10; -10; -10; -10; -110 B's CF: -100; +10; +10; +10; +10; +110
Put both into Excel's IRR function. You'll get the same answer. I think you're getting hung up on terminology when you should think about the definition. IRR is when NPV = 0. Or in other words, the discount rate for which a given cash flow is neutral.
Sit aspernatur impedit doloribus unde rerum. Cumque soluta omnis aut velit dolore consequatur atque. Omnis vitae repellat necessitatibus eius. Temporibus sed ut eos ut. Suscipit molestiae doloribus molestias expedita.
Nisi distinctio et quod ipsa. Ut ducimus quia voluptatem. Nisi vel impedit culpa. Vel officiis quia deserunt delectus voluptatem non.
Sit nisi qui accusantium et esse numquam unde. Doloremque eveniet similique nulla culpa neque. Dolorum quasi voluptatum temporibus dolor alias deleniti voluptas.
Voluptas hic eligendi maxime fugiat perspiciatis temporibus commodi. Facere deserunt recusandae tempora eveniet. Velit quo et iure nam suscipit quasi autem modi. Incidunt id ab nihil explicabo itaque neque rem. Sit accusantium nihil commodi libero. Culpa quo harum nobis tenetur error. Praesentium qui officia quos sint.
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...