loan Amortization table with inconsistent payments

[RachelAnne13]

I am not the fastest at excel but generally know how to set up an amort table. However this one is a little different then what I'm used to:

How would I set up an amort table with an extra column to be able to show the random payments made. They are not made on the same day/period. The payments are very sporadic. Also, my interest seems to be going down and not up as it should and I don't know where I am going wrong.

 

[CalcSux78]

How is your interest compounded?

Here's a variation of the one Microsoft posted: https://support.microsoft.com/en-us/kb/816643

Excel 2010
	A	B	C	D	E	F
1		Loan Amount	$60,000.00
2		Interest Rate	3.95
3		# of Months	360
4		Monthly Payment	-$284.72
5	#	Start Balance	Add'l Payment	Int. for Month	Payment	End Balance
6	1	$60,000.00	$50.00	$197.50	-$334.72	$59,862.78
7	2	$59,862.78		$197.05	-$284.72	$59,775.10
Sheet1

Cell Formulas
Range	Formula
C4	=PMT(C2/12/100,C3,C1)
B6	=C1
B7	=F6
D6	=B6*($C$2/12)/100
D7	=B7*($C$2/12)/100
E6	=$C$4-C6
E7	=$C$4-C7
F6	=B6+D6+E6
F7	=B7+D7+E7
A7	=A6+1