You can use the NPV function when the cash flows are of different amounts but the time periods between cash flows is the same.
When an asset DOES NOT have an annuity cash flow pattern, you can use…
Excel Finance Trick 14: Npv Function Capital Invest Decision
05
Oct