2014
2015
2016
20170.3
0.3
0.31000000
1000000
1000000225000
235000
2450005.5E-2
0.06
0.06364
365
3640.15
0.17
0.191.65
1.75
1.851.25
1.5
1.7525000
26000
270002014
2015
2016
20172014
2015
2016
2017100000002014
2015
2016
20171250100032014
2015
2016
201710000002014
2015
2016
2017Constants
Tax rate
NA
Minimum cash needed to start year
Fixed administrative expense
Interest rate for year
Business days per year
Cost per doughnut
Cost per cup of coffee
Cost per muffin
Average salary per worker
Inputs
Sell muffins? (Y=Yes N=No)
Growth rate (H=High M=Medium L=Low)
Pricing Power (Y/N)?
Summary of key results
Net income after taxes
End-of-year cash on hand
End-of-year debt owed
Calculations
Average number of doughnuts sold per day
Average cups of coffee sold per day
Average number of muffins sold per day
Margin per item
Number of workers
Income and Cash Flow Statements
Beginning-of-year cash on hand
Revenue
Yearly doughnut revenue
Yearly coffee revenue
Yearly muffin revenue
Total revenue
Costs
Yearly doughnut costs
Yearly coffee costs
Yearly muffin costs
Salary costs
Fixed administrative costs
Total costs
Income before interest and taxes
Interest expense
Income before taxes
Income tax expense
Net income after tax
Net cash position (NCP)
Borrowing from bank
Repayment to bank
Debt Owed
Beginning-of-year debt owed
Bakery
Attachments: