Question

In: Finance

You graduated from college and decided to attend law school. If you go to law school,...

  1. You graduated from college and decided to attend law school. If you go to law school, you will be forced to incur $180,000 in student loans. The re-payment of the student loans will take place over the next ten years after you graduate. The current rate on student loans is 6% ARP (with monthly compounding).
    1. How much in interest will you pay over the lifetime of the loan?
    2. How much interest will save if you add an additional $150 to your monthly payment?

Solutions

Expert Solution

Calculating interest paid over the life time of loan

To find the interest paid over life time of loan, we need to find the monthly payment of loan

Loan = $180000, No of months of loan = 12 x no of years of loan = 12 x 10 = 120 months

Monthly rate of interest = APR with monthly compounding / 12 = 6% / 12 = 0.50%

We can find the monthly payment of loan using PMT function in excel

Formula to be used in excel: =PMT(rate,nper,-pv)

Using PMT function in excel, we get monthly payment of loan = 1998.3690

Total amount paid over life of loan = Monthly payment of loan x no of months = 1998.3690 x 120 = $239804.2800

Total interest paid over lifetime of loan = Total amount paid over life of loan - Loan = 239804.2800 - 1800000 = $59804.28

Hence Total interest paid over lifetime of loan = 59804.28

Calculating Interest saved

Additional monthly payment = $150

New monthly payment = Monthly payment + Additional monthly payment = $1998.3690 + 150 = $2148.3690

If the monthly payment is increased, then no of months to payoff the loan will be reduced. We can find the no of months of payoff loan with new monthly payment by using NPER function in excel

Formula to be used in excel: =NPER(rate,pmt,-pv)

Using NPER function in excel, we get get no of months to payoff loan = 108.8454 months

Total amount paid over life of loan = no of months x monthly loan payment = 108.8454 x 2148.3690 = 233840.0832

Total interest paid over life of loan = Total amount paid over life of loan - Loan = 233840.0832 - 180000 = 53840.0832

Total interest saved over life of loan = 59804.28 - 53840.0832 = $5964.1968

Answer: $5964.1968

jeff jeffy answered 2 months ago
Next > < Previous

Related Solutions

College bound: A national college researcher reported that 64%  of students who graduated from high school in...
College bound: A national college researcher reported that 64%  of students who graduated from high school in 2012 enrolled in college. Twenty eight high school graduates are sampled. Round the answers to four decimal places. (a) What is the probability that exactly 16 of them enroll in college? b) What is the probability that more than 13 enroll in college? (c) What is the probability that fewer than 10 enroll in college? (d) Would it be unusual if more than 23...
To complete your last year in business school and then go through law school, you will...
To complete your last year in business school and then go through law school, you will need $35,000 per year for 4 years, starting next year (that is, you will need to withdraw the first $35,000 one year from today). Your uncle offers to put you through school, and he will deposit in a bank paying 9.73% interest a sum of money that is sufficient to provide the 4 payments of $35,000 each. His deposit will be made today. How...
Newly graduated from medical school, David and Mary have decided to take over a medical practice...
Newly graduated from medical school, David and Mary have decided to take over a medical practice together in Saltbush, a small NSW country town. This decision was made after seeing the official announcement of the retirement of its two elderly doctors and the closure of their Saltbush practice. David and Mary have no plans to expand in the future but are wondering whether a partnership is the best legal structure for their business. Please advise the following: i. How does...
Q1. Jesse James graduated from high school in Wawanesa and decided to start his own business...
Q1. Jesse James graduated from high school in Wawanesa and decided to start his own business doing small building and repair jobs. Jesse knew that incorporating a business had many benefits so he set up a corporation with the help of a lawyer. The business was incorporated on July 1, 2019. Jesse had saved $20,000 which he transferred from his personal account into the bank account for Jesse James Home Improvements Ltd. (JJHI) and received shares in return. He then...
Q1. Jesse James graduated from high school in Wawanesa and decided to start his own business...
Q1. Jesse James graduated from high school in Wawanesa and decided to start his own business doing small building and repair jobs. Jesse knew that incorporating a business had many benefits so he set up a corporation with the help of a lawyer. The business was incorporated on July 1, 2019. Jesse had saved $20,000 which he transferred from his personal account into the bank account for Jesse James Home Improvements Ltd. (JJHI) and received shares in return. He then...
You are deciding if you should go to Law School, which is a three year degree....
You are deciding if you should go to Law School, which is a three year degree. If you do not go to law school, you will earn $47,000 per year. While you are in law school, you will have the opportunity to take a part-time job working for a professor for $12,000 per year. Tuition is $30,000 per year. Once you get a law degree, you will earn $100,000 per year. For simplicity, assume no raises. a) Suppose the interest...
My sister's teenager has decided not to attend college in favor of joining the stage crew...
My sister's teenager has decided not to attend college in favor of joining the stage crew for a touring rock band. What advice can I give my sister? Thank you, A. Grand
You have just graduated from The a College and is making a budget presentation to a...
You have just graduated from The a College and is making a budget presentation to a group of students. In your presentation you are required to prepare the cash budget for Neann Ltd for the first quarter of 2011. The following information is to be used in the preparation of the budget. a) The directors have agreed at a special meeting to inject additional capital into the business of $60million dollars in February 2011. b) The business expects to receive...
Woodcock graduated from law school and finished his MBA in 1983.His student loans came due...
Woodcock graduated from law school and finished his MBA in 1983. His student loans came due nine months later. Because he was a part-time student until 1990, he requested that payment be deferred, which the lender incorrectly approved. Because he was not in a degree program, payment should not have been deferred under the terms of the loan. Woodcock filed for bankruptcy in 1992, more than seven years after the loans first became due. Hence, that debt would be discharged...
You want to quit your job and go back to school for a law degree 4...
You want to quit your job and go back to school for a law degree 4 years from now, and you plan to save $2,100 per year, beginning immediately. You will make 4 deposits in an account that pays 5.7% interest. Under these assumptions, how much will you have 4 years from today?
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT