Question 1: 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
Question 2: 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