In the first article, I discussed the PV and FV functions in Excel for calculating the time value of money. In this article, I will discuss the NPV and IRR functions in Excel. In the real world, these two formulas are critical in capital budgeting alternatives, as the results determined by NPV and IRR dictate whether or not to commence projects. This article will outline the theory behind the two functions and what decisions to make when there are conflicts in the results.
Read More...
[Source: Computers and Technology: Software Articles from EzineArticles.com - Posted by FreeAutoBlogger]