Filetype Excel XLS | Posted on 10 Aug 2022 | 3 years ago
Authentication
digital resources
204x Filetype XLS File size 1.99 MB Source: www.agmrc.org
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
no reviews yet
Please Login to review.
