Bradley borrowed $72,500 in student loans and he has just graduated from Elon University. He earns...

Bradley borrowed $72,500 in student loans and he has just graduated from Elon University. He earns enough at his new job to allow him to pay $575 per month on the loan. If the annual rate on the student loan is 4.38% (compounded monthly), how long will it take Bradley to pay off his student loans? Specify the number of months to the nearest whole number

Chandler found his dream mountain home, valued at $245,000. He plans to buy a home just like it when he retires in 15 years. Chandler can earn 6.96 percent per year on his investments. Assume that the price of the house will increase 2.25 percent per year for the next 15 years. How much must he invest at the end of each month for the next 15 years to make the purchase at the end of the 15th year?
A. less than $1,015
B. more than $1,015 but less than $1,080
C. more than $1,080 but less than $1,145
D. more than $1,145 but less than $1,210
E. more than $1,210

Solutions

Expert Solution

Bradley :

The number of months is calculated using the NPER function in Excel with these inputs :

rate = 4.38% / 12 (annual rate converted into monthly rate)

pmt = -575 (monthly payment. this is entered as a negative number as it is a cash outflow)

pv = 72,500 (loan amount. this is entered as a positive number as the loan taken is a cash inflow)

NPER is calculated to be 169.24. Rounding off, 169 months is the time taken to repay the loan

Chandler :

Price of home after 15 years = $245,000 * (1 + 2.25%)¹⁵ = $342,070.67

The amount of monthly deposit to invest is calculated using the PMT function in Excel with these inputs :

rate = 6.96% / 12 (annual rate converted into monthly rate)

nper = 15 * 12 (15 years , with 12 monthly investments each year)

pv = 0 (savings at the beginning of the 15-year period is zero)

fv = 342,070.67 (the amount required at the end of 15 years to buy the home)

PMT is calculated to be $1,082.97.

The monthly investment required is $1,082.97. The answer is C

jeff jeffy answered 6 months ago

Next > < Previous

Related Solutions

Not surprisingly, Tarek still has several thousand dollars in student loans outstanding. When he graduated from...

Not surprisingly, Tarek still has several thousand dollars in student loans outstanding. When he graduated from college, he had federal loans of $48,100, with an average APR of 5.40%. Six months after graduation, he started making payments using the standard repayment plan. How much is his monthly payment? If all his student loans were subsidized and if he wants to minimize his monthly payment to increase his financial flexibility, what repayment schedule would be best for Tarek? What will be...

While Andy was a student at Albury University, he borrowed $25,000 in student loan at an...

While Andy was a student at Albury University, he borrowed $25,000 in student loan at an annual interest rate of 7%. If he repays $2,000 per year, calculate the period required (to the nearest year) to pay off his debt.

The probability that a student graduating from West Texas A&M University has student loans to pay...

The probability that a student graduating from West Texas A&M University has student loans to pay off after graduation is 0.60. If two students are randomly selected from this university, what is the probability (rounded to the nearest two decimal places) that neither of them has student loans to pay off after graduation? The following table gives the frequency distribution of the number of telephones owned by a sample of 50 households selected from a city. Number of Telephones Owned ...

Beth, a newlywed, just graduated from university as a Registered Nurse. She was just hired by...

Beth, a newlywed, just graduated from university as a Registered Nurse. She was just hired by a large hospital in Toronto that employs over 500 workers. She is hired at a rate of $40 per hour and has a probationary period of one-year. When she was hired, her employment offer was to get a minimum of 32 hours per week, but depending on the hospitals needs, may be up to 60 hours per week. Because of COVID-19, the hospital demands...

Travis Daniels has just graduated from Matchbook State University and is deciding whether to pursue his...

Travis Daniels has just graduated from Matchbook State University and is deciding whether to pursue his master's degree. Travis is now 20 years old. He has just been offered a job with Schmultz, Inc. at an annual salary of $45,000 with anticipated annual increases (for inflation), of 3%. Travis anticipates working only through to his planned retirement, on his 65th birthday. Were Travis to defer the job acceptance and attend graduate school at Matchbook State, the tuition would cost $45,000 annually...

Assume you just graduated from a university with an MBA and were hired by a small...

Assume you just graduated from a university with an MBA and were hired by a small American company generating 100% of its $20 million revenue from domestic sales. Your job as International Sales Director is quite simple: to make sure international sales generate as much revenue as domestic sales within five years. Where do you start? What are some of your first initiatives? Why?

You have just graduated from the MBA program of a large university, and one of your...

You have just graduated from the MBA program of a large university, and one of your favorite courses was “Today’s Entrepreneurs.” In fact, you enjoyed it so much you have decided you want to “be your own boss.” While you were in the master’s program, your grandfather died and left you $1 million to do with as you please. You are not an inventor and you do not have a trade skill that you can market; however, you have decided...

You have just graduated from the MBA program of a large university, and one of your...

You have just graduated from the MBA program of a large university, and one of your favorite courses was Today’s Entrepreneurs. In fact, you enjoyed it so much you have decided you want to “be your own boss.” While you were in the master’s program, your grandfather died and left you $1 million to do with as you please. You are not an inventor, and you do not have a trade skill that you can market; however, you have decided...

You have just graduated from the MBA program of a large university, and one of your...

You have just graduated from the MBA program of a large university, and one of your favorite courses was “Today’s Entrepreneurs.” In fact, you enjoyed it so much you have decided you want to “be your own boss.” While you were in the master’s program, your grandfather died and left you $1.5 million to do with as you please. You are not an inventor, and you do not have a trade skill that you can market; however, you have decided...

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...

Subjects