Robinson borrows a certain amount of money at 7% effective. He will repay this loan by...

Robinson borrows a certain amount of money at 7% effective. He will repay this loan by making payments of 2000 at the end of each year for 15 years, using the amortization method. Calculate the amount of principal repaid in the 4th payment.

Solutions

Expert Solution

First, we calculate the amount borrowed.

Amount borrowed is calculated using PV function in Excel :

rate = 7% (rate of interest)

nper = 15 (number of years)

pmt = -2000 (Yearly payment. This is entered with a negative sign because it is a payment)

PV is calculated to be $18,215.83

Interest in any year = principal outstanding at beginning of year * 7%

Principal portion of yearly payment = yearly payment minus interest portion of payment

principal outstanding at end of year = principal outstanding at beginning of year minus principal portion of yearly payment

Amount of principal repaid in the 4th payment = $888.02

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Harry borrows $3,500 from Mary. He agrees to repay the loan with annual payments, made at...

Harry borrows $3,500 from Mary. He agrees to repay the loan with annual payments, made at the end of each year, of $500, $1,000, $1,500, etc. with a smaller final payment one year after the last regular payment. Mary charges Henry a rate of discount 10% convertible 4 times per year. Determine the amount of the final payment. Ans: At least $1670, but less than $1700.

Tom borrows $100 at annual effective interest rate of 4% and agrees to repay it with...

Tom borrows $100 at annual effective interest rate of 4% and agrees to repay it with 30 annual installments. The amount of each payment in the last 20years is set at twice that in the first 10 years. At the end of 10 years, Tom has the option to repay the entire loan with a final payment $X, in addition to the regular payment. This will yield the lender an annual effective rate of 4.5% over the 10-year period. Calculate...

Common information for 6 and 7 Andrew borrows 360,000 at i=.05. He repays this loan by...

Common information for 6 and 7 Andrew borrows 360,000 at i=.05. He repays this loan by paying off only the interest due at the end of each year to the lender and depositing a level amount Y at the end of each year into a sinking fund account offering 8% APY so as to accumulate the full balance of the loan amount in the sinking fund at the end of 20 years. What value Y must he deposit into the...

Jake borrows $35,000 to finance the expansion of his business. He promises to repay with the...

Jake borrows $35,000 to finance the expansion of his business. He promises to repay with the entire amount plus interst in exactly 5 years. The annual interest rate is 7.5%. What is the amount of Jake's monthly payments? Please answer using excel formulas & show your work. Thanks.

A person borrows $100,000 at a simple interest rate r = 24%. He is to repay...

A person borrows $100,000 at a simple interest rate r = 24%. He is to repay the loan with 2 payments, one at the end of 2 months and the other at the end of 6 months. The first payment is the same as the 2nd payment. Determine the size of the payments, using the end of 6 months as the focal date.

Chad borrows $75,000 and agrees to repay the loan in five equal annual installments. The loan's...

Chad borrows $75,000 and agrees to repay the loan in five equal annual installments. The loan's interest rate is 6.75 percent. What is his loan's balance after making the third payment?

If you borrow a principal amount of $11,778 and are required to repay the loan in...

If you borrow a principal amount of $11,778 and are required to repay the loan in ten equal installments of $2,000, what is the interest rate associated with the loan?

a man borrows 100.000 euro at 10%compounded annually agreeing to repay the loan in 20 equal...

a man borrows 100.000 euro at 10%compounded annually agreeing to repay the loan in 20 equal annual payments how much of the original principal is still unpaid after he has made the tenth payment

Tak took out a loan for $5,000 at 4% interest. To repay the loan he must...

Tak took out a loan for $5,000 at 4% interest. To repay the loan he must make a payment of $672.46 at the end of each year for 9 years. How much of his second payment is interest? The question we are interested in is this: After he has made payments for 3 years, how much will he still owe?

What will be the effective interest rate when you repay a loan of $48,000 in five...

What will be the effective interest rate when you repay a loan of $48,000 in five years if the interest rate is 8.75% compounded continuously?

Subjects