Excel Worksheet Template to calculate gain/loss on shares

Scope of work 1) calculate gain/loss on FIFO & LIFO method 2) Split them by FY i.e. 30 June 3) Holding Summary at each year end with shares quantity and cost base 4) Length of holding for each parcel of share sold by categorizing them in two sections less than one year and more than one year 5) Model should be reusable 6) It should recalculate based on method of inventory selection i.e. FIFO or LIFO