Question

In: Accounting

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

Solutions

Expert Solution

1] The loan amortization formula is:
PMT = L*r*(1+r)^n/((1+r)^n-1), where
PMT = Periodic payment [installment]
L = Loan amount
r = interest rate per year
n = number of years
Using the above formula the annual installment = 30000*0.25*1.25^5/(1.25^5-1) = $                11,155
2] Total amount paid = 11155*5 = $                55,775
Total amount paid as interest = 55,777.01-30000 = $                25,775 Answer 1
3] The loan amortization would be as given below:
Year Beginning Balance Interest for the year Installment paid Payment of Principal Ending Balance
1 $                30,000 $            7,500 $          11,155 $             3,655 $         26,345
2 $                26,345 $            6,586 $          11,155 $             4,569 $         21,776
3 $                21,776 $            5,444 $          11,155 $             5,711 $         16,065
4 $                16,065 $            4,016 $          11,155 $             7,139 $           8,927
5 $                  8,927 $            2,232 $          11,155 $             8,923 $                  -  
$          25,778 $          55,775 $           29,997
4] Interest in third installment $                  5,444 Answer 2
Principal in third installment $                  5,711
5] Amount to be repaid after 3rd Installment $                16,065 Answer 3

Related Solutions

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 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 first payment occurring one year from today. What annual interest rate are you paying?
Mr. Lamb borrowed $85,000 at 11.40% compounded monthly. He agreed to repay the loan in equal...
Mr. Lamb borrowed $85,000 at 11.40% compounded monthly. He agreed to repay the loan in equal monthly payments over 15 years. What is the size of the monthly payment rounded up to nearest cent? How much of the 24th payment is interest? How much of the 137th payment goes towards principal? How much principal was paid down in the third year? Now assume that in part (a) you had rounded the payments down to the nearest dollar, what would be...
John borrowed $84,000 at 9.60% compounded monthly. He agreed to repay the loan in equal monthly...
John borrowed $84,000 at 9.60% compounded monthly. He agreed to repay the loan in equal monthly payments over a 15 year amortization term. (a) What is the size of the monthly payment?t Enter answer to 2 decimal places b) Now assume that in part (a) you had rounded the payments DOWN to the nearest dollar, what would be the size of the final payment? Round down to nearest dollar means for example 121.8 is rounded to $121.00 (NOT 122) c)...
What will be the effective interest rate when you repay a loan of $48,000 in five...
What will be the effective interest rate when you repay a loan of $48,000 in five years if the interest rate is 8.75% compounded continuously?
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...
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?
You have just borrowed $200,000 to buy a condo. You will repay the loan in equal...
You have just borrowed $200,000 to buy a condo. You will repay the loan in equal monthly payments of $2,106.45 over the next 25 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.) Monthly interest rate % a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) APR% b. What is the effective annual...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT