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

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 (NCI) entries.

I need help finishing the consolidation worksheet and the TI and S entries. I finished the financial statements and included those as well as the working notes for information. Please help if possible.

Sun and Moon Company Proforma Financial Statements for 2024 \begin{tabular}{|l|l|} \hline Sun 2024 Projected & Moon 2024 \\ Financial & Projected \\ Statements Without & Financial \\ Acquisition & Statements \end{tabular} "Sun: \$13 par value. Moon: \$20 par value Sun and Moon Company Proforma Financial Statements for 2024 \begin{tabular}{|l|l|} \hline Sun 2024 Projected & Moon 2024 \\ Financial & Projected \\ Statements Without & Financial \\ Acquisition & Statements \end{tabular} "Sun: \$13 par value. Moon: \$20 par value Requirement 1 Sun Company 2024 Pro Forma Income Statement With Acquisition Sun Company 2024 Pro Forma Balance Sheet with Acquisition Cash Accounts Receivable Inventory Property, Plant \& Equipment Less: Accumulated Depreciation Investment in Subsidiary Total Assets Accounts Payable Interest Payable (for six months) Bonds Payable Common Stock Paid-In Capital in Excess of Par Retained Earnings Total Liabilities \& Equities \begin{tabular}{rr} \hline$ & 18,167 \\ 13,775 \\ 12,875 \\ 228,000 \\ \hline(176,600) \\ 41,143 \\ \hline$137,360 \\ \hline \hline & \\ \hline$ & 13,400 \\ & 1,080 \\ \hline & 36,000 \\ \hline & 65,000 \\ & 2,000 \\ \hline & 19,880 \\ \hline$ & 137,360 \\ \hline \hline & \\ \hline \end{tabular} Working Papers - Requirement \#1 Sun Company Proforma Financial Statements with Acquisition 2 Annual Amortization \begin{tabular}{|l|r|r|} \hline 80% of Excess Fair Value allocated to Machinery & $800 & \\ \hline Useful remaining life of machinery & 5 & $160 \\ \hline Annual Amorization & $160 & $160 \end{tabular} 3 Gross profit deferral on upstream sales Inventory remaining with Sun Company Markup \% on Cost applied by Moon Total Gross Profit (1200* Gross Profit Margin) Sun Company's Share to be deferred GP Margin =M/(1+M) 0.2 4 Gross profit deferral on downstream sales Inventory remaining with Moon Company Markup \% on cost applied by Sun Gross Profit to be deferred (150GP%) GP Margin =M/(1+M) 0.166666667 5 Investment in Moon account Beginning Balance (Moon no. of shares 80%$30 ) Plus equity in Subsidiary (Moon Income 80% ) \begin{tabular}{l} Minus Annual Amortization \\ Minus Subsidiary dividen \\ Minus Unrealized profit on \\ Minus Unrealized profit on \\ Balance on 12/31/2024 \\ \hline \end{tabular} \begin{tabular}{|rr} $ & 36,000 \\ $ & 6,720 \\ $ & (160) \\ $ & (1,200) \\ $ & (192) \\ $ & (25) \\ \hline$ & 41,143 \\ \hline \end{tabular} 6 Cash Account Cash Balance before acquisition $20,170 Plus lssue of Bonds $36,000 Minus Interest Expense paid for 6 months $(1,080) Plus Dividend Received from Moon (Moon div 80% ) $1,200 Minus Direct cost of acquisition paid (legal fees) $(750) Minus amount paid to Moon $(36,000) Minus additional income tax liability with acquistion $(1,373) (8,8137,440) Cash Balance after acquistion $18,167 7 Interest Expense payable for six months $1,080 from July 1st to Dec 31st payable on Jan 1 st 2025 8 Equity in Subsidiary Income 80% of Moon 2024 Project income minus annual amortization minus gross profit deferral on upstream sales minus gross profit deferral on downstream sales Equity in Subsidiary Income \begin{tabular}{|rr|} \hline$ & 6,720 \\ $ & (160) \\ $ & (192) \\ \hline$ & (25) \\ \hline$ & 6,343 \\ \hline \end{tabular} Consolidation Entries Check figures 66448 664489912 1 S entry Common Stock - Sub Paid-In Capital in Excess of Par - Sub. Retained Earnings, Jan. 1 - Sub. Investment in Sub. Noncontrolling Interest in Sub. 1/1/24 2 A entry 3 I entry Equity in Subsidiary Income 6,343 Investment in Sub. 4 D entry Investment in Sub. 1,200 Dividends 5 E entry Operating Expenses - Depreciation 160 Accumulated Depreciation 160 6 Tl entry Sales Cost of Goods Sold 7 G entry Sun and Moon Company Proforma Financial Statements for 2024 \begin{tabular}{|l|l|} \hline Sun 2024 Projected & Moon 2024 \\ Financial & Projected \\ Statements Without & Financial \\ Acquisition & Statements \end{tabular} "Sun: \$13 par value. Moon: \$20 par value Sun and Moon Company Proforma Financial Statements for 2024 \begin{tabular}{|l|l|} \hline Sun 2024 Projected & Moon 2024 \\ Financial & Projected \\ Statements Without & Financial \\ Acquisition & Statements \end{tabular} "Sun: \$13 par value. Moon: \$20 par value Requirement 1 Sun Company 2024 Pro Forma Income Statement With Acquisition Sun Company 2024 Pro Forma Balance Sheet with Acquisition Cash Accounts Receivable Inventory Property, Plant \& Equipment Less: Accumulated Depreciation Investment in Subsidiary Total Assets Accounts Payable Interest Payable (for six months) Bonds Payable Common Stock Paid-In Capital in Excess of Par Retained Earnings Total Liabilities \& Equities \begin{tabular}{rr} \hline$ & 18,167 \\ 13,775 \\ 12,875 \\ 228,000 \\ \hline(176,600) \\ 41,143 \\ \hline$137,360 \\ \hline \hline & \\ \hline$ & 13,400 \\ & 1,080 \\ \hline & 36,000 \\ \hline & 65,000 \\ & 2,000 \\ \hline & 19,880 \\ \hline$ & 137,360 \\ \hline \hline & \\ \hline \end{tabular} Working Papers - Requirement \#1 Sun Company Proforma Financial Statements with Acquisition 2 Annual Amortization \begin{tabular}{|l|r|r|} \hline 80% of Excess Fair Value allocated to Machinery & $800 & \\ \hline Useful remaining life of machinery & 5 & $160 \\ \hline Annual Amorization & $160 & $160 \end{tabular} 3 Gross profit deferral on upstream sales Inventory remaining with Sun Company Markup \% on Cost applied by Moon Total Gross Profit (1200* Gross Profit Margin) Sun Company's Share to be deferred GP Margin =M/(1+M) 0.2 4 Gross profit deferral on downstream sales Inventory remaining with Moon Company Markup \% on cost applied by Sun Gross Profit to be deferred (150GP%) GP Margin =M/(1+M) 0.166666667 5 Investment in Moon account Beginning Balance (Moon no. of shares 80%$30 ) Plus equity in Subsidiary (Moon Income 80% ) \begin{tabular}{l} Minus Annual Amortization \\ Minus Subsidiary dividen \\ Minus Unrealized profit on \\ Minus Unrealized profit on \\ Balance on 12/31/2024 \\ \hline \end{tabular} \begin{tabular}{|rr} $ & 36,000 \\ $ & 6,720 \\ $ & (160) \\ $ & (1,200) \\ $ & (192) \\ $ & (25) \\ \hline$ & 41,143 \\ \hline \end{tabular} 6 Cash Account Cash Balance before acquisition $20,170 Plus lssue of Bonds $36,000 Minus Interest Expense paid for 6 months $(1,080) Plus Dividend Received from Moon (Moon div 80% ) $1,200 Minus Direct cost of acquisition paid (legal fees) $(750) Minus amount paid to Moon $(36,000) Minus additional income tax liability with acquistion $(1,373) (8,8137,440) Cash Balance after acquistion $18,167 7 Interest Expense payable for six months $1,080 from July 1st to Dec 31st payable on Jan 1 st 2025 8 Equity in Subsidiary Income 80% of Moon 2024 Project income minus annual amortization minus gross profit deferral on upstream sales minus gross profit deferral on downstream sales Equity in Subsidiary Income \begin{tabular}{|rr|} \hline$ & 6,720 \\ $ & (160) \\ $ & (192) \\ \hline$ & (25) \\ \hline$ & 6,343 \\ \hline \end{tabular} Consolidation Entries Check figures 66448 664489912 1 S entry Common Stock - Sub Paid-In Capital in Excess of Par - Sub. Retained Earnings, Jan. 1 - Sub. Investment in Sub. Noncontrolling Interest in Sub. 1/1/24 2 A entry 3 I entry Equity in Subsidiary Income 6,343 Investment in Sub. 4 D entry Investment in Sub. 1,200 Dividends 5 E entry Operating Expenses - Depreciation 160 Accumulated Depreciation 160 6 Tl entry Sales Cost of Goods Sold 7 G entry