Question

In: Finance

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

$1800

$

$

$

Solutions

Expert Solution

Note-

Interest Paid = Principal o/s *Interest rate

Principal o/s = Last principal o/s - Principal paid during the year

Principal repaid = Amount repaid - Interest

Please upvote if the ans is helpful.In case of doubt,do comment.Thanks.


Related Solutions

A loan of ​$13 comma 000 with interest at 12​% compounded semi dash annually is repaid...
A loan of ​$13 comma 000 with interest at 12​% compounded semi dash annually is repaid by payments of $ 937.00 made at the end of every three months. ​(a) How many payments will be required to amortize the​ loan? ​(b) If the loan is repaid in full in 2 years​, what is the payout​ figure? ​(c) If paid​ out, what is the total cost of the​ loan? ​(a) The number of payments required to amortize the loan is nothing....
A loan of $27,150.00 at 5.00% compounded semi-annually is to be repaid with payments at the...
A loan of $27,150.00 at 5.00% compounded semi-annually is to be repaid with payments at the end of every 6 months. The loan was settled in 4 years. a. Calculate the size of the periodic payment. $3,406.15 $4,200.70 $3,786.54 $4,276.00 b. Calculate the total interest paid. $3,142.32 $30,292.32 -$644.22 $6,928.86
1. An individual is borrowing $100,000 at 8% compounded annually. The loan is to be repaid...
1. An individual is borrowing $100,000 at 8% compounded annually. The loan is to be repaid in equal annual payments over 30 years. a. What is the annual payment? b. If the individual paid P8,000 per year instead of the calculated amount in a, how long will it take to pay for the loan in full maintaining the same interest rate? c. If the borrower wanted to pay P8,000 per year in 30 years, what is the rate of interest...
A loan of $1500 can be repaid in 18 months by paying the principal amount borrowed...
A loan of $1500 can be repaid in 18 months by paying the principal amount borrowed plus $225.00 interest. What was the rate of interest charged?
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!
Yassine took a loan of $6,744.29. The rate of interest is 5% compounded annually. The loan...
Yassine took a loan of $6,744.29. The rate of interest is 5% compounded annually. The loan is to be repaid by annual payments of $500 at the end of each year for 23 years. What is the outstanding balance of the loan after the third payment? ​
A debt of $42000 is repaid by making payments of $4500. If interest is 9% compounded...
A debt of $42000 is repaid by making payments of $4500. If interest is 9% compounded monthly, for how long will payments have to be made at the end of every six months? b) What payment made at the end of each year for 18 years will amount to $48000 at 4.2% compounded monthly?
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?
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
RM60,000 is borrowed for 12 years at 5% compounded annually. The borrower does not pay interest...
RM60,000 is borrowed for 12 years at 5% compounded annually. The borrower does not pay interest currently and will pay all accrued interest at the end of 12 years together with the principal. (a) Find the amount annual sinking fund deposit necessary to liquidate the loan at the end of 12 years if the sinking fund earns 3% yearly compounding and the borrower make first payment immediately. (b) Prepared a sinking fund schedule. Ans: (a) RM 7,371.25
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT