What this shows: If you buy the land at a given price per lot (rows) and hold it for a certain number of years (columns), what is your annual return on the equity you put in? The model assumes you put up equity on day one, pay interest, land tax, and holding costs each year, earn any income from the land, then sell at the projected future land value. Green = you're making money. Red = you're losing money. Find your target purchase price on the left and read across to see how returns change with time.

What this shows: The actual dollar profit or loss per lot, adjusted for the time value of money. Starting from today's land value (RLV), we subtract the present value of all holding costs (interest, tax, etc.) over the hold period, add back any earnings, then subtract the purchase price. Positive (green) = net profit per lot. Negative (red) = net loss per lot. This tells you in today's dollars how much you actually make or lose at each price point and hold period.

What this shows: A stress test of the land value. Each cell shows what the land is worth per lot if the home sale price (rows) or the total build cost (columns) is different from the base case. Moving right increases costs, reducing land value. Moving down increases revenue, boosting land value. The highlighted cell is your current scenario. This helps you see how sensitive the land value is to changes in market conditions — if prices drop 10%, or costs rise $20K, is the deal still viable?