Hello Tutors,

I hope my message finds you are doing great.

Could you please do me a big favor? I have to ask for help for a big project in Advance Accounting class. It may take me at least 3 hours+ since I really do not know how to start it.

For your convenience, You can check the project instruction and a excel file under the link below, and link the download button. There are total 4 parts. We have to finish it all of parts. You also can see the question below.

Also for your convenience, I can separate the project to "multiple Tutor request" for you if you prefer to. I have some of the "Tutor points" for the huge project. But please guide me how to process it. I am not familiar it in Coursehero.

http://www.mediafire.com/file/azxtr9m3usn2mwo/Project_Instructions.docx/file

http://www.mediafire.com/file/ijsoo6jpgz6a1tl/Project.xlsx/file

Thanks

The project Fact is below:

Park Company acquired 100 percent of Sand Company's outstanding stock for $1,450,000 cash on January 1, 2019 and paid $20,000 in fees to their lawyers for completing the deal.

By the end of 2019 it became clear that the research project that led to the in-process R&D was a failure with no future economic benefits.

Selected amounts from Park's and Sand's separate financial statements at December 31, 2020 are presented on the Project Facts tab in the Excel file provided in Canvas.

Park's January 1, 2020, Retained Earnings balance (before any effect from Sand's 2019 income or consolidation amounts in 2019) is $(930,000) (credit balance).

Park has 500,000 common shares outstanding for EPS calculations and reported $2,943,100 for consolidated assets at 1/1/2020.

Project Requirements

[12 points] On the "Project Facts" tab, review all information provided and complete the fair-value allocation schedule and calculate the excess amortizations for 2019 and 2020.

Part 1 [21 points]

a)Record the journal entry on Park's books to acquire Sand assuming dissolution occurs, then record the journal entry assuming no dissolution. For the rest of the project, please assume no dissolution.

b)a schedule showing the changes in the Investment in Sand account from acquisition through 12/31/2020

Part 2 [66 points for undergrads, 100 points for grads]

Using these instructions as well as the instructions at the top of each tab, complete two (4240) or three (6024) consolidation worksheets.

a)Equity method consolidation worksheet

b)Initial value method consolidation worksheet

c)Partial equity method consolidation worksheet (only 6024)

d)Discuss the results found addressing the following:

The effects of alternative investment accounting methods on the parent's trial balances and the final consolidation figures.

The relation between consolidated retained earnings and the parent's retained earnings under each of the investment accounting methods

Which method did you find easiest to apply and why?

Part 3 [12 points]

Calculate and present the effects of a 2020 total goodwill impairment loss on the following ratios for the consolidated entity: Earnings per share (EPS), Return on assets (ROA), Return on equity (ROE), and Debt to equity. Your worksheets should have the capability to adjust immediately for the possibility that all acquisition goodwill can be considered impaired in 2020. However, make sure they do not show the impairment when you submit your final file.

Below your calculations, discuss the results found. What is the effect on EPS, ROA, ROE, and debt to equity ratios when all of the acquisition related goodwill is considered impaired in 2021? What are some potential upsides and downsides when an impairment loss is recorded? Who is impacted by a goodwill impairment loss being recorded?

Part 4 [49 points]

Assume instead that Sand Company is located in Germany and uses the Euro for its currency. Park's CFO wishes to determine the effect that a change in the value of the Euro would have on the financial results. To help assess the foreign currency exposure associated with the investment in Sand, the CFO requests assistance in comparing results under various exchange rate fluctuations.

a)Using the exchange rates presented under the three different scenarios, translate Sand's 12/31/2020 trial balance. The Euro is Sand's functional currency.

b)Provide a risk assessment for Park regarding how the change in exchange rate could impact net income, cash flows from dividends, and the debt-to-equity ratio. Below your calculations, discuss your findings. Make sure you address the following:

Did the change in rate impact the figures consistently?

When should Park hedge their Euro exposure (when the rate is increasing or decreasing)?

How could Park avoid a negative translation adjustment reported in other comprehensive income?

What are some other strategies Park could use based on your hedging knowledge from Chapter 9?