Answered step by step
Verified Expert Solution
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?
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started