Downloadable Excel Financial Spreadsheets

By on September 26, 2012 in Working Capital

 

Here’s 8 pretty fundamental financial spreadsheets that every small business needs to have. All are in excel. All are templates and all are downloadable.

 

This spreadsheet will help you to prepare a projected profit and loss account as part of your Operating Budget, in a format suitable for inclusion in your Business Plan. Download the Operating Budget Profit and Loss spreadsheet.
This spreadsheet will help you to record and analyse receipts made by your business. Download the Receipts spreadsheet.
This spreadsheet will help you to analyse the overheads your business is likely to incur, in a format suitable for inclusion in your Business Plan. Download the Operating Budget Analysis of Overheads spreadsheet.
This spreadsheet will help you to prepare a projected cashflow for your business, in a format suitable for inclusion in your Business Plan. Download the Cashflow spreadsheet.
This spreadsheet will help you to estimate your business’ likely sales and gross profit, in a format suitable for inclusion in your Business Plan. Download the Operating Budget:Estimate of Sales and Gross Profit spreadsheet.
This spreadsheet will help you to record and analyse petty cash expenses for your business. Download the Petty Cash spreadsheet.
This spreadsheet will help you to record and analyse payments made by your business. Download the Payments spreadsheet.
This spreadsheet will help you to summarise three years’ projected cashflows for your business, in a format suitable for inclusion in your Business Plan. Download the Cashflow:Summary spreadsheet.

Share this:
pin it button Downloadable Excel Financial Spreadsheets
fionan

About fionan

Fionan was CEO of an international software business, which he led to global market leadership in operations management software. He completed the Leadership4Growth executive management course for Ireland’s high potential entrepreneurs at the Stanford Business School in California. He is a former Head of Marketing with KBC Bank and worked as a journalist in London specialising in finance and technology.
View all posts by fionan →
  • http://twitter.com/BrianFlanagan1 Brian Flanagan

    The worksheets featured in Fionan’s piece above are useful but limited because they do not offer integration between P&L, cashflow and balance sheets.
    If you need comprehensive tools for financial projections, have a look at Exl-Plan at Dublin-based PlanWare where you’ll find planners to suit all types and sizes of businesses at prices ranging from US$49 to US$289.Versions are available using UK/International and US/Canadian accounting formats.
    More at http://www.planware.org/financialprojectionsoftware.htm

  • Pranit

    That is really useful..