I ran into this problem in accounting. A workbook was being generated by the general ledger that created separate sheets for each ATM, with dates and deposits. There were a total of 19 ATMs. Individual dates for each sheet were in column A and amounts in column C. The dates did not necessarily show up in the same […]
Author: Don Pistulka
Retired Credit Union CFO - Finance
Background: over 40 years in investments, asset/Liability management, banking, securities trader.
Worked for: California Credit Union, WesCorp, CalFed S&L, Crocker Bank, Carroll McEntee, Federal Home Loan Bank Board (D.C.), Western Asset Management, Security Pacific National Bank.
No XNFV Excel Function?
You might have already used the XNPV built-in Excel function for calculating the present value of a stream of cash flows with dates. How about XNFV for future value? Wait a minute. There is no XNFV. It would have been easy to include an XNFV function, but maybe they couldn’t think of a reason to use […]