Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please help me solve these in excel? THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 32 - 33. On September 1, Year 1, Test

Can someone please help me solve these in excel?

image text in transcribed

THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 32 - 33. On September 1, Year 1, Test Company purchased 2,000 shares of A Company common stock for $25 per share. The investment represents a less than 1% ownership interest. On the date of acquisition, the fair value of A Company's net assets exceeded the book value by $100,000. The amount is attributable to buildings with a remaining useful life of 10 years. During both Year 1 and Year 2, A Company paid dividends of $0.50 per share. A Company reported net income of $2,000,000 for the year ended December 31 , Year 1 and $2,100,000 for the year ended December 31 Year 2. The fair value of A Company's common stock was $27 per share on December 31 , Year 1 and $28 per share on December 31 , Year 2. Assume that Tests Company held no other investments during Year 1 or Year 2. Determine the amount that pretax income would increase (decrease) in Year 1 as a result of the investment. Give your answer using dollar signs and commas but not decimals (cents). Example: $12,345 or $(12,345) Selected Answer: x [None Given] Correct Answer: stion 33 0 out of 3 points THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 32 - 33. On September 1, Year 1, Test Company purchased 2,000 shares of A Company common stock for $25 per share. The investment represents a less than 1% ownership interest. On the date of acquisition, the fair value of A Company's net assets exceeded the book value by $100,000. The amount is attributable to buildings with a remaining useful life of 10 years. During both Year 1 and Year 2, A Company paid dividends of $0.50 per share. A Company reported net income of $2,000,000 for the year ended December 31 , Year 1 and $2,100,000 for the year ended December 31 Year 2. The fair value of A Company's common stock was $27 per share on December 31 , Year 1 and $28 per share on December 31 , Year 2. Assume that Tests Company held no other investments during Year 1 or Year 2. Determine the amount that pretax income would increase (decrease) in Year 2 as a result of the investment. Give your answer using dollar signs and commas but not decimals (cents). Example: $12,345 or $(12,345) Selected Answer: x [None Given] THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 32 - 33. On September 1, Year 1, Test Company purchased 2,000 shares of A Company common stock for $25 per share. The investment represents a less than 1% ownership interest. On the date of acquisition, the fair value of A Company's net assets exceeded the book value by $100,000. The amount is attributable to buildings with a remaining useful life of 10 years. During both Year 1 and Year 2, A Company paid dividends of $0.50 per share. A Company reported net income of $2,000,000 for the year ended December 31 , Year 1 and $2,100,000 for the year ended December 31 Year 2. The fair value of A Company's common stock was $27 per share on December 31 , Year 1 and $28 per share on December 31 , Year 2. Assume that Tests Company held no other investments during Year 1 or Year 2. Determine the amount that pretax income would increase (decrease) in Year 1 as a result of the investment. Give your answer using dollar signs and commas but not decimals (cents). Example: $12,345 or $(12,345) Selected Answer: x [None Given] Correct Answer: stion 33 0 out of 3 points THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 32 - 33. On September 1, Year 1, Test Company purchased 2,000 shares of A Company common stock for $25 per share. The investment represents a less than 1% ownership interest. On the date of acquisition, the fair value of A Company's net assets exceeded the book value by $100,000. The amount is attributable to buildings with a remaining useful life of 10 years. During both Year 1 and Year 2, A Company paid dividends of $0.50 per share. A Company reported net income of $2,000,000 for the year ended December 31 , Year 1 and $2,100,000 for the year ended December 31 Year 2. The fair value of A Company's common stock was $27 per share on December 31 , Year 1 and $28 per share on December 31 , Year 2. Assume that Tests Company held no other investments during Year 1 or Year 2. Determine the amount that pretax income would increase (decrease) in Year 2 as a result of the investment. Give your answer using dollar signs and commas but not decimals (cents). Example: $12,345 or $(12,345) Selected Answer: x [None Given]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The International Corporate Governance System Audit Roles And Board Oversight

Authors: F. Lessambo

1st Edition

134947178X, 978-1349471782

More Books

Students also viewed these Accounting questions

Question

Write formal and informal proposals.

Answered: 1 week ago

Question

Describe the components of a formal report.

Answered: 1 week ago

Question

Write formal and informal reports.

Answered: 1 week ago