Formula: Add, Subtract; Cell Referencing Using Excel to Determine Income Tax Effects PROBLEM At December 31, 2022 and 2023, Secor Inc. reported amounts for a deferred tax asset. Information concerning the company's income taxes is provided here. Deferred tax asset, December 31, 2022 Deferred tax asset, December 31, 2023 Current tax expense 2023 $ 40,000 62,000 70,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or to this work area. What amount should Secor report as total 2020 income tax expense? $ 22,000 Prepare the journal entries to record income taxes for 2020. 2023 income tax expense Current Tax Expense Income Tax Payable Deferred Tax Expense Current Tax Expense Debit 70,000 22,000 Credit 70,000 22,000

Formula: Add, Subtract; Cell Referencing Using Excel to Determine Income Tax Effects PROBLEM At December 31, 2022 and 2023, Secor Inc. reported amounts for a deferred tax asset. Information concerning the company's income taxes is provided here. Deferred tax asset, December 31, 2022 Deferred tax asset, December 31, 2023 Current tax expense 2023 $ 40,000 62,000 70,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or to this work area. What amount should Secor report as total 2020 income tax expense? $ 22,000 Prepare the journal entries to record income taxes for 2020. 2023 income tax expense Current Tax Expense Income Tax Payable Deferred Tax Expense Current Tax Expense Debit 70,000 22,000 Credit 70,000 22,000

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter18: Accounting For Income Taxes

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

Discussion Question: The average tax rate is calculated by dividing the total tax payable by the taxable income and it represents the percentage of the income that goes to pay taxes. Consider the following data for two corporations. ABC and XYZ Inc.: Particulars ABC Inc. (Rs.) XYZ Inc. (Rs.) Gross Profit 2,600,000 2.600,000 Administrative Expenses 800,000 800,000 Depreciation Other Income Taxable Income 200,000 500,000 900,000 900,000 2,500,000 2,200,000 Requirements: i. Calculate the average tax rate for both companies. ii. Briefly describe how the above calculations support the notion that depreciation acts as a tax shield. Your answers must be presented in the following format:
Compute NOPAT Selected income statement information for 2018 is presented below for Home Depot Inc. and Lowe’s Companies Inc. Assume the statutory tax rate is 22%. Pretax Net Average Net Nonoperating Tax Operating Company ($ millions) Ticker Sales NOPBT Expense Expense Assets Home Depot HD $65,787 $9,442 $592 $2,088 $15,332 Lowe’s LOW 43,356 2,443 379 657 12,358
Compute NOPAT Selected income statement information for 2018 is presented below for Home Depot Inc. and Lowe’s Companies Inc. Assume the statutory tax rate is 22%. Pretax Net Average Net Nonoperating Tax Operating Company ($ millions) Ticker Sales NOPBT Expense Expense Assets Home Depot HD $65,787 $9,442 $592 $2,088 $15,332 Lowe’s LOW 43,356 2,443 379 657 12,358 a. Compute the following measures for both companies. 1. NOPAT Company NOPAT Home Depot Answer Lowe's Answer 2. RNOA Note: 1. Select the appropriate numerator and denominator used to compute RNOA from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute RNOA. Company Numerator Denominator RNOA Answer Answer Home Depot Answer Answer Lowe's Answer Answer 3. NOPM Note: 1. Select the appropriate numerator and denominator used to compute NOPM from the drop-down menu options. 2. Enter…
es Required: Determine the amount of average income tax liability per tax return, for each income range provided, using the information in the below table. Taxable Income and Total Tax Liability are in thousands. Note: Enter your answers in whole dollars and not in thousands. Round the final answers to the nearest dollar value. Item Number of returns Taxable income Total tax liability Average tax rate* Ranges of Adjusted Gross Income $15,000 to under $30,000 27,410,421 $ 189,345,926 $ 15,590,244 Under $15,000 30,714,603 $ 5,388,125 $ 532,117 9.88% *The average tax rate is total tax liability divided by taxable income. Under $15,000 $15,000 to under $30,000 $30,000 to under $50,000 $50,000 to under $100,000 $100,000 to under $200,000 $200,000 or more $30,000 to under $50,000 to under $50,000 $100,000 37,547,454 28,926,296 $ 1,912,925,663 $ 639,289,718 $215,589,667 $56,077,985 8.23% 8.77% 11.27% $100,000 to under $200,000 24,180,226 $ 2,687,818, 279 $385,658,662 14.35% $200,000 or more…
Compute NOPAT Selected income statement information for 2018 is presented below for Home Depot Inc. and Lowe’s Companies Inc. Assume the statutory tax rate is 22%. Pretax Net Average Net Nonoperating Tax Operating Company ($ millions) Ticker Sales NOPBT Expense Expense Assets Home Depot HD $65,787 $9,442 $592 $2,088 $15,332 Lowe’s LOW 43,356 2,443 379 657 12,358 a. Compute the following measures for both companies. 1. NOPAT Company NOPAT Home Depot Answer Lowe's Answer 2. RNOA Note: 1. Select the appropriate numerator and denominator used to compute RNOA from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute RNOA. Company Numerator Denominator RNOA Answer Answer Home Depot Answer Answer Lowe's Answer Answer 3. NOPM Note: 1. Select the appropriate numerator and denominator used to compute NOPM from the drop-down menu options. 2. Enter the numerator and…
A company makes the following journal entry for 2021: Dr. Income Tax Expense xxxx Dr. Deferred Tax Asset 62,000 Cr. Deferred Tax Liability 11,000 Cr. Income Tax Payable 536,000 On the income statement, the current portion of income tax expense for 2021 appears as: _______________.
x Company reports the following pretax income (loss) for both book and tax purposes. Year. Pretax income tax rate 2018 120,000 20% 2019 93,000 20% 2020. (82,000) 25% 2021 110,000 25% The tax rates listed were enacted by the beginning of 2018 Prepare the journal entries for years 2018-2021 to record income tax expense (benefit) and income taxes payable and the tax effects of the loss carryforward assuming that based on the weight of available evidence it is more likely than not that one half of the benefits of the loss carryforward will not be realized.
The amount of net deferred tax asset/(liability) on January 1, 20x8 is The amount of net deferred tax asset/(liability) on December 31, 20x8 is Income tax expense – current for 20x8 is
A company reported in the income statement for the current year P900,000 income before provision for income tax. Please consider the following information: Rent income received in advance P150,000Interest income on time deposit 200,000Depreciation deducted for income tax purposes in excess of financial depreciation P100,000Income tax rate 30% 1. How much is the taxable income?A. 950,000B. 750,000C. 850,000D. 700,0002. How much is the accounting income subject to tax?A. 900,000B. 750,000C. 700,000D. 225,000Thank you.
Required: Total deferred tax liability- December 31, 20x6 Total deferred tax asset at December 31, 20x6 Current income tax expense for the year ended December 31,20x6 Total income tax expense for 20x6
INVOICE issued date 05/05/2020 as below: You have received an invoice from one of our suppliers and you are required to prepare: (i) Double entry for the invoice you have received base on the account and supplier number provided. (ii) Base on tax point of view, specify each item whether it is Capital or Revenue expenditure.
b. Extracts from trial balance at 31 March, 2019 GH¢ Current tax credit balance 1,600,000 Deferred tax liability 5,200,000 The balance on current tax represents the under/over provision of the tax liability for the year ended 31 March, 2018. The required provision for income tax for the year ended 31 March, 2019 is GH 38.8 million. The difference between the carrying amounts of the net assets of the company and their (lower) tax base at 31 March, 2019 is GH¢54 million. The rate of income tax is 25%. Required: Prepare a Statement of Profit or Loss Extract and Statement of Financial Position Extract for 31 March, 2019.