Friday, November 21, 2008

Home
Services
Projected Financial
Statements.com

Announcements
Contact Us
Recommended links
Heroes and Bullies





Projected Financial Statements.com

Enter financial data and assumptions, and get projected financial and 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.
  • Small Business plan:
    Click Here to Purchase Online!
    This Financial Modeling tool is designed to work for almost any business: Service, Construction, Manufacturing, Retail, etc.. There are 20 categories of General and Administrative Expenses.
  • Custom Business plan:
    We will customize the template for your unique business or reporting needs. Formula and logic changes are charged based on the time needed to perform the work.
  • To busy to prepare the first draft?
    Send us your historical financial statements - including employee census data. We'll 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.
Please contact us if you are interested in hearing 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