Financial Statements
The Vertex42™ collection of financial spreadsheets includes templates designed specifically for small business owners. We hope that you will find them as useful as we have! The spreadsheets featured below also work with OpenOffice and Google Spreadsheets, so if you are operating your business on a very tight budget, hopefully you'll be able to make these financial templates work for you.
Financial Statement Templates
Business Plan Workbook ▶
Create a business plan using Word with a companion Excel workbook for customizing financial statements.
Income Statement Template ▶
Provides a measure of economic performance for your company. Also called a Profit and Loss Statement
Business Budget Template ▶
Contains two worksheets for creating a yearly business budget - for service providers or companies producing and selling goods. Based on the Income Statement template, with similar categories and layout.
Business Budget and COGS Analysis ▶
Perform a detailed analysis of expenses and cost of goods sold (COGS) for multiple products.
Break Even Analysis Calculator ▶
Calculate the Break-Even Point or Payback Period for a new venture or product.
Profit and Loss Projection Template ▶
Based on the Business Budget template - helps you create a 3-year profit and loss projection.
Sales Forecast Template ▶
Create a sales forecast spreadsheet to use in your business plan, including estimated sales, COGS, and gross profit on a monthly basis over 3 years. Includes sample charts.
Business Startup Costs Template ▶
Estimate the startup costs for your new business. Essential for any business plan.
Depreciation Schedule Template ▶
Calculate yearly depreciation for multiple assets using the straight-line or declining balance methods.
Billing Statement Template ▶
A billing statement can be used as an invoice as well as an accounts receivable ledger. This works well as a customer account statement. It can also be used to bill a customer.
Personal Financial Statement ▶
Create and maintain your own personal financial statements, including a balance sheet for calculating net worth and a cash flow statement for budgeting.
Net Worth Calculator for Excel ▶
Calculate your net worth based on the total of all your assets minus your liabilities.
Petty Cash Log Template ▶
Customize and print a petty cash form for your business. Includes a reconciliation section.
SWOT Analysis Template ▶
Use a SWOT Analysis to routinely evaluates the health or your business or personal finances and find ways to grow and improve.
More Financial Statements
- NPV Calculator - A simple spreadsheet to help calculate Net Present Value and Internal Rate of Return of various investments.
- Financial Management Templates at templates.office.com - The new Microsoft Office® templates gallery has a few financial statements.