i need answer in excell

WAR (We Are Rich) has been in business since 1988. WAR is an accrual-method sole proprietorship that deals in the manufacturing and wholesaling of various types of golf equipment. Hack & Hack CPAS has filed accurate tax returns for WAR's owner since WAR opened its doors. The managing partner of Hack & Hack (Jack) has gotten along very well with the owner of WAR-Mr. Someday Woods (single). However, in early 2021, Jack Hack and Someday Woods played a round of golf, and Jack, for the first time ever, beat Mr. Woods. Mr. Woods was so upset that he fired Hack & Hack and has hired you to compute his 2021 taxable income. Mr. Woods was able to provide you with the following information from prior tax returns. The taxable income numbers reflect the results from all of Mr. Woods's activities except for the items separately stated. You will need to consider how to handle the separately stated items for tax purposes. Also, note that the 2016- 2020 numbers do not reflect capital loss carryovers. 2014 2018 2019 2020 Ordinary taxable income $ 4,320 $97,760 $176,000 $260,000 other items not included in ordinary taxable income Net gain (loss) on disposition of $1231 assets 2017 $ 2,160 10,800 $3,400 $ (6,960) Net long-term capital gain (loss) on disposition of capital asseta $ (16,200) $1,160 (17.760) $(8,600) In 2021, Mr. Woods had taxable income in the amount of $512,000 before considering the following events and transactions that transpired in 2021: a. On January 1, 2021, WAR purchased a plot of land for $108,000 with the intention of creating a driving range where patrons could test their new golf equipment. WAR never got around to building driving range: Instead, WAR sold the land on October 1, 2021, for $43,200. b. On August 17, 2021, WAR sold its golf testing machine, "Iron Byron," and replaced it with a new machine, "Iron Tiger" "Iron Byron" was purchased and installed for a total cost of $25,200 on February 5, 2017. At the time of sale, "Iron Byron had an adjusted tax basis of $7,200. WAR sold "Iron Byron" for $33,000. c. In the months October through December 2021, WAR sold various assets to come up with the funds necessary to invest in WAR's latest and greatest invention-the three-dimple golf ball. Data on these assets are provided below. Placed in (53 Prev 2 3 of 3 Next > 1 Placed in Service (or Asset purchased) Initial Basis Sold Accumulated Selling Depreciation Price Someday's black leather sofa 4/4/20 10/16/21 11/8/21 $ 3,640 (used in office) Someday's office chair Marketable securities $ 3,380 3/1/19 2/1/18 $ 700 3,320 4,800 12/1/21 9,280 13,920 0 7/1/20 11/29/21 Land held for investment Other investment property 53,000 0 21,600 55,200 14,400 11/30/19 10/15/21 18,000 0 d. Finally, on May 7, 2021, WAR decided to sell the building where it tested its plutonium shaft, lignite head drivers. WAR purchased the building on January 5, 2009, for $230,000 ($202,000 for the building, $28,000 for the land). At the time of the sale, the accumulated depreciation on the building was $58,000. WAR sold the building (with the land) for $348,000. The fair market value of the land at the time of sale was $53,000. (Do not round intermediate computations. Round your final answers to the nearest whole dollar amount. Loss amounts should be indicated by a minus sign.) Comprehensive Problem 11-73 Part 1 (Algo) Compute Mr. Woods's taxable income after taking into account the transactions described above. Description Depreciation Recapture LT 25% Gain/(Loss) Ordinary income (Loss) LT 28% $1231 Short Term 8 111 Next Long Term Total LT 0/15/20% " Compute Mr. Woods's taxable income after taking into account the transactions described above. Description. Gain/(Loss) Depreciation Recapture $1231 a. Land 0 (64,800) 25,800 18,000 b. Iron Byron 1. Sofa 440 440 2. Chair (1.480) o c3. Marketable securities 9.280 04. Land for investment 3,480 c5. Investment property (2,160) dt. Building 6,000 d2. Land 25,000 560 $1231 netting Step1-depreciation recapture -ordinary income Step 2-51231 G/L netting -gains/losses exclusive of 51250 -Unrecap 51250 Step 3-lookback rule -apply to unrecap $1250 first Ordinary income 141,720 58,000 Prev Ordinary Short Long Term income/(Loss) Term Total 0 (64,800) 0 $ 0 0 0 of of 0 0 7,800 0 (1480) 0 0 0 0 0 0 0 5,000 0 25,000 18.440 36.320 18.440 CO 0 D 0 (64,800) 18,440 6,960 of 3 # 0 o 0 0 0 0 01 0 Next > LT 28% 0 D$ 0 0 0 www. 0 of 14,400 0 3,480 (2,160) 0 0 15.720 0 0 0 0 0 LT 25% o 0 0 0 0 0 0 0 0 0 LT 0/15/20% 0 0 0 0 14,400 3,480 (2,160) a 0 15,720 Required information Ordinary income Remaining unrecap $1250 Remaining gain-0/15/20 Capital gain netting Long term capital loss carryover Reclassified Taxable income: Before transactions Ordinary incomerloss LTCG @ 25% LTCG@0/15/20% Taxable income $512,000 $ 612.000 58,000 141,720 36,880 236,040 6,960 (39,400) 0 51,040 141,720 208,480 (5,800) 51,040 0 $1,040 D 61,040 (5.800) (5,800) (11.000) 141,720 157,440 157,440 WAR (We Are Rich) has been in business since 1988. WAR is an accrual-method sole proprietorship that deals in the manufacturing and wholesaling of various types of golf equipment. Hack & Hack CPAS has filed accurate tax returns for WAR's owner since WAR opened its doors. The managing partner of Hack & Hack (Jack) has gotten along very well with the owner of WAR-Mr. Someday Woods (single). However, in early 2021, Jack Hack and Someday Woods played a round of golf, and Jack, for the first time ever, beat Mr. Woods. Mr. Woods was so upset that he fired Hack & Hack and has hired you to compute his 2021 taxable income. Mr. Woods was able to provide you with the following information from prior tax returns. The taxable income numbers reflect the results from all of Mr. Woods's activities except for the items separately stated. You will need to consider how to handle the separately stated items for tax purposes. Also, note that the 2016- 2020 numbers do not reflect capital loss carryovers. 2014 2018 2019 2020 Ordinary taxable income $ 4,320 $97,760 $176,000 $260,000 other items not included in ordinary taxable income Net gain (loss) on disposition of $1231 assets 2017 $ 2,160 10,800 $3,400 $ (6,960) Net long-term capital gain (loss) on disposition of capital asseta $ (16,200) $1,160 (17.760) $(8,600) In 2021, Mr. Woods had taxable income in the amount of $512,000 before considering the following events and transactions that transpired in 2021: a. On January 1, 2021, WAR purchased a plot of land for $108,000 with the intention of creating a driving range where patrons could test their new golf equipment. WAR never got around to building driving range: Instead, WAR sold the land on October 1, 2021, for $43,200. b. On August 17, 2021, WAR sold its golf testing machine, "Iron Byron," and replaced it with a new machine, "Iron Tiger" "Iron Byron" was purchased and installed for a total cost of $25,200 on February 5, 2017. At the time of sale, "Iron Byron had an adjusted tax basis of $7,200. WAR sold "Iron Byron" for $33,000. c. In the months October through December 2021, WAR sold various assets to come up with the funds necessary to invest in WAR's latest and greatest invention-the three-dimple golf ball. Data on these assets are provided below. Placed in (53 Prev 2 3 of 3 Next > 1 Placed in Service (or Asset purchased) Initial Basis Sold Accumulated Selling Depreciation Price Someday's black leather sofa 4/4/20 10/16/21 11/8/21 $ 3,640 (used in office) Someday's office chair Marketable securities $ 3,380 3/1/19 2/1/18 $ 700 3,320 4,800 12/1/21 9,280 13,920 0 7/1/20 11/29/21 Land held for investment Other investment property 53,000 0 21,600 55,200 14,400 11/30/19 10/15/21 18,000 0 d. Finally, on May 7, 2021, WAR decided to sell the building where it tested its plutonium shaft, lignite head drivers. WAR purchased the building on January 5, 2009, for $230,000 ($202,000 for the building, $28,000 for the land). At the time of the sale, the accumulated depreciation on the building was $58,000. WAR sold the building (with the land) for $348,000. The fair market value of the land at the time of sale was $53,000. (Do not round intermediate computations. Round your final answers to the nearest whole dollar amount. Loss amounts should be indicated by a minus sign.) Comprehensive Problem 11-73 Part 1 (Algo) Compute Mr. Woods's taxable income after taking into account the transactions described above. Description Depreciation Recapture LT 25% Gain/(Loss) Ordinary income (Loss) LT 28% $1231 Short Term 8 111 Next Long Term Total LT 0/15/20% " Compute Mr. Woods's taxable income after taking into account the transactions described above. Description. Gain/(Loss) Depreciation Recapture $1231 a. Land 0 (64,800) 25,800 18,000 b. Iron Byron 1. Sofa 440 440 2. Chair (1.480) o c3. Marketable securities 9.280 04. Land for investment 3,480 c5. Investment property (2,160) dt. Building 6,000 d2. Land 25,000 560 $1231 netting Step1-depreciation recapture -ordinary income Step 2-51231 G/L netting -gains/losses exclusive of 51250 -Unrecap 51250 Step 3-lookback rule -apply to unrecap $1250 first Ordinary income 141,720 58,000 Prev Ordinary Short Long Term income/(Loss) Term Total 0 (64,800) 0 $ 0 0 0 of of 0 0 7,800 0 (1480) 0 0 0 0 0 0 0 5,000 0 25,000 18.440 36.320 18.440 CO 0 D 0 (64,800) 18,440 6,960 of 3 # 0 o 0 0 0 0 01 0 Next > LT 28% 0 D$ 0 0 0 www. 0 of 14,400 0 3,480 (2,160) 0 0 15.720 0 0 0 0 0 LT 25% o 0 0 0 0 0 0 0 0 0 LT 0/15/20% 0 0 0 0 14,400 3,480 (2,160) a 0 15,720 Required information Ordinary income Remaining unrecap $1250 Remaining gain-0/15/20 Capital gain netting Long term capital loss carryover Reclassified Taxable income: Before transactions Ordinary incomerloss LTCG @ 25% LTCG@0/15/20% Taxable income $512,000 $ 612.000 58,000 141,720 36,880 236,040 6,960 (39,400) 0 51,040 141,720 208,480 (5,800) 51,040 0 $1,040 D 61,040 (5.800) (5,800) (11.000) 141,720 157,440 157,440