Financial Mangement Assignment

profileTopnotch4
excellassignment.xlsx

Sheet1

Coffeeshop plc
Up-front payment (time period 0) £1,200,000
Passenger numbers (2012)
Annual growth in passenger numbers (2013)
Annual growth in passenger numbers (2014)
Annual growth in passenger numbers (2015)
Annual growth in passenger numbers (2016)
Probability of passenger being customer 10%
Time Period
Average spending per customer (2012) 2011 2012 2013 2014 2015 2016
Annual increase in average spending (2013 onwards) No. of passengers
Gross margin No. of customers
Other operating costs (2012) Spending per customer
Annual increase in operating costs (2013)
Annual increase in operating costs (2014)
Annual increase in operating costs (2015)
Annual increase in operating costs (2016)
Cost of capital 15%