winery ten year planning
Post on 29-Oct-2014
39 Views
Preview:
TRANSCRIPT
Copyright © Iowa State University Extension 200504/07/2023 23:20:39 1
Enter Company Name
Use this space for the Title of the Document
10 Year Cash Flow Balance Sheet
Income Statement Loan Amortization
Use this area to enter general information you want on the cover.
Table of Contents
Copyright © Iowa State University Extension 2005 2
Page
Cover 1
Table of Contents 2
Sources and Uses of Cash 3
Annual Cash Flow 4-11
Assets & Depreciation 12-41
Monthly Cash Flow 42-47
Ten Year Analysis 48-50
Instructions and Assumptions 51-54
Sources and Uses of Cash
Copyright © Iowa State University Extension 2005 04/07/2023 23:20:39 3
Sources of Cash
2007
DescriptionStock # Price Total TotalClass A Stock 133 $6,000 $798,000Class B Stock 0 $0 $0Other 0 $0 $0Total Stock $798,000
Describe $0Describe $0Describe $0Total Other $0
GrantsUSDA-Value Added Ag Producer Grant $123,000State Grant $100,000Other $0Other $0Total Grants $223,000
Loan AmountWells Fargo-Building 5.75% 20 12 Jan 1, Year 2 $530,000Bank of Am. Equipment 8.00% 7 12 Jan 1, Year 2 $228,112State of Iowa 8.00% 5 12 Jan 1, Year 2 $457,428Total Loans 1/1/2008 $1,215,540If Interest Free Loan use annual interst rate of .000001% 1/2/2008Total Sources of Cash 1/3/2008 $2,236,540
Information in Yellow represents the source value and can be changed by entering a new description, new dollar amount, number or percentage.
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 current and/or future years. Enter the year that Start Up will begin in the yellow box to the right.
Other Cash Sources-Personal Investment
Loans - Start Date of Loans must be Jan. 1 after start up year.
Annual Interest Rate
Loan Period in Years
Payments per Year must be
12
Start Date of Loan must be Jan. 1, Year 2
A B C D E F G
1
234
5
678910111213
14
151617181920212223242526
27
282930313233
Annual Cash Flow Projection
Information In Yellow can be changed by entering a new name, number or dollar amount or percentage. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 4
Annual Income & Expense 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016RevenueWine Sales-Tasting Room $75,000 $528,000 $718,080 $869,440 $915,200 $960,960 $1,052,480 $985,600 $985,600 $985,600 Wine Sales-Retail Outlets $0 $150,000 $136,000 $152,000 $160,000 $189,000 $207,000 $180,000 $180,000 $180,000 Wine Sales-Wholesale $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gift Shop Net of Expenses $0 $20,000 $20,600 $21,218 $21,855 $22,510 $23,185 $23,881 $24,597 $25,335 Room Rental Net of Expenses $0 $25,000 $25,750 $26,523 $27,318 $28,138 $28,982 $29,851 $30,747 $31,669 Total Revenue $75,000 $723,000 $900,430 $1,069,181 $1,124,373 $1,200,608 $1,311,647 $1,219,332 $1,220,944 $1,222,605 Cost of Goods ProducedGrapes $60,000 $68,000 $76,000 $80,000 $84,000 $92,000 $80,000 $80,000 $80,000 $80,000 Packaging $93,750 $109,438 $125,982 $136,591 $147,723 $166,646 $149,257 $153,734 $158,346 $163,097 Lab supplies $3,075 $3,590 $4,132 $4,480 $4,845 $5,466 $4,896 $5,042 $5,194 $5,350 Owner labor $627 $627 $627 $627 $627 $627 $627 $627 $627 $627 Full time labor $37,167 $74,334 $76,564 $78,861 $81,227 $83,664 $86,174 $88,759 $91,422 $94,164 Part time labor $2,370 $3,983 $4,103 $4,226 $4,352 $4,483 $4,618 $4,756 $4,899 $5,046 Total Cost of Goods Produced $196,988 $259,971 $287,407 $304,784 $322,774 $352,885 $325,570 $332,918 $340,487 $348,283 Beginning of Year Inventory $0 $170,723 $233,706 $287,407 $304,784 $322,774 $352,885 $325,570 $332,918 $340,487 Less Cost of Goods Sold $26,265 $196,988 $233,706 $287,407 $304,784 $322,774 $352,885 $325,570 $332,918 ($340,487)End of Year Inventory $170,723 $233,706 $287,407 $304,784 $322,774 $352,885 $325,570 $332,918 $340,487 $348,283 Bottles of Wine InventoryBeginning Inventory 0 65,000 75,000 85,000 90,000 95,000 105,000 90,000 90,000 90,000 Production 75,000 85,000 95,000 100,000 105,000 115,000 100,000 100,000 100,000 100,000
Less Bottles Consumed 10,000 75,000 85,000 95,000 100,000 105,000 115,000 100,000 100,000 100,000
Ending Bottles of Wine Inventory 65,000 75,000 85,000 90,000 95,000 105,000 90,000 90,000 90,000 90,000
$2.627 $2.749 $3.025 $3.048 $3.074 $3.069 $3.256 $3.329 $3.405 $3.483
Total Cost of Goods Sold $26,265 $196,988 $233,706 $287,407 $304,784 $322,774 $352,885 $325,570 $332,918 $340,487 Gross Profit $48,735 $526,012 $666,724 $781,773 $819,588 $877,834 $958,762 $893,762 $888,026 $882,118
Average Cost Per Bottle of Ending Inventory
A B C D E F G H I J K12345
6789
10111213141516171819202122
23
24
25
26
2728
Annual Cash Flow Projection
Information In Yellow can be changed by entering a new name, number or dollar amount or percentage. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 5
Operating Expense 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016Owner Labor $627 $627 $627 $627 $627 $627 $627 $627 $627 $627 Full time labor $37,167 $74,334 $76,564 $78,861 $81,227 $83,664 $86,174 $88,759 $91,422 $94,164 Part time labor $13,428 $22,571 $23,248 $23,946 $24,664 $25,404 $26,166 $26,951 $27,759 $28,592 Marketing $50,000 $36,150 $45,022 $53,459 $56,219 $60,030 $65,582 $60,967 $61,047 $61,130 Office Supplies $1,500 $1,500 $1,545 $1,591 $1,639 $1,688 $1,739 $1,791 $1,845 $1,900 Utilities $3,500 $7,000 $7,210 $7,426 $7,649 $7,879 $8,115 $8,358 $8,609 $8,867 Phone $2,500 $5,000 $5,150 $5,305 $5,464 $5,628 $5,796 $5,970 $6,149 $6,334 Fuel for vehicle $2,000 $4,000 $4,120 $4,244 $4,371 $4,502 $4,637 $4,776 $4,919 $5,067 Taxes & Dues $775 $17,700 $18,231 $18,778 $19,341 $19,922 $20,519 $21,135 $21,769 $22,422 Legal Fees $30,000 $5,000 $5,150 $5,305 $5,464 $5,628 $5,796 $5,970 $6,149 $6,334 Outside Accounting $2,500 $2,500 $2,575 $2,652 $2,732 $2,814 $2,898 $2,985 $3,075 $3,167 Miscellaneous $5,000 $10,000 $10,300 $10,609 $10,927 $11,255 $11,593 $11,941 $12,299 $12,668 Total Operating Expense $148,997 $186,382 $199,741 $212,802 $220,323 $229,039 $239,642 $240,230 $245,669 $251,272 Fixed CostsInsurance $4,000 $8,000 $8,240 $8,487 $8,742 $9,004 $9,274 $9,552 $9,839 $10,134 Property Tax $0 $25,000 $25,750 $26,523 $27,318 $28,138 $28,982 $29,851 $30,747 $31,669 Repairs & Maintenance $0 $14,216 $13,271 $12,325 $11,387 $10,450 $9,598 $8,747 $8,482 $8,217 Interest Expense
Wells Fargo-Building $0 $30,095 $29,236 $28,326 $27,362 $26,341 $25,260 $24,115 $22,902 $21,618 Bank of Am. Equipment $0 $17,334 $15,231 $12,954 $10,488 $7,817 $4,925 $1,793 $0 $0 State of Iowa $0 $33,793 $27,360 $20,393 $12,848 $4,677 $0 $0 $0 $0
Total Interest Expense $0 $81,222 $71,827 $61,673 $50,698 $38,835 $30,185 $25,908 $22,902 $21,618 Depreciation $94,583 $94,583 $94,583 $93,750 $93,750 $85,150 $85,150 $26,507 $26,500 $26,500 Total Fixed Costs $98,583 $223,021 $213,671 $202,757 $191,895 $171,576 $163,189 $100,565 $98,470 $98,138
$247,580 $409,403 $413,412 $415,559 $412,218 $400,615 $402,831 $340,795 $344,139 $349,410 Taxable Income ($198,845) $116,609 $253,312 $366,214 $407,370 $477,218 $555,931 $552,968 $543,887 $532,707 Loss Carry Forward $0 ($198,845) ($82,236) $0 $0 $0 $0 $0 $0 $0 Income before Dividend ($198,845) ($82,236) $171,076 $366,214 $407,370 $477,218 $555,931 $552,968 $543,887 $532,707
$0 $0 $0 $59,877 $128,175 $142,580 $167,026 $194,576 $193,539 $190,360 Net Income after Dividend ($198,845) ($82,236) $171,076 $306,337 $279,196 $334,639 $388,905 $358,392 $350,348 $342,347
Total Operational and Fixed Expenses
Dividend or Tax if prior year cash balance is greater than Zero.
A B C D E F G H I J K2930313233343536373839404142434445464748495051525354
55
565758
59
60
Annual Cash Flow Projection
Information In Yellow can be changed by entering a new name, number or dollar amount or percentage. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 6
Cash Flow Calculation 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
Cash At Beginning of Year $2,236,540 $345,332 $376,146 $543,549 $789,315 $996,352 $1,226,247 $1,670,484 $1,986,625 $2,334,155 Total Revenue $75,000 $723,000 $900,430 $1,069,181 $1,124,373 $1,200,608 $1,311,647 $1,219,332 $1,220,944 $1,222,605 Less Cost of Goods Produced ($196,988) ($259,971) ($287,407) ($304,784) ($322,774) ($352,885) ($325,570) ($332,918) ($340,487) ($348,283)Less Operating Expense ($148,997) ($186,382) ($199,741) ($212,802) ($220,323) ($229,039) ($239,642) ($240,230) ($245,669) ($251,272)Less Fixed Costs ($98,583) ($223,021) ($213,671) ($202,757) ($191,895) ($171,576) ($163,189) ($100,565) ($98,470) ($98,138)Less Dividend or Tax $0 $0 $0 ($59,877) ($128,175) ($142,580) ($167,026) ($194,576) ($193,539) ($190,360)Less New Asset Purchases $1,616,223 $0 $0 $0 $0 $0 $0 $0 $0 $0 Plus Depreciation $94,583 $94,583 $94,583 $93,750 $93,750 $85,150 $85,150 $26,507 $26,500 $26,500 Less Principal Payments on Loans
Wells Fargo-Building $0 $14,557 $15,417 $16,327 $17,291 $18,312 $19,393 $20,538 $21,750 $23,034 Bank of Am. Equipment $0 $25,331 $27,434 $29,711 $32,177 $34,847 $37,740 $40,872 0 0State of Iowa $0 $77,507 $83,940 $90,907 $98,452 $106,623 0 0 0 0
Total Principal Payments on Loans $0 $117,395 $126,790 $136,944 $147,919 $159,782 $57,132 $61,410 $21,750 $23,034
Cash Balance at end of Year $345,332 $376,146 $543,549 $789,315 $996,352 $1,226,247 $1,670,484 $1,986,625 $2,334,155 $2,672,171
Balance Sheet 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016AssetsCash $345,332 $376,146 $543,549 $789,315 $996,352 $1,226,247 $1,670,484 $1,986,625 $2,334,155 $2,672,171
Wine Inventory@Cost $170,723 $233,706 $287,407 $304,784 $322,774 $352,885 $325,570 $332,918 $340,487 $348,283 Building & Equipment $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 Less Depreciation ($94,583) ($189,166) ($283,749) ($377,499) ($471,249) ($556,399) ($641,549) ($668,056) ($694,556) ($721,056)Land Value $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 Land Appreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Assets $2,037,695 $2,036,909 $2,163,431 $2,332,824 $2,464,100 $2,638,956 $2,970,728 $3,267,711 $3,596,309 $3,915,621 Liabilities & EquityTerm Debt $1,215,540 $1,098,145 $971,355 $834,411 $686,491 $526,709 $469,576 $408,167 $386,416 $363,382
Stockholders Equity $822,155 $938,764 $1,192,076 $1,498,413 $1,777,609 $2,112,248 $2,501,152 $2,859,544 $3,209,892 $3,552,239 Total Liabilities & Equity $2,037,695 $2,036,909 $2,163,431 $2,332,824 $2,464,100 $2,638,956 $2,970,728 $3,267,711 $3,596,309 $3,915,621 Term Loan BalanceWells Fargo-Building $530,000 $515,443 $500,026 $483,699 $466,409 $448,097 $428,704 $408,167 $386,416 $363,382 Bank of Am. Equipment $228,112 $202,781 $175,347 $145,636 $113,459 $78,612 $40,872 $0 $0 $0 State of Iowa $457,428 $379,921 $295,982 $205,075 $106,623 $0 $0 $0 $0 $0
Year End Loan Balance $1,215,540 $1,098,145 $971,355 $834,411 $686,491 $526,709 $469,576 $408,167 $386,416 $363,382
A B C D E F G H I J K61
62
6364656667686970717273
74
75
76
7778
79
8081828384858687
8889909192
93
Annual Cash Flow Projection
Information In Yellow can be changed by entering a new name, number or dollar amount or percentage. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 7
2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
$7.50 $9.04 $10.05 $10.75 $10.75 $10.95 $10.95 $11.66 $11.66 $11.66
Grapes $0.800 $0.800 $0.800 $0.800 $0.800 $0.800 $0.800 $0.800 $0.800 $0.800 Packaging $1.250 $1.288 $1.326 $1.366 $1.407 $1.449 $1.493 $1.537 $1.583 $1.631 Lab supplies $0.041 $0.042 $0.043 $0.045 $0.046 $0.048 $0.049 $0.050 $0.052 $0.053 Owner labor $0.008 $0.007 $0.007 $0.006 $0.006 $0.005 $0.006 $0.006 $0.006 $0.006 Full time labor $0.496 $0.875 $0.806 $0.789 $0.774 $0.728 $0.862 $0.888 $0.914 $0.942 Part time labor $0.032 $0.047 $0.043 $0.042 $0.041 $0.039 $0.046 $0.048 $0.049 $0.050 Total Cost of Goods Produced $2.627 $3.058 $3.025 $3.048 $3.074 $3.069 $3.256 $3.329 $3.405 $3.483 Operating ExpenseOwner Labor $0.008 $0.007 $0.007 $0.006 $0.006 $0.005 $0.006 $0.006 $0.006 $0.006 Full time labor $0.496 $0.875 $0.806 $0.789 $0.774 $0.728 $0.862 $0.888 $0.914 $0.942 Part time labor $0.179 $0.266 $0.245 $0.239 $0.235 $0.221 $0.262 $0.270 $0.278 $0.286 Marketing $0.667 $0.425 $0.474 $0.535 $0.535 $0.522 $0.656 $0.610 $0.610 $0.611 Office Supplies $0.020 $0.018 $0.016 $0.016 $0.016 $0.015 $0.017 $0.018 $0.018 $0.019 Utilities $0.047 $0.082 $0.076 $0.074 $0.073 $0.069 $0.081 $0.084 $0.086 $0.089 Phone $0.033 $0.059 $0.054 $0.053 $0.052 $0.049 $0.058 $0.060 $0.061 $0.063 Fuel for vehicle $0.027 $0.047 $0.043 $0.042 $0.042 $0.039 $0.046 $0.048 $0.049 $0.051 Taxes & Dues $0.010 $0.208 $0.192 $0.188 $0.184 $0.173 $0.205 $0.211 $0.218 $0.224 Legal Fees $0.400 $0.059 $0.054 $0.053 $0.052 $0.049 $0.058 $0.060 $0.061 $0.063 Outside Accounting $0.033 $0.029 $0.027 $0.027 $0.026 $0.024 $0.029 $0.030 $0.031 $0.032 Miscellaneous $0.067 $0.118 $0.108 $0.106 $0.104 $0.098 $0.116 $0.119 $0.123 $0.127 Total Operating Expense $1.987 $2.193 $2.103 $2.128 $2.098 $1.992 $2.396 $2.402 $2.457 $2.513
Average Income & Expense Per Bottle
Average Income Per Bottle Consumed
Average Cost Per Unit of Production
A B C D E F G H I J K
94
95
96
979899
100101102103104105106107108109110111112113114115116117
Annual Cash Flow Projection
Information In Yellow can be changed by entering a new name, number or dollar amount or percentage. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 8
Fixed Costs 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Insurance $0.053 $0.094 $0.087 $0.085 $0.083 $0.078 $0.093 $0.096 $0.098 $0.101 Property Tax $0.000 $0.294 $0.271 $0.265 $0.260 $0.245 $0.290 $0.299 $0.307 $0.317 Repairs & Maintenance $0.000 $0.167 $0.140 $0.123 $0.108 $0.091 $0.096 $0.087 $0.085 $0.082 Total Interest Expense $0.000 $0.956 $0.756 $0.617 $0.483 $0.338 $0.302 $0.259 $0.229 $0.216 Depreciation $1.261 $1.113 $0.996 $0.938 $0.893 $0.740 $0.852 $0.265 $0.265 $0.265 Total Fixed Costs $1.314 $2.624 $2.249 $2.028 $1.828 $1.492 $1.632 $1.006 $0.985 $0.981 Dividend and Principal Payments
$0.000 $0.000 $0.000 $0.599 $1.221 $1.240 $1.670 $1.946 $1.935 $1.904 Total Principal Payments on Loans $0.000 $1.381 $1.335 $1.369 $1.409 $1.389 $0.571 $0.614 $0.218 $0.230
$0.000 $1.381 $1.335 $1.968 $2.629 $2.629 $2.242 $2.560 $2.153 $2.134
$5.928 $9.256 $8.712 $9.172 $9.629 $9.181 $9.526 $9.297 $8.999 $9.111
$0.000 $0.235 $0.217 $0.212 $0.208 $0.196 $0.232 $0.239 $0.246 $0.253
$0.000 $0.294 $0.271 $0.265 $0.260 $0.245 $0.290 $0.299 $0.307 $0.317
$5.928 $8.727 $8.224 $8.694 $9.161 $8.741 $9.004 $8.760 $8.446 $8.541
$1.572 $0.313 $1.824 $2.058 $1.591 $2.211 $1.948 $2.896 $3.210 $3.115
Dividend or Tax if prior year cash balance is greater than Zero.
Total Average Cost Per Unit of Production or Break Even from Wine Sales
Contribution to Average Cost or Break Even from Gift Shop
Contribution to Average Cost or Break Even from Room Rental
Total Average Cost Per Unit of Production or Break Even from Wine Sales including all Income Sources
Estimated Profit or Loss from All Sources per bottle of Wine Produced
A B C D E F G H I J K118119120121122123124125
126
127128
129
130
131
132
133
Annual Cash Flow Projection
Information In Yellow can be changed by entering a new name, number or dollar amount or percentage. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 9
Annual Production, Income , Expense, and Dividend or Tax Calculations2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
Wine Inventory
Wine Bottle Beginning Inventory 0 65,000 75,000 85,000 90,000 95,000 105,000 90,000 90,000 90,000Bottles of Wine Produced in Year 75,000 85,000 95,000 100,000 105,000 115,000 100,000 100,000 100,000 100,000Less Bottles Consumed 10,000 75,000 85,000 95,000 100,000 105,000 115,000 100,000 100,000 100,000Wine Bottle Ending Inventory 65,000 75,000 85,000 90,000 95,000 105,000 90,000 90,000 90,000 90,000
RevenueWine Sales-Tasting Room Price $10.00 $10.00 $12.00 $13.00 $13.00 $13.00 $13.00 $14.00 $14.00 $14.00
100% 80% 80% 80% 80% 80% 80% 80% 80% 80%
25% 12% 12% 12% 12% 12% 12% 12% 12% 12%
Wine Sales-Retail Outlets Price $7.00 $10.00 $8.00 $8.00 $8.00 $9.00 $9.00 $9.00 $9.00 $9.00
0% 20% 20% 20% 20% 20% 20% 20% 20% 20%
0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Wine Sales-Wholesale Price $5.00 $10.00 $6.00 $6.00 $6.00 $7.00 $7.00 $7.00 $7.00 $7.00
0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Grape Purchase Bottles of Wine Produced 75,000 85,000 95,000 100,000 105,000 115,000 100,000 100,000 100,000 100,000Grape Purchase Price/Ton $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 Gallons of Grape Juice/Ton 150 150 150 150 150 150 150 150 150 150Bottles of Wine/Gallon 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0Average Cost of Juice/Bottle $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 Grapes Cost/Year $60,000 $68,000 $76,000 $80,000 $84,000 $92,000 $80,000 $80,000 $80,000 $80,000
Packaging Cost/Bottle $0.78 $0.80 $0.83 $0.85 $0.88 $0.90 $0.93 $0.96 $0.99 $1.02 Cost/Cork $0.26 $0.27 $0.28 $0.28 $0.29 $0.30 $0.31 $0.32 $0.33 $0.34 Cost/Capsules $0.11 $0.11 $0.12 $0.12 $0.12 $0.13 $0.13 $0.14 $0.14 $0.14 Cost/Label $0.10 $0.10 $0.11 $0.11 $0.11 $0.12 $0.12 $0.12 $0.13 $0.13 Packaging Cost/Bottle $1.25 $1.29 $1.33 $1.37 $1.41 $1.45 $1.49 $1.54 $1.58 $1.63 Packaging Cost/Year $93,750 $109,438 $125,982 $136,591 $147,723 $166,646 $149,257 $153,734 $158,346 $163,097
Percentage of Production Consumed in Tasting Room
% of Bottles given away in Tasting Room
Percentage of Production Consumed through Retail Outlets
% of Bottles given away at Retail Outlets
Percentage of Production Consumed through Wholesale
% of Bottles given away thought WholesaleVariable Costs:
A B C D E F G H I J K
134
135136
137138139140141142143
144
145
146147
148
149
150151
152
153
154155156157158159160161
162
163164165166167168
Annual Cash Flow Projection
Information In Yellow can be changed by entering a new name, number or dollar amount or percentage. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 10
Owner Operator Labor 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Owner $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Overhead (See Line 189) $253 $253 $253 $253 $253 $253 $253 $253 $253 $253
50% 50% 50% 50% 50% 50% 50% 50% 50% 50%
50% 50% 50% 50% 50% 50% 50% 50% 50% 50%Total Owner/Operator Labor $1,253 $1,253 $1,253 $1,253 $1,253 $1,253 $1,253 $1,253 $1,253 $1,253
Full time laborOther $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 General Manager $24,000 $48,000 $49,440 $50,923 $52,451 $54,024 $55,645 $57,315 $59,034 $60,805 Winemaker $20,000 $40,000 $41,200 $42,436 $43,709 $45,020 $46,371 $47,762 $49,195 $50,671 Cellar Rat $9,650 $19,300 $19,879 $20,475 $21,090 $21,722 $22,374 $23,045 $23,737 $24,449 Officer Manager $9,000 $18,000 $18,540 $19,096 $19,669 $20,259 $20,867 $21,493 $22,138 $22,802
Overhead (See Line 189) $11,684 $23,368 $24,070 $24,792 $25,535 $26,301 $27,090 $27,903 $28,740 $29,602
50% 50% 50% 50% 50% 50% 50% 50% 50% 50%
50% 50% 50% 50% 50% 50% 50% 50% 50% 50%Total Full time labor $74,334 $148,668 $153,129 $157,722 $162,454 $167,328 $172,347 $177,518 $182,843 $188,329
Owner Labor Percentage Allocation to Cost of Goods Sold
Owner Labor Percentage Allocation to Operations Expense
Full Time Labor Percentage Allocation to Cost of Goods Sold
Full Time Labor Percentage Allocation to Operations Expense
A B C D E F G H I J K169
170171
172
173
174
175
176177178179180
181
182
183
184
Annual Cash Flow Projection
Information In Yellow can be changed by entering a new name, number or dollar amount or percentage. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 11
Part Time labor 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Press Operators(2) $2,880 $2,880 $2,966 $3,055 $3,147 $3,241 $3,339 $3,439 $3,542 $3,648Bottling Operators(2) $3,360 $3,360 $3,461 $3,565 $3,672 $3,782 $3,895 $4,012 $4,132 $4,256Warehouse Personal (1) $4,400 $10,400 $10,712 $11,033 $11,364 $11,705 $12,056 $12,418 $12,791 $13,174Customer Service(1) $3,900 $7,800 $8,034 $8,275 $8,523 $8,779 $9,042 $9,314 $9,593 $9,881
Overhead (See Line 189) $1,258 $2,114 $2,177 $2,243 $2,310 $2,379 $2,451 $2,524 $2,600 $2,678
15% 15% 15% 15% 15% 15% 15% 15% 15% 15%
85% 85% 85% 85% 85% 85% 85% 85% 85% 85%
Total Part Time Labor $15,798 $26,554 $27,351 $28,171 $29,016 $29,887 $30,783 $31,707 $32,658 $33,638
Lab supplies
Lab Supplies/Bottle $0.041 $0.042 $0.043 $0.045 $0.046 $0.048 $0.049 $0.050 $0.052 $0.053
Total Lab Supplies/Year $3,075 $3,590 $4,132 $4,480 $4,845 $5,466 $4,896 $5,042 $5,194 $5,350
Dividend or Income Tax % 35% 35% 35% 35% 35% 35% 35% 35% 35% 35%
Employers Share of Social Security Tax 6.20% 6.20%Employers Share of Medicare 1.45% 1.45%
Management's Share (If they are the Owner) of Social Security Tax 12.40%
Managements Share (If they are the Owner) of Medicare Tax 2.90%
1.00% 1.00%
Health Insurance (Estimated at 10% if true cost is unknown.) 10.00% 10.00%
Other Employee Costs:
Total Percentage Cost 18.65% 25.30% 8.65%
Part Time Labor Percentage Allocation to Cost of Goods Sold
Percentage Allocation to Operations Expense
Overhead is that part of the hourly labor cost that is an additional expense to labor. Enter the percentage that the overhead expense will add to the total Annual wage.
Full Time Labor
Owner Operator
Part Time Labor
Workers Compensation Tax or Insurance to pay for injury to employees. Estimated at 5% if true cost is unknown.
A B C D E F G H I J K185186187188189190191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 12
Assets Year Assets Purchased 2007
Receiving Equipment # Needed $/unit Total Cost Asset LifeCMA Lugana 2RTL de-stemmer 1 $8,400.00 $0.00 $8,400 7SK-16 Wine Press (3 tons) 1 $21,300.00 $0.00 $21,300 7Reconditioned Fork Lift 1 $20,000.00 $0.00 $20,000 7Nutriflo Hose- 3.0" 100 5.5 $0.00 $550 7Pallet jack 1 $350.00 $30.00 $380 7
Rotator attachment-dumps grapes out of bins onto conveyor 1 $4,075.00 $0.00 $4,075 7Hopper 1 $7,500.00 $0.00 $7,500 7CMA 100 Elipitical lobe pump 1 6,855.00 $0.00 $6,855 7Scale-Series 3200 Platform Scales 1 $1,000.00 $0.00 $1,000 7
$0$0$0$0$0
Total Receiving Equipment $70,060
Fermentation/Storage Tanks
19.8HL 523 gallons-Variable capacity floating lid Tanks 5 $3,850 $0.00 $19,250 7
5 $6,500 $0.00 $32,500 7
5 $8,470 $0.00 $42,350 7
2 $9,130 $0.00 $18,260 7
2 $9,680 $0.00 $19,360 7
1 $9,500 $0.00 $9,500 760HL Tanks-1585 gallons 1 $12,280 $0.00 $12,280 7
$0$0$0$0$0$0$0
Total Fermentation Storage Tanks $153,500
Cooperage # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0$0$0$0$0
$0
Total Cooperage $0
Refrigeration EquipmentDella Toffola condensing unit 1 $22,000.00 $0.00 $22,000 7Glycol buffer tank 300 liter 1 $890.00 $0.00 $890 7Pumps Lowara model 2HMS3 2 $328.00 $0.00 $656 7Master temperature control panel 1 $5,356.00 $0.00 $5,356 7Tank electro valves 21 $230.00 $0.00 $4,830 7Estimated Installation Cost 40% 1 $13,492.80 $0.00 $13,493 7Glycol diluted 50/50 with water 200 $2.00 $0.00 $400 7
$0$0$0$0$0$0$0$0
Total Refrigeration equipment $47,625
Plus Shipping
40HL Tanks- 1585 gallons-Fixed capacity with cone top & three man ways
60 HL Tanks-1585 gallons-Fixed capacity with cone top & three man ways
80 HL Tanks-2114 gallons-Fixed capacity with cone top & three man ways
100 HL Tanks-2642 gallons-Fixed capacity with cone top & three man ways
40HL Tanks- 1057 gallons--Fixed capacity fully insulated with cone top & three man ways
Plus Shipping
A B C D E F
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 13
Year Assets Purchased 2007
Cellar Equipment # Needed $/unit Total Cost Asset LifePEC/OMAC VNB-115 pump 1 6,490.00 $0.00 $6,490 7MIDEX 1.5" pump (frequency drive) 1 2,850.00 $0.00 $2,850 7Nutriflo Hose- 1.5" 150 2.25 $0.00 $338 7
0 0.00 $0.00 $0 7Valves, clamps, gaskets, reducers, barbs 1 7,371.50 $0.00 $7,372 7Option two Bottling line 1500 bottles per hour 1 80,095.00 $0.00 $80,095 7
Bulldog pup 1 600.00 $0.00 $600 7Punch down device- ss pole w/ foot 2 150.00 $0.00 $300 7Stirring rod 1 27.55 $0.00 $28 7SS hopper for dumping pumice into press 1 5,000.00 $0.00 $5,000 7SS sump and screen 1 5,000.00 $0.00 $5,000 7Della Tofola Universal filter 1 11,875.00 $0.00 $11,875 7Buckets-5 gallon plastic 10 6.00 $0.00 $60 7Carts 2 175.00 $0.00 $350 7Food grade shovels 2 45.00 $0.00 $90 7Water hose- 100' 7/8 diameter 3 30.00 $0.00 $90 7SO2 dispenser-canister 1 300.00 $0.00 $300 7Flashlights 3 30.00 $0.00 $90 7Funnels 3 10.00 $0.00 $30 7Tools-various 1 750.00 $0.00 $750 7Siphon hoses-1" kanaline 30 1.21 $0.00 $36 7
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Cellar Equipment $121,743
Lab equipment # Needed $/unit Total Cost Asset Life
pH meter-Orion 525 AO w/ ATC probe& electrode 1 $1,383.00 $0.00 $1,383 7Microscope 1 $3,500.00 $0.00 $3,500 7Spectrometer 1 $3,000.00 $0.00 $3,000 7Gast vacuum pump and vacushield membrane 1 $356.50 $0.00 $357 7SO2 testing apparatus-A-O setup #2 1 $315.00 $0.00 $315 7Incubator 1 $50.00 $0.00 $50 7Small pressurized lab filter 1 $50.00 $0.00 $50 7Magnetic stirrer and bars 1 $160.00 $0.00 $160 7
Refractometer-Handheld Brix model 45-02 1 $161.24 $0.00 $161 7
Hydrometer-Narrow Range -5-5,0-8,8-16,16-24 Brix 8 $12.30 $0.00 $98 7Thermometer 2 $4.30 $0.00 $9 7Balance-0.01g to 200 g 1 $325.00 $0.00 $325 7Ebulliometer-electric 1 $925.00 $0.00 $925 7Stirrer 1 $16.00 $0.00 $16 7Glassware-various* 1 $295.90 $0.00 $296 7Burettes 1 $82.00 $0.00 $82 7Dispensing Burettes 1 $25.00 $0.00 $25 7Thief-glass18" 1 $44.00 $0.00 $44 7
$0$0$0$0$0$0$0$0
Total Lab Equipment $10,796
Plus Shipping
Plus Shipping
A B C D E F69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 14
Other Equipment Year Assets Purchased 2007
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
General office equipment-fax, copier, telephone, etc 1 $2,000.00 $0.00 $2,000 7Computer & software-computer, printer, MS office 1 $2,500.00 $0.00 $2,500 3Furnishings-desks, chairs, etc 1 $5,000.00 $0.00 $5,000 7Truck 1 $15,000.00 $0.00 $15,000 5Car 2 $14,000.00 $0.00 $28,000 5
$0$0$0$0$0
Total Other Equipment $52,500Total Wine Equipment $456,223
Building # Needed $/unit Total Cost Asset LifeWinery- ft2 10,000 $100.00 $1,000,000 40Air conditioning system 1 $15,000.00 $15,000 40Heating system 1 $15,000.00 $15,000 40Waste water disposal & sewer 1 $30,000.00 $30,000 40
$0$0$0$0$0$0$0
Total Building $1,060,000
Total Investment in Building and Equipment $1,516,223
Land Acres $/Acre Total CostLand and roads 7.5 $13,333.33 $100,000 0.0%
$0$0$0$0$0$0
Total Land $100,000
Total Investment $1,616,223
Plus Shipping
A B C D E F140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 15
Assets Year Assets Purchased 2008 ###
Receiving Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Fermentation Storage Tanks $0 ###
Cooperage # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
Total Cooperage $0 ###
Refrigeration Equipment$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
S T U V W X Y
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 16
Year Assets Purchased 2008 ###
Cellar Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Cellar Equipment $0 ###
Lab equipment # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Lab Equipment $0 ###
Plus Shipping
Plus Shipping
S T U V W X Y69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 17
Depreciation Per YearOther Equipment Year Assets Purchased 2008 ###
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Other Equipment $0 ###Total Wine Equipment $0
Depreciation Per YearBuilding # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Building $0 ###
Total Investment in Building and Equipment $0 Land Value with Appreciation
Land Acres $/Acre Total Cost$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Land $0 ###
Total Investment $0
Plus Shipping
S T U V W X Y140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 18
Assets Year Assets Purchased 2009
Receiving Equipment # Needed $/unit Total Cost Asset Life$0$0$0$0$0
$0$0$0$0$0$0$0$0$0$0
$0
$0
$0
$0
$0
$0$0$0$0$0$0$0$0$0
Total Fermentation Storage Tanks $0
Cooperage # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0$0$0$0$0
$0
Total Cooperage $0
Refrigeration Equipment$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
AL AM AN AO AP AQ AR
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 19
Year Assets Purchased 2009
Cellar Equipment # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Cellar Equipment $0
Lab equipment # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0
$0
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Lab Equipment $0
Plus Shipping
Plus Shipping
AL AM AN AO AP AQ AR69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 20
Other Equipment Year Assets Purchased 2009
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0$0$0
Total Other Equipment $0Total Wine Equipment $0
Building # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0$0$0$0
Total Building $0
Total Investment in Building and Equipment $0
Land Acres $/Acre Total Cost$0$0$0$0$0$0$0
Total Land $0
Total Investment $0
Plus Shipping
AL AM AN AO AP AQ AR140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 21
Assets Year Assets Purchased 2010
Receiving Equipment # Needed $/unit Total Cost Asset Life$0$0$0$0$0
$0$0$0$0$0$0$0$0$0$0
$0
$0
$0
$0
$0
$0$0$0$0$0$0$0$0$0
Total Fermentation Storage Tanks $0
Cooperage # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0$0$0$0$0
$0
Total Cooperage $0
Refrigeration Equipment$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
BE BF BG BH BI BJ BK
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 22
Year Assets Purchased 2010
Cellar Equipment # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Cellar Equipment $0
Lab equipment # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0
$0
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Lab Equipment $0
Plus Shipping
Plus Shipping
BE BF BG BH BI BJ BK69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 23
Other Equipment Year Assets Purchased 2010
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0$0$0
Total Other Equipment $0Total Wine Equipment $0
Building # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0$0$0$0
Total Building $0
Total Investment in Building and Equipment $0
Land Acres $/Acre Total Cost$0$0$0$0$0$0$0
Total Land $0
Total Investment $0
Plus Shipping
BE BF BG BH BI BJ BK140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 24
Assets Year Assets Purchased 2011 ###
Receiving Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Fermentation Storage Tanks $0 ###
Cooperage # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
Total Cooperage $0 ###
Refrigeration Equipment$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
BX BY BZ CA CB CC CD
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 25
Year Assets Purchased 2011 ###
Cellar Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Cellar Equipment $0 ###
Lab equipment # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Lab Equipment $0 ###
Plus Shipping
Plus Shipping
BX BY BZ CA CB CC CD69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 26
Depreciation Per YearOther Equipment Year Assets Purchased 2011 ###
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Other Equipment $0 ###Total Wine Equipment $0
Depreciation Per YearBuilding # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Building $0 ###
Total Investment in Building and Equipment $0 Land Value with Appreciation
Land Acres $/Acre Total Cost$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Land $0 ###
Total Investment $0
Plus Shipping
BX BY BZ CA CB CC CD140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 27
Assets Year Assets Purchased 2012 ###
Receiving Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Fermentation Storage Tanks $0 ###
Cooperage # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
Total Cooperage $0 ###
Refrigeration Equipment$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
CQ CR CS CT CU CV CW
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 28
Year Assets Purchased 2012 ###
Cellar Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Cellar Equipment $0 ###
Lab equipment # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Lab Equipment $0 ###
Plus Shipping
Plus Shipping
CQ CR CS CT CU CV CW69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 29
Depreciation Per YearOther Equipment Year Assets Purchased 2012 ###
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Other Equipment $0 ###Total Wine Equipment $0
Depreciation Per YearBuilding # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Building $0 ###
Total Investment in Building and Equipment $0 Land Value with Appreciation
Land Acres $/Acre Total Cost$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Land $0 ###
Total Investment $0
Plus Shipping
CQ CR CS CT CU CV CW140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 30
Assets Year Assets Purchased 2013 ###
Receiving Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Fermentation Storage Tanks $0 ###
Cooperage # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
Total Cooperage $0 ###
Refrigeration Equipment$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
DJ DK DL DM DN DO DP
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 31
Year Assets Purchased 2013 ###
Cellar Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Cellar Equipment $0 ###
Lab equipment # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Lab Equipment $0 ###
Plus Shipping
Plus Shipping
DJ DK DL DM DN DO DP69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 32
Depreciation Per YearOther Equipment Year Assets Purchased 2013 ###
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Other Equipment $0 ###Total Wine Equipment $0
Depreciation Per YearBuilding # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Building $0 ###
Total Investment in Building and Equipment $0 Land Value with Appreciation
Land Acres $/Acre Total Cost$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Land $0 ###
Total Investment $0
Plus Shipping
DJ DK DL DM DN DO DP140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 33
Assets Year Assets Purchased 2014
Receiving Equipment # Needed $/unit Total Cost Asset Life$0$0$0$0$0
$0$0$0$0$0$0$0$0$0$0
$0
$0
$0
$0
$0
$0$0$0$0$0$0$0$0$0
Total Fermentation Storage Tanks $0
Cooperage # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0$0$0$0$0
$0
Total Cooperage $0
Refrigeration Equipment$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
EC ED EE EF EG EH EI
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 34
Year Assets Purchased 2014
Cellar Equipment # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Cellar Equipment $0
Lab equipment # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0
$0
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Lab Equipment $0
Plus Shipping
Plus Shipping
EC ED EE EF EG EH EI69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 35
Other Equipment Year Assets Purchased 2014
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0$0$0
Total Other Equipment $0Total Wine Equipment $0
Building # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0$0$0$0
Total Building $0
Total Investment in Building and Equipment $0
Land Acres $/Acre Total Cost$0$0$0$0$0$0$0
Total Land $0
Total Investment $0
Plus Shipping
EC ED EE EF EG EH EI140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 36
Assets Year Assets Purchased 2015
Receiving Equipment # Needed $/unit Total Cost Asset Life$0$0$0$0$0
$0$0$0$0$0$0$0$0$0$0
$0
$0
$0
$0
$0
$0$0$0$0$0$0$0$0$0
Total Fermentation Storage Tanks $0
Cooperage # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0$0$0$0$0
$0
Total Cooperage $0
Refrigeration Equipment$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
EV EW EX EY EZ FA FB
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 37
2015
Cellar Equipment # Needed $/unit Total Cost Asset Life$0$0$0$0$0$0
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Cellar Equipment $0
Lab equipment # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0
$0
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Lab Equipment $0
Plus Shipping
Plus Shipping
EV EW EX EY EZ FA FB69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 38
Other Equipment 2015
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0$0$0
Total Other Equipment $0Total Wine Equipment $0
Building # Needed $/unit Total Cost Asset Life
$0$0$0$0$0$0$0$0$0$0$0
Total Building $0
Total Investment in Building and Equipment $0
Land Acres $/Acre Total Cost$0$0$0$0$0$0$0
Total Land $0
Total Investment $0
Plus Shipping
EV EW EX EY EZ FA FB140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 39
Assets Year Assets Purchased 2016 ###
Receiving Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Fermentation Storage Tanks $0 ###
Cooperage # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
Total Cooperage $0 ###
Refrigeration Equipment$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Refrigeration equipment $0
Plus Shipping
Plus Shipping
Refr
FO FP FQ FR FS FT FU
1
2
34567
8
910111213141516171819
20
21
22
23
24
25
2627282930313233
34
37
3839404142434445464748
49
51
525354555657585960616263646566
67
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 40
2016 ###
Cellar Equipment # Needed $/unit Total Cost Asset Life$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Cellar Equipment $0 ###
Lab equipment # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
$0 ###
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Lab Equipment $0 ###
Plus Shipping
Plus Shipping
FO FP FQ FR FS FT FU69
70
717273747576
77
78798081828384858687888990919293949596979899100101102103104105106107
108
111
112
113114115116117118119
120
121
122123124125126127128129130131132133134135136137
138
Asset List
Information In Yellow can be changed by entering a new name, number, dollar amount or percentage.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 41
Depreciation Per YearOther Equipment 2016 ###
General office equipment-fax, copier, telephone, etc # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Other Equipment $0 ###Total Wine Equipment $0
Depreciation Per YearBuilding # Needed $/unit Total Cost Asset Life
$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Building $0 ###
Total Investment in Building and Equipment $0 Land Value with Appreciation
Land Acres $/Acre Total Cost$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###$0 ###
Total Land $0 ###
Total Investment $0
Plus Shipping
Tota
FO FP FQ FR FS FT FU140141
142
143
144145146147148149150151152
153
156157159160161162163164165166167168169170
171
172173
175
177
178179180181182183184185186
187
Monthly Cash Flow
Information In Yellow can be changed by entering a new number. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 42
2007
Jan Feb March April May June July Aug Sept Oct Nov DecCash At Beginning of Year $2,236,540 $2,236,540 $2,236,540 $2,236,540 $2,236,165 $2,236,165 $2,228,766 $2,175,887 $2,132,127 $2,084,335 $1,476,298 $957,084 $2,236,540
RevenueWine Sales-Tasting Room $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $75,000 $0 $75,000 Wine Sales-Retail Outlets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Wine Sales-Wholesale $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Gift Shop Net of Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Room Rental Net of Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $75,000 $0 $75,000
Cost of Goods ProducedGrapes $0 $0 $0 $0 $0 $0 $8,571 $17,143 $25,714 $8,571 $0 $0 $60,000 Packaging $0 $0 $0 $0 $0 $0 $0 $0 $0 $15,625 $31,250 $46,875 $93,750 Lab supplies $0 $0 $0 $0 $0 $0 $513 $513 $513 $513 $513 $513 $3,075 Owner labor $0 $0 $0 $0 $0 $0 $104 $104 $104 $104 $104 $104 $627 Full time labor $0 $0 $0 $0 $0 $0 $6,195 $6,195 $6,195 $6,195 $6,195 $6,195 $37,167 Part time labor $0 $0 $0 $0 $0 $0 $0 $592 $592 $592 $0 $592 $2,370 Total Cost of Goods Produced $0 $0 $0 $0 $0 $0 $15,383 $24,547 $33,118 $31,600 $38,061 $54,279 $196,988
Operating ExpenseOwner Labor $0 $0 $0 $0 $0 $90 $90 $90 $90 $90 $90 $90 $627 Full time labor $0 $0 $0 $0 $0 $5,310 $5,310 $5,310 $5,310 $5,310 $5,310 $5,310 $37,167 Part time labor $0 $0 $0 $0 $0 $0 $6,714 $6,714 $0 $0 $0 $0 $13,428 Marketing $0 $0 $0 $0 $0 $2,000 $4,000 $6,000 $8,000 $10,000 $10,000 $10,000 $50,000 Office Supplies $0 $0 $0 $375 $0 $0 $375 $0 $0 $375 $0 $375 $1,500 Utilities $0 $0 $0 $0 $0 $0 $175 $350 $525 $700 $875 $875 $3,500 Phone $0 $0 $0 $0 $0 $0 $417 $417 $417 $417 $417 $417 $2,500 Fuel for vehicle $0 $0 $0 $0 $0 $0 $333 $333 $333 $333 $333 $333 $2,000 Taxes & Dues $0 $0 $0 $0 $0 $0 $0 $0 $0 $388 $388 $0 $775 Legal Fees $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $15,000 $0 $0 $30,000
Outside Accounting $0 $0 $0 $0 $0 $0 $1,250 $0 $0 $1,250 $0 $0 $2,500 Miscellaneous $0 $0 $0 $0 $0 $0 $2,500 $0 $0 $2,500 $0 $0 $5,000
Total Operating Expense $0 $0 $0 $375 $0 $7,399 $36,163 $19,213 $14,674 $36,362 $17,412 $17,399 $148,997
Total for the Year
A B C D E F G H I J K L M N
1
2
3
4
56789
10
11
12131415161718
19
20212223242526272829
30
31
32
Monthly Cash Flow
Information In Yellow can be changed by entering a new number. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 43
Cash At Beginning of Year
RevenueWine Sales-Tasting Room Wine Sales-Retail OutletsWine Sales-Wholesale Gift Shop Net of ExpensesRoom Rental Net of Expenses
Total Revenue
Cost of Goods ProducedGrapesPackagingLab suppliesOwner laborFull time laborPart time laborTotal Cost of Goods Produced
Operating ExpenseOwner LaborFull time laborPart time laborMarketingOffice SuppliesUtilitiesPhoneFuel for vehicleTaxes & Dues Legal Fees
Outside AccountingMiscellaneous
Total Operating Expense
2008
Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec$345,332 $304,943 $275,729 $245,307 $249,388 $264,176 $300,849 $339,732 $403,643 $425,844 $401,868 $371,938 $345,332
$16,500 $16,500 $16,500 $33,000 $33,000 $49,500 $66,000 $82,500 $66,000 $49,500 $33,000 $66,000 $528,000 $4,688 $4,688 $4,688 $9,375 $9,375 $14,063 $18,750 $23,438 $18,750 $14,063 $9,375 $18,750 $150,000
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $625 $625 $625 $1,250 $1,250 $1,875 $2,500 $3,125 $2,500 $1,875 $1,250 $2,500 $20,000 $781 $781 $781 $1,563 $1,563 $2,344 $3,125 $3,906 $3,125 $2,344 $1,563 $3,125 $25,000
$22,594 $22,594 $22,594 $45,188 $45,188 $67,781 $90,375 $112,969 $90,375 $67,781 $45,188 $90,375 $723,000
$0 $0 $0 $0 $0 $0 $8,500 $17,000 $25,500 $17,000 $0 $0 $68,000 $12,875 $12,875 $6,438 $0 $0 $0 $0 $0 $0 $19,313 $25,750 $32,188 $109,438
$422 $422 $211 $0 $0 $0 $0 $0 $0 $633 $845 $1,056 $3,590 $74 $74 $37 $0 $0 $0 $0 $0 $0 $111 $147 $184 $627
$8,745 $8,745 $4,373 $0 $0 $0 $0 $0 $0 $13,118 $17,490 $21,863 $74,334 $469 $469 $234 $0 $0 $0 $0 $0 $0 $703 $937 $1,172 $3,983
$22,585 $22,585 $11,292 $0 $0 $0 $8,500 $17,000 $25,500 $50,877 $45,170 $56,462 $259,971
$52 $52 $52 $52 $52 $52 $52 $52 $52 $52 $52 $52 $627 $6,195 $6,195 $6,195 $6,195 $6,195 $6,195 $6,195 $6,195 $6,195 $6,195 $6,195 $6,195 $74,334 $1,881 $1,881 $1,881 $1,881 $1,881 $1,881 $1,881 $1,881 $1,881 $1,881 $1,881 $1,881 $22,571 $2,126 $2,126 $2,126 $2,835 $3,544 $4,253 $4,962 $4,962 $2,835 $2,126 $2,126 $2,126 $36,150
$375 $0 $0 $375 $0 $0 $375 $0 $0 $375 $0 $0 $1,500 $483 $483 $483 $483 $241 $241 $241 $483 $724 $966 $1,207 $966 $7,000 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $5,000 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $4,000
$4,425 $0 $0 $4,425 $0 $0 $4,425 $0 $0 $4,425 $0 $0 $17,700 $1,250 $0 $0 $1,250 $0 $0 $1,250 $0 $0 $1,250 $0 $0 $5,000
$625 $0 $0 $625 $0 $0 $625 $0 $0 $625 $0 $0 $2,500 $2,500 $0 $0 $2,500 $0 $0 $2,500 $0 $0 $2,500 $0 $0 $10,000
$20,662 $11,487 $11,487 $21,371 $12,663 $13,372 $23,256 $14,322 $12,437 $21,145 $12,211 $11,970 $186,382
Total for the Year
A O P Q R S T U V W X Y Z AA
1
2
3
4
56789
10
11
12131415161718
19
20212223242526272829
30
31
32
Monthly Cash Flow
Information In Yellow can be changed by entering a new number. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 44
2007
Monthly Cash Flow Jan Feb March April May June July Aug Sept Oct Nov DecFixed CostsInsurance $0 $0 $0 $0 $0 $0 $1,333 $0 $0 $1,333 $0 $1,333 $4,000 Property Tax $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Repairs & Maintenance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Interest ExpenseWells Fargo-Building $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Bank of Am. Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 State of Iowa $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $94,583 Total Fixed Costs $0 $0 $0 $0 $0 $0 $1,333 $0 $0 $1,333 $0 $1,333 $98,583
$0 $0 $0 $375 $0 $7,399 $52,879 $43,760 $47,792 $69,295 $55,473 $73,011 $444,568
Other Adjustments to CashDividend or Tax $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Plus Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $94,583 Less New Asset Purchases $0 $0 $0 $0 $0 $0 $0 $0 $0 $538,741 $538,741 $538,741 $1,616,223 Principal Payments on LoansWells Fargo-Building $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Bank of Am. Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 State of Iowa $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Principal Payments on Loans $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Adjustments to Cash $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,710,806 Cash Balance at end of Year $2,236,540 $2,236,540 $2,236,540 $2,236,165 $2,236,165 $2,228,766 $2,175,887 $2,132,127 $2,084,335 $1,476,298 $957,084 $345,332 $345,332
Total for the Year
Total Cost of Goods Produced, Operational and Fixed Expenses
A B C D E F G H I J K L M N
33
34
3536373839404142434445
46
47
4849505152535455
56
57
Monthly Cash Flow
Information In Yellow can be changed by entering a new number. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 45
Monthly Cash FlowFixed CostsInsuranceProperty TaxRepairs & MaintenanceInterest ExpenseWells Fargo-BuildingBank of Am. EquipmentState of IowaTotal Interest ExpenseDepreciationTotal Fixed Costs
Other Adjustments to CashDividend or TaxPlus DepreciationLess New Asset PurchasesPrincipal Payments on LoansWells Fargo-BuildingBank of Am. EquipmentState of IowaTotal Principal Payments on Loans
Total Other Adjustments to CashCash Balance at end of Year
Total Cost of Goods Produced, Operational and Fixed Expenses
2008
Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec
$2,000 $0 $0 $2,000 $0 $0 $2,000 $0 $0 $2,000 $0 $0 $8,000 $0 $0 $12,500 $0 $0 $0 $0 $0 $12,500 $0 $0 $0 $25,000
$1,185 $1,185 $1,185 $1,185 $1,185 $1,185 $1,185 $1,185 $1,185 $1,185 $1,185 $1,185 $14,216
$2,540 $2,534 $2,528 $2,523 $2,517 $2,511 $2,505 $2,499 $2,494 $2,488 $2,482 $2,476 $30,095 $1,521 $1,507 $1,494 $1,480 $1,466 $1,452 $1,438 $1,424 $1,410 $1,395 $1,381 $1,366 $17,334 $3,050 $3,008 $2,966 $2,924 $2,882 $2,839 $2,796 $2,753 $2,710 $2,666 $2,622 $2,577 $33,793 $7,110 $7,049 $6,988 $6,926 $6,865 $6,802 $6,740 $6,676 $6,613 $6,549 $6,485 $6,420 $81,222 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $94,583
$18,176 $16,116 $28,555 $17,993 $15,931 $15,869 $17,806 $15,743 $28,179 $17,615 $15,551 $15,486 $223,021
$61,423 $50,187 $51,334 $39,364 $28,594 $29,241 $49,562 $47,065 $66,117 $89,637 $72,932 $83,918 $669,374
$0 $0 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $94,583
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$1,181 $1,187 $1,193 $1,199 $1,204 $1,210 $1,216 $1,222 $1,228 $1,233 $1,239 $1,245 $14,557 $2,035 $2,048 $2,062 $2,076 $2,089 $2,103 $2,117 $2,132 $2,146 $2,160 $2,174 $2,189 $25,331 $6,225 $6,267 $6,309 $6,351 $6,393 $6,436 $6,479 $6,522 $6,565 $6,609 $6,653 $6,698 $77,507 $9,442 $9,502 $9,563 $9,625 $9,687 $9,749 $9,812 $9,875 $9,939 $10,003 $10,067 $10,132 $117,395
$17,324 $17,384 $17,445 $17,507 $17,569 $17,631 $17,694 $17,757 $17,821 $17,884 $17,949 $18,014 $211,978 $304,943 $275,729 $245,307 $249,388 $264,176 $300,849 $339,732 $403,643 $425,844 $401,868 $371,938 $376,146 $376,146
Total for the Year
A O P Q R S T U V W X Y Z AA
33
34
3536373839404142434445
46
47
4849505152535455
56
57
Monthly Cash Flow
Information In Yellow can be changed by entering a new number. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 46
2007Jan Feb March April May June July Aug Sept Oct Nov Dec Total
RevenueWine Sales-Tasting Room 0 0 0 0 0 0 0 0 0 0 2 0 2
Wine Sales-Retail Outlets 0 0 0 0 0 0 0 0 0 0 2 1 3
Wine Sales-Wholesale 0 0 0 0 0 0 0 0 0 0 2 1 3
Gift Shop Net of Expenses 0 0 0 0 0 0 0 0 0 0 2 1 3
Room Rental Net of Expenses 0 0 0 0 0 0 0 0 0 0 2 1 3
Cost of Goods Produced
Grapes 0 0 0 0 0 0 1 2 3 1 0 0 7
Packaging 0 0 0 0 0 0 0 0 0 1 2 3 6
Lab supplies 0 0 0 0 0 0 1 1 1 1 1 1 6
Owner labor 0 0 0 0 0 0 1 1 1 1 1 1 6
Full time labor 0 0 0 0 0 0 1 1 1 1 1 1 6
Part time labor 0 0 0 0 0 0 0 1 1 1 0 1 4
Jan Feb March April May June July Aug Sept Oct Nov Dec Total Operating Expense
Owner Labor 0 0 0 0 1 1 1 1 1 1 1 7
Full time labor 0 0 0 0 0 1 1 1 1 1 1 1 7
Part time labor 0 0 0 0 0 0 1 1 0 0 0 0 2
Marketing 0 0 0 0 0 1 2 3 4 5 5 5 25
Office Supplies 0 0 0 1 0 0 1 0 0 1 0 1 4
Utilities 0 0 0 0 0 0 1 2 3 4 5 5 20
Phone 0 0 0 0 0 0 1 1 1 1 1 1 6
Fuel for vehicle 0 0 0 0 0 0 1 1 1 1 1 1 6
Taxes & Dues 0 0 0 0 0 0 0 0 0 1 1 0 2
Legal Fees 0 0 0 0 0 0 1 0 0 1 0 0 2
Outside Accounting 0 0 0 0 0 0 1 0 0 1 0 0 2
Miscellaneous 0 0 0 0 0 0 1 0 0 1 0 0 2
Fixed ExpenseInsurance 0 0 0 0 0 0 1 0 0 1 0 1 3
Property Tax 0 0 0 0 0 0 0 0 1 0 0 1 2
Repairs & Maintenance 0 0 0 0 0 0 1 1 1 1 1 1 6
The method used to allocate Income & Expense to a month is based on a sum of the digits. In the areas in Yellow enter a number that you think will best represent the portion of the annual income or expense that would occur in that month. Complete the task for each month in Start Up and Year 1. The sum of each row is shown in the Total for the Year. The spreadsheet will distribute the annual income & expense based on the percentage created in each month. Note: The Total Start Up must have contain a number greater than 0 in all rows.
Monthly Income & Expense Allocation
A B C D E F G H I J K L M N
58
59
6061626364656667686970717273747576777879808182838485868788899091929394
Monthly Cash Flow
Information In Yellow can be changed by entering a new number. Copyright © Iowa State University Extension 2005
04/07/2023 23:20:39 47
RevenueWine Sales-Tasting Room Wine Sales-Retail OutletsWine Sales-Wholesale Gift Shop Net of ExpensesRoom Rental Net of Expenses
Cost of Goods Produced
GrapesPackagingLab suppliesOwner laborFull time laborPart time labor
Operating Expense
Owner LaborFull time laborPart time laborMarketingOffice SuppliesUtilitiesPhoneFuel for vehicleTaxes & Dues Legal Fees Outside AccountingMiscellaneous
Fixed ExpenseInsuranceProperty TaxRepairs & Maintenance
Monthly Income & Expense Allocation 2008
Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Total
1 1 1 2 2 3 4 5 4 3 2 4 321 1 1 2 2 3 4 5 4 3 2 4 321 1 1 2 2 3 4 5 4 3 2 4 321 1 1 2 2 3 4 5 4 3 2 4 321 1 1 2 2 3 4 5 4 3 2 4 32
0 0 0 0 0 0 1 2 3 2 0 0 82 2 1 0 0 0 0 0 0 3 4 5 172 2 1 0 0 0 0 0 0 3 4 5 172 2 1 0 0 0 0 0 0 3 4 5 172 2 1 0 0 0 0 0 0 3 4 5 172 2 1 0 0 0 0 0 0 3 4 5 17
Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Total
1 1 1 1 1 1 1 1 1 1 1 1 121 1 1 1 1 1 1 1 1 1 1 1 121 1 1 1 1 1 1 1 1 1 1 1 123 3 3 4 5 6 7 7 4 3 3 3 511 0 0 1 0 0 1 0 0 1 0 0 42 2 2 2 1 1 1 2 3 4 5 4 291 1 1 1 1 1 1 1 1 1 1 1 121 1 1 1 1 1 1 1 1 1 1 1 121 0 0 1 0 0 1 0 0 1 0 0 41 0 0 1 0 0 1 0 0 1 0 0 41 0 0 1 0 0 1 0 0 1 0 0 41 0 0 1 0 0 1 0 0 1 0 0 4
1 0 0 1 0 0 1 0 0 1 0 0 40 0 1 0 0 0 0 0 1 0 0 0 21 1 1 1 1 1 1 1 1 1 1 1 12
The method used to allocate Income & Expense to a month is based on a sum of the digits. In the areas in Yellow enter a number that you think will best represent the portion of the annual income or expense that would occur in that month. Complete the task for each month in Start Up and Year 1. The sum of each row is shown in the Total for the Year. The spreadsheet will distribute the annual income & expense based on the percentage created in each month. Note: The Total Year 1 must have contain a number greater than 0 in all rows.
A O P Q R S T U V W X Y Z AA
58
59
6061626364656667686970717273747576777879808182838485868788899091929394
Ten Year Balance SheetIncome Statement
% Change in Accounts
Copyright © Iowa State University Extension 2005 04/07/2023 23:20:39 48
Balance Sheet 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
Assets
Cash $345,332 $376,146 $543,549 $789,315 $996,352 $1,226,247 $1,670,484 $1,986,625 $2,334,155 $2,672,171 Wine Inventory@Cost $170,723 $233,706 $287,407 $304,784 $322,774 $352,885 $325,570 $332,918 $340,487 $348,283
Building & Equipment $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223 $1,516,223
Less Depreciation ($94,583) ($189,166) ($283,749) ($377,499) ($471,249) ($556,399) ($641,549) ($668,056) ($694,556) ($721,056)
Land Value $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Land Appreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $2,037,695 $2,036,909 $2,163,431 $2,332,824 $2,464,100 $2,638,956 $2,970,728 $3,267,711 $3,596,309 $3,915,621
Liabilities & EquityTerm Debt $1,215,540 $1,098,145 $971,355 $834,411 $686,491 $526,709 $469,576 $408,167 $386,416 $363,382
Stockholders Equity $822,155 $938,764 $1,192,076 $1,498,413 $1,777,609 $2,112,248 $2,501,152 $2,859,544 $3,209,892 $3,552,239
Total Liabilities & Equity $2,037,695 $2,036,909 $2,163,431 $2,332,824 $2,464,100 $2,638,956 $2,970,728 $3,267,711 $3,596,309 $3,915,621
Annual Income & ExpenseTotal Revenue $75,000 $723,000 $900,430 $1,069,181 $1,124,373 $1,200,608 $1,311,647 $1,219,332 $1,220,944 $1,222,605
Total Cost of Goods Sold $26,265 $196,988 $233,706 $287,407 $304,784 $322,774 $352,885 $325,570 $332,918 $340,487
Gross Profit $48,735 $526,012 $666,724 $781,773 $819,588 $877,834 $958,762 $893,762 $888,026 $882,118
Total Operating Expense $148,997 $186,382 $199,741 $212,802 $220,323 $229,039 $239,642 $240,230 $245,669 $251,272 Total Fixed Costs $98,583 $223,021 $213,671 $202,757 $191,895 $171,576 $163,189 $100,565 $98,470 $98,138
Total Operational and Fixed Expenses $247,580 $409,403 $413,412 $415,559 $412,218 $400,615 $402,831 $340,795 $344,139 $349,410
Taxable Income ($198,845) $116,609 $253,312 $366,214 $407,370 $477,218 $555,931 $552,968 $543,887 $532,707
B C D E F G H I J K L
1
2
3
4
5
6
7
8
9
10
1112
13
14
15
16
17
18
19
20
21
Ten Year Balance SheetIncome Statement
% Change in Accounts
Copyright © Iowa State University Extension 2005 04/07/2023 23:20:39 49
Percentage Change in Accounts 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016AssetsCash & Equivalents 16.9% 18.5% 25.1% 33.8% 40.4% 46.5% 56.2% 60.8% 64.9% 68.2%Inventory 8.4% 11.5% 13.3% 13.1% 13.1% 13.4% 11.0% 10.2% 9.5% 8.9%Total Current (Assets) 25.3% 29.9% 38.4% 46.9% 53.5% 59.8% 67.2% 71.0% 74.4% 77.1%Fixed Assets (net) 74.7% 70.1% 61.6% 53.1% 46.5% 40.2% 32.8% 29.0% 25.6% 22.9%
Total Assets 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
LiabilitiesLong Term Debt 59.7% 53.9% 44.9% 35.8% 27.9% 20.0% 15.8% 12.5% 10.7% 9.3%Net Worth 40.3% 46.1% 55.1% 64.2% 72.1% 80.0% 84.2% 87.5% 89.3% 90.7%
Total Liabilities & Net Worth 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Income DataNet Sales 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%Gross Profit 65.0% 72.8% 74.0% 73.1% 72.9% 73.1% 73.1% 73.3% 72.7% 72.2%Operating Expenses 198.7% 25.8% 22.2% 19.9% 19.6% 19.1% 18.3% 19.7% 20.1% 20.6%Operating Profit -133.7% 47.0% 51.9% 53.2% 53.3% 54.0% 54.8% 53.6% 52.6% 51.6%All Other Expenses (net) 131.4% 30.8% 23.7% 19.0% 17.1% 14.3% 12.4% 8.2% 8.1% 8.0%
Profit Before Taxes -265.1% 16.1% 28.1% 34.3% 36.2% 39.7% 42.4% 45.4% 44.5% 43.6%
B C D E F G H I J K L22
23
2425262728
29
30
3132
33
34
35
3637383940
41
42
Ten Year Balance SheetIncome Statement
% Change in Accounts
Copyright © Iowa State University Extension 2005 04/07/2023 23:20:39 50
Annual Depreciation by Year Year 2007 2008 2009 2010 2011 2012 2013 2014 2015 20162007 $94,583 $94,583 $94,583 $93,750 $93,750 $85,150 $85,150 $26,507 $26,500 $26,500 2008 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2009 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2010 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2011 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2012 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2013 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2014 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2015 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2016 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Annual Depreciation $94,583 $94,583 $94,583 $93,750 $93,750 $85,150 $85,150 $26,507 $26,500 $26,500
Land Value Annual AppreciationYear 2007 2008 2009 2010 2011 2012 2013 2014 2015 20162007 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2008 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2009 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2010 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2011 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2012 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2013 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2014 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2015 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2016 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Land Value Appreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
B C D E F G H I J K L43444546474849505152535455565758596061626364656667686970
Instructions to Use the Program and Assumptions Used
Copyright © Iowa State University Extension 2005 51
Winery Ten Year Financial Planning Workbook
Funding for this Project was provided by the following:
Leopold Center for Sustainable Agriculture www.leopold.iastate.edu
Agricultural Marketing Resource Center www.agmrc.org
Iowa State University Extension www.extension.iastate.edu
Created by: Craig Tordsen
Agricultural Marketing Resource Center
Iowa State University Extension
167 Heady HallAmes, IA 50011
Phone: 515-294-1938
E-mail: ctordsen@iastate.edu
Step 1 Instructions and Assumptions
A
B When complete go to the next step.
Step 2
Step 3 Cover
A
The Winery Ten Year Financial Planning Workbook has been created to aid in the development of a business plan. The worksheet assumes the user has a good understanding of wine production, marketing, management and accounting principals. Any results developed by the worksheet should be reviewed by a Certified Public Account for any errors in calculation or assumptions of the user.
Iowa State University assumes no liabilities or guarantees of the success or failure of any business that uses the Winery Ten Year Financial Planning Worksheet as a decision tool in the start of .the business.
The workbook is built using Microsoft Office Excel 2003. The workbook is made up of eight worksheets. Data entered in one worksheet may be linked to other worksheets. Calculations flow through the worksheets automatically. Save often to protect the information entered.
Important Instruction: Data can be entered in any box in this workbook colored in Yellow (except this one). The data may be text or numbers. Data can be changed any time. Any changes in numbers will change the results of calculations through out the workbook. All other cells in the workbook are password protected and can not be accessed.
Start by printing and reading the Instructions and Assumptions. This worksheet is your only help or instruction manual for the workbook. Excel help can still be found in the usual place.
The workbook is populated with example data of a winery that will produce about 20,000 gallons of wine a year. Bottles of wine, not cases, is the unit of measure. The income and expense per bottle of wine is assumed to represent the average of all bottles of wine to be produced. No effort was made to keep an inventory of different types of wine, market value, etc. Most data is straight forward in the type of information needed to populate any given cell that has a yellow background. Change the data in a cell or set of cells and see how the changes will effect the rest of the workbook.
When ready to start entering new data, delete the old data and begin by entering new data by following the steps below.
Enter the company name in the top yellow box, a description of the document in the second box and other information in the third box. When complete go to the next step.
Instructions to Use the Program and Assumptions Used
Copyright © Iowa State University Extension 2005 52
Step 4 Table of Contents
A Review the table of contents.
Instructions to Use the Program and Assumptions Used
Copyright © Iowa State University Extension 2005 53
Step 5 Sources and Uses of Cash Line
A
B 15
C
E 28-30
F Check the data entered in this step. When complete go to the next Step.
Step 6 Annual
A
B 6-7
C
D
E
F
G 138-139
H
The business will need a large pool of money to buy land, buildings and equipment as well as cash to begin operations. Just how much money will depend on the data entered in the Annual and Asset worksheets.
For now, enter an estimated amount of money needed in cell F15. Assume for each 1,000 gallons of wine making capacity a capital need of $50,000. Then double the amount.
Later , after completion of Step 6, return to this Step 5 to adjust the amount of cash needed and from what Source of Cash.
Note: The program can accommodate up to three term loans. Data entered on lines 28, 29 and 30 will populate the Amortization Tables, Annual and Monthly worksheets.
Note: The first year on the cash flow will represent a partial year of operations. Income and expense items will not reflect a full year of business. The second year will be more representative of the business.
The main business of the winery will be to market wine, Detailed information is needed to populate the income and expenses related to wine. But not for related income sources like a gift shop or room rental. Enter a net dollar amount assuming all expenses have been paid out of the gross receipts of the gifts or room rental. The name of the related income center can be changed.
Note: Including Inflation Factors in planning future Income and Expense. Expect inflation to raise the Price per Bottle, Operating Expense and some Fixed Expenses. Budget 1 to 4 percent increase for expenses and income per year.
Estimate the cost of Operating and Fixed Expenses on lines 34-42 and 45-47. Enter a new name for the expense item if the example is different than the actual. Enter the costs for each year.
34-42 45-47
Hint: Excel formulas can be created to increase the next years costs by a percentage to make data entry faster. Look at the Annual worksheet row six, cell D6 The amount in this sell is the result of the following formula. =SUM(C6+(C6*0.03)) The result in D6 is equal to the amount in C6 plus three percent of C6. To learn more about Excel formulas use the Help button.
Interest Expense Lines 48-52 and Principal Payments on Loans lines 70-74: This data is the result of information entered on the Sources and Uses of Cash worksheet lines 28-30. Return to Step 5 as needed to adjust values based on the business needs.
48-52 70-74
Depreciation Expense (Line 53) and Building & Equipment (Line 80): This data is the result of information entered in the Asset worksheet. Go to Step 7 to complete this task. When done return to Step 6 Item G.
53 80
Wine Inventory: Estimate the number of bottles of wine to be produced and sold each year on lines 138 & 139. Remember wine takes time to age and there is a lot of wine on the market. Your wine will have to replace existing supply. It take time to build a market share. Go slow. Expect to reach maximum capacity in five or six years.
Wine Revenue: The market for wine will occur in the winery, at other stores which have a relationship with the winery like a local grocery store and through wholesale distributors. The bottle price at each market will be different. Enter the market price for each market on lines 143, 147, 151.
143 147
151
Instructions to Use the Program and Assumptions Used
Copyright © Iowa State University Extension 2005 54
I
J
K
L Packaging: Enter a cost per unit for each item on lines 163-165.
M
N
O Lab Supplies: Enter an estimated cost per bottle for lab supplies on line 196. 196
P 198
Q 201-207
R
S 87
T Check the data entered in this step. When complete go to the next Step.
Step 7 AssetsA
Receiving Equipment 3-16
Fermentation/Storage Tanks 20-33
Cooperage 38-48
Refrigeration Equipment 52-66
Cellar Equipment 71-107
Lab equipment 112-137
Enter a percentage of sales that will occur in each market on lines 144,148 and 152. The total percentage should be 100%.
144 148
152
Wine Promotion: Customers expect a taste before they buy. Experience says this tasting will consume between 10 to 15 percent more wine than was sold. Enter a percentage for each year of the wine expected to be used for promotion on lines 145, 149 and 153.
145 149
153
Grape Purchase: The program assumes grapes will be purchased and crushed for juice. But if juice is purchased a conversion to a grape price must be made. Enter the price per ton of grapes on line 157, the conversion rate to gallons of juice on line 158 and the conversion to number of bottles per gallon on line 159.
157 158
159
163 164 165
Labor: Labor is estimated as an annual cost for each skill level and broken down into Owner Operator, Full Time and Part Time. Enter the annual labor cost on lines 170, 177-180 and 186-190. Note: The type or description of the worker can be entered on lines 176-180 and 186-190.
170 177-180 186-190
Labor is also allocated by a percentage as a Cost of Goods Produced and Operating Expense. Enter a percentage for each labor group on lines 172,182 and 192.
172 182
192
Dividend or Income Tax Percentage: It is assumed that as long as the Taxable Income shows a loss there will be no Dividend or Income Tax paid.. A loss is carried forward until there is a positive Income. The amount paid will occur in the year following the positive income. enter a percentage on line 198 to pay the estimated dividend or tax.
Labor Overhead: Often missed in developing a financial plan is the hidden costs of labor. Payroll taxes, Workman's Compensation Insurance, and Health Insurance costs can mount up quickly. Enter a percentage for each type of labor on lines 201-207.
Adjusting the Beginning Cash Balance: Review the Beginning and Ending Cash Balance on lines 62 and 75. To change the Beginning cash, retune to Step 5 to adjust the Sources and Uses of Cash worksheet to meet the business needs.
62 75
Note: Midwest lenders and investors will not have much, if any, experience with a winery business. Therefore their approach will be conservative. Lenders want to see Stockholders Equity to be at least 40 percent, preferable 50 percent for a new start up business. Also most businesses fail because of to little money to meet unforeseen problems in the first year of operation. If the business is a good idea, invest the extra 10 to 20 percent in the beginning. It is easier to go to the banker for more money if the investors have shown greater commitment.
The Assets worksheet is a listing of all the assets the business will own and asset life in years. Assets can now be purchased in later years. There are ten yearly sections. For each asset in the categories below enter in the year of purchase.
Instructions to Use the Program and Assumptions Used
Copyright © Iowa State University Extension 2005 55
Other Equipment 142-152
For each asset in the above categories complete the following.
Enter a description of the asset.
Enter the number of units needed.
Enter the cost per unit
Enter the cost to ship each unit to the business.
Enter the depreciable life of the asset in years.
Building 160-170
Land 178-184
For each asset in the above categories complete the following.
Enter a description of the asset.
Enter the number of units needed.
Enter the cost per unit
B
C Check the data entered in this step. When complete go to the next Step.
Step 8 Monthly Worksheet
A
B 63-97
Note: Each cell in yellow must have contain either a zero or a number.
C Check the data entered in this step. When complete go to the next Step.
Step 9 Ten Year Analysis
A
Step 10 A Print the workbook using the print option "Entire Workbook".
B Review and modify information as needed. When print again.
Enter the depreciable life of the building assets in years and in the case of Land, an estimated Annual Land Appreciation percentage.
The Total Asset values will appear at the bottom of the worksheet for eacy year and annual depreciation or appreciation amounts will appear on the worksheet and related annual, monthly and Ten Year Analysis worksheets.
The monthly worksheet represents a monthly cash flow for the first two years of the business. The purpose of this worksheet is to locate if and when the available cash in the business will reach a dangerously low amount. If so, the amount of cash in the Sources and Uses of Cash worksheet will have to be increased to meet requirements of investors and or lenders.
Distribution of income and expense is accomplished by estimating when the income or expense will occur.
The method used to allocate Income & Expense to a month is based on a sum of the digits. In the areas in Yellow enter a number best represent the portion of the annual income or expense will occur in the month. Complete the task for each month in the table. The sum of each row is shown in the Total for the Year. The worksheet will distribute the annual income & expense based on the percentage created in each month.
Note: If the error message #Value! Appears in any cell in rows 5-54, a corresponding cell in rows 57-93 is blank. Enter a zero or a number.
The Ten Year Analysis is a report each year of the business Balance Sheet, Income Statement and Percentage Change in Assets, Liabilities, Income and Expense.
To change the numbers in this report, return to Step 5 through 9 to change information entered.
Note: Each page of the print out will contain the date and time printed and a page number.
Amortization Table 1
Information in Yellow can be changed by entering a new name or number.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:40 56
Amortization Table 1 Wells Fargo-Building Monthly PrincipalMonthly Interest
Enter Values Loan SummaryLoan Amount $530,000 Scheduled Payment $ 3,721.04
Annual Interest Rate 5.75% Scheduled Number of Payments 240 Loan Period in Years 20 Actual Number of Payments 240
Number of Payments Per Year 12 Total Early Payments $ - Start Date of Loan 1/1/2008 Total Interest $ 363,050.22
Optional Extra Payments $ -
Payment Date Total Payment Principal Interest
1 2/1/2008 $ 530,000.00 $ 3,721.04 $ - $ 3,721.04 $ 1,181.46 $ 2,539.58 $ 528,818.54 $ 2,539.58 2 3/1/2008 528,818.54 $ 3,721.04 $ - $ 3,721.04 $ 1,187.12 $ 2,533.92 $ 527,631.42 5,073.51 3 4/1/2008 527,631.42 $ 3,721.04 $ - $ 3,721.04 $ 1,192.81 $ 2,528.23 $ 526,438.61 7,601.74 4 5/1/2008 526,438.61 $ 3,721.04 $ - $ 3,721.04 $ 1,198.52 $ 2,522.52 $ 525,240.09 10,124.26 5 6/1/2008 525,240.09 $ 3,721.04 $ - $ 3,721.04 $ 1,204.27 $ 2,516.78 $ 524,035.82 12,641.03 6 7/1/2008 524,035.82 $ 3,721.04 $ - $ 3,721.04 $ 1,210.04 $ 2,511.00 $ 522,825.78 15,152.04 7 8/1/2008 522,825.78 $ 3,721.04 $ - $ 3,721.04 $ 1,215.84 $ 2,505.21 $ 521,609.95 17,657.25 8 9/1/2008 521,609.95 $ 3,721.04 $ - $ 3,721.04 $ 1,221.66 $ 2,499.38 $ 520,388.29 20,156.63 9 10/1/2008 520,388.29 $ 3,721.04 $ - $ 3,721.04 $ 1,227.52 $ 2,493.53 $ 519,160.77 22,650.15 10 11/1/2008 519,160.77 $ 3,721.04 $ - $ 3,721.04 $ 1,233.40 $ 2,487.65 $ 517,927.37 25,137.80 11 12/1/2008 517,927.37 $ 3,721.04 $ - $ 3,721.04 $ 1,239.31 $ 2,481.74 $ 516,688.07 27,619.53 12 1/1/2009 516,688.07 $ 3,721.04 $ - $ 3,721.04 $ 1,245.25 $ 2,475.80 $ 515,442.82 30,095.33 13 2/1/2009 515,442.82 $ 3,721.04 $ - $ 3,721.04 $ 1,251.21 $ 2,469.83 $ 514,191.61 32,565.16 14 3/1/2009 514,191.61 $ 3,721.04 $ - $ 3,721.04 $ 1,257.21 $ 2,463.83 $ 512,934.40 35,029.00 15 4/1/2009 512,934.40 $ 3,721.04 $ - $ 3,721.04 $ 1,263.23 $ 2,457.81 $ 511,671.17 37,486.81 16 5/1/2009 511,671.17 $ 3,721.04 $ - $ 3,721.04 $ 1,269.28 $ 2,451.76 $ 510,401.88 39,938.56 17 6/1/2009 510,401.88 $ 3,721.04 $ - $ 3,721.04 $ 1,275.37 $ 2,445.68 $ 509,126.52 42,384.24 18 7/1/2009 509,126.52 $ 3,721.04 $ - $ 3,721.04 $ 1,281.48 $ 2,439.56 $ 507,845.04 44,823.80 19 8/1/2009 507,845.04 $ 3,721.04 $ - $ 3,721.04 $ 1,287.62 $ 2,433.42 $ 506,557.42 47,257.23 20 9/1/2009 506,557.42 $ 3,721.04 $ - $ 3,721.04 $ 1,293.79 $ 2,427.25 $ 505,263.63 49,684.48 21 10/1/2009 505,263.63 $ 3,721.04 $ - $ 3,721.04 $ 1,299.99 $ 2,421.05 $ 503,963.64 52,105.54 22 11/1/2009 503,963.64 $ 3,721.04 $ - $ 3,721.04 $ 1,306.22 $ 2,414.83 $ 502,657.43 54,520.36 23 12/1/2009 502,657.43 $ 3,721.04 $ - $ 3,721.04 $ 1,312.48 $ 2,408.57 $ 501,344.95 56,928.93 24 1/1/2010 501,344.95 $ 3,721.04 $ - $ 3,721.04 $ 1,318.76 $ 2,402.28 $ 500,026.19 59,331.21
PmtNo.
Beginning Balance
Scheduled Payment
Extra Payment
Ending Balance
Cumulative Interest
A B C D E F G H I J
1
23456789
10111213141516
17
18192021222324252627282930313233343536373839404142
Amortization Table 2
Information in Yellow can be changed by entering a new name or number.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:40 57
Amortization Table 2 Bank of Am. Equipment
Enter Values Loan SummaryLoan Amount $228,112 Scheduled Payment $ 3,555.40
Annual Interest Rate 8.00% Scheduled Number of Payments 84 Loan Period in Years 7 Actual Number of Payments 84
Number of Payments Per Year 12 Total Early Payments $ - Start Date of Loan 1/2/2008 Total Interest $ 70,541.81
Optional Extra Payments
Payment Date Total Payment Principal Interest
1 2/2/2008 $ 228,112.00 $ 3,555.40 $ - $ 3,555.40 $ 2,034.66 $ 1,520.75 $ 226,077.34 $ 1,520.75 2 3/2/2008 226,077.34 $ 3,555.40 $ - $ 3,555.40 $ 2,048.22 $ 1,507.18 $ 224,029.12 3,027.93 3 4/2/2008 224,029.12 $ 3,555.40 $ - $ 3,555.40 $ 2,061.88 $ 1,493.53 $ 221,967.25 4,521.46 4 5/2/2008 221,967.25 $ 3,555.40 $ - $ 3,555.40 $ 2,075.62 $ 1,479.78 $ 219,891.63 6,001.24 5 6/2/2008 219,891.63 $ 3,555.40 $ - $ 3,555.40 $ 2,089.46 $ 1,465.94 $ 217,802.17 7,467.18 6 7/2/2008 217,802.17 $ 3,555.40 $ - $ 3,555.40 $ 2,103.39 $ 1,452.01 $ 215,698.78 8,919.20 7 8/2/2008 215,698.78 $ 3,555.40 $ - $ 3,555.40 $ 2,117.41 $ 1,437.99 $ 213,581.37 10,357.19 8 9/2/2008 213,581.37 $ 3,555.40 $ - $ 3,555.40 $ 2,131.53 $ 1,423.88 $ 211,449.84 11,781.06 9 10/2/2008 211,449.84 $ 3,555.40 $ - $ 3,555.40 $ 2,145.74 $ 1,409.67 $ 209,304.11 13,190.73 10 11/2/2008 209,304.11 $ 3,555.40 $ - $ 3,555.40 $ 2,160.04 $ 1,395.36 $ 207,144.07 14,586.09 11 12/2/2008 207,144.07 $ 3,555.40 $ - $ 3,555.40 $ 2,174.44 $ 1,380.96 $ 204,969.62 15,967.05 12 1/2/2009 204,969.62 $ 3,555.40 $ - $ 3,555.40 $ 2,188.94 $ 1,366.46 $ 202,780.68 17,333.52 13 2/2/2009 202,780.68 $ 3,555.40 $ - $ 3,555.40 $ 2,203.53 $ 1,351.87 $ 200,577.15 18,685.39 14 3/2/2009 200,577.15 $ 3,555.40 $ - $ 3,555.40 $ 2,218.22 $ 1,337.18 $ 198,358.93 20,022.57 15 4/2/2009 198,358.93 $ 3,555.40 $ - $ 3,555.40 $ 2,233.01 $ 1,322.39 $ 196,125.92 21,344.96 16 5/2/2009 196,125.92 $ 3,555.40 $ - $ 3,555.40 $ 2,247.90 $ 1,307.51 $ 193,878.03 22,652.47 17 6/2/2009 193,878.03 $ 3,555.40 $ - $ 3,555.40 $ 2,262.88 $ 1,292.52 $ 191,615.14 23,944.99 18 7/2/2009 191,615.14 $ 3,555.40 $ - $ 3,555.40 $ 2,277.97 $ 1,277.43 $ 189,337.18 25,222.42 19 8/2/2009 189,337.18 $ 3,555.40 $ - $ 3,555.40 $ 2,293.15 $ 1,262.25 $ 187,044.02 26,484.67 20 9/2/2009 187,044.02 $ 3,555.40 $ - $ 3,555.40 $ 2,308.44 $ 1,246.96 $ 184,735.58 27,731.63 21 10/2/2009 184,735.58 $ 3,555.40 $ - $ 3,555.40 $ 2,323.83 $ 1,231.57 $ 182,411.75 28,963.20 22 11/2/2009 182,411.75 $ 3,555.40 $ - $ 3,555.40 $ 2,339.32 $ 1,216.08 $ 180,072.42 30,179.28 23 12/2/2009 180,072.42 $ 3,555.40 $ - $ 3,555.40 $ 2,354.92 $ 1,200.48 $ 177,717.50 31,379.76
PmtNo.
Beginning Balance
Scheduled Payment
Extra Payment
Ending Balance
Cumulative Interest
Amortization Table 2
Information in Yellow can be changed by entering a new name or number.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:40 58
Payment Date Total Payment Principal InterestPmtNo.
Beginning Balance
Scheduled Payment
Extra Payment
Ending Balance
Cumulative Interest
24 1/2/2010 177,717.50 $ 3,555.40 $ - $ 3,555.40 $ 2,370.62 $ 1,184.78 $ 175,346.88 32,564.54
Amortization Table 3
Information in Yellow can be changed by entering a new name or number.Copyright © Iowa State University Extension 2005
04/07/2023 23:20:40 59
Amortization Table 3 State of Iowa
Enter Values Loan SummaryLoan Amount $457,428 Scheduled Payment $ 9,274.99
Annual Interest Rate 8.00% Scheduled Number of Payments 60 Loan Period in Years 5 Actual Number of Payments 60
Number of Payments Per Year 12 Total Early Payments $ - Start Date of Loan 1/3/2008 Total Interest $ 99,071.43
Optional Extra Payments $ -
Payment Date Total Payment Principal Interest
1 2/3/2008 $ 457,428.00 $ 9,274.99 $ - $ 9,274.99 $ 6,225.47 $ 3,049.52 $ 451,202.53 $ 3,049.52 2 3/3/2008 451,202.53 $ 9,274.99 $ - $ 9,274.99 $ 6,266.97 $ 3,008.02 $ 444,935.56 6,057.54 3 4/3/2008 444,935.56 $ 9,274.99 $ - $ 9,274.99 $ 6,308.75 $ 2,966.24 $ 438,626.80 9,023.77 4 5/3/2008 438,626.80 $ 9,274.99 $ - $ 9,274.99 $ 6,350.81 $ 2,924.18 $ 432,275.99 11,947.95 5 6/3/2008 432,275.99 $ 9,274.99 $ - $ 9,274.99 $ 6,393.15 $ 2,881.84 $ 425,882.84 14,829.79 6 7/3/2008 425,882.84 $ 9,274.99 $ - $ 9,274.99 $ 6,435.77 $ 2,839.22 $ 419,447.07 17,669.01 7 8/3/2008 419,447.07 $ 9,274.99 $ - $ 9,274.99 $ 6,478.68 $ 2,796.31 $ 412,968.39 20,465.33 8 9/3/2008 412,968.39 $ 9,274.99 $ - $ 9,274.99 $ 6,521.87 $ 2,753.12 $ 406,446.52 23,218.45 9 10/3/2008 406,446.52 $ 9,274.99 $ - $ 9,274.99 $ 6,565.35 $ 2,709.64 $ 399,881.18 25,928.09 10 11/3/2008 399,881.18 $ 9,274.99 $ - $ 9,274.99 $ 6,609.12 $ 2,665.87 $ 393,272.06 28,593.97 11 12/3/2008 393,272.06 $ 9,274.99 $ - $ 9,274.99 $ 6,653.18 $ 2,621.81 $ 386,618.88 31,215.78 12 1/3/2009 386,618.88 $ 9,274.99 $ - $ 9,274.99 $ 6,697.53 $ 2,577.46 $ 379,921.35 33,793.24 13 2/3/2009 379,921.35 $ 9,274.99 $ - $ 9,274.99 $ 6,742.18 $ 2,532.81 $ 373,179.17 36,326.05 14 3/3/2009 373,179.17 $ 9,274.99 $ - $ 9,274.99 $ 6,787.13 $ 2,487.86 $ 366,392.04 38,813.91 15 4/3/2009 366,392.04 $ 9,274.99 $ - $ 9,274.99 $ 6,832.38 $ 2,442.61 $ 359,559.67 41,256.52 16 5/3/2009 359,559.67 $ 9,274.99 $ - $ 9,274.99 $ 6,877.93 $ 2,397.06 $ 352,681.74 43,653.59 17 6/3/2009 352,681.74 $ 9,274.99 $ - $ 9,274.99 $ 6,923.78 $ 2,351.21 $ 345,757.96 46,004.80 18 7/3/2009 345,757.96 $ 9,274.99 $ - $ 9,274.99 $ 6,969.94 $ 2,305.05 $ 338,788.02 48,309.85 19 8/3/2009 338,788.02 $ 9,274.99 $ - $ 9,274.99 $ 7,016.40 $ 2,258.59 $ 331,771.62 50,568.44 20 9/3/2009 331,771.62 $ 9,274.99 $ - $ 9,274.99 $ 7,063.18 $ 2,211.81 $ 324,708.44 52,780.25 21 10/3/2009 324,708.44 $ 9,274.99 $ - $ 9,274.99 $ 7,110.27 $ 2,164.72 $ 317,598.17 54,944.97 22 11/3/2009 317,598.17 $ 9,274.99 $ - $ 9,274.99 $ 7,157.67 $ 2,117.32 $ 310,440.50 57,062.29 23 12/3/2009 310,440.50 $ 9,274.99 $ - $ 9,274.99 $ 7,205.39 $ 2,069.60 $ 303,235.12 59,131.90 24 1/3/2010 303,235.12 $ 9,274.99 $ - $ 9,274.99 $ 7,253.42 $ 2,021.57 $ 295,981.69 61,153.46
PmtNo.
Beginning Balance
Scheduled Payment
Extra Payment
Ending Balance
Cumulative Interest
A B C D E F G H I J
1
23456789
10111213141516
17
18192021222324252627282930313233343536373839404142
top related