Question

In: Finance

A loan of Rs 5,00,000 is to be paid in 5 equal annual installments. If the...

A loan of Rs 5,00,000 is to be paid in 5 equal annual installments. If the rate of interest is 10% p.a compounded annually.

Find the amount of each annual installment and also prepare the loan amortization schedule.

Solutions

Expert Solution

PV = 500,000

r = 10%

n = 5

Annual payments = $131,898.7404115845

Amortization Schedule

Screenshot with formulas

Can you please upvote? Thank You :-)


Related Solutions

A loan of Rs 7,00,000 is to be paid in 5 equal annual installments. If the...
A loan of Rs 7,00,000 is to be paid in 5 equal annual installments. If the rate of interest is 10% pa compounded annually. Find the amount of each annual installment and also prepare the loan amortization schedule. please try to give answer within 1Hr
A loan is repaid in ten equal annual installments with the first installment paid one year...
A loan is repaid in ten equal annual installments with the first installment paid one year after the loan is made. The effective annual interest rate is 4%. The total amount of principal repaid in the fifth, sixth, and seventh payments combined is $6,083. What is the total amount of interest paid in the second, third, and fourth payments combined? Less than $2,000 At least $2,000, but less than $2,020 At least $2,020, but less than $2,040 At least $2,040,...
Chad borrows $75,000 and agrees to repay the loan in five equal annual installments. The loan's...
Chad borrows $75,000 and agrees to repay the loan in five equal annual installments. The loan's interest rate is 6.75 percent. What is his loan's balance after making the third payment?
A loan is repaid in nine equal annual installments. The first payment is due one year...
A loan is repaid in nine equal annual installments. The first payment is due one year after the loan is made. The effective annual interest rate is 5%. The total amount of interest paid in the third, fourth, and fifth payments combined is $3798. What is the total amount of principal repaid in the seventh, eighth, and ninth payments combined? Choices: Less than $13,600 At least $13,600, but less than $13,700 At least $13,700, but less than $13,800 At least...
Construct an amortization schedule for a $1,000, 12% annual rate loan with 4 equal installments. What...
Construct an amortization schedule for a $1,000, 12% annual rate loan with 4 equal installments. What is the annual interest expense for the borrower, and the annual interest income for the lender, during Year 2? Suppose on January 1 you deposit $1000 in an account that pays a nominal, or quoted, interest rate of 12%, with interest added (compounded) daily. How much will you have in your account on October 1, or 9 months later? You want to buy a...
The interest-bearing loan is repaid in equal installments, paid monthly. First installment after 10 months, last...
The interest-bearing loan is repaid in equal installments, paid monthly. First installment after 10 months, last after 8 years. During the deferral period, interest is paid monthly (9 times). The annual interest rate of EUR 97000 credit, capitalized monthly, is 5.10%. (a) Calculate the monthly contribution. (b) How much interest is paid in installments after 6 years and 1 month? (c) How much credit is repaid in year 7 (starting with the contribution after 6 years and 1 month, ending...
Consider a $35,000 loan to be repaid in equal installments at the end of each of...
Consider a $35,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6%. Set up an amortization schedule for the loan. Round your answers to the nearest cent. Enter "0" if required Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $   $   $   5 $   $   $   $   Total $   $  ...
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 .
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT