Calculating Percentages

[cbwidow1]

This message was edited by cbwidow1 on 2002-10-29 19:41
This message was edited by cbwidow1 on 2002-10-29 19:49

 

[plettieri]

Given the infomation supplied, I set up a simple schedule. It this what you had in mind...if not, please give a few more details

test7.xls
	F	G	H	I	J	K	L	M	N	O
26
27			Principal		Principal		11%
28		period	Bal beg	Payment	Bal end		Interest		Total
29		1	28000	262	27738		256.67		518.67
30		2	27738	262	27476		254.27		516.27
31		3	27476	262	27214		251.86		513.86
32
33
Sheet1

pll

 

[cbwidow1]

OK i got that part but can you show me what I have to do to get the balance to show how much is really being paid? I dont want to see how much my interest and my house payment together is. I want to see how much is being paid toward the princible when the interest is being add on.I know it is like $28.28 I`ll do the rest of the caculations later in my program.ty for your help ,I really needed that help,It has been so long since I used this program(since 1990)I forgot how.
This message was edited by cbwidow1 on 2002-10-29 19:50
This message was edited by cbwidow1 on 2002-10-29 19:50

 

[cbwidow1]

OK i got that part but can you show me what I have to do to get the balance to show how much is really being paid? I dont want to see how much my interest and my house payment together is. I want to see how much is being paid toward the princible when the interest is being add on.I know it is like $28.28 I`ll do the rest of the caculations later in my program.ty for your help ,I really needed that help,It has been so long since I used this program(since 1990)I forgot how.
This message was edited by cbwidow1 on 2002-10-29 19:51

 

[cbwidow1]

OK i got that part but can you show me what I have to do to get the balance to show how much is really being paid? I dont want to see how much my interest and my house payment together is. I want to see how much is being paid toward the princible when the interest is being add on.I know it is like $28.28 I`ll do the rest of the caculations later in my program.ty for your help ,I really needed that help,It has been so long since I used this program(since 1990)I forgot how.
This message was edited by cbwidow1 on 2002-10-29 19:48

 

[plettieri]

You might find this thread templete helpful...rather than starting from scratch...this might give you what you need....if not post back...



http://search.officeupdate.microsoft.com/TemplateGallery/result.asp?qu=amortization


pll

 

[IML]

Payment - Interest above should give you what your after (col I - Col L)

 

[dtaylor]

man a house payment less than 300...whoaaa

 

[plettieri]

The 11% cost of money seems a bit high (in USA anyway)...might try a new bank and refinance.

pll

 

[cbwidow1]

Trying to but bank wont finance with a 30 year old trailer.
This message was edited by cbwidow1 on 2002-10-29 19:51