Zoho Sheet

Balloon Payment Loan Calculator						© 2005 Vertex42 LLC	v. 1.3
Download from Vertex42.com

	Inputs				Assumptions
					* Interest compounds monthly
		Loan Amount	$10,000		* Payments made at end of month
		Annual Interest Rate	3.00%		* Balloon amount paid a month after the
		Amortization Period	36	months	last regular monthly payment
		# of Regular Payments	12	months
		Begin Date	12/1/2005

	Summary

		Monthly Payment	$290.81	FALSE
		Balloon Payment	$6,782.89
		Balloon Payment w/Rounding	$6,782.98

		Total Payments	$10,272.70
		Total Interest Paid	$272.70

		Amortization Schedule
		Month	Date	Payment	Interest	Principal	Balance
			12/1/2005	-	-	-	$10,000.00
		1	1/1/2006	290.81	25.00	265.81	9,734.19
		2	2/1/2006	290.81	24.34	266.47	9,467.72
		3	3/1/2006	290.81	23.67	267.14	9,200.58
		4	4/1/2006	290.81	23.00	267.81	8,932.77
		5	5/1/2006	290.81	22.33	268.48	8,664.29
		6	6/1/2006	290.81	21.66	269.15	8,395.14
		7	7/1/2006	290.81	20.99	269.82	8,125.32
		8	8/1/2006	290.81	20.31	270.50	7,854.82
		9	9/1/2006	290.81	19.64	271.17	7,583.65
		10	10/1/2006	290.81	18.96	271.85	7,311.80
		11	11/1/2006	290.81	18.28	272.53	7,039.27
		12	12/1/2006	290.81	17.60	273.21	6,766.06
		13	1/1/2007	6,782.98	16.92	6,766.06	0.00

BalloonLoan