Discuss the two ways to calculate present value using a spreadsheet program such as Microsoft Excel.

What will be an ideal response?


There are two ways to calculate present value using a spreadsheet program such as Microsoft Excel. The discount adjustment factors can be entered from an external table, and a simple formula is used to apply the factors. However, many analysts find it easier to use a built-in NPV formula that handles the calculations. The example in the text shows costs and benefits for a proposed information system with a one-year development period, a three-year useful life, and a 6% discount rate.

Computer Science & Information Technology

You might also like to view...

MC The __getattribute__ method executes when______ .

a) an attempt to modify a class value is made. b) an attempt to access an attribute not in the __dict__ is made. c) any attribute access attempt is made with the dot operator. d) None of the above.

Computer Science & Information Technology

Non-repudiation is

(a) Legally proving that a message was sent or received. (b) Ensuring that the sender and receiver of a message prove their identities to each other. (c) Ensuring that information transmitted over the Internet has not been captured or passed on to a third part. (d) Ensuring that information you send or receive has not been compromised or altered.

Computer Science & Information Technology

On the left end of the title bar is the ____ toolbar, containing buttons for saving a file, undoing an action, and redoing an action.

A. Insertion Point B. Document C. Quick Click D. Quick Access

Computer Science & Information Technology

From most restrictive to least restrictive, the access modifiers are:

a. protected, private, public b. private, protected, public c. private, public, protected d. protected, public, private

Computer Science & Information Technology