Using the information below, please help fill in this table. Please provide detailed equations, excel formulas, and explanations to better understand this process. Thank You!

Question: Assuming sales in the$1$st year are breakeven, what is the growth rate of sales required to pay the start up costs for the WTC location within$5$ years?

Break Even Number of Cakes:$23,600$

Rent $$310,600|3\%$ Annual Escalation

Utility Costs $$38,644|3\%$ Annual Escalation

Labor Costs $$594,750|5\%$ Annual Escalation

Cakes $$80$

COGS $$40|50\%$Assumption$$Total Fixed Costs: $$943,994$

In forecasting the next five years, Romaniszyn and Tom assumed the following:

$*$ Annual sales growth would be $20\%$ for $2015,40\%$ in $2016($since the World Trade Center location would potentially be opening in late $2015),$ and $25\%$ for the three years afterward.

$*$ They assumed an annual sales growth rate of $4\%$ in perpetuity.

$*$ Cost of goods sold had consistently been approximately $25\%$ of sales but had been dipping in the past two years. They expected it to remain approximately constant over the next five years.

$*$ With rent and labor costs making up a large portion of their expenses, Romaniszyn and Tom expected SG&A costs to remain approximately the same as prior years, but to decrease by one percentage point each year.

$*$ Although R&D costs had been negligible in the past, they decided they should probably assume some cost in the future as well, albeit only $0\mathrm{.}1\%$ of sales.

$*$ With the prospect of opening a new store in the following year, the two decided to allocate $$1,000,000$ for capital expenditures in $2015.$ After that, however, they assumed that no new stores would be opened and capital expenditures would remain approximately $0\mathrm{.}3\%$ of sales.

$*$ Depreciation was expected to rise by five percentage points each year starting in $2014,$ becoming $100\%$ of capital expenditures in $2019.$

$*$ Additions to intangibles would be zero.

$*$ Amortization would be zero.

$*$ The tax rate would continue to be $35\%.$

$*$ The two expected the change in working capital to remain a constant percent of the change in sales and behave similarly to $2014.$

$*$ In order to do a discounted cash flow analysis, Romaniszyn and Tom assumed Lady M$\text{'}$s weighted average cost of capital was $12\%.$ They chose a $12$x EBITDA multiple.