Excel Courses: [ Ссылка ]
More help: [ Ссылка ]
Excel Forum: [ Ссылка ]
How to find the interest and principal payments on a fixed rate loan in excel. This tutorial will walk you through using the PPMT() and IPMT() functions in excel in order to find out how much of a monthly payment on a loan actually goes to pay off the loan amount and how much is just an interest payment.
More free excel stuff such as macros, tutorials, articles, etc. go to: TeachExcel.com
Ещё видео!