I need to find a formula(s) in MS Excel that can be used to calculate how a student loan payments are broken down between principle and interest.
For example, say a student borrows $100,000 at the rate of 5%. Then the student pays different amount each month (according to his/her finances). For each payment I am trying to find how much the bank allocates to principle and how much to interest. For example, if you I could create the following spreadsheet
DATE PAYMENT AMOUNT PRINCIPLE INTEREST
01/01/14 $500. ?? ??
02/04/14 $700. ?? ??
03/10/14 $650. ?? ??
and so on.
Does Excel have formulas for the PRINCIPLE and INTEREST columns?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham