Question

In: Finance

The borrower is in a $238,000 loan makes interest payments at the end of each six...

The borrower is in a $238,000 loan makes interest payments at the end of each six months for eight years. These are computed using an annual effective discount rate of 6.5%. Each time he makes an interest payment, the borrower also makes a deposit into a sinking fund earning a nominal interest rate of 4.2% convertible monthly. The amount of each sinking und deposit is D in the first three years and 2D in the remaning five years, and the sinking fund balance at the end of the eight years is equal to the loan amount. Find D.

Solutions

Expert Solution

loan = $ 238000

annual discount rate = 6.5%

Since the borrower is making deposits semiannually,
the effective semiannual rate by computing 4.2%/12=0.35% effective monthly, and (1.0035)^6-1=2.118461% effective semiannually.

Since the deposits are made at the end of every six months, the first deposit of D will accumulate interest 15 times before the end of eight years, the second deposit 14 times, and so on until the sixth deposit, which is the last deposit of amount D and which accumulates 10 times. Then the borrower deposits 2D which accumulates 9 times, on until his last deposit of 2D which accumulates no interest (it's at the end of the eight years).

The simplest way to treat this calculation is to break it into deposits of D for eight years and additional deposits of D for five years. Then:

D*((1.02118461)^16-1)/(1.02118461-1)+D*((1.02118461)^10-1)/(1.02118461-1)=238000

Which gives D=7980.98


Related Solutions

A loan is to be repaid by twenty end of quarter payments of $1,000. The interest...
A loan is to be repaid by twenty end of quarter payments of $1,000. The interest rate for the first two years is 6% convertible quarterly, and last three years is 8% convertible quarterly. Find the outstanding loan balance just after the 5th payment. Please don't use Excel! I'm looking to learn how to do it with the formulas.
A loan is to be repaid in end of quarter payments of $1,000 each, with there...
A loan is to be repaid in end of quarter payments of $1,000 each, with there being 20 end of quarter payments total. The interest rate for the first two years is 6% convertible quarterly, and the interest rate for the last three years is 8% convertible quarterly. Find the outstanding loan balance right after the 6th payment.
A loan of 10000$ is to be repaid with annual payments, at the end of each...
A loan of 10000$ is to be repaid with annual payments, at the end of each year, for the next 20 years. For the rst 5 years the payments are k per year ; the second 5 years, 2k per year ; the third 5 years, 3k per year ; and the fourth 5 years, 4k per year. (a) Draw two timelines describing this series of payments. (b) For each of the timelines in (a), find an expression for k...
A loan amount of L is amortized over six years with monthly payments (at the end...
A loan amount of L is amortized over six years with monthly payments (at the end of each month) at a nominal interest rate of i(12) compounded monthly. The first payment is 500 and is to be paid one month from the date of the loan. Each subsequent payment will be 1% larger than the prior payment. (a) If i(12) = 9%, find the principal repaid in the 25th payment. (b) If i(12) = 12%, find the amount of loan...
A 20 year loan with payments at the end of each year involves payments of $1,...
A 20 year loan with payments at the end of each year involves payments of $1, 000 for the first 10 years, and then for the next 10 years payments are 3% larger than the previous year’s payment. If effective annual interest is 5% then find the original loan amount. please dont solve using excel
A loan is being repaid with 20 payments of $ 1,000 at the end of each...
A loan is being repaid with 20 payments of $ 1,000 at the end of each quarter. Given that the nominal rate of interest is 8% per year compounded quarterly, find the outstanding balance of the loan immediately after 10 payments have been made (a) by the prospective method, (b) by the retrospective method.
A 10-year loan of 120,000 is to be repaid with payments at the end of each...
A 10-year loan of 120,000 is to be repaid with payments at the end of each month. Interest is at an annual effective rate of 6.00%. The first monthly payment is 800. Each additional payment will be k more than the previous month payment. Find k.
A loan of $5000 is repaid with annual payments at the end of each year of...
A loan of $5000 is repaid with annual payments at the end of each year of $1200,$800,$1300 and X. Assume the loan has 10% effective interest per year. a) Determine X b) Determine the amount of interest paid with the third payment.
A 30-year loan of 1,000 is repaid with payments at the end of each year. Each...
A 30-year loan of 1,000 is repaid with payments at the end of each year. Each of the first ten payments equals the amount of interest due. Each of the next ten payments equals 150% of the amount of interst due. Each of the last ten payments is X. The lender charges interest at an annual effective rate of 10%. Calculate X.
A loan of $30,000 is paid off in 36 payments at the end of each month...
A loan of $30,000 is paid off in 36 payments at the end of each month in the following way: Payments of $750 are made at the end of the month for the first 12 months. Payments of $750 + x are made at the end of the month for the second 12 months. Payments of $750 + 2x are made at the end of the month for the last 12 months. What should x be if the nominal monthly...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT