Excel Tools and Net Present Value
Not what you're looking for?
Master
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
Purchase this Solution
Solution Summary
This solution first discusses the various Excel tools available and then illustrates how to solve a net present value problem.
Solution Preview
34. The H Lookup and V Lookup only produce results on a row-by-row or column-by-column basis ...
Purchase this Solution
Free BrainMass Quizzes
Motivation
This tests some key elements of major motivation theories.
Introduction to Finance
This quiz test introductory finance topics.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.