Amoritization sheet 1

[rry2k]

I would like to build a sheet to track principle and interest for a mortgage. Can someone give me the excel formula for this.

Thanks..russ

 

[jebry]

Hi Russ!

If I am understanding your question correctly you are looking for IPMT and PPMT which returns the interest payment and the principal payment respectively.

hth Jeff Bridgham
bridgham@purdue.edu

 

[rry2k]

So how would I build that into a sheet? are those formulas in 2 seperate cells? And last, how do I make a change as I progress through the life of the loan?

 

[Hasit]

This looks US specific, so I may not be able to help without more detail (being as I am from the UK). Could you elaborate and I can create the formulas for you....

 

[rry2k]

I need a spreadsheet that shows the break down by month for a mortgage. So there should be 360 cells (12 months x 30 yrs) where principle and interest change as you progress down the sheet. i.e. high interest low principle to start and then the balance changes.

 

[Hasit]

I have a mortgage (*sigh*), but I don't fully understand the requirements. Can you send me the file and I'll send it back with the formulas by return:

hasitbakhda@yahoo.co.uk

 

[iSeriesCodePoet]

I have one at home that does this that I made for a class back in College. Email me privatly (WalkerGagh at hotmail.com) if you would like to see if that would work for you. Mike Wills
AS400 Programmer

 

[rry2k]

Walter, I sent you my email address.
Thanks..Russ

 

[iSeriesCodePoet]

Is that what you where looking for? Mike Wills
AS400 Programmer

 

[rry2k]

It is thanks. But when I tried to scroll or page down nothing happened.

Russ

 

[Hasit]

Scroll lock is on.

 

[iSeriesCodePoet]

I have a freeze pane on it? Might that be causing it? What is your resolution set at? Mike Wills
AS400 Programmer

 

[rry2k]

Mike,

I'm set at 640 x 480 and the scroll lock is off.
When I mouse down or page down the screen the slider moves but the screen is still at the top. This is a new one I've never seen that happen before.

 

[iSeriesCodePoet]

Go to Window | Freeze Panes (or whever the opposite is). This should remove that. I had that set so I could see the top part and just scroll down the rest of the way.

Otherwise... A) set your resolution higher. B) Set your zoom to about 50% or so. Mike Wills
AS400 Programmer

 

[rry2k]

Mike,
Freeze pains off did the trick and this is exactly what I'm looking for. Thanks alot..Russ

 

[iSeriesCodePoet]

No problem... Mike Wills
AS400 Programmer