Complete problem 2-7 using the week 02 excel template. using the data

FIND A SOLUTION AT Academic Writers Bay

Complete Problem 2-7 using the Week 02 Excel Template.
Using the data given in Problem 2-6, assume that Aron Company purchases 80% of the common stock of Shield Company for $320,000 cash.
The following comparative balance sheets are prepared for the two companies immediately after the purchase:
 
Aron
Shield
Cash
$ 315,000
$ 40,000
Accounts receivable
70,000
30,000
Inventory
130,000
120,000
Investment in Shield Company
320,000
 
Land
50,000
35,000
Buildings and equipment
350,000
230,000
Accumulated depreciation
(100,000)
(50,000)
Copyrights
40,000
10,000
Total assets
$1,175,000
$415,000
Current liabilities
$ 192,000
$ 65,000
Bonds payable
 
100,000
Common stock ($10 par)—Aron
100,000
 
Common stock ($5 par)—Shield
 
50,000
Paid-in capital in excess of par
250,000
70,000
Retained earnings
633,000
130,000
Total liabilities and equity
$1,175,000
$415,000
Required
1. Prepare the value analysis and the determination and distribution of excess schedule for the investment in Shield Company.
2. Complete a consolidated worksheet for Aron Company and its subsidiary Shield Company as of December 31, 2015.
Information from 2-6
On December 31, 2015, Aron Company purchases of the common stock of Shield Company for $450,000 cash. On this date, any excess of cost over book value is attributed to accounts with fair values that differ from book values. These accounts of Shield Company have the following fair values:
Cash
$ 40,000
Accounts receivable
30,000
Inventory
140,000
Land
45,000
Buildings and equipment
225,000
Copyrights
25,000
Current liabilities
65,000
Bonds payable
105,000
The following comparative balance sheets are prepared for the two companies immediately after the purchase:
 
Aron
Shield
Cash
$ 185,000
$ 40,000
Accounts receivable
70,000
30,000
Inventory
130,000
120,000
Investment in Shield Company
450,000
 
Land
50,000
35,000
Buildings and equipment
350,000
230,000
Accumulated depreciation
(100,000)
(50,000)
Copyrights
40,000
10,000
Total assets
$1,175,000
$415,000
Current liabilities
$ 192,000
$ 65,000
Bonds payable
 
100,000
Common stock ($10 par)—Aron
100,000
 
Common stock ($5 par)—Shield
 
50,000
Paid-in capital in excess of par
250,000
70,000
Retained earnings
633,000
130,000
Total liabilities and equity
$1,175,000
$415,000
 
 

Order from Academic Writers Bay
Best Custom Essay Writing Services

QUALITY: ORIGINAL PAPER NO PLAGIARISM - CUSTOM PAPER

Why Choose Us?

  • non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee
SATISFACTION
SATISFACTION

How It Works

  • Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT ; SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.

About AcademicWritersBay.com

AcademicWritersBay.comnbsp;is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.

AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient andnbsp;high quality academic servicesnbsp;to our highly esteemed clients. AcademicWritersBay.com is equipped with competent andnbsp;proficient writersnbsp;to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders ofnbsp;master's degreesnbsp;ornbsp;PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. Atnbsp;AcademicWritersBay.com, you can be sure ofnbsp;excellent gradesnbsp;in your assignments and final exams.

NO PLAGIARISM
NO PLAGIARISM
error: Content is protected !!