Business plan

loanplan.xlsx

Loan Amortization

	Developed by Pete Eggspuehler, Senior Business Advisor for the Oregon Chemeketa SBDC
			Loan Amortization Table -
	Enter Loan Amount >>>		$ 2,000.00		Data entry is	Note: To avoid blank
	Enter Term in Months >>>		18		only permitted	pages, define your print
	Enter Interest Rate >>>		7.00%		in yellow cells.	range before printing.
	Payment		$117.37
		Total Payments	Interest Paid	Principal Paid	Year End Balance
	Year 1	$ 1,408.44	$ 98.50	$ 1,309.94	$ 690.06
	Year 2	$ 704.22	$ 14.16	$ 690.06
	Year 3	$ - 0	$ - 0	$ - 0
	Year 4	$ - 0	$ - 0	$ - 0
	Year 5	$ - 0	$ - 0	$ - 0
	Totals	$ 2,112.66	$ 112.66	$ 2,000.00
	Period	Payment	Interest	Principal	Balance
	1	$ 117.37	$ 11.67	$ 105.70	$ 1,894.30
	2	$ 117.37	$ 11.05	$ 106.32	$ 1,787.98
	3	$ 117.37	$ 10.43	$ 106.94	$ 1,681.04
	4	$ 117.37	$ 9.81	$ 107.56	$ 1,573.47
	5	$ 117.37	$ 9.18	$ 108.19	$ 1,465.28
	6	$ 117.37	$ 8.55	$ 108.82	$ 1,356.46
	7	$ 117.37	$ 7.91	$ 109.46	$ 1,247.00
	8	$ 117.37	$ 7.27	$ 110.10	$ 1,136.91
	9	$ 117.37	$ 6.63	$ 110.74	$ 1,026.17
	10	$ 117.37	$ 5.99	$ 111.38	$ 914.78
	11	$ 117.37	$ 5.34	$ 112.03	$ 802.75
	12	$ 117.37	$ 4.68	$ 112.69	$ 690.06
	13	$ 117.37	$ 4.03	$ 113.34	$ 576.72
	14	$ 117.37	$ 3.36	$ 114.01	$ 462.71
	15	$ 117.37	$ 2.70	$ 114.67	$ 348.04
	16	$ 117.37	$ 2.03	$ 115.34	$ 232.70
	17	$ 117.37	$ 1.36	$ 116.01	$ 116.69
	18	$ 117.37	$ 0.68	$ 116.69	$ 0.00


















































































































































































































































































































































































































































































Password = "amort"