Manufacturing Equipment Investment Excel Calculator
Originally published: 26/04/2019 15:15
Publication number: ELQ-71362-1
View all versions & Certificate
certified

Manufacturing Equipment Investment Excel Calculator

This is an extremely useful calculator for evaluating whether to buy new, old, or lease manufacturing equipment.

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!

This Best Practice includes
1 Excel Model, 1 Excel Demo version

Acquire business license for $9.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Andrew Grigolyunovich, CFA, CFM, FMVA


See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Manufacturing Equipment Investment Excel Calculator?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...