week 2
knohe_
week_02_templates.xlsxProblem 2-7
| Name of Company Being Acquired | Shield Company Carol Fischer: Insert Name of Company Being Acquired in this Cell. |
|||||||||||||||
| Name of Acquiring Company | Aron Company Carol Fischer: Insert the Name of the Acquiring Company in this cell. |
|||||||||||||||
| Date of Acquisition | December 31,2015 Carol Fischer: Insert the Date of Acquisition in this Cell. |
|||||||||||||||
| Shield Company | Aron Company | |||||||||||||||
| Book | Market Carol Fischer: Insert all market values even if they are the same as the fair values. | Book Value | ||||||||||||||
| Assets | ||||||||||||||||
| Cash Carol Fischer: Insert Current Assets in Cell A8 through A13. Cell A8 is reserved for Cash. |
||||||||||||||||
| Accounts Receivable | ||||||||||||||||
| Inventory | ||||||||||||||||
| Investment in Subsidiary | ||||||||||||||||
| Land Carol Fischer: Row 16 is reserved for the Land Account. |
||||||||||||||||
| Buildings and Equipment Carol Fischer: Row 17 is reserved for a Depreciable Fixed Asset |
||||||||||||||||
| Accumulated Depreciation Carol Fischer: Reserved for Accumulated Depreciaion. |
||||||||||||||||
| Copyrights Carol Fischer: Rows 23, 24, and 25 are reserved for intangibles other than goodwill. |
||||||||||||||||
| Goodwill | ||||||||||||||||
| Total Assets | - | - | - | |||||||||||||
| Liabilities | ||||||||||||||||
| Current Liabilities Carol Fischer: Rows 31, 32, and 33 are reserved for Current Liabilities. |
||||||||||||||||
| Bonds Payable Carol Fischer: Rows 34, 35, and 36 are reserved for Long-Term Liabilities |
||||||||||||||||
|
Carol Fischer: Insert the Name of the Acquiring Company in this cell. |
Carol Fischer: Insert the Date of Acquisition in this Cell. |
Carol Fischer: Insert all market values even if they are the same as the fair values. |
Carol Fischer: Insert Current Assets in Cell A8 through A13. Cell A8 is reserved for Cash. |
Carol Fischer: Do Not insert an account in this cell. |
Carol Fischer: Row 16 is reserved for the Land Account. |
Carol Fischer: Row 17 is reserved for a Depreciable Fixed Asset |
Carol Fischer: Reserved for Accumulated Depreciaion. |
Carol Fischer: Reserved for a Depreciable Fixed Asset |
Carol Fischer: Reserved for Accumulated Depreciation |
Carol Fischer: Reserved for a Depreciable Fixed Asset. |
Carol Fischer: Reserved for Accumulated Depreciation |
Carol Fischer: Rows 23, 24, and 25 are reserved for intangibles other than goodwill. |
Carol Fischer: This Cell should be left Blank |
Carol Fischer: Rows 31, 32, and 33 are reserved for Current Liabilities. | Premium on Bonds Payable | |
| Total Liabilities | - | - | - | |||||||||||||
| Equity Acquired Company | ||||||||||||||||
| Common Stock | ||||||||||||||||
| Paid-in Capital in Excess of Par | ||||||||||||||||
| Retained Earnings | ||||||||||||||||
| Equity Acquiring Company | ||||||||||||||||
| Common Stock | ||||||||||||||||
| Paid-in Capital in Excess of Par | ||||||||||||||||
| Retained Earnings | ||||||||||||||||
| Total Equity | - | - | ||||||||||||||
| Total Liabilities and Equity | - | - | ||||||||||||||
| Net Assets at Market of Acquired Co. | - | |||||||||||||||
| Check Balance Sheet Equality | OK | OK | ||||||||||||||
| Purchase Price | ||||||||||||||||
| Cash | ||||||||||||||||
| Number of shares exchanged | ||||||||||||||||
| Par value of a share of stock | ||||||||||||||||
| Market value of a share of stock | ||||||||||||||||
| Market value of stock exchanged | - | |||||||||||||||
| Total purchase price | - | |||||||||||||||
| Ownership Interest enter as .7 for 70% | ||||||||||||||||
| Goodwill Applicable to NCI | ||||||||||||||||
| Implied Value of NCI Interest | ERROR:#DIV/0! | |||||||||||||||
| Estimated Value of NCI interest if not the implied proportional amount--Enter amount or 0 | - 0 | |||||||||||||||
| Value Analysis | ||||||||||||||||
| Company Fair Value | Parent Price | NCI Value | ||||||||||||||
| Company Fair Value | ERROR:#DIV/0! | - | ERROR:#DIV/0! | |||||||||||||
| Fair Value of Net Assets Excluding Goodwill | - | - | - | |||||||||||||
| Goodwill | ERROR:#DIV/0! | - | ERROR:#DIV/0! | |||||||||||||
| Gain on Acquisition | ERROR:#DIV/0! | |||||||||||||||
| Determination and Distribution of Excess Schedule | ||||||||||||||||
| Implied Company Value | Parent Price | NCI Value | ||||||||||||||
| Fair Value of Company | ERROR:#DIV/0! | - | ERROR:#DIV/0! | |||||||||||||
| Less Book Value of Interest Acquired | ||||||||||||||||
| Common Stock | - | |||||||||||||||
| Paid-in Capital in Excess of Par | - | |||||||||||||||
| Retained Earnings | - | |||||||||||||||
| Total Equity | - | |||||||||||||||
| Interest Acquired | - 0 | 1.00 | ||||||||||||||
| Book Value | 0 | - | ||||||||||||||
| Excess of Fair Value over Book Value | - | ERROR:#DIV/0! | ||||||||||||||
| Elimination Entry | Key | |||||||||||||||
| Common Stock | - | EL | ||||||||||||||
| Paid-in Capital in Excess of Par | - | EL | ||||||||||||||
| Retained Earnings | - | EL | ||||||||||||||
| Investment in Subsidiary | - 0 | EL | ||||||||||||||
| Adjustment to Identifiable Accounts | Debit (Credit) | Key | ||||||||||||||
| Accounts Receivable | - | D | ||||||||||||||
| Inventory | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| Land | - | D | ||||||||||||||
| Buildings and Equipment | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| Copyrights | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| Goodwill | ERROR:#DIV/0! | D | ||||||||||||||
| Current Liabilities | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| Bonds Payable | - | D | ||||||||||||||
| Premium on Bonds Payable | - | D | ||||||||||||||
| - | - | D | ||||||||||||||
| Investment in Subsidiary | - | D | ||||||||||||||
| Gain Taken to Acquiring Co. RE | ERROR:#DIV/0! | D | ||||||||||||||
| Acquired Company RE | ERROR:#DIV/0! | D | ||||||||||||||
| Check | ERROR:#DIV/0! | |||||||||||||||
| Consolidated Worksheet | ||||||||||||||||
| Trial Balance | Eliminations | |||||||||||||||
| Aron Company | Shield Company | Key | Debit | Credit | Key | Non Control Interest | Consolidated Balance Sheet | |||||||||
| Cash | - | - | - | |||||||||||||
| Accounts Receivable | - | - | D | 0 | 0 | D | - | |||||||||
| Inventory | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| Investment in Subsidiary | - | - | 0 | EL | - | |||||||||||
| D | 0 | 0 | D | |||||||||||||
| Land | - | - | D | 0 | 0 | D | - | |||||||||
| Buildings and Equipment | - | - | D | 0 | 0 | D | - | |||||||||
| Accumulated Depreciation | - | - | - | |||||||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | - | |||||||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | - | |||||||||||||
| Copyrights | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| Goodwill | - | - | D | ERROR:#DIV/0! | ERROR:#DIV/0! | D | ERROR:#DIV/0! | |||||||||
| Current Liabilities | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| Bonds Payable | - | - | D | 0 | 0 | D | - | |||||||||
| Premium on Bonds Payable | - | - | D | 0 | 0 | D | - | |||||||||
| - | - | - | D | 0 | 0 | D | - | |||||||||
| Common Stock | - | - | EL | - | - | - | ||||||||||
| Paid-in Capital in Excess of Par | - | - | EL | - | - | - | ||||||||||
| Retained Earnings | - | - | EL | - | ERROR:#DIV/0! | D | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| Common Stock | - | - | - | |||||||||||||
| Paid-in Capital in Excess of Par | - | - | - | |||||||||||||
| Retained Earnings | - | - | ERROR:#DIV/0! | D | ERROR:#DIV/0! | |||||||||||
| Totals | - | - | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||
| Non-Controlling Interest | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||
| Total | ERROR:#DIV/0! | |||||||||||||||
