Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Slove Lady M Break Even Excel with formulas YEAR ONE Break-even Rent $ 310,600.00 Utilities $ 38,644.00 Labor $ 594,750.00 COGS (50% of Gross Sales)
Slove Lady M Break Even Excel with formulas
| YEAR ONE | ||||||
| Break-even | ||||||
| Rent | $ 310,600.00 | |||||
| Utilities | $ 38,644.00 | |||||
| Labor | $ 594,750.00 | |||||
| COGS (50% of Gross Sales) | $ 944,620.00 | |||||
| Total Cost | $ 1,888,614.00 | |||||
| Gross Sales | $ 1,889,240.00 | |||||
| Average Retail per Cake | $ 80.00 | |||||
| Cakes Sold per year | 23,616 | |||||
| Cakes Sold per day | 64.7 | |||||
| Net Income | $ 626.00 | |||||
| Margin | 0.03% | Growth Rate | ||||
| Year One | Year Two | Year Three | Year Four | Year Five | ||
| Rent (3% escalation) | $ 310,600.00 | |||||
| Utilities (3% escalation) | $ 38,644.00 | |||||
| Labor (5% escalation) | $ 594,750.00 | |||||
| COGS (50% of Gross Sales) | $ 944,620.00 | |||||
| Total Cost | $ 1,888,614.00 | |||||
| Gross Sales | $ 1,889,240.00 | |||||
| Average Retail per Cake | $ 80.00 | |||||
| Cakes Sold per year | 23,616 | |||||
| Cakes Sold per day | 64.7 | |||||
| Net Income | $ 626.00 | |||||
| Margin | 0.03% | |||||
| Start-up Cost Left | $ 999,374.00 | |||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals Of Investments
Authors: Charles J. Corrado
3rd Edition
0072829192, 978-0072829198
