Question

DDB over 5 years (not tax) End of year basis year 1 40.00% 60.00% year 2 24.00% 36.00% year 3 14.40% 21.60% year 4 8.64% 12.9DDB over 5 years (not tax) Enter annual depreciation percentage 20.0% End of year basis 80.0% year 1 year 2 year 3 year 4 yea

0 0
Add a comment Improve this question Transcribed image text
Answer #1
DDB over %
years(not tax)
End of the year
basis
MACRS 5 year Enter annual
depreciation
percentage
End of the year
basis
Year 1 40.00% 60.00% Year 1 Half of DDB year 1 20.00% 80.00%
Year 2 24.00% 36.00% Year 2 DDB average year1,2 32.00% 48.00%
Year 3 14.40% 21.60% Year 3 DDB average year2,3 19.20% 28.80%
Year 4 8.64% 12.96% Year 4 DDB average year3,4 11.52% 17.28%
Year 5 12.96% 0.00% Year 5 DDB average year4,5 10.80% 6.48%
Total 100.00% Year 6 Half of DDB year 5 6.48% 0.00%

The excel formulas used to derive the depreciation percentages are shown below as screen shot of the above table

1 A C D E Year 1 Year 2 Year 3 Year 4 Year 5 Total DDB over % years(not tax) 0.4 0.24 0.144 0.0864 0.1296 =SUM(B3:37) End of

Add a comment
Know the answer?
Add Answer to:
DDB over 5 years (not tax) End of year basis year 1 40.00% 60.00% year 2...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • DDB over 5 years (not tax) End of year basis year 1 40.00% 60.00% year 2...

    DDB over 5 years (not tax) End of year basis year 1 40.00% 60.00% year 2 24.00% 36.00% year 3 14.40% 21.60% year 4 8.64% 12.96% year 5 12.96% 0.00% Total 100.00% Questions: (these are not tax questions. Instead, these are critical thinking questions that will enable you to later appreciate the logic of MACRS) 1. Do you see something conceptually wrong with this table? In other words, the logic of accelerated depreciation is that we derive greater benefits from...

  • Look at the numbers calculated in the yellow field. In plain english please, 1.explain how depreciation...

    Look at the numbers calculated in the yellow field. In plain english please, 1.explain how depreciation was calculated for years 1-3. 2.explain how depreciation was calculating for years 4-6. Hint: End-of-year basis for year 3 is 28.8% divided by 5 = 5.8% Explain why divide by 5? DE 3 year 1 4 year 2 5 year 3 6 year 4 7 year 5 8 Total DDB over 5 years (not tax) 40.00% 24.00% 14.40% 8.64% 12.96% 100.00% End of year...

  • 1. Do you see something conceptually wrong with this table?  In other words, the logic of accelerated...

    1. Do you see something conceptually wrong with this table?  In other words, the logic of accelerated depreciation is that we derive greater benefits from the asset in early years.  According to that logic, what is wrong with this schedule? 2. Can you propose a solution or modification to the DDB depreciation schedule that would solve the problem you identified in question 1, but would still largely follow the DDB approach? year 1 year 2 DDB over 5 years (not tax) 40.00%...

  • QUESTIONS 1. Complete the 1992 columns of Tables 3 through 6, disregarding for now the projected...

    QUESTIONS 1. Complete the 1992 columns of Tables 3 through 6, disregarding for now the projected data in the 1993 and 1994 columns. If you are using the spreadsheet model, use it to complete the tables. Be sure you understand all the numbers, as it would be most embarrassing and harmful to your career) if you were asked how you got a particular number and you could not give a meaningful response. 2. Based on the information in the case...

  • Comprehensive Income Tax Course: Module 1 4. Randy turned 16 last year and had his first...

    Comprehensive Income Tax Course: Module 1 4. Randy turned 16 last year and had his first summer job. Even though his parents are claiming him as a dependent he wants to file a return in order to get his refund. He receives his W-2 and decides he can do his own return using form 1040-EZ. Which of the following information is not found on a Form W-2? a) The taxpayer’s Social Security number b) The taxpayer’s wages, tips and other...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT