Question

Consider the following cash flows: Year points o-NM Cash Flow 19,400 10,400 9,320 6,900 ( 8 00:23:43 eBook a. What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the NPV at a discount rate of 10 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the NPV at a discount rate of 20 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d. What is the NPV at a discount rate of 30 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) References a. Net present value b. Net present value c. Net present value d. Net present value

Answer 1

a	NPV at 0%	7220.00
b	NPV at 10%	2941.10
c	NPV at 20%	-268.06
d	npv at 30%	-2744.56

Working

AutoSave o 9.3HD Book1 - Excel Sign in - 0 X File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments - 11 A = = 0 Calibri BIU - B -A A = E Insert - Delete - Format Paste La- - General 3$ -% Number . Conditional Format as Formatting Table - Styles Cell Styles Sort & Find & Filter - Select Editing Clipboard Font Alignment Cells B16 - X fic Year D E F G Year NPV at 0% =NPV(0%,C18:C20)+C17 Cash flow -19400 10400 9320 6900 NPV at 10% =NPV(10%,C18:C20)+C17 NPV at 20% =NPV(20%,C18:C20)+C17 d npv at 30% =NPV(30%,C18:C20)+C17 20 Sheet1 Sheet2 Sheet3 Ready E -- ENG + 100% 0 2 10:33 AM