considering a small catering business that does fresh pasta

1. What are your set-up costs?

2. How will you pay for your set-up costs?

3. What are your recurring Operating Expenses?

4. Average Transaction:

a. What is the average amount (price) you will receive for your product or service?

b. What are your direct costs (cost of good sold) for providing that product or service?

c. How many transactions do you plan to have each month?

Jan Jul

Feb Aug

Mar Sep

Apr Oct

May Nov

Jun Dec

5. Using the attached spreadsheet template, enter the revenue, cost of goods sold, and operating expenses for the first year of your business.

Please look at all of the examples so you know how to do this.

Numbers File Edit Insert Table Organize F Format Arrange View Window Help D 2 Q 8 Fri Dec 2 5:00 PM Income Statement Template 125% BB, A View Zoom Add Category Pivot Table Insert Table Chart Text Shape Media Comment Share Format Organize + Income Statement Mixed-Product Worksheet Sheet Sheet Name Instructions: Fill in highlighted cells. Do not write in white cells as you will erase the formulas. For the "Cost of Goods Sold Worksheet", fill in each item with the per unit cost. If you need to add an item, Income Statement highlight the center two cells, right click and select "insert". The total costs of goods sold will automatically fill in to the profit/loss worksheet. (pretty cool, huh!) YEAR ONE Income JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL Background # of clients/products sold Ave Income per client/product boooo Revenue o o o o o o oo oo oo Ave. Cost of Goods Sold per client/product of of Duplicate Sheet Total Cost of Goods Sold o Gross Profit of of Delete Sheet Operating Expenses Salaries/Payroll Rent of Utilities Marketing Insurance pooooooc o o o o o o o C Office Expenses/Supplies Professional Fees Total Net Income Before Taxes DEC 2 8 tv