Home » APR » 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






One thought on “Lump Sum Calculator

Leave a Reply

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