Business Growth Specialists/Finance Expertise
Our specialists have extensive experience in accounting and banking. Their expertise will benefit you in many ways:
- Ensure financial records are accurate
- Prepare loan packages for submission to banks
- Compare financials to industry benchmarks identifying areas of improvement
- Use financials as a tool to manage the business
- Develop “what-if” scenarios for financial impact on the business for new initiatives or ROI
- Complete annual budgeting
- Implement cash management
- Leverage lending relationships
The information and tools provided below will help you better understand and manage the financial structure of your business.
Cash Flow Spreadsheets
Underlying your narrative plan documents are the financials. The financial picture is your ultimate reality check. Can your business generate income and achieve your financial goals? Several cash analysis spreadsheets are included for your use, from blank forms for your input to examples of completed financial plan documents.
Yearly Cash Flow Projection and Variance Analysis (.exe)
This spreadsheet, which requires Microsoft Excel, was developed using SBA form OMB No. 3245-0019 as a model. Changes were made to subtotal variable expenses and segregate them from fixed expenses, add a % of sales column, and automatically compute total fixed costs, contribution margin, and break-even sales. Also, the file contains a worksheet for Year 2 and worksheets for variance analysis. Var, Y1, Q1 relates to year one’s cash flow projection, the first three months with subsequent quarters, and month by month found under the appropriate tab.
The formulas in the worksheet are not protected. Be careful not to enter data in cells that have formulas.
Using the Template
- Save the spreadsheet as a new file. From the file menu select:
File>Save As>Type in a new name for the file
- Project your sales month by month:
Fill in Line 57, Sales Volume under Month 1 through Month 12 (Columns C through N, inclusive).
- Decide if you will be receiving cash for the sales listed at the bottom on line 57, or if you will be selling on account.
Copy Line 57 to Line 8 Cash Sales or Line 9, Collections from Credit Accounts (as appropriate).
- Enter variable expenses.
Fill in lines for appropriate variable expense using a formula to establish the expense as a percentage of sales. For example, to record Materials as 60 percent of sales, type + .6*C57. Then copy the formula across.
- Fill in the fixed expenses as indicated.
Whereas, variable expenses were entered as a formula and as a percentage of sales, use absolute dollar amounts for the fixed expenses. For example, if rent is $1500 per month, enter the numerals 1500 in the appropriate cells.
Income and Expense Calculations- Child Care Business (.exe)
Use this blank spreadsheet, which requires Microsoft Excel to open, to help calculate income and expenses.
Know Your Numbers Workshop
This program is designed specifically for CEO’s who seek improved financial skills. (Register for this training on Business Workshops)
This workshop provides the business owner an in-depth look at the essentials of using financial information to make effective decisions about improving their business performance.
Who should attend: CEO’s of businesses with at least 3 years of financial history who want to have a better understanding of how financial statements can inform their business decisions.
- Ways to improve your company’s cash flow
- How to use the balance sheet and income statement to diagnose business problems and opportunities
- How break-even analysis helps you make better pricing and investment decisions
- How to ensure you have enough working capital to support growth
- How to keep your banker on your side
Special offer: Participants in this workshop will receive priority access to the MI-SBDC Fiscal Fitness Counseling Program which helps you make an in-depth analysis of your own business financials.
Financial Management Analysis
The owners of small businesses often cite access to capital as their most dire need. Financial Management Analysis is a one-on-one, confidential counseling process is designed to strengthen your financial literacy and improve your ability to access the capital you need to grow your business.
As a result of participating in the Financial Management Analysis, you will be able to:
- Use your income statement and balance sheet to understand your company’s financial strengths and weaknesses
- Identify ways to improve your company’s cash flow
- Determine the capital needs associated with your planned growth
- Create an effective loan proposal to address your capital needs
- Benchmark industry ratios
We think the Financial Management Analysis will offer you an opportunity to gain stronger control of the financial aspects of your business and improve your opportunity to access the capital you need. We welcome the opportunity to support you.