Suppose Shin borrowed $70,000 on a student loan at a rate of 10% and must repay...

Suppose Shin borrowed $70,000 on a student loan at a rate of 10% and must repay it in 5 equal installments at the end of each of the next 5 years.

a. Construct an amortization schedule.

b. What is the annual interest expense for the borrower and the annual interest income for the lender during Year 4?

Expert Solution

a:

Instalment No	Opening balance	Payment	Interest component	Principal repaid
1	70000	$18,465.82	7000	$11,465.82
2	$58,534.18	$18,465.82	5853.417634	$12,612.41
3	$45,921.77	$18,465.82	4592.177032	$13,873.65
4	$32,048.12	$18,465.82	3204.81237	$15,261.01
5	$16,787.11	$18,465.82	1678.711241	$16,787.11

b: In year 4, interest = $3204.81

WORKINGS

jeff jeffy answered 7 months ago

Suppose you borrowed $50,000 at a rate of 8.5% and must repay it in5 equal...

Suppose you borrowed $50,000 at a rate of 8.5% and must repay it in 5 equal installments at the end of each of the next 5 years. By how much would you reduce the amount you owe in the first year?

Suppose you borrowed $50,000 at a rate of 8.5% and must repay it in 5 equal...

Suppose you borrowed $50,000 at a rate of 8.5% and must repay it in 5 equal installments at the end of each of the next 5 years. By how much would you reduce the amount you own in the first year?

You borrowed $45,000 at 4% annual interest rate that you must repay over 3 years. The...

You borrowed $45,000 at 4% annual interest rate that you must repay over 3 years. The loan is amortized into three-equal end-of-year payments. (a) Calculate annual payment amount (b) Prepare a loan amortization schedule (c) If you make equal monthly payment for 36 months, calculate monthly payment amount and prepare a monthly loan amortization schedule (d) How much is total interest charge for 3 years, if you make annual payment? How much is total interest charge...

Suppose you borrow $20,000 at an annual rate of 6% and must repay it in 6...

Suppose you borrow $20,000 at an annual rate of 6% and must repay it in 6 equal installments at the end of each of the next 6 years. How much will you still owe at the end of the second year, after you make the second payment?

You have borrowed 15,000 and agreed to repay the loan with 5 annual level payments of...

You have borrowed 15,000 and agreed to repay the loan with 5 annual level payments of 4000, with the ﬁrst payment occurring one year from today. What annual interest rate are you paying?

If you borrowed $30,000 at 25% annual interest. You agreed to repay the loan with five...

If you borrowed $30,000 at 25% annual interest. You agreed to repay the loan with five equal annual payments. How much of the total amount repaid is interest? How much of the third annual payment is interest, and how much principal is there? If you decided to pay off your loan after the third payment, how much will you pay? please i want the result step by step by hand not using excel! thanks in advance

If you borrowed 24000 at 6% annual interest. You agreed to repay the loan with five...

If you borrowed 24000 at 6% annual interest. You agreed to repay the loan with five equal annual payments. How much of the total amount repaid is interest? How much of the third annual payment is interest, and how much principal is there? If you decided to pay off your loan after the third payment, how much will you pay?

You have just borrowed $300,000 to buy a condo. You will repay the loan in equal...

You have just borrowed $300,000 to buy a condo. You will repay the loan in equal monthly payments of $3,950.37 over the next 20 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. What is the effective annual rate on that loan? (Do...

You have just borrowed $160,000 to buy a condo. You will repay the loan in equal...

You have just borrowed $160,000 to buy a condo. You will repay the loan in equal monthly payments of $1,287.40 over the next 30 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. What is the effective annual rate on that loan? (Do...

You have just borrowed $100,000 to buy a condo. You will repay the loan in equal...

You have just borrowed $100,000 to buy a condo. You will repay the loan in equal monthly payments of $804.62 over the next 30 years. a. What monthly interest rate are you paying on the loan?' b. What is the APR? c. What is the effective annual rate on that loan? d. What rate is the lender more likely to quote on the loan?

Question