Question

I am needing help with the excel formulas for the following problem (the cells highlighted in green)

Problem 1.	West Coast Company is considering two mutually exclusive projects, the project's expected net cash flows are as follows:
	Expected Cash Flows
Year	Proj. A	Proj. B
0	($40,000)	($30,000)
1	($12,000)	$8,500
2	$10,000	$8,500
3	$35,000	$8,500
4	$14,000	$8,500
5	$25,000	$8,500
Required Rate of Return	14.00%	14.00%
1.a. (8 points)	Calculate each project's IRR (IRR should be denoted as a percentage number, and two numbers are kept after the decimal point).
Proj.A's IRR
Proj. N's IRR
1.b. (8 points)	Caluclate each project's NPV.
Proj. A's NPV
Proj. B's NPV

Answer 1

Proj.A's IRR	15.40%
Proj. N's IRR	12.86%
Proj. A's NPV	$2,065.70
Proj. B's NPV	($818.81)

Workings

AutoSave © of HO- Book2 - Excel Sign in - o File Home Insert Draw Page Layout Formulas Data Review View Help O Tell me what you want to do Inherit 6 = = dopo ake - A À - A - = I Insert ${Delete - Format - Share Comment E. As 7- Z O, Sort & Find & Filter - Select Editing Paste General $ - % 9 Number BI U - - Conditional Format as Formatting Table Cell Styles Clipboard Font Alignment o Styles Cells B3 - X ✓ B fx Proj. A CD E F G H I J 2 Expected Cash Flows Year Proj. A Proj. B o -40000 -30000 -12000 8500 10000 8500 m two ooo 35000 8500 14000 8500 25000 8500 Required Rate of Return 0.14 0.14 Calculate each project's IRR (IRR should be denoted as a percentage number, and two numbers are kept after the decimal point). 1.a. (8 points) Proj.A's IRR =IRR(B4:39) 12. 13 Proj. N's IRR =IRR(C4:09) 14 1.b. (8 points) Caluclate each project's NPV 16 Proj. A's NPV =NPV(B10,B5:89)+B4 17 Proj. B's NPV =NPV(C10,C5:09)+C4 18