Plan Assumption and Financials Assignment
Before beginning work on this discussion post, review Chapter 16, “The Financials,” in your textbook. You have already read this chapter during the previous week. With your review this week, specifically examine:
- “Assumption Sheet,” pages 323–324 and “Sample Plan: Assumptions,” page 332.
- “Sources and Use of Funds,” page 317 and “Sample Plan: Sources and Use of Funds,” page 331.
- “Break-Even Analysis,” pages 320–321.
The financial plan must be based on decisions and facts. Investors want to know whether your business plan is realistic.
For This Week’s Discussion, Please Respond to the Following
Provide a written overview of the plan assumptions and key financials based on the information contained in your business plan and your Business Plan Financials Excel Template.
Use headings (bold) to address each required topic.
Be sure to include:
- Key Financial-Specific Worksheet in the Business Plan Financials Excel Template where the information can be found
- Projected Sales-Sales Projections worksheet
- Personnel Overview-Setup and Staff Budgeting worksheets
- Financing to Date and Funds you plan to raise from investors-Capital Investments worksheet
- Use of Funds-Capital Expenditures worksheet
- Break-Even Analysis-Break-Even worksheet
- Projected Profits-Income Statement worksheet
Important: do not copy tables from the Excel document in your discussion response. This is an overview of the key financials.
Post at least one substantive comment to another student’s post.
Notes
- You will use the information from this discussion post in the Week 10 assignment, Business Plan—Final.
- A bullet point under Part 1 asks you to incorporate financial information that will help to convince the investors.
Note:Start your response with a brief description of your business (no more than 3 sentences). Specify your company name, what business you are in, and the specific product or service you plan to sell.
Reply Quote 2 months ago
This week’s discussion is a written summary of the key financials investors would like to know before deciding to look at your business plan in more detail.
Do not copy tables from the Excel document in the discussion response.
Start your response with a brief description of your business (company name, what you do, and what you sell). This description should not be longer than 3 sentences.
Discuss the following and use bold headings to organize your response. You can find the numbers you need in your Excel document your completed last week (Business Plan Financials). Check the table provided in the discussion for the exact worksheet of where the information can be located. Be sure to include a brief description of your business.
- Projected Sales
- Specify your how many product lines or service options you offer for sales, then specify what these are.
- Specify the total projected sales per year for years one and two (from the sales projections worksheet). You can mention your goal to reach sales of over 1 million by the end of the second year.
- The projected sales will help the investors understand your sources of revenue (product lines or service options) and your projected sales.
- Personnel Overview
- Clarify how many employees you currently have and how many you plan to have in the future.
- Specify how many people you have in your management team and their roles. Mention the key skills and experience for each person on your management team (one sentence per person focusing on the most important information). This will help your investors understand you have a competent and experienced team to grow the business.
- Funds to Date and Funds you plan to raise
- Provide a list of the funds you already have (loans, money in the bank, etc.)
- Provide a list of the funds you are planning to raise from the investors and the equity you plan to give in exchange for these funds. Remember, we are writing the business plan for this purpose.
- Use of Funds
- Provide a list of expenses you plan to make (major expenses) with the funds you plan to raise from the investors. Include the cost for each major expense. They would want to know what you plan to do with the money.
- Break-Even Analysis
- The break-even number will clarify how much you need to sell just to cover your expenses.
- Provide just the average monthly break-even number for years 1 and 2.
- Projected Profits
- Specify the projected yearly profits for the first and second year from the income statement.
- The projected profits will indicate when the company will become profitable and how much these profits are expected to be.
Check the video below for an overview of this week’s discussion.