Thursday, August 21, 2008
Home
Services
Projected Financial
Statements.com

Announcements
Contact Us
Recommended links
Heroes and Bullies








Services

We provide a full range of services for growing businesses. We can perform any of the following services for your company:
  • Accounting and Bookkeeping
  • Senior Executive Recruiting
    We help Medium size companies find qualified board members. Please contact us if you have a proven track record, and you are qualified to serve a company with 50mm to 250mm in sales.
  • Strategic Business planning
  • Financial and Cash Flow projections
  • Internal Control analysis and implementation
  • Tax planning and Tax preparation
  • 401(k) plan testing and administration
  • Compilation, Review and Auditing Services - Attestation.

Free Business Tools

The following tools are free of charge.
Input fields are highlighted in yellow.
Before downloading these tools, you must agree to the following license terms:
Each product is licensed for one business only. It is not to be (given to, resold to, or used by) any other entity without written permission from Gruber and Company, Inc. If you like these tools, you'll love this; but it's not free:


Projected Financial Statements

Enter financial data and assumptions, and get projected financial cash flow information instantly:
  • Balance Sheet, Income Statement, and Direct Method Cash Flow Statement.
  • Monthly Projections for the first year, and annual projections for the next 2 years.
Produce statements in-house that will give you credibility with banks or with upper management.
Please contact us with questions, or click the icon below to see a sample report for a professional firm.
You won't find a more comprehensive and user-friendly projection tool anywhere else.
We offer several single-company license options.
  • Generic Small Business plan:
    Purchase this Template Online
    This Spreadsheet program is designed to work for almost any business: Service, Construction, Manufacturing, Retail, etc.. There are 20 categories of General and Administrative Expenses.
  • Industry-Specific Business Plan:
    Let us know what industry you are in, and we'll send you a sample report from a template designed for your industry. If you are satisfied with the report format, we'll sell you the template.
  • Custom Business plan:
    Send us your historical financial statements - including employee census data. We'll design a template around your financial statement format, enter your financial data into the template and send you the file. The only thing left would be to update your projected assumptions: Headcount, cost, etc.
    This customization does not include changes in (revenue or expense) projection formulas. Formula and logic changes are charged based on the time needed to perform the work.
Please contact us if you are interested in learning more about these license options.


The Development History of our Projection Tool:

This business planning architecture is a time-tested tool. It has been updated and perfected many times over the last 20 years. The original prototype was developed by a team of 3 professionals - A Ph.D in math, a semi-retired software developer, and a CPA.

The first prototype:
We theorized that each component of (income, expense, and cash flow) could be expressed as an algorithm. If the formulas are sound, then financial activity could become predictable based on a set of assumptions.

Our goal was to create a projection that was uncomplicated, predictive and professional looking.
Uncomplicated so we could make changes quickly without re-doing formulas or reconfiguring the spreadsheet.
Predictive so it would be useful as a budgeting tool and an accurate predictor of cash flows and financial activity.
Professional looking so we could proudly present it to investors and bankers.

Our efforts were very successful. Our internally generated projections were used to expand our line of credit by over 1,000%, to value the business for a possible IPO, and to streamline the internal budgeting process.

Our newest version:
Gruber and Company has been using this tool since the early 90s. Over the last 6 months, we have worked very hard to make it user-friendly enough to be used by anyone:

  • Input cells are shaded in yellow. You can enter up to 3 years of historical financial data. the more data you enter, the more sophisticated it becomes. You can even enter your depreciation schedule.
    Historical financial data is not required. If your company is just starting out, and you have no financial history, this projection will still work very well.

  • Projected financials are based on a number of variables including headcount, hourly rates, expected sales, etc. Sales can be expressed as a multiple of production staff (and the expected business cycle) if appropriate.
    For example, if you add employees, you automatically buy a desk, a chair, hardware, and software; office expenses become incrementally more expensive; The depreciation schedule is updated; the cost of the Christmas party and the summer picnic goes up; you get the idea.

    This projection tool has been a valuable asset to our firm and our clients. We know it will help you gain credibility with the bank, create fantastic proposals, and help with internal decision-making by quantifying business options to see if they make financial sense.




    • Click here to Post A Job