How to Use NPV Function in Excel (Net Present Value Easy Guide)

Hello friends! Today we learn about a very smart business formula: the NPV() function in Excel!

What is NPV? It stand for "Net Present Value". If you want to open a coffee shop, you must spend money now, but you will make money later. NPV help you calculate if this coffee shop is a good idea or bad idea by looking at future money! Very smart!

🛠️ How to write NPV Function

To use NPV, you need 2 main things: your discount rate (like the interest rate if you put money in bank instead) and the list of money you get in the future.

Formula Syntax:

=NPV(rate, value1, [value2], ...)

• rate: The discount rate for one period (Usually 1 year).
• value1, value2...: The money you get (or lose) at the end of each year.
• (Wait! Do not put the money you spend TODAY inside the NPV bracket! We must subtract it outside!)

📊 Short & Clear Example

Imagine you want to open a small coffee shop. You spend $10,000 today to buy everything. You think you will make: $3,000 in Year 1, $4,000 in Year 2, and $5,000 in Year 3. The discount rate is 8%.

Is this a good business? Let's check!

Formula for Net Present Value:

=NPV(B5, B2:B4) + B1

• Result: $160.44
• What it means? Because result is positive (more than 0), it means the coffee shop is a GOOD idea! You make $160 more than if you just put the money in the bank!
• Why we put + B1 outside? Because B1 is the money you spend today. NPV only calculate the money you get in the future (Year 1, Year 2, Year 3).

💡 Easy Pro Tips

1. Positive is Good, Negative is Bad: If your final NPV result is positive, do the business! If it is negative, do not do the business! You will lose money.
2. Always keep Today outside: The biggest mistake people make is putting Year 0 (Today) inside the NPV bracket. Always remember to add the initial cost outside the formula!
3. NPV vs PV: PV is for when payments are exactly the same every month. NPV is for when payments change every year (like business profits!).

📚 Useful Resources

• How to Use PV Function in Excel (Find Present Value)
• How to Use FV Function in Excel (Find Future Value)
• How to Use PMT Function in Excel (Calculate Loan Easy)