## To get the daily interest rate, what should the client divide the yearly interest by?

1. Question 1 To get the daily interest rate, what should the client divide the yearly interest by? 1 point   7   12   365   730

## Should the client proceed with the investment?

4. Question 4 Should the client proceed with the investment? 1 point   Yes   No

## After evaluating the NPV for the advertising campaign, what is the NPV?

3. Question 3 After evaluating the NPV for the advertising campaign, what is the NPV? 1 point   628   1,628   3,265

## What formula can be found in cell E25 on the Culminating Exercise sheet when complete?

2. Question 2 What formula can be found in cell E25 on the Culminating Exercise sheet when complete? 1 point   =(D25/1000)*INDEX(\$A\$15:\$C\$16,MATCH(D25,\$B\$14:\$B\$16,1))   =(D25/1000)*INDEX(\$C\$14:\$C\$16,MATCH(D25,\$B\$14:\$B\$16,1))   =(D25/1000)*INDEX(\$A\$15:\$C\$16,MATCH(D25,\$C\$14:\$C\$16,1))

## What are the four components of loan formulas?

4. Question 4 What are the four components of loan formulas? 1 / 1 point   Rate, payments per year, current value, loan payment amount   Rate, present value of the loan, future…

## You are working with Net Present Value (NPV), which statement below reflects the current value of future cash flows?

1. Question 1 You are working with Net Present Value (NPV), which statement below reflects the current value of future cash flows? 1 / 1 point   Future cash flows are worth less…

## You are working with IRR formula, which of the following scenarios will not be computed?

3. Question 3 You are working with IRR formula, which of the following scenarios will not be computed? 1 / 1 point   The cash flows begin with three negative years followed by…

## Net Present Value (NPV) is the value of future dollars, in terms of today’s dollars, discounted based on given discount rates.

2. Question 2 Net Present Value (NPV) is the value of future dollars, in terms of today’s dollars, discounted based on given discount rates. 1 / 1 point   True   False  …

## When you use the match formula which of the following is the expected outcome?

3. Question 3 When you use the match formula which of the following is the expected outcome? 1 / 1 point   The lookup value   The sum of all values that match…

## Index formula is used to tell us which of the following?

2. Question 2 Index formula is used to tell us which of the following? 1 / 1 point   The value contained in a cell designated by the distance from the top left…