A 10-year amortized loan of $100,000 with 5% APR requires yearly loan payment. After making four...

A 10-year amortized loan of $100,000 with 5% APR requires yearly loan payment. After making four yearly payments, the fourth year's ending loan balance is $Answer (don't include thousand separator( , ), rounding the number with two decimal places)

Expert Solution

First we need to calculate the annual payment of the loan

We are given the following information:

Payment	PMT	To be calculated
Rate of interest	r	5.00%
Number of years	n	10.00
Annual	frequency	1.00
Loan amount	PV	100000.00

We need to solve the following equation to arrive at the required PMT:

So the annual payment is 12950.46

Below is the amortization schedule:

Year	Opening Balance	PMT	Interest	Principal repayment	Closing Balance
1	$ 1,00,000.00	$ 12,950.46	$ 5,000.00	$ 7,950.46	$ 92,049.54
2	$ 92,049.54	$ 12,950.46	$ 4,602.48	$ 8,347.98	$ 83,701.56
3	$ 83,701.56	$ 12,950.46	$ 4,185.08	$ 8,765.38	$ 74,936.18
4	$ 74,936.18	$ 12,950.46	$ 3,746.81	$ 9,203.65	$ 65,732.53
5	$ 65,732.53	$ 12,950.46	$ 3,286.63	$ 9,663.83	$ 56,068.70
6	$ 56,068.70	$ 12,950.46	$ 2,803.44	$ 10,147.02	$ 45,921.68
7	$ 45,921.68	$ 12,950.46	$ 2,296.08	$ 10,654.37	$ 35,267.31
8	$ 35,267.31	$ 12,950.46	$ 1,763.37	$ 11,187.09	$ 24,080.22
9	$ 24,080.22	$ 12,950.46	$ 1,204.01	$ 11,746.45	$ 12,333.77
10	$ 12,333.77	$ 12,950.46	$ 616.69	$ 12,333.77	$ 0.00
		$ 1,29,504.57	$ 29,504.57	$ 1,00,000.00

Opening balance = previous year's closing balance
Closing balance = Opening balance+Loan-Principal repayment
PMT is calculated as per the above formula
Interest = 0.05 x opening balance
Principal repayment = PMT - Interest
So after the payment at the end of year 4, the loan balance is $65,732.53

jeff jeffy answered 1 year ago

Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate,...

Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate, a 20-year amortization and monthly payments of $965.02

Determine the annual payment on a $19,500 loan that is to be amortized over a four-year...

Determine the annual payment on a $19,500 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Also prepare a loan amortization schedule for this loan.

Determine the annual payment on a $17,000 loan that is to be amortized over a four-year...

Determine the annual payment on a $17,000 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Also prepare a loan amortization schedule for this loan.

What is the loan balance (in dollars) after the third payment, of a 5 year loan...

What is the loan balance (in dollars) after the third payment, of a 5 year loan of $100,000 with an APR of 10% and annual payments?

you borrowed 100,000 exactly 5 years ago. the loan is structured as an amortized loan. the...

you borrowed 100,000 exactly 5 years ago. the loan is structured as an amortized loan. the interest rate is 6 % and you make quarterly (end of quarter) payments of 1937.06. the loan is amortized over 25 years. how much principal have you paid over the first 5 years ?

A $200,000 loan amortized over 11 years at an interest rate of 10% per year requires...

A $200,000 loan amortized over 11 years at an interest rate of 10% per year requires payments of $21,215.85 to completely remove the loan when interest is charged on the unrecovered balance of the principal. If interest is charged on the original principal instead of the unrecovered balance, what is the loan balance after 11 years provided the same $21,215.85 payments are made each year?

a. Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 3% and...

a. Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 3% and the loan calls for equal monthly payments. The following table shows how you should prepare the amortization schedule for the loan. Month Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $100,000.00 b. Use the annuity formula to find how much principal you still owe to the bank at the end of the third year. Check that this value is the same...

Assume that a partially amortized 10-year and 5% coupon semi-annual bond has a balloon payment of...

Assume that a partially amortized 10-year and 5% coupon semi-annual bond has a balloon payment of $500. The total amount of the principal reimbursed after 18 months is closest to: A 20.56 B 60.19 C 61.68

Your company is planning to borrow $3 million on a 5-year, 10%, annual payment, fully amortized...

Your company is planning to borrow $3 million on a 5-year, 10%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places

A home is purchased for 395,000 with a 10% down payment and a 30 year amortized...

A home is purchased for 395,000 with a 10% down payment and a 30 year amortized mortgage charging 3.6% compounded monthly find: a) the amount borrowed, b) the size of the monthly mortgage payment and c) the total interest paid over 30 years?

Question