Question

In: Finance

To borrow $1,600, you are offered an add on interest loan at 8.2 percent with 12...

To borrow $1,600, you are offered an add on interest loan at 8.2 percent with 12 monthly payments. Compute the 12 equal payments. (Round your answer to 2 decimal places.) Equal Payments

Use the amount you borrowed and the monthly payments you computed to calculate the APR of the loan. Then, use that APR to compute the EAR of the loan. (Do not round intermediate calculations and round your answer to 2 decimal places.) EAR ____ %

Solutions

Expert Solution

Loan = Principal = $1600, Interest rate = 8.2%, Period of loan = 12 months = 1 year

In add on method, total interest paid over tenure of loan is calculated using Principal of loan

Total interest to be paid over tenure of loan = principal x interest rate x no of years of loan = 1600 x 8.2% x 1 = 131.20

Total amount paid over tenure of loan = principal + Total interest to be paid over tenure of loan = 1600 + 131.20 = 1731.20

Monthly payment of add on interest loan = Total amount paid over tenure of loan / No of months = 1731.20 / 12 = 144.2666 = 144.27 (rounded to two decimal places)

Equal payments = $144.27

To find the APR of loan we need to first find the monthly rate of loan, We can find the monthly rate of loan using RATE function in excel

Formula to be used in excel: =RATE(nper,-pmt,pv)

Using RATE function in excel, we get monthly rate of loan = 1.2341%

APR = monthly rate of loan x 12 = 1.2341% x 12 = 14.8092% = 14.81% (rounded to two decimal places)

Hence APR of loan = 14.81%

EAR = (1+monthly rate)12 - 1 = (1+1.2341%)12 - 1 = (1.012341)12 - 1 = 1.158569 - 1 = .0.158569 = 15.8569% = 15.86% (rounded to two decimal places)

Hence EAR of loan = 15.86%


Related Solutions

1) To borrow $1,500, you are offered an add on interest loan at 8.4 percent with...
1) To borrow $1,500, you are offered an add on interest loan at 8.4 percent with 12 monthly payments. Compute the 12 equal payments. 2) Use the amount you borrowed and the monthly payments you computed to calculate the APR of the loan. Then, use that APR to compute the EAR of the loan. 1-? 2-?
To borrow $500, you are offered an add-on interest loan at 8 percent. Two loan payments...
To borrow $500, you are offered an add-on interest loan at 8 percent. Two loan payments are to be made, one at six months and the other at the end of the year. Compute the two equal payments.
You borrow $1,600 at 6% (SA) and owe $2,026.83. What is the termof the loan?...
You borrow $1,600 at 6% (SA) and owe $2,026.83. What is the term of the loan? Round the answer to n to a whole (i.e. n = 13.999 = 14, n= 4.00005 = 4) - do this before you convert to years and months. Answer in Years and Months (if years or months are zero, place 0).
Assume you are to borrow money, the loan amount, at an annual interest rate to be...
Assume you are to borrow money, the loan amount, at an annual interest rate to be paid in equal installments each period. Installment Loan Schedule Loan Amount $25,000 Annual Interest Rate 9.90% Periods per year 12 Years to payback 5 See Table B.3 in book. Factor 47.17454194 FACTOR = [1 - (1 / ((1 + R)^n)]/ R Equal Payments $529.95 let R = period interest rate let n = number of periods to payback loan Number of periods: 60 Reduction...
Suppose you obtain a 20-year mortgage loan of $197,000 at an annual interest rate of 8.2%....
Suppose you obtain a 20-year mortgage loan of $197,000 at an annual interest rate of 8.2%. The annual property tax bill is $978 and the annual fire insurance premium is $491. Find the total monthly payment for the mortgage, property tax, and fire insurance. (Round your answer to the nearest cent.)
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years?
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years.
If you borrow $7,000 with an interest rate of 3 percent, to be repaid in five...
If you borrow $7,000 with an interest rate of 3 percent, to be repaid in five equal yearly payments at the end of the next five years, what would be the amount of each payment? Use Exhibit 1-D. (Round time value factor to 3 decimal places and final answer to 2 decimal places.) Amount of each paymet
You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate...
You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate is 4.46%, what is your monthly payment?
You borrow a ten-year loan of $1,500,000. The annual interest rate is 13% that to be...
You borrow a ten-year loan of $1,500,000. The annual interest rate is 13% that to be repaid every 2 weeks. Assume 52 weeks a year. List the numerical answers and EXCEL formulas of payment, interest, principal paid and end balance of 115th periodic payment in the table provided. Payment Interest Principal End Balance (Period 115) (Numerical Answer) (Numerical Answer) (Numerical Answer) (Numerical Answer) (EXCEL Formula) (EXCEL Formula) (EXCEL Formula) (EXCEL Formula)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT