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.
AdvertisementCreate a business plan using Word with a companion Excel workbook for customizing financial statements.
Summarize what your company owns and owes. Compare to previous year(s).
Provides a measure of economic performance for your company. Also called a Profit and Loss Statement
Where does your company get and spend its cash?
AdvertisementContains 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.
12-Month Business Budget ▶ Create a 12-month breakdown of your sales and business expenses.
Business Budget and COGS Analysis ▶ Perform a detailed analysis of expenses and cost of goods sold (COGS) for multiple products.
Calculate the Break-Even Point or Payback Period for a new venture or product.
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.
Estimate the startup costs for your new business. Essential for any business plan.
Advertisement
Depreciation Schedule Template ▶ Calculate yearly depreciation for multiple assets using the straight-line or declining balance methods.
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.
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.
Use a SWOT Analysis to routinely evaluates the health or your business or personal finances and find ways to grow and improve.
Create a horizontal or vertical waterfall chart using Excel.
Vertex42.com
The Guide to Excel in Everything
Vertex42® is a registered trademark of Vertex42 LLC. Microsoft® and Microsoft Excel® and Microsoft Word® are registered trademarks of Microsoft Corporation. Vertex42.com is not associated with Microsoft.
Free Financial Statements - Balance Sheets, Cash Flow, Income Statements, etc.
