hard20 pts · first answer countsbusiness-caseexcelnpv
The Excel NPV function trap
Cell B1 holds the year 0 investment (−10,00,000) and B2:B4 hold the year 1–3 savings. An analyst writes the formula below. What is wrong with it?
=NPV(10%, B1:B4)
Discussion 0
Join free to post in the discussion.
Related questions
- What a business case is forBusiness Analyst
- Opportunity cost in a business caseBusiness Analyst
- Why money today is worth moreBusiness Analyst
- Present value of one future amountBusiness Analyst
- What a hurdle rate meansBusiness Analyst
- Total cost of ownershipBusiness Analyst
- Spot the capital expenseBusiness Analyst
- Why compare options at allBusiness Analyst