i need formulas for these. cannot seem to figure it out!

for this assignment I need to find a formulas for each tan column. The first column is labeled disallowed loss total. So I need to find the formula to find this answer. and so on with the orher columns

Insert Draw View Page Layout Formulas Data Review AA EE EI W OWAVE w Tee Mergentes WEX BT % C onditional Format x fx K149L14) YER GROUP MEMBERI NAME HERE KTER GROUP MEMBER NAME HERE IF APPLICABLE) NTER GROUP MEMBERS NAME HERE OF APPLICABLE) Facts: On June 1, 2019 you decided to sell shares of stock in a variety of companies. These shares were purchased at various dates Calculate your gain or los per share as a result of the June 1st sale. On June 14, 201 decided that you really think these shares are going to incre abstantially in vale. Therefore, is an attempt to buy back shares while their prices are still low, you repurchased some of these shares in various quan to the wash sale rules, you know that some or all of the losses from the June 1, 2019 wales may be disallowed. Therefore, calculate the disallowed losses (if any)und your basis in the newly equired shares. Finally, be bought these shares over various dates, you have two seperate categories of share those remaining from the original purchase and those from the June 14th purchase. Calculate the total number of shares owned and Wash Sale Exercise DE Facts: On June 1, 2019 you decided to sell shares of stock in a variety of companies. These shares were purchased at decided that you really think these shares are going to increase substantially in value. Therefore, in an attempt to bu to the wash sale rules, you know that some or all of the losses from the June 1, 2019 sales may be disallowed. Theref bought these shares over various dates, you have two seperate categories of shares: those remaining from the origina in total She Purchased 100 200 3 00 150 Stock FHS JUS NIK WES OOS POP ODB DCB WDB LCP Purchase Date 12/25/18 7/20/18 10/15/18 4/20/10 7/31/12 5/14/19 2/5/15 4/21/17 5/14/19 5/5/19 6/1/2019 Sale Basis Shares Price Gainos Gatoss) per Share Sold par Share per share in total S 15.55 725 9.795 (5.76) S (414.72) 18.22 1395 10.93 7.29) S (1.013.31) $ 21.21 252 $ 18.45 S (2.7631 S (695 52) $ 36.77 1405 23.535 (13.24) S (1,853.60) 1 $ 12.21200 $ 15.1452.935586.00 S 23.082315 33.46 10.38 $ 2.397.78 S 5,69 244 $ 6.65 $ 0.96 $ 234.24 S 7.24 322 $ 9.19 $ 1.95 6 27.90 S 8.99 350S 7.371 S L 62) S (567.00) IS 22.03 125_15 18.725 031) 5 (413.75) 6/14/2019 Purchase Shares Price Divullendless in total Purchased per Share from 6/1/2019 sale 2911 9.201 2 267701 167 $ 11.69 330 SIROS 266 S 25.88 60 220 $ 35.47 | 92 5.99 350 174 100 SIROL $ 14.21 S 200 250 300 350 400 200 re purchased at various dates. Calculate your gain or loss per share as a result of the June 1st sale. On June 14, 2019 you in attempt to buy back shares while their prices are still low, you repurchased some of these shares in various quantities. Due allowed. Therefore, calculate the dissallowed losses (if any) and your basis in the newly aquired shares. Finally, because you rom the original purchase and those from the June 14th purchase. Calculate the total number of shares owned and their basis Original Shares Remaining Wash Shares P a Share Raisin Wash EESTI New Per Share Betis in Shares New med loss in total Per Share Basis in 1 Original Shares FIX PIX FIX FIX FIX T FIX FIX TH FIX FIX FIX FIX FIX FIX FIX IST Ela Insert Draw View Page Layout Formulas Data Review AA EE EI W OWAVE w Tee Mergentes WEX BT % C onditional Format x fx K149L14) YER GROUP MEMBERI NAME HERE KTER GROUP MEMBER NAME HERE IF APPLICABLE) NTER GROUP MEMBERS NAME HERE OF APPLICABLE) Facts: On June 1, 2019 you decided to sell shares of stock in a variety of companies. These shares were purchased at various dates Calculate your gain or los per share as a result of the June 1st sale. On June 14, 201 decided that you really think these shares are going to incre abstantially in vale. Therefore, is an attempt to buy back shares while their prices are still low, you repurchased some of these shares in various quan to the wash sale rules, you know that some or all of the losses from the June 1, 2019 wales may be disallowed. Therefore, calculate the disallowed losses (if any)und your basis in the newly equired shares. Finally, be bought these shares over various dates, you have two seperate categories of share those remaining from the original purchase and those from the June 14th purchase. Calculate the total number of shares owned and Wash Sale Exercise DE Facts: On June 1, 2019 you decided to sell shares of stock in a variety of companies. These shares were purchased at decided that you really think these shares are going to increase substantially in value. Therefore, in an attempt to bu to the wash sale rules, you know that some or all of the losses from the June 1, 2019 sales may be disallowed. Theref bought these shares over various dates, you have two seperate categories of shares: those remaining from the origina in total She Purchased 100 200 3 00 150 Stock FHS JUS NIK WES OOS POP ODB DCB WDB LCP Purchase Date 12/25/18 7/20/18 10/15/18 4/20/10 7/31/12 5/14/19 2/5/15 4/21/17 5/14/19 5/5/19 6/1/2019 Sale Basis Shares Price Gainos Gatoss) per Share Sold par Share per share in total S 15.55 725 9.795 (5.76) S (414.72) 18.22 1395 10.93 7.29) S (1.013.31) $ 21.21 252 $ 18.45 S (2.7631 S (695 52) $ 36.77 1405 23.535 (13.24) S (1,853.60) 1 $ 12.21200 $ 15.1452.935586.00 S 23.082315 33.46 10.38 $ 2.397.78 S 5,69 244 $ 6.65 $ 0.96 $ 234.24 S 7.24 322 $ 9.19 $ 1.95 6 27.90 S 8.99 350S 7.371 S L 62) S (567.00) IS 22.03 125_15 18.725 031) 5 (413.75) 6/14/2019 Purchase Shares Price Divullendless in total Purchased per Share from 6/1/2019 sale 2911 9.201 2 267701 167 $ 11.69 330 SIROS 266 S 25.88 60 220 $ 35.47 | 92 5.99 350 174 100 SIROL $ 14.21 S 200 250 300 350 400 200 re purchased at various dates. Calculate your gain or loss per share as a result of the June 1st sale. On June 14, 2019 you in attempt to buy back shares while their prices are still low, you repurchased some of these shares in various quantities. Due allowed. Therefore, calculate the dissallowed losses (if any) and your basis in the newly aquired shares. Finally, because you rom the original purchase and those from the June 14th purchase. Calculate the total number of shares owned and their basis Original Shares Remaining Wash Shares P a Share Raisin Wash EESTI New Per Share Betis in Shares New med loss in total Per Share Basis in 1 Original Shares FIX PIX FIX FIX FIX T FIX FIX TH FIX FIX FIX FIX FIX FIX FIX IST Ela