346Hwk05ans.xls - Intro The worksheets that follow provide pro forma workpapers to help you solve the assigned homework problems They organize your

346Hwk05ans.xls - Intro The worksheets that follow provide...

This preview shows page 1 out of 10 pages.

You've reached the end of your free preview.

Want to read all 10 pages?

Unformatted text preview: Intro The worksheets that follow provide pro forma workpapers to help you solve the assigned homework problems. They organize your solution in a manner that is consistent with the analytical methods that we discuss in class and allow you to focus on the technical issues, rather than workpaper techniques and computer skills. However, you should continuously analyze the organization of the solution and the answers that you receive, as you work the problems. That is the only way that you will learn the skills and techniques that you will need for your long-term success. Click on the appropriate tab below to move to the worksheet for the homework problem that you want to work on. Once you have completed the assignment, save the file to your computer, then submit it in the manner prescribed in the course syllabus. NOTE: Cells with red dots in them contain notes that provide additional information about the cell contents. Double click on those cells to read the notes. Also, you need enter information only in the cells that are highlighted in bright yellow. Capital Recovery Intro Capital Recovery Intro Capital Recovery Intro Capital Recovery Problem 7-40 Skirt Domestic Production Gross Receipts Less: Cost of Goods Sold Other Direct Costs Allocated Indirect Costs Qualified Production Activities Income per Unit 12 Blouse 10 Total 22 -5 -1 -6 -5 6 -1 -11 -6 0 5 Taxable Income Limitation QPAI TI Limitation % Limitation Amount W-2 Wages Limitation W-2 Wages Limitation % Limitation Amount DPAD $ 4,000,000 $ 3,000,000 9% $ $ 270,000 $ 200,000 $ 200,000 400,000 50% Cost Recovery Problem 8-46 Quarter 1 Purchases by Quarter Percentages by Quarter $ 2 40,000 $ 27% 3 40,000 $ 27% Cost Recovery Deductions §§168(k) & §168(a) 179 4 70,000 47% Total Furniture Total Cost Recovery per §179 Recovery per §168(k) Basis for MACRS 40,000 40,000 (7,140) (7,140) Trucks Total Cost Recovery per §179 Recovery per §168(k) Basis for MACRS 40,000 40,000 (6,000) (6,000) Computers Total Cost Recovery per §179 Recovery per §168(k) Basis for MACRS 70,000 70,000 (3,500) (3,500) (16,640) (16,640) Total Cost Recovery Deductions Check Figure - $ 16,640 $ Total 150,000 100% Sec. 179 Problem 8-42 Maximum §179 Provision §179 Provision Phaseout Floor $ 500,000 $ 2,000,000 Taxable Income Net Income before Cost Recovery Depreciable Basis- Current Acquisitions Less: Section 179 Provision Less: Section 168(k) Provision Cost Recovery Basis- Current Acquisitions MACRS % MACRS Deduction- Current Acquisitions MACRS Deduction- Past Acquisitions MACRS Deduction- Total Taxable Income before §179 Deduction $ $ $ $ $ $ $ 250,000 600,000 (500,000) 100,000 14.29% 14,290 95,000 $ $ (109,290) 140,710 $ (359,290) Carryforward Schedule Section 179 Deduction Carryforward from Previous Years Current Year Section 179 Provision Potential Deduction- Current Year Actual Deduction- Current Year Carryforward Current Year Taxable Income Total Cost Recovery- Current Year Additions $ $ $ $ $ 500,000 500,000 (140,710) $ 359,290 $ Carryforward Check Figure $ Capital Recovery 359,290 (140,710) - Depletion Problem 8-56 Check Figure Gross Income from Mineral Sales Less: Expenses Taxable Income Before Depletion Depletion Cost Depletion Cost of Mineral Deposits Estimated Number of Tons Purchased Cost per Ton Tons Sold Current Year Cost Depletion- Current Year Percentage Depletion Gross Income from Mineral Sales Percentage Depletion % Percentage Depletion $ $ Limitation for TI Before Depletion Percentage Depletion- Current Year $ $ $ $ $ 12,000,000 (5,000,000) 7,000,000 $ $ (2,640,000) 4,360,000 10,000,000 250,000 40 45,000 $ 1,800,000 $ $ 12,000,000 22% 2,640,000 3,500,000 $ 2,640,000 Depletion Deduction Taxable Income Capital Recovery $ 4,360,000 ...
View Full Document

  • Spring '13
  • WILSON
  • Accounting, Generally Accepted Accounting Principles

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes