Easy-to-use, simple to understand, and free(!) small business spreadsheet templates. Quickly download and plug your business’ information in.
These small business spreadsheet templates come with detailed walkthroughs explaining what the numbers mean, why they matter, and how to understand them.
These concepts will help you manage your business more effectively. You can’t manage what you don’t understand. Make educated decisions.
Don’t be intimidated – everything is explained in detail and the calculations are done for you.
Just plug in your numbers and get answers!
Strategic planning
CAPITAL BUDGETING WORKBOOK
This priceless workbook will calculate the net present value (NPV), payback period, and other valuable metrics. Use this to rank potential projects and to make smart long-term decisions for your business. This workbook provides a very detailed analysis – factoring in variables such as depreciation, taxes, asset disposition, and much more.
OPERATING BUDGET WORKBOOK
Yep, this is a big and complicated workbook. Taking the time to walk through this will tell you now if you can expect to be profitable next year. Sure, things will change, but planning now will give you the opportunity to face challenges head-on. Get a pro forma income statement and ratios for the next fiscal year.
FINANCIAL BUDGETING WORKBOOK
Cash is the lifeblood of your business. You can make sales all day long, but if you’re sending more cash out the door than you’re bringing in – you’re done for. Use this financial budget to forecast, and plan for, any cash shortfalls (or excesses). Round out your planning for the next fiscal year.
Quantitative methods
FORECASTING
We all want to know the future. This workbook won’t win you the lottery, but it will help you predict the future of your business’ sales (or whatever else you want to know). Also, you’ll gain valuable insights into what truly drives sales. All you need to do is plug in the historical information that you already have.
LINEAR PROGRAMMING
It doesn’t take much more effort to do things perfectly than it does to do them “okay.” But, only if you know what “perfectly” is. You’ve probably never heard of linear programming. What it does, though, is find optimum solutions for things such as profit maximization, cost minimization, and any other problem that can be perfected.
EXPECTED VALUE
Making smart decisions is hard enough. But, what if you have to consider multiple scenarios too? Don’t make assumptions and just “go with your gut.” Use this worksheet to think through and quantify the decisions to be made and the scenarios that might affect them.
MONTE CARLO SIMULATION
Channel your inner fortune teller. See every possible outcome before it happens. Know what your best-case and worst-case scenarios are so that you can protect your business’ downside.
Cost Management
JOB ORDER COSTING
A costing template for contractors, consultants, and any other business that offers a (semi) custom product or service. Tracks and totals material, labor, and overhead to determine job profitability.
PROCESS COSTING
A costing template for manufacturers or any other business that makes a lot of the same product. A process costing system allows your company to compare costs, WIP, and inventory balances over time. Plus, it provides transparency into what departments are contributing the most to costs.
ACTIVITY-BASED COSTING
Activities are what drive costs in your organization. So, why not apply costs to individual products based on how much activity they demand? This is one of the most comprehensive and accurate costing systems there is. Understand the true profitability of each of your products and gain insights that you didn’t think were possible, with this workbook.
Performance Measurement
VARIANCE ANALYSIS
Don’t just create an operating budget and let it collect dust! Use it to find strengths, weaknesses, opportunities, and threats. How? By comparing actual results to your original budget. You’ll be surprised by the insights that can be uncovered. Was revenue, material costs, labor costs, or overhead costs above or below your budgeted amount? Why?
Corporate Finance
MANAGING CURRENT ASSETS & LIABILITIES
Having a healthy ratio of current assets to current liabilities is important for your small business to stay solvent. Like most things, the accounts that make up current assets/liabilities (cash, inventory, AR, AP) can be optimized. This workbook transforms a couple of simple inputs into information that will help you keep your small business healthy.
WEIGHTED AVERAGE COST OF CAPITAL (WACC)
Knowing your small business’ weighted average cost of capital (WACC) will help you know the minimum return you can accept for any project you undertake. This workbook will help you estimate the cost of equity and after-tax cost of debt.
Decision Analysis
BREAK-EVEN ANALYSIS
Performing a break-even analysis will tell you what level of sales your small business will need to reach in order to start turning a profit. You can then decide if that level of sales is feasible. This workbook will perform the calculations for you and present break-even amounts in units and dollar sales.