Up Your Cash Flow 
Budgeting & cash flow forecasting software
Phone number 310-387-5403 Pacific
  • Home
  • Products
    • Up Your Cash Flow >
      • Product Features
      • Benefits
      • Sample Reports
    • Advisor Services
    • Free-Books To Download
  • Store
  • Support
    • Update Your File
    • How The Program Works
    • Benefits
    • Help Files
    • FAQ's
    • Contact Us
  • Company
    • About Us
    • Contact Us
    • Testimonials
    • Blog
  • Articles
    • Making More Money Helping Your Clients
    • Let's Begin The Forecasting Process
    • The Profit And Loss Forecast-Step 1
    • The Profit And Loss Forecast-Step 2
    • The Profit And Loss Forecast-Step 3
    • AP-AR Turnover Ratio
    • Inventory Turnover Ratio
    • Net Income To Net Sales Ratio
    • Net Income To Equity Ratio
    • Debt To Equity Ratio
    • Why Plan
    • Tough Blog
    • Importance Of The Balance Sheet
    • Business Financial planning A must
  • Blog
  • Business Planning Series
    • 1. Whose Business Is It, Anyway?
    • 2. How to Identify and Monitor the Key Financial Elements of Your Company
    • 3. Kill The Budget
    • 4. How to Foresee And Predict Your Financial Future
    • 5. The Dynamic Financial Planning Process
    • 6. Developing The Forecast
    • 7. Expenses
    • 8. The Cash Flow Forecast
    • 9. What Do You Do with Your Forecast Now That You Have One?
    • 10. In Summary
    • 11. What Do All the Numbers
    • 12. The Business Plan: We Must Plan For The Future
    • 13. Personal Planning Is a Must
    • 14. A Matter Of Minutes >
      • 15. A Final Word
  • Advisor Services
  • Special ADP Video On Planning
  • Library
Budgeting and Forecasting Software

THREE ITEMS NEEDED FOR AN EFFECTIVE FORECAST
 I have noticed over the years that budgets or forecasts prepared by a company’s internal staff tend to illustrate profit and loss without a cash flow or balance sheet forecast. They usually prepare a report that shows sales—less costs and expenses—profit, and that’s all. This is where budgeting and forecasting software makes the difference.
Not too long ago, I was asked to assist a company in the potential buyout of one of its competitors. My client was doing about $70 million in sales. It was a large and profitable company. I assumed the management of such a large company would be quite sophisticated on the financial side of the business and have some sort of budgeting and forecasting software. So I set up a meeting with their CFO.
I started the discussion, “Let me make sure I understand the purpose of the merger. You believe that there will be substantial efficiencies in payroll and cost reductions. And the merged company will be in a good position financially to pay down the additional millions of dollars in new debt needed to complete the transaction?”
The CFO’s response was quite positive.  “Have you prepared any P&L and/or cash flow forecasts as to what the anticipated cash flow requirements will be after the merger?” I asked.
“No,” was his quick response.  
Needless to say, I was quite surprised that no information was prepared to make certain they could sustain such a potentially large transaction. My immediate advice to the president of the company was to have the forecasts prepared so as to reveal any potential cash flow problems they might encounter as a result of the merger. He agreed.  
So why didn’t the CFO prepare them? The answer is simple. It’s too difficult and time consuming and they did not have access to a solid budgeting and forecasting software.
We were engaged to put together the forecasts. It took us about five hours. Two hours by my assistant and three for me. My three hours included a meeting with the CFO to get some additional assumptions. How were we able to complete them so fast? We used my secret weapon. The budgeting and forecasting software I created.  


The three reports needed for effective budgeting and forecasting are:
1. The twelve-month profit and loss. This report will let management know in advance if anticipated financial activities will produce a profit or not. It will also serve as a guide during the year as to whether expenses are under control or not. It is also great for looking at future tax requirements.
2. The twelve-month cash flow. This is the report that will let management know well in advance how much cash they will need and when they will need it.
3. Forecasted balance sheets for each month of the forecast. This report is the most neglected and is extremely important in the forecasting process. It tells you whether the other reports are realistic or not.

Several years ago, I was meeting with a client preparing a P&L and cash flow forecast. The company was profitable and had excellent cash flow. We sat in the client’s conference room working on the forecast. When we completed the preparation, we were quite pleased as to the forecasted profit and amazing cash flow prospects. Everything was going to be terrific. 
After reviewing the reports, we began to study the forecasted balance sheets. We both quickly realized there were major problems. The accounts receivable balances were forecasted lower than they had ever been. Payables balances were larger than they should have been, and inventory was forecasted too low. Basically, the balance sheet made no sense at all.  
Then it hit me like a ton of bricks. The balance sheet was telling us that the forecast was wrong. Obviously, the assumptions used to develop the cash flow were way off. Collection on accounts receivable balances was too rich, and the payment of the payables was not enough. The balance sheet was the barometer as to the efficacy of the other reports. If it made no sense, the other reports were wrong.


Copyright GoHagIt,Inc, Granville Software 2015,2016

Cash Flow Forecasting Software
| Business Budgeting Software | Business Budget Forecasting | Budgeting and Forecasting Software
 Financial Budgeting Software |  Business Budgeting | Cash Flow Analysis

.