- You have accepted a loan in the amount of $15,000 for your new car. You have agreed to pay the loan back in four years. What is your monthly payment if you agree to pay an interest rate of 9% compounding monthly? Solve this problem for i = 6%, i = 7%, and i - 8%, each compounding monthly.
Q: out a 36-month installment loan to finance a delivery van for $26,100. The payments are $987 per…
A: The given problem can be solved using FV function in excel. FV function computes outstanding loan…
Q: In one instance, a financial institution loaned you $20,000 for two years at an apr of 4.75% for…
A: Interest refers to the cost of borrowing money from the lender.
Q: Supposed you want to buy a used car but your savings is not enough. To do this, you borrow P60,000…
A: Loan amortization is the process of scheduling out a fixed-interest rate loan into scheduled…
Q: Assume that you can get a loan from NCB for $264,500 for three years to buy an item of your…
A: Present Value of Ordinary Annuity refers to the concept which dictates the discounted value of a sum…
Q: If you take out a 4 year loan for $16,500 at your bank and pay the quarterly payments for the 4…
A: Total interest is = total payments - loan
Q: Suppose you lend $11,500 to a friend at an APR of 10.00%. Your friend will pay you back beginning…
A: The periodic payment can be made monthly, quarterly, semi-annually or annually. Periodic payment is…
Q: You have borrowed $20,000 from a bank for a five-year period. You will be making monthly payments on…
A: Borrowed amount is $20,000 Interest rate on Loan is 12% per annum Interest rate compounded monthly…
Q: Six years ago you acquired a 15-year loan of $140,400, charging 3.4% annual interest, compounded…
A: monthly payment formula: pmt=p×rm1-1+rm-m×n where, p = principal r = rate of interest m = frequency…
Q: If you borrow $2800 and agree to repay the loan in 5 equal annual payments at an interest rate of…
A: Using excel PMT function to calculate the yearly payment
Q: You borrow $ 1 million on a 10-year loan from a bank to finance the expansion of your business.…
A: Note: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts…
Q: You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is…
A: Hello, I am only answering first question as per the policy and if you want others to be answered…
Q: Suppose that you borrow $8,000 now, promising to repay the loan principal plus accumulated interest…
A: The future value of an amount is the future worth of an amount calculated based on the time value…
Q: The purchase of a car requires a $15,000 loan to be repaid in monthly installments for four years at…
A: Computation:
Q: You are considering a thirty-year home loan of $400,000. A prospective lender has quoted an APR of…
A: a. MONTHLY PAYMENT FORMULA: PMT = P×rn1-1+rn-mn=$400,000×3.75%121-1+3.75%12-30×12=$1852.46 answer:…
Q: Suppose that you borrow $10,000 from a bank to purchase a car. You agree with the bank to repay the…
A: Given: Particulars Amount Loan $10,000 Interest rate 16% Years 1
Q: years ago you acquired a 15-year loan of $180,300, charging 4.5% annual interest, compounded…
A: Monthly payment when interest rate was 4.5%: $1,379.28 Calculation: Loan payment…
Q: Suppose that you borrow $10,000 for four years at 8% toward the purchase of a car. Find the monthly…
A: The amortization schedule shows the periodic loan payment owed for each period, the amount of…
Q: Assume you graduate from college with $35,000 in student loans. If your interest rate is fixed at…
A: Monthly payment = PV/(1-(1+i)-n)/i Where PV - Loan amount i.e. $35,000 i - Interest rate i.e.…
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: You have taken out a loan that requires you to repay $200 per month for 10 years at 12% annual…
A: Given:
Q: You want to buy a car, and a local bank will lend you $35,000. The loan will be fully amortized over…
A: Loan amount is the amount borrowed from the financial institutions such as banks, corporate houses,…
Q: You borrow $10,000 from a bank for three years at an annual interest rate of 12% compounded…
A: Given information : Borrowed amount $10,000 Interest rate 12% Time period (years) 3 Note :…
Q: Assume you have secured a loan of $10,000 from a bank which will be paid in one year. The bank has…
A: Month Instalment Interest Paid = Opening Balance x 0.31% Principal Opening Balance Closing Balance…
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: To pay for your education, you've taken out $18,000 in student loans. If you make monthly payments…
A: Loan Amount = $18,000 Time Period = 10 Years Interest Rate = 3% compounded monthly
Q: years ago, you acquired a 25-year loan of $190,200, charging 6.3% annual interest, compounded…
A: Note: No intermediate round is done in the solution. Initial loan amount = $190200 Number of years…
Q: After making the twenty-sixth payment on your car loan, you wanted to find out how much is left of…
A: Loan amount (PV) = $27000 Interest rate = 7.1% Monthly interest rate (r) = 7.1%/12 =…
Q: Suppose you purchase a car for a total price of $24,790 including taxes and licensee and finance…
A: To find the monthly payment, we will use the present value of annuity formula and adjust it to find…
Q: 4. You are buying your first car for $20,000 and are paying $2,000 as a down payment. You have…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: Mr. Jimin borrowed money to CBA Bank for $211,000 for business development the chicken farm. The…
A: Given, Loan Amount - 211,000 Interest rate = 9% (compounded monthly) Period - 12 years
Q: Suppose your car loan for 36 months has a monthly payment of $425. Immediately after the 30th…
A: Effective Annual Rate: The effective annual rate of interest is the actual or the real rate of…
Q: You receive a car loan of $22,000 and must pay off the loan in 60 monthly installments. If your…
A: The periodic payment for a loan can be found using the PMT Function in excel. PMT = (RATE, NPER, PV,…
Q: A student takes out a college loan of $4000 at an annual percentage rate of 5%, compounded monthly.…
A: PV 4000 RATE 5% COMPOUNDING PER YEAR 12 PMT 200 TIME PMT PRINCIPAL…
Q: You have just taken out a $25.000 car loan with a 4% APR, compounded monthly. The loan is for five…
A: A monthly mortgage payment is a monthly payment that is to be paid for a specific period of time to…
Q: payment
A: Monthly payments are nothing but the payment which has to be made by the borrower every month. The…
Q: You have taken out a 60-month, $26,000 car loan with an APR of 6%, compounded monthly. The monthly…
A: Loan Amortization Schedule gives the information of your loan and how you'll repay it. The payment…
Q: Suppose you borrow $10,000 from your parents to buy a car. You agree to pay $208 per month for 48…
A: Here the monthly payment is a annuity and we need to find the interest rate given the following:…
Q: Suppose you take on a loan that is subject to an annual interest rate of 12%, with the interest rate…
A: present value=future value1+rate of interestfrequency of compoundingyear×frequency
Q: Assume you have secured a loan of $10,000 from a bank which will be paid in one year. The bank has…
A: Interest payable = Opening Balance * Monthly interest rate
Q: If you buy a computer directly from the manufacturer for $2,241 and agree to repay it in 48equal…
A: Using Excel PMT function.
Q: Suppose that you borrowed $20k for 36 months to buy a car last year at an annual interest rate of 5%…
A: Monthly payment is the fixed amount of monthly payment made by the borrower against the loan. The…
Q: You are interested in a car which costs $25,000. You have a $2000 down payment, and you have a found…
A: A loan is amortized by paying equal monthly installments comprising Principal and interest. Total…
Q: If you borrowed S 15,000 to be repaid in 20 equal quarterly payments and after your 10th payment you…
A: Present value refers to the current valuation for a future sum. Investors determine the present…
Q: You want to borrow $30,000. For the loan to you must repay $1100 every quarter (4 times per year)…
A: Loan is an agreement between lender and borrower where lender agrees to provide funds to lender for…
Q: What is the compound amount when $6400 is deposited in an account earning an interest rate of 6%,…
A: Because you have posted multiple questions, we will answer the first question only, For the…
Q: Suppose that you're planning a vacation and borrow $2,000 from a bank for one year at a stated…
A: The real interest that an investor earns on the investment and a borrower pays on loan after…
Solve Problem 20.11 using Excel.
Trending now
This is a popular solution!
Step by step
Solved in 6 steps
- You have accepted a loan in an amount of $15,000 for your new car. You have agreed to pay the loan back in four years. What is your monthly payment if you agree to pay an interest rate of 9% compounding monthly? Solve this problem for i = 6%, i = 7%, and i = 8% each compounding monthly.Suppose that you borrow $17,000 for three years at 8% toward the purchase of a car. Use PMT= PA [---] -nt The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) to find the monthly payments and the total interest for the loan.You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is the amount of interest? What is the true interest rate cost of this loan? If you could pay the same loan above at a compound rate: What would the monthly payment be? What would the amount of interest be? 3. Prepare a monthly payment schedule for each loan above using Excel, and submit it.
- Suppose that you buy a car costing $14,000. You agree to make payments at the end of each monthly period for 4 years. You pay 7% interest, compounded monthly.(a) What is the amount of each payment? (b) Find the total amount of interest you will pay.You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is the amount of interest? What is the true interest rate cost of this loan? If you could pay the same loan above at a compound rate: What would the monthly payment be? What would the amount of interest be? Prepare a monthly payment schedule for each loan above using Excel, and submit it. Suppose that you are only allowed to make a balloon payment to the principal of the compound interest loan. You have $1,000 to put down at the beginning of year three. How many payments will you save?Suppose that you borrow $10,000 for four years at 8% toward the purchase of a car. Use PMT = to find the monthly payments and the total interest for - nt 1- the loan. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) The total interest for the loan is $ (Use the answer from part (a) to find this answer. Round to the nearest cent as needed.)
- Suppose you want to borrow $20,000 for a new car. You can borrow at 8% per year, compounded monthly (8/12 =.66667% per month). lf you take a 5 year loan, what is your monthly payment? Respuesta:You borrow $18826 to buy a car. You will have to repay this loan by making equal monthly payments for 5 years. The bank quoted an APR of 12%. How much is your monthly payment (in $ dollars)? $_______You have decided to buy a car that costs $25,800. Since you do not have a big down payment, the lender offers you a loan with an APR of 6.01 percent compounded monthly for 6 years with the first monthly payment due today. What is the amount of your loan payment?
- a. If you borrow $2,200 and agree to repay the loan in five equal annual payments at an interest rate of 12%, what will your payment be? b. What will your payment be if you make the first payment on the loan immediately instead of at the end of the first year?You have just taken out a $16,000 car loan with a 8% APR, compounded monthly. The loan is for five years. When you make your first payment in one month, how much of the payment will go toward the principal of the loan and how much will go toward interest? (Note: Be careful not to round any intermediate steps less than six decimal places.) When you make your first payment, $____ will go toward the principal of the loan and $______ will go toward the interest. (Round to the nearest cent.)Suppose that you decide to borrow 13000 for a new car. You can select one of the following loans each requiring regular monthly payments. Installment loan A three-year loan at 5.9% Installment loan B five -year loan at 5.8% What would be the monthly payments for each loan and total interest for them also?