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

Excel and Money

Excel has a number of features designed specifically for working with financial data. These are, of course, particularly relevant to this book. This section reviews these features.

Cash Flow

Excel uses a cash flow model for dealing with financial data. This is a lot simpler than it sounds, and means simply that money values are treated as positive values if the money is coming in and negative values if it is going out. For example, suppose you are using the PMT function to calculate the payment on a car loan. The amount of the loan must be entered as a positive value because this is money you receive. The result of the calculation is a negative value because this is money you pay out—your monthly payment.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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