Business Plan & Excel

Revisions for Business Plan Financials Excel-Topmark Cafe

Please check and adjust the following:

· Sales Projections - our goal is to reach total gross sales of over 1 million by the end of the second year. Your sales are too high for a startup in the first year. Reduce the sales in the first year. Also, identify your products in the far left column.

· Inventory- the Inventory Expense must equal the Cost of Goods Sold for every month. Please click on the red triangle in the cell for additional information and adjust for assignment 3. Also, identify your products in the far left column.

 How to complete the inventory worksheet – with example

· Staff budget- account for every staff member.  Keep in mind you will need to develop a management hierarchy. As your business grows, increase the number of employees. You should have more employees and managers in the second year than in the first year.

How to complete the Staff Budgeting worksheet

· Marketing Budget – the cost of developing the website should be a one-time cost input in January 2021 and should also include the monthly maintenance costs.

 How to complete the Marketing Budget worksheet

· Capital Investment - Please list an angel investor or a venture capitalist, instead of a partner. They should have equity less than 50%. 

How to complete the Capital Investments worksheet

· Income statement- complete the maintenance expense (this could be cleaning, and other expenses related to maintenance). 

 How to complete the Income Statement worksheet

· Cash Flow Statement- The income tax payment must match the provisions for taxes on income on the income statement. Your estimated tax should not be zero.

 How to complete the Cash Flow Statement worksheet

Be sure to complete the worksheets per the instructions in the Guidelines documents.

The Written Summary of the Financials

For this week's discussion, you will provide a  written summary  of the key financials investors would like to know before looking at your business plan in more detail.

See below for the key topics you need to focus on. Headings are required in your response (bold). 

Keep in mind that you must follow the guidelines in the Snack-Food Company Guidelines and Company of Choice Guidelines documents. 

Do not include tables in this written section of the financials or copy tables from Excel.  You are to provide a summary of the key financial information. You will focus on the first two years. 

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.

1.Projected Sales

· The projected sales will help the investors understand your sources of revenue (product lines or service options) and your projected sales.

· List your sources of revenue (specify your product lines/ service options you plan to offer) and provide the average sales per year for each product line/ service option.

· You can also list milestones such as overall sales of 1 million by the end of the second year.

2.Personnel Overview

· Clarify how many employees you currently have and plan to have in the future.

· Mention the key skills and experience (very brief) of your management team. This will help your investors understand you have a competent and experienced team to grow the business.

3. 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. Remember, we are writing the business plan with this purpose.

4.Use of Funds

· Provide a list of expenses you plan to make (major expenses) with the funds you plan to raise from the investors. They would want to know what you plan to do with the money.

5.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

· The projected profits will indicate when the company will become profitable and how much these profits are expected to be. 

· Specify the estimated yearly profit estimates for the first and second year.