Sun and Moon Company Proforma Financial Statements for 2024 S entry Common Stock - Sub Paid-In Capital in Excess of Par - Sub Retained Earnings, January 1 - Sub Investment in Sub Noncontrolling interest in Sub.1/1/24 A entry Property, Plant, \& Equipment Goodwill Investment in Sub I entry Equity in Subsidiary income Investment in Sub D entry Investment in Sub Dividends E entry Operating Expenses - depreciation Accumulated Depreciation TI entry Sales Cost of Goods Sold G entry Cost of Goods Sold Inventory Big Company 2024 Pro Forma Income Statement With Acquisition Sales Cost of Goods Sold Operating Expenses (49,200+450) Interest Expense Equity in Subsidiary income Income Before Taxes Income Tax Expense Net Income Big Company 2024 Projected with Acquisition 2024 Pro Forma Statement of Retained Earnings with Acquisition Retained Earnings, January 1 Add: Net Income Less: Dividends Retained Earnings, December 31 Big Company 2024 Pro Forma Balance Sheet with Acquisition Cash Accounts Receivable Inventory Property, Plant, \& Equipment Less: Accumulated Depreciation Investment in Subsiidiary Total Assets Accounts Payable Interest Payable Bonds Payable Common Stock Paid-In Capital in Excess of Par Retained Earnings Total Liabilities \& Equities Requirement 3 -Statements for Ratio Analysis Sun Inc. is contemplating a tender offer to acquire 80% of Moon Corporation's common stock. Moon's shares are currently quoted on the New York Stock Exchange at \$25 per share In order to have a reasonable chance of the tender offer attracting 80% of Moon's stock, Sun believes it will have to offer at least $30 per share. If the tender offer is made and is successful, the purchase will be consummated on January 1, 2024. Michael Jackson, the chairperson of Sun's acquisitions committee, has provided you with the projected 2024 financial statements for Sun Company without the proposed acquisition and the 2024 Projected Financial Statements of the Moon company in Table 1 If the tender offer is successful, Sun will finance the acquisition by issuing $36,000 of 6% nonconvertible bonds at par on January 1 , 2024. The bonds would first pay interest on July 1, 2024 and would pay interest semi annually thereafter each January 1 and July 1 This business combination will be recorded using acquisition method and Sun will account for the investment using the equity method. Although most of the legal work related to the acquisition will be handled by Sun's staff attorney, direct costs to prepare and process the tender offer will total \$750 and will be paid in cash by Sun in 2024. Additional Information As of January 1, 2024, all of Moon Company's assets and liabilities are fairly valued except for machinery with a book value of $5,000, an estimated fair value of $6,000, 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 2024. Regardless of whether they combine, Sun Company plans to buy $15,000 of merchandise from Moon Company in 2024 and will have $1,200 of these purchases remaining in inventory on December 31, 2024. In addition, Moon is expected to buy $900 of merchandise from Sun in 2024 and to have $150 of these purchases in inventory on December 31,2024 . Sun and Moon price their products to yield a 20 percent and 25 percent markup on cost, respectively. Sun Company intends to use three financial yardsticks to determine the financial attractiveness of the combination. First, Sun wishes to acquire Subsidiary Corporation Moon only if 2024 consolidated earnings per share will be at least as high as the earnings per share Sun would report if no combination takes place. Second, Sun will consider the proposed combination unattractive if it will cause the consolidated current ratio to 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 Required 1.Adjust the separate financial statements of Sun Company to reflect the proposed acquisition. Adjust the given Sun's pro forma 2024 financial statements to reflect the proposed acquisition (i.e., adjust Parent's forecasted financial statements - Statement of Operations, Statement of Retained Earnings and Balance Sheet) for bond issuance, stock purchase, income from subsidiary, etc.). Support your statements with appropriate work papers and journal entries. 2. Prepare pro forma consolidation worksheet. Prepare a pro forma consolidation worksheet for Sun Company and it's proposed subsidiary Moon Company as of December 31, 2024. Use the adjusted pro forma 2024 financial statements of Sun Company prepared in \#1 and the projected 2024 financial statements of Moon company in table 1 . Show all consolidation adjusting entries including non controlling interest (NCl) entries. 1. Perform ratio analysis. Compute earnings per share, Current Ratio and Return on Average Stockholders' Equity for (i) the 2024 projected financial statements of Sun Company without acquisition as given in the question and (ii) the consolidated financial statements contained in the pro forma consolidation worksheet prepared in requirement \#2 of Phase I. Requirement 4 -Ratio Analysis Big w/o Acq Pro Forma 2024 Earnings Per Share + Net Income + Weighted Average C/S Outstanding EPS Consolidated Statements 2024 $ $ 8,000 8,000 0.00 Big w/o Acq Pro Forma 2024 Consolidated Statements 2024 Current Ratio + Current Assets + Current Liabilities $ Current Ratio Big w/o Acq Pro Forma 2024 Return on Average Stockholders Equity + Net Income + Average Stockhollders' Equity (below) Return on Average Stockholders Equity Consolidated Statements 2024 $ $ $ \#DIV/O! \#DIV/O! Average Stockholders' Equity Beginning Of Year Common Stock Paid-in Capital in Excess of Par Retained Earnings Total End Of Year Common Stock Paid-in Capital in Excess of Par Retained Earnings Total Total beg. and ending Stockholder's Equity Average Stockhollders' Equity-Total b/e +2 $ \#DIV/O! $ $ $ $ Sun and Moon Company Proforma Financial Statements for 2024 S entry Common Stock - Sub Paid-In Capital in Excess of Par - Sub Retained Earnings, January 1 - Sub Investment in Sub Noncontrolling interest in Sub.1/1/24 A entry Property, Plant, \& Equipment Goodwill Investment in Sub I entry Equity in Subsidiary income Investment in Sub D entry Investment in Sub Dividends E entry Operating Expenses - depreciation Accumulated Depreciation TI entry Sales Cost of Goods Sold G entry Cost of Goods Sold Inventory Big Company 2024 Pro Forma Income Statement With Acquisition Sales Cost of Goods Sold Operating Expenses (49,200+450) Interest Expense Equity in Subsidiary income Income Before Taxes Income Tax Expense Net Income Big Company 2024 Projected with Acquisition 2024 Pro Forma Statement of Retained Earnings with Acquisition Retained Earnings, January 1 Add: Net Income Less: Dividends Retained Earnings, December 31 Big Company 2024 Pro Forma Balance Sheet with Acquisition Cash Accounts Receivable Inventory Property, Plant, \& Equipment Less: Accumulated Depreciation Investment in Subsiidiary Total Assets Accounts Payable Interest Payable Bonds Payable Common Stock Paid-In Capital in Excess of Par Retained Earnings Total Liabilities \& Equities Requirement 3 -Statements for Ratio Analysis Sun Inc. is contemplating a tender offer to acquire 80% of Moon Corporation's common stock. Moon's shares are currently quoted on the New York Stock Exchange at \$25 per share In order to have a reasonable chance of the tender offer attracting 80% of Moon's stock, Sun believes it will have to offer at least $30 per share. If the tender offer is made and is successful, the purchase will be consummated on January 1, 2024. Michael Jackson, the chairperson of Sun's acquisitions committee, has provided you with the projected 2024 financial statements for Sun Company without the proposed acquisition and the 2024 Projected Financial Statements of the Moon company in Table 1 If the tender offer is successful, Sun will finance the acquisition by issuing $36,000 of 6% nonconvertible bonds at par on January 1 , 2024. The bonds would first pay interest on July 1, 2024 and would pay interest semi annually thereafter each January 1 and July 1 This business combination will be recorded using acquisition method and Sun will account for the investment using the equity method. Although most of the legal work related to the acquisition will be handled by Sun's staff attorney, direct costs to prepare and process the tender offer will total \$750 and will be paid in cash by Sun in 2024. Additional Information As of January 1, 2024, all of Moon Company's assets and liabilities are fairly valued except for machinery with a book value of $5,000, an estimated fair value of $6,000, 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 2024. Regardless of whether they combine, Sun Company plans to buy $15,000 of merchandise from Moon Company in 2024 and will have $1,200 of these purchases remaining in inventory on December 31, 2024. In addition, Moon is expected to buy $900 of merchandise from Sun in 2024 and to have $150 of these purchases in inventory on December 31,2024 . Sun and Moon price their products to yield a 20 percent and 25 percent markup on cost, respectively. Sun Company intends to use three financial yardsticks to determine the financial attractiveness of the combination. First, Sun wishes to acquire Subsidiary Corporation Moon only if 2024 consolidated earnings per share will be at least as high as the earnings per share Sun would report if no combination takes place. Second, Sun will consider the proposed combination unattractive if it will cause the consolidated current ratio to 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 Required 1.Adjust the separate financial statements of Sun Company to reflect the proposed acquisition. Adjust the given Sun's pro forma 2024 financial statements to reflect the proposed acquisition (i.e., adjust Parent's forecasted financial statements - Statement of Operations, Statement of Retained Earnings and Balance Sheet) for bond issuance, stock purchase, income from subsidiary, etc.). Support your statements with appropriate work papers and journal entries. 2. Prepare pro forma consolidation worksheet. Prepare a pro forma consolidation worksheet for Sun Company and it's proposed subsidiary Moon Company as of December 31, 2024. Use the adjusted pro forma 2024 financial statements of Sun Company prepared in \#1 and the projected 2024 financial statements of Moon company in table 1 . Show all consolidation adjusting entries including non controlling interest (NCl) entries. 1. Perform ratio analysis. Compute earnings per share, Current Ratio and Return on Average Stockholders' Equity for (i) the 2024 projected financial statements of Sun Company without acquisition as given in the question and (ii) the consolidated financial statements contained in the pro forma consolidation worksheet prepared in requirement \#2 of Phase I. Requirement 4 -Ratio Analysis Big w/o Acq Pro Forma 2024 Earnings Per Share + Net Income + Weighted Average C/S Outstanding EPS Consolidated Statements 2024 $ $ 8,000 8,000 0.00 Big w/o Acq Pro Forma 2024 Consolidated Statements 2024 Current Ratio + Current Assets + Current Liabilities $ Current Ratio Big w/o Acq Pro Forma 2024 Return on Average Stockholders Equity + Net Income + Average Stockhollders' Equity (below) Return on Average Stockholders Equity Consolidated Statements 2024 $ $ $ \#DIV/O! \#DIV/O! Average Stockholders' Equity Beginning Of Year Common Stock Paid-in Capital in Excess of Par Retained Earnings Total End Of Year Common Stock Paid-in Capital in Excess of Par Retained Earnings Total Total beg. and ending Stockholder's Equity Average Stockhollders' Equity-Total b/e +2 $ \#DIV/O! $ $ $ $