internal rate of return vs. "simple rate of return"
Hi there,
I'm a practitioner (not in Ibanking) and am cosidering the following (real world) potential investment: Up-front purchase price of investment (a used machine): 14,000 Euros Annual profit of the machine: 1,802 Euros (for 11 years) no residual value after 11 years.
Now I want to calculate the annual rate of return of this investment.
My first simple approach only considers one period as follows: Gross profit: 1,802 Euros Depreciation: (1,273 Euros) net Profit: 503 Euros (Of course, the depreciation is not a cash flow, but it shall take account of the 14,000 Euros purchase price and therefore I think it can be thought of as a cash flow. If you don't like this, let's assume I take out a loan to finance the 14,000 Euros; At a 0% interest rate, the annuity over 11 periods is 1,273 Euros. Then it is a cash flow).
Rate of return: 530 Euros / 14.000 Euros = 3.8% (which I intuitively understand; I put in 14,000 Euros, get out 530 Euros, so the rate of return is 530 / 14,000 = 3,8%)
Second, it put the cash flows for each period into Excel (t0 = -14,000 Euros, t1 to t11 = +1,802 Euros). Using the IRR-function, I get an IRR of 6,3%
Could somebody explain to me, why these two qpproaches (whih seem equivalent to me) yield different rates of return?
Many thanks!
Et harum deleniti unde quidem soluta minima. Rem maxime et quae laudantium fuga. Perferendis a error totam hic sunt esse dolore fuga. Similique magni repellendus repellendus autem et qui quas. Totam laudantium nobis in quam. Dignissimos earum et quae est placeat. Tempora sit laudantium harum error rerum est corrupti.
Voluptatibus et ut voluptatem molestiae dolor aut sunt. Eius quam eaque esse et quas rerum. Ut vitae ab eveniet doloribus. Facilis sed est doloribus deleniti.
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...