Land Investment Calculator Spreadsheet

About this template

This land investment calculator is for people weighing up raw land deals who want their numbers in one place. Log the land that sold near you, type a parcel's asking price and your offer, and the file sets it against similar sales and runs the deal on your own estimates.

Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).

The dashboard

Pick a way out, sold whole or split into lots, and the cards and costs follow.

• What the deal would make on your estimates, and the cash it needs
• Sale price, every cost and the profit for the way picked
• The comparable sales used, highest price an acre first, and how many feed the deal
• Every parcel you are watching against its area's average
• Selling whole against splitting into lots, side by side
• The average price an acre in each area, with the deal's area lit
• Profit sold whole if the price an acre comes in higher or lower

Comparable sales

Every land sale you log gets its price per acre worked out, and the ones that fit your deal are marked: same area, similar size and recent.

Your offer, in context

The asking price and your offer an acre are set against the comparables' average, lowest and highest, and your offer is shown as a share of the value.

Two ways out

Closing, holding and selling costs are added. Then the parcel is run sold whole, or split into lots with survey, road, permits and utilities, for anyone thinking of land flipping or wanting to subdivide land. Each way shows cash in, profit, return a year and the break-even price an acre, all from the figures you enter.

What if

Profit is shown as the price an acre and the months held move, and as your offer moves against the sale price. The Deals tab keeps every parcel you are watching. These are estimates you type, not a valuation or investment advice.

Seven connected tabs

Start Here, Setup, Deal, Comparables, What If, Deals and Dashboard.

Works with

• Microsoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice
• Google Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.
• No dynamic arrays, no macros, no add-ins and no subscription

What you download

• The Excel workbook, filled with a worked example: a 20-acre deal against 33 land sales in three areas
• The same workbook, blank and ready for yours
• The instruction guide, which has one-click links to the Google Sheets versions (filled and blank)
• The terms of use as a PDF

Your files are ready to download as soon as payment clears. They are for personal and business use on your own devices, so please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.

Frequently asked questions

Can I use it in Google Sheets?

Yes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.

Where do the comparable sales come from?

You log the land sales near you. The file works out the price an acre and marks the ones in the same area, of a similar size and recent.

Can it compare selling whole with splitting into lots?

Yes. It runs both ways out side by side, with survey, road, permits and utilities for the lots, and shows profit and break-even price an acre for each.

Does it tell me whether to buy?

No. It calculates from the prices, costs and estimates you type, and it is not a valuation or investment advice.

Is there a worked example?

Yes. The filled copy is a 20-acre deal against 33 land sales in three areas, and a blank copy is included.