PLEASE help me fill in the empty green boxes! please give the formula to calculate them.

H45 A x fx A B D E F G H 1 J K L 1 2 3 4 31 32 33 34 Acquiring Acquired Merger Passive Interest Transaction Type Acquisition Type Accounting Method Company (Legal Entity) Non-Controlling Interest Equity Minority Controlling Interest Consolidated Subsidiary Cost Merger New A B A A B A B 10,000 10,000 15% 10,000 70% 10,000 30% NA 30% 10% 70% 40% 5% z Pre-transaction Market Value B Percent of B Acquired Acquisition Premium Percent Merger Conversion Ratio Consideration Percent Cash Cash Stock Leverage (in dollars) NA 1,575 3,300 50% 1,650 1,650 9,800 50% 4,900 4,900 NA NA 1,575 NA 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 NA Cash Flow Statement Year of Transaction Cash Acquisitions Issue (Retire) Debt ( Issue (Repurchase) Equity Increase in Excess Cash (1,575) 75 (1,650) 150 (4,900) 3,400 (1,500) (1,500) (1,500) 5,000 3,000 8,000 5,000 3,000 3,000 5,000 2,250 8,000 6,300 1,000 1,500 1,000 2,500 1,575 1,000 1,000 Balance Sheet End of Year Tangible Invested Capital Intangible Assets Excess Cash Unconsolidated Equity Investments Debt Equity Non Controlling Interest (NCI) 1,000 5,500 4,900 500 3,500 1,500 9,000 1,050 1,150 7,150 1,075 5,500 500 3,500 500 3,500 10,400 1,050 H45 X fx B D E F G H I K J ---- 9,350 Common Equity 5,500 3,500 9,000 5,500 7,150 3,500 3,500 2,000 700 2,700 2,000 2,000 700 2,700 700 25 25 50 (58) 25 (195) 25 25 30 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 Income Statement Next Year EBIT Synergies Interest Income (Expense) Dividends Received Net Income Affiliates Pretax Income Tax (30% rate) Net Income Net Income Attributable to NCI Net Income Attributable to Common 2.025 725 218 508 2,750 825 1,925 2,055 617 152 2,095 628 608 1,418 725 218 508 152 877 263 614 1,439 2,505 752 1,754 152 1,601 1,466 152 1,418 508 1,925 1,418 1,466 355 614 508 Cash Flow Statement Next Year Net Income Dividends Paid (40% Payout) Dividends from Affiliates Increase in Excess Cash 1,418 (567) 508 (203) 1925 ( (770) 1,418 (567) 1,466 (587) 43 1,754 (641) 614 (246) (142) 79 851 305 1,155 851 922 365 1,113 368 1,400 1,000 1,000 800 800 1,000 1,000 1,000 1,000 1,000 1,000 80 81 82 83 84 85 86 87 88 Number of Shares Original Change Share Price EPS Return on Equity 1,083 1,000 83 20 1.35 21% 1,245 1,000 245 20 1.29 17% 1,400 20 1.38 21% 20 1.42 26% 10 0.63 15% 20 1.42 26% 10 0.36 10% 10 0.61 18% H45 A x fx A B D E F G H 1 J K L 1 2 3 4 31 32 33 34 Acquiring Acquired Merger Passive Interest Transaction Type Acquisition Type Accounting Method Company (Legal Entity) Non-Controlling Interest Equity Minority Controlling Interest Consolidated Subsidiary Cost Merger New A B A A B A B 10,000 10,000 15% 10,000 70% 10,000 30% NA 30% 10% 70% 40% 5% z Pre-transaction Market Value B Percent of B Acquired Acquisition Premium Percent Merger Conversion Ratio Consideration Percent Cash Cash Stock Leverage (in dollars) NA 1,575 3,300 50% 1,650 1,650 9,800 50% 4,900 4,900 NA NA 1,575 NA 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 NA Cash Flow Statement Year of Transaction Cash Acquisitions Issue (Retire) Debt ( Issue (Repurchase) Equity Increase in Excess Cash (1,575) 75 (1,650) 150 (4,900) 3,400 (1,500) (1,500) (1,500) 5,000 3,000 8,000 5,000 3,000 3,000 5,000 2,250 8,000 6,300 1,000 1,500 1,000 2,500 1,575 1,000 1,000 Balance Sheet End of Year Tangible Invested Capital Intangible Assets Excess Cash Unconsolidated Equity Investments Debt Equity Non Controlling Interest (NCI) 1,000 5,500 4,900 500 3,500 1,500 9,000 1,050 1,150 7,150 1,075 5,500 500 3,500 500 3,500 10,400 1,050 H45 X fx B D E F G H I K J ---- 9,350 Common Equity 5,500 3,500 9,000 5,500 7,150 3,500 3,500 2,000 700 2,700 2,000 2,000 700 2,700 700 25 25 50 (58) 25 (195) 25 25 30 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 Income Statement Next Year EBIT Synergies Interest Income (Expense) Dividends Received Net Income Affiliates Pretax Income Tax (30% rate) Net Income Net Income Attributable to NCI Net Income Attributable to Common 2.025 725 218 508 2,750 825 1,925 2,055 617 152 2,095 628 608 1,418 725 218 508 152 877 263 614 1,439 2,505 752 1,754 152 1,601 1,466 152 1,418 508 1,925 1,418 1,466 355 614 508 Cash Flow Statement Next Year Net Income Dividends Paid (40% Payout) Dividends from Affiliates Increase in Excess Cash 1,418 (567) 508 (203) 1925 ( (770) 1,418 (567) 1,466 (587) 43 1,754 (641) 614 (246) (142) 79 851 305 1,155 851 922 365 1,113 368 1,400 1,000 1,000 800 800 1,000 1,000 1,000 1,000 1,000 1,000 80 81 82 83 84 85 86 87 88 Number of Shares Original Change Share Price EPS Return on Equity 1,083 1,000 83 20 1.35 21% 1,245 1,000 245 20 1.29 17% 1,400 20 1.38 21% 20 1.42 26% 10 0.63 15% 20 1.42 26% 10 0.36 10% 10 0.61 18%