On January 1, 20X8, Pace Company acquired all of the outstanding stock of Spin PLC, a British company, for $350,000. Spin’s net assets on the date of acquisition were 250,000 pounds (£). On January 1, 20X8, the book and fair values of the Spin’s identifiable assets and liabilities approximated their fair values except for property, plant, and equipment and trademarks. The fair value of Spin’s property, plant, and equipment exceeded its book value by $25,000. The remaining useful life of Spin’s equipment at January 1, 20X8, was 10 years. The remainder of the differential was attributable to a trademark having an estimated useful life of 5 years. Spin’s trial balance on December 31, 20X8, in pounds, follows:
Debits
Credits
Cash
£
70,000
Accounts Receivable (net)
100,000
Inventory
120,000
Property, Plant, and Equipment
330,000
Accumulated Depreciation
£
120,000
Accounts Payable
110,000
Notes Payable
90,000
Common Stock
100,000
Retained Earnings
150,000
Sales
420,000
Cost of Goods Sold
270,000
Operating Expenses
60,000
Depreciation Expense
30,000
Dividends Paid
10,000
Total
£
990,000
£
990,000
Additional Information:
March 1, 20X6
1£
=
$
1.20
December 31, 20X7
1£
=
$
1.25
January 1, 20X8
1£
=
$
1.25
November 1, 20X8
1£
=
$
1.26
December 26, 20X8
1£
=
$
1.31
December 31, 20X8
1£
=
$
1.35
Average for 20X8
1£
=
$
1.30
Required:
Prepare and submit only one Excel spreadsheet answering all of the requirements.
Use Excel formulas to make or evidence each of your calculations of each/any dollar amounts. Do not enter any dollar amounts, directly, for the answers to the requirements unless it is unavoidable for obvious reasons. Use the tab function at the bottom of the Excel file where required to answer each of the requirements.
Name your Excel file when you submit it: MyNameModuleXOption1or2.
Requirements:
Review the week’s CT Assignment grading rubric for more information on expectations and how you will be graded.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more