Answered step by step
Verified Expert Solution
Question
1 Approved Answer
#8) I want to know if this is correct? I calculated this using Excel, however, I sometimes get 1318.7471 for the NPV of CDMA for
#8) I want to know if this is correct? I calculated this using Excel, however, I sometimes get 1318.7471 for the NPV of CDMA for example. I am mainly concerned with the NPV. If you can explain this I would much appreciate it. These are my calculations below is the problem:
1318.7471422039300% |
Year CDMA G4 Wi-Fi -7 -27 10 -20 1 11 18 25 2 7.5 33 39 3 4.5 27 27 Profitability Index 2.883924489 3.31961591 2.88954936 ANS - 3.32ANS -2.89 ANS- 2.88 13.19 4639 51,02 NPV a319615912 5101.7832647402300% O N a. Calculate the profitability index for each investment. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate the NPV for each investment. (Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to 2 decimal places, e.g., 1,234,567.89) CDMA 2.88 a. G4 3.32 Wi-Fi 2.89 b. CDMA 13.19 G4 46.39 Wi-Fi $ 51.02
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started