the amount is 1125.5, but not
entirely sure how to get there. No excel please
Annual Payments = $ 2000, Interest Rate = 15% and Loan = $ 10000
Let the required final payment be $ P
Further, the number of payments is at least 5 as 5 x 2000 = $ 10000 in case the discount rate is zero.
Therefore, 2000 x (1/0.15) x [1-{1/(1.15)^(5)}] = $ 6704.31
Remaining Payment = $ 10000 - 6704.31 = $ 3295.69
PV of Another $ 2000 coming in at the end of Year 6 = 2000 / (1.15)^(6) = $ 864.655
Remaining Payment = 3295.69 - 864.655 = $ 2431.03
PV of Another $ 2000 coming in at the end of Year 7 = 2000 / (1.15)^(7) = $ 751.874
Remaining Payment = 2431.03 - 751.874 = $ 1679.16
PV of Another Payment coming in at the end of Year 8 = 2000 / (1.15)^(8) = $ 653.804
Remaining Payment = 1679.16 - 653.804 = $ 1025.36
PV of Another Payment coming in at the end of Year 9 = 2000 / (1.15)^(9) = $ 568.525
Remaining Payment = 1025.36 - 568.525 = $ 456.832
PV of Another $ 2000 at the end of Year 10 is higher than the outstanding payment, thereby implying that the final payment P is made at the end of Year 10
Therefore, P = 456.832 x (1.15)^(10) = $ 1848.14
Loan Outstanding at the end of Year 4 = 2000 x (1/0.15) x [1-{1/(1.15)^(5)}] + 1848.14 / (1.15)^(6) = $ 7503.31
Interest Accrued on Outstanding Loan during year 5 = 7503.31 x 0.15 = $ 1125.5
Interest Portion of 5th Payment = Interest Accrued on Outstanding Loan during Year 5 = $ 1125.5
Hence, the correct option is (E)
the amount is 1125.5, but not entirely sure how to get there. No excel please A...
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
all
of three please
LOANS: Written Answer Questions (3) Due 7/2 1 Sylvia is repaying a loan of X by making 17 annual payments of 100. Each payment consists of interest on the loan at 5% effective and an amount that is deposited in a sinking fund earning 4% effective. At the end of 17 years, the amount in the sinking fund is equal to the original loan amount accumulated with interest at the sinking fund rate. Determine X. 2....
Problem 3 A) Pierluigi is trying to get a loan for $10,000 to start a business as a financial advisor and is trying to decide between several options. (15 points) i) A $10,000 loan that needs to be paid back after 5 years with a 5% nominal annual interest rate, compounded monthly interest ) A $10,000 loan that needs to be paid back after 6 years, the first 2 years there is no and after the annual effective interest rate...
** USE FORMULA TO SOLVE THIS PROBLEM (NO EXCEL PLEASE!!!)
(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
Problem 3 B) Pierluigi is trying to get a loan for $10,000 to start a business as a financial advisor and is trying to decide between several options. (15 points) DA $10,000 loan that needs to be paid back in 6 years with a 6 % nominal annual interest rate, compounded monthly i) A $10,000 loan that needs to be paid back in 7 years, which accrues no interest during the first 2 years but has a 10% effective interest...
EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a home loan with yearly loan repayments, ie. the loan is paid by payments at the end of each year for n years, until the loan is completely paid off. Please use your spreadsheet to answer the following questions: (a) Given loan amount is $600,000, annual effective interest rate i is 11%, loan term is 20 years. Find the annual repayment amount. (b) Given annual...
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.
can somebody help me with 37,38 and (most needed) 40
please???
200 The theory of interest 36. A loan is being repaid with 10 payments. The first payment is 10, the second 9, d so forth with the tenth payment being 1. Show that the amount of interest in te sixth payment is 5- ag- 37. A loan is repaid with payments which start at $200 the first year and increase by $0 per year until a payment of $1000...
Please post with mathematical
formulas please, not an excel sheet!
1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...
Please post with mathematical formulas please, no an excel
sheet
2. The lender of a loan of 175000 receives interest payments at the end of each year for 25 years at an effective annual interest rate of i, and in addi tion, will receive a lump-sum repayment of the principal along with the 25th interest payment. The borrower will pay the annual interest to the lender and accumulate the 175000 by making 25 level annual deposits at the end of...