Question

A $10,000 loan is to be repaid with 7 equal half-yearly instalments, the first repayment being...

A $10,000 loan is to be repaid with 7 equal half-yearly instalments, the first repayment being in 6 months from today. Interest is at 7%p.a. compounding half-yearly. Calculate the principal repaid in the fourth instalment. ( Use the =PPMT() function in excel)

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A $19,000 loan is to be repaid with 10 equal half-yearly instalments. Interest is at 7.0%p.a....
A $19,000 loan is to be repaid with 10 equal half-yearly instalments. Interest is at 7.0%p.a. compounding half-yearly Calculate the principal repaid in the fourth instalment. (use excel; answer to include cents but do not use the comma separator)
A debt of $17,000 with interest at 7.2%p.a compounding quarterly is to be repaid with 9...
A debt of $17,000 with interest at 7.2%p.a compounding quarterly is to be repaid with 9 equal end-of-quarter payments. How much interest is in the final instalment? (Hint use excel: You can either: -       First calculate the loan outstanding at the beginning of the last quarter. The interest can then be calculated as if you were setting up a loan repayment schedule for the final quarter. -       Use IPMT function)
A debt of $11,000 with interest at 8.1%p.a compounding quarterly is to be repaid with 9...
A debt of $11,000 with interest at 8.1%p.a compounding quarterly is to be repaid with 9 equal end-of-quarter payments. How much interest is in the final instalment? (Hint use excel: You can either: -       First calculate the loan outstanding at the beginning of the last quarter. The interest can then be calculated as if you were setting up a loan repayment schedule for the final quarter. -       Use IPMT function)
A debt of $18,000 with interest at 7.3%p.a compounding quarterly is to be repaid with 8...
A debt of $18,000 with interest at 7.3%p.a compounding quarterly is to be repaid with 8 equal end-of-quarter payments. How much interest is in the final instalment? (Hint use excel: You can either: -       First calculate the loan outstanding at the beginning of the last quarter. The interest can then be calculated as if you were setting up a loan repayment schedule for the final quarter. -       Use IPMT function)
A loan of $100,000 is to be repaid by two equal repayments of X. One repayment...
A loan of $100,000 is to be repaid by two equal repayments of X. One repayment is due at the end of 2 years, the second repayment is due at the end of 6 years. The interest rate is at 4% p.a. compounded quarterly for the first 3 years and then 4.4% p.a. compounded quarterly thereafter. What is the size of each repayment? a. $57,989.46 b. $56,779.19 c. $58,222.14 d. $58,762.97
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments,...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments, followed by a final smaller repayment, i.e., there are 11 repayments in total. The first of the level repayments will occur exactly 2 years from today, and each subsequent repayment (including the final smaller repayment) will occur exactly 1 year after the previous repayment. Explicitly, the final repayment will occur exactly 12 years from today. If the interest being charged on this loan is...
A local organization borrows $1,000, and the loan is to be repaid in 6 equal payments...
A local organization borrows $1,000, and the loan is to be repaid in 6 equal payments at each of the next 6 years with monthly compounding. The lender is charging a 12 percent annual interest rate on the loan. Calculate the monthly payment and construct the amortization table for the first three months only.
a loan of $15000 at 9% p.a. is to be settled in three instalments as follows:...
a loan of $15000 at 9% p.a. is to be settled in three instalments as follows: first payment of $5000 in three months and two equal payments, one in six months and the other in nine months. Calculate the size of each equal payments. Let the focal date be three months from now.
Eve borrows 10,000. The loan is being repaid with the following sequence of monthly payments: 100,...
Eve borrows 10,000. The loan is being repaid with the following sequence of monthly payments: 100, 150, 100, 150, 100, 150, etc. The annual nominal interest rate is 7.8% payable monthly. Calculate the amount of principal repaid in the 13th payment.
Set up an amortization schedule for a $30,000 loan to be repaid in equal installments at...
Set up an amortization schedule for a $30,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 10% compounded annually. How much repayment of principal was included in the first payment?