You plan to apply for a $50,000 loan. The APR is 5.5% compounded quarterly. If you plan to make payments of $2,000 per quarter, how many years do you need to pay off the loan?

Question

You plan to apply for a $50,000 loan. The APR is 5.5% compounded quarterly. If you plan to make payments of $2,000 per quarter, how many years do you need to pay off the loan?

BlackTom AI · Accepted Answer

To determine how many years are needed to pay off the loan, we must evaluate the structure of the cash flows and the interest compounding.
Option 1: =NPER(5.5%*12, 2000, 50000,0)*12
This uses an annualized rate by multiplying 5.5% by 12, which is incorrect for quarterly compounding. It also uses a positive payment value, which conflicts with the typical cash-flow convention in NPER (payments are usually negative when you are paying the loan). Finally, multiplying by 12 would yield a number of years without the proper per-period calculation, making this option inconsistent with the actual quarterly setup.
Option 2: =NPER(5.5%/4, -2000, 50000,0)/4
Here the rate is divided by 4 to reflect quarterly compounding (5.5% per year → 5.5%/4 per quarter). The payment is entered as -2000, which correctly represents an outflow each quarter, and the present value is 50000 as a positive amount. The NPER function returns the number of quarters needed to amortize the loan to 0; dividing by 4 converts that quarter count into years. This aligns with the problem statement asking for years.
Option 3: =NPER(5.5%/4, 2000, -50000,0)/12
This option flips the sign of the payment (positive 2000) and the present value (negative 50000), which breaks the standard cash-flow convention used by NPER for loans. Additionally, dividing by 12 would attempt to convert to years via months, which is not appropriate here since the payments are quarterly. Overall, this misrepresents both cash flows and the timing unit.
Option 4: =NPER(5.5%/12, -2000, 50000,0)/12
This one uses an interest rate of 5.5%/12, implying monthly compounding, while the problem specifies quarterly compounding. It also divides by 12, which would convert quarters to years through a monthly basis, not aligning with the given quarterly payments. Thus the rate basis and unit conversion are both inconsistent with the scenario.
In summary, Option 2 is the only choice that correctly matches the quarterly compounding (rate per quarter), uses the correct cash-flow signs for a loan payoff, and converts the resulting number of quarters into years by dividing by 4. The other options mishandle the compounding period, sign conventions, or unit conversions, leading to incorrect results.

CSE 2111 AU2025 (10550) Post-Test Quiz

You plan to apply for a $50,000 loan. The APR is 5.5% compounded quarterly. If you plan to make payments of $2,000 per quarter, how many years do you need to pay off the loan?

查看解析

登录即可查看完整答案

类似问题

In implementing a credit card payment program, assuming to stop using credit, your debt balance will decrease slowly at first and more quickly as time progresses.

You bought a new car today which cost you $20,000. You financed the entire cost with a 5-year loan at 4.00%. If you make payments at the end of each month starting a month from now, how much is your monthly payment?

Question at position 21 One of the main distinctions between a construction loan and permanent financing is that a construction loan payment is “Interest Only” and permanent financing is “Amortizing”, meaning the principal is paid down over the life of the loan?TrueFalse

Elena is looking to buy a car for $10,000. She is planning to buy this car by borrowing 60% of the car price. The bank is happy to do the loan for 3 years at a rate of 7.67% per year. Calculate the monthly car loan repayment In your answer, ignore the "$" and enter with 2 decimal places

Question at position 25 At the end of a fully amortized loan, there is a final balloon payment to the lender.TrueFalse

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单