Reference no: EM131010475
Perform the accounting required for the elimination of each independent intercompany transaction:
Prepare the book calculations
Perform the required journal entries
Requirements:
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, which can be accessed from the Course Information page, to understand how you will be graded on this assignment.
Reach out to your instructor if you have questions about the assignment.
Assume that Parent Company decides to sell Equipment (Cost = $10,000, Accumulated Depreciation = $1,000) to Sub for $20,000 cash. Show the sale and the subsequent elimination entries by Parent Company.
|
Parent Company Balance Sheet
|
|
Assets, Liabilities & Equities
|
Book Value
|
|
Cash
|
$1,500,000
|
|
AR
|
$10,000
|
|
Inventory
|
$200,000
|
|
Land
|
$640,000
|
|
Equipment
|
$400,000
|
|
Accumulated Depreciation
|
-$150,000
|
| |
|
|
Patent
|
$0
|
|
Total Assets
|
$2,600,000
|
|
AP
|
$100,000
|
|
Common Stock
|
$450,000
|
|
Additional Paid In Capital
|
$600,000
|
|
Retained Earnings
|
$1,450,000
|
|
Total Liabilities & Equity
|
$2,600,000
|
|
Sub 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
|
Sale By Parent
|
|
|
|
Account
|
DR
|
CR
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
Acquisition by Sub
|
|
|
|
Account
|
DR
|
CR
|
| |
|
|
| |
|
|
| |
|
|
|
Elimination Entries by Parent
|
|
|
|
Account
|
DR
|
CR
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
Expects to earn the same annual return
: 3 year(s) ago, Mack invested 5,060 dollars. In 2 year(s) from today, he expects to have 8,990 dollars. If Mack expects to earn the same annual return after 2 year from today as the annual rate implied from the past and expected values given in the pr..
|
|
Find the amplitude and period of motion of the body
: A body with mass 250g is attached to the end of a spring that is stretched 25cm by a force of 9N. Find x(t) in the form C cos(ω0t - a). Find the amplitude and period of motion of the body.
|
|
How accurate are the various media representations
: How accurate are the various media representations of psychopathology- Identify at least one theoretical perspective (e.g., biological, cognitive, psychodynamic) from the literature that informs your observations.
|
|
Estimated value of operation
: EMC Corporation has never paid a dividend. Its current free cash flow of $400,000 is expected to grow at a constant rate of 5%. The weighted average cost of capital is WACC=12%. Calculate EMC's estimated value of operation.
|
|
Clearly identify the requirements being addressed
: 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 t..
|
|
Three deposits have added to your nest-egg
: Assume that, to help build your nest-egg, you made two deposits of $100, one on January 1, 2013, and one on July 1, 2013, in a savings account that paid 10 percent compounded semiannually. Then you made a third S100 deposit on April 1, 2014. How much..
|
|
What is the probability of each simple event
: Two of these students are to be randomly selected for inclusion on a university-wide student committee (by placing ?ve slips of paper in a bowl, mixing, and drawing out two of them). What are the 10 possible outcomes (simple events)?
|
|
Future value annuity-retirement account
: Future Value Annuity You are planning to make monthly deposits of $400 into a retirement account that pays 10 percent interest compounded monthly. If your first deposit will be made one month from now. how large will your retirement account be in 30 ..
|
|
Savings account-how much money will you receive
: You deposited $1,000 in a savings account that pays 8 percent interest, compounded quarterly, planning to use it to finish your last year in college. Eighteen months later, you decide to go to the Rocky Mountains to become a ski instructor rather tha..
|