---
title: "FV, NPV and IRR in Excel: practice exercises | ExcelSavvy"
description: "Practice FV, NPV and IRR in a live spreadsheet. A savings plan, the net present value of a project and its rate of return."
canonical_url: "https://excelsavvy.com/practice/investments"
meta:
  "og:description": "Practice FV, NPV and IRR in a live spreadsheet. A savings plan, the net present value of a project and its rate of return."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RlYsIE5QViBhbmQgSVJSIGluIEV4Y2VsOiBwcmFjdGljZSBleGVyY2lzZXM%2Cdescription_~UHJhY3RpY2UgRlYsIE5QViBhbmQgSVJSIGluIGEgbGl2ZSBzcHJlYWRzaGVldC4gQSBzYXZpbmdzIHBsYW4sIHRoZSBuZXQgcHJlc2VudCB2YWx1ZSBvZiBhIHByb2plY3QgYW5kIGl0cyByYXRlIG9mIHJldHVybi4%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiU2F2aW5ncyBwbGFuIiwiVmFsdWUiXX0seyJuIjoyLCJjZWxscyI6WyJTYXZlZCBlYWNoIG1vbnRoIiwiNTAwIl19LHsibiI6MywiY2VsbHMiOlsiSW50ZXJlc3QgcmF0ZSBwZXIgeWVhciIsIjAuMDQiXX0seyJuIjo0LCJjZWxscyI6WyJZZWFycyIsIjEwIl19LHsibiI6NSwiY2VsbHMiOlsiQmFsYW5jZSBhdCB0aGUgZW5kIiwiIl19XSwidGFyZ2V0IjpbNCwxXX19%2Cp_Ii9wcmFjdGljZS9pbnZlc3RtZW50cyI%2Cs_wZmPj6fq7E_hygtf.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "FV, NPV and IRR in Excel: practice exercises | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RlYsIE5QViBhbmQgSVJSIGluIEV4Y2VsOiBwcmFjdGljZSBleGVyY2lzZXM%2Cdescription_~UHJhY3RpY2UgRlYsIE5QViBhbmQgSVJSIGluIGEgbGl2ZSBzcHJlYWRzaGVldC4gQSBzYXZpbmdzIHBsYW4sIHRoZSBuZXQgcHJlc2VudCB2YWx1ZSBvZiBhIHByb2plY3QgYW5kIGl0cyByYXRlIG9mIHJldHVybi4%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiU2F2aW5ncyBwbGFuIiwiVmFsdWUiXX0seyJuIjoyLCJjZWxscyI6WyJTYXZlZCBlYWNoIG1vbnRoIiwiNTAwIl19LHsibiI6MywiY2VsbHMiOlsiSW50ZXJlc3QgcmF0ZSBwZXIgeWVhciIsIjAuMDQiXX0seyJuIjo0LCJjZWxscyI6WyJZZWFycyIsIjEwIl19LHsibiI6NSwiY2VsbHMiOlsiQmFsYW5jZSBhdCB0aGUgZW5kIiwiIl19XSwidGFyZ2V0IjpbNCwxXX19%2Cp_Ii9wcmFjdGljZS9pbnZlc3RtZW50cyI%2Cs_wZmPj6fq7E_hygtf.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **Investments: FV, NPV and IRR practice exercises**

What savings grow to, what future cash flows are worth today and the return an investment makes: the three formulas behind most finance test questions.

[**Start the first exercise**](https://excelsavvy.com/practice/investments/fv-savings)

FV(IRR(NPV(

## **How FV, NPV and IRR work**

These three functions answer the main questions of investing. FV tells you what savings grow to, from a rate, a number of periods and a deposit. NPV tells you what future cash flows are worth today at a discount rate. IRR returns the yearly rate of return an investment earns from its cash flows.

For a savings plan with 500 a month at 5% a year for 10 years, `**=FV(B3/12,B4*12,-B2)**` returns 77,641.14. The deposit has a minus sign because it is money going out. For a project with -10,000 in year 0 (B2) and 3,000, 4,000, 5,000 and 6,000 in years 1 to 4 (B3:B6), `**=NPV(E1,B3:B6)+B2**` at 8% in E1 returns 4,586.47, and `**=IRR(B2:B6)**` returns 24.9%.

The classic NPV mistake is the first value. NPV treats it as one period from now, so leave the year 0 investment out of the range and add it afterward, as above. IRR is the opposite: it needs the year 0 investment as its first value, plus at least one positive cash flow. The exercises below cover a savings plan with FV, net present value and the rate of return with IRR.

1. [**1****What savings grow to with FV**In B5, work out what the savings grow to with FV: the monthly rate, the number of months and the monthly deposit as money going out, FV(B3/12,B4\*12,-B2).](https://excelsavvy.com/practice/investments/fv-savings)
2. [**2****Net present value with NPV****Premium**In E2, work out the project's net present value at the rate in E1. NPV discounts every value it gets, so give it years 1 to 4 and add the year 0 investment after: NPV(E1,B3:B6)+B2.](https://excelsavvy.com/practice/investments/npv-net-present-value)
3. [**3****Rate of return with IRR****Premium**In E1, work out the project's internal rate of return with IRR. Give it every cash flow, starting with the year 0 investment.](https://excelsavvy.com/practice/investments/irr-rate-of-return)

## **Functions in this topic**

- [**FV**](https://excelsavvy.com/functions/fv)
- [**IRR**](https://excelsavvy.com/functions/irr)
- [**NPV**](https://excelsavvy.com/functions/npv)

## **Questions**

<details>

<summary>

### How do I calculate compound interest in Excel?

</summary>

Use FV with a single deposit and no regular payments: =FV(B3,B4,0,-B2). With 1,000 in B2, a 5% rate in B3 and 10 years in B4, it returns 1,628.89. If the interest is added monthly, use B3/12 and B4\*12 instead.

</details>

<details>

<summary>

### Why does IRR return #NUM!?

</summary>

IRR needs at least one negative and one positive cash flow, such as an investment followed by income. Check the signs first. If they are fine, Excel may need a starting guess as the second argument, as in =IRR(B2:B6,0.1), so it can home in on the rate.

</details>

<details>

<summary>

### What does a negative NPV mean?

</summary>

The project earns less than the discount rate you used, so it does not pay off at that rate. A positive NPV means it earns more. The IRR tells the same story: when the NPV is above 0, the IRR is above the discount rate.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/investments#webpage","description":"Practice FV, NPV and IRR in a live spreadsheet. A savings plan, the net present value of a project and its rate of return.","name":"FV, NPV and IRR in Excel: practice exercises","url":"https://excelsavvy.com/practice/investments","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/investments#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/investments#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/investments#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/investments#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/investments"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/investments#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"FV, NPV and IRR in Excel: practice exercises","position":3}]},{"@id":"https://excelsavvy.com/practice/investments#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I calculate compound interest in Excel?","acceptedAnswer":{"@type":"Answer","text":"Use FV with a single deposit and no regular payments: =FV(B3,B4,0,-B2). With 1,000 in B2, a 5% rate in B3 and 10 years in B4, it returns 1,628.89. If the interest is added monthly, use B3/12 and B4*12 instead."}},{"@id":"https://excelsavvy.com/practice/investments#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does IRR return #NUM!?","acceptedAnswer":{"@type":"Answer","text":"IRR needs at least one negative and one positive cash flow, such as an investment followed by income. Check the signs first. If they are fine, Excel may need a starting guess as the second argument, as in =IRR(B2:B6,0.1), so it can home in on the rate."}},{"@id":"https://excelsavvy.com/practice/investments#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"What does a negative NPV mean?","acceptedAnswer":{"@type":"Answer","text":"The project earns less than the discount rate you used, so it does not pay off at that rate. A positive NPV means it earns more. The IRR tells the same story: when the NPV is above 0, the IRR is above the discount rate."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
