Question

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)

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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)
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)
Complete an amortization schedule for a $19,000 loan to be repaid in equal installments at the...
Complete an amortization schedule for a $19,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 10% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $    $    $    $    $    2                               3                               What percentage...
Connor has $2500 in his savings account today. He earns interest at 7.8% p.a. compounded half-yearly....
Connor has $2500 in his savings account today. He earns interest at 7.8% p.a. compounded half-yearly. He plans to make the following deposits: $2400 in 2 years, and $3700 in 8 years. How much will be in Connor’s bank account in 13 years? (Round your answer to 2 decimal places. Do not put $. Do not use comma separators. E.g. 1234.56)
Complete an amortization schedule for a $19,000 loan to be repaid in equal installments at the...
Complete an amortization schedule for a $19,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2                          3                          What percentage...
Andrew takes out a 30-year home-loan of $650,000. The bank charges interest at 6% p.a. compounded...
Andrew takes out a 30-year home-loan of $650,000. The bank charges interest at 6% p.a. compounded monthly. Andrew repay the same amount at the end of each month for the whole loan term. Help Andrew to prepare the loan repayment schedule for month 61 below. (Round your answer to 2 decimal places. Do not include the $ symbol. Do not use comma separators. E.g. 1234.56) Month Opening balance of the loan Interest Paid Principal Paid Ending balance of the loan...
A 10-year loan in the amount of $527,000 is to be repaid in equal annual payments....
A 10-year loan in the amount of $527,000 is to be repaid in equal annual payments. What is the remaining principal balance after the sixth payment if the interest rate is 5 percent, compounded annually? Show work.
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be...
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment. no excel
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT