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 26 - 27. On October 1, Year 1, Test
Can someone please help me solve these in excel?
THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 26 - 27. On October 1, Year 1, Test Company purchased $80,000,6% A Company bonds for $80,000. The bonds pay interest quarterly with the next interest payment due on January 1 . Test Company management plans to trade the bonds in the short term. The fair value of the bonds on December 31 , Year 1 was $90,000. On January 1 , Year 2, Test Company sold all of the bonds for $90,000. 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: $5,000 Correct Answer: I on 27 0 out of 3 points THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 26 - 27. On October 1, Year 1, Test Company purchased $80,000,6% A Company bonds for $80,000. The bonds pay interest quarterly with the next interest payment due on January 1 . Test Company management plans to trade the bonds in the short term. The fair value of the bonds on December 31, Year 1 was $90,000. On January 1 , Year 2, Test Company sold all of the bonds for $90,000. 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: $5,000 Correct Answer: THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 26 - 27. On October 1, Year 1, Test Company purchased $80,000,6% A Company bonds for $80,000. The bonds pay interest quarterly with the next interest payment due on January 1 . Test Company management plans to trade the bonds in the short term. The fair value of the bonds on December 31 , Year 1 was $90,000. On January 1 , Year 2, Test Company sold all of the bonds for $90,000. 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: $5,000 Correct Answer: I on 27 0 out of 3 points THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 26 - 27. On October 1, Year 1, Test Company purchased $80,000,6% A Company bonds for $80,000. The bonds pay interest quarterly with the next interest payment due on January 1 . Test Company management plans to trade the bonds in the short term. The fair value of the bonds on December 31, Year 1 was $90,000. On January 1 , Year 2, Test Company sold all of the bonds for $90,000. 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: $5,000 CorrectStep 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