PLEASE HELP I DONT KNOW WHAT FORMULA TO USE EXCEL 2007!!!!!

[opiidol]

Hey hows it going, i cant figure this out for some reason but hopefully you can help me out , ok so i need to find the total amount paid on the loan for the first year. heres how its setup

(loan is for 15 years, and a the monthly payment is paid every month so 15 years (times) 12 months = 180 months
Year 1
Beginning Balance-$750,000
Ending Balance-$719450.8795
Interest rate: 0.065
Monthly Payment: $6533.30524
total paid on Loan(paid on principle)- Need help on this! What do I do for total paid on loan(paid on principle), what formula (the answer is this $78399.66288, but i somehow I cant get it)? (if you dont understand what i mean, all i need is how much interest i paid for the first year on the loan.)
Thanks SO MUCH

__________
Jansen

 

[big_mac]

Are you trying to produce something like this?

Book1
	A	B	C	D	E	F	G	H
1	TERM	ST.DT.		INT.RATE				BEG.BAL
2	180.0	01/10/07		6.500%				750,000.00
3					ACCRULED		ACCRULED
4	TERM		PAYMENT	INTEREST	INTEREST	PRINCIPAL	PRINCIPAL	BALANCE
5	0		0	0	0	0	0	750000
6	1	Jan-07	6533.31	4062.5	4062.5	2470.81	2470.81	747529.19
7	2	Feb-07	6533.31	4049.12	8111.62	2484.19	4955	745045
8	3	Mar-07	6533.31	4035.66	12147.28	2497.65	7452.65	742547.35
9	4	Apr-07	6533.31	4022.13	16169.41	2511.18	9963.83	740036.17
10	5	May-07	6533.31	4008.53	20177.94	2524.78	12488.61	737511.39
11	6	Jun-07	6533.31	3994.85	24172.79	2538.46	15027.07	734972.93
12	7	Jul-07	6533.31	3981.1	28153.89	2552.21	17579.28	732420.72
13	8	Aug-07	6533.31	3967.28	32121.17	2566.03	20145.31	729854.69
14	9	Sep-07	6533.31	3953.38	36074.55	2579.93	22725.24	727274.76
15	10	Oct-07	6533.31	3939.4	40013.95	2593.91	25319.15	724680.85
16	11	Nov-07	6533.31	3925.35	43939.3	2607.96	27927.11	722072.89
17	12	Dec-07	6533.31	3911.23	47850.53	2622.08	30549.19	719450.81
18				47850.53		30549.19
Sheet2

I think this might be over the board size limit?