Question
The DeVille Company reported pretax accounting income on its income statement as follows: 2021 $ 350,000 2022 270,000 2023 340,000 2024 380,000 Included in the
The DeVille Company reported pretax accounting income on its income statement as follows: 2021 $ 350,000 2022 270,000 2023 340,000 2024 380,000 Included in the income of 2021 was an installment sale of property in the amount of $50,000. However, for tax purposes, DeVille reported the income in the year cash was collected. Cash collected on the installment sale was $20,000 in 2022, $25,000 in 2023, and $5,000 in 2024. Included in the 2023 income was $15,000 interest from investments in municipal governmental bonds. The enacted tax rate for 2021 and 2022 was 40%, but during 2022, new tax legislation was passed reducing the tax rate to 25% for the years 2023 and beyond. Required: Use this data to complete the tables on the following tab entitled "Problem 2".
You should use Excel tools and functions to complete the data required to complete the Problem 2 tab. You will be calculating Deville Company's taxable income, and taxes payable in the first section. (Rows 9 - 14)
In the second section, you will calculate both each year's temporary difference in depreciation and the cumulative difference for each of 4 years. (Rows 17 - 24)
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