How to calculate NPV and IRR？

NPV (Net Present Value) and IRR (Internal Rate of Return) are two important financial metrics used to evaluate the profitability of an investment project. Here are the steps to calculate NPV and IRR:

Calculating NPV:

Step 1: Determine the expected cash flows for each year of the investment project.

Step 2: Determine the discount rate, which is the rate of return required by the investor to undertake the project.

Step 3: Use the following formula to calculate the NPV:

NPV = ∑(Cash flow / (1+discount rate)^n)

Where n is the year of the cash flow.

Step 4: If the NPV is positive, the project is profitable and should be considered for investment. If the NPV is negative, the project is not profitable and should be rejected.

Calculating IRR:

Step 1: Determine the expected cash flows for each year of the investment project.

Step 2: Use the following formula to calculate the IRR:

0 = ∑(Cash flow / (1+IRR)^n)

Where n is the year of the cash flow.

Step 3: Use trial and error method or Excel's IRR function to find the IRR that makes the above equation equal to zero.

Step 4: If the IRR is greater than the required rate of return, the project is profitable and should be considered for investment. If the IRR is less than the required rate of return, the project is not profitable and should be rejected.