# NPV and IRR calculator > How much is an investment worth today? Discount a list of yearly cash flows to today's money and find the rate at which the investment breaks even. Calculate the net present value (NPV) and internal rate of return (IRR) of a list of cash flows, with each year's discount factor and present value. - Page: https://how.box/npv/ - Runs entirely in the browser. - License: HowToolbox's own text and data (titles, explanations, FAQs, tool descriptions and schemas, this file) are CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/); AI training and answers are welcome. Attribute "HowToolbox (how.box)" with a link to the page used. Third-party data keeps its own terms; the name and logo are not licensed. Publisher: HowToolbox, contact@how.box. Terms: https://how.box/about/terms/ ## Inputs Answer link: https://how.box/npv/?r={r}&f={f}&n={n}&c={c} - `r` (number -99 to 100): Discount rate per period. Example: `8`. - `f` (array): Cash flows in order, versioned: ~1:id.amount_… (* for the decimal point; 0 may be empty). Example: `[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]`. - `n` (boolean): First flow today (true) or one period from now (false). Example: `true`. - `c` (AED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM, BBD, BDT, BGN, BHD, BIF, BMD, BND, BOB, BRL, BSD, BTN, BWP, BYN, BZD, CAD, CDF, CHF, CLF, CLP, CNY, COP, CRC, CUC, CUP, CVE, CZK, DJF, DKK, DOP, DZD, EGP, ERN, ETB, EUR, FJD, FKP, GBP, GEL, GHS, GIP, GMD, GNF, GTQ, GYD, HKD, HNL, HRK, HTG, HUF, IDR, ILS, INR, IQD, IRR, ISK, JMD, JOD, JPY, KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT, LAK, LBP, LKR, LRD, LSL, LYD, MAD, MDL, MGA, MKD, MMK, MNT, MOP, MRU, MUR, MVR, MWK, MXN, MYR, MZN, NAD, NGN, NIO, NOK, NPR, NZD, OMR, PAB, PEN, PGK, PHP, PKR, PLN, PYG, QAR, RON, RSD, RUB, RWF, SAR, SBD, SCR, SDG, SEK, SGD, SHP, SLE, SLL, SOS, SRD, SSP, STN, SVC, SYP, SZL, THB, TJS, TMT, TND, TOP, TRY, TTD, TWD, TZS, UAH, UGX, USD, UYU, UYW, UZS, VES, VND, VUV, WST, XAF, XCD, XCG, XDR, XOF, XPF, XSU, YER, ZAR, ZMW, ZWG or ZWL): Display currency. Example: `EUR`. Example answer: https://how.box/npv/?r=8&f=%7E1%3Af1.-40000_f2.8000_f3.9200_f4.10000_f5.12000_f6.14500&n=1&c=EUR A complete link carries the primary answer in the page HTML; a missing or invalid value shows the default page. ## Agent tools - `npv_calculate`: Net present value and internal rate of return of a list of cash flows, one per equal period (year). - MCP, one POST to https://how.box/mcp: `{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"npv_calculate","arguments":{"rate_percent":8,"flows":[{"id":"f1","amount":-40000},{"id":"f2","amount":8000},{"id":"f3","amount":9200},{"id":"f4","amount":10000},{"id":"f5","amount":12000},{"id":"f6","amount":14500}],"first_now":true,"currency":"EUR"}}}` - GET: https://how.box/mcp/run/npv_calculate?rate_percent=8&flows=%5B%7B%22id%22%3A%22f1%22%2C%22amount%22%3A-40000%7D%2C%7B%22id%22%3A%22f2%22%2C%22amount%22%3A8000%7D%2C%7B%22id%22%3A%22f3%22%2C%22amount%22%3A9200%7D%2C%7B%22id%22%3A%22f4%22%2C%22amount%22%3A10000%7D%2C%7B%22id%22%3A%22f5%22%2C%22amount%22%3A12000%7D%2C%7B%22id%22%3A%22f6%22%2C%22amount%22%3A14500%7D%5D&first_now=true¤cy=EUR ## How it works Money today is worth more than the same money later, because today's money could already be earning a return. Net present value (NPV) turns every future cash flow into today's money and adds them up. A positive NPV means the investment beats the discount rate; a negative one means it does not. NPV = Σ CFₜ / (1 + r)ᵗ, where CFₜ is the cash flow of year t and r the discount rate. The internal rate of return (IRR) is the rate r at which NPV is exactly zero. These are the definitions behind Microsoft's NPV and IRR spreadsheet functions; turn off "First cash flow is today" to match the spreadsheet NPV, which discounts the first value too. When the cash flows change sign more than once, there can be several IRRs, and all of them are shown. The result is only as good as the forecast and the rate you choose. It assumes equal periods and flows at the end of each year, and no taxes or inflation beyond what the rate already includes. ## FAQ **What discount rate should I use?** The return you would expect from another investment of similar risk, or your cost of borrowing. A higher rate lowers the value of later cash flows. **Why does a spreadsheet give a different NPV?** The spreadsheet NPV function treats its first value as one year from now. Turn off "First cash flow is today" to get the same number, or add the initial investment outside the function as the spreadsheet help suggests. **Why are there several IRRs, or none?** An IRR exists only when the cash flows include both money paid out and money received. If they switch between negative and positive more than once, more than one rate can make the NPV zero; then the NPV at your own rate is the better guide. **Can I enter a year with no cash flow?** Yes. Add a zero for that year so later payments stay in their correct periods. **Is the undiscounted total the same as NPV?** Only at a zero discount rate. Otherwise NPV also reflects when each payment arrives. More: [HowToolbox index](https://how.box/llms.txt) · [Agent Skill](https://how.box/skill.md) · [agent terms](https://how.box/about/agents/)