Week 7 Discussion
Please respond to the following:
Before you get started on this exercise, watch the video below for some tips that will help you complete the discussion assignment.
For this exercise, you will consider your company’s financials, such as Income Statement, Cash Flow Projections, Balance Sheets.
Using your NAB Company Portfolio and the first year of your business plan for the company, complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the ?Business Plan Financials? spreadsheet. (These files are found in the Student Center). Attach the completed Excel worksheet to the discussion thread.
- Remember to include your marketing costs from the Marketing Plan you completed in Week 6.
- Use the figures you arrived at in the operations and technology sections of your plan to help fill out your financial forms.
- Go through the worksheets in order. The Excel worksheets will automatically enter the numbers into your Income Statement as you enter them.
Develop the following financial sections of your NAB company’?s Business Plan. Attach the completed Word document to the discussion thread.
- Sources and use of funds
- Plan assumptions
- Break-even analysis
Example:
Sources and Uses of Funds
The Spring Citrus Tangerina Water Company is receiving the following sources of funds:
1) Melinda Cates Capital Investment – $40,000
2) Friends and Family – $20,000
3) Northrup Grumman – $500,000
The funds will be used to cover operating expenses, cost of goods and salaries.
Plan Assumptions
The Spring Citrus Tangerina Water Company has two product lines: Orange and Tangerine flavored Water. The first year is expected to yield a profit. Years 2-5 are expected to achieve at least a 5% profit and grow with each year. The company is expected to have a 10% growth by the end of the 5th year.
Break-even Analysis
The Break-even is the point where Spring Citrus Tangerina Water Company will make enough income to pay for its expenses. At this point in time the company is making a profit. The break-even analysis uses the companies fixed expenses such as rent, utilities, and salaries and divides this by the gross profit margin. The Break Even Point for year one is $40,402 and for year two is $37,171.