Reference no: EM13852453
On January 1, 2014, Patrick Company purchased 100 percent of the outstanding voting stock of Shawn, Inc., for $1,000,000 in cash and other consideration. At the purchase date, Shawn had common stock of $500,000 and retained earnings of $185,000. Patrick attributed the excess of acquisition-date fair value over Shawn's book value to a trade name with a 25-year remaining useful life. Patrick uses the equity method to account for its investment in Shawn.
During the next two years, Shawn reported the following:
|
|
Income
|
Dividends
Declared
|
Inventory Transfers to
Patridc at Transfer Price
|
|
2014
|
578.000
|
525.000
|
5190.000
|
|
2015
|
85,000
|
27,000
|
210,000
|
Shawn sells inventory to Patrick after a markup based on a gross profit rate. At the end of 2014 and 2015, 30 percent of the current year purchases remain in Patrick's inventory.
Required
Create an Excel spreadsheet that computes the following:
1. Equity method balance in Patrick's Investment in Shawn, Inc., account as of December 31, 2015.
2. Worksheet adjustments for the December 31, 2015, consolidation of Patrick and Shawn. Formulate your solution so that Shawn's gross profit rate on sales to Patrick is treated as a variable.
|
Calculate franchises payback period and net present value
: Calculate each franchise's payback period, net present value (NPV), internal rate of return (IRR), and modified internal rate of return (MIRR).
|
|
Calculate the first ten years of the income statement
: Your Qualified Loan: 70% LTV, 6.5% Interest Rate, 20 years, 10 year balloon, DCR = 1.4. Calculate the first ten years of the income statement through the ATCF.
|
|
What income tax payments did 2014 liquidation cost supervalu
: What additional income tax payments did the 2014 liquidation cost SUPERVALU? Assume an income tax of 40%.
|
|
Compute the expected new net income
: Given the increased incentive, they expect net sales to increase by 15%. As a result, they estimate that gross profit will increase by $52,576 and expenses by $76,180. Compute the expected new net income. Then, compute the revised profit margin an..
|
|
Compute the equity method balance in patricks investment
: Formulate your solution so that Shawns gross profit rate on sales to Patrick is treated as a variable - Create an Excel spreadsheet.
|
|
Alculate amount of current assets and current liabilities
: Calculate the amount of current assets and current liabilities from the following: a) Current Ratio: 2.5:1, Working capital: ?60,000 b) Gross Profit : ?1,00,000, Total sales: ?5,25,000, Sales returns: ?25,000.Calculate Gross profit ratio.
|
|
Specific products in the process
: What amount of costs should be traced to specific products in the process?
|
|
What is npv of plane b on a ten-year equivalent life basis
: What is the NPV of plane B on a ten-year equivalent life basis? $27,047,879 $8,143,286 $9,255,576 $21,595,356 $12,677,537.
|
|
What are the ethics of the alternatives
: What are the ethical issues - who are the primary stakeholders and what are the possible alternatives - What are the ethics of the alternatives?
|