Skip to content
The title slide and first slides of the Lump Sum vs Monthly Payments Calculator template

Lump Sum vs Monthly Payments Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

A settlement, a pension option, a prize or a sale can arrive as one large payment or as many small ones. Adding the small ones up is not the fair comparison, because money received later is worth less than money in hand. This calculator brings both offers to a value today. Offer A holds the lump sum and any wait before it arrives. Offer B holds the monthly payment, the number of payments and the wait before the first.

Each offer gets its own discount rate, a yearly rate that stands for what you could earn or what waiting costs. The Compare tab shows both values today, which one is higher and the rate at which they are equal, then repeats the comparison for discount rates from 2 to 10 percent with a line chart. Where the two lines cross is the rate at which your choice changes. The sample compares 185,000 dollars now with 1,475 dollars a month for fifteen years.

Useful for

  • Weighing a settlement offer against a payment plan
  • Comparing a pension lump sum with monthly income
  • Testing how much a higher discount rate favors the lump sum

What's included

  • 4 tabs: Offer A, Offer B, Compare, How to use
  • Offer A: a table
  • Offer B: a table
  • Compare: a dashboard with 4 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Offer A tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is a lump sum better than monthly payments?

It depends on the discount rate you choose, taxes, risk and your needs. At a higher rate the lump sum looks better, at a lower rate the payments do. The sheet shows the value today of each at several rates.

What is a discount rate?

It is a yearly rate used to turn future money into value today. You can base it on what you could earn on the lump sum, or on the rate you would pay to borrow.

What does the rate where they tie mean?

It is the yearly return at which the lump sum would grow into the same payments. If you expect to earn more than that, the lump sum may suit you better; if less, the payments may.

  • #financial-calculator
  • #lump-sum-vs-monthly-payments-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…