EXCEL: Complete the loan amortization schedule in the green cells below. You must use at least...

EXCEL: Complete the loan amortization schedule in the green cells below. You must use at least one of the following formulas (PMT, IPMT, PPMT) in your solution.

	Years				Periods per year
	30				12

Period	PMT	Interest	Principal Paid	Balance	Annual Interest Rate	Lump Sum
0				350,000.00
1					0.08
2					0.08
3					0.08	10,000.00
4					0.08
5					0.08
6					0.08
7					0.08
8					0.08
9					0.08
10					0.08
11					0.08
12					0.08
13					0.085
14					0.085
15					0.085
16					0.085

Expert Solution

Please upvote

jeff jeffy answered 3 years ago

Implement an amortization schedule of a loan of at least 5 years in excel

AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal...

AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all...

a. Complete an amortization schedule for a $44,000 loan to be repaid in equal installments at...

a. Complete an amortization schedule for a $44,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 11% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 $ $ $ $ $ 3 $ $ $ $ $ b. What percentage of the payment represents interest and what percentage represents principal...

a. Complete an amortization schedule for a $38,000 loan to be repaid in equal installments at...

a. Complete an amortization schedule for a $38,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent. Beginning Balance -Payment -Interest -Repayment of Principal -Ending Balance 1 $ $ $ $ $ 2 $ $ $ $ $ 3 $ $ $ $ $ b. What percentage of the payment represents interest and what percentage represents principal for...

a. complete an amortization schedule for a 33,000 loan to be repaid in equal installments at...

a. complete an amortization schedule for a 33,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. round all answers to the nearest cent. b. what percentage of the payment represents interest and what percentage represents principal for each of the three years? round all answers to two decimal places .

Complete an amortization schedule for a $23,000 loan to be repaid in equal installments at the...

Complete an amortization schedule for a $23,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 11% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Remaining Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 What percentage...

Complete an amortization schedule for a $42,000 loan to be repaid in equal installments at the...

Complete an amortization schedule for a $42,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 $ $ $ $ $ 3 $ $ $ $ $ b. What percentage of the payment represents interest and what percentage represents principal for...

Complete an amortization schedule for a $26,000 loan to be repaid in equal installments at the...

Complete an amortization schedule for a $26,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 9% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Remaining Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 What percentage...

Complete an amortization schedule for a $22,000 loan to be repaid in equal installments at the...

Complete an amortization schedule for a $22,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 7% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Remaining Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 What percentage...

Complete an amortization schedule for a $28,000 loan to be repaid in equal installments at the...

Complete an amortization schedule for a $28,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 What percentage...

Question