Question

In: Finance

If you borrow $40,000 today and agree to repay the loan in 24 annual payments, how...

If you borrow $40,000 today and agree to repay the loan in 24 annual payments, how much do you owe every year? Assume this is an amortized loan with 10% interest rate, compounded annually?

Solutions

Expert Solution

Loan amount = 40000
Interest rate annual= 10% or 0.1
Time in years (n)= 24

Equal annual payments for loan formula = P* i *((1+i)^n)/((1+i)^n-1)

40000*0.10*((1+0.10)^24)/(((1+0.10)^24)-1)

$4,451.99

Amount owed every year shall be $ 4451.99

(Please thumbs up)

Loan amortization table

Year Beginning balance Annual Payment Interest @10% Principal payment received

Ending balance

(Beg. Bal.*8%) (Payment - interest)

(Beg. Balance - Loan red.)

1 40000.00 4451.99 4000.00 451.99 39548.01
2 39548.01 4451.99 3954.80 497.19 39050.82
3 39050.82 4451.99 3905.08 546.91 38503.91
4 38503.91 4451.99 3850.39 601.60 37902.31
5 37902.31 4451.99 3790.23 661.76 37240.55
6 37240.55 4451.99 3724.05 727.94 36512.61
7 36512.61 4451.99 3651.26 800.73 35711.88
8 35711.88 4451.99 3571.19 880.80 34831.08
9 34831.08 4451.99 3483.11 968.88 33862.20
10 33862.20 4451.99 3386.22 1065.77 32796.43
11 32796.43 4451.99 3279.64 1172.35 31624.08
12 31624.08 4451.99 3162.41 1289.58 30334.50
13 30334.50 4451.99 3033.45 1418.54 28915.95
14 28915.95 4451.99 2891.60 1560.40 27355.56
15 27355.56 4451.99 2735.56 1716.44 25639.12
16 25639.12 4451.99 2563.91 1888.08 23751.04
17 23751.04 4451.99 2375.10 2076.89 21674.16
18 21674.16 4451.99 2167.42 2284.58 19389.58
19 19389.58 4451.99 1938.96 2513.03 16876.55
20 16876.55 4451.99 1687.65 2764.34 14112.21
21 14112.21 4451.99 1411.22 3040.77 11071.44
22 11071.44 4451.99 1107.14 3344.85 7726.60
23 7726.60 4451.99 772.66 3679.33 4047.26
24 4047.26 4451.99 404.73 4047.26 0.00

Related Solutions

You borrow $42,000 and repay the loan with 6 equal annual payments. The first payment occurs...
You borrow $42,000 and repay the loan with 6 equal annual payments. The first payment occurs one year after receipt of the $42,000 and you pay 8% annual compound interest. a)Solve for the payment size. b)What is the payment size when interest is 8% compounded monthly, and monthly payments are made over 6 years? c)What is the payment size when interest is 8% compounded semiannually, and annual payments are made over 6 years? d)What is the payment size when the...
Suppose you borrow $8,000 and agree to repay the loan in 4 equal installments over a...
Suppose you borrow $8,000 and agree to repay the loan in 4 equal installments over a 4-year period. The interest rate on the loan is 13% per year. What is the amount of the reduction in principal in year 2? A. $1,040 B. $1,864 C. $2,690 D. $826 E. $2000 Suppose you win $100 million in lottery. The money is paid in equal annual installments of $4 million over 25 years. If the appropriate discount rate is 10%, how much...
You are planning to borrow OMR 3,500. You can repay the loan in 40 monthly payments...
You are planning to borrow OMR 3,500. You can repay the loan in 40 monthly payments of OMR 103.25 each or 36 monthly payments of OMR 112.94 each. You decide to take the 40-month loan. During each of the first 36 months you make the loan payment and place the difference between the two payments (OMR 9.69) into an investment account earning 10% APR. Beginning with the 37th payment you will withdraw money from the investment account to make your...
You buy a car for $40,000. You agree to a 6 year loan with a annual...
You buy a car for $40,000. You agree to a 6 year loan with a annual interest 6 percent. a. What is your required monthly payment? b. What is the total amount interest payment over this period? C. Show the difference in the total interest payment if the payment was done yearly instead of monthly?
You borrow $7,000 today and promise to repay the loan over the next three years with 36 equal, end-of-month payments starting one month from today.
You borrow $7,000 today and promise to repay the loan over the next three years with 36 equal, end-of-month payments starting one month from today. The interest rate is 4% APR compounded monthly. What is the amount of each payment? Round only your final answer to two decimal places.• $206.67• $194.44• $214.98• $202.19• $223.86
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?
If you borrow a principal amount of $11,778 and are required to repay the loan in...
If you borrow a principal amount of $11,778 and are required to repay the loan in ten equal installments of $2,000, what is the interest rate associated with the loan?
Consider a 4-year amortizing loan. You borrow $2,900 initially and repay it in four equal annual...
Consider a 4-year amortizing loan. You borrow $2,900 initially and repay it in four equal annual year-end payments. a. If the interest rate is 9%, what is the annual payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. Prepare an amortization schedule. (Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.)
Consider a 4-year amortizing loan. You borrow $2,700 initially and repay it in four equal annual...
Consider a 4-year amortizing loan. You borrow $2,700 initially and repay it in four equal annual year-end payments. a. If the interest rate is 10%, what is the annual payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.)   Annual payment $    b. Prepare an amortization schedule. (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Time Loan Balance, $ Year-End Interest...
Suppose you plan to borrow $300,000 from a financial institution and you are required to repay the loan by making equal annual payments for five years (payment at the end of each year).
  Suppose you plan to borrow $300,000 from a financial institution and you are required to repay the loan by making equal annual payments for five years (payment at the end of each year). The interest rate for the loan is 3.5% per year. Show your answers correct to two decimal points. Calculate the annual payment required. Prepare an amortization schedule for the loan for each year according to the following format. Year Beginning balance Annual payment Interest paid Principal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT