Set up the monthly loan payments

Assignment Help Financial Management

Reference no: EM131848180

You have decided that you will go to law school after graduation, which will be a 3-year program. You want to borrow enough money to cover all 3 years of law school (tuition, books, lodging, food, etc.), which you estimate to be $145,000. You go to the bank, and work out a plan for a loan with a customized repayment option since you will not be earning money for the next 3 years while in school. The bank will let you borrow $145,000 now, and you can pay it back over the next 20 years (240 months) according to the following plan:

For the next 3 years (month 1 to month 36), since you’ll be in graduate school, you will make

a smaller monthly payment, which we’ll call X.

After that, since you’ll have a job, you will pay 5X from month 37 through month 84.

After month 84 you anticipate that you can afford to increase your payment, so from month 85 through 240, you will pay 12X each month. After your last payment in month 240, the loan will be completely paid off.

The monthly interest rate is 0.55%

Find X. (Hint: you will need to use Solver of Goal Seek for this. Set up the monthly loan payments, but be careful to take the customized repayment plan into account.)

Reference no: EM131848180

Questions Cloud

Bond with annual coupon payments : Consider a 26-year bond with 9 percent annual coupon payments. The market rate (YTM) is 7.2 percent for this bond.

One of the criticisms against china : As discussed in class, one of the criticisms against China is that it deliberately keeps its currency value low against the U.S. and other developed nations,

Intel spreads huge fixed costs of developing new generation : Intel spreads the huge fixed costs of developing new generation chips over the nearly 2 billion chips it sells to computer makers. Intel benefits from

Raise by the time of the first payment : how much money do the officers have to raise by the time of the first payment?

Set up the monthly loan payments : you will need to use Solver of Goal Seek for this. Set up the monthly loan payments, but be careful to take the customized repayment plan into account

Cellular service provider gives customers free cell phone : A cellular service provider gives customers a “free” cell phone if they sign a two-year service contract. You are a state tax auditor.

What is the price of the bond : If the market demands 8.1 percent required rate on the bond, what is the price of the bond?

Coupon bond is callable in ten years for call premium : A 4.8 percent corporate coupon bond is callable in ten years for a call premium of one year of coupon payments.

What is your rate of return on one-year investment : What is your rate of return on a 1-year investment in ABC Bonds if they are downgraded at the end of the year?

User Account

All Pages