Please explain steps and show how these items are calculated, preferably using Excel.

26. LO.5, 6 Zebra, Inc., a calendar year S corporation, incurred the following items this year. Sammy is a 40% Zebra shareholder throughout the year. $100,000 Operating income Cost of goods sold Depreciation expense (MACRS) Administrative expenses 5 1231 gain Depreciation recapture income Short-term capital loss from stock sale Long-term capital loss from stock sale Long-term capital gain from stock sale Charitable contributions (40,000) (10,000) (5,000) 21,000 25,000 (6,000) (4,000) 15,000 (4,500) a. Calculate Samm b. Calculate Sammy's share of any Zebra long-term capital gain, if any. c. Calculate Sammy's share of charitable contributions, if any y's share of Zebra's nonseparately computed income or loss