Tax Provision Workbook
Concepts covered
| FINAL EXAM - Part I | |||
| Outline of Topics covered | |||
| Topic | Week Covered | ||
| Perm Ms | 1, 2 | ||
| Temp Ms | 1, 2 | ||
| AMT | 3 | ||
| Tax Credits | 3 | ||
| Valuation Allowance | 3 (lesson 2) | ||
| State Blended Rate | 4 | ||
| Interim Financial reporting | 5 | ||
| FIN 48 | 6, 7 | ||
| True-up | 9 | ||
| FS Disclosures | 8, 9 | ||
| Foreign - APB 23 | 11, 12 | ||
| Stock Options | 13, 14 | ||
INDEX
| DELTA Corporation & Subsidiary | |||
| FINAL EXAM Part 1 | |||
| INDEX to workpapers | |||
| tab # | Tab Description | ||
| Q | Questions to be answered | Yellow tab - Facts provided | |
| F | DELTA Corporation Facts | ||
| FA | Delta Fixed Asset Rollforward | ||
| FC | Foxtrot Corporation Facts | ||
| I | 2009 Interim Schedule | ||
| C | Delta Current Provision | ||
| P | Delta 2011 Provision-to-Return schedule | ||
| D | Delta Deferred Rollforward schedule | ||
| TA | Tax Account Rollforward schedule | ||
| R | Rate Reconciliation | ||
| FS | 2012 Consolidated Income Tax Footnote disclosure |
&A
&Z&F Printed on: &D &T
Q - Questions to be answered
| DELTA Corporation & Subsidiary | |||
| FINAL EXAM Part 1 | |||
| Tasks | |||
| Considering the facts outlined on tab "F" determine the following - | |||
| 1 | For 2009 only - determine the interim tax expense by completing the schedule on tab I | ||
| Consider only pre-tax income, perms and credits from facts tab. Assume no VA recorded for this portion of the exercise. | |||
| 2 | Prepare a current provision and deferred rollforward schedule for each of the years 2009 through 2012. | ||
| see example for 2009 at tabs C and D | |||
| 3 | Compute the 2011 provision-to-return JE and post as part of the 2012 provision | ||
| - use the template on tab P as a guide | |||
| 4 | Complete the Tax Account Analysis schedule tab TA for each year 2009 to 2012. | ||
| Note - actual taxes paid are reflected on this tab | |||
| 5 | Complete a Rate Reconciliation schedule tab R for each year 2009 to 2012. | ||
| see example for 2009 | |||
| 6 | Prepare a current and deferred tax provision for Foxtrot Corporation for the year 2012 (in FC and RC). | ||
| - see facts at tab FC and complete the yellow highlighted cells in the trial balance. | |||
| 7 | For 2012 only - create the Consolidated Income Tax footnotes (with 2011 comparison) (i.e., Delta + Foxtrot). | ||
| - use the templates on tab FS as a guide | |||
| Please show all your work (to provide for maximum credit). | |||
| Feel free to add columns, rows, & worksheets as necessary to complete the above tasks | |||
| Please reference your workpapers to make the review easier. | |||
| Note - there are hidden columns on tabs C, D, and P that you may want to use |
&A
&Z&F Printed on: &D &T
F - Delta Facts
| DELTA Corporation | ||||||||||
| FACTS | link | |||||||||
| DELTA is a "C" corporation (SEC registrant) operating entirely within the U.S. on the basis of a calendar year end. Delta was formed 1/1/2009. | ||||||||||
| Year 2009 | Year 2010 | Year 2011 | Year 2012 | |||||||
| per return | per return | per provision | per return (only if different) | per provision | ||||||
| Federal Tax Rate | 35% | 35% | 35% | 35% | ||||||
| States - | 100% NV - 0% rate | 100% NV - 0% rate | 100% OR @ 7.6% flat tax rate | 80% OR @ 7.6% rate | ||||||
| 20% IL @ 7.00% flat tax rate | ||||||||||
| Assume no fed/state differences other than state tax deduction which is not deductible for state tax purposes. | ||||||||||
| Assume states do not have an AMT tax concept. | ||||||||||
| Assume headquarters moved from Reno Nevada to Portland Oregon on 1/1/2011. Assume began operations in Illinois on 1/1/2012. [Hint - Prior YE deferred tax balance should not anticipate this change]. | ||||||||||
| Assume federal deduction for state taxes is on a "current" basis (i.e., federal deduction = state "current" tax expense) | ||||||||||
| Research expense: assume book = regular tax expense. In addition, assume yearly research expense is amortized over 10 years for AMT purposes | ||||||||||
| Fed regular = state tax depreciation | see tab FA for details | |||||||||
| Fed AMT tax depreciation | see tab FA for details | |||||||||
| Organizational expenses (incurred 1/1/2009) are expensed immediately for book purposes. For income tax purposes (pursuant to IRC Sec 248), the 1st $5,000 is expensed immediately with the remainder amortized SL over 180 months | ||||||||||
| IRC Sec. 263A Inventory Absorption % on gross ending inventory per BS | 2.0% | 2.2% | 2.2% | 2.3% | ||||||
| [Hint: EOY inventory capitalization DTA = EOY gross inventory x absorption ratio for year. Book/Tax difference equals EOY Inventory capitalization less BOY Inventory capitalization. See 2009 & 2010 Current Prov detail for example.] | ||||||||||
| Vacation paid w/in 2.5 months after YE | $ - 0 | $ 20,000 | $ - 0 | $ 15,000 | $ 30,000 | |||||
| Add'l penalty expense discovered w/in "misc expense" | $ - 0 | $ - 0 | $ - 0 | $ 5,000 | $ - 0 | |||||
| Research Tax Credit Generated (IRC Sec 280C election taken) - federal only | $ 12,800 | $ 19,500 | $ - 0 | $ - 0 | ||||||
| The investment in Echo Development, LLC is accounted for using the equity method of accounting and includes the $100,000 cash contribution (for both book and tax purposes) made by Delta Corporation on 1/1/2011 and Delta Corporation's $60,000 share of Echo Development's book income for the year ended 12/31/2011 and $40,000 book income for the year ended 12/31/2012. | ||||||||||
| Schedule K1s received from Echo Development, LLC reflect net rental real estate income as follows - | $ 40,000 | $ 50,000 | $ 50,000 | |||||||
| ISOs granted - | ||||||||||
| Grant Date | December 1, 2009 | |||||||||
| ISO issued to (non-officer) | employee Douglas | |||||||||
| # ISOs granted | 2,000 | |||||||||
| Exercise price per ISO | $ 10 | |||||||||
| FMV at date of Grant | $ 10 | |||||||||
| Cliff vesting period [i.e., all vest at end of 2 years] | 2 years | |||||||||
| Vesting / Exercise Date | December 1, 2011 | |||||||||
| FMV at vesting date | $ 16 | |||||||||
| Sale Date | December 31, 2012 | |||||||||
| FMV at date of Sale | $ 20 | |||||||||
| Non-Quals stock options granted - | ||||||||||
| Grant Date | December 31, 2009 | |||||||||
| Options issued to (non-officer) | employee Mildred | |||||||||
| # Options granted | 24,000 | |||||||||
| Exercise price per option | $ 8 | |||||||||
| FMV option at date of Grant | $ 8 | |||||||||
| FMV stock at date of Grant | $ 16 | |||||||||
| S/L Vesting period [i.e., 1/3 vest each year] | 3 years | |||||||||
| Exercise date #1 | June 15, 2011 | |||||||||
| Per share FMV at exercise date #1 | $ 16 | |||||||||
| Number of options exercised on date #1 | 6,000 | |||||||||
| Exercise date #2 | December 31, 2012 | |||||||||
| Per share FMV at exercise date #2 | $ 20 | |||||||||
| Number of options exercised on date #2 | 18,000 | |||||||||
| Sale Date | no sale through 12/31/2012 | |||||||||
| Zero opening APIC Pool, post any "windfalls" to Additional-Paid-in-Capital "APIC" (B/S) | ||||||||||
| Valuation Allowance - | ||||||||||
| Delta recorded a full valuation allowance against its deferred tax assets in 2009. | ||||||||||
| In 2010 Delta determined that it was more likely than not that it would be able to utilize all of its deferred tax assets. | ||||||||||
| FIN 48 analysis - | ||||||||||
| Prior to 2012 Delta had taken the position that it had no uncertain tax positions, thus it had not recorded any FIN 48 entries. | ||||||||||
| During the preparation of the 2012 tax provision Delta uncovered a few errors in prior tax returns as follow - | ||||||||||
| - A review of the liability accounts revealed that Delta's "Other Accrued Liability" account actually relates to a legal reserve that has not been settled as of 12/31/2011. | ||||||||||
| - Delta determined that the R&D credit generated in 2009 and 2010 was overstated by $2,000 and $3,000 respectively. | ||||||||||
| Delta has decided not to amend prior returns, but will instead record a FIN 48 liability as part of its 2012 year-end tax provision | ||||||||||
| Assume a penalty rate of 3% and an interest rate of 6% (fed & state). Delta has elected to record FIN 48 interest and penalties as part of its tax provision expense. | ||||||||||
| Interest and penalties are computed from the original due date of the impacted tax return to the end of the financial statement year. | ||||||||||
| Assume FIN 48 Interest is not deductible for federal or state tax purposes. | ||||||||||
| Foreign Operations - | ||||||||||
| Delta Corporation formed Foxtrot Corporation on 1/1/2012 as a wholly-owned subsidiary of Delta Corporation - see tab FC for details. | ||||||||||
| TRIAL BALANCE - DELTA Corporation | ||||||||||
| yellow cells in TB need to be completed as part of Exam | ||||||||||
| Dr (Cr) | Year 2009 | Year 2010 | Year 2011 | Year 2012 | ||||||
| Balance Sheet | ||||||||||
| Cash & ST Investments | 80,000 | 400,000 | 300,000 | 1,350,000 | ||||||
| Accounts Receivable | 50,000 | 385,000 | 1,800,000 | 2,900,000 | ||||||
| Allowance for Doubtful Accounts | - | - | (100,000) | C | (120,000) | C | ||||
| Inventory (gross before reserve) | 100,000 | C | 200,000 | C | 260,000 | C | 300,000 | C | ||
| Inventory Obsolescence Reserve [hint: temp] YourNameHere: Inventory Obsolescence Reserve: Reserve established against estimated inventory that will be disposed at zero sales price (i.e., thrown-out as obsolete) rather than being sold. | - | (50,000) | C | (70,000) | C | (40,000) | C | |||
| Investment in Echo Development, LLC | - | - | 160,000 | 200,000 | ||||||
| Investment in Foxtrot Corporation | - | - | - | FC | 100,000 | |||||
| Deferred Tax Asset/(Liability) - Current | - | TA | 149,583 | TA | TA | |||||
| Fixed Asset, cost | FA | 200,000 | 270,000 | 710,000 | 950,000 | |||||
| Fixed Asset, Accum Depr. | FA | (20,000) | (47,000) | (88,000) | (153,000) | |||||
| Total Assets | $ 410,000 | $ 1,307,583 | $ 2,972,000 | $ 5,487,000 | ||||||
| Accounts Payable | (110,067) | (229,067) | (1,022,900) | (742,601) | ||||||
| Vacation Payable | - | (20,000) | (40,000) | (50,000) | ||||||
| Income Tax (Payable)/Receivable | - | TA | 2,325 | TA | (348,622) | TA | (1,235,040) | |||
| Other Accrued Liabilities | - | - | (100,000) | (100,000) | ||||||
| Deferred Tax Asset/(Liability) - Non-Current | - | - | - | TA | ||||||
| FIN 48 (Liability) - Non-Current | - | - | - | TA | ||||||
| Long-Term Debt (to 3rd party bank) | (400,000) | (800,000) | (600,000) | (800,000) | ||||||
| Common Stock | (100) | (100) | (100) | (100) | ||||||
| APIC | (200,833) | (274,833) | (348,000) | (412,000) | ||||||
| Retained Earnings - BOY | - | 301,000 | 51,000 | (1,111,000) | ||||||
| Current year earnings | 301,000 | (250,000) | (1,162,000) | (2,690,000) | ||||||
| Total Liabilities & Equity | $ (410,000) | $ (1,270,675) | $ (3,570,622) | $ (7,140,741) | ||||||
| - | 36,908 | (598,622) | (1,653,741) | |||||||
| Income Statement | ||||||||||
| Sales | (4,000,000) | (8,000,000) | (10,800,000) | (11,300,000) | ||||||
| Cost of Goods sold | 1,500,000 | 3,000,000 | 3,625,000 | 3,230,000 | ||||||
| Officer's base salary expense (President) | 400,000 | 850,000 | 1,200,000 | 1,050,000 | ||||||
| Officer's base salary expense (CFO) | 250,000 | 600,000 | 855,000 | 1,010,000 | ||||||
| Salary expense (non-officers) | 1,000,000 | 1,600,000 | 2,200,000 | 1,800,000 | ||||||
| Benefits expense (includes vacation, bonus, etc.) | 200,000 | 320,000 | 440,000 | 360,000 | ||||||
| ISO compensation expense | 833 | C | 10,000 | C | 9,167 | C | - | C | ||
| Non-Qual comp expense | - | 64,000 | C | 64,000 | C | 64,000 | C | |||
| Payroll tax & license expense | 400,000 | 640,000 | 880,000 | 720,000 | ||||||
| Penalty expense | - | C | 2,000 | C | 1,000 | C | 4,000 | C | ||
| Meals & Entertainment expense | 20,000 | C | 30,000 | C | 44,000 | C | 50,000 | C | ||
| Rent expense | 200,000 | 200,000 | - | 100,000 | ||||||
| Supplies expense | 19,667 | 9,000 | 10,833 | 49,000 | ||||||
| Organizational expense | 50,000 | C | - | - | - | |||||
| Bad Debt expense | 5,500 | 20,000 | 100,000 | 10,000 | ||||||
| Depreciation expense | FA | 20,000 | C | 27,000 | C | 41,000 | C | 65,000 | C | |
| <Income> Loss from Echo Development, LLC | - | - | (60,000) | C | (40,000) | C | ||||
| Research expenses | 200,000 | C | 300,000 | C | - | - | ||||
| Other Misc expenses | 11,000 | 25,000 | 164,000 | 60,000 | ||||||
| Charitable contribution expense | - | 5,000 | 40,000 | 30,000 | ||||||
| Interest income (tax exempt both fed & state) | - | C | - | C | (12,000) | C | - | C | ||
| Interest expense | 24,000 | 48,000 | 36,000 | 48,000 | ||||||
| Pre-tax (Income)/ Loss | 301,000 | C | (250,000) | C | (1,162,000) | C | (2,690,000) | C | ||
| Income tax expense / (benefit) | - | |||||||||
| Net (Income) / Loss | $ 301,000 | $ (250,000) | $ (1,162,000) | $ (2,690,000) |
&A
&Z&F Printed on: &D &T Page &P of &N
FA - Fixed Asset rollforward
| DELTA Corporation (only) | |||||||||||||||||||||
| Fixed Asset Rollforward Schedule | input | ||||||||||||||||||||
| link | |||||||||||||||||||||
| Assume all acquisitions purchased on January 1 each year. | |||||||||||||||||||||
| Assume no dispositions during years shown (i.e., when move HQ they transfer all assets to new location) | |||||||||||||||||||||
| Note - this schedule provides far more detail than is necessary for this Exam. | |||||||||||||||||||||
| Assume elected out of all bonus depreciation | |||||||||||||||||||||
| initial yr | |||||||||||||||||||||
| 12/31/2009 | 2010 adds | 12/31/2010 | 2011 adds | 12/31/2011 | 2012 adds | 12/31/2012 | |||||||||||||||
| Fixed Asset Cost | |||||||||||||||||||||
| Building | - | - | - | 400,000 | 400,000 | - | 400,000 | ||||||||||||||
| Machinery | 100,000 | 50,000 | 150,000 | 20,000 | 170,000 | 130,000 | 300,000 | ||||||||||||||
| Furniture | 100,000 | 20,000 | 120,000 | 20,000 | 140,000 | 110,000 | 250,000 | ||||||||||||||
| Total cost | 200,000 | 70,000 | 270,000 | 440,000 | 710,000 | 240,000 | 950,000 | ||||||||||||||
| F | F | F | F | ||||||||||||||||||
| Book Depreciation | |||||||||||||||||||||
| Building | 40 yr | SL | - | - | - | 10,000 | 10,000 | 10,000 | 20,000 | ||||||||||||
| Machinery | 10 yr | SL | 10,000 | 15,000 | 25,000 | 17,000 | 42,000 | 30,000 | 72,000 | ||||||||||||
| Furniture | 10 yr | SL | 10,000 | 12,000 | 22,000 | 14,000 | 36,000 | 25,000 | 61,000 | ||||||||||||
| Total Book Depr. | 20,000 | 27,000 | 47,000 | 41,000 | 88,000 | 65,000 | 153,000 | ||||||||||||||
| F | F | F | F | F | F | F | |||||||||||||||
| Net Book Value | 180,000 | 223,000 | 622,000 | 797,000 | |||||||||||||||||
| Regular | Regular | ||||||||||||||||||||
| Regular Tax Depreciation | 5-yr | 7-yr | |||||||||||||||||||
| Building | 39.5 yr | SL | - | - | - | 10,127 | 10,127 | 10,127 | 20,254 | 20.00% | 14.29% | ||||||||||
| 32.00% | 24.49% | ||||||||||||||||||||
| Machinery | 5 yr | 200% MACRS | 20,000 | 42,000 | 62,000 | 39,200 | 101,200 | 53,520 | 154,720 | 19.20% | 17.49% | ||||||||||
| assume 1/2 year convention | 11.52% | 12.49% | |||||||||||||||||||
| Furniture | 7 yr | 200% MACRS | 14,290 | 27,348 | 41,638 | 25,246 | 66,884 | 36,605 | 103,489 | 11.52% | 8.93% | ||||||||||
| assume 1/2 year convention | 5.76% | 8.92% | |||||||||||||||||||
| Total Regular Tax Depr. | 34,290 | 69,348 | 103,638 | 74,573 | 178,211 | 100,252 | 278,463 | 8.93% | |||||||||||||
| C | C | C | C | 4.46% | |||||||||||||||||
| Net Tax Value | 165,710 | ||||||||||||||||||||
| AMT | AMT | ||||||||||||||||||||
| AMT Tax Depreciation | 5-yr | 7-yr | |||||||||||||||||||
| SL | SL | ||||||||||||||||||||
| Building | 39.5 yr | SL | - | - | - | 10,127 | 10,127 | 10,127 | 20,254 | 10.00% | 7.14% | ||||||||||
| 20.00% | 14.29% | ||||||||||||||||||||
| Machinery | 5 yr | SL | 10,000 | 25,000 | 35,000 | 32,000 | 67,000 | 47,000 | 114,000 | 20.00% | 14.29% | ||||||||||
| assume 1/2 year convention | 20.00% | 14.28% | |||||||||||||||||||
| Furniture | 7 yr | SL | 7,140 | 15,718 | 22,858 | 18,576 | 41,434 | 27,850 | 69,284 | 20.00% | 14.29% | ||||||||||
| assume 1/2 year convention | 10.00% | 14.28% | |||||||||||||||||||
| Total AMT Tax Depr. | 17,140 | 40,718 | 57,858 | 60,703 | 118,561 | 84,977 | 203,538 | 14.29% | |||||||||||||
| C | C | C | C | 7.14% |
&A
&Z&F Printed on: &D &[Time
FC - Foxtrot Facts
| Foxtrot Corporation | |||||
| FACTS | Final Exam Question #6 | input | |||
| Year Ended December 31, 2012 | |||||
| Task - Compute the 2012 current and deferred tax provision for Foxtrot Corporation and complete the yellow highlighted portions of the trial balance. | |||||
| Delta Corporation formed Foxtrot Corporation on 1/1/2012 as a wholly-owned subsidiary of Delta Corporation. | |||||
| Foxtrot Corporation operates entirely within Country Z where the statutory income tax rate is 20%. | |||||
| The Functional Currency in Country Z is Z$ | |||||
| Foxtrot Corporations' Reporting Currency is the US Dollar. | |||||
| Fines & Penalties are 50% deductible for income tax purposes in Country Z. | |||||
| Reserves for bad debts are currently deductible on an accrual basis in Country Z [hint: no temporary difference]. | |||||
| Warranties are deductible on a cash basis only in Country Z. | |||||
| Tax depreciation computed under the income tax laws of Country Z is Z$ 2,000,000 for 2012. | |||||
| Foxtrot Corporation has not made any tax payments during 2012 to Country Z taxing authorities. | |||||
| Delta Corporation has made an APB 23 election with respect to Foxtrot Corporation for 2012. | |||||
| Weighted average FX 2012: | F$ to US$ | 1:1 | |||
| FX rate at 12/31/2012: | F$ to US$ | 1:1.1 | |||
| Below is the Trial Balance of Foxtrot Corporation prior to posting the YE tax provision - | |||||
| Dr(Cr) | |||||
| Year Ended December 31, 2012 | |||||
| FC | US Dollar | ||||
| Functional Currency of Country Z | FX Rate | Reporting Currency | |||
| Current Assets | |||||
| Cash | 500,000 | 1.1 | 550,000 | ||
| Accounts receivable | 2,000,000 | 1.1 | 2,200,000 | ||
| Reserve for bad debts | (500,000) | 1.1 | (550,000) | ||
| Noncurent Assets | |||||
| Fixed assets | 6,000,000 | 1.1 | 6,600,000 | ||
| Accumulated depreciation | (1,000,000) | 1.1 | (1,100,000) | ||
| Total Assets | 7,000,000 | 7,700,000 | |||
| Current Liabilities | |||||
| Accounts payable | (5,600,000) | 1.1 | (6,160,000) | ||
| Accrued warranties | (800,000) | 1.1 | (880,000) | ||
| Current taxes (payable) / receivable | - | 1.1 | - | ||
| Deferred tax asset / (liability) | - | 1.1 | - | ||
| Equity | |||||
| Common Stock | (100,000) | Historical | (100,000) | ||
| BOY Retained earnings | - | Historical | - | ||
| Book <income> loss | (500,000) | Historical | (500,000) | ||
| Cumulative translation adjustment | Calculated | (60,000) | |||
| Total Liabilities & Equity | (7,000,000) | (7,700,000) | |||
| - | - | ||||
| Income Statement | |||||
| Revenue | (7,500,000) | 1.0 | (7,500,000) | ||
| Cost of goods sold | 2,500,000 | 1.0 | 2,500,000 | ||
| Bad debt expense | 500,000 | 1.0 | 500,000 | ||
| Depreciation | 1,000,000 | 1.0 | 1,000,000 | ||
| Fines & penalties | 500,000 | 1.0 | 500,000 | ||
| Other | 2,500,000 | 1.0 | 2,500,000 | ||
| Pre-tax (Income)/ Loss | (500,000) | (500,000) | |||
| Income tax expense / (benefit) | - | 1.0 | - | ||
| Net (Income) / Loss | (500,000) | (500,000) | |||
&A
&Z&F Printed on: &D &T
I - 2009 Interim schedule
| DELTA Corporation (only) | ||||||
| 2009 Interim Reporting | Final Exam Question #1 | |||||
| The below table lists (in column C of rows 9 to 12) pre-tax income for each quarter in 2009 | ||||||
| Task - Complete the amounts in column E | ||||||
| Consider only pre-tax income, perms and credits. Assume no VA recorded for this portion of the exercise (i.e., credits useable). | ||||||
| Use the data provided on tabs F and C as the basis for your 2009 interim calculations | ||||||
| Reporting Period | Q Ordinary Income <Loss> | YTD Ordinary Income <Loss> | YTD Tax Expense <Benefit> | Less Previously Reported | Reporting Period Only | |
| Q1 | 100,000 | 100,000 | - | - | ||
| Q2 | (200,000) | (100,000) | - | - | ||
| Q3 | (400,000) | (500,000) | - | - | ||
| Q4 | 199,000 | (301,000) | - | - | ||
| Annual | (301,000) | - | ||||
| [Hint: there is a perm that isn't known until Q4] | ||||||
&A
&Z&F Printed on: &D &T
C - Current Prov
| DELTA Corporation (only) | |||||||||||||||||||||||||||||||||||||||
| Current Provision Calculation | input | ||||||||||||||||||||||||||||||||||||||
| link | |||||||||||||||||||||||||||||||||||||||
| not used | |||||||||||||||||||||||||||||||||||||||
| 2009 | 2010 | 2011 | 2012 | ||||||||||||||||||||||||||||||||||||
| Federal | State | Federal | Federal | State | Federal | Federal | State | State | Federal | Federal | State | State | |||||||||||||||||||||||||||
| (Dr) / Cr | Dr / (Cr) | Dr / (Cr) | (Dr) / Cr | (Dr) / Cr | Dr / (Cr) | Dr / (Cr) | (Dr) / Cr | (Dr) / Cr | Dr / (Cr) | Dr / (Cr) | (Dr) / Cr | Dr / (Cr) | Dr / (Cr) | (Dr) / Cr | Dr / (Cr) | Dr / (Cr) | Dr / (Cr) | Dr / (Cr) | (Dr) / Cr | Dr / (Cr) | Dr / (Cr) | Dr / (Cr) | Dr / (Cr) | ||||||||||||||||
| payable (B/S) | Expense (I/S) | Deferred (B/S) | payable (B/S) | payable (B/S) | Expense (I/S) | Deferred (B/S) | payable (B/S) | payable (B/S) | Expense (I/S) | Deferred (B/S) | payable (B/S) | Expense (I/S) | Deferred (B/S) | payable (B/S) | Expense (I/S) | Deferred (B/S) | FIN 48 payable | APIC | payable (B/S) | Expense (I/S) | Deferred (B/S) | FIN 48 payable | APIC | ||||||||||||||||
| Pre-tax Income/(Loss) | F | (301,000) | (301,000) | (301,000) | F | 250,000 | 250,000 | 250,000 | F | 1,162,000 | 1,162,000 | FS | 1,162,000 | 1,162,000 | F | 2,690,000 | 2,690,000 | FS | 2,690,000 | 2,690,000 | |||||||||||||||||||
| Permanent Differences | |||||||||||||||||||||||||||||||||||||||
| Penalties | F | - | - | - | F | - | - | F | - | FS | - | - | F | - | FS | - | - | ||||||||||||||||||||||
| Meals & Entertainment | Note 1 | 10,000 | 10,000 | 10,000 | - | - | - | - | - | FS | - | - | - | - | FS | - | - | ||||||||||||||||||||||
| Stock Comp Expense | F | 833 | 833 | 833 | F | - | - | F | - | FS | - | - | F | - | - | FS | - | - | |||||||||||||||||||||
| Other - Perm #1 | - | - | - | - | - | - | F | - | FS | - | - | F | - | FS | - | - | |||||||||||||||||||||||
| Other - Perm #2 | F | - | - | - | F | - | - | F | - | FS | - | - | F | - | - | FS | - | - | |||||||||||||||||||||
| Subtotal Perm Differences | 10,833 | 10,833 | - | 10,833 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||
| Pre-Tax + Perms | (290,167) | (290,167) | - | (290,167) | 250,000 | 250,000 | - | 250,000 | 1,162,000 | 1,162,000 | - | 1,162,000 | 1,162,000 | - | 2,690,000 | 2,690,000 | - | - | - | 2,690,000 | 2,690,000 | - | - | - | |||||||||||||||
| State Tax Deduction | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||
| Temporary Differences | |||||||||||||||||||||||||||||||||||||||
| Other - Reserve #1 | Note 6 | - | - | - | - | - | - | - | - | D | - | - | - | - | D | - | - | ||||||||||||||||||||||
| 263A Inventory Capitalization | Note 2 | 2,000 | 2,000 | D | 2,000 | 2,400 | 2,400 | D | 2,400 | - | - | D | - | - | - | - | D | - | - | ||||||||||||||||||||
| Inventory Reserve | Note 5 | - | - | D | - | - | - | D | - | - | - | D | - | - | - | - | D | - | - | ||||||||||||||||||||
| Non-Qual Stock Comp per books | F | - | - | - | F | - | - | F | - | - | - | F | - | - | - | ||||||||||||||||||||||||
| Non-Qual Stock Comp per tax | - | - | D | - | - | - | D | - | F | - | D | - | - | F | F | D | F | - | - | - | - | ||||||||||||||||||
| Other - Reserve #2 | Note 7 | - | - | D | - | - | - | D | - | - | - | D | - | - | - | - | D | - | - | ||||||||||||||||||||
| Book Depreciation | F | 20,000 | 20,000 | 20,000 | F | - | - | F | - | - | - | F | - | - | - | ||||||||||||||||||||||||
| Tax Depreciation | FA | (34,290) | (34,290) | D | (34,290) | FA | - | D | - | FA | - | D | - | - | FA | - | D | - | - | ||||||||||||||||||||
| Organizational Expense | Note 3 | 42,000 | 42,000 | D | 42,000 | - | - | D | - | - | - | D | - | - | - | - | D | - | - | ||||||||||||||||||||
| Other - Adj. per books | F | - | - | - | F | - | - | F | - | - | - | F | - | - | - | ||||||||||||||||||||||||
| Other - Adj. per tax | - | - | D | - | - | - | D | - | F | - | D | - | - | F | - | D | - | - | |||||||||||||||||||||
| Other - Reserve #3 | - | - | - | - | - | - | - | - | - | - | - | F | D | - | - | - | - | ||||||||||||||||||||||
| Subtotal Temp Differences | 29,710 | - | 29,710 | 29,710 | 2,400 | - | 2,400 | 2,400 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||
| Regular Taxable Income/(Loss) | (260,457) | (290,167) | 29,710 | (260,457) | 252,400 | 250,000 | 2,400 | 252,400 | 1,162,000 | 1,162,000 | - | 1,162,000 | 1,162,000 | - | 2,690,000 | 2,690,000 | - | - | - | 2,690,000 | 2,690,000 | - | - | - | |||||||||||||||
| NOL C/F Generated / (Utilized) | 260,457 | 260,457 | D | 260,457 | D | - | D | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||
| Regular Taxable Income/(Loss) after NOL | - | (290,167) | 290,167 | - | 252,400 | 250,000 | 2,400 | 252,400 | 1,162,000 | 1,162,000 | - | 1,162,000 | 1,162,000 | - | 2,690,000 | 2,690,000 | - | - | - | 2,690,000 | 2,690,000 | - | - | - | |||||||||||||||
| Tax Rate | F | 35% | 35% | 35% | F | 0% | F | 35% | 35% | 35% | F | 0% | F | 35% | 35% | 35% | F | 0.0% | 0.0% | F | 35% | 35% | 35% | 35% | 35% | F | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||
| Tax b4 credits | - | (101,558) | 101,558 | - | 88,340 | 87,500 | 840 | - | 406,700 | 406,699 | - | - | - | - | 941,500 | 941,500 | - | - | - | - | - | - | - | - | |||||||||||||||
| AMT Tax Credit | - | - | - | - | - | - | - | - | D | - | - | - | D | - | - | - | - | - | |||||||||||||||||||||
| R&E Tax Credit | - | (12,800) | 12,800 | D | - | - | - | D | - | D | - | - | D | - | - | - | D | - | - | 1 | - | F | - | - | - | ||||||||||||||
| AMT Adjustments | - | - | - | - | - | D | - | - | - | - | |||||||||||||||||||||||||||||
| Valuation Allowance Adjustment | 114,358 | (114,358) | - | - | - | D | - | - | D | ||||||||||||||||||||||||||||||
| Tax Rate Adjustment | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||||
| Current Year Tax after credits | - | - | - | - | 88,340 | 87,500 | 840 | - | 406,700 | 406,699 | - | - | - | - | 941,500 | 941,500 | - | - | - | - | - | - | - | - | |||||||||||||||
| State Tax after credits | - | - | - | - | - | FS | - | - | - | - | - | FS | |||||||||||||||||||||||||||
| FIN 48 Interest | - | - | - | - | - | - | 1 | - | |||||||||||||||||||||||||||||||
| FIN 48 Penalty | - | - | - | - | - | - | 1 | - | |||||||||||||||||||||||||||||||
| Total CY Federal + State Tax after credits | - | 88,340 | 406,700 | 406,699 | - | 941,500 | 941,500 | - | - | - | |||||||||||||||||||||||||||||
| - | = sum 1 | ||||||||||||||||||||||||||||||||||||||
| AMT Calculation - | FS | FIN 48 Liability all relates to Calendar 2011 | |||||||||||||||||||||||||||||||||||||
| Regular taxable income / (loss) | (260,457) | 252,400 | 1,162,000 | 2,690,000 | - | FIN 48 Tax Liability (fed + state) | |||||||||||||||||||||||||||||||||
| plus regular tax depreciation | 34,290 | - | - | - | - | Penalty @ 3% of tax | |||||||||||||||||||||||||||||||||
| less AMT tax depreciation | FA | (17,140) | - | Interest @ 6% of tax | |||||||||||||||||||||||||||||||||||
| plus research tax expense | F | 200,000 | - | - | 3/15/2012 to 12/31/2012 = 290 days | ||||||||||||||||||||||||||||||||||
| less AMT research expense amortization | Note 4 | (20,000) | - | - | - | ||||||||||||||||||||||||||||||||||
| less AMT NOL C/F | - | (63,307) | - | - | |||||||||||||||||||||||||||||||||||
| AMT Taxable Income / (Loss) | (63,307) | 189,093 | 1,162,000 | 2,690,000 | |||||||||||||||||||||||||||||||||||
| AMT tax rate | 20% | 20% | 20% | 20% | |||||||||||||||||||||||||||||||||||
| AMT tax | - | 37,819 | 232,400 | 538,000 | |||||||||||||||||||||||||||||||||||
| Regular tax | - | 88,340 | 406,700 | 941,500 | |||||||||||||||||||||||||||||||||||
| AMT Adj. | - | - | - | - | |||||||||||||||||||||||||||||||||||
| Supporting Calculations | |||||||||||||||||||||||||||||||||||||||
| Note 1 | Meals & Ent Adj. | ||||||||||||||||||||||||||||||||||||||
| Meals & Ent expense per books | F | 20,000 | F | F | F | ||||||||||||||||||||||||||||||||||
| disallowance % | 50.0% | 50.0% | 50.0% | 50.0% | |||||||||||||||||||||||||||||||||||
| Disallowed Meals Expense | 10,000 | - | - | - | |||||||||||||||||||||||||||||||||||
| Note 2 | 263A Inventory Adj. | ||||||||||||||||||||||||||||||||||||||
| EOY Inventory per BS | F | 100,000 | F | 200,000 | F | F | |||||||||||||||||||||||||||||||||
| 263A absorption ratio | F | 2.0% | F | 2.2% | F | F | |||||||||||||||||||||||||||||||||
| EOY Inventory Capitalization Adj. | 2,000 | 4,400 | - | - | |||||||||||||||||||||||||||||||||||
| BOY Inventory Capitalization Adj. | - | 2,000 | - | ||||||||||||||||||||||||||||||||||||
| current change in 263A Adj. | 2,000 | 2,400 | - | - | |||||||||||||||||||||||||||||||||||
| Note 3 | Organizational Exp | ||||||||||||||||||||||||||||||||||||||
| Book Organizational Expense | F | 50,000 | c | F | - | F | - | F | - | ||||||||||||||||||||||||||||||
| Tax immediate expense | (5,000) | a | |||||||||||||||||||||||||||||||||||||
| Capitalized Tax Org Costs | 45,000 | - | - | ||||||||||||||||||||||||||||||||||||
| total tax amortization period in months | 180 | 180 | 180 | 180 | |||||||||||||||||||||||||||||||||||
| monthly amortization | 250 | - | - | - | |||||||||||||||||||||||||||||||||||
| months in year | 12 | 12 | 12 | 12 | |||||||||||||||||||||||||||||||||||
| annual tax amort Org costs | 3,000 | b | - | - | - | ||||||||||||||||||||||||||||||||||
| 2009 Tax Org Cost expense | b-a | 8,000 | d | - | - | - | |||||||||||||||||||||||||||||||||
| Book > Tax Org Cost | c-d | 42,000 | - | - | - | ||||||||||||||||||||||||||||||||||
| Note 4 | AMT research Expense Amort. | ||||||||||||||||||||||||||||||||||||||
| Book/regular tax research expense | F | 200,000 | F | F | F | ||||||||||||||||||||||||||||||||||
| AMT amortization period in years | 10 | 10 | 10 | 10 | |||||||||||||||||||||||||||||||||||
| AMT research amort. on CY adds | 20,000 | - | - | - | |||||||||||||||||||||||||||||||||||
| AMT research amort. on PY adds | - | - | |||||||||||||||||||||||||||||||||||||
| Total AMT amort. | - | - | - | ||||||||||||||||||||||||||||||||||||
| Note 5 | Inventory Reserve | ||||||||||||||||||||||||||||||||||||||
| EOY reserve | F | - | F | ||||||||||||||||||||||||||||||||||||
| BOY reserve | - | F | - | - | - | ||||||||||||||||||||||||||||||||||
| Net change in reserve - CY | - | - | - | - | |||||||||||||||||||||||||||||||||||
| Note 6 | Other - Reserve #1 | ||||||||||||||||||||||||||||||||||||||
| EOY reserve | F | - | F | F | F | ||||||||||||||||||||||||||||||||||
| BOY reserve | - | F | - | - | |||||||||||||||||||||||||||||||||||
| Net change in reserve - CY | - | - | - | - | |||||||||||||||||||||||||||||||||||
| Note 7 | Other - Reserve #2 | ||||||||||||||||||||||||||||||||||||||
| EOY reserve | F | F | F | ||||||||||||||||||||||||||||||||||||
| less amt paid w/in 2.5 months of YE | F | F | F | ||||||||||||||||||||||||||||||||||||
| BOY reserve | - | F | F | - | F | - | |||||||||||||||||||||||||||||||||
| less amt paid w/in 2.5 months of YE | - | F | F | - | P | per return | |||||||||||||||||||||||||||||||||
| Net change in reserve - CY | - | - | - | - | |||||||||||||||||||||||||||||||||||
&A
&Z&F Printed on: &D &T Page &P of &N
P - Prov-Return
| DELTA Corporation (only) | ||||||||||||||||||
| Provision-to-Return | Final Exam Question #3 | |||||||||||||||||
| Calendar 2011 | Task - Prepare a Provision-to-Return Reconciliation for 2011 and post the resulting entry as part of the 2012 YE tax provision. | |||||||||||||||||
| (Dr) / Cr | Dr / (Cr) | Dr / (Cr) | (Dr) / Cr | Dr / (Cr) | Dr / (Cr) | |||||||||||||
| payable (B/S) | Expense (I/S) | Deferred (B/S) | payable (B/S) | Expense (I/S) | Deferred (B/S) | |||||||||||||
| Federal | State | |||||||||||||||||
| per Provision | per Return | Difference | per Provision | per Return | Difference | |||||||||||||
| Pre-tax Income/(Loss) | C | - | - | - | C | - | - | - | ||||||||||
| Permanent Differences | ||||||||||||||||||
| Penalties | C | F | - | - | C | - | - | - | ||||||||||
| Meals & Entertainment | C | - | - | - | C | - | - | - | ||||||||||
| Stock Comp Expense | C | - | - | - | C | - | - | - | ||||||||||
| Other - Perm #1 | C | - | - | - | C | - | - | - | ||||||||||
| Other - Perm #2 | C | - | - | - | C | - | - | - | ||||||||||
| Subtotal Perm Differences | - | - | - | - | - | - | - | - | - | - | ||||||||
| Pre-Tax + Perms | - | - | - | - | - | - | - | - | - | - | ||||||||
| State Tax Deduction | C | - | - | - | - | |||||||||||||
| Temporary Differences | ||||||||||||||||||
| Other - Reserve #1 | C | - | - | - | C | - | - | - | ||||||||||
| 263A Inventory Capitalization | C | - | - | - | C | - | - | - | ||||||||||
| Inventory Reserve | C | - | - | - | C | - | - | - | ||||||||||
| Non-Qual Stock Comp per books | C | - | - | - | C | - | - | - | ||||||||||
| Non-Qual Stock Comp per tax | C | - | - | - | C | - | - | - | ||||||||||
| Other - Reserve #2 | C | - | - | C | - | - | - | |||||||||||
| Book Depreciation | C | - | - | - | C | - | - | - | ||||||||||
| Tax Depreciation | C | - | - | - | C | - | - | - | ||||||||||
| Organizational Expense | C | - | - | - | C | - | - | - | ||||||||||
| Other - Adj. per books | C | - | - | - | C | - | - | - | ||||||||||
| Other - Adj. per tax | C | F | - | - | C | - | - | - | ||||||||||
| Other - Reserve #3 | C | - | - | - | C | - | - | - | - | |||||||||
| Subtotal Temp Differences | - | - | - | - | - | - | - | - | - | - | ||||||||
| Regular Taxable Income/(Loss) | - | - | - | - | - | - | - | - | - | - | ||||||||
| NOL C/F Utilized | C | - | - | - | - | - | - | - | - | |||||||||
| Regular Taxable Income/(Loss) after NOL | - | - | - | - | - | - | - | - | - | - | ||||||||
| Tax Rate | C | 35% | 35% | 35% | 35.0% | 35.0% | C | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | ||||||
| Tax b4 credits | - | - | - | - | - | - | - | - | - | - | ||||||||
| AMT Tax Credit | C | - | - | - | C | - | - | - | ||||||||||
| R&E Tax Credit | C | - | - | - | C | - | - | - | ||||||||||
| AMT Adjustments | C | - | - | - | C | - | - | - | ||||||||||
| Current Year Tax after credits | - | - | - | - | - | - | - | - | - | - | ||||||||
| State Tax after credits | - | - | - | - | - | |||||||||||||
| Total CY Federal + State Tax after credits | - | - | - | - | - | |||||||||||||
| R | ||||||||||||||||||
| AMT Calculation - | ||||||||||||||||||
| Regular taxable income | - | - | ||||||||||||||||
| less regular tax depreciation | - | - | ||||||||||||||||
| plus AMT tax depreciation | C | - | ||||||||||||||||
| less research tax expense | C | - | ||||||||||||||||
| plus AMT research expense amortization | C | - | ||||||||||||||||
| less AMT NOL C/F | C | - | ||||||||||||||||
| AMT Taxable (Income)/Loss | - | - | ||||||||||||||||
| AMT tax rate | 20% | 20% | ||||||||||||||||
| AMT tax | - | - | ||||||||||||||||
| Regular tax | - | - | ||||||||||||||||
| AMT Adj. | - | - | ||||||||||||||||
| Note 7 | Vacation Accrual | |||||||||||||||||
| EOY reserve | C | F | ||||||||||||||||
| less amt paid w/in 2.5 months of YE | C | F | ||||||||||||||||
| BOY reserve | C | - | ||||||||||||||||
| less amt paid w/in 2.5 months of YE | C | - | ||||||||||||||||
| Net change in reserve - CY | - | - |
&A
&Z&F Printed on: &D &T
D - Deferred Rollforward
| DELTA Corporation (only) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Deferred Tax Rollforward Schedule | input | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| link | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Dr (Cr) | Federal BOY | Federal + State BOY | Federal EOY | Federal + State EOY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2009 GROSS | 2010 GROSS | 2011 GROSS | 2012 GROSS | 2009 Tax Effected | 2010 Tax Effected | 2011 Tax Effected | 2012 Tax Effected | Tax effected at FYE 12/11 | Tax effected at FYE 12/11 | Tax effected at FYE 12/12 | Tax effected at FYE 12/12 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| BOY | PY | CY Activity | EOY | PY | CY Activity | EOY | PY | CY Activity | EOY | 2011 | CY Activity | EOY | BOY | PY | CY Activity | Rate Adj. / | EOY | PY | CY Activity | Rate Adj. / | EOY | PY | CY Activity | Rate Adj. / | EOY | 2011 | CY Activity | Rate Adj. / | EOY | Current | Non-Current | Current | Non-Current | Current | Non-Current | Current | Non-Current | ||||||||||||||||||||||||||||||||
| C/NC | 1/1/09 | True-up | 2009 | Other Adj. | 12/31/09 | True-up | 2010 | Other Adj. | 12/31/10 | True-up | 2011 | Other Adj. | 12/31/11 | True-up | 2012 | Other Adj. | 12/31/12 | 1/1/09 | True-up | 2009 | Other | 12/31/09 | True-up | 2010 | Other | 12/31/10 | True-up | 2011 | Other | 12/31/11 | True-up | 2012 | Other | 12/31/12 | Asset | Liability | Asset | Liability | Asset | Liability | Asset | Liability | Asset | Liability | Asset | Liability | Asset | Liability | Asset | Liability | |||||||||||||||||||
| FEDERAL | 35% | 35% | 35% | 35% | 35% | 35% | 35% | 35% | 35% | 35% | 35% | 35% | 35% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Other - Reserve #1 | C | - | - | C | - | - | - | - | C | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||
| 263A Capitalization | C | - | - | C | 2,000 | - | 2,000 | - | C | 2,400 | - | 4,400 | - | C | - | - | 4,400 | P | - | C | - | - | 4,400 | - | - | 700 | - | 700 | - | 840 | - | 1,540 | - | - | - | 1,540 | - | - | - | 1,540 | 1,540 | - | - | - | 1,540 | - | - | - | 1,540 | - | - | - | 1,540 | - | - | - | |||||||||||||
| Inventory Reserve | C | - | - | C | - | - | - | - | C | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||
| Non-Qual Stock Option Comp | NC | - | - | C | - | - | - | - | C | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||
| Other - Reserve #2 | C | - | - | C | - | - | - | - | C | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||
| Fixed Asset Depreciation | NC | - | - | C | (14,290) | - | (14,290) | - | C | - | - | (14,290) | - | C | - | - | (14,290) | P | - | C | - | - | (14,290) | - | - | (5,002) | - | (5,002) | - | - | (1) | (5,002) | - | - | - | (5,002) | - | - | - | (5,002) | - | - | - | (5,002) | - | - | - | (5,002) | - | - | - | (5,002) | - | - | - | (5,002) | |||||||||||||
| Organizational Costs | NC | - | - | C | 42,000 | - | 42,000 | - | C | - | - | 42,000 | - | C | - | - | 42,000 | P | - | C | - | - | 42,000 | - | - | 14,700 | - | 14,700 | - | - | - | 14,700 | - | - | - | 14,700 | - | - | - | 14,700 | - | - | 14,700 | - | - | - | 14,700 | - | - | - | 14,700 | - | - | - | 14,700 | - | |||||||||||||
| Net Operating Loss | C | - | - | C | 260,457 | - | 260,457 | - | C | - | - | 260,457 | - | C | - | - | 260,457 | - | C | - | - | 260,457 | - | - | 91,160 | - | 91,160 | - | - | - | 91,160 | - | - | - | 91,160 | - | - | - | 91,160 | 91,160 | - | - | - | 91,160 | - | - | - | 91,160 | - | - | - | 91,160 | - | - | - | ||||||||||||||
| Other - Adj. | NC | - | - | C | - | - | - | - | - | - | - | - | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||
| Other - Reserve #3 | NC | - | - | - | - | - | - | - | - | - | - | - | - | - | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||
| State Taxes | NC | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||
| Subtotal | - | - | 290,167 | - | 290,167 | - | 2,400 | - | 292,567 | - | - | - | 292,567 | - | - | - | 292,567 | - | - | 101,558 | - | 101,558 | - | 840 | (1) | 102,398 | - | - | - | 102,398 | - | - | - | 102,398 | |||||||||||||||||||||||||||||||||||
| AMT Tax Credit | C | - | - | - | - | - | - | C | - | - | - | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||||||
| R&E Tax Credit | - | - | F | 12,800 | - | 12,800 | - | F | - | 12,800 | - | F | (12,800) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||||||||||||
| Federal Tax after Credits | - | - | 114,358 | - | 114,358 | - | 840 | (1) | 115,198 | - | (12,800) | - | 102,398 | - | - | - | 102,398 | 92,700 | - | 14,700 | (5,002) | 92,700 | - | 14,700 | (5,002) | 92,700 | - | 14,700 | (5,002) | 92,700 | - | 14,700 | (5,002) | ||||||||||||||||||||||||||||||||||||
| Less VA | - | - | (114,358) | - | (114,358) | - | - | (114,358) | - | - | (114,358) | - | - | (114,358) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Federal Tax after VA | - | - | - | - | - | - | 840 | (1) | 840 | - | (12,800) | - | (11,960) | - | - | - | (11,960) | 92,700 | 9,698 | 92,700 | 9,698 | 92,700 | 9,698 | 92,700 | 9,698 | ||||||||||||||||||||||||||||||||||||||||||||
| State Tax after VA | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | TA | TA | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Tax after VA | - | - | - | - | - | - | 840 | (1) | 840 | - | (12,800) | - | (11,960) | - | - | - | (11,960) | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| TA | TA | TA | TA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| State BOY | State EOY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2009 GROSS | 2010 GROSS | 2011 GROSS | 2012 GROSS | 2009 Tax Effected | 2010 Tax Effected | 2011 Tax Effected | 2012 Tax Effected | Tax effected at FYE 12/11 | Tax effected at FYE 12/12 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| BOY | PY | CY Activity | EOY | PY | CY Activity | EOY | PY | CY Activity | EOY | 2011 | CY Activity | EOY | BOY | PY | CY Activity | Rate Adj. / | EOY | PY | CY Activity | Rate Adj. / | EOY | PY | CY Activity | Rate Adj. / | EOY | 2011 | CY Activity | Rate Adj. / | EOY | Current | Non-Current | Current | Non-Current | ||||||||||||||||||||||||||||||||||||
| 1/1/09 | True-up | 2009 | Other Adj. | 12/31/09 | True-up | 2010 | Other Adj. | 12/31/10 | True-up | 2011 | Other Adj. | 12/31/11 | True-up | 2012 | Other Adj. | 12/31/12 | 1/1/09 | True-up | 2009 | Other | 12/31/09 | True-up | 2010 | Other | 12/31/10 | True-up | 2011 | Other | 12/31/11 | True-up | 2012 | Other | 12/31/12 | Asset | Liability | Asset | Liability | Asset | Liability | Asset | Liability | ||||||||||||||||||||||||||||
| STATE | 0% | 0% | 0% | 0% | 0% | 0% | 0.0% | 0% | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Other - Reserve #1 | C | - | - | C | - | - | - | - | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||
| 263A Capitalization | C | - | - | C | 2,000 | - | 2,000 | - | C | 2,400 | - | 4,400 | - | C | - | - | 4,400 | P | - | C | - | - | 4,400 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||
| Inventory Reserve | C | - | - | C | - | - | - | - | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||
| Non-Qual Stock Option Comp | NC | - | - | C | - | - | - | - | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||
| Other - Reserve #2 | C | - | - | C | - | - | - | - | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||
| Fixed Asset Depreciation | NC | - | - | C | (14,290) | - | (14,290) | - | C | - | - | (14,290) | - | C | - | - | (14,290) | P | - | C | - | - | (14,290) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||
| Organizational Costs | NC | - | - | C | 42,000 | - | 42,000 | - | C | - | - | 42,000 | - | C | - | - | 42,000 | P | - | C | - | - | 42,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||
| Net Operating Loss | C | - | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||
| Other - Adj. | NC | - | - | C | - | - | - | - | - | - | - | - | C | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||
| Other - Reserve #3 | NC | - | - | - | - | - | - | - | - | - | - | - | - | - | P | - | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||
| Subtotal | - | - | 29,710 | - | 29,710 | - | 2,400 | - | 32,110 | - | - | - | 32,110 | - | - | - | 32,110 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||
| State Tax Credits | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| State Tax after Credits | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||
| Less VA | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| State Tax after VA | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| C | C | C | C |
&A
&Z&F Printed on: &D &T
TA - Tax Account Recon
| DELTA Corporation & Subsidiary | ||||||||||||||||||||||||||||
| Tax Account Rollforward Schedule | input | Final Exam Question #4 | ||||||||||||||||||||||||||
| link | Task - Complete the below Tax Account Rollforward schedule. [Hint: complete the links in the blue cells]. | |||||||||||||||||||||||||||
| Dr (Cr) | [Add'l hint: confirm the accuracy of your calculations by comparing to the Delta Trial Balance amounts at tab F]. | |||||||||||||||||||||||||||
| Taxes (Payable)/Receivable (B/S) | FIN 48 (Payable) / Receivable (B/S) | Deferred Tax (B/S) | Tax Expense (I/S) | |||||||||||||||||||||||||
| Federal | State | Foreign | Total | Federal | State | Interest | Penalty | Total | Current | Non-Current | Valuation Allowance | Total | APIC | CTA | Current | Deferred | Total | Cash | cross-foot check | |||||||||
| Balance at 1/1/2009 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||
| 2009 Estimated Taxes Paid | - | - | - | - | - | - | - | |||||||||||||||||||||
| assume all deferreds are "current" for 2009 for simplicity | ||||||||||||||||||||||||||||
| 2009 Tax Provision | C | - | - | - | - | - | - | - | - | - | 114,358 | - | (114,358) | - | - | - | - | - | - | F | - | |||||||
| Balance at 12/31/2009 | - | - | - | - | - | - | - | - | 114,358 | - | (114,358) | - | F | |||||||||||||||
| 2010 Estimated Taxes Paid | 115,000 | - | - | 115,000 | (115,000) | - | ||||||||||||||||||||||
| 2009 Prov-Return True-up | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||
| assume all deferreds are "current" for 2010 for simplicity | ||||||||||||||||||||||||||||
| 2010 Tax Provision | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | F | - | ||||||||||
| Balance at 12/31/2010 | 115,000 | - | - | 115,000 | F | - | - | - | - | - | 114,358 | - | (114,358) | - | F | |||||||||||||
| 2011 Estimated Taxes Paid | 95,000 | 40,000 | - | 135,000 | (135,000) | - | ||||||||||||||||||||||
| 2010 Prov-Return True-up | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||
| assume all deferreds are "current" for 2011 for simplicity | ||||||||||||||||||||||||||||
| 2011 Tax Provision | C | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | F | - | ||||||||||
| Balance at 12/31/2011 | 210,000 | 40,000 | - | 250,000 | F | - | - | - | - | - | 114,358 | - | (114,358) | - | F | |||||||||||||
| 2012 Estimated Taxes Paid | 110,000 | 30,000 | - | 140,000 | (140,000) | - | ||||||||||||||||||||||
| Tax Paid w/ 2011 TR | - | - | - | - | - | - | ||||||||||||||||||||||
| 2011 Prov-Return True-up | P | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||
| 2012 Tax Provision - Delta only | C | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||
| Reclass - Current / Non-Current | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||
| D | ||||||||||||||||||||||||||||
| Balance at 12/31/2012 - Delta Only | 320,000 | 70,000 | - | 390,000 | F | - | - | - | - | - | 114,358 | - | (114,358) | - | F | for CY year | - | - | - | F | ||||||||
| 2012 Tax Provision - Foxtrot only | FC | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||
| Balance at 12/31/2012 - Consolidated | 320,000 | 70,000 | - | 390,000 | FS | - | - | - | - | - | FS | 114,358 | - | (114,358) | - | FS | for CY year | - | - | - | FS | |||||||
| "Proof" of ending Taxes Payable Balance | ||||||||||||||||||||||||||||
| Taxes paid towards 2012 | 320,000 | 70,000 | - | 390,000 | ||||||||||||||||||||||||
| 2012 Tax Provision | - | - | - | - | ||||||||||||||||||||||||
| Estimated Balance due w/ 12/31/2012 TRs | 320,000 | 70,000 | - | 390,000 | ||||||||||||||||||||||||
&A
&Z&F Printed on: &D &T
R - Rate Reconciliation
| DELTA Corporation & Subsidiary | input | |||||||||||||||||||||||||||
| Rate Reconciliation | Final Exam Question #5 | link | ||||||||||||||||||||||||||
| Task - Complete the Rate Reconciliation for each of the years 2010 to 2012. | ||||||||||||||||||||||||||||
| Dr (Cr) | ||||||||||||||||||||||||||||
| 2009 | 2010 | 2011 | 2012 | |||||||||||||||||||||||||
| Gross amt | Tax Effected $ | Tax Effected % | Gross amt | Tax Effected $ | Tax Effected % | Gross amt | Tax Effected $ | Tax Effected % | Gross amt | Tax Effected $ | Tax Effected % | |||||||||||||||||
| 35% | 35% | 35% | 35% | |||||||||||||||||||||||||
| Tax Expense / (Benefit) at Statutory Rate | C | (301,000) | (105,350) | 35.00% | C | 250,000 | 87,500 | 35.00% | C | 1,162,000 | 406,700 | 35.00% | C / FC | 3,190,000 | 1,116,500 | 35.00% | ||||||||||||
| State Tax (gross - including rate adj.) b4 True-up | C | - | C | - | C | C | ||||||||||||||||||||||
| State Tax (fed benefit) | - | - | - | - | ||||||||||||||||||||||||
| State Tax (net of fed benefit) | - | 0.00% | - | 0.00% | - | 0.00% | FS | - | 0.00% | FS | ||||||||||||||||||
| Foreign Rate Differential | - | 0.00% | - | 0.00% | - | 0.00% | FC | 0.00% | FS | |||||||||||||||||||
| Permanent Differences (domestic only) - | ||||||||||||||||||||||||||||
| Non deductible penalties | C | - | - | 0.00% | C | - | 0.00% | C | - | 0.00% | C | - | 0.00% | |||||||||||||||
| Meals & entertainment | C | 10,000 | 3,500 | -1.16% | C | - | 0.00% | C | - | 0.00% | C | - | 0.00% | |||||||||||||||
| Stock Comp Expense (ISO) | C | 833 | 292 | -0.10% | C | - | 0.00% | C | - | 0.00% | FS | C | - | 0.00% | FS | |||||||||||||
| Other - Perm #1 | C | - | - | 0.00% | C | - | 0.00% | C | - | 0.00% | C | - | 0.00% | |||||||||||||||
| Other - Perm #2 | C | - | - | 0.00% | C | - | 0.00% | C | - | 0.00% | C | - | 0.00% | |||||||||||||||
| R&E Tax Credit | C | (12,800) | 4.25% | C | 0.00% | F | 0.00% | F | 0.00% | |||||||||||||||||||
| Valuation Allowance Adj. | C | 114,358 | -37.99% | C | 0.00% | - | 0.00% | - | 0.00% | |||||||||||||||||||
| Prior Year True-up (Fed & State) | - | 0.00% | - | 0.00% | - | 0.00% | FS | P | 0.00% | FS | ||||||||||||||||||
| FIN 48 Accrual (fed tax only, interest & penalties) | - | 0.00% | - | 0.00% | - | 0.00% | C | 0.00% | ||||||||||||||||||||
| Total Tax Expense / (Benefit) / ETR | C | - | 0.00% | C | 87,500 | 35.00% | C | 406,700 | 35.00% | C | 1,116,500 | 35.00% | ||||||||||||||||
&A
&Z&F Printed on: &D &T
FS - Financial Stmt Disclosure
| DELTA Corporation & Subsidiary | ||||
| Income Tax Footnote Disclosure | Final Exam Question #7 | |||
| Year Ended December 31, 2012 | ||||
| Task - Prepare the Financial Statement Disclosures for 2012 (with 2011 comparison) | ||||
| complete the below templates and add any add'l disclosures you deem necessary | ||||
| The provision for income taxes consists of the following: | ||||
| Year Ended 12/31/11 | Year Ended 12/31/12 | |||
| Current: | ||||
| C | ||||
| C | ||||
| - | FC | |||
| Total Current | - | - | ||
| Deferred: | ||||
| C | ||||
| C | ||||
| - | FC | |||
| Total Deferred | - | - | ||
| Total | - | - | ||
| The components of earnings before income taxes, by taxing jurisdiction, were as follows for the years ended December 31: | ||||
| Year Ended 12/31/11 | Year Ended 12/31/12 | |||
| U.S. | C | C | ||
| Foreign | - | FC | ||
| Total | - | - | ||
| The provision for income taxes for the years ended December 31, 2011 and 2012 differ from the amount computed by applying the statutory federal corporate income tax rate of 35% to earnings before income taxes as a result of the following: | ||||
| Year Ended 12/31/11 | Year Ended 12/31/12 | |||
| Statutory Rate | R | 35.00% | 35.00% | |
| State Income Taxes (net of fed benefit) | R | |||
| Foreign Tax Differential | R | |||
| Permanent Differences | R | |||
| Credits & Other, net | R | |||
| Effective Tax Rate | 35.00% | 35.00% | ||
| The tax effects of temporary differences for the years ended December 31 that give rise to significant portions of the deferred tax assets and deferred tax liabilities are provided below: | ||||
| Year Ended 12/31/11 | Year Ended 12/31/12 | |||
| Deferred Tax Assets: | ||||
| D | ||||
| D | ||||
| Stock Compensation | D | |||
| Tax Credits | D | |||
| D | ||||
| Total | - | - | ||
| Valuation Allowance | - | - | ||
| Total Deferred Tax Assets (net of VA) | - | - | ||
| Deferred Tax Liabilities: | ||||
| Property, Plant & Equipment | D | |||
| D | ||||
| D | ||||
| Total | - | - | ||
| Net Deferred Tax Assets | - | - | ||
| The net deferred income tax assets are recorded on the Balance Sheet at December 31 as follows: | ||||
| Year Ended 12/31/11 | Year Ended 12/31/12 | |||
| Current asset / (liability) | D | |||
| Noncurrent asset / (liability) | D | |||
| Total | - | - | ||
&A
&Z&F Printed on: &D &T