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 Liquor Store'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 Liquor Store
• Key financial ratios
• Operational cash flow visuals
• 5-year summary profit & loss graph

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

• Alcohol Sales Forecasting: Estimate earnings from the sale of various types of alcohol, including spirits, wine, and beer, considering customer preferences and pricing strategies. Also decide when a certain product will launch in stores.
• Ecommerce Revenue: Factor in any sales made through the website and accommodate for shipping and packaging costs.
• Store Expansions: Plan for the opening of additional store locations
• Ancillary Product Sales: Include potential revenue from related products like mixers, glassware, and snack items or any other additional non-alcohol item or category of items
• Financial Statements: All revenue is automatically calculated and added to your financial statements.

‍

• Inventory Procurement: Budget for the purchase of liquor inventory, accounting for bulk buying discounts and inventory turnover rates.
• Staffing Costs: Calculate expenses for store staff, including salaries, benefits, and any required training.
• Store Operation Expenses: Estimate monthly costs for store rent or mortgage, utilities, security, and maintenance.
• Marketing and Advertising: Allocate resources for promoting the store through advertising campaigns, social media, and local community events.
• Licensing and Compliance: Plan for costs associated with liquor licensing, compliance with local and state alcohol regulations, and any legal fees.
• Theft and Shrinkage: Include a budget for potential inventory loss due to theft or damage.
• 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.