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

  1. Pingback: Math for Excel Functions With Starting and Ending Values | Excel@CFO

Leave a Reply

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

WordPress spam blocked by CleanTalk.