Manufacturing Equipment Investment Excel Calculator

Description
This is a MS Excel calculator which will help you to evaluate the different ways of acquiring manufacturing equipment.

Instantly downloadable, this tool will compare whether leasing the equipment, buying it new, or buying it used, is in your best interests. The tool also allows comparison between two different offers for purchasing new / used equipment.

This template contains the following worksheets for data input and presentation:

- Data: This is the worksheet that contains the main assumptions for your company. Data that you enter in this worksheet automatically impacts all the other worksheets as well as the final results.

- Calculations – Equipment 1: This is the worksheet that shows calculations for a scenario in which company decides to purchase the new equipment. Almost all cells are calculated automatically, using data from the “Data” worksheet.

- Calculations – Equipment 2: This is the worksheet that shows calculations for scenario in which company decides to purchase another equipment. Again, almost all cells are calculated automatically, using data from the “Data” worksheet.

- Effect on Income Statement: This is a graphical representation of the effect that the purchase has on your income statement.

- Effect on Cash Flow: This is a graphical representation of the effect that the purchase has on your cash flow statement.

- Hourly Price

This model is simple to use, with clear instructions at every step, however, if you should have any problems and questions, feel free to contact me either by Eloquens private message, or by starting a discussion below!