News for hackers. Stuff that matters.
Re:Spreadsheet formulas for personal finance by marianov on Wednesday August 04, 2021 @04:21PM (#28065802)
High inflation question:

Given 40% inflation. An item is offered for $1200 in 12 "zero interest" payments of $100 or $800 in cash.

How do you compare their real cost taking into account inflation?

Re:Spreadsheet formulas for personal finance by CaptainNegative on Wednesday August 04, 2021 @04:31PM (#28065923)
If (annual) inflation is 40%, then the annual discount factor is 1.40 and the monthly one is c = 1.40^(1/12) ≈ 1.0284.

Assuming the $100 payments are paid at the end of each month, the value of the money sent over in today's dollars is $((100/c^1) + (100/c^2) + (100/c^3) + ... + (100/c^12)) which is a geometric series with ratio 1/c, so the sum is (100/c^1 - 100/c^(12+1))/(1-1/c) ≈ $1005.

So take the cash offer.

For spreadsheet calculations, look into the SERIESSUM flavor of macros.

Re:Spreadsheet formulas for personal finance by medvezhenok on Wednesday August 04, 2021 @05:08PM (#28066321)
That's computing based on purely the discounted value of money. The more useful metric is not the % of inflation, but rather the % you can get on your money lying around (your answer assumes that to be 40% annually as well - i.e. a real rate of zero, but real rates on all of your options could be deeply negative as well).

(though from an academic point of view you are completely correct)

Re:Spreadsheet formulas for personal finance by narush on Wednesday August 04, 2021 @04:22PM (#28065813)
Are they monthly payments?
Re:Spreadsheet formulas for personal finance by marianov on Thursday August 05, 2021 @10:38AM (#28074319)
Yes