Article by Roger Schlueter, MBA
Companies looking for Financing have many problems that they need to overcome. Some of these problems are common and some problems need a little creating problem solving to overcome them. Most good financial people and banks will always start the analysis of a financial need with a Financial Analysis of the companies financial statements.
The financial analysis is always started with a Spread of the companies financial statements. This is pure grunt work and is usually accomplished in a few minutes or hours depending on the complexity of the financial statements, the number of years analyzed and any changes made to the format of the financials themselves. This is mind numbing enough if the analysis is one company and three years financial statements. Sometimes the analysis is five years and then the individual or company has other companies which are related or connected in some way. Then the analysis can be a combination of Watching the Grass Grow or the Paint Dry and the most boring three hour lecture that you ever had in college.
The way I start the spread of a company that will take many hours of pure grunt work is to buy a six pack of tallboys and a bag of Snyders Sourdough Nibblers and Hunker Down for a long protracted engagement.
The whole idea of the Spread Sheet of the financial statements is to do three things:
1) Spot Trends in Sales, Earnings, or Expenses
2) Check Ratios – Cash Ratios, Debt Ratios, and Expenditure Ratios
3) Analyze Cash Flow and end up with a Coverage Ratio for your debt
I will always spread each company on its own for three to five years. The spreadsheet is a good tool to create the sales and expense projections that will also be needed. The projections and cash flow statements need to be done for each company before putting them together to create the End Result of the combined entity that will pay the debt service of your loan from the bank.
When you have several companies owned by the same person or entity, they may all be run out of the same physical location and managed by the same people. Decisions are probably made by the same people and when getting a loan for Assets that can benefit several companies, it is wise to put the spreadsheets together for that purpose. This is because, on their own they probably do not have the wherewithal to buy the building or equipment, but together they have ample cash flow and capacity to make the deal happen.
Lets start with an Example:
I’m working with a individual that has a total of four companies. Two of the companies are slow growth companies and had problems during the 2008-2010 Recession. they may still may make money but it would be unwise to put all your assets into an entity that may become obsolete or could go out of business in a few years. One of the companies has had exceptional growth and profits over the last three years. They owners have also started a forth company that is related to the high growth company but was only recently created and has only three months of operating financials.
The owners want to buy a building that would house all four companies but the main reason for the new location is so the High Growth Company and the Newly Created Company can operate more efficiently and grow to their true potential.
The spreadsheet is done on all four companies, really three with the newly created company not having any years to spread. Giving all four spreads to the banker caused problems because he may not understand the situation the way you want him to understand it. We decided to combine the High Growth company and the Newly Created company to show the new direction of the Owners. The Slow Growth companies were also combined to show a slower entity that still created cash flow but was not the focus of the New Direction the Owners wanted to go.
The two spreadsheets were both given to the banker and it showed the new direction with Growing Sales and Earnings and the Slow Growth entities that still had earnings. If we had combined all four spreads it would show an entity that was deteriorated and weakened by the Slower Growth Entities. Our Cash Flow was done with the High Growth and the Slow growth but also combined to show the Cash Flow available to pay debt service by all entities.
The bank has a spread and cash flow that shows the true potential of the High Growth company but also has a spread and a combined Cash Flow that shows the value added by the Slow Growth companies to the Cash Flow. The End Result of the combined Statement is enough Cash Flow to cover the Debt Service and a Coverage Ratio which impressed the banker. The banker could now see the direction of the company and the true Cash Flow Available to Pay Debt Service and was not bogged down or diluted by the Slow Growth companies.
Please address any questions to the Blog or email me at roger@rogerschlueter.com You can also get more contact info at my Website at
www.schlueterfinancial.com