solved additional information to help you with this assignment:Intercompany sales: For

additional information to help you with this assignment:Intercompany sales: For purposes of the intercompany sales between the two entities. Assuming T’s gross profit ratio for its sales to Flying Gator is the same 44% ($550,000 ÷ $1,250,000) gross profit ratio for all its sales, the gross receipts and cost of goods sold associated with the deferred gross profits from the intercompany inventory sales are as follows:Deferred from preceding year to current year:Gross profit = $40,700; gross receipts ÷ 0.44 = $92,500Cost of goods sold = $92,500 – $40,700 = $51,800Deferred from current year to next year:Gross profit = $45,100; gross receipts ÷ 0.44 = $102,500Cost of goods sold = $102,500 – $45,100 = $57,400Current-year net adjustmentsGross receipts: $92,500 – $102,500 = $(10,000)Cost of goods sold: $(51,800) – $(57,400) = $5,600. The two amounts are negativebecause cost of goods sold reduces gross profit.Dividend Exclusion: Exclusion of dividend T pays to Flying Gator. Adjustment is needed because the dividends are included in Flying Gator’s separate taxable income calculation.Matching rule with respect to intercompany interest: Under the matching rule, Flying Gator’s interest income is matched with T’s interestexpense. The group includes T’s interest expense on Line 18, and it includes Flying Gator’sinterest income on Line 5.Capital gain income: ($3,000) NSTCL + $6,000 NLTCG + $20,000 net Sec. 1231 gain = $23,000 T’s capitalgain net income.Loss on intercompany transaction: The $9,000 loss on Flying Gator’s land sale to T is deferred under the intercompanytransaction rules.There is Charitable contribution deduction limitation that must be calculated:Dividends-received deduction and intercompany dividends You must calculate the dividends received deduction. A dividends-receiveddeduction is not allowed for the $100,000 dividend T pays to Flying Gator because it isexcluded from consolidated income.Anwer the qeution by form 1120 and excel worksheet