Modelled index
RWN.ENR.0178.0±35 ptsRWN.AGR.0164.0±39 ptsRWN.INF.0161.0±42 ptsRWN.PRP.0183.0±33 ptsRWN.ENR.0259.0±47 ptsRWN.ENR.0346.0±44 ptsRWN.INF.0268.0±45 ptsRWN.AGR.0257.0±42 ptsRWN.AGR.0362.0±41 ptsRWN.INF.0344.0±44 ptsRWN.INF.0453.0±45 ptsRWN.INF.0566.0±41 ptsRWN.PRP.0261.0±41 ptsRWN.PRP.0363.0±42 ptsRWN.PRP.0448.0±43 ptsRWN.CRD.0171.0±40 ptsRWN.CRD.0258.0±43 ptsRWN.CRD.0388.0±22 ptsRWN.CMD.0179.0±35 ptsRWN.CMD.0239.0±46 ptsRWN.PRP.0546.0±26 ptsRWN.PRP.0640.0±26 ptsRWN.PRP.0754.0±26 ptsRWN.PRP.0858.0±26 ptsRWN.PRP.0954.0±26 ptsRWN.PRP.1048.0±26 ptsRWN.PRP.1148.0±26 ptsRWN.PRP.1240.0±26 ptsRWN.PRP.1340.0±26 ptsRWN.PRP.1448.0±26 ptsRWN.CRD.0464.0±26 ptsRWN.CRD.0548.0±26 ptsRWN.CRD.0640.0±26 ptsRWN.CRD.0754.0±26 ptsRWN.CRD.0840.0±26 ptsRWN.CRD.0958.0±26 ptsRWN.CRD.1058.0±26 ptsRWN.CRD.1134.0±26 ptsRWN.CRD.1258.0±26 ptsRWN.CRD.1348.0±26 ptsRWN.EQU.0148.0±26 ptsRWN.EQU.0234.0±26 ptsRWN.EQU.0348.0±26 ptsRWN.EQU.0434.0±26 ptsRWN.EQU.0540.0±26 ptsRWN.EQU.0634.0±26 ptsRWN.EQU.0740.0±26 ptsRWN.EQU.0840.0±26 ptsRWN.EQU.0948.0±26 ptsRWN.EQU.1048.0±26 ptsRWN.CMD.0358.0±26 ptsRWN.CMD.0448.0±26 ptsRWN.CMD.0534.0±26 ptsRWN.CMD.0640.0±26 ptsRWN.CMD.0734.0±26 ptsRWN.CMD.0840.0±26 ptsRWN.CMD.0934.0±26 ptsRWN.CMD.1048.0±26 ptsRWN.CMD.1140.0±26 ptsRWN.CMD.1234.0±26 ptsRWN.COL.0140.0±26 ptsRWN.COL.0248.0±26 ptsRWN.COL.0348.0±26 ptsRWN.COL.0458.0±26 ptsRWN.COL.0540.0±26 ptsRWN.COL.0640.0±26 ptsRWN.COL.0758.0±26 ptsRWN.COL.0848.0±26 ptsRWN.COL.0958.0±26 ptsRWN.COL.1040.0±26 ptsRWN.DIG.0140.0±26 ptsRWN.DIG.0258.0±26 ptsRWN.DIG.0334.0±26 ptsRWN.DIG.0434.0±26 ptsRWN.DIG.0534.0±26 ptsRWN.DIG.0634.0±26 ptsRWN.DIG.0734.0±26 ptsRWN.DIG.0840.0±26 ptsRWN.DIG.0934.0±26 ptsRWN.DIG.1034.0±26 ptsRWN.CUR.0158.0±26 ptsRWN.CUR.0258.0±26 ptsRWN.CUR.0348.0±26 ptsRWN.CUR.0448.0±26 ptsRWN.CUR.0558.0±26 ptsRWN.CUR.0648.0±26 ptsRWN.CUR.0748.0±26 ptsRWN.CUR.0858.0±26 ptsRWN.CUR.0948.0±26 ptsRWN.CUR.1040.0±26 ptsRWN.ENR.0178.0±35 ptsRWN.AGR.0164.0±39 ptsRWN.INF.0161.0±42 ptsRWN.PRP.0183.0±33 ptsRWN.ENR.0259.0±47 ptsRWN.ENR.0346.0±44 ptsRWN.INF.0268.0±45 ptsRWN.AGR.0257.0±42 ptsRWN.AGR.0362.0±41 ptsRWN.INF.0344.0±44 ptsRWN.INF.0453.0±45 ptsRWN.INF.0566.0±41 ptsRWN.PRP.0261.0±41 ptsRWN.PRP.0363.0±42 ptsRWN.PRP.0448.0±43 ptsRWN.CRD.0171.0±40 ptsRWN.CRD.0258.0±43 ptsRWN.CRD.0388.0±22 ptsRWN.CMD.0179.0±35 ptsRWN.CMD.0239.0±46 ptsRWN.PRP.0546.0±26 ptsRWN.PRP.0640.0±26 ptsRWN.PRP.0754.0±26 ptsRWN.PRP.0858.0±26 ptsRWN.PRP.0954.0±26 ptsRWN.PRP.1048.0±26 ptsRWN.PRP.1148.0±26 ptsRWN.PRP.1240.0±26 ptsRWN.PRP.1340.0±26 ptsRWN.PRP.1448.0±26 ptsRWN.CRD.0464.0±26 ptsRWN.CRD.0548.0±26 ptsRWN.CRD.0640.0±26 ptsRWN.CRD.0754.0±26 ptsRWN.CRD.0840.0±26 ptsRWN.CRD.0958.0±26 ptsRWN.CRD.1058.0±26 ptsRWN.CRD.1134.0±26 ptsRWN.CRD.1258.0±26 ptsRWN.CRD.1348.0±26 ptsRWN.EQU.0148.0±26 ptsRWN.EQU.0234.0±26 ptsRWN.EQU.0348.0±26 ptsRWN.EQU.0434.0±26 ptsRWN.EQU.0540.0±26 ptsRWN.EQU.0634.0±26 ptsRWN.EQU.0740.0±26 ptsRWN.EQU.0840.0±26 ptsRWN.EQU.0948.0±26 ptsRWN.EQU.1048.0±26 ptsRWN.CMD.0358.0±26 ptsRWN.CMD.0448.0±26 ptsRWN.CMD.0534.0±26 ptsRWN.CMD.0640.0±26 ptsRWN.CMD.0734.0±26 ptsRWN.CMD.0840.0±26 ptsRWN.CMD.0934.0±26 ptsRWN.CMD.1048.0±26 ptsRWN.CMD.1140.0±26 ptsRWN.CMD.1234.0±26 ptsRWN.COL.0140.0±26 ptsRWN.COL.0248.0±26 ptsRWN.COL.0348.0±26 ptsRWN.COL.0458.0±26 ptsRWN.COL.0540.0±26 ptsRWN.COL.0640.0±26 ptsRWN.COL.0758.0±26 ptsRWN.COL.0848.0±26 ptsRWN.COL.0958.0±26 ptsRWN.COL.1040.0±26 ptsRWN.DIG.0140.0±26 ptsRWN.DIG.0258.0±26 ptsRWN.DIG.0334.0±26 ptsRWN.DIG.0434.0±26 ptsRWN.DIG.0534.0±26 ptsRWN.DIG.0634.0±26 ptsRWN.DIG.0734.0±26 ptsRWN.DIG.0840.0±26 ptsRWN.DIG.0934.0±26 ptsRWN.DIG.1034.0±26 ptsRWN.CUR.0158.0±26 ptsRWN.CUR.0258.0±26 ptsRWN.CUR.0348.0±26 ptsRWN.CUR.0448.0±26 ptsRWN.CUR.0558.0±26 ptsRWN.CUR.0648.0±26 ptsRWN.CUR.0748.0±26 ptsRWN.CUR.0858.0±26 ptsRWN.CUR.0948.0±26 ptsRWN.CUR.1040.0±26 pts
Frontiers · Digital Farmlands · Stress & sensitivity
Pressure-test the investment.
Shocks applied to your current U.S. Midwest scenario from the Investment lab. Base IRR 4.3%.
Pressure-test the investment.
See how the base case changes when the weather, currency or exit market turns.
| Scenario | IRR | Multiple | NPV | |
|---|---|---|---|---|
| Current case Your current underwriting inputs. | 4.3% | 1.47× | -$27,022 | |
| Dry season Year 3 farm income falls 50%; other assumptions unchanged. | 4.1% | 1.45× | -$28,237 | |
| Currency pressure Local currency loses 5% against USD every year. | -0.9% | 0.92× | -$53,348 | |
| Difficult exit 25% discount on gross terminal asset value. | 2.1% | 1.21× | -$38,984 | |
| Combined downside Land −2%/year, FX −3%/year, income shock and 25% exit discount. | -5.0% | 0.64× | -$66,328 | |
| Productivity upside 5% starting farm income yield, 5% appreciation and 3% income growth. | 8.0% | 1.96× | $260 |
Deterministic scenarios with no probability assigned — not forecasts or confidence intervals.
Appreciation × exit discount
Annual equity IRR; other inputs fixed.
| Growth / discount | 0% | 10% | 20% | 30% |
|---|---|---|---|---|
| -2% / yr | 0.5% | -0.4% | -1.3% | -2.4% |
| 0% / yr | 2.2% | 1.2% | 0.2% | -0.9% |
| 2% / yr | 3.9% | 2.9% | 1.9% | 0.7% |
| 4% / yr | 5.6% | 4.6% | 3.6% | 2.4% |
| 6% / yr | 7.4% | 6.4% | 5.3% | 4.0% |
Green meets your hurdle; amber misses it; red is negative.
Where the model stops
Risk is not just volatility
Appraisal-based land indices smooth observed price movements; they are not comparable with daily traded assets.
Water is a production input
Water-sale revenue must be weighed against lost production. No separate water-trading yield is counted.
Holding longer is not free
No buyer may be available at the modelled exit date. A longer horizon and deeper discount do not ensure liquidity.
Inflation-adjusted NPV
-$27,022 in today's USD at a real hurdle of 5.4%.