I) Suppose you borrow $15,000. The interest rate is 11%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0".

->please help me calculate exercise with excel functions

	Beginning			Repayment	Ending
Year	Balance	Payment	Interest	of Principal	Balance
1	$	$	$	$	$
2	$	$	$	$	$
3	$	$	$	$	$
4	$	$	$	$	$