Question: SHOW YOUR WORK FOR QUESTION 5-PART a HERE: USE EXCEL FORMULAS ONLY TO SOLVE THE PROBLEM! Question 4. (includes parts a and b below). The


SHOW YOUR WORK FOR QUESTION 5-PART a HERE: USE EXCEL FORMULAS ONLY TO SOLVE THE PROBLEM! Question 4. (includes parts a and b below). The following is the cash flow diagram of an 8- year investment project that is expected to bring profit. Years 1 through 8 show annual profits (up arrows: cash inflow (positive), down arrows: cash outflow (negative)). 14K 14K 14K 7K 0 1 2 3 4 OK 5 6 7 8 3K IK 5K 15K a. (3 points) What is the NPV of this project at a 9% MARR? Please choose one below by selecting that option and changing the text color to red. ALSO MAKE SURE YOU SHOW YOUR WORK ON THE RIGHT HAND SIDE OF THIS SPACE IN EXCEL. - COVER SUMMARY OF CONTENT Q1 and Q2 Q3 04 05 / @ -- b. (2 points) Ignore the NPV value you found in part a, and assume that the NPV of this project is $20,000. Calculate the Annual Worth (AW) of this project. Please choose one below by selecting that option and changing the text color to red. ALSO MAKE SURE YOU SHOW YOUR WORK ON THE RIGHT HAND SIDE OF THIS SPACE IN EXCEL. b1. -$39,851 b2. $2,500 b3. -$3616 b4. $39,851 b5. $3,613
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
