CATCO Tools

Tax-Lot PnL Planner

Compare FIFO, LIFO and HIFO lot selection before a partial stock or crypto sale.

Browser calculation
AVAILABLE TAX LOTS

LOTS ARE IN PURCHASE ORDER, OLDEST FIRST. ESTIMATES EXCLUDE TAX RULES, FEES AND WASH SALES.

UNITSCOST / UNIT
FIFO SALE ESTIMATE
EST. REALIZED GAIN / LOSS$420.002 LOTS SELECTED
PROCEEDS$1,440.00
COST BASIS$1,020.00
UNITS REMAINING11
LOT 1: 10 @ $80.00LOT 2: 2 @ $110.00

Tax-Lot PnL Planner calculation coverage

  1. 01

    FIFO, LIFO and HIFO

  2. 02

    Partial-lot selection

  3. 03

    Realized basis estimate

Not tax advice. Lot rules, wash sales and reporting requirements vary by jurisdiction and broker.

Overview

About this tool

A tax-lot planner assigns units sold to specific purchase lots and estimates realized cost basis and gain. FIFO uses the oldest lots, LIFO the newest and HIFO the highest purchase prices first.

Method

How it works

Selected lots supply cost basis until the sale quantity is filled. Estimated realized PnL equals sale proceeds minus the summed basis of selected units.

Inputs and outputs used by the Tax-Lot PnL Planner
ParameterHow it is used
Purchase lotsStores units and unit cost in your entered order, oldest acquisition first.
Sale quantityDetermines how many units require lot assignment.
Sale priceCalculates estimated proceeds.
Selection methodOrders lots by FIFO, LIFO or HIFO.
Worked example

The same sale, different selected basis

Oldest lot: 10 units at $40. Newer lot: 10 at $60. Sell 10 units at $70, excluding costs.

Proceeds = $700. FIFO basis = $400 and gain = $300. HIFO basis = $600 and gain = $100.

HIFO produces a $100 modeled gain for this sale, compared with $300 under FIFO.

The remaining lots retain different bases. A lower modeled gain is not proof that a method is legally available or best overall.

How to use this tool

  1. Enter each available lot with quantity and unit cost, ordered from oldest acquisition to newest.
  2. Add the proposed sale quantity and price.
  3. Compare FIFO, LIFO and HIFO estimates, then confirm allowed identification rules with a tax professional or broker.
Common questions

Frequently asked questions

What is HIFO?

Highest-in, first-out selects the highest-cost available units first, which may reduce the estimated realized gain in some situations.

Can I always choose any lot method?

No. Jurisdiction, asset type and broker procedures determine available methods and identification requirements.

Is the result tax advice?

No. It is an educational estimate. Confirm records and treatment with a qualified professional and the executing broker.

Further reading