Please show through excel, if possible.

1. Rose had net income of $120,000 in 2013.

1. Daisy acquired Rose so that Rose could provide Daisy with vital component parts for its production of Captain Kirk lounge chairs.
   1. At the beginning of 2013, Daisy had inventory on hand from Rose that it paid Rose $30,000 for. Roses cost to make that inventory was $20,000.
   2. During 2013, Daisy purchased $160,000 of inventory from Rose that cost Rose $120,000 to make. Of the inventory purchased in 2013, Daisy had $68,000 of it left unused at the end of the year. The cost to Rose to make this unused inventory was $51,000.
2. On January 1, 2012, Daisy sold Rose several pieces of equipment that had a 10 year remaining useful life. All equipment in the controlled group is considered to have no salvage value and is depreciated on a straight line basis. The equipment originally cost Daisy $100,000 and had accumulated depreciation of $56,000 at the time of the transfer. The transfer price was $80,000.
3. On January 1, 2013 Daisy sold land on credit to Rose for $50,000. The original cost of the land was $22,000. At December 31, 2013, Rose had yet to pay for the land.

1. (8 Points) Calculate the equity in income for the controlling and non-controlling interest

Description	Total	CI	NCI
Total