Cash ProForma
torrbo
excel20assignmentpizzeria-spring20201420template.xlsxGrading criteria
| Criteria: | Your current score: | ||
| All information cells are referenced back to the assumption page., | 30 points | ||
| Loan payment is calculated using a function.. | 10 points | ||
| Recommendations are based on spread sheet what if analysis. | 10 points | ||
| The dollar break-even point is calculated | 10 points | ||
| Sheets are appropriately labeled | 10 points | ||
| The chart is present and reflects worksheet content. | 10 points | ||
| Taxes are calculated correctly using boolean logic. | 10 points | ||
| Twelve months are presented and an annual total is given. | 10 points | ||
| Score (out of 100) | 0 |
Sheet 1
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Total | |
| Revenue: | |||||||||||||
| Pizza | |||||||||||||
| Chicken Wings | |||||||||||||
| Salads | |||||||||||||
| Fries | |||||||||||||
| Sodas | |||||||||||||
| Monthly Revenue | |||||||||||||
| Expenses: | |||||||||||||
| COGS | |||||||||||||
| Rent | |||||||||||||
| Phone | |||||||||||||
| Electricity | |||||||||||||
| Insurance | |||||||||||||
| Advertising | |||||||||||||
| Hourly Wages | |||||||||||||
| Salaries | |||||||||||||
| Loan Payment | |||||||||||||
| Total Expenses | |||||||||||||
| Income Before Tax | |||||||||||||
| Tax | |||||||||||||
| Net Income | |||||||||||||
| Cash Flow |
Sheet 2
| Assumptions Made: | ||||||||||
| Products: | ||||||||||
| Pizza selling price | ||||||||||
| Wings selling price | ||||||||||
| Salad selling price | ||||||||||
| Fries selling price | ||||||||||
| Sodas selling price | ||||||||||
| Pizza COGS | Customer Traffic Flow: | Tue | Wed | Thu | Fri | Sat | Sun | Total | ||
| Wings COGS | Customers: Weekdays | 0 | 0 | 0 | 0 | 0 | ||||
| Salad COGS | Customers: Weekend | 0 | 0 | 0 | ||||||
| Fries COGS | 0 | |||||||||
| Soda COGS | ||||||||||
| Unit Sales per Week: | Pizza | Wings | Salads | Fries | Sodas | Total | ||||
| Fixed Costs: | Weekdays | 0 | 0 | 0 | 0 | 0 | 0 | |||
| Rent | Weekends | 0 | 0 | 0 | 0 | 0 | 0 | |||
| Phone | Weekly Total | 0 | 0 | 0 | 0 | 0 | 0 | |||
| Electricity | ||||||||||
| Insurance | Revenue: | Pizza | Wings | Salads | Fries | Sodas | Total | |||
| Advertising | Weekly Revenue: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Monthly Revenue: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Operating Information: | ||||||||||
| # of days open (weekdays) | Cost of Goods Sold: | Pizza | Wings | Salads | Fries | Sodas | Total | |||
| # of days open (weekends) | Weekly COGS: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Hours open (weekdays) | Monthly COGS: | $ - 0 | ||||||||
| Hours open (weekends) | ||||||||||
| Hourly wage | Weekly Wages: | Tue | Wed | Thu | Fri | Sat | Sun | Total | ||
| Customers per hour weekdays | Hourly | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Customers per hour weekends | ||||||||||
| Hourly employees/day (weekdays) | ||||||||||
| Hourly employees/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 | ||||||||||
| Growth rate | ||||||||||
| Weeks Per Month | ||||||||||
| Loan period (years) | ||||||||||
| Loan interest rate | ||||||||||
| Taxes: | ||||||||||
| If income before tax is equal or greater than: | Tax rate = | |||||||||
| If income before tax is less than: | Tax rate = | |||||||||
| Coded Document |
Sheet 3
| Start Up Costs: |
| Kitchen equipment |
| Sales equipment (cash register, etc.) |
| Initial inventory |
| Pre-opening marketing |
| Diner fixtures (chairs, tables etc.) |
| Oil painting |
| Licenses |
| Security deposit |
| Initial insurance payment |
| Total |
| Owner's Equity |
| Cash Reserves Elke Leeds: Cash Reserves represent an amount in excess of what is needed to open your business. This reserve fund is borrowed and kept to protect your business against negative cash flow or losses. It replaces what would normally be considered an available line of credit. |
| Loan Amount |
