Question
Background Crane Harbour is an American paper manufacturer producing both newsprint and fine papers for customers in North America and around the world. The past
Background
Crane Harbour is an American paper manufacturer producing both newsprint and fine papers for customers in North America and around the world. The past few years have been challenging for MPI because of the headwinds in the printing industry. Daily newspapers are facing declining readership as more people get their news from online sources. Demand for fine paper has also fallen, as fewer people print documents at work. As demand for paper has fallen, so have the fortunes of the company. After a particularly poor performance in 2018, the CEO, Simon Smith was removed by the board. A lifelong employee, Smith had worked his way up from the warehouse to become CEO in 2003. Smith was known as a very conservative manager. His strategy included the use of a significant cash cushion, parked in marketable securities. Crane Harbour drew on the cash when the company faced unexpected shortfalls, but it was expensive insurance. Over the past several years, the marketable securities paid next to no interest. Consistent with his cautious approach, Smith had responded to the most recent downturn in demand by paying down the companys revolving debt and renegotiating the interest on the companys outstanding debt. While the board noted Smith success in renegotiating the companys debt to cut interest expenses, he was not able to enjoy the fruits of his labours. After the company announced a loss of $2.60/ share at the 2018 annual general meeting, Smith was replaced by Hunter Lee, and he was given a mandate to return the company to profitability within five years.
In contrast to Smith, Lee has a reputation as a relentless competitor, who is unafraid to take risks. His reputation as a skilled turnaround artist is well deserved. He has successfully revived other firms and the board of Crane Harbour fully supports her agenda. One of her first acts as CEO was to liquidate the companys marketable securities. In one particularly pointed interview on BTS, Lee exclaimed Cash is trash! and he went on to explain that her predecessor had been overly cautious, and her team was not afraid to use debt responsibly. We arent reckless, but debt has a place in any organization. No company should be holding onto cash in a low interest environment. It isnt a life preserver. It is a millstone around the companys neck. He cut headcount to streamline operations and control costs and he made some immediate changes to the companys paper pricing strategy. He argued that Crane had the market power to raise prices, despite the challenging demand slump. Her strategy was met with consternation by her sales team, but he was unmoved. He also slashed trade credit, pointing out that Crane was financing the newspapers. In another colourful conference call with analysts after taking the reins, he stated, We are not the First National Bank of Spilled Ink! We value our customers, but we have a business to run and we can use the money internally. The newspaper men need to control their costs, just like we will.
In her most recent conference call with analysts, he commented on the success of her strategy. In 2018, I was brought in to turn this company around and I am proud to report that, for the first time in several years, Crane is profitable again. We have accomplished much, but our work is not done. I am committed to generating sustainable revenue growth of 5% annually for Crane. I know our share price isnt where it deserves to be, based on our performance but I am confident that we are on the right path. Our future is bright.
Deliverables
- Create a set of linked historical financial statements in Excel (including income statement, balance sheet and cash flow statement). Make sure your model is formatted appropriately (all formulas are the same colour; all constants are coded the same way; all off-sheet links are coded consistently.) Your spreadsheet model should be professional and easy to understand for the user. Include a title page or header. Use a legend so I know what your colour coding convention means.
- Create a suite of ratios to analyze the company's performance. I leave it to you to decide which ratios to include, but the list on page 53 of your text is a good starting place. Calculate the sustainable and internal growth rate for Crane in 2021.
- Project the financial statements over the next five years, using the forecast factors provided by the firm. Use a combination of the revolver (short-term debt) and marketable securities to balance the balance sheet. If the firm generates more revenue than it needs, it goes into marketable securities. If the firm needs external financing assume it is borrowed from its revolver (credit line) at the bank. The limit on the revolver is $250 million dollars. Neither marketable securities nor the revolver should become negative.
- Calculate the sustainable and internal growth rate for Crane in 2021. What does the calculation tell you about the firms stated growth target?
- Write a brief report describing the performance of Crane over the past five years. Basically, interpret the ratios you produced in step 2. Then comment on the forecasted financial statements. Pay particular attention to the reasonableness of the forecast factors. Do some sensitivity analysis. Two pages, single spaced, 12 fonts. Your written report must not exceed two pages, excluding the cover page, and any appendices The format and content of your report is left to your discretion, but this is a professional report and should be written in a style that is suitable for senior management in an organization. Make sure your work is free of typos or awkward prose that may detract from your analysis.
Forecast Assumptions
Income Statement:
Sales: Management is divided on whether further price increases are feasible. As a base case, you are asked to assume that prices will not change, but volume will increase by 5% annually (for both types of paper.)
Gross Profit margin: 10% of sales each year
SG&A margin: 5% of sales each year
Depreciation: = 5.4% of current year net fixed assets, but it should not be greater than EBITDA and it should not be negative. Hint: try wrapping a MAX function around a MIN function in Excel.
Interest Expense: The interest rate on the revolver (short-term debt) and long-term debt is 4%. For simplicity, assume the interest this year is calculated on last years ending balances.
Income Tax Rate: 33% of Pre-tax Income. Assume the company does not pay any tax if Pretax Income is less than zero.
Common Stock: The Company does not plan to issue or buy back any shares. Assume that the Price /Earnings ratio will be 17 going forward this will let you estimate a stock price for future periods. The company does not plan to pay any dividends during the projection period.
Balance Sheet:
Cash: 3% of sales
Accounts Receivable: Assume A/R Days is 64 days for the forecast period.
Inventory: Assume an inventory turnover of 3.5X.
Other Current Assets: 1% of sales
Gross Property, Plant and Equipment: Assume that capital expenditures will be zero for the next 5 years. In other words, Gross PP&E is 654487.1 for every year in the forecast period.
Other Long-Term Assets: will be 17% of sales.
Accounts Payable: Assume days payables outstanding will be 48 days. (Use Average COGS, not Sales)
Long Term Debt: The company will continue to pay down $30,333.30 every year. This is part of their agreement with their bank.
Deferred Taxes and Other Liabilities: will remain constant for the next 5 years. Just project the 2021 value across the forecast period.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started