Determine Appreciated Value after a certain number of years

[kpierce]

Hello:
I'm needing a little help.

I'm trying to determine the principal that has been paid on a loan after a certain number of years.

For example:
A1 = Purchase Price: $100,000
A2 = Interest Rate: 5.5
A3 = Loan Duration: 30
A4 = Number of Years before refi: 15

=-PMT(A2/12,A3*12,A1)
= $568 (Monthly payment)

How can I determine principal that has been paid after 15 years(A4).

I appreciate your help.
Regards,
kp

 

[johnnyL]

How about:

Book1
	A	B	C	D
1	Loan Amount	$100,000.00
2	Interest Rate	5.50%
3	Years	30
4	Number of Years before refi	15	-$30,510.28
5	Monthly Payment	$567.79
6
7	Principal for Payment #	1	$109.46
8
Sheet1

Cell Formulas
Range	Formula
C4	C4	=CUMPRINC(B2/12,B3*12,B1,1,B4*12,0)
B5	B5	=PMT(B2/12,B3*12,-B1)
C7	C7	=PPMT(B2/12,B7,B3*12,-B1)