Manufacturing Company Investment Excel Calculator

Description
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 utilise 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 labour costs and electricity.

NPV Plan

NPV Chart

Solver

Attached with this template is a demo version which helps the user visualise which data inputs should be made and where. If you have any other questions or queries about this model, you can either start a discussion below, or reach out directly by private message via my Eloquens author channel.

To show you appreciation for this tool, you’re very welcome to leave a rating and review below!