IRR and NPV: how to evaluate an investment when costs and revenue are in different currencies
IRR and NPV give a reliable answer only when cash flows and the discount rate share one currency and the projected exchange rate is consistent with inflation in both economies.
A CFO comparing a project with dollar revenue and peso costs often receives a single figure, an IRR of 20%, with no indication of the currency it was calculated in or the exchange rate behind it. That figure may be correct, optimistic, or simply not comparable with the minimum return the investment committee requires.
At Soulbit Academy, this article opens a series on financial valuation for Latin American corporate treasuries. It explains what IRR and net present value measure, works through a calculation you can reproduce in a spreadsheet, and shows how to discount when costs and revenue sit in different currencies. Later installments will cover the cost of capital and free cash flow.
IRR and NPV: what they measure and how they are calculated
Net present value (NPV) is the sum of a project's future cash flows, each discounted at a rate that reflects the cost of capital and risk, minus the initial investment. The internal rate of return (IRR) is the discount rate that makes that NPV equal to zero.
The NPV formula adds, for each year t, that year's cash flow divided by (1 + r) raised to t, where r is the discount rate and year 0 is the investment, entered as a negative. A positive NPV means the project earns more than the required rate; a negative one, less.
IRR has no closed-form solution: it is found by successive approximation, and spreadsheets do it with the IRR function. The decision rule is simple: if the IRR exceeds the company's minimum required return, the project is acceptable.
Which discount rate should a company use to calculate NPV?
It should use its cost of capital adjusted for the project's risk, expressed in the same currency as the cash flows. Estimating that cost of capital is the subject of the next installment; here we use an assumed rate to isolate the mechanics.
Complete worked example: investment, five years of cash flows, NPV and IRR
A project with an investment of 1,000 (in thousands of dollars) and net flows of 260, 300, 340, 360 and 380 in years 1 to 5, discounted at 10%, has an NPV of 221.6 and an IRR of 17.8%. Every figure in this section is an illustrative assumption, not data from a real company or from Soulbit.
The setup: a hypothetical Mexican manufacturer expands a plant to serve export orders. The net flows already subtract operating costs from revenue and are stated in thousands of dollars. The assumed dollar discount rate is 10%.
| Year | Net flow (USD thousand) | Discount factor at 10% | Present value (USD thousand) |
|---|---|---|---|
| 0 | -1,000 | 1.0000 | -1,000.0 |
| 1 | 260 | 0.9091 | 236.4 |
| 2 | 300 | 0.8264 | 247.9 |
| 3 | 340 | 0.7513 | 255.5 |
| 4 | 360 | 0.6830 | 245.9 |
| 5 | 380 | 0.6209 | 235.9 |
| NPV at 10% | 221.6 |
To reproduce it in a spreadsheet, apply the NPV function to the year 1 to 5 flows and subtract the initial investment, or compute each present value as the flow divided by 1.10 raised to the year. The IRR of the six flows is 17.77%.
NPV depends on the required rate: at 12% it would be 157.7, at 15% it would be 71.2, and at 18% it turns negative at -5.5. That is why the 17.8% IRR marks the threshold: any required rate below it leaves a positive NPV.
What does an NPV of 221.6 thousand dollars mean?
It means that after recovering the investment and rewarding capital at 10%, the project creates 221.6 thousand dollars of value in today's terms. It is not an accounting profit, nor a cash flow received in any particular year.
Limits of IRR: multiple rates, interim flows and scale
IRR may not be unique and does not measure the absolute value created. It also excludes returns earned after interim cash flows leave the project. Read it alongside NPV.
First, multiple IRRs. When cash flows change sign more than once, for example an initial outlay, a gain and then a closing cost, the equation can have several solutions. With flows of -100, +300 and -200, the IRRs are 0% and 100%, and neither helps decide.
Second, interim flows. IRR measures the project itself; it does not specify how distributions are reinvested. To model that separate decision, use a modified IRR with an explicit reinvestment rate.
Third, scale. Project A invests 100 and receives 150 a year later: its IRR is 50% and its NPV at 10% is 36.4. Project B invests 1,000 and receives 1,200 a year later: its IRR is 20% and its NPV is 90.9. If they are mutually exclusive, B creates more value despite the lower IRR.
When should a company decide by NPV rather than IRR?
It should decide by NPV when projects are mutually exclusive, differ in size or duration, or have flows that change sign more than once. IRR remains useful as a quick read of the margin over the required rate.
A project with costs and revenue in different currencies: discount in one currency
When costs and revenue are in different currencies, the correct procedure is to convert each annual flow into one currency at a projected exchange rate for that year and discount with a rate in that same currency. The chosen currency is usually the company's functional currency.
If revenue is in dollars and costs are in pesos, project the exchange rate for each year, convert revenue to pesos, subtract costs, and obtain an annual net flow in pesos. Then discount with a peso rate. Choosing pesos or dollars as the calculation currency does not change the NPV if the projection is consistent, only how it is expressed.
The example assumes relative purchasing power parity for the exchange rate; this is a model, not a forecast. Under that assumption, convert the discount rate as follows: (1 + peso rate) = (1 + dollar rate) × (1 + peso inflation) / (1 + dollar inflation). See Damodaran’s currency conversion method.
Suppose, as an example, an initial rate of 18.00 pesos per dollar, assumed inflation of 4.0% in pesos and 2.5% in dollars, and a dollar discount rate of 10%. The equivalent peso rate is 11.61%. The projected exchange rate rises 1.46% a year: 18.26 in year 1 and 19.36 in year 5.
Official targets are the reference; the example's 4.0% is above them and is a scenario, not a forecast. Banxico keeps a 3% target with a variability interval of one percentage point, while Banco de la República sets its target at 3.0% a year. Expected inflation over five years can differ from the target, and the difference should be documented.
These long-run assumptions must be coordinated with the annual budget assumption. To set that starting point and the scenario bands, see which exchange rate assumption to use in the 2027 budget. To turn the project into monthly flows, rely on the cash flow forecast for foreign currency revenue.
The error of mixing flows in one currency with a rate in another
The most frequent error is discounting dollar flows with a peso rate, or peso flows with a dollar rate, without adjusting the projected exchange rate. Each inconsistent combination biases the NPV in a predictable direction.
With the example project (18.00 pesos per dollar, rates of 10% and 11.61%), the consistent NPV is 3,988.4 thousand pesos, equal to 221.6 thousand dollars at the initial rate. In thousands of pesos, the flows are: -18,000.0; 4,748.5; 5,559.2; 6,392.6; 6,867.7 and 7,355.4. Their IRR is 19.5%, against 17.8% in dollars: the same project, with depreciation built in.
| Calculation method | What is done | NPV (thousand pesos) | Reading |
|---|---|---|---|
| Consistent in pesos | Peso flows at the projected exchange rate, peso rate of 11.61% | 3,988.4 | Correct |
| Consistent in dollars | Dollar flows, 10% rate, result converted at the initial rate | 3,988.4 | Correct, same value |
| Dollars at a fixed rate, peso discount rate | Dollar flows converted at 18.00 every year, discounted at 11.61% | 3,055.7 | Understates the project |
| Pesos with depreciation, dollar discount rate | Projected peso flows discounted at 10% | 4,971.9 | Overstates the project |
The reasoning is logical. If the exchange rate is frozen at 18.00 but the discount rate is in pesos and already includes inflation, the flow is penalized twice: the depreciation that offsets that inflation is ignored. In the opposite case, a peso flow that already grows with depreciation, discounted at the dollar rate, is rewarded twice.
Can today's exchange rate be used for every year of the project?
Only if the discount rate is in the same currency as the original flows. Freezing the rate requires discounting at the dollar rate and converting at the end; combining it with a peso rate produces the bias in row three of Table 2.
One last check: the dollar and peso costs of capital are not chosen separately. If the company funds the project with debt, the currency of that liability matters, as discussed in the article on financial leverage and the currency of debt. And the policy that approves these decisions lives in the treasury policy template.
Checklist before presenting the evaluation to the committee
Before presenting an IRR and NPV evaluation, the finance team should check five points: a single currency, a consistent rate, a documented exchange rate projection, scenarios, and a joint reading of NPV and IRR. This checklist fits on one page and heads off most objections.
The first is a single currency: all flows and the discount rate in the same unit. The second is a consistent rate: the equivalence between dollars and pesos is derived from inflation differentials, not chosen separately. The third is the projected exchange rate, with date, method and source.
The fourth is scenarios: a base case, one with greater depreciation and one with less, and the NPV of each. The fifth is the joint reading: NPV to decide, IRR to compare against the required rate, and a note if flows change sign more than once.
What happens if the project switches currency midway?
The switch forces the later flows to be recalculated in the new currency and the transition exchange rate assumption to be documented. Adjusting the rate is not enough: each year's flow must be expressed in the currency in which it is discounted.
What Soulbit does today and what remains the company's decision
Soulbit does not evaluate investments, does not calculate a project's IRR, does not hedge currency risk and does not offer derivatives or financial advice. The discount rate, the projected exchange rate and the decision to invest remain with the company and its committee.
What Soulbit V1 offers is a place to hold the dollar portion of a project's treasury: balances in USDC and USDT, fiat in USD, EUR and GBP, and OTC quote-based conversion (eOTC) when the company decides to move into local currency, with a local bank rail in Colombia only. That balance earns no yield and should not be used as a reference for the discount rate.
To see how that conversion works, read what OTC crypto means for treasuries. A company that has already decided to keep part of its cash in dollars can review the proportion in how much cash should be in dollars.
Frequently asked questions
What is IRR and how does it relate to NPV?
The internal rate of return (IRR) is the discount rate at which a project's net present value (NPV) equals zero. If the IRR exceeds the minimum return the company requires, the NPV is positive and the project creates value, provided the cash flows follow the usual sign pattern.
What is the difference between NPV and IRR when choosing between two projects?
NPV measures how much value a project creates in currency units; IRR measures its return per unit invested. For mutually exclusive projects of different size, NPV is usually the more reliable criterion, because IRR can favor a small project that creates less total value.
How do you evaluate a project with revenue in dollars and costs in pesos?
A company should convert each annual flow into a single currency at a projected exchange rate for that year and discount with a rate in that same currency. Mixing dollar flows with a peso rate, or the reverse, distorts both the NPV and the IRR.
How do you project the exchange rate for a multi-year project?
A common method is relative purchasing power parity: the currency with higher inflation depreciates by roughly the inflation differential. It is a planning assumption, not a forecast, and should be tested against scenarios such as those used in the annual budget.
Can Soulbit calculate IRR or hedge a project's currency risk?
No. Soulbit V1 does not evaluate investments, offer derivatives or hedge currency risk. It offers balances in USDC and USDT, fiat in USD, EUR and GBP, and OTC quote-based conversion (eOTC) to hold the dollar portion of a project's treasury, without yield.
Want your company to add stablecoins to its operations?
Join the Soulbit waitlist and start paying payroll, collecting and managing treasury without SWIFT.
Join the waitlist