NON-ALCOHOLOIC BEVERAGE COMPANY CASE STUDY
WE WRITE ESSAYS FOR STUDENTS
Tell us about your assignment and we will find the best writer for your project
Write My Essay For Me
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages Description/Paper Instructions
NON-ALCOHOLOIC BEVERAGE COMPANY CASE STUDY
Business Plan Financials Worksheet Guidance
Below is guidance for data entry into cells of each of the separate Excel worksheets of the overall Business Plan Financials. This is the base pro-forma financial statements for your business. 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 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. Work 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 as early as possible. (Review the Course Guide for specific due dates on specified worksheets; as assignments are due throughout the course.)
Worksheet #1 – Set Up and Assumptions
Line 9: the month the academic quarter starts
Line 12: enter the year the academic quarter starts
Line 15: Two (students can choose the number of product lines to include up to 10 lines)
Line 18: they will sell 55% on credit
Line 21: 30 days (standard default; however, can be adjusted as needed)
Line 43: $16,500 (estimate of net sales after six month of weekend sales)
Line 49: 1.00% (Dodd-Frank Act of 2011 allows businesses to receive interests on business accounts, per the agreement of the financial institution [range 0 to 1.50%])
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. Reflect this in/from your Operations Plan
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 to purchased equipment, not leased equipment.)
Facilities section: Students are not purchasing facilities (facility is already provided)
Equipment section: Capital Purchases should be additional expenses that each student might decide to purchase. (Note – after the first year of business)
Current vans and other equipment should be captured in Line 23 as part of “Other Assets” on the Balance Sheet, Worksheet 11.
Computer Hardware/Software Section: Capital Purchases should be additional expenses that each student might decide to purchase.
Current computer hardware/software should be captured as part of “Other Assets” on the balance sheet, along with equipment mentioned above.
Worksheet #5 – Staffing Budget
Account for every paid employee using the appropriate Lines for the six categories of employees (Management, Administrative/Support, Sales/Marketing, Operations/Production, Other, Part-Time/Hourly) and when their employment will commence in accordance with the Operations Plan and Management Plan.
(See Note # 1 and Note #3 of the NAB Company Portfolio for additional details)
Worksheet #6 – Marketing Budget
This is submitted with Assignment 2: Marketing Plan
Worksheet #7: Professional Services
Line 6: $2,000
Line 7: $1,500
Line 9: $2,000
Line 11: Mary Cates, JD $10,000 (first year only)
Worksheet #8 – Cap Investment
Equity Capital Investments:
Line 6: Melinda Cates $40,000
Line 7: Glass Bottles $3,000
Line 8: Metal Caps $300
Line 9: Cardboard Cartons $500
Line 10: NAB Ingredients $600
Line 11: Labels $840
Loans:
Line 24: Friends and Family $20,000; the loan period is 24; the interest rate is 5% [immediate decision is needed, before proceeding to other sections]
(Note: Early pay off within 12 months @ 0% interest could apply; however if early payoff is not chosen 5% interest at 24 months will automatically apply.) (See Note #3)
Add projections of other funds they intend to raise
Worksheet #9 – Income Statement
Line 20: $1,000
*Note the Leased equipment in the NAB Company Portfolio. (See Note #2)
The Income Statement is submitted with Assignment 3 Part 2: Business Plan – Draft
Worksheet #11 – Balance Sheet
This will automatically populate from other completed worksheets. (See Worksheet # 4 above)
Updated 2/26/2016 1
The post NON-ALCOHOLOIC BEVERAGE COMPANY CASE STUDY appeared first on Terms Broker.
DO MY HOMEWORK NOW!Write my Essay. Premium essay writing services is the ideal place for homework help or essay writing service. if you are looking for affordable, high quality & non-plagiarized papers, click on the button below to place your order. Provide us with the instructions and one of our writers will deliver a unique, no plagiarism, and professional paper.
Get help with your toughest assignments and get them solved by a Reliable Custom Papers Writing Company. Save time, money and get quality papers. Buying an excellent plagiarism-free paper is a piece of cake!
All our papers are written from scratch. We deliver high quality assignment answers to students.
