Please Note: I don't need help with table 1. I just need help with tables 4-7. I cannot figure out this assignment at all. Thank you in advance!

BUS-FP4063 DyalMichael Assessment Excel Sign in Insert Page Layout Formulas Data Review view Q Tell me what you want to do File Home dx cut 2 Autosu A Wrap Text Accounting Paste Co E Merge & Center s Conditional Format as cell Insert Delete Format Sort & Find & B I U Format Painter Clear Table Select Clipboard Fon Alignment Number Editing B28 1 Assessment 1: Accounting for Equity InvestmentsA1 2 Exercise 1 Worksheet: Journal Entries On January 1, 2015, the Parker Corporation acquired 10% of Simon Inc. for $420,000, even though Simon's book value on January 1 was $3,400,000. Simon held land on its books that was undervalued by $200,000. In 2015, Simon earned $480,000 in net income and paid cash dividends of $180,000. Parker acquired an additional 30% of Simon January 1 2016 for $1.200,000, Simon's land remained undervalued as of th at date $240,000. Any excess cost was ascribed to a trademark with a life of 10 years for the first acquisition and a life of nine years for the second acquisition Because fair values were not readily available Parker maintained the in al investment of 10% at cost. The method will now be a 2018, Simon reported $800,000 in ncome and $220,000 of distributed dividends Complete steps 1 and 2 below. Step 1: Restate the 2015 purchase to the equity method in Tables 1, 2, and 3. 6 Table 1: First Purchase-January 1, 2015 Exercise 1 NotesToMyself Exercise 2 Exercise 3 Entel 58 AM Ask me anything A 3/15/2017 share