Question
Create a spreadsheet that will calculate a simple tax provision for a company. ABC Inc. is in its first year of operations and has only
Create a spreadsheet that will calculate a simple tax provision for a company. ABC Inc. is in its first year of operations and has only the following differences between pretax accounting income and taxable income: 1. Fixed assets, $300,000 historical cost, are depreciated straight-line over three years for the financial statements and are depreciated straight-line over two years for tax purposes. ABC has a pretax accounting income of $250,000. 2. Warranty expense of $140,000 is accrued for financial statement purposes, but the tax deduction isn't allowed until the warranty liabilities are paid/completed, which is expected to happen evenly over the following two years. 3. Municipal bond interest of $70,000 is received in the current year. The municipal bond interest of $60,000 is expected in the following year. Subscription revenue of $120,000 is deferred on the financial statements as unearned subscription revenue. For tax purposes, the subscription revenue is gross income in the year received. The subscription revenue will be earned in the next year for financial statement purposes. 5. Installment sale gains of $65,000 are reported in the current year, with another $65,000 reported next year. For financial statements, all gain is reported in the current year. ABC has pretax accounting income of $300,000 in the first year. ABC has pretax accounting income of $450,000 in the second year. The statutory tax rate for all years is 30%. Please include any deferred tax assets and liabilities, the income tax payable, the income tax expense and the effective tax rate.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started