Principle Formula

**cwiesniewski** · 05-07-2012, 03:29 PM

How I can find what the principle will be paid in intervals of 12 months?

**martindwilson** · 05-07-2012, 03:38 PM

what formula would you use if you never had excel?

**cwiesniewski** · 05-07-2012, 03:40 PM

I'm not sure, I'm asking for my boss.

**martindwilson** · 05-07-2012, 04:03 PM

well this is an excel forum,not an accounting forum! but we could help you with perhaps a bit more info, what have you got and what exactly do you want to see

**cwiesniewski** · 05-07-2012, 04:07 PM

I'm fully aware that this is an excel forum! We were trying to use the CUMPRINC formula but was getting stuck on the start and end period. We would like to know what the paid principle would be in intervals of 12 months. We have the orginal loan amount, rate, payment, first due date, contract date, term.

**roki4** · 05-07-2012, 05:09 PM

Are you asking how to calculate how much the principal has been paid down at the end of each 12-month interval inclusive of interest rate et al?

Try this: http://office.microsoft.com/en-us/ex...010069826.aspx

**ron2k_1** · 05-07-2012, 07:53 PM

See my attachment.

Look under the second tab. I've placed the same info that's on the amortization schedule on a little simple table that contains all the info needed for the formulas on Column C to work.

Look at the formula in C2. It adds all the principal payments for periods 1 thru 12. You can verify that the answer is correct by going to the first tab and adding period 1 thru 12 on column G.

Then look at the results in C9. It adds all the principal payments for periods 13 thru 24. You can again verify it by going to the first tab and adding period 13 thru 24 on column G. The period to add is stated on the little table. Go thru the formulas and let us know if you require more help.