Projecting your finances

Projecting your finances


Spreadsheet is attached in the bottom of the article. 
  1. Download and open Projections Spreadsheet. 
  2. Form will appear.  Fill it out to the best of your knowledge.  Fields that are left blank will assume 0

    2. All numbers are monthly except for the Scenario which is annual sales.
    3. It will create 20 sheets with increments of Scenario incremental value
    4. Submit and Close Form
  3. Assumptions Tab  to Tweek the projections ONLY CHANGE WHAT IS IN RED. 
    1. Variable and fixed costs
      1. Labor in % of sales

      3. RENT calculation

      2. Scenario auto populates starting with Scenario 1, incremented by Scenarioinc. So only change what is in RED.
      3.       
                          

  1. Percent variation in sales per month of all Sub Zero stores by month over 5 years.
                                                                                                  

  1. Now look at the CONSOLIDATED Tab and find the annual sales that best fits your past store sales. Scenario 6 fits closes to our average sales for 2018.

  3. Now go to Scenario 6 for the National Average and you will notice that the monthly costs fluctuate with the different sales by month seasonally.  
  4. This is not a firm P&L only a guide to help you give some targets.  

  1. LABOR -

      2. If the labor is set with this spreadsheet to be $6000 per month then you have $6000 to spend on labor.

    1. So if an employee hour costs $10 per hour you have 600 hours for the month to schedule people.




    • Related Articles

    • 9 Tips for Managing Small Business Finances - CFO Corner 12/2021

      9 Tips for managing small business finances Aggregated by Rob West, CFO, MBA Here are a few things you should do as a small business owner to stay on top of your finances. 1. Pay yourself. If you're running a small business, it can be easy to try and ...

    • Understanding a Balance Sheet - CFO Corner 7/2023

      What is a balance sheet? The balance sheet is one of the three main financial statements, along with the income statement and cash flow statement. While income statements and cash flow statements show your business’s activity over a period of time, a ...

    • Payment Preparedness Matrix Model - CFO Corner 8/2021

      PAYMENT PREPAREDNESS MATRIX Model (“PPM”) The model is attached below or found linked here. I picked this tip up from Investment Bankers I know. I follow this PPM model and, quite frankly, it has served me very well! I pass this on to you as we are ...

    • Financial Reporting Requirements

      Statement Requiring Financial Reporting Sub-Zero Franchising requires Financial statements and the following defines what is required. The Franchisor is required by the FTC to audit and publish our books annually. However, your books are confidential ...

    • Financial advice for entrepreneurs who think they're 'bad with money' - CFO Corner 9/2022

      Financial advice for artists entrepreneurs who think they're 'bad with money' By Paco de Leon Not every hobby needs to be a side hustle. But, if you set out to make money off of yours – congratulations, you're running a business! Now you have to pay ...