The Churreria

Location: Rexburg, ID

Description:

The Churreria is a local favorite when it comes to fried food. It’s also the only place in town to get a churro filled and drizzled with an assortment of flavors. The attached spreadsheet is a financial forecast and summarization of the company’s financial position. We have taken many liberties in estimating the values, but the structure of the forecast is accurate. The purpose of our model is to provide a valuation for the company based on the information allowed to us.

The forecasts that follow list key indicators of company health such as estimated cost of capital, estimated rate of return, financial statements, and cash flows. Additionally, we have included a decision tree and a Black Scholes model to estimate the expected value of moving to a new location.