You are a partner in a small bakery that sells a variety of bread, rolls, cookies, and donuts. After reading OnwardLinks to an external site. by Howard Schultz, you fall in love the idea of making the bakery more than just a store. Instead, you want the bakery to be a place where people gather and build community. To do this, you look into the option of adding indoor and outdoor seating as well as a commercial coffee machine. You pitch the idea to the other partners and insist that it will likely be good for business as well. The partners want to see some numbers before they agree. They agree to let you use $1,500 to hire a consultant to help you put the numbers together. The partners expect a 12% return on investment (Cost of Capital). Since this is a partnership, we will not worry about Taxes and Depreciation. Here are the other relevant numbers: Cost of commercial coffee maker = $5,000; Cost of adding seating = $10,000 Life span is on average 10 years with no salvage value No opportunity costs but will complement current products. Estimated $2,500 increase in cash flows from sale of bakery items each year. Expect to Sell 15,000 cups of coffee in year 1. This should grow to 18,000 in year 2; 21,000 in year 3, and plateau at 24,000 in year 4. In year 1, a cup of coffee will sell for $2.00 with the expectation of increasing the price by 3% per year. In year 1, the cost to the bakery of a cup of coffee is estimated at 40/cup with the expectation of a 3% increase in the cost per year. Staffing will need to be increased. This is a fixed cost and estimated at $30,000 for year 1 with a 3% increase per year. Working Capital as a percent of next year's sales is estimated at 10%. You plug all the numbers into a handy spreadsheet found on the learning content page of this module, and see the the MIRR is 20.76% with an NPV of $24,443.45. You are very happy with the results, but your partners have questions.

1. Your partners notice that there is no analysis of risk. All they see is the most likely outcome (base case). Assume that the consultant is unavailable to provide you with a worst case or best case scenario until later that year. If partners wanted to make a decision now, give examples for how the risk could be mitigated.