Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

SOFTWARE

Smart Investment Tool

Download	Size
The Smart Investment Tool 1-0-1.xlsm	7.99 MB

Version

1.0.1

Type of Software

Excel Macro

Last Updated

06/16/2021

NIST Author

Douglas Thomas

This tool calculates metrics for investment analysis documented in NIST Advanced manufacturing Series 200-5. It calculates net present value, internal rate of return, and payback period along with executing sensitivity analysis using Monte Carlo techniques. The tool helps to identify the most economical projects/investments. For instance, it could be used to identify the most economical heating and cooling system or it might be used to rank a set of potential investments.

Version 1.0.1 corrects an error in the Monte Carlo analysis function.

Related Publications

Investment Analysis Methods: A practitioner's guide to understanding the basic principles for investment decisions in manufacturing

Download	Size
The Smart Investment Tool 1-0-1.xlsm	7.99 MB

Version

1.0.1

Type of Software

Excel Macro

Last Updated

06/16/2021

NIST Author

Douglas Thomas

Organizations

System/Platform Requirements

Software tool contains macros.

Licensing Information

This software was developed at the National Institute of Standards and Technology by employees of the Federal Government in the course of their official duties. Pursuant to title 17 Section 105 of the United States Code this software is not subject to copyright protection and is in the public domain. NIST assumes no responsibility whatsoever for its use by other parties, and makes no guarantees, expressed or implied, about its quality, reliability, or any other characteristic. We would appreciate acknowledgement if the software is used. This software can be redistributed and/or modified freely provided that any derivative works bear some notice that they are derived from it, and any modified versions bear some notice that they have been modified.

Contact

Douglas Thomas

douglas.thomas@nist.gov

(301) 975-4918

Created June 17, 2020, Updated June 24, 2021