Excellence Equipment Corporation is a public Canadian company manufacturing highly specialized equipment. On January 1, 2017,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excellence Equipment Corporation is a public Canadian company manufacturing highly specialized equipment. On January 1, 2017, Excellence issued a 12%, $10,000,000 bond, maturing in 10 years. At January 1, 2020, the bond had a carrying value of $9,300,000. Interest is payable semi-annually on June 30 and December 31. The company uses the straight-line method of amortizing any bond premium or discount. The bond carries covenants that call for the firm's debt to total assets ratio to be no higher than 50% and their times interest earned ratio to be at least 2. You are the CEO of Excellence. You have been on the job for a year after the previous CEO was fired for missing earnings targets. You are a CPA and MBA with a major in Accounting. Excellence's business is cyclical and the last two years have been tough. In recent months however, there have been signs of recovery in the industry, and many distributors have placed large orders for Excellence's equipment. Delivery of the equipment is expected in 2021 and 2022. You are under pressure from the board of directors to show improvement in the bottom line. It is now November 30, 2020, and you have just met with the company's CFO, Ms. Bean. In preparation for the coming year end on December 31, 2020, she has prepared forecasted financial statements, but has not included the effects of the $ 10,000,000 bond issue. Below is a summary of those statements: Income Statement Sales COGS Gross profit Operating expenses Operating income before interest expense Bond interest expense Income before income tax Income tax (35%) Net income $ 28,000,000 20,000,000 8,000,000 5,465,000 2,535,000 ? ? ? ? Statement of financial position Current assets Non-current assets Total assets Current liabilities Bonds payable Shareholders' equity Total liabilities and equity 14,700,000 22,000,000 36,700,000 9,000,000 ? ? 36.700.000 Additional Information a. Except for the bond, the company did not incur any other interest expense. b. The last time entries were recorded for the bond was at the end of the third quarter (September 30, 2020), when adjusting entries were prepared. Required a. Prepare the journal entries related to the bond payable for the last quarter of 2020. The entries should reflect the payment of interest and related amortization of the premium or discount. b. Complete the forecasted financial statements for December 31, 2020 by including the effects of the bond payable. c. Using the financial statements from part b), calculate the times interest earned and debt to total assets ratios. d. Given your calculations in part c), is Excellence forecasted to be in violation of the debt covenants? If yes, what action(s) would you recommend? Discuss the advantages/disadvantages of each recommendation. Excellence Equipment Corporation is a public Canadian company manufacturing highly specialized equipment. On January 1, 2017, Excellence issued a 12%, $10,000,000 bond, maturing in 10 years. At January 1, 2020, the bond had a carrying value of $9,300,000. Interest is payable semi-annually on June 30 and December 31. The company uses the straight-line method of amortizing any bond premium or discount. The bond carries covenants that call for the firm's debt to total assets ratio to be no higher than 50% and their times interest earned ratio to be at least 2. You are the CEO of Excellence. You have been on the job for a year after the previous CEO was fired for missing earnings targets. You are a CPA and MBA with a major in Accounting. Excellence's business is cyclical and the last two years have been tough. In recent months however, there have been signs of recovery in the industry, and many distributors have placed large orders for Excellence's equipment. Delivery of the equipment is expected in 2021 and 2022. You are under pressure from the board of directors to show improvement in the bottom line. It is now November 30, 2020, and you have just met with the company's CFO, Ms. Bean. In preparation for the coming year end on December 31, 2020, she has prepared forecasted financial statements, but has not included the effects of the $ 10,000,000 bond issue. Below is a summary of those statements: Income Statement Sales COGS Gross profit Operating expenses Operating income before interest expense Bond interest expense Income before income tax Income tax (35%) Net income $ 28,000,000 20,000,000 8,000,000 5,465,000 2,535,000 ? ? ? ? Statement of financial position Current assets Non-current assets Total assets Current liabilities Bonds payable Shareholders' equity Total liabilities and equity 14,700,000 22,000,000 36,700,000 9,000,000 ? ? 36.700.000 Additional Information a. Except for the bond, the company did not incur any other interest expense. b. The last time entries were recorded for the bond was at the end of the third quarter (September 30, 2020), when adjusting entries were prepared. Required a. Prepare the journal entries related to the bond payable for the last quarter of 2020. The entries should reflect the payment of interest and related amortization of the premium or discount. b. Complete the forecasted financial statements for December 31, 2020 by including the effects of the bond payable. c. Using the financial statements from part b), calculate the times interest earned and debt to total assets ratios. d. Given your calculations in part c), is Excellence forecasted to be in violation of the debt covenants? If yes, what action(s) would you recommend? Discuss the advantages/disadvantages of each recommendation.
Expert Answer:
Answer rating: 100% (QA)
Question The forecasted statement are showing that the times interest earned ratio may go below 2 Ho... View the full answer
Related Book For
Financial Reporting and Analysis
ISBN: 978-1259722653
7th edition
Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
You are the assistant controller for StrongBar Ltd., a company that specializes in making energy bars and other high-protein snacks. The companys CFO, Diana Cash, has just stopped by your office. She...
-
1.) On January 1, 2014, Jack Company issues $3,744,000, 6%, 10-year bonds for cash of $3,013,464 when the market rate of interest is 9%. The bonds pay interest semi-annually on June 30 and December...
-
Creativity and Innovation Management (Feb. 2008) published an article on identifying the social network characteristics of lead users of children's computer games. Data were collected for n = 326...
-
Grape Corporation has placed a term loan request with its lender and submitted the following balance sheet entries for the year just concluded and the pro forma balance sheet expected by the end of...
-
Using Bloomberg, what is the current price and yield on a 30year Treasury bond? Is the bond selling above or below par? Is the yield to maturity (current yield) above or below the coupon rate? What...
-
\(X\) is the number of bits in error in the next four bits transmitted. What is the expected value of the square of the number of bits in error? Now, \(h(X)=X^{2}\). Therefore, \[ \begin{aligned}...
-
A government permits its employees to accumulate all unused vacation days and sick leave. Whereas (in accord with current standards) it may have to book a liability for the unused vacation days, it...
-
! Required information [The following information applies to the questions displayed below.] Camille Sikorski was divorced in 2018. She currently provides a home for her 15-year-old daughter Kaly....
-
Uber Technologies, Inc., is a ridesharing provider. In its 2019 annual report, the company reported deferred tax assets totaling about $11,230 million. The company also reported valuation allowances...
-
1. A young person is having a sensory problem. A good friend recommends that this person visit an audiologist, who, in turn, referred this person to an otorhinolaryngologist. The...
-
What is meant by "new regionalism"? Detail an example of an area that has adopted new regionalism where it has been successful. Detail an example of an area that has adopted new regionalism where it...
-
A few noted issues within group dynamics include role management, equity, and fairness. In the past, how has working in a group affected your outlook for future partnerships? Has your experience led...
-
Describe how Kurt Lewin's three-step model of change and the primary goal of this action research technique in group dynamics.
-
Thinking back on an incident that had occurred at your place of work, how do you believe you could have made an impact on the outcome? Do you believe the individuals who conducted the investigation...
-
Diversity can be a great benefit for a project or company. What types of skills or knowledge should a project manager consider when selecting a project team member? What do you believe are the...
-
For Culver Company, the budgeted cost for one unit of product is direct materials $8, direct labor $16, and manufacturing overhead 75% of direct labor cost. If 22,500 units are expected to be sold at...
-
Solve each problem. Find the coordinates of the points of intersection of the line y = 2 and the circle with center at (4, 5) and radius 4.
-
On December 31, 2017, Ball Company leased a machine from Cook for a 10-year period, expiring December 30, 2027. Annual payments of $100,000 are due on December 31. The first payment was made on...
-
Lufthansa Group operates an international airline based in Germany. Lufthansa files its annual reports under International Financial Reporting Standards (IFRS). In its 2012 Annual Report to...
-
The following inventory note appears in General Electric's Year 3 annual report. General Electric Company Edited Inventory Note LIFO revaluations decreased $70 million in Year 3, compared with...
-
Consider the situation illustrated in Figure 25. 11. A positively charged particle is lifted against the uniform electric field of a negatively charged plate. Ignoring any gravitational interactions,...
-
A positively charged particle is moved from point A to point B in the electric field of the massive, stationary, positively charged object in Figure 25. 12. (a) Is the electrostatic work done on the...
-
Two metallic spheres A and B are placed on nonconducting stands. Sphere A carries a positive charge, and sphere B is electrically neutral. The two spheres are connected to each other via a wire, and...
Study smarter with the SolutionInn App