PLEASE USE FORMULAS AND CELL REFERENCING SO I KNOW HOW TO DO IT

Chapter 10 SPREADS Home Insert Draw Page Layout Formulas Data Review View Times New... 10A ? Wrap Text Paste B I Merge & Center H1 Pineapple Plantation Company is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows Time Project A (5375) ($300) ($200) ($100) Project B (S575) $190 $190 $190 $190 $190 $190 $190 10 12 13 15 16 18 19 A. If each project's cost of capital is 6%, which project should be selected? 20 project is the proper cholce? If the cost of capital is 14%, what 22 @ 6% cost of ca ital 23 24 WACC= 25 26 NPVA 27 14% cost of a tal Use Excel's NPV function. Note that the range does not include the costs, which are added separately 6% WACC = 14% NPV A- 29 30 ANSWER: 32