pratiksathe.lhs
New Member
Hello, I have tried to create excel for calculating profit of particular stock using fifo method. But the results are not coming as expected. Need your help to suggest excel file or formula.
FIFO cost =SUMPRODUCT((-SUMIF(B$2:B7,"<0")>SUMIF(OFFSET(B$1,,,ROW(B$1:B6)),">0"))*(-SUMIF(B$2:B7,"<0")-SUMIF(OFFSET(B$1,,,ROW(B$1:B6)),">0"))*(C$2:C7-N(+C$1:C6)))-SUM(E$1:E6)
FIFO Gain =IF(B7>0,0,-B7*C7-E7)
Alpha return= Capital Gain rate- Bank rate
FIFO cost =SUMPRODUCT((-SUMIF(B$2:B7,"<0")>SUMIF(OFFSET(B$1,,,ROW(B$1:B6)),">0"))*(-SUMIF(B$2:B7,"<0")-SUMIF(OFFSET(B$1,,,ROW(B$1:B6)),">0"))*(C$2:C7-N(+C$1:C6)))-SUM(E$1:E6)
FIFO Gain =IF(B7>0,0,-B7*C7-E7)
Alpha return= Capital Gain rate- Bank rate