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.

Advertisement

Financial Statement Templates


1

Business Plan WorkbookBusiness Plan Workbook ▶

Create a business plan using Word with a companion Excel workbook for customizing financial statements.

2

Balance Sheet TemplateBalance Sheet Template ▶

Summarize what your company owns and owes. Compare to previous year(s).

3

Income Statement TemplateIncome Statement Template ▶

Provides a measure of economic performance for your company. Also called a Profit and Loss Statement

4

Cash Flow Statement TemplateCash Flow Statement Template ▶

Where does your company get and spend its cash?

Advertisement
5

Business Budget TemplateBusiness 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.

6

12-Month Business Budget12-Month Business Budget ▶

Create a 12-month breakdown of your sales and business expenses.

7

Business Budget and COGS AnalysisBusiness Budget and COGS Analysis ▶

Perform a detailed analysis of expenses and cost of goods sold (COGS) for multiple products.

8

Break Even Analysis CalculatorBreak Even Analysis Calculator ▶

Calculate the Break-Even Point or Payback Period for a new venture or product.

9

Profit and Loss Projection TemplateProfit and Loss Projection Template ▶

Based on the Business Budget template - helps you create a 3-year profit and loss projection.

10

Sales Forecast TemplateSales 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.

11

Business Startup Costs TemplateBusiness Startup Costs Template ▶

Estimate the startup costs for your new business. Essential for any business plan.

Advertisement
12

Depreciation Schedule TemplateDepreciation Schedule Template ▶

Calculate yearly depreciation for multiple assets using the straight-line or declining balance methods.

13

Billing Statement TemplateBilling 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.

14

Personal Financial StatementPersonal 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.

15

Net Worth Calculator for ExcelNet Worth Calculator for Excel ▶

Calculate your net worth based on the total of all your assets minus your liabilities.

16

Petty Cash Log TemplatePetty Cash Log Template ▶

Customize and print a petty cash form for your business. Includes a reconciliation section.

17

SWOT Analysis TemplateSWOT Analysis Template ▶

Use a SWOT Analysis to routinely evaluates the health or your business or personal finances and find ways to grow and improve.

18

Waterfall Chart TemplateWaterfall Chart Template ▶

Create a horizontal or vertical waterfall chart using Excel.

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.

Follow Us On ...

FB  PIN  TWEET  LI  IG  YT 
Template Categories

   Share: