• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VIII: Appendixes > Financial Functions

Financial Functions

Excel contains a number of financial functions that either directly or indirectly can solve just about any financial calculation you might require (see Table B.3). Common uses include calculating loan details, annuities, investment analyses, and so on. Broadly, these calculations are called time value of money calculations. The value of money changes with the passage of time because of interest that's charged (excepting any impact from inflation). Essentially, a dollar today is worth more than a dollar tomorrow because you can collect interest on that dollar over time. Similarly, a dollar borrowed today requires that you repay more than a dollar tomorrow because of the interest that you pay.

The financial functions accept some common arguments that you might not be familiar with if you don't have a business or financial background. These are the most common arguments found in the financial functions:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint