4. On January 1, 2016, Parent Company purchased 100% of the common stock of Subsidiary Company for $390,000. On this date, Subsidiary had common stock, other paid in capital, and retained earnings of $50,000,$100,000, and $200,000 respectively. Any excess of cost over book value is due to goodwill. Parent accounts for the Investment in Subsidiary using the simple equity method. On January 1, 2017, Parent purchased equipment for $204,120 and immediately leased the equipment to Subsidiary on a 4-year lease. The minimum lease payments of $60,000 are to be made annually on January 1 , beginning immediately, for a total of 4 payments. The implicit interest rate is 12%. The lease provides for an automatic transfer of title at the end of 4 years. The estimated useful life of the equipment is 6 years. The lease has been capitalized by both companies. A lease amortization schedule, applicable to either company, is presented below: On January 1, 2017 Parent held merchandise acquired from Subsidiary for $10,000. During 2017 , subsidiary sold merchandise to Parent for $50,000, of which $15,000 is held by Parent on December 31, 2017. Subsidiary's usual gross profit on affiliated sales is 40%. Required: Complete the worksheet for consolidated financial statements for the year ended December 31 , 2017. Round all computations to the nearest dollar. (The worksheet below can be copied into Excel. Add rows as needed.) Also, prepare journal entries for the eliminations. (No explanations) \begin{tabular}{|l|l|} \hline Common Stock - S Co. & 50,000 \\ \hline Other Paid-in Capital - S Co. & 100,000 \\ \hline Retained Earnings - S Co. & 310,000 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Net Sales & 600,000 & 350,000 \\ \hline Cost of Goods Sold & 372,170 & 200,000 \\ \hline Operating \& Other Expenses & 140,000 & 67,830 \\ \hline Interest Income on Lease & 12,170 & \\ \hline Interest Expense on Lease & & 12,170 \\ \hline Subsidiary Income & 70,000 & \\ \hline Dividends Declared - P Co. & 50,000 & \\ \hline Dividends Declared - S Co. & & 10,000 \\ \hline \end{tabular} Consolidated Net Income To NCl To Controlling Interest Total NCl Ret. Earn. Contr. Int. 12-31 00 4. On January 1, 2016, Parent Company purchased 100% of the common stock of Subsidiary Company for $390,000. On this date, Subsidiary had common stock, other paid in capital, and retained earnings of $50,000,$100,000, and $200,000 respectively. Any excess of cost over book value is due to goodwill. Parent accounts for the Investment in Subsidiary using the simple equity method. On January 1, 2017, Parent purchased equipment for $204,120 and immediately leased the equipment to Subsidiary on a 4-year lease. The minimum lease payments of $60,000 are to be made annually on January 1 , beginning immediately, for a total of 4 payments. The implicit interest rate is 12%. The lease provides for an automatic transfer of title at the end of 4 years. The estimated useful life of the equipment is 6 years. The lease has been capitalized by both companies. A lease amortization schedule, applicable to either company, is presented below: On January 1, 2017 Parent held merchandise acquired from Subsidiary for $10,000. During 2017 , subsidiary sold merchandise to Parent for $50,000, of which $15,000 is held by Parent on December 31, 2017. Subsidiary's usual gross profit on affiliated sales is 40%. Required: Complete the worksheet for consolidated financial statements for the year ended December 31 , 2017. Round all computations to the nearest dollar. (The worksheet below can be copied into Excel. Add rows as needed.) Also, prepare journal entries for the eliminations. (No explanations) \begin{tabular}{|l|l|} \hline Common Stock - S Co. & 50,000 \\ \hline Other Paid-in Capital - S Co. & 100,000 \\ \hline Retained Earnings - S Co. & 310,000 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Net Sales & 600,000 & 350,000 \\ \hline Cost of Goods Sold & 372,170 & 200,000 \\ \hline Operating \& Other Expenses & 140,000 & 67,830 \\ \hline Interest Income on Lease & 12,170 & \\ \hline Interest Expense on Lease & & 12,170 \\ \hline Subsidiary Income & 70,000 & \\ \hline Dividends Declared - P Co. & 50,000 & \\ \hline Dividends Declared - S Co. & & 10,000 \\ \hline \end{tabular} Consolidated Net Income To NCl To Controlling Interest Total NCl Ret. Earn. Contr. Int. 12-31 00
