Solve for green cells

Acquiring Acquired Full Cash Acquisition Type Accouning Method Company (Legal Entity) Merger Merger Consolidated B New Acquisition Valuation 18000 Percent Acquired NA 100% Acquisition Payment NA 18000 1,000 2,000 75 50 Income Statement EBIT Interest Income (Expense) Dividends Reveived Net Income Affiliates Pretax Income Tax (30% rate) Net Income Net Income Attributable to Net Income Attributable to 2,075 623 1,453 1,0501 315 735 1,453 735 5,000 5,000 1,500 1,000 Balance Sheet Tangible CIO Intangible Assets Excess Cash Unconsolidated Equity Debt Equity Non Controlling Interest (NCI) Common Equity 6,500 6,000 6,500 6,000 1,453 735 (581) (294) Cash Flow Statement Net Income Change CIO Dividends Paid (40% Payout) Cash Acquisitions Dividends from Affiliates Issue (Retire) Debt Increase in Excess Cash NA 872 441 Acquiring Acquired Full Cash Acquisition Type Accouning Method Company (Legal Entity) Merger Merger Consolidated B New Acquisition Valuation 18000 Percent Acquired NA 100% Acquisition Payment NA 18000 1,000 2,000 75 50 Income Statement EBIT Interest Income (Expense) Dividends Reveived Net Income Affiliates Pretax Income Tax (30% rate) Net Income Net Income Attributable to Net Income Attributable to 2,075 623 1,453 1,0501 315 735 1,453 735 5,000 5,000 1,500 1,000 Balance Sheet Tangible CIO Intangible Assets Excess Cash Unconsolidated Equity Debt Equity Non Controlling Interest (NCI) Common Equity 6,500 6,000 6,500 6,000 1,453 735 (581) (294) Cash Flow Statement Net Income Change CIO Dividends Paid (40% Payout) Cash Acquisitions Dividends from Affiliates Issue (Retire) Debt Increase in Excess Cash NA 872 441