A new client of yours, Ray Marquez, wants to open a small diner selling pizzas, chicken wings, salads, french fries,...
osctru
pizzeria_diner_template__spring_2014.xlsxSheet1
| Month 1 rmarquez: Marquez: Spring 2014 Change to appropriate month name | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Revenue: | ||||||||||||
| Pizza | ||||||||||||
| Chicken Wings | ||||||||||||
| Salads | ||||||||||||
| Fries | ||||||||||||
| Sodas | ||||||||||||
| Monthly Revenue: | ||||||||||||
| Expenses: | ||||||||||||
| Cost of Goods Sold (COGS) | ||||||||||||
| Rent | ||||||||||||
| Phone | ||||||||||||
| Electricity | ||||||||||||
| Insurance | ||||||||||||
| Advertising | ||||||||||||
| Hourly Wages | ||||||||||||
| Salaries | ||||||||||||
| Loan Payment rmarquez: Marquez: Spring 2014 Use the appropriate financial function for this calculation |
||||||||||||
| Total Monthly Expenses: | ||||||||||||
| Income Before Taxes (IBT) | ||||||||||||
| Tax rmarquez: Marquez: Spring 2014 Use the appropriate logical function for this calculation |
||||||||||||
| Net Income | ||||||||||||
| Cash Flow rmarquez: Marquez Spring 2014: Cash Flow begins with the amount of cash you have available - this is usually your Cash Reserves. It is added to the Net Income at the end of Month 1 to begin your running total. |
||||||||||||
| Spring 2014 section 01 |
Sheet2
| Assumptions Made: | ||
| Products: | ||
| Pizza selling price | ||
| Wings selling price | ||
| Salad selling price | ||
| Fries selling price | ||
| Sodas selling price | ||
| Pizza COGS | ||
| Wings COGS | ||
| Salad COGS | ||
| Fries COGS | ||
| Soda COGS | ||
| Overhead Costs: | ||
| Rent | ||
| Phone | ||
| Electricity | ||
| Insurance | ||
| Advertising | ||
| Operating Information: | ||
| # of days open (weekdays) | ||
| # of days open (weekends) | ||
| Hours open (weekdays) | ||
| Hours open (weekends) | ||
| Hourly wage | ||
| Customers per hour weekdays | ||
| Customers per hour weekends | ||
| Employees per day (weekdays) | ||
| Employees per day (weekends) | ||
| % of customers purchasing pizzas | ||
| % of customers purchasing wings | ||
| % of customers purchasing salads | ||
| % of customers purchasing fries | ||
| % of customers purchasing sodas | ||
| Manager annual salary | ||
| Assistant manager annual salary | ||
| Monthly Growth Rate | ||
| Loan period (in years) | ||
| Interest rate | ||
| If IBT is greater than or equal to | $27,500 | Tax rate = |
| If IBT is less than | $27,500 | Tax rate = |
| Weeks per month | ||
| Spring 2014 section 01 |
Sheet3
| Start Up Costs: |
| Kitchen equipment |
| Cash register and sales equipment |
| Initial inventory |
| Pre-opening marketing programs |
| Diner fixtures (chairs, tables etc.) |
| Oil painting |
| Licenses |
| Security deposit |
| First Insurance payment |
| Total: |
| Owner's equity |
| Cash Reserves rmarquez: Marquez: Spring 2014: Cash Reserves represents an amount in excess of what is needed to open your business. This reserve fund is kept to protect your business against negative cash flow or losses. |
| Loan amount |
| Spring 20014 section 01 |
