Question

In: Finance

Matt needs to borrow money to go to college. He has been granted a student loan...

Matt needs to borrow money to go to college. He has been granted a student loan of $7000. When is school, he actually only needed $6000. He has two options for paying it back. The great news about student loans is that interest does not calculate until he finishes school. What should be choose and why? • Option A: Pay back $1000 extra before the interest starts. Pay back the $6000 loan over 3 years at 5.2% interest compounded annually by making monthly payments. • Option B: Use the extra $1000 to help buy a car. Pay back the entire student loan over 4 years at 5.2% interest compounded annually by making monthly payments.

Solutions

Expert Solution

Option 1: Payback = $ 1000, Borrowing = $ 6000, Interest Rate = 5.2 % and Repayment Tenure = 3 years or (3x12)=36 months

Applicable Monthly Rate = 5.2/12 = 0.4333 %

Let the monthly repayments be $ M

Therefore, 6000 = M x (1/0.004333) x [1-{1/(1.004333)^(36)}]

6000 = M x 33.2661

M = 6000 / 33.2661 = $ 180.364

Option 2: Borrowing = $ 7000, Interest Rate = 5.2 % and Repayment Tenure = 4 years or (4x12)=48 months

Applicable Monthly Rate = 5.2/12 = 0.4333 %

Let the monthly repayments be $ M

Therefore, 7000 = M x (1/0.004333) x [1-{1/(1.004333)^(48)}]

7000 = M x 43.2529

M = 7000 / 43.2529 = $ 161.839

Total Repayment under Option 1 = 36 x 180.364 = $ 6493.09, Interest Paid = 6493.09 - 6000 = $ 493.09

Total Repayment under Option 2 = 48 x 161.839 = $ 7768.26, Interest Paid = 7768.26 - 7000 = $ 768.26

As the student pays less interest under Option 1 as compared to Option2, the student should select Option1.


Related Solutions

Student Loan Program The National Direct Student Loan (NDSL) program allows college students to borrow funds...
Student Loan Program The National Direct Student Loan (NDSL) program allows college students to borrow funds from the federal government. The contract stipulates that the annual percentage rate of interest is 0 percent until 12 months after the student ceases his or her formal education (defined as as least half-time enrollment). At that time, interest becomes 4 percent per year. The maximum repayment college period is 10 years. Assume that the student borrows $10,000 in the beginning of the first...
Calculating a Loan With the PMT Function in Excel Everyone needs to borrow money some time....
Calculating a Loan With the PMT Function in Excel Everyone needs to borrow money some time. Every time you use your credit card you are taking out a loan. The key question for most people is “What will my monthly payment be?” Fortunately, Excel has a special function just for this calculation, called PMT. The basic syntax for PMT is as follows: =PMT(rate, nper, pv) Let’s break down the ARGUMENTS you have to input: The rate input is the amount...
The Hidden Student Loan Debt Problem Much outrage has been expressed over the difficulty U.S. college...
The Hidden Student Loan Debt Problem Much outrage has been expressed over the difficulty U.S. college students and recent graduates are facing because of their student loan debt. Since the recession began in 2008, the amount of student loan debt has spiked by 84 percent, with borrowers owing a record $1.2 trillion. Nearly 40 million Americans have at least one outstanding student loan, according to new research by Experian. But is the problem as dire as some make it out...
Tom has taken out a loan for college. He started paying off the loan with a...
Tom has taken out a loan for college. He started paying off the loan with a first payment of $200. Each month he pays, he wants to pay back 1.2 times as the amount he paid the month before. Explain to Tom how to represent his first 30 payments in sigma notation. Then explain how to find the sum of his first 30 payments, using complete sentences. Explain why this series is convergent or divergent.
A college student has been looking for a new tires. The student feels that the warranty...
A college student has been looking for a new tires. The student feels that the warranty period is a good estimate of the tire life and that 10% interest rate is appropriate. Given 4 options find the minimum Equivalent Uniform Monthly Cost. (Note: the student wants to buy 4 tires) Hint use i/12 for computing the annual costs. Warranty time (months) Tire price (all 4 tires) Warranty time (months) Tire price (all 4 tires) 12 36 24 54 36 68...
Student Debt – Vermont: The average student loan debt of a U.S. college student at the...
Student Debt – Vermont: The average student loan debt of a U.S. college student at the end of 4 years of college is estimated to be about $21,800. You take a random sample of 141 college students in the state of Vermont and find the mean debt is $23,000 with a standard deviation of $2,800. You want to construct a 99% confidence interval for the mean debt for all Vermont college students. (a) What is the point estimate for the...
Student Debt – Vermont: The average student loan debt of a U.S. college student at the...
Student Debt – Vermont: The average student loan debt of a U.S. college student at the end of 4 years of college is estimated to be about $22,500. You take a random sample of 146 college students in the state of Vermont and find the mean debt is $23,500 with a standard deviation of $2,600. We want to construct a 90% confidence interval for the mean debt for all Vermont college students. (a) What is the point estimate for the...
Ricky Fowler needs to borrow $76,543 for seven years. The loan will be repaid in a...
Ricky Fowler needs to borrow $76,543 for seven years. The loan will be repaid in a single payment at the end of the loan term. Which one of the following interest rates is best for Ricky Fowler? A.) 7.5% simple interest B.) 7.6% simple interest C.) 7.5% interest, compounded annually D.) 7.75% interest, compounded annually
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...
The average student loan debt of a U.S. college student at the end of four years...
The average student loan debt of a U.S. college student at the end of four years of college is estimated to be about $22,000. You take a random sample of 150 college students in the state of Wyoming and find that the mean debt is $19,850, and the sample standard deviation is $2,180. (a) Construct a 95% confidence interval for the mean debt of all Wyoming college graduates. (b) Construct a 98% confidence interval for the mean debt of all...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT