
Annual Report
Docs + Word6 pages
FeaturedFree
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.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Offer A tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
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.
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.
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.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free