Final Paper Abby

Thank you for the updated worksheet.

In this worksheet, please adjust the following: 

 

· Sales Projections- our goal is to reach total gross sales of over 1 million by the end of the second year. Increase your sales to reach this goal. Look at row 107 total at the end of the second year. 

How to complete the Sales Projections worksheet

 

· Inventory- the Inventory Expense must equal the Cost of Goods Sold for every month and product line, for the first two years. You must manually adjust the first two months for each product line and then the rest of the months should auto-populate. See the video example below. Please click on the red triangle in the cell for additional information and adjust for assignment 3.

How to complete the inventory worksheet – with example

 

 

· Staff budget- Revise this completely. You have 1000 managers and so on. Adjust to reflect the employees in each area of your business.  Keep in mind you will need to develop an organizational 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 April 2022. This cost is missing.

· How to complete the Marketing Budget worksheet

 

· Capital Investment – Specify the funds you had to start the business (equity or loans). Also, input the funds you plan to raise from investors (required per the guidelines). The funds from investors can be from angel investors, venture capitalists etc. These are equity investments so you will note in your paper the percentage of your company you will be willing to give in exchange for these funds. 

How to complete the Capital Investments worksheet

 

· Income statement- complete all the expenses indicated in the guidelines. You must show profits.

How to complete the Income Statement worksheet

 

· Cash Flow Statement- reflect the income tax payments (check red triangle). The income tax payment must match the provisions for taxes on income on the income statement. Check the red triangle in the income tax payment cell on the cash-flow statement for instructions and view the video below for a demonstration. 

How to complete the Cash Flow Statement worksheet