what is the pro forma Cash flow statement?

Parent Inc. is contemplating a tender offer to acquire 80% of Subsidiary Corporation's common stock. Subsidiary's shares are currently quoted on the New York Stock Exchange at $85 per share. In order to have a reasonable chance of the tender offer attracting 80% of subsidiary's stock, Parent believes it will have to offer at least $105 per share. If the tender offer is made and is successful, the purchase will be consummated on January 1, 2013. A typical part of the planning of a proposed business combination is the preparation of projected or pro forma consolidated financial statements. As a member of Parent's accounting group, you have been asked to prepare the pro forma 2013 consolidated financial statements for Parent and Subsidiary assuming that 80% of subsidiary's stock is acquired at a price of $105 per share. To support your computations, Martha Franklin, the chairperson of Parent's acquisitions committee, has provided you with the projected 2013 financial statements for Subsidiary. (The projected financial statements for Subsidiary and several other companies were prepared earlier for the acquisition committee's use in targeting a company for acquisition.) The projected financial statements for Subsidiary for 2013 and Parent's actual 2012 financial statements are presented in Table 1 Table 1 Parent Inc. Actual Financial Statements for 2016 and Subsidiary Corporation Projected Financial Staternents for 2017 Assumptions Sales will increase by 10% in 2013 2.All sales will be on account. nts receivable will be 5% lower on December 31, 2013, than on December 31, 2012. 3-Accou 4,Cost of goods sold will increase by 9% in 2013. 5.All purchases of merchandise will be on account. 6.Accounts payable are expected to be $50,500 on December 31, 2013 ZInventory will be 3% higher on December 31, 2013, than on December 31, 2012. 8.Straight-line depreciation is used for all fixed assets ets will be disposed of during 2013. The annual depreciation on existing assets is $40,000 per year 10 Equipment will be purchased on January 1, 2013, for $48,000 cash. The equipment will have an estimated life of 10 years, with no salvage value. 11.Operating expenses, other than depreciation, will increase by 14% in 2013. 12 All operating expenses, other than depreciation, will be paid in cash. 13.Parent's inf Microsoft Excel ". and taxes are paid in cash in four equal payments. Payments will be eptember, and Decemben For simplicity, assume taxable income equals made on the !!Operating expenses, other than depreciation, will increase by 14% in 2013. 12.All operating expenses, other than depreciation, will be paid in cash. 13-Parent's income tax rate is 40%, and taxes are paid in cash in four equal payments. Payments will be made on the 15th of April, June, September, and December. For simplicity, assume taxable income equals financial reporting income before taxes. 14.Parent will continue the $2.50 per share annual cash dividend on its common stock. 15.f the tender offer is successful, Parent will finance the acquisition by issuing nonconvertible bonds at par on January 1, 2013. The bonds would first pay interest on July 1, 2013, and would pay interest semiannually thereafter each January 1 and July 1 until maturity on January 1, 2023 $170,000 of 6% acquisition will be accounted for as a purchase and Parent will account for the investment using the equity method. Although most of the legal work related to the acquisition will be handled by Parent's staff attorney, direct costs to prepare and process the tender offer will total $2.000 and will be paid in cash by Parent in 2013. As of January 1, 2013, all of Subsidiary's assets and liabilities are fairly valued except for machinery with a book value of $8,000, an estimated fair value of $9,.500, and a 5-year remaining useful ife. Assume that straight-line depreciation is used to amortize any revaluation increment. No transactions between these companies occurred prior to 2013. Regardless of whether they combine, Parent plans to buy $50,000 of merchandise from Subsidiary in 2013 and will have $3,600 of these purchases remaining in inventory on December 31, 2013. In addition, Subsidiary is expected to buy $2,400 of merchandise from Parent in 2013 and to have $495 of these purchases in inventory on December 31, 2013, Parent and Subsidiary price their products to yield a 65% and 80% markup on cost, respectively Parent intends to use three financial yardsticks to determine the financial attractiveness of the combination. First, Parent wishes to acquire Subsidiary Corporation only if 2013 consolidated earnings per share will be at least as high as the earnings per share Parent would report if no combination takes place. Second, Parent will consider the proposed combination unattractive if it will cause the consolidated c fall below two to one. Third, return on average stockholders' equity must remain above 20% for the combined entity If the financial yardsticks described above and the nonfinancial aspects of the combination are appealing then the tender offer will be made. On the other hand, if these objectives are not met, the acquisition will either be restructured or abandoned. Assumptions - Financial Statements Parent 2016 Subsidiary Actual 2017 Projected Sales $800,000 $100,000 COGS $(485,000) $(55,000) Operating expense $(219,000) $(10,000) Income before taxes $96,000 $35,000 Income tax expense $(38,400) $(14,000) $57600 $21000 Net income $21,000 Retained earnings $23,000 $21,000 Add Net Income $57,600 $21,000 Retained earnings $23,000 $21,000 Add Net Income $57,600 $21,000 Deduct Dividends $(38,000) $(7,000) Retained Earnings December 31 $42,600 $28,500 Cash $36,200 $19,500 Accounts receivable $39,000 $13,000 Inventory $26,000 $12,000 PPE $673,000 $213,000 Accumulated Depreciation $(490,000) $(28,000) Total Assets $284,200 $229,500 Accounts Payable $44,600 $21,000 Common Stock* $150.00o 190.000 Cash $36,200 $19,500 Accounts receivable $39,000 $13,000 Inventory $26,000 $12,000 $673,000 PPE $213,000 Accumulated Depreciation (490,000) $(28,000) Total Assets $284,200 $229,500 Accounts Payable $21,000 $44,600 Common Stock $190,000 $150,000 $7000 Paid-in Capital in Excess of Par 30,000 $42,600 Retained Earnings $28,500 Total Liabilities and Equities $284,200 $229,500 "Parent $12.50 Par value Subsidiary $75 Par value