Rural Real Estate Investment Calculator
Model acquisition costs, blended income (rental, ag/grazing, recreational), operating expenses, and financing to estimate return on a larger rural property.
This tool produces estimates only, based entirely on the assumptions you enter — it is not an appraisal and not financial, legal, or tax advice. Before making a purchase decision, complete independent due diligence: a licensed appraisal, title search, survey, water/mineral rights review, zoning and land-use check, environmental and structural inspections, and consultation with qualified professionals (attorney, CPA, lender, local broker).
Everything paid to acquire and ready the property.
–
Land value and improvement value are tied together — they always add up to the purchase price. Enter whichever side you actually know and the other is filled in automatically.
–
Land and buildings/improvements often appreciate at different rates — set a rate for each. (The purchase-price split between the two is set in section 1.)
The improvement value still grows (or shrinks) at the appreciation rate above to project a replacement-cost-new figure at exit; each stage below is then applied to the value remaining after the prior stage — physical first, then functional, then external, following standard cost-approach practice — and applies in full throughout the hold, not scaled down by how long the property has been held.
Cash purchase or a loan — the calculator supports either, including a balloon structure (a loan amortized over a longer schedule than its actual term, such as a 20-year amortization with a 10-year term). Set the loan term shorter than the amortization period to model a balloon. If the term falls before your exit — say a 20-year hold with a balloon at year 5 or 10 — the remaining balance is assumed paid off in cash that year, and the property is held debt-free from then through your exit; if the term instead lands at or after your exit, the balance is simply carried and settled from sale proceeds. Either way, no mid-hold refinance (new rate or new terms) is modeled.
–
Agricultural, grazing, and other land-based lease income. Enter a flat annual amount, or switch a line to units × rate (acres, AUM, etc.) and it'll compute the annual figure for you. Each line defaults to starting in Year 1 and running through the end of the hold — set a later "Starts in year" if that income doesn't begin right away (a lease that starts in Year 2, for example), and an "Ends in year" if it stops before the hold is over (a lease that expires in Year 5, for example). No income is counted for a line before its start year or after its end year; growth and any year overrides above still apply while it's active.
Applied only to the land & lease income above — recreational and structure rentals below carry their own vacancy rates, since risk profiles differ.
Hunting, fishing, and other recreational access leases or day-use fees — tracked separately from row-crop and grazing leases since pricing and collection risk usually differ. Each line defaults to starting in Year 1 and running through the end of the hold — set a later "Starts in year" if that income doesn't begin right away, and an "Ends in year" if it stops before the hold is over.
Applied only to recreational income above.
Houses, guest cabins, barn apartments, employee housing, or other structures rented separately from the land itself. Optionally give each an estimated value — if you fill these in, they replace the improvement value from section 1 for appreciation, depreciation, and sale price. Each structure can also be given its own depreciation rate at exit. Each line defaults to starting in Year 1 and running through the end of the hold — set a later "Starts in year" for a short-term rental or other structure that won't be built/operating until partway through the hold, and an "Ends in year" if the rental stops before the hold is over; no income is counted for it before its start year or after its end year.
Applied only to structure rental income — typically carries more turnover/vacancy risk than land or lease income.
Total income (land & lease + recreational + structure rental, combined) normally grows smoothly at the income growth rate set in section 2 (Appreciation & growth). Use this to override specific years — a ramp-up year, a lease gap, a one-time step change — as a percent of what that year would otherwise be. Years not listed here are unaffected.
No year overrides entered — income follows the smooth growth rate set in section 2 (Appreciation & growth) for every year.
Recurring annual costs, excluding debt service.
One-time costs at a specific point in the hold — a new roof, well or septic replacement, fencing, or all-new structures like a dwelling, barn, or indoor arena. Each reduces cash flow in the year it occurs.
Entries with a year beyond your holding period are ignored. Every capital expenditure reduces that year's cash flow (and total ROI) but is not added to the initial cash-invested basis. Check "New structure — adds to property value at exit" for anything that's genuinely new construction (a dwelling, barn, indoor arena, added guest cabin, etc.) — that amount then appreciates at the improvement rate from the year it's built, and you can optionally set its own physical/functional/external depreciation rate. Those rates apply in full for any year the structure exists — they're your own judgment call for this structure, not scaled down based on how recently it was built. Both the appreciated and depreciated value flow into property value, equity, and Net Sale Proceeds. Leave it unchecked for repairs/replacements (roof, fencing) that just maintain the property rather than adding to it.
Costs incurred to sell the property — commission, marketing, buyer concessions, etc. Each can be set as a percent of the final sale price or a flat dollar amount, and all are subtracted (along with any remaining loan balance) to arrive at Net Sale Proceeds.
–
Based on your inputs, before any appreciation or growth.
| Year | Gross income | Vacancy | Operating exp. | NOI | Debt service | Capital exp. | Cash flow | Property value | Loan balance | Equity | Cum. cash flow |
|---|
Cap rate is calculated on purchase price. Debt service assumes a fixed-rate loan amortized over the entered schedule — if the loan term is shorter than the amortization period, the remaining balance is treated as a balloon payment due no later than the exit. Scheduled capital expenditures reduce cash flow in the year they occur (and are excluded from NOI). Cash-on-cash and ROI figures are pre-tax and do not account for depreciation, income tax, or 1031 exchange treatment — consult a tax professional for after-tax figures.
Package this analysis into a polished, printable report — add your logo and property photos, then generate a clean document you can save as a PDF or share directly.
Both fields are required and are stamped on every report this copy generates — a simple way to trace a copy back to its named license holder. This name also appears at the top of every report as "Prepared by," unless the "Prepared by" field above is filled in separately.
"Draft with data" / "Draft all sections" fill in a first-pass narrative from the numbers you've entered above — entirely on this device, no data sent anywhere. Nothing is locked in: the text lands in the box below fully editable, so use it as a starting point, tweak it, or delete it and write your own.
Opens in a new tab, formatted for printing or saving as a PDF (use your browser's Print → Save as PDF). Your logo, photos, and documents stay in your browser — nothing is uploaded anywhere. Documents are embedded directly in the report as download links, so keep file sizes reasonable.
A separate, underwriting-focused document for a lender's loan-quality review — loan-to-value and debt service coverage for every year of the hold, balloon/refinance risk, and a stress-tested downside scenario. Kept apart from the client-facing report above so investor narrative and underwriting numbers don't get mixed.
Stress test — reruns the analysis under a downside scenario (set any shock to 0 to skip it):
Leave a pair blank to apply that shock across the entire hold (the default). The income and expense windows are independent, so you can model a downturn hitting income in different years than an expense spike — e.g. income shocked Years 2–4 while expenses are shocked Years 5–7. Set both years in a pair the same — e.g. 3 through 3 — to model a single bad year that recovers afterward. The rate shock always applies to the loan for its full term regardless of either window — a fixed-rate loan that temporarily spikes and reverts isn't something this calculator models.
The DSCR above is property-only — this ranch's own income covering its own debt service, the standard test for a straight income property. Many ag and recreational-property lenders instead (or also) underwrite on a global cash flow basis: the borrower's off-farm/other household income and other existing debt obligations, alongside the property. Fill these in to add a global DSCR alongside the property-only figure; leave them at $0 to omit it and report property-only DSCR as before.
Opens in a new tab, formatted for printing or saving as a PDF. Uses the same property data and branding as the client report above, but replaces the investment narrative with year-by-year LTV/DSCR, balloon/refinance-risk detail, and the stress-tested downside scenario. Runs entirely in your browser — nothing is uploaded anywhere.
A side-by-side Best Case / Base Case / Worst Case view for investors who want to see a range, not a single point estimate. All three cases run through the exact same calculation as the report above — only the assumptions below change between them.
Base Case is simply your analysis exactly as entered above — no separate inputs needed. Best Case and Worst Case each apply a set of adjustments on top of those same entered assumptions:
Leave a from/through pair blank to apply that shock across the entire hold (the default). Best Case and Worst Case each have independent income and expense windows, so you can model a Worst Case where income only drops in Years 2–4, or an Expense shock that only hits Years 5–7 — the two windows within a case don't have to match either. Set both years in a pair the same (e.g. 3 through 3) for a single bad or good year that the hold recovers from afterward. The rate shock always applies to the loan for its full term regardless of any window — this calculator doesn't model a fixed rate that temporarily spikes and reverts. Land and improvement appreciation deltas are independent of each other — this matters when the two are entered at very different rates in section 2 (e.g. land at 4.5%, improvements at 0%): a shared delta could push a low or zero improvement rate into depreciation even when that's not the intent, so set improvement's delta to 0 if you want it to hold steady while land moves.
Opens in a new tab, formatted for printing or saving as a PDF. Shows Best Case, Base Case, and Worst Case side by side — key metrics, the assumptions behind each case, and an equity comparison chart. Runs entirely in your browser — nothing is uploaded anywhere.