Question

A loan of 50,000 euros is to be repaid in equal quarterly installments in five years. If the annual interest rate is 7.5%, find out
a) the amount of the installment,
b) the total amount of the interest paid,
c) interest paid quarterly,
d) the first year of installments.

Answer 1

Part A:

Equal Quarter Instalment = Loan / PVAF (r%, n)

r = Int rate per quarter

n is no. of quarters

Particulars	Amount
Loan Amount	€   50,000.00
Int Rate per Quarter	1.8750%
No. of periods	20
EQI = Loan Amount / PVAF (r%, n)
Where r is Int rate per Quarter & n is no. of Quarters
= Euro 50,000 / PVAF (0.01875 , 20)
= Euro 50,000 / 16.5504
= Euro 3021.08

Part B:

Total Int Paid = [ EQI * Instalments ] - Loan

= [ Euro 3021.08 * 20 ] - Euro 50,000

= Euro 60,421.60 - Euro 50,000

= Euro 10,421.60

Part C:

Period	Opening Bal	EMI	Int	Principal Repay	Closing Outstanding
1	50,000.00	3,021.08	937.50	2,083.58	47,916.42
2	47,916.42	3,021.08	898.43	2,122.64	45,793.78
3	45,793.78	3,021.08	858.63	2,162.44	43,631.34
4	43,631.34	3,021.08	818.09	2,202.99	41,428.35
5	41,428.35	3,021.08	776.78	2,244.29	39,184.06
6	39,184.06	3,021.08	734.70	2,286.37	36,897.69
7	36,897.69	3,021.08	691.83	2,329.24	34,568.44
8	34,568.44	3,021.08	648.16	2,372.92	32,195.53
9	32,195.53	3,021.08	603.67	2,417.41	29,778.12
10	29,778.12	3,021.08	558.34	2,462.74	27,315.38
11	27,315.38	3,021.08	512.16	2,508.91	24,806.47
12	24,806.47	3,021.08	465.12	2,555.95	22,250.52
13	22,250.52	3,021.08	417.20	2,603.88	19,646.64
14	19,646.64	3,021.08	368.37	2,652.70	16,993.94
15	16,993.94	3,021.08	318.64	2,702.44	14,291.50
16	14,291.50	3,021.08	267.97	2,753.11	11,538.39
17	11,538.39	3,021.08	216.34	2,804.73	8,733.66
18	8,733.66	3,021.08	163.76	2,857.32	5,876.34
19	5,876.34	3,021.08	110.18	2,910.89	2,965.45
20	2,965.45	3,021.08	55.63	2,965.45	0.00

Part D:

Period	Opening Bal	EMI	Int	Principal Repay	Closing Outstanding
1	50,000.00	3,021.08	937.50	2,083.58	47,916.42
2	47,916.42	3,021.08	898.43	2,122.64	45,793.78
3	45,793.78	3,021.08	858.63	2,162.44	43,631.34
4	43,631.34	3,021.08	818.09	2,202.99	41,428.35
5	41,428.35	3,021.08	776.78	2,244.29	39,184.06
6	39,184.06	3,021.08	734.70	2,286.37	36,897.69
7	36,897.69	3,021.08	691.83	2,329.24	34,568.44
8	34,568.44	3,021.08	648.16	2,372.92	32,195.53
9	32,195.53	3,021.08	603.67	2,417.41	29,778.12
10	29,778.12	3,021.08	558.34	2,462.74	27,315.38
11	27,315.38	3,021.08	512.16	2,508.91	24,806.47
12	24,806.47	3,021.08	465.12	2,555.95	22,250.52
13	22,250.52	3,021.08	417.20	2,603.88	19,646.64
14	19,646.64	3,021.08	368.37	2,652.70	16,993.94
15	16,993.94	3,021.08	318.64	0 0 Add a comment Know the answer? Your Answer: Post as a guest Your Name: What's your source? Earn Coins Coins can be redeemed for fabulous gifts. Log In Sign Up Post as anonymous Post Your Answer Not the answer you're looking for? Ask your own homework help question Similar Questions 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,... A loan of $ 10000 is to be repaid in 30 equal monthly installments with the... A loan of $ 10000 is to be repaid in 30 equal monthly installments with the first one paid seven months after the loan is made. The nominal annual interest rate is 6 % compounded quarterly. Determine the amount of the monthly payment. Please show detailed process Amortization Schedule Consider a $50,000 loan to be repaid in equal installments at the end of... Amortization Schedule Consider a $50,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 9%. 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 loan is being repaid in equal annual installments at 4% effective per annum. If the... A loan is being repaid in equal annual installments at 4% effective per annum. If the principal repaid in the next to the last installment is $100, find the interest contained in the installment due 5 years before the last installment. A loan is repaid in 12 equal annual installments, beginning in 1 year. The effective annual... A loan is repaid in 12 equal annual installments, beginning in 1 year. The effective annual interest rate is 3.5%. The total amount of principal repaid in the 9th through 12th payments is $9,503. What is the amount of interest paid in the 4th payment? Possible answers are: 725 or 690 or 755 or 395 or 740. Thanks Question 1 Jack took a $ 5,000 loan, which he repaid in monthly installments over seven... Question 1 Jack took a $ 5,000 loan, which he repaid in monthly installments over seven months. Payments were always made at the end of the month (each payment month was 1/12 part of the year) so that the first repayment was made 4 months after the loan was drawn down. Each equal installment consisted of an installment of the loan amount of $ 5,000 / 7 and an interest component of $ 30 and an account management fee of... A loan is being repaid by quarterly installments of $1500 at the end of each quarter... A loan is being repaid by quarterly installments of $1500 at the end of each quarter at 10% convertible quarterly. If the loan balance at the end of the first year is $12,000. Find the original loan balance. A loan is being repaid by quarterly installments of $1500 at the end of each quarter... A loan is being repaid by quarterly installments of $1500 at the end of each quarter at 10% convertible quarterly. If the loan balance at the end of the first year is $12,000. Find the original loan balance. Question 1 Jack took a $ 5,000 loan, which he repaid in monthly installments over seven... Question 1 Jack took a $ 5,000 loan, which he repaid in monthly installments over seven months. Payments were always made at the end of the month (each payment month was 1/12 part of the year) so that the first repayment was made 4 months after the loan was drawn down. Each equal installment consisted of an installment of the loan amount of $ 5,000 / 7 and an interest component of $ 30 and an account management fee of... A loan is being repaid over 10 years in equal annual installments. If the amount of... A loan is being repaid over 10 years in equal annual installments. If the amount of principal in the third payment is $350, find the principal portion of the eighth payment given j12 = 8.5% Ans; 534.56 ADVERTISEMENT Need Online Homework Help? Get Answers For Free Most questions answered within 1 hours. Ask a Question ADVERTISEMENT Active Questions Question 1: What Background investigations, if any, would you recommend to differentiate acceptable from unacceptable job... asked 9 minutes ago using MLK- letter from a birmingham jail 2. What are some other purposes of this letter,... asked 16 minutes ago Java Program Implement a class called AnimalTrainer. Include the following data types in your class with... asked 18 minutes ago Which of the following can be categorized under fiscal policy? A. Increase in money supply B.... asked 23 minutes ago Prove that the open rectangle in R2     S = { (x,y) | 2 < x<5 -8... asked 23 minutes ago For 30 years, Ron Porter has owned and operated Celtic Adventure Camp on the Bruce Peninsula,... asked 25 minutes ago The following are true statements related to the Demand for Labor, EXCEPT: A: The demand for... asked 29 minutes ago Describe, with the aid of diagrams and equations, the relationships between: uniform load - shear force... asked 46 minutes ago excel lab 3 in bcis asked 1 hour ago Assess your strengths and areas for growth with regard to both the leadership and management roles... asked 1 hour ago Innocent until proven guilty? In Japanese criminal trials, about 95% of the defendants are found guilty.... asked 1 hour ago ARITHMETIC INSTRUCTIONS a) ADD with register/memory       ADD r [or] ADD M b) ADD immediate.      ... asked 1 hour ago About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App Report DMCA © 2022 JustAAA   user contributions licensed under cc by-sa 4.0