BUSINESS & FINANCE

NPV in Excel: Discounted Cash Flow Example for Students

Study npv in excel through a worked example, a self-check and a common error to avoid. Free college guide plus optional 1:1 tutoring.

Student learning resource6 min read

If you are studying npv in excel in a US college course, start by understanding what the problem asks before reaching for a formula or copying a solution. Net present value discounts future cash inflows to today and subtracts the initial investment. Excel's NPV function discounts the cash flows entered as future periods. This short learning guide offers an original example, a way to check the reasoning, and an independent practice question. Your instructor's directions and course-specific notation take priority.

WHAT YOU'LL LEARN

A quick look at this guide

Jump to a topic below, or read the entire article for explanations and examples.

  1. What to recognize in a npv in excel problem
  2. Worked example with steps
  3. Why the method works and how to verify it
  4. Independent practice and a suggested solution

Practical takeaways

  • State exactly what you are trying to find or explain.
  • List known values, conditions and units where applicable.
  • Check assumptions before applying a named formula or method.
  • Explain the choice of method in your own words.

What to recognize in a npv in excel problem

Net present value discounts future cash inflows to today and subtracts the initial investment. Excel's NPV function discounts the cash flows entered as future periods.

Before solving, identify the given information, the unknown result, and any assumptions or restrictions. Write those down separately. Ask which method fits the structure of the question and whether another approach would be simpler. This habit is useful when a college problem looks slightly different from the example shown in class.

  • State exactly what you are trying to find or explain.

  • List known values, conditions and units where applicable.

  • Check assumptions before applying a named formula or method.

Worked example with steps

The following illustration shows a concrete version of the question. Follow each transformation and ask what justifies moving to the next line. The goal is to understand a method you can reuse, rather than memorize one answer.

Because the present value of three future $400 inflows is slightly below $1,000 at this rate, the project has a small negative NPV.

Example / walkthrough
Initial cost today: −$1,000
Cash inflow: $400 at end of years 1,2,3
Discount rate: 10%
Excel: =NPV(10%,400,400,400)-1000
Result ≈ −$5.26

Why the method works and how to verify it

Because the present value of three future $400 inflows is slightly below $1,000 at this rate, the project has a small negative NPV.

Year-0 initial costs should normally be placed outside Excel's NPV function; cash flows need consistent timing.

A convincing solution includes the reasoning and a check. Look for a unit mismatch, a missing condition, an implausible sign, an unintended duplicate row, or another inconsistency relevant to this specific topic. If you get a different answer, compare the first step where the two approaches diverge.

Independent practice and a suggested solution

If the discount rate falls while positive future cash flows stay fixed, what usually happens to NPV?

Try to solve it yourself before reading the model response. Explain your choice of method in one sentence and, where possible, verify the result by substitution, differentiation, testing or checking against the question.

Suggested answer: NPV generally increases because future cash flows are discounted less heavily.

A common mistake and a better approach

Including the immediate investment inside NPV shifts its timing by one period and can produce a wrong valuation.

When reviewing your own work, read the prompt again and compare it with the conclusion you wrote. A correct-looking calculation can still answer a different question. Keep a record of the step that confused you so a tutor or instructor can address that exact gap.

  • Explain the choice of method in your own words.

  • Show intermediate steps rather than jumping to a result.

  • Check whether the conclusion matches the scope of the question.

Related study guide and optional one-to-one tutoring

For more background, explore our related college learning resource. If the next problem still feels unclear, see the relevant one-to-one tutoring service. Tutoring is for instruction, guided practice and feedback on your own work. Subject fit, availability and a fixed quote are confirmed before payment; no exam taking or submission-ready work is offered.

KEEP LEARNING

Understanding the concept is the first step.

Explore related resources or learn about subject-focused tutoring designed to help you understand the material.

Tutoring and feedback should support your learning. Follow your institution's academic-integrity rules and submit work that is your own.

Working against a deadline? See deadline-sensitive support options.