Rente Excel Jun 2026

And includes a sensitivity table ( Data Table feature in Excel) showing required capital across different yields and withdrawal rates.

You want €500,000 at retirement in 20 years. Your investments yield 5% annually. rente excel

: Determining the effective interest rate for bonds or long-term loans . And includes a sensitivity table ( Data Table

: It can determine the rate for loans (to find out how much interest you're paying) or investments (to find out your rate of return) . : Determining the effective interest rate for bonds

| A | B | C | |---|-----------------------|----------------| | | Value | Formula/Note | | Age now | 35 | | | Retirement age | 67 | =B2-B1 (years to save) | | Life expectancy | 90 | =B3-B2 (years in payout) | | Current savings | €10,000 | | | Monthly save | €600 | | | Expected return | 5% | | | Results | | | | Capital at 67 | =FV(B6/12, (B2-B1)*12, -B5, -B4, 0) | €665,000 (approx) | | Monthly pension (nominal) | =PMT(B6/12, (B3-B2)*12, -C7, 0, 0) | €3,500 (approx) | | Monthly pension (real) | =PMT(((1+B6)/(1+2%))-1)/12... | €2,100 (approx) |