Problem Solving with Excel

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

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

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

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))

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…

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…

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…

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  …

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…

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…