Calculate the consolidated taxable income and consolidated tax liability of ParentCo and SubCo for 2013. Then 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.

[Pin It]

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:

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.
ParentCo’s taxable income includes a \$12,000 dividend SubCo paid to ParentCo.
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.
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. Then 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.

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]