Please show formulas!!

The December 31, 20X8, balance sheets for Pint Corporation and its 70 percent-owned subsidiary Saloon Company contained the following summarized amounts: PINT CORPORATION AND SALOON COMPANY Balance Sheets December 31, 20x8 Pint Saloon Corporation Company Assets Cash & Receivables $113,000 $ 48,000 Inventory 166,000 109,000 Buildings & Equipment (net) 312,000 289,000 Investment in Saloon Company 224,500 Total Assets $815,500 $446,000 Liabilities & Equity Accounts Payable $117,500 $ 67,000 Common Stock 182,000 142,000 Retained Earnings 516,000 237,000 Total Liabilities & Equity $815,500 $446,000 Pint acquired the shares of Saloon Company on January 1, 20x7. On December 31, 20X8, assume Pint sold inventory to Saloon during 20x8 for $110,000 and Saloon sold inventory to Pint for $304,000. Pint's balance sheet contains inventory items purchased from Saloon for $102,000. The items cost Saloon $62,000 to produce. In addition, Saloon's inventory contains goods it purchased from Pint for $32,000 that Pint had produced for $19,200. Assume Saloon reported net income of $73,000 and dividends of $14,600. Required: a. Prepare all consolidation entries needed to complete a consolidated balance sheet worksheet as of December 31, 20X8. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Do not round intermediate calculations.) Consolidation Worksheet Entries A B Record the basic consolidation entry. Note: Enter debits before credits. Accounts Debit Credit Entry 1 Common stock Retained earnings Income from Saloon Company NCI in NI of Saloon Company Dividends declared Investment in Saloon Company INCI in NA of Saloon Company Record entry Clear entry view consolidation entries es Record the entry to defer this year's unrealized profit on inventory transfers. Note: Enter debits before credits. Accounts Debit Credit Entry 2 Sales Inventory Cost of goods sold Record entry Clear entry view consolidation entries b. Prepare a consolidated balance sheet worksheet as of December 31, 20X8. (Do not round intermediate calculations. Values in the first two columns (the "parent" and "subsidiary" balances) that are to be deducted should be indicated with a minus sign, while all values in the "Consolidation Entries" columns should be entered as positive values. For accounts where multiple adjusting entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet.) PINT CORPORATION & SUBSIDIARY Consolidated Balance Sheet Worksheet December 31, 20x8 Consolidation Entries Pint Saloon DR CR Corporation Company Consolidated S 0 S 0 S 0 S 0 S 0 Assets Cash and receivables Inventory Buildings & equipment (net) Investment in Saloon Company Total Assets Liabilities & Equity Accounts payable Common stock Retained earnings NCI in NA of Saloon Company Total Liabilities & Equity S 0 S 0 S 0 S 0 S 0