Final payment to be made on August 31 = $1,171 (rounded off)
Refer table below for computation:
Date | Installment amount | Interest amount | Principal amount | Balance |
1-Mar | - | - | - | 3,000 |
31-Mar | 700 | 18 | 682 | 2,318 |
15-Jun | 1,200 | 35 | 1,165 | 1,153 |
31-Aug | 1,171 | 17 | 1,153 | - |
For formulas and calculations, see table below:
Date |
Installment amount (A) |
Interest amount (B) |
Principal amount (A)-(B) |
Balance |
43891 | 0 | 0 | 0 | 3000 |
43921 | 700 | =3000*7.25%*1/12 | =700-18 | =3000-682 |
43997 | 1200 | =2318*7.25%*2.5/12 | =1200-35 | =2318-1165 |
44074 | =1153.1+17.4 | =1153.1*7.25%*2.5/12 | =1170.5-17.4 | =1153-1153 |
2. A $3000 loan on March 1 was repaid by payments of $700 on March 31,...
Problem 5 - Varying Payments and Equal Principal Repaid McKenna has a loan to be repaid by 17 annual payments at an effective annual interest rate of 3%. Payments 1-11 are $600 each, payments 12-15 are $340 each, and the last 2 payments are $570 each. Calculate the interest portion in McKenna's 14 th payment. I14=
5. (2 points) A company borrowed $107,512,000 for a plant expansion and repaid the loan in 15 annual payments of $14,135,000, with the first payment occurring one year after the company received the money. What is the approximate annual.interest rate on the loan? What is the total amount of interest paid?
5. (2 points) A company borrowed $107,512,000 for a plant expansion and repaid the loan in 15 annual payments of $14,135,000, with the first payment occurring one year after...
Suppose that a loan is being repaid with 20 annual payments with the first payment coming one year from now. The first 5 payments are for $220, the next 8 are $340 each, and the final 7 are $410 each. If the effective rate of interest is 6.1%, how much interest is in the 11th payment?
A 10-year loan in the amount of $238,000 is to be repaid in equal annual payments. The interest rate is 7 percent, compounded annually. What is the amount of interest that is included in the loan payment for Year 3? PLEASE HELP WITH EXCEL FUNCTION
A loan is repaid with annual year-end payments of 15,000. The effective rate of interest is 3%. How much interest is paid in the final payment? Note: you are not given the original amount of the loan nor are you given the number of payments. This problem, however, can be solved.
A loan of 100,000 is to be repaid in 4 level annual payments starting one year after the loan date. For the first 2 years, the annual interest rate is 8%; for the last 2 years, the annual interest rate is 4%. Find the annual payment and complete the loan amortization table. t Payment Interest Due Principal Repaid Outstanding Balance 0 100,000 1 2 3 4
(1 point) A loan is being repaid with a series of payments at the end of each quarter for 9 years. If the amount of principal in the fourth payment is $200 find the amount of principal in the last 4 payments. Interest is at the rate of 5.2% convertible quarterly. ANSWER -$
5) A loan is being repaid by 2n level payments (with the first payment 1 period after the start of the loan) at an effective interest rate of j per period. Just after the nth payment, the outstanding balance on the loan is 3/4 of the initial outstanding balance on the loan. a) Find vj". b) What is the ratio of interest to principal reduction in the n+1st payment? (i.e In+1/PR.n+1)
QUESTION 6 A loan of L is to be repaid with 40 payments of 100 at the end of each month. Interest on the loan is charged at an annual nominal rate of i, 0 <i< 1, convertible monthly. The outstanding balances immediately after the 8th and 24th payments are 2308.15 and 1345.50, respectively. Calculate the amount of interest repaid in the 15th payment. Round your answer to the nearest whole number.
A 15 year loan of $1000 is repaid with payments at the end of each year. Each of the first ten payments is 120% of the amount of interest due. Each of the last five payment is $X. The lender charges interest at an annual effective rate of 8%. Calculate X.