Question

Jefferson qualifies for an income-adjusted monthly payment of $485. If Jefferson has a subsidized student loan...

Jefferson qualifies for an income-adjusted monthly payment of $485. If Jefferson has a subsidized student loan of $46,000 at an annual interest rate of 4% (compounded monthly), how many months are required to repay the loan? (Round your answer up to the nearest month.)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The number of months to repay the loan is calculated using NPER function in Excel ;

rate = 4%/12 (converting annual rate into monthly rate)

pmt = -485 (Monthly payment. This is entered with a negative sign because it is a payment)

pv = 46000 (loan amount)

NPER is calculated to be 114.20

This is rounded up to 115

It will take 115 months to repay the loan

X Fax =NPER(4%/12,-485,46000) A D E FE 1 - B 114.20 !

Add a comment
Know the answer?
Add Answer to:
Jefferson qualifies for an income-adjusted monthly payment of $485. If Jefferson has a subsidized student loan...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Lois received a 9-year subsidized student loan of $35,000 at an annual interest rate of 5.875%....

    Lois received a 9-year subsidized student loan of $35,000 at an annual interest rate of 5.875%. Determine her monthly payment on the loan after she graduates in 3 years. (Round your answer to the nearest cent.) Lois received a 9-year subsidized student loan of $35,000 at an annual interest rate of 5.875%. Determine her monthly payment on the loan after she graduates in 3 years. (Round your answer to the nearest cent.)

  • Part 1 Suppose a graduate student receives a non-subsidized student loan of $13,000 for each of...

    Part 1 Suppose a graduate student receives a non-subsidized student loan of $13,000 for each of the 4 years the student pursues a PhD. If the annual interest rate is 5% and the student has a 10-year repayment program, what are the student's monthly payments on the loans after graduation? (Round your answer to the nearest cent.) $____________ Part 2 Samuel Ng received a 3-year subsidized student loan of $12,000 at an annual interest rate of 5%. What are Samuel's...

  • Nathan has a loan of $6000 to repay, with an interest rate of 8% compounded monthly....

    Nathan has a loan of $6000 to repay, with an interest rate of 8% compounded monthly. Nathan planned to make $150 payments at the end of each month to repay his loan, but is considering only $100 per month. How many additional months will it take to repay the loan if he pays $100 per month instead of $150? (Hint: Round each term in months up to a whole number before finding the difference.)

  • 1. What monthly payment is required to amortize a loan of $50,000 over 14 years if...

    1. What monthly payment is required to amortize a loan of $50,000 over 14 years if interest at the rate of 6%/year is charged on the unpaid balance and interest calculations are made at the end of each month? (Round your answer to the nearest cent.) $ 2. The Flemings secured a bank loan of $368,000 to help finance the purchase of a house. The bank charges interest at a rate of 3%/year on the unpaid balance, and interest computations...

  • Instructor-created question Question Help A student takes out a loan of $2,600 at the beginning of...

    Instructor-created question Question Help A student takes out a loan of $2,600 at the beginning of each semester (semi-annually) for 11 semesters to pay for college. The loan charges 7.4% interest compounded semiannually. The student graduates after the 11 semesters and refinances the loan to a lower 6.7% rate compounded monthly with monthly payment (made at the end of each month) for 120 months. Find the monthly payment and the total interest paid The monthly payment is $ (Round to...

  • A student takes out a college loan of $6000 at an annual percentage rate of 5%,...

    A student takes out a college loan of $6000 at an annual percentage rate of 5%, compounded monthly. a. If the student makes payments of $800 per month, how much, to the nearest dollar, does the student owe after 4 months? Don't round until the end. Enter an integer or decimal number [more.. b. After how many months will the loan be paid off?

  • Consider a $15,000 loan with an annual interest rate of 9%, a term of four years,...

    Consider a $15,000 loan with an annual interest rate of 9%, a term of four years, anda monthly payment of A (5 points) What is the amount of the monthly payment? a. (10 points) Ifyou pay $750 per month, how many months will it take to repay the loan? b. (10 points) If you pay $750 per month on this loan, how much will the final payment C. be? Consider a $15,000 loan with an annual interest rate of 9%,...

  • • 1) A new car is purchased and a $20,000 loan is taken. The loan is...

    • 1) A new car is purchased and a $20,000 loan is taken. The loan is for 5 years (60 months) and the interest rate is 7.9% compounded monthly. What is the monthly payment? • 2)A new car is purchased and a $20,000 loan is taken. The loan is for 5 years (60 months) and the interest rate is 7.9% compounded monthly. What is the balance after 3 years? . 3) A new car is purchased and a $30,000 loan...

  • Ted borrowed $4,100 at 6.0% compounded monthly to purchase a used car. Payments of $485 will...

    Ted borrowed $4,100 at 6.0% compounded monthly to purchase a used car. Payments of $485 will be made at the end of every month. There will also be a final, smaller payment. Construct the full amortization schedule for the loan. How much interest will be paid over the life of the loan? (Do not round the intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Payment number Payment...

  • Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $1...

    Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT