60.1K

Verified Solution

Link Copied!

D E F G . I J K L M N o P Q R S T 2 3 Value of mixed streams. Find the present value of the streams of cash flows shown in the following table. Assume that the firm's opportunity cost is 12%. 4 5 6 6 7 A Cash flow $-2,000 3,000 4,000 6,000 8,000 Year 1 2 3 4 5 Year 1 2-5 6 B Cash flow $10,000 5,000/yr 7,000 Year 1-5 6-10 Cash flow $10,000/yr 8,000/yr 8 9 10 11 12 13 Solution 14 15 16 17 18 Project A Opportunity cost CF1 CF2 CF3 CF4 CF5 Net present value 12% $-2,000 $3,000 $4,000 $6,000 $8,000 19 20 21 22 23 Problem 5-30 2 6 4:12 24 25 26 27 28 Project B Opportunity cost CF1 CF2 CF3 CF4 CF5 CF6 Net present value 12% $10,000 $5,000 $5,000 $5,000 $5,000 $7,000 29 30 31 32 33 34 35 36 37 38 39 Project C Opportunity cost CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 12% $10,000 $10,000 $10,000 $10,000 $10,000 $8,000 $8,000 $8,000 $8,000 40 41 42 43 44 Problem 5-30 33 34 35 36 37 38 39 40 Project C Opportunity cost CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 CF10 Net present value 12% $10,000 $10,000 $10,000 $10,000 $10,000 $8,000 $8,000 $8,000 $8,000 $8,000 41 42 43 44 45 46 47 48 Points 1 49 Requirements 1 In cell E22, by using cell references to the given data and the function NPV, calculate the 50 net present value of project A. 2 In cell E32, by using cell references to the given data and the function NPV, calculate the 51 net present value of project B. 3 In cell E46, by using cell references to the given data and the function NPV, calculate the 1 1 Problem 5-30 ( 3 o C

Answer & Explanation Solved by verified expert

See Answer