Your Business Name
                          Projections                             
                                      10 Year Cash Flow     
                                   Balance Sheet                
                                Income Statement            
                                                            Loan 
                                 Amortization
                           by Your Name                                    
                                     Date
                          Copyright © Iowa State University Extension 201008/10/2022   00:19:19   1
                                                   Table of Contents
                                                                                             Page
                        Cover                                                                  1
                        Table of Contents                                                      2
                        Sources and Uses of Cash                                               3
                        Annual Cash Flow                                                      4-19
                        Assets & Depreciation                                                20-49
                        Monthly Cash Flow                                                    50-55
                        Ten Year Analysis                                                    56-58
                        Instructions and Assumptions                                         59-62
                                      Copyright © Iowa State University Extension 2010                 2
                                                            A                         B               C                D                  E                 F                G
                                                                                               Sources and Uses of Cash
                                        1   Sources of Cash
                                        2        Information in Yellow represents the source value and can be changed by entering a new description, new dollar amount, 
                                        3                                                            number or percentage.
                                        4
                                            Set the year the business will start to spend money on fixed and operating expenses.  The Start Up time is 
                                            assumed to be the calendar year when there is no beginning inventory but wine will be produced for sale in the 
                                        5   current and/or future years.  Enter the year that Start Up will begin in the yellow box to the right.                          2010
                                        6
                                        7              Description
                                        8   Stock                                                                      #               Price              Total            Total
                                        9   Class A Stock                                                                    133            $6,000         $798,000
                                       10 Class B Stock                                                                        0                 $0               $0
                                       11   Other                                                                              0                 $0               $0
                                       12 Total Stock                                                                                                                       $798,000
                                       13
                                       14 Other Cash Sources-
                                            Personal Investment
                                       15 Describe                                                                                                                $0
                                       16 Describe                                                                                                                $0
                                       17 Describe                                                                                                                $0
                                       18 Total Other                                                                                                                              $0
                                       19
                                       20 Grants
                                       21 USDA-Value Added Ag Producer Grant                                                                               $123,000
                                       22 State Grant                                                                                                      $100,000
                                       23 Other                                                                                                                   $0
                                       24 Other                                                                                                                   $0
                                       25 Total Grants                                                                                                                      $223,000
                                       26
                                            Loans - Start Date of Loans                                         Payments per       Start Date of 
                                       27 must be Jan. 1 after start up           Annual        Loan Period  Year must be          Loan must be 
                                            year.                              Interest Rate      in Years             12          Jan. 1, Year 2    Loan Amount
                                       28 Wells Fargo-Building                     5.75%             20                12          Jan 1, Year 2           $530,000
                                       29 Bank of Am. Equipment                    8.00%              7                12          Jan 1, Year 2           $228,112
                                       30 State of Iowa                            8.00%              5                12          Jan 1, Year 2           $457,428
                                       31 Total Loans                                                                                 1/1/2008                            $1,215,540
                                       32 If Interest Free Loan use annual interst rate of .000001%                                   1/2/2008
                                       33 Total Sources of Cash                                                                       1/3/2008                            $2,236,540
                                                                                      Copyright © Iowa State University Extension 2010                          08/10/2022     00:19:19     3
                                                          Annual Cash Flow Projection 
                                         A                       B             C               D             E              F
                     1   Annual Income & Expense                2010          2011           2012          2013           2014
                     2   Revenue
                     3   Wine Sales-Tasting Room                $75,000       $528,000       $718,080     $869,440         $915,200 
                     4   Wine Sales-Retail Outlets                   $0       $150,000       $136,000     $152,000         $160,000 
                     5   Wine Sales-On Line                          $0              $0             $0           $0              $0 
                     6   Resturant                                   $0         $20,000        $20,600      $21,218         $21,855 
                     7   Room Rental Net of Expenses                 $0         $25,000        $25,750      $26,523         $27,318 
                     8   Total Revenue                          $75,000       $723,000       $900,430    $1,069,181      $1,124,373 
                     9   Cost of Goods Sold
                    10 Grapes                                   $60,000         $68,000        $76,000      $80,000         $84,000 
                    11   Packaging                              $93,750       $109,438       $125,982     $136,591         $147,723 
                    12 Lab supplies                              $3,075          $3,590         $4,132       $4,480          $4,845 
                    13 Owner labor                                 $627           $627           $627         $627             $627 
                    14 Full time labor                          $37,167         $74,334        $76,564      $78,861         $81,227 
                    15 Part time labor                           $2,370          $3,983         $4,103       $4,226          $4,352 
                    16 Total Cost of Goods Produced            $196,988       $259,971       $287,407     $304,784         $322,774 
                    17 Bottles Produced                           75,000         85,000         95,000      100,000          105,000
                    18 Average Cost Per Bottle                   $2.627          $3.058         $3.025       $3.048          $3.074 
                    19
                    20 Wine Bottle Beginning Inventory                 0         65,000         75,000       85,000           90,000
                    21 Bottles of Wine Produced in Year           75,000         85,000         95,000      100,000          105,000
                    22 Less Bottles Consumed                      10,000         75,000         85,000       95,000          100,000
                    23 Wine Bottle Ending Inventory               65,000         75,000         85,000       90,000           95,000
                    24 Cost of Goods Sold
                    25 Beginning Inventory (Sold First)               $0       $170,723       $229,386     $257,154         $274,306
                    26 Current Production (Sold Last)            $26,265        $30,585        $30,253      $30,478          $30,740
                    27 Total Cost of Goods Sold                  $26,265       $201,308       $259,639     $287,632         $305,046
                    28 Ending Inventory Value                   $170,723       $229,386       $257,154     $274,306         $292,034
                         Average Cost Per Bottle of Ending 
                    29 Inventory                                 $2.6265        $3.0585        $3.0253      $3.0478          $3.0740
                    30 Gross Profit                              $48,735       $521,692       $640,791     $781,548         $819,326
                         Information In Yellow can be changed by entering a new name, number or dollar amount or percentage.  
                                                    Copyright © Iowa State University Extension 2010         08/10/2022    00:19:19    4