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.

Calculate your essay price
(550 words)

Approximate price: $22

How it Works


It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.


Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.


After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.


Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!