please show your work thank you

Formula llar D Problem 34 (Ch 2), pages 85-86 14th ed. New Tune Co. & On-the-Go, Inc. On January 1, NewTune exchanges 15,000 shares of its common stock for all of the outstanding shares of On-the-Go. Each of NewTune's shares has a $4 per value and a $50 fair value. The fair value of the stock exchanged in the acquisition was considered equal to On-the-Go's fair value. NewTune also paid $25,000 in stock registration and issuance costs in connection with the merger. On-the-Go at acquisition date: Receivables Trademarks Record music catalog In-process research and development Notes payable BVs 65,000 95,000 60,000 0 (50,000) FVs 63,000 225,000 180,000 200,000 (45,000) Precombination book values for both companies: Cash Receivables Trademarks given analysis of acq'n New Tune 60,000 150,000 400,000 On-the-Go 29,000 65,000 95,000 bal sheet cons ws questions Home Page Layout Formulas Review View HEID Tell me what you want to do E12 X 63000 A B D 17 Precombination book values for both companies: 19 1 2 3 Cash Receivables Trademarks Record music catalog Equipment (net) Totals Accounts payable Notes payable Common stock Additional paid-in-capital Retained earnings Totals New Tune 60,000 150,000 400,000 840,000 320,000 1,770,000 (110,000) (370,000) (400,000) (30,000) (860,000) (1,770,000) On-the-Go 29,000 65,000 95,000 60,000 105,000 354,000 (34,000) (50,000) (50,000) (30,000) (190,000) (354,000) Requirements: Per textbook Assume that this combination is a statutory merger so that On-the-Go's accounts will be transferred to the records of NewTune. On-the-Go will be dissolved and will no longer exist as a legal entity. Prepare a postcombination balance Requirements: Per textbook a) Assume that this combination is a statutory merger so that On-the-Go's accounts will be transferred to the records of New Tune. On the Go will be dissolved and will no longer exist as a legal entity. Prepare a postcombination blanice sheet for New Tune as of the acquisition date. 30% b) Assume that no dissolution takes place in connection with this combination. Rather, both companies retain their separate legal identities. Prepare a worksheet to consolidate the two companies as of the combination date. 40% c) How do the balance sheet accounts compare across perts a) and b) ? 5% Per instructor d) How does the economic entity concept relate to the work you've done in this problem? 10% e) Analysis of acquisition 10% Professional approach to spreadsheet: calculations, Inbels, consistent formatting, etc. 5% Total grade 100% Formula llar D Problem 34 (Ch 2), pages 85-86 14th ed. New Tune Co. & On-the-Go, Inc. On January 1, NewTune exchanges 15,000 shares of its common stock for all of the outstanding shares of On-the-Go. Each of NewTune's shares has a $4 per value and a $50 fair value. The fair value of the stock exchanged in the acquisition was considered equal to On-the-Go's fair value. NewTune also paid $25,000 in stock registration and issuance costs in connection with the merger. On-the-Go at acquisition date: Receivables Trademarks Record music catalog In-process research and development Notes payable BVs 65,000 95,000 60,000 0 (50,000) FVs 63,000 225,000 180,000 200,000 (45,000) Precombination book values for both companies: Cash Receivables Trademarks given analysis of acq'n New Tune 60,000 150,000 400,000 On-the-Go 29,000 65,000 95,000 bal sheet cons ws questions Home Page Layout Formulas Review View HEID Tell me what you want to do E12 X 63000 A B D 17 Precombination book values for both companies: 19 1 2 3 Cash Receivables Trademarks Record music catalog Equipment (net) Totals Accounts payable Notes payable Common stock Additional paid-in-capital Retained earnings Totals New Tune 60,000 150,000 400,000 840,000 320,000 1,770,000 (110,000) (370,000) (400,000) (30,000) (860,000) (1,770,000) On-the-Go 29,000 65,000 95,000 60,000 105,000 354,000 (34,000) (50,000) (50,000) (30,000) (190,000) (354,000) Requirements: Per textbook Assume that this combination is a statutory merger so that On-the-Go's accounts will be transferred to the records of NewTune. On-the-Go will be dissolved and will no longer exist as a legal entity. Prepare a postcombination balance Requirements: Per textbook a) Assume that this combination is a statutory merger so that On-the-Go's accounts will be transferred to the records of New Tune. On the Go will be dissolved and will no longer exist as a legal entity. Prepare a postcombination blanice sheet for New Tune as of the acquisition date. 30% b) Assume that no dissolution takes place in connection with this combination. Rather, both companies retain their separate legal identities. Prepare a worksheet to consolidate the two companies as of the combination date. 40% c) How do the balance sheet accounts compare across perts a) and b) ? 5% Per instructor d) How does the economic entity concept relate to the work you've done in this problem? 10% e) Analysis of acquisition 10% Professional approach to spreadsheet: calculations, Inbels, consistent formatting, etc. 5% Total grade 100%