Page 1 of 1
A Year o ($41,300) Year 1 6,300 Year 2 14,200 Year 3 17,900 Year 4 30,300 Required return Required return Required retur
Posted: Thu May 05, 2022 8:04 am
by answerhappygod
- A Year O 41 300 Year 1 6 300 Year 2 14 200 Year 3 17 900 Year 4 30 300 Required Return Required Return Required Retur 1 (58.84 KiB) Viewed 33 times
A Year o ($41,300) Year 1 6,300 Year 2 14,200 Year 3 17,900 Year 4 30,300 Required return Required return Required return Required return 10% Required return 15% Required return 20% Required return 25% (Use cells A6 to C20 from the given information to complete this question. You must use the built-in Excel function to answer this question.) Output area: IRR A 19.75% 18.75% IRR B Year O Year 1 Year 2 Year 3 Year 4 Crossover rate NPV A NPV B NPV at 0% NPV at 5% INPV at 10% NPV at 15% INPV at 20% INPV at 25% ($41,300) 19,100 17,800 15,200 8,400 11% 0% 5% CF difference 50 (12,800) (3,600) 2,700 21,900 NPV A B NPV B