You buy items costing $800 and finance the cost with a fixed loan installment for 18 months at 5% simple interest per year. What is the finance charge? What is the monthly payment?

Q: $5000 that you have to pay in 7 annual installments of $1100 each, the first one at the end of the…

A: The given problem relates to RATE function in excel. RATE function computes interest rate for no. of…

Q: If you repaid a loan of $3000 in 4 years with monthly installments of $86, what was the finance…

A: Computation:

Q: Consider a loan of 1,000,000 which is to be amortized by 60 monthly payments. The interest rate is…

A: Loan (mortgage) amortization schedule refers to a schedule which is prepared to shows the periodic…

Q: Suppose you take out a loan for 180 days in the amount of $11,500 at 14% ordinary interest. After 60…

A: A loan is an amount borrowed by a party in exchange for its repayment along with some interest.

Q: A car loan for $19,500 has an interest rate of 4.25% and is amortized over 60 months.  What is the…

A: Monthly payment of loans is popularly also known as EMI ( Equated Monthly Installments) which is a…

Q: You borrow a five-year $13,000 loan with monthly payments of S250. What is the annual percentage…

A: PV = 13000, PMT = -250, N = 5*12, FV = 0 use rate function in Excel monthly rate = 0.48%

Q: You borrow $280,000 at 4.00% per year and will pay off the loan in equal payments starting one year…

A: Borrowings are the liability that is used to finance the requirement of the funds. The borrwer needs…

Q: What monthly payment is required to amortize a loan of $50,000 over 12 yr if interest at the rate of…

A: using excel PMT function to calculate the monthly payment =PMT(rate,nper,pv,[fv])

Q: You take one-year installment loan of $1000 at an interest rate of 12% per year (1% per month) to be…

A: Loan amount (L) = $1000 r = 1%  n = 12

Q: In ‘N Out Payday Loans advertises that for a fee of only $10, you can immediately borrow up to $200…

A: Calculation of nominal interest rate per month =Amount of fees / Amount of borrowings = 10/200 =0.05…

Q: What are the weekly payments on a 6-year, $80,000 loan if the interest rate is 14%?

A: Using excel PMT function

Q: If you have a $15,000 car note with a $450.00 monthly payment, payable over 36 months, what interest…

A: In the given question we need to compute the interest rate from following details: Car note value =…

Q: What would be the total interest paid

A: Interest is charged on the amount lent by the lender to the borrower. In short, any excess payment…

Q: If you have a $19,500 car note with a $380.00 monthly payment, payable over 60 months, what interest…

A: In the above question we need to compute the interest rate from following details: Value of card…

Q: You borrowed $5,000 for 24 months at 6% interest. What is the total payback on the Single Payment…

A: Total payback on the Single Payment loan - It es the payback of the loan at a single payment…

Q: If you borrow $7,500 at $550 interest for one year, what is your effective interest rate for the…

A: The effective rate of interest refers to the return on savings or interest on the investment…

Q: The going annual interest rate for a loan with a term of 30 years is 6% compounded monthly. The…

A: Going interest rate is the interest rate that is prevailing in the market for loans or bonds. It is…

Q: A consumer loan of P80,000 is obtained that is due 3 months from now. If interest rate is 8%…

A: The borrower is required to pay the lender the initial sum borrowed and the interest on the loan.…

Q: A car loan requires 30 monthly payments of $199.00, starting today. At an annual rate of 12 percent…

A: In the given question we require to calculate the amount of money lent from following details:…

Q: You have a student loan of 25000 with a fixed Apr of 6 % for 15 years  what is the monthly payment…

A: Using excel PMT function

Q: When interest is charged on the unrecovered balance, if you borrow $10,000 at 10% per year interest…

A: Whenever loan is taken, interest is required to be paid on that loan. That interest calculation can…

Q: How many months will it take you to pay off a loan of $17,000 at 7% APR compounded monthly if you…

A: The loan is taken in order to finance the purchase of the asset or for the purpose of expansion. The…

Q: If the bank quotes a loan APR of 9% per annum, compounded monthly, what do you have to pay back in 1…

A: Compound interest= P(1+r%/n)^tn Interest rate = 9% Borrow amount= 100

Q: If you borrow $800 for 6 months at 4% annual simple interest, how much must you repay at the end of…

A: Borrow amount (principal)= 800 Interest =4% Period =6 months

Q: You have taken out a loan that requires you to repay $200 per month for 10 years at 12% annual…

A: Given:

Q: A loan is to be repaid quarterly for 5 years that will start at the end of 2 years. If interest rate…

A: Given Information: Quarterly payment = 10,000 Annual interest rate = 6% Number of years payment made…

Q: You borrow $8,000 at an annual rate of 21%. If you repay the debt in three months, what do you owe?

A: In this question we require to calculate the amount we owe if we borrow $8000 and repay it in 3…

Q: You invest $5,000 into a money market account that pays interest monthly (e.g., interest is…

A: Future Value = Present Value * (1+r)^n Where, n = no. of compounding period i.e. 3 years * 12 = 36 r…

Q: You have taken out a home loan of $400,000 at an interest rate of 3.6% per annum compounded monthly.…

A: A loan is a debt amount borrowed by one person from another person. A loan payable in equivalent…

Q: A personal loan for $20,000 has an interest rate of 12% over 5 years with monthly payments. What is…

A: Equated Monthly Instalment(EMI) means a part of the equally divided monthly amount paid for the…

Q: PLEASE DO THE FOLLOWING ON AN EXCEL SPREADSHEET: Consider a loan of $1,000,000 with the nominal…

A: Given information : Loan amount $1,000,000 Annual interest rate 10% Time period (years) 15…

Q: What monthly payment is required to pay off a $40,000 loan in seven years if the interest rate is…

A: Loan Payment: These represent periodic payments made by the borrower for borrowing a sum of the…

Q: A $25,000 loan has a yearly 3.2% interest applied to it monthly. The loan is being paid off with…

A: Monthly payment refers to the periodic payment extended by the borrower against loan repayment. The…

Q: How many months will it take you to pay off a loan of $11,000 at 3% APR compounded monthly if you…

A: Loan = 11000 APR = 3% Monthly Compounding Interest Rate = APR / Number of compounding periods =…

Q: Consider a loan of 800,000 which is to be amortized by 60 monthly payments. The interest rate is 12%…

A: Monthly payment is the portion of the loan amount along with the interest that is paid every month.…

Q: The monthly payment on an 8%, 36-month, add-on loan for $10,000 would be

A: Information Provided: Rate = 8% Time = 36months or 3years Principal = $10,000

Q: Consider a loan of 1,000,000 which is to be amortized by 60 monthly payments. The interest rate is…

A: Monthly payment is the portion of the loan amount along with the interest that is paid every month.…

Q: What is the monthly payment to repay a 10 year loan of $200,000 at a nominal rate of 15% per year if…

A: For this solution we need to consider the quarterly interest rate and quarter period and calculate…

Q: A payday loan company charges $95 fee for a $350 payday loan that will be repaid in 13 days.…

A: Given, Payday loan company charges fee = $95 Payday loan amount = $350 Duration = 13 days

Q: annual loan payment

A: Annual Loan Payment: Annual loan payment is the amount to be paid in a year on the loan taken.…

Q: What is the size of eight equal annual payments to repay a loan of$1,000? The first payment is due…

A: PV = 1000 FV = 0 rate = 10% N = 8 use PMT function in Excel

Q: What is the size of 8 equal annual payments to repay a loan of $1,000? The first payment is due one…

A: Present Value of annuity refers to the present value of all the future payments of and series of…

Q: How many monthly payments are required to repay a loan of $12,000 with an interest rate of ¾% per…

A: A concept that implies the future worth of the money is lower than its current value due to several…

Q: What amortization payment would you need to make every month, at 12% interest compounded monthly, to…

A: Monthly Payment is the payment that is to be paid monthly for a specific period of time to repay the…

Q: A loan of ₱20,000 will be paid semiannually for 4 years. What is the amount of each payment if…

A: Borrowings are the liability of the company which is used to finance the requirement of the funds.…

Cost of Credit

The cost of credit is an extra amount that the borrower has to pay besides the loan amount. These credit charges may vary from loan to loan. The cost of credit includes interest charges, maintenance charges, and arrangement charges. Some of the costs are mandatorily collected by the lender based on the loan amount and tenure of the loan. The cost of credit is also called finance charges of the credit.