Distillery Financial Plan Template

This Distillery Financial Plan template prepares a sophisticated financial plan for a small distillery business that produces several types of spirits or liquors and sells them to a variety of different markets (e.g. local markets and export markets). In addition, the spreadsheet template also foresees offering tours to interested visitors which can form an additional source of income. Depending on where the alcohol is sold, different liquor tax charges will apply. This is foreseen in the model which counts liquor tax separately by market segment. The distillery financial model prepares a comprehensive plan for a business producing spirits or liquors and its investors. Forecasts included cover 10 years and include relevant Financial Statements, Cash Flows, Tables, Financial Ratios, and Financial Metrics of interest to banks and investors.

, , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Distillery Business Plan Highlights

This template is simple and complex at the same time. It is simple because it focuses your attention on a few product groups and market segments. It is complex because there are tons of calculations included that aim to give you a solid understanding of the financial implications of your business plan for a distillery business.

Please also refer to this video here which explains in detail some particularities when planning for financial success for a Distillery Business.

The Highlights of this Financial Model Template are the following:

Assumptions

The assumptions sheet outlines the assumptions for product types, production capacity, sales volumes, prices, production, and other direct costs, employee expenses, operating expenses, capital expenditures, and other financial model assumptions. There are also assumptions with respect to an expansion of the production capacity, investment

Executive Summary Sheet

Summarizes the financial plans in the form of charts and tables. It contains the following Summaries:

  • Financial Statement Forecast: Income Statement, Balance Sheet, Cash Flow Statement, Financial Ratios for the next 10 years
  • First-year monthly budget.
  • Breakdowns for revenue, gross profit, and capacity utilization.
  • Volumes and Price Forecasts
  • Debt Schedule
  • Financial Metrics summarizing the Internal Rate of Return (IRR), NPV, Payback Period, Uses and Sources of Funds
  • Investor Section with Capitalization Table for multiple rounds of funding, Financial Metrics by Investor Group, Pre- and Post-Money Valuations.
  • Sensitivity Analysis for the impact of the main key value drivers on the IRRs
  • Break-Even Analysis for up to four products

Break-Even Analysis

This worksheet calculates the break-even points for prices and volumes for four different product groups.

Financial Forecast

The financial forecast includes a Three Statement Model and a 10-year forecast of

• Income Statement
• Balance Sheet
• Cash Flow Statement
• Financial Ratios.
• Standardized Income Statement
• Business Valuation Forecast
• Free Cash Flow Forecast
• Equity Funding and Dividends

Debt Schedule

A debt schedule includes details to forecast the drawdown and the repayment of up to 4 facilities of financial debt (existing, two new ones, and one facility for expansion-related debt) during the forecast horizon.

Monthly Budget

A monthly budget is included to break down the first year’s financial targets for each month and track the monthly cash flows and cash position.

Shareholders

This sheet is to forecast the cash flows of an investor group. The model allows for multiple funding rounds and on this worksheet, the cash flows based on investment and participation are calculated for 5 different groups of investors who come in during multiple funding rounds.

Other Worksheets

There are also other Worksheets included that contain detailed calculations for Revenues, Direct Costs, Gross Profit, OPEX, Employee Costs, CAPEX, as well as Terms and Abbreviations.

Comprehensive Financial Planning for your Distillery Business

This distillery model template offers a comprehensive analytical framework to forecast the business of manufacturing spirits or liquors and hosting tours for interested visitors. The model allows to include the different liquor taxes depending on the market. The spreadsheet offers an ideal framework to get your next distillery business started and planned out.

The model is available as a fully editable Excel file and a PDF Demo version which outlines the exact model structure. The current model version has been updated to version 3.2.

File types:
.xlsx
.pdf

You must log in to submit a review.