Rentes Rente Excel: !!hot!!

| A | B | C | D | |-----------|------------|--------------------|------------------| | Period | Payment | Interest (IPMT) | Principal (PPMT) | | 1 | =PMT(...) | =IPMT(...) | =PPMT(...) | | 2 | same PMT | =IPMT(...,2,...) | =PPMT(...,2,...) |

=IPMT(4%/12, 12, 60, 100000)

You will see the balance growing faster each year because the 5% is calculated on a larger and larger number. rentes rente excel

154,992.99 kr.

You save 1,000 kr. per month for 10 years at an annual 5% interest rate. | A | B | C | D

Total number of payment periods (e.g., 10*12 for 10 years of monthly compounding). ...) | =PPMT(...