Computer Science Assessment - CREATING A SPREADSHEET FOR DECISION SUPPORT

2014 2015 2016 2017 0.3 0.3 0.3 1000000 1000000 1000000 225000 235000 245000 5.5E-2 0.06 0.06 364 365 364 0.15 0.17 0.19 1.65 1.75 1.85 1.25 1.5 1.75 25000 26000 27000 2014 2015 2016 2017 2014 2015 2016 2017 1000000 0 2014 2015 2016 2017 1250 1000 3 2014 2015 2016 2017 1000000 2014 2015 2016 2017 Constants 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