Manufacturing Company Investment Excel Calculator
This is a detailed and effective Excel calculator for those wanting to evaluate whether the purchasing of new equipment will generate a good return on investment.
Suited to a manufacturing company and available to download and utilize immediately, this calculator generates the ROI based on assumptions and break-even sales volume.
The Manufacturing Investment Calculator is very easy to use and is equipped with clear instructions for each section of the spreadsheet.
The following elements are included in this download:
Assumptions: Main assumptions include interest rate per annum and employment taxes and benefits, % of salaries.
Scenarios: The model helpfully evaluates 4 different scenarios for the manufacturing investment.
Direct Costs: This allows input for the sales price and direct costs per unit for each product, such as direct labor costs and electricity.
NPV Plan
NPV Chart
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.
