Explore BrainMass

Excel Tools and Net Present Value

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

34. As a bank loan officer, you want to reference detailed columnar loan portfolio data with a list of past-due loans. Which of the following is the most effective tool for doing so?
a. Pivot table
b. H Lookup
c. Search function
d. Scatter plot
e. V Lookup

35. Suppose that you are approached with an offer to purchase an investment that will provide cash flows of $1,200 per year for 15 years. The cost of purchasing this investment is $9,800. You have an alternative investment opportunity, of equal risk, that will yield 8% per year. What is the NPV that makes you indifferent between the two options?
a. $10,271.37
b. $436.46
c. $1,197.30
d. $471.37

© BrainMass Inc. brainmass.com September 20, 2018, 4:38 am ad1c9bdddf - https://brainmass.com/business/net-present-value/excel-tools-and-net-present-value-394811

Solution Preview

34. The H Lookup and V Lookup only produce results on a row-by-row or column-by-column basis ...

Solution Summary

This solution first discusses the various Excel tools available and then illustrates how to solve a net present value problem.