Gary borrows 150,000 with interest at 15% compounded quarterly. How many 9,500 quarterly payments are required?...

Gary borrows 150,000 with interest at 15% compounded quarterly. How many 9,500 quarterly payments are required?

Show complete solution

Solutions

Expert Solution

The number of quarterly payments required can be calculated with the help of NPER function of Excel

Inputs required"

PV = 150000

FV = 0

PMT = 9500

Rate = 15%/4 = 3.75%

The NPER function of Excel is:

=NPER(3.75%,-9500,150000,0,0)

= 24.36 payments

Hence it would take 24.36 quarterly payments

Amanda K answered 2 years ago

Next > < Previous

Related Solutions

A debt of $30000 with interest at 9.75% compounded quarterly is to repaid by equal payments...

A debt of $30000 with interest at 9.75% compounded quarterly is to repaid by equal payments at the end of each year for 7 years. what is the size of annual payment also construct a payment schedule.

Quarterly payments of $675 are required to settle a loan. The interest rate on the loan...

Quarterly payments of $675 are required to settle a loan. The interest rate on the loan is 9.6% compounded quarterly. Find the amount of a single payment which will settle the debt on January 1, 2018 given the date of the first payment and the date of the last payment. a) April 1, 2011; October 1, 2016 b) July 1, 2019; April 1, 2023 c) January 1, 2005; July 1, 2010 ******* the answers given by the teacher are A.) 22,971.63...

Jeremy Grey loans Gary Grobowski $400,000. Grey accepts a 5% note, which requires quarterly interest payments...

Jeremy Grey loans Gary Grobowski $400,000. Grey accepts a 5% note, which requires quarterly interest payments for 10 years. The day after receiving the 6th interest payment, Grey decides to sell the note to Blue Hills Bank. Blue Hills Bank agrees to purchase it to yield an 8% return. What is the amount that Jeremy Grey will receive on the sale of the note to Blue Hills Bank? Prepare the entries that Jeremy Grey and Blue Hills Bank will make...

11) A debt of $10,000 with interest at 8% compounded quarterly is to be repaid by...

11) A debt of $10,000 with interest at 8% compounded quarterly is to be repaid by equal payments at the end of every six months for two years. a) Calculate the size of the semi-annual payments. b) Construct an amortization table for the complete 2 years with dollar amounts to two decimal places i.e. include the pennies. Round your semi-annual payment to the next higher dollar. If you did not get an answer to part a), assume a debt of...

A debt of $10 000.00 with interest at 8% compounded quarterly is to be repaid by...

A debt of $10 000.00 with interest at 8% compounded quarterly is to be repaid by equal payments at the end of every three months for two years. a) Calculate the size of the monthly payments. b) Construct an amortization table. c) Calculate the outstanding balance after three payments. Amortization Table Payment Number Amount Paid Interest Paid Principal Repaid Outstanding Principal Balance 0 1 2 3 4 5 6 7 8 Barbara borrowed $12 000.00 from the bank at...

You borrow $2000 at 4% annual interest compounded quarterly, to be paid off with equal quarterly...

You borrow $2000 at 4% annual interest compounded quarterly, to be paid off with equal quarterly payments. Your first payment will be one year from now, and your last payment will be nine years from now. What will your payments be?

Q6) If you deposit $92,360 at 09.00% annual interest compounded quarterly, how much money will be...

Q6) If you deposit $92,360 at 09.00% annual interest compounded quarterly, how much money will be in the account after 12 years? Q7) If you deposit $907 into an account paying 05.00% annual interest compounded monthly, how many years until there is $7,655 in the account? Q8) What is the value today of receiving a single payment of $91,870 in 8 years if your required rate of return on this investment is 30.00% compounded semi-annually? Q9) If you deposit $573...

Jamie deposits $10,000 in an account earning 3% interest, compounded quarterly. How much will the account...

Jamie deposits $10,000 in an account earning 3% interest, compounded quarterly. How much will the account balance be in 10 years? $13,483.48 $22,879.28 $12,327.12 $14,724.14

a) Suppose $600 is invested at 5% interest, compounded quarterly for 2.5 years. How much money...

a) Suppose $600 is invested at 5% interest, compounded quarterly for 2.5 years. How much money is in the account after 2.5 years? b) How much shoukd you pay each year for 15 years into an ordinary annuity that pays 3.15% interest compunsed annually so that at the end, you have $43,000 in the account? c) A building manager sets up a sinking fund so that there is enough money when the HVAC system needs to be replaced in 6...

Dunwoody Bank offers 1.8% interest compounded monthly. Chamblee Bank offers 2.2% interest compounded quarterly. A client...

Dunwoody Bank offers 1.8% interest compounded monthly. Chamblee Bank offers 2.2% interest compounded quarterly. A client wants to deposit $10,000 for 3 years and get the better return on his deposit. Calculate the return each bank would give on his deposit so the client can decide which will be better for him

Subjects