Lump Sum Calculator

Last week I showed  a cash flow calculator for even cash flows give dates. This next calculator solves for one time (lump sum) cash flows. Excel has built in functions for all of these, but this one is slightly different , in that it uses dates as inputs for time. The advantage is that all of the calculations are on one sheet, so it could save some time. You can download this workbook that that solves for:

  1. Present Value
  2. Future Value
  3. APR & APY
  4. Time (In this case last date)


You have the choice of day count and base Year:


Lump Sum PV & FV

Download “Lump_Sum 





Don Pistulka
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.

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *