Law school after graduation

Assignment Help Operation Management

Reference no: EM132097282

USE EXCEL

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 should 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: EM132097282

Questions Cloud

Role of metrics and measurement in the strategy process : What is the role of metrics and measurement in the strategy process? Why are they so important to the strategy process?

Strategic cost management and contract management : What are the salient characteristics of strategic cost management and contract management?

Particular reference to the roles of organized medicine : Discuss, with particular reference to the roles of (a) organized medicine, (b) the middle class, and (c) American beliefs and values,

Explain how brand loyalty has relaxed your standards : Explain how brand loyalty has relaxed your standards when it comes to claim-belief discrepancy.

Law school after graduation : You have decided that you will go to law school after graduation, which will be a 3-year program.

Purchased brand new batmobile : Batman and Superman were going to meet for dinner at The Riddler’s Italian Restaurant. Batman was very excited because he just purchased a brand new Batmobile.

What inference processes are you assuming : Find an ad that you feel might mislead consumers through a claim-belief discrepancy. What inference processes are you assuming?

Discuss the three tiers process of strategic management : Discuss the three tiers process of strategic management and the responsibilities at each tier and give examples.

What is treasure trove : What is a treasure trove? Please also find an article dealing with lost treasures.

User Account

All Pages