ParentCo and SubCo are calendar year corporations that keep their respective books on the accrual basis. The companies have taxable income of $200,000 and $250,000, respectively, for tax year 2013 (before consolidation adjustments, elimination entries and charitable deductions). The following transactions are included:

1. Land was sold by ParentCo to a third party for $80,000. The land was acquired from SubCo in 2011. SubCo acquired the land in 2008 for $48,000.
2. ParentCo’s taxable income includes a $12,000 dividend SubCo paid to ParentCo.
3. ParentCo sold inventory to SubCo in 2013 for a realized $100,000 profit. The intercompany profit on the unsold inventory is $8,000. ParentCo sold inventory to SubCo in 2012 for which deferred profit at the beginning of the year is $5,000. SubCo sold this inventory to an external party. ParentCo sold additional inventory to SubCo in 2013 for a realized $100,000 profit. The intercompany profit on the unsold inventory is $8,000.
4. ParentCo and SubCo contribute $17,000 and $11,000 to charity, respectively.

Directions: Calculate the consolidated taxable income and consolidated tax liability of ParentCo and SubCo for 2013.  Than calculate the basis of ParentCo’s stock at the end of 2013, assuming that it was $1,400,000 at the beginning of the year.

Requirements: Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so that your thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions. Submit a single Excel file for grading. Review the grading rubric, which can be accessed from the Module 8 folder, to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.

ParentCo and SubCo are calendar year corporations that keep their respective books on the accrual basis. The companies have taxable income of $200,000 and $250,000, respectively, for tax year 2013 (before consolidation adjustments, elimination entries and charitable deductions). The following transactions are included:

1. Land was sold by ParentCo to a third party for $80,000. The land was acquired from SubCo in 2011. SubCo acquired the land in 2008 for $48,000.
2. ParentCo’s taxable income includes a $12,000 dividend SubCo paid to ParentCo.
3. ParentCo sold inventory to SubCo in 2013 for a realized $100,000 profit. The intercompany profit on the unsold inventory is $8,000. ParentCo sold inventory to SubCo in 2012 for which deferred profit at the beginning of the year is $5,000. SubCo sold this inventory to an external party. ParentCo sold additional inventory to SubCo in 2013 for a realized $100,000 profit. The intercompany profit on the unsold inventory is $8,000.
4. ParentCo and SubCo contribute $17,000 and $11,000 to charity, respectively.

Directions: Calculate the consolidated taxable income and consolidated tax liability of ParentCo and SubCo for 2013.  Than calculate the basis of ParentCo’s stock at the end of 2013, assuming that it was $1,400,000 at the beginning of the year.

Requirements: Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so that your thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions. Submit a single Excel file for grading. Review the grading rubric, which can be accessed from the Module 8 folder, to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.