In addition to Excel’s 16 standard financial functions, Excel users also have access to another 42 add-in financial functions. Most business users of Excel won’t need these add-in functions, but if you perform much financial analysis with Excel—especially financial analysis of investments—you’ll … [Read more...] about Using the Add-In Financial Functions in Excel
financial calculations
Using the Standard Financial Functions in Excel
Excel provides 16 standard financial functions for making depreciation, loan payment, present value, future value, and rate of return calculations. To see which financial functions Excel provides or to see which arguments a function requires, choose the Insert menu’s Function command and then select … [Read more...] about Using the Standard Financial Functions in Excel
EasyRefresher: Applying Time Value of Money Concepts
The phrase “time value of money” must surely be one of the most used terms that people don’t really understand. Almost invariably, people who don’t know a discount rate from Adam use the term to explain or question any financial complexity. The irony—and most business school students and graduates … [Read more...] about EasyRefresher: Applying Time Value of Money Concepts