A managed farmland sales deck can make almost any opportunity look disciplined, premium, and financially attractive. The usual anchor is a return number, often shown as projected IRR. That number can be useful, but only if the underlying cash flows, dates, costs, and exit assumptions are realistic. Microsoft’s Excel documentation makes the core point clearly: IRR is calculated from a series of cash flows, and XIRR should be used when cash flows are not periodic. Google Sheets says the same for XIRR, which matters because farmland cash flows are rarely neat, equal-period events.
That is why buyers should treat IRR as a model output, not a verdict. A deck can show a polished percentage while hiding optimistic timing, excluded costs, or an exit value doing most of the heavy lifting. If you know how to sanity-check the number, you can ask better questions and compare opportunities more intelligently.
Table of Contents
What IRR tells you, and what it does not
In plain English, IRR is a return figure based on the pattern of money going out and money coming back in over time. It is useful because it reflects timing, not just totals. A project returning money earlier can produce a different IRR from a project returning the same amount later. Microsoft’s guidance on NPV and IRR also notes that these methods are part of discounted cash flow analysis, which is another way of saying that time matters.
But IRR does not tell you whether the assumptions are credible. It does not prove crop maturity will happen on schedule. It does not prove annual maintenance is fully captured. It does not prove you will exit at the value shown in the deck. It only reflects the cash flow pattern that the modeler chose to enter.
That is the first sanity check: do not argue with the number before you inspect the assumptions behind the number.
Why XIRR usually matters more in managed farmland
This is where many decks become less reliable than they look.
Excel’s official documentation says XIRR returns the internal rate of return for a schedule of cash flows that is not necessarily periodic, while IRR is for periodic cash flows. Google Sheets describes XIRR the same way, as the function for potentially irregularly spaced cash flows. Managed farmland usually has irregular cash flows because registration happens one day, development costs may happen later, maintenance may recur annually or seasonally, crop proceeds can be uneven, and the eventual exit date is rarely a clean year-end event.
So when a deck shows one IRR number, ask a simple question: Was this built using IRR or XIRR? If the answer is IRR, ask whether the cash flows were actually periodic. If not, the model may already be oversimplifying the economics.
The 7-point framework to sanity-check farmland IRR claims
1) Check what cash inflows are included
Start with the money coming in. A deck may include:
- crop revenue
- land appreciation
- rental or stay income
- timber or harvest proceeds
- terminal sale value
None of these are automatically wrong. The issue is whether the deck clearly separates them. If a single IRR number blends land appreciation, agricultural output, and a future exit without showing the contribution of each, you do not yet know what is actually driving the result.
A useful question is: If crop income underperforms, does the IRR still hold up, or is the return mostly an exit-price story?
2) Check what cash outflows are missing
This is where many headline return numbers become less impressive.
A reliable model should make room for:
- purchase price
- stamp duty and registration
- development charges
- annual maintenance
- irrigation repairs or replacement
- labor and farm operations
- taxes or transaction costs at exit, where applicable
If the deck uses only the land ticket price and future sale value, it is showing a cleaner number than the buyer will actually experience.
3) Check whether the timing is biologically and operationally realistic
This is one of the most important filters.
A spreadsheet can make year three look attractive, but crops do not care about spreadsheet ambition. Ask:
- When does plantation actually begin?
- When does the crop become commercially meaningful?
- Are the first inflows shown too early?
- Is the exit shown on an unusually favorable timeline?
If the deck assumes smooth, fast monetization with no delay risk, the IRR may be mathematically tidy but operationally weak.
4) Check whether appreciation is doing all the work
A strong-looking IRR can hide a simple truth: most of the modeled return may come from the assumed resale value at the end.
That is not always a problem. Land appreciation is part of many real-asset theses. But you should know whether the opportunity is really an operations-led model, an appreciation-led model, or a mix of both. If the model looks weak without a high terminal value, the deck is less about farmland operations and more about a future buyer paying a premium.
A clean question here is: What percentage of the modeled return comes from exit value versus operating cash flows?
5) Check whether the model uses projected, possible, and committed figures interchangeably
This is a classic sales-deck problem.
Projected crop revenue is not the same as committed income. A possible resale value is not the same as a likely resale value. A best-case scenario is not a base case. When those categories get blended together, the IRR becomes harder to trust.
A credible deck labels assumptions clearly:
- projected
- conservative
- base case
- upside case
- committed or contract-backed, if any
6) Check whether sensitivity changes break the story
The easiest way to test a return model is to change one or two assumptions and watch what happens.
Try these stress tests:
- delay exit by 24 months
- raise annual maintenance
- reduce crop income in the first productive years
- push back first meaningful harvest
- lower terminal sale value
If one modest change collapses the return story, the deck may be less robust than it first appears.
7) Check whether the operator’s execution model supports the math
Numbers do not perform themselves. Farmland returns depend on care, maintenance, monitoring, irrigation reliability, crop planning, and reporting. Hasiru Farms’ Hasiru Care page presents managed farmland as an operating system with daily monitoring, communication, soil-health work, and ongoing agricultural support, while Hasiru Tech highlights technology-enabled owner visibility and digital project interaction. Those are the kinds of operational inputs buyers should look for when deciding whether a projection is supported by execution.
A quick red-flag checklist
Treat these as caution signs:
- one headline IRR number with no visible cash flow table
- no dates attached to inflows and outflows
- crop income starts too early for the crop type and setup
- registration, development, or maintenance costs are absent
- appreciation assumptions are aggressive but unexplained
- no downside scenario is shown
- the model works only if the exit happens right on schedule
- “up to” language is doing too much work
If you spot three or more of these, the right next step is not excitement. It is verification.
A worked example
Here is a simple illustrative comparison.
Deck version
- Initial land payment: ₹30,00,000
- Year 3 crop income: ₹80,000
- Year 4 crop income: ₹1,20,000
- Year 5 crop income plus exit: ₹55,50,000 total
This version produces an annualized return of about 14.1% XIRR in an illustrative model.
Buyer-adjusted version
Now add costs and timing that decks often underplay:
- registration cost on purchase date: ₹2,10,000
- development cost after purchase: ₹1,50,000
- annual maintenance: ₹1,20,000
- same crop inflows, but keep them separate
- exit pushed by one additional year
- exit value softened to ₹52,00,000
Under those assumptions, the illustrative annualized return drops to about 6.8% XIRR.
The point is not that every deck is overstated. The point is that a return number can change materially once you add real dates and real costs. That is exactly why buyers should rebuild the logic before trusting the headline.
Questions to ask the seller before you trust the IRR
Copy these into your notes before the next call:
- Was the return calculated using IRR or XIRR?
- Can you share the full dated cash flow table behind the number?
- Are registration, development, and annual maintenance included?
- What assumptions were used for first crop income?
- How much of the return comes from exit value?
- What is the base case versus the upside case?
- What happens if exit is delayed by two years?
- Which assumptions are contractual, and which are projections only?
- How is farm management quality reflected in the model?
- Can I see the same model with a conservative scenario?
These questions are not hostile. They are buyer hygiene.
When a strong IRR claim is actually credible
A strong IRR claim deserves attention when the operator shows the math openly, dates every major cash flow, includes recurring costs, separates projected outcomes from guaranteed ones, and can explain why the biological timeline is realistic. It also helps when the project has an execution layer that supports ownership visibility and long-term maintenance, because good models should be connected to real operational capability.
This is also where portfolio fit matters. SEBI’s investor education guidance says investment choices should align with financial goals, risk tolerance, and time horizon. So even an honest IRR does not make a project right for every buyer. A solid return model still has to match the buyer’s own plan.
Conclusion
A managed farmland sales deck is supposed to simplify the decision, but a polished IRR number can create false confidence if the assumptions are not visible. The smartest response is not to reject every projection. It is to inspect what drives it.
Sanity-check the inflows. Add the missing costs. Challenge the timing. Separate operations from appreciation. Ask whether XIRR was used. Stress-test the exit. Then decide whether the number still deserves your attention.
That process will not make every opportunity less attractive. It will make your judgment sharper. Explore more hasiru’s managed farmland projects.
FAQs
Is IRR enough to decide on a managed farmland investment?
No. IRR is a useful summary metric, but it is only as good as the assumptions behind the cash flow model. It should be read alongside costs, execution quality, legal clarity, and exit realism.
Why is XIRR often better than IRR for farmland?
Because managed farmland cash flows are often irregularly spaced. Excel and Google Sheets both define XIRR as the function for non-periodic or potentially irregular cash flows.
Is a higher IRR always better?
Not necessarily. A higher IRR built on aggressive assumptions can be less credible than a lower IRR built on transparent cash flows and realistic timing.
What costs are most often left out of deck IRR claims?
Registration, development charges, annual maintenance, replacement costs, and timing slippage are common blind spots in buyer-facing projections.
What is the fastest way to pressure-test a return claim?
Ask for the full dated cash flow table, rebuild it in XIRR, add all recurring costs, and push the exit date back by one or two years.
