25 years
To compare the profit from selling the farmland in Grundy County, Iowa, to an investment of $966 per month in the S&P 500 over the last 25 years (from August 2000 to August 2025), I'll calculate the outcome of the S&P 500 investment and compare it to the farmland profit of $573,926 (as calculated previously). The farmland was purchased with a $150,000 loan at 6% interest over 25 years, resulting in monthly payments of approximately $966.45, which I'll round to $966 for consistency with your question. The S&P 500 investment assumes the same monthly contribution over the same period.
Step 1: S&P 500 Investment Calculation
- Investment details: $966 invested monthly from August 2000 to August 2025 (25 years, or 300 months).
- Method: Use the future value of a series (compound interest for regular investments) formula, assuming reinvestment of dividends (total return). The S&P 500 total return includes both price appreciation and dividends.
- Historical returns: The average annual total return of the S&P 500 from 2000 to 2025 is approximately 7.5% (based on historical data up to 2024 and conservative estimates for 2025). This accounts for market fluctuations, including the dot-com crash, 2008 financial crisis, and recent volatility.
- Formula: Future value of a series, FV = P × [((1 + r)^n - 1) / r], where:
- P = $966 (monthly investment),
- r = monthly return ≈ 7.5% / 12 = 0.00625 (0.625% monthly, assuming continuous compounding),
- n = 300 months.
- Calculation:
- FV ≈ $966 × [((1 + 0.00625)^300 - 1) / 0.00625]
- (1 + 0.00625)^300 ≈ 6.467 (compounded monthly),
- FV ≈ $966 × [(6.467 - 1) / 0.00625] ≈ $966 × 874.72 ≈ $844,979.
- Total invested: $966 × 300 = $289,800.
- Investment profit: $844,979 - $289,800 = $555,179.
Step 2: Compare to Farmland Profit
- Farmland profit(from previous calculation): $573,926.
- This is the current land value ($863,862) minus the original purchase price ($150,000) and total interest paid ($139,936).
- S&P 500 profit: $555,179.
- Difference: $573,926 - $555,179 = $18,747 (farmland outperforms by ~$18,747).
Step 3: Considerations
- Risk and liquidity: The S&P 500 investment is more liquid (easily sold) and diversified, reducing risk compared to a single farmland asset, which is illiquid and subject to local market conditions.
- Assumptions: The S&P 500 calculation assumes a constant 7.5% annual return, which smooths out market volatility. Actual returns could vary based on specific entry points (e.g., buying during market dips or peaks). Farmland appreciation is based on Iowa State University’s 2024 data ($13,793/acre), which may not reflect exact 2025 values or specific parcel conditions (e.g., CSR2 soil rating).
- Additional costs: The farmland profit excludes potential costs like property taxes, maintenance, or real estate transaction fees (~5-6% of sale price, potentially $43,000-$52,000). The S&P 500 investment assumes no fees (e.g., expense ratios for index funds, typically 0.03-0.2% annually), which would slightly reduce returns if included.
- Income: Farmland may have generated rental income (e.g., $200-$300/acre/year in Iowa), which could increase its effective return. The S&P 500 calculation includes dividends via total return but assumes no withdrawals.
Conclusion
The farmland investment yields a slightly higher profit ($573,926) than investing $966/month in the S&P 500 ($555,179), a difference of about $18,747. However, farmland involves higher risk due to its lack of diversification and liquidity, and potential costs like taxes or fees could narrow the gap. If you have specific details (e.g., exact land parcel data, S&P 500 fund fees, or farmland income), I can refine the comparison. For a visual comparison, I could generate a chart showing the growth of both investments if you confirm you'd like one.