Why do you have to exclude year 0 in excel when calculating NPV, but not when calculating IRR?

When trying to calculate NPV in Excel, you must exclude the initial investment (year 0) in the formula, and add back this value at the end. Why don't you do the same thing (meaning: exclude year 0) for IRR formula calculation?

NPV is Net Present Value. The technique takes a stream of future payments and discounts by an interest rate to determine what that future stream is worth now. There is no year zero, because that's right now. So the first value will be a payment for the next period or period 1.
IRR is the Internal Rate of Return. Here we're looking for a percentage rate where a future stream of payments will equal an outlay of money today. The money today is considered period zero. It's similiar to NPV but here we're looking for the rate, whereas in NPV we provide the rate.

Tags

　　Venture Capitalist 　　Venture Capital 　　VC Fund 　　Vanguard Fund 　　Value Investment 　　Trust Investment 　　Stock Investment 　　startup Investments

Related information

Sale/Leaseback Home?

Good luck.

...

Fine silver .999 bars vs fine silver .999 coins?

Generally the market for coins is more liquid than the market for bars, hence the premium.

...

Why buy or finance a new car?

The problem with a lease is you pay almost as much money as buying, but you are left with nothing at the end of the lease. In fact you may even owe money if you go over the mileage limits. Whil...

How do Comps affect and appraisal?

Your home will be compared to homes in the neighborhood and adjustments are made to those homes (typically within a 1mi radius and sold w/in 6 mos. For ex. if your house is valued at $145K and is ...

Help me on my finance assignment.......!!!!?

In other words you'd like someone to give you a project that they've already done so that you can turn it in as your own work, right? And what exactly would you learn from that exercis...

Given the following info and assuming str.line depreciation to zero, what is the NPV of this project?

$6844.94

...

Is TurboTax worth it?

If you do (or have done) your own taxes on paper, Turbo tax is GREAT. Buy the deluxe version and your particular state version. I do not have an overly complicated tax return, but ALL the proper fo...

Calculate the project鈥檚 NPV and ARR?

This is a very interesting problem. Best of luck in doing your own homework. This forum is not intended to give readers homework assignments. It is meant for asking intelligent questions in order t...