Expert answer:Spreadsheet

Solved by verified expert:Assignment Option #1: Acquisitions with Ownership < 100% and BV = FMVUsing the data in the Option 1 Spreadsheet (linked at the bottom of the page), perform the accounting required for the acquisition of Little, Inc. by Big, Inc. This is an 80% acquisition, where the book value of the assets acquired equals the acquisition price. Within the worksheet, you are to:Select an accounting method (either cost or equity) and explain why you selected this methodPerform the required journal entriesComplete the consolidation worksheetPrepare the consolidated balance sheet in good formRequirements:Complete all work on the spreadsheet attached to this assignment; it will be your only deliverable.Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions. Submit a single MS Excel file for grading.Review the grading rubric to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment. act470_studenttemplate_ct_mod03_opt1.xlsx Unformatted Attachment Preview Assume that Big Company decides to acquire 80% Little Company for $500,000. P Big Company Balance Sheet Assets, Liabilities & Equities Book Value Cash $2,100,000 AR $10,000 Inventory $200,000 Land $40,000 PP&E $400,000 Accumulated Depreciation -$150,000 Patent $0 Total Assets $2,600,000 AP $100,000 Common Stock ($10 par) $450,000 Additional Paid In Capital $600,000 Retained Earnings $1,450,000 Total Liabilities & Equity $2,600,000 Little Company Balance Sheet Assets, Liabilities & Equities Book Value Cash $35,000 AR $10,000 Inventory $65,000 Land $40,000 PP&E $400,000 Accumulated Depreciation -$150,000 Patent $0 Total Assets $400,000 AP $100,000 Common Stock $100,000 Additional Paid In Capital $50,000 Retained Earnings $150,000 Total Liabilities & Equity $400,000 Assume that Book Value = Fair Value Which accounting method is most appropriate for representing a investment of this type? Prepare the journal entries for a 80% Asset Acquisition (using Bi Company Cash) Account Prepare the journal entries for a 80% Acquisition by issuing 10,00 shares of Big Company Stock Account Investment in Little Common Stock Additional Paid In Capital Allocation of Excess Schedule tle Company for $500,000. Prepare the appropriate journal entries. most appropriate for representing an ent of this type? Prepare Elimination Entries for Stock Acquisition Account DR CR or a 80% Asset Acquisition (using Big mpany Cash) DR CR or a 80% Acquisition by issuing 10,000 Big Company Stock DR CR of Excess Schedule Big Company Balance Sheet (Consolidated) Assets, Liabilities & Equities Cash AR Inventory Land PP&E (net) Accumulated Depreciation Goodwill Patent Total Assets AP Common Stock ($10 par) Additional Paid In Capital Retained Earnings NCI Total Liabilities & Equity ... Purchase answer to see full attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades