Excel
Pmnguyen1989
ExcelAssignmentSparklesDessertCafeTemplatesum2020copy.xlsxGrading criteria
| Criteria: | Your current score: | ||
| Sheets are appropriately labeled | 5 points | ||
| All information cells on cash proforma are referenced back to the assumption page, calculations are correct, all fields have values, twelve months are presented and an annual totals are given as well as a monthly totals. | 35 points | ||
| Assumptions and startup worksheets setup and complete. | 15 points | ||
| Recommendations are based on cash proforma information and what if analysis Use separate worksheet for each recommendation. | 15 points | ||
| The charts are present and reflects worksheet content. | 10 points | ||
| Taxes are calculated correctly using boolean logic. | 10 points | ||
| Loan payment is calculated using a function.. | 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: | |||||||||||||
| Cupcakes | |||||||||||||
| Whole Cakes | |||||||||||||
| Cake Slices | |||||||||||||
| Whole Pies | |||||||||||||
| Pie Slices | |||||||||||||
| Custard | |||||||||||||
| Yogurt Granola Parfait | |||||||||||||
| Ice Cream Cones | |||||||||||||
| Soda | |||||||||||||
| 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: | ||
| Cupcakes selling price | ||
| Whole Pies selling price | ||
| Pie Slices selling price | ||
| Whole Cakes selling price | ||
| Cake Slices selling price | ||
| Custard selling price | ||
| Yogurt Granola selling price | ||
| Ice Cream Cones | ||
| Soda | ||
| Cupcakes COGS | ||
| Whole Pies COGS | ||
| Pie Slices COGS | ||
| Whole Cakes COGS | ||
| Cake Slices COGS | ||
| Custard COGS | ||
| Yogurt Granola COGS | ||
| Ice Cream COGS | ||
| Soda COGS | ||
| Fixed 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 | ||
| Hourly employees/day (weekdays) | ||
| Hourly employees/day (weekends) | ||
| % of customers purchasing Cupcakes | ||
| % of customers purchasing Whole Pies | ||
| % of customers purchasing Pie Slices | ||
| % of customers purchasing Whole Cakes | ||
| % of customers purchasing Cake Slices | ||
| % of customers purchasing Custard | ||
| % of customers puchasing Yogurt Parfait | ||
| % of customers purchasing Ice Cream Cones | ||
| % 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 |
| Cafe fixtures (chairs, tables etc.) |
| Decorations |
| 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 |
