Business Finance - Management Assignment 2

Tutorial on how to complete the Business Plan Financials Excel document

· Be sure to check the guidelines for the snack food company or company of your choice (as applicable) as you complete the Financials Excel template.

· Ensure the financials match the information you have in the business plan.

· You will submit this entire document, as required, with week 4 discussion, Assignment 2, Week 7 discussion, Assignment 3, and Assignment 4.

Overview of the Excel document

How to complete the Setup worksheet -start the business the month and year the quarter starts 

How to complete the Sales Projections worksheet- reach sales of over 1 million by the end of the second year

How to complete the Inventory worksheet-

-the inventory expense must equal the COGS every month and for every product line

How to complete the inventory worksheet – with example

How to complete the Capital Ex worksheet

How to complete the Staff Budgeting worksheet- you should have more managers and employees in the second year than the first as your business is growing. 

How to complete the Marketing Budget worksheet

How to complete the Professional Services worksheet

How to complete the Capital Investments worksheet-  specify the funds you plan to raise from investors and the equity you plan to give in exchange for these funds. 

How to complete the Income Statement worksheet

How to complete the Cash Flow Statement worksheet

How to complete the Balance Sheet worksheet

How to complete the Break-even worksheet

Notes:

1. If you are not selling physical good with your service, you can set the Cost of Goods Sold at zero (on the Sales Projections worksheet). This also means your inventory worksheet will be blank. 

2. The income statement and the cash-flow statement must be in the positive (no negative numbers).     

3.  Do not delete any columns, rows, or cells. If you want to change the number in a cell, just type over. If something does not apply to you, just leave it at zero, but do not delete the column or row, as this will cause the formulas to be deleted, and the document to have errors. If you have REF or VALUE  errors showing, you must start over on a clean copy.