This is an easy-to-use tool for those looking to open a café and wanting to calculate its return on investment.
Available to download and use instantly, this MS Excel calculator will demonstrate the return of the café and the break-even sales volume, calculated from the assumptions.
Within this calculator are the following worksheets:
Assumptions: This contains the key assumptions that are needed to calculate current costs and sales in the NPV section. Includes assumptions such as the area of commercial premises, rent, public utilities and others.
Investments: This section is for the user to input all that is necessary for the café, including kitchen equipment, hall equipment, and furniture.
Employees: Worksheet used to calculate the total monthly salary for all employees.
Scenarios: This part helps to evaluate the investments in four different scenarios (Min, Avg, Max, Break-even)
NPV Plan: This is the main worksheet, which contains a table with the main calculations for the investment project. In this worksheet such indicators as PV, NPV and ROI are calculated.
NPV Chart: This shows your projected café development over time.
Solver
Let us do the work for you!
Feel free to contact our team in case you need support with budgeting your company. Our team provides financial modeling services to companies around the world. Actually, this is our core business. We have a lot of experience with creating budgets for service companies and know the specifics of the business.
