Loan Amount = $ 1000, Planned Annual Payments = $ 100, Interest Rate = 5 %, First Payment comes in at the end of Year 5,
Let the number of years required to pay off the loan be N years (beginning from end of year 5) and the final bigger payment be $ P
Therefore, 1000 = 100 x (1/0.05) x [1-{1/(1.05)^(N-1)}] x [1/(1.05)^(4)] + P / (1.05)^(N) = PV of Level Payments + PV of Final Payment
The above equation can only be solved by means of trial and error as it contains two variable. Further, as each annual payment of $ 100 is 1/10th of the loan amount, the value of N is definitely greater than 10
Hence, when N = 13
PV of Level Payments = 100 x (1/0.05) x [1-{1/(1.05)^(12)}] x [1/(1.05)^(4)] = $ 729.182
Remaining Loan = 1000 - 729.182 = $ 270.818
270.818 = P / (1.05)^(17)
P = $ 620.72
One needs to now progressively increase the value of N such that the value of P approaches the level payment value of $ 100 and the required value of N is that at which the final payment value is greater than the level payment value for the last time.
Now when N = 15
PV of Level Payments = 100 x (1/0.05) x [1-{1/(1.05)^(14)}] x [1/(1.05)^(4)] = $ 814.364
Remaining Loan = 1000 - 814.364 = $ 185.636
185.636 = P / (1.05)^(19)
P = $ 469.094
When N = 19
PV of Level Payments = 100 x (1/0.05) x [1-{1/(1.05)^(18)}] x [1/(1.05)^(4)] = $ 961.705
Remaining Loan = 1000 - 961.705 = $ 38.2948
38.2948 = P / (1.05)^(23)
P = $ 117.623
the answer is 124.72 5. A loan of 1,000 is to be repaid by annual payments...
Problem 3. A loan of $10,000 is being repaid with payments of $1,000 at the end of each year for 20 years. If each payment is immediately reinvested at 5% effective, find the effective annual rate of interest earned by the lender over the 20-year period.
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.
1. A $12,000 loan is being repaid with $1000 payments at the end of each year for as long as necessary, plus a smaller payment one year after the last $1000 payment. The first payment is due one year after the loan is taken out, and the effective annual interest rate is 6%. Calculate the balance on the loan immediately following the ninth payment
An amortized loan is repaid with annual payments which start at $550 at the end of the first year and increase by $ 50 each year until a payment of $ 2,000 is made, after which they cease. If interest rate is 4% effective, find the amount of principal in the tenth payment. would prefer to understand the financial mathematics behind obtaining the solution, not using excel spreadsheet or financial calculator online
A company takes out a loan of 15,000,000 at an annual effective discount rate of 5.5%. You are given: (i) The loan is to be repaid with n annual payments of 1,200,000 plus a drop payment one year after the nth payment. (ii) The first payment is due three years after the loan is taken out. Calculate the amount of the drop payment. 5. On January 1, 2010 Susan took out a 30-year mortgage loan in the amount of 200,000...
A loan is repaid with equal annual payments of $350 at the end of each year for 10 years. AEIR=5% for the first five years and 8% thereafter. What must have been the amount of this loan?
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 5-year loan in the amount of $48,000 is to be repaid in equal annual payments. What is the remaining principal balance after the third payment if the interest rate is 5 percent, compounded annually?
Explain without excel
(3) An amortized loan is repaid with annual payments which start at $400 at the end of the first year and increase by $45 each year until a payment of $1,480 is made, after which they cease. If interest is 4% effective, find the amount of principal in the fourteenth payment.
A loan of 16,000 is repaid by 8 annual payments starting 1 year after the loan is made. The amount of the first 2 payments is X and the amount of the last 6 payments is 2X. The effective annual interest rate is 6%. Find: a. X. b. OB7 providing formulas for both the retrospective and prospective calculation approaches.