Five years ago, you had arranged for an eight-year bank loan for $300,000 at an interest...

Five years ago, you had arranged for an eight-year bank loan for $300,000 at an interest rate of 10% p.a. with interest compounded semi-annually. The loan was being repaid in equal semi-annual instalments and the payments were being made at the end of each period. The total amount still owed the bank today is closest to？

Could you please show the solution step by step instead of using Excel functions…Thanks a lot!

Solutions

Expert Solution

Semiannual payments=Loan*(rate/2)/(1-1/(1+rate/2)^(2*n))=300000*(10%/2)/(1-1/(1+10%/2)^(2*8))=27680.9723933

Loan outstanding after x years=Loan*(1+rate/2)^(2*x)-Semiannual payments/(rate/2)*((1+rate/2)^(2*x)-1)=300000*(1+10%/2)^(2*5)-27680.9723933/(10%/2)*((1+10%/2)^(2*5)-1)=140500.0919908

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

You have just arranged a six-year bank loan for $150,000 at an interest rate of 9%...

You have just arranged a six-year bank loan for $150,000 at an interest rate of 9% p.a. with interest compounded quarterly. The loan will be repaid in equal quarterly installments and the first payment will be due one quarter from today. Assuming end-of-the-period cash flows, the principal amount repaid to the bank at the end of the first quarter will be closest to: Group of answer choices $3,375. $4,890. $4,782. $3,267.

Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan...

Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan has 4.0% APR with monthly payments of $1,800. How much do you owe on the loan today? The remaining loan balance is $________. (round to the nearest dollar) How much interest did you pay on the loan in the past year? The interest paid in year five was $______. (round to the nearest dollar) Over the entire period of 10 years, how much interest...

Five years ago you took out a 30-year fixed $300,000 mortgage with monthly payments and an...

Five years ago you took out a 30-year fixed $300,000 mortgage with monthly payments and an APR of 8%, compounded monthly. You have made the normal payments in full, and, this morning, after making a normally scheduled payment, you are paying off the balance by taking out a new 30-year fixed mortgage at a lower APR of 6% (with monthly compounding). How much will each monthly payment be?

Four years ago, you borrowed $300,000 for a ten-year period from ABC Bank at a stated...

Four years ago, you borrowed $300,000 for a ten-year period from ABC Bank at a stated interest rate of 10% p.a. with interest compounded quarterly. You have been making equal, quarterly payments on the loan during this time and now wish to repay the loan in full. The amount that you need to repay the bank today is closest to:

Five years ago, Diane secured a bank loan of $390,000 to help finance the purchase of...

Five years ago, Diane secured a bank loan of $390,000 to help finance the purchase of a loft in the San Francisco Bay area. The term of the mortgage was 30 years, and the interest rate was 8%/year compounded monthly on the unpaid balance. Because the interest rate for a conventional 30-year home mortgage has now dropped to 6.5%/year compounded monthly, Diane is thinking of refinancing her property. (Round your answers to the nearest cent.) (a) What is Diane's current...

How much interest will you pay during the last six years of a 15-year $300,000 loan...

How much interest will you pay during the last six years of a 15-year $300,000 loan with an APR of 3.15% assuming you only make the minimum required monthly payments? A. $13,915 B. $18,223 C. $18,641 D. $13,551

Eight years ago you took out a $400,000, 30-year mortgage with an annual interest rate of...

Eight years ago you took out a $400,000, 30-year mortgage with an annual interest rate of 6 percent and monthly payments of $2,398.20. What is the outstanding balance on your current loan if you just make the 96th payment?

You are a loan officer at a bank. Two years ago your bank loaned Westwood Solar...

You are a loan officer at a bank. Two years ago your bank loaned Westwood Solar $100,000 to start a company selling solar panels to commercial and residential customers. The loan has an acceleration clause that permits the bank to immediately demand all payments plus the interest owed to date if Westwood Solar fails to pay an installment in any given month. Westwood Solar has made its loan payments for the past two years. However, you know that the company...

Five years ago I took out a 30-year fixed $300,000 mortgage withmonthly payments and an...

Five years ago I took out a 30-year fixed $300,000 mortgage with monthly payments and an APR of 8%, compounded monthly. I have made the normal payments in full, and, this morning, after making a normally scheduled payment, I are paying off the balance by taking out a new 30-year fixed mortgage at a lower APR of 6% (with monthly compounding). How much will each monthly payment be?

Two years ago, you purchased your first car and financed your purchase with a five-year loan...

Two years ago, you purchased your first car and financed your purchase with a five-year loan at 6.0% p.a. You were making monthly payments of $1,160 on the car loan and you have just made your 24th monthly payment on the car today. Assuming that you have made all 24 payments on time, the current principal balance outstanding on your car loan is closest to: a) $26,170. b) $27,840. c) $38,130. d) $41,760.

Subjects