I need the Cash Flow and Journal Entries for the following question:

Corporate Takeover

Situation

Parent, Inc. is contemplating a tender offer to acquire 80 percent of Subsidiary Corporation's common stock. Subsidiary's shares are currently quoted on the New York Stock Exchange at $100 per share. Parent is going to offer $105 per share to execute the tender offer. 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 percent 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.

Assumptions

Ms. Franklin has asked you to use the following assumptions to project Parent's 2013 financial statements:

Sales will increase by 10 percent in 2013 and all sales will be on account.

Accounts receivable will be 5 percent lower on December 31, 2013, than on December 31, 2012.

Cost of goods sold will increase by 9 percent in 2013.

All purchases of merchandise will be on account.

Accounts payable are expected to be $50,500 on December 31, 2013.

Inventory will be 3 percent higher on December 31, 2013, than on December 31, 2012.

Straight-line depreciation is used for all fixed assets.

No fixed assets will be disposed of during 2013. The annual depreciation expense on existing assets is $40,000 per year.

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.

Other operating expenses (depreciation is discussed above) will increase by 14 percent in 2013 and all will be paid in cash.

Parent's income tax rate is 40 percent 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.

Parent will continue the $2.50 per share annual cash dividend on its common stock.

If the tender offer is successful, Parent will finance the acquisition by issuing $170,000 of 6 percent non-convertible bonds at par on January

1, 2013. The bonds would first pay interest on July 1, 2013, and would pay interest semi-annually thereafter each January 1 and July 1 until

maturity on January 1, 2023.

The acquisition will be properly accounted for as an acquisition (SFAS 141R) 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.

Additional Information

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 life. 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 percent and 80 percent markup on cost, respectively. Parent intends to use three financial yardsticks to determine the financial attractiveness of the acquisition. 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

acquisition takes place. Second, Parent will consider the proposed acquisition unattractive if it will cause the consolidated current ratio to fall

below 2 to 1. Third, return on average stockholders' equity must remain above 20 percent for the consolidated entity.

If the financial yardsticks described above and the non-financial aspects of the acquisition 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.

Course Project Team

The project is to be done in teams to be assigned by the instructor during week 1 of the course. The team will work together in private

threaded discussion assigned by the instructor. The private threads are located in Letter designated (A. B. ) areas included in the Team

Caf link just below Week 8. There are three threads in each letter group that correspond to the three required milestones. Milestone 1 - required 1. Milestone 2 - Required 2. & 3. Milestone 3 - Required 4. & 5. The team will choose a leader to be responsible for posting their document(s) to that persons Dropbox for the appropriate week. In addition to the private threaded discussion areas, teams have private Doc Sharing to facilitate project activities.

Required

1. Forecast the separate financial statements of Parent, Inc. Using Ms. Franklin's assumptions and Parent's 2012 financial statements, prepare pro forma 2013 financial statements for Parent, Inc., assuming that the acquisition is not attempted. Support your statements with appropriate work papers and journal entries. Pro forma financial statements include Statement of Operation; Statement of Retained Earnings, Balance Sheet and Cash Flow Statement.

2. Adjust the separate financial statements of Parent, Inc. to reflect the proposed acquisition. Adjust Parent's pro forma 2013 financial statements prepared in #1 to reflect the proposed acquisition (i.e., adjust Parent's forecasted financial statements for bond issuance, stock purchase, income from subsidiary, etc.). Support your statements with appropriate work papers and journal entries. Pro forma financial statements include Statement of Operation; Statement of Retained Earnings, Balance Sheet and Cash Flow Statement.

3. Prepare pro forma consolidation worksheet. Prepare a pro forma consolidation worksheet for Parent, Inc. and it's proposed subsidiary as of December 31, 2013. Use the adjusted pro forma 2013 financial statements of Parent, Inc. prepared in #2 and the projected 20131 financial statements of Subsidiary Corporation in table 1. Show all consolidation adjusting entries including non controlling interest (NCI) entries.

4. Perform ratio analysis. Compute earnings per share for (1) the separate financial statements of Parent, Inc. prepared in #1 and (2) the consolidated financial statements contained in the pro forma consolidation worksheet prepared in #3. Also, calculate current ratio and return on average stockholders' equity for the separate company (parent) and consolidated financial statements.

5. Write a memorandum to Ms. Franklin summarizing the results of your analysis, including a summary of the financial ratios you computed and your recommendation. Attach copies of both sets of pro forma financial statements of Parent, Inc. and the pro forma consolidation worksheet.