The template will take your unique inputs and assumptions to automatically calculate and build your Income Statement (Profit & Loss), Balance Sheet, and Cash Flow statement. Any change you make on the input tabs will automatically be calculated and updated on your financial statements making for easy changes and experimentation. The financial statements are easily exported or printed for lenders or investors.

Financial Statements Included:

• 5 Year Income Statement Annual Summary
• 5 Year Income Statement Monthly Breakdown
• 5 year Cash Flow Statement Annual Summary
• 5 year Cash Flow Statement Monthly Breakdown
• 5 Year Projected Balance Sheet Annual Summary
• 5 Year Projected Balance Sheet Monthly Breakdown

Our At-A-Glance dashboard offers a concise financial overview of your Distillery's projections. With key financial ratios, break-even analyses, and start-up cost breakdown, your data becomes actionable. This tab, filled with tables, charts, and summaries allows you to easily drop key visuals into your pitch deck or investor memo.

Visualizations Include:

• Profit and loss summary table
• Initial start-up cost breakdown for your Distillery
• Key financial ratios
• Operational cash flow visuals
• 5-year summary profit & loss graph

Tailored for Distillery, this model generates accurate sales predictions based on specific Distillery income assumptions then automatically calculates and builds the financial statements.

• Spirits Sales Forecasting: Project revenue from selling distilled spirits such as whiskey, vodka, gin, or rum, considering factors like production capacity, product pricing, and market trends.
• Tasting Room and Direct Sales: Include income from direct sales in the distillery’s tasting room, often at a higher margin than wholesale.
• Beer Production: Also account for beer production and sales if you plan to offer it.
• Restaurant Income: Account for additional earnings from food and a simple customizable menu.
• Wholesale Income: Calculate income generated from wholesale relationships separate from taproom income. 
• Financial Statements: All revenue is automatically calculated and added to your financial statements.

‍

• Raw Material and Production Costs: Budget for the purchase of ingredients (grains, yeast, etc.), barrels for aging, and production expenses like distillation and bottling.
• Aging and Storage: Estimate costs associated with the aging process, including storage space and managing aging inventory.
• Staffing Expenses: Calculate costs for skilled distillers, tasting room staff, sales and marketing teams, and administrative support, including salaries and benefits.
• Marketing and Brand Development: Allocate funds for brand building, product marketing, and promotional events to establish market presence.
• Facility Operations and Utilities: Plan for ongoing expenses related to maintaining the distillery, utilities, and equipment upkeep.
• Financial Statements: Expenses and salary data automatically populate the financial statements for consistent reporting.

• Startup Capital and Balance Sheet: Begin with assumptions about assets, loans, investments, and accounts payable to calculate startup capital needs and structure the balance sheet.
• Automated Financial Calculations: The template includes amortization, depreciation, and interest expenses in pro forma balance sheets.