Financial Spread Sheets
padhfindery1966
business_plan_financials_worksheet.docxNon‐Alcoholic Beverage
Business Plan Financials Worksheet
Guidance
Below is guidance for data to enter into cells of each of the separate Excel
worksheets of the overall Business Plan Financials.
Please note: Many of the cells in the Business Plan Financials (BPF) are already prepopulated
with suggested/default values. Use the default numbers unless otherwise
indicated.
Only cells with BLUE text can be entered/changed. The cells in black will be filled in
automatically, based on your setup assumptions, or will be carried over from
numbers you entered earlier on other worksheets.
We suggest working in order – as every cell you complete will carry over to all other
applicable Excel worksheets (for example, if you enter a figure in the Staff Budget,
that figure will carry over to your Income Statement and Cash Flow Statement).
You are encouraged to work through the guide at your convenience. Review
the Course Guide for specific due dates on specified worksheets.
Worksheet #1 ‐ Set Up and Assumptions
Line 9: the month the semester starts
Line 12: enter the year the term starts
Line 15: Two (students can write over this to include up to 10 lines)
Line 18: they will sell 100% on credit
Line 21: 30 days (that’s the default now in BPFs)
Line 43: $40,000 (assuming Melinda is putting in half her inheritance)
Line 49 $0
Worksheet #2 ‐ Sales Projections
Each student must determine this for their business—speculate on how your
company will grow and how much you will sell.
Worksheet #3 ‐ Inventory
Line 7: Ingredients
Line 8: Bottles/caps
Line 9: Labels
Line 10: Cartons
Repeat these four lines for each product line.
Worksheet #3 ‐ Inventory
Line 7: Ingredients
Line 8: Bottles/caps
Line 9: Labels
Line 10: Cartons
Repeat these four lines for each product line.
Worksheet #3 ‐ Inventory
Line 7: Ingredients
Line 8: Bottles/caps
Line 9: Labels
Line 10: Cartons
Repeat these four lines for each product line.
Worksheet #3 ‐ Inventory
Line 7: Ingredients
Line 8: Bottles/caps
Line 9: Labels
Line 10: Cartons
Repeat these four lines for each product line.
Worksheet #4 ‐ Capital Expenditures
(Note: This applies only to purchased equipment, not leased equipment.)
Facilities section:
Students are not purchasing facilities
Equipment section:
Line 18: used panel van $10,000
Line 19: used panel van $10,000
Line 20: used panel van $10,000
Line 21: used panel van $10,000
Years of service for each van: 4
Salvage value of each van: $2000
Computer Hardware/Software:
Line 40: Apple MacIntosh $1,200
Line 41: Apple MacIntosh $1,200
Line 42: Apple MacIntosh $1,200
Years of service for each computer: 4
Salvage value of each: $100
Line 43: Graphics software $750
Worksheet #5 ‐ Staffing Budget
Line 6: Six months into the business and going forward for the rest of the year, add
2 for the number of salaried employees
Line 7: Six months into the business and going forward for the rest of the year,
$2000
Line 27: Six months into the business and going forward for the rest of the year,
add 1 production person
Line 28: Six months into the business and going forward for the rest of the year,
add $3000
Line 41: 1 hourly employee
Line 42: 20 hours
Line 43: $10
Worksheet #5 ‐ Staffing Budget
Line 6: Six months into the business and going forward for the rest of the year, add
2 for the number of salaried employees
Line 7: Six months into the business and going forward for the rest of the year,
$2000
Line 27: Six months into the business and going forward for the rest of the year,
add 1 production person
Line 28: Six months into the business and going forward for the rest of the year,
add $3000
Line 41: 1 hourly employee
Line 42: 20 hours
Line 43: $10
Worksheet #6 ‐ Marketing Budget
This is submitted with Project Deliverable 2: Marketing Plan
Worksheet #7: Professional Services
Line 6: $2,000
Line 7: $1,500
Line 9: $2,000
Worksheet #8 ‐ Cap Investment
Equity Capital Investments
Line 6: Melinda Cates $20,000
Loans
Line 24: friends and family $20,000; the loan period is 24; the interest rate
is 5%
Add projections of other funds they intend to raise
Worksheet #8 ‐ Income Statement
Line 20: $1,000
The Income Statement is submitted with Project Deliverable 4: Business Plan
– Draft
Worksheet #9 ‐ Cash Flow
This will be automatically populated from other completed worksheets.
Worksheet #10 ‐ Balance Sheet
This will be automatically populated from other completed worksheets
