Jia borrows $50,000 at 10 percent annually compounded interest to be repaid in four equal annual...

Jia borrows $50,000 at 10 percent annually compounded interest to be repaid in four equal annual installments. The actual end-of-year loan payment is

Solutions

Expert Solution

The actual end of year loan payment is:-

=PMT(rate,nper,pv)

=PMT(10%,4,50000)

=15773.54

Where,

rate is periodic rate,

nper is no of periods,

pv is present value

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over...

A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over 10 years. a) What will be the principal component of the sixth payment? b) What will be the interest component of the sixteenth payment? c) How much will Payments 6 to 15 inclusive reduce the principal? d) How much interest will be paid in the third year? e) What will be the final payment?

John borrows $50,000 and plans to pay it back in four equal semi-annual installments. The annual...

John borrows $50,000 and plans to pay it back in four equal semi-annual installments. The annual interest rate is 8%. Calculate the amount of each installment and exhibit the amortization table. a. the balance of the loan after the second payment is refinanced for the remaining two payments at annual rate of 6%, calculate the amount by which total interest payment would be reduced.

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

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.

A company borrowed $16,000 paying interest at 9% compounded annually. If the loan is repaid by...

A company borrowed $16,000 paying interest at 9% compounded annually. If the loan is repaid by payments of $ 1800 made at the end of each year, construct a partial amortization schedule showing the last three payments, the total paid, and the total interest paid. Complete the table below for the last three payments. (Do not round until the final answer. Then round to the nearest cent as needed.) Payment Number Amount Paid Interest Paid Principal Repaid Outstanding Principal 17...

$5000 is borrowed, to be repaid in three equal, annual payments with 10% interest. Approximately how...

$5000 is borrowed, to be repaid in three equal, annual payments with 10% interest. Approximately how much principal is amortized with the second payment? $2,010.57 $1,510.57 $900.68 $1,661.63 include calculations please

How long will it take $10,000 to reach $50,000 if it earns 10% annual interest compounded...

How long will it take $10,000 to reach $50,000 if it earns 10% annual interest compounded semiannually? 17 years 33 years 16.5 years (correct) 8.5 years You get a twenty-year amortized loan of $100,000 with a 5% annual interest rate. What are the annual payments? $ 8,718 $37,689 $ 4,762 $ 8,024 (correct) You get a 25-year loan of $150,000 with an 8% annual interest rate. What are the annual payments? $14,052 (correct) $ 2,052 $13,965 $13,427

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...

Richard borrowed 50,000 from a bank at 12% (APR) semiannually compounded interest to be repaid in...

Richard borrowed 50,000 from a bank at 12% (APR) semiannually compounded interest to be repaid in 10 years (12 equal installments) . Calculate the interest and principal paid in the fourth year. USE EXCEL FORMULAS SO I CAN SEE THE INPUTS PLEASE AND SHOW THE WORK I WANT TO LEARN IT!

Calculate the effective annual rate for each. 6 percent compounded annually. % 6 percent compounded semiannually....

Calculate the effective annual rate for each. 6 percent compounded annually. % 6 percent compounded semiannually. % 6 percent compounded quarterly. % 6 percent compounded monthly. %

Subjects