How the etf and fund cost comparison works
Compares two funds or ETFs with the same return before costs: how much final balance do ongoing charges (TER) and the sales charge cost over the years? Monthly savings plan with an optional lump sum.
Inputs
- Lump sum
- Monthly savings amount
- Investment period (years)
- Return before costs p.a.
- Fund A: ongoing charges (TER) p.a.
- Fund A: sales charge
- Fund B: ongoing charges (TER) p.a.
- Fund B: sales charge
Results
- Cost advantage of fund B
- Final balance fund A
- Final balance fund B
- Difference as % of B
- Total contributions
Show formulas
- Cost advantage of fund B:
endB - endA - Final balance fund A:
round(fv(zinsA, jahre * 12, -rate * (1 - aufschlagA), -startkapital * (1 - aufschlagA), 1), 2) - Final balance fund B:
round(fv(zinsB, jahre * 12, -rate * (1 - aufschlagB), -startkapital * (1 - aufschlagB), 1), 2) - Difference as % of B:
endB > 0 ? differenz / endB : 0 - Total contributions:
startkapital + rate * 12 * jahre
Add your own result fields with “+ Field” – every input is available as a variable.
More calculators
- Compound interest calculatorHow much will my money grow?
- Savings planRegular saving with compound interest
- Loan calculator (annuity loan)Monthly payment, remaining balance and amortisation schedule
- Mortgage calculatorPurchase costs, loan amount and monthly payment
- How much house can I afford?Maximum purchase price from income and savings
- Rental yield calculatorIs the buy-to-let worth it?
- Withdrawal planHow long will my savings last?
- Dividend calculatorDividend yield and net dividend
- Overdraft interest calculatorWhat does an overdrawn current account cost?
- Late payment interest calculator (Germany)Default interest under § 288 BGB
- VAT calculatorNet, gross and VAT
- Capital gains tax calculator (Germany)What is left of interest and dividends?
- Inflation calculatorWhat will my money be worth tomorrow?
- Percentage calculatorPercentage, rate, base value and percent change
- Discount calculatorWhat does it cost after the discount?