Loan Amortization

Lalic · Mar 6th, 2002, 02:15 PM

I have a group of mortgage loans I want to amortize the first 5 payments listing the detail principal and interest payment separately. Is there an easy way to do this? Can you do this efficiently in a pivot table?

Barrie Davidson · Mar 6th, 2002, 02:23 PM

Quote:

On 2002-03-06 13:15, Lalic wrote:
I have a group of mortgage loans I want to amortize the first 5 payments listing the detail principal and interest payment separately. Is there an easy way to do this? Can you do this efficiently in a pivot table?

I believe this was answered for you by Paul B at:

http://www.mrexcel.com/board/viewtop...1454&forum=2&1

Was the response not sufficient?

Mar 6th, 2002, 03:36 PM

I don't know about pivot tables, but if you use the PMT function to figure out the total payment, then figure the interest paid by (Current Balance*(Interest Rate/12)), the difference between those numbers will be your payment toward principal.

Scott R · Mar 6th, 2002, 03:52 PM

See help on the CUMPRINC and CUMIPMT functions. That's exactly what you need.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 02:15 PM	#1
Lalic New Member Join Date: Mar 2002 Posts: 2	I have a group of mortgage loans I want to amortize the first 5 payments listing the detail principal and interest payment separately. Is there an easy way to do this? Can you do this efficiently in a pivot table?

Mar 6th, 2002, 03:36 PM	#3
Guest Posts: n/a	I don't know about pivot tables, but if you use the PMT function to figure out the total payment, then figure the interest paid by (Current Balance*(Interest Rate/12)), the difference between those numbers will be your payment toward principal.

Mar 6th, 2002, 03:52 PM	#4
Scott R Board Regular Join Date: Feb 2002 Location: WA state Posts: 332	See help on the CUMPRINC and CUMIPMT functions. That's exactly what you need.