please need it in excel format

Pet Instructional Programs Corp. (PIP) and its 90% owned subsidiary, Squeak Toys Ltd (Squeak), join in filing consolidated returns for U.S. tax purposes. On January 6, 2020, Squeak purchased new fixtures for $4,200, which Squeak immediately placed into service in its business without claiming bonus depreciation. On January 1, 2021, when the fixtures had an adjusted basis of $3,600, Squeak sold the fixtures to PIP for $5,800. Although PIP immediately placed the fixtures into service in 2021, PIP ended up selling the fixtures to an unrelated purchaser on July 14, 2022. Under the terms of the sale, the unrelated purchaser agreed to pay PIP 10% of whatever profit the purchaser reported in the month of October for ten consecutive years, starting with October 2022. Accordingly, the unrelated purchaser made its first payment to PIP of $700 on November 15,2022. Required (25 points): Explain what depreciation, gain, and/or loss PIP and Squeak would include in their respective separate taxable incomes (i.e., taxable income after any adjustments for intercompany transactions) for 2021 and 2022 with respect to the fixtures. Common Facts for Each Situation: Epic Feat Inc. (Epic), a U.S. corporation, took its first step toward global domination during 2023 by establishing a global enterprise that acquires goods from a manufacturer in Guatemala and resells those goods to retail customers in Thailand (the 'Business'). Legal title to the goods passes to the customers in Thailand, and the Business will generate $280,000 of income (gross income less deductible expenses, as determined under U.S. tax laws) as it gets a toehold in the Thai market during 2023. Epic will also have $410,000 of U.S. source income (gross income less deductible expenses, as determined under U.S. tax laws) from its business operations wholly within the United States. The total value of Epic's tangible assets is $5,520,000 (i.e., the original cost of the assets less ADS straight-line depreciation). Assume the U.S. government taxes Epic at a 21% flat rate. Required (25 points for each INDPENDENT situation): (A) Assume Epic conducts the Business without having any of its assets or employees outside the United States (i.e., all $5,520,000 of the tangible assets are located within the United States), and the Thai government will impose $28,000 of withholding taxes on Epic's sales to Thai customers during 2023. Explain what amount of income tax Epic will owe the U.S government for 2023 . (B) Assume Epic moved $828,000 of its tangible assets to Thailand and conducts the Business as a branch. Assume further that--under Thai tax law--the Thai government will treat Page 3 Epic's branch as having taxable income of $476,000 for 2023, and the Thai government imposes a 4% tax rate on taxable income up to $50,000 and a 11% tax rate on taxable income in excess of $50,000. Explain what amount of income tax Epic will owe the U.S government for 2023. (C) Assume Epic transferred $828,000 of its tangible assets to a newly-formed Thai corporation (a 'foreign subsidiary') in exchange for all of the foreign subsidiary's stock, and the foreign subsidiary conducts the Business. Assume further that--under Thai tax law--the Thai government will treat the foreign subsidiary as having taxable income of $476,000 for 2023 , and the Thai government imposes a 4% tax rate on taxable income up to $50,000 and a 11% tax rate on taxable income in excess of $50,000. Finally, assume the foreign subsidiary will not make any distributions to Epic during 2023. Explain what amount of income tax Epic will owe the U.S government for 2023