bus 599 week 4 attachments

Non‐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 pre‐ populated 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.