Expert Answer :Assignment 4: Final Project

Solved by verified expert :Assignment 4: Final ProjectRoberts Corporation and William Company (Continuing Project)Over the next two years, William continued selling inventory to Roberts. Assume that any items in intercompany inventory at the end of a given year were sold to outside parties in the following year. Below are the details of the intercompany inventory sales:YearIntercompany salesIntercompany ending inventory at transfer priceGross profit rate on intercompany inventory transfers2009$125,000$80,00025%2010$220,000$125,00028%2011$300,000$160,00025%In addition to these transfers of inventory, William sold a building to Roberts on January 1, 2010, for $126,000. The book value of the building was only $70,000 on that date. The building had an eight-year remaining useful life at the time of the transfer and is depreciated using the straight-line method with no salvage method. The building remains on Robert’s books as of December 31, 2011.Separate financial statements for both companies as of December 31, 2011, are shown below:RobertsWilliamRevenues$(1,740,000)$(950,000)Cost of goods sold$820,000$500,000Depreciation expense$104,000$85,000Amortization expense$220,000$120,000Interest expense$20,000$15,000Income from Subsidiary$(129,600)0Net Income$(705,600)$(230,000)Retained earnings, 1/1/09$(2,856,000)$(487,000)Net Income (above)$(705,600)$(230,000)Dividends paid$200,000$25,000Retained earnings, 12/31/09$(3,361,600)$(692,000)Cash$535,000$115,000Accounts receivable$575,000$215,000Inventory$990,000$800,000Investment in William Stock$1,481,6000Buildings and equipment (net)$1,025,000$905,000Patents$950,000$107,000Total assets$5,556,600$2,142,000Accounts payable$(450,000)$(200,000)Notes payable$(545,000)$(450,000)Common stock$(900,000)$(700,000)Additional paid-in capital$(300,000)$(100,000)Retained earnings, 12/31/09 (above)$(3,361,600)$(692,000)Total liabilities and stockholders’ equity$(5,556,600)$(2,142,000)Part IBased on the information given above, complete the following tasks using the excel sheet created in Week 1:Prepare all of the necessary eliminating entries needed at December 31, 2011, using Microsoft Excel.Prepare the consolidated income statement, retained earnings statement, and balance sheet as of December 31, 2011, using Microsoft Excel. Be sure to show clearly the noncontrolling interest in both net income and stockholders’ equity on your worksheet.Submit your sheet to the W3: Assignment 4 Dropbox by Friday, October 25, 2013.Name your document: SU_MBA6302_W3_A4_LastName_FirstInitial.xls.Part IIRobert’s management has recently become vaguely aware of the requirements for FASB Statement No. 131, “Disclosures about Segments of an Enterprise and Related Information.” Since both Roberts and William operate in a single industry segment, management assumes that they are not subject to the disclosure requirement of SFAS 131. Draft a one- to two-page memorandum in a Microsoft Word document to your president indicating how, if at all, SFAS 131 applies to your company. Provide succinct but complete communication and, given the nature of the audience, avoid the use of accounting jargon.Cite any sources you use using the correct APA format on a separate page.Submit your memorandum to the Discussion Area by Saturday, October 26, 2013.