This is an ROI calculator for health or beauty care companies that plan to invest in new equipment and want to calculate their breakeven sales volume and the return on investment with given assumptions.
Available to download and input data immediately, this MS Excel spreadsheet contains the following tabs:
• Assumptions: This worksheet contains key assumptions that are needed for the calculations. Fill in the data for the new services you plan to provide for each year.
• Cost of Treatments: This worksheet calculates the direct costs of one treatment. Direct costs are those that are directly dependent on the number of treatments.
• Scenarios: This model facilitates evaluating investments in four different scenarios:
- Min - the worst-case scenario with the lowest number of treatments per month,
- Avg - the base case scenario,
- Max - the optimistic scenario with the highest number of treatments per month,
- Break-Even - corrects Avg scenario by multiplying Avg sales by a correction factor.
• NPV Plan: This is the main worksheet, which contains a table with the main calculations for the investment project. This worksheet calculates indicators such as PV, NPV and ROI.
• NPV Chart
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.