Consider the following scenario: John buys a house for $ 150,000 and takes out a five year adjustable rate mortgage with a beginning rate of 6%. He makes annual payments rather than monthly payments.

Unfortunately for John, interest rates go up by 1% for each of the five years of his loan (Year 1 is 6%, Year 2 is 7%, Year 3 is 8%, Year 4 is 9%, Year 5 is 10%).

Calculate the amount of John’s payment over the life of his loan. Compare these findings if he would have taken out a fix rate loan for the same period at 7.5%. Which do you think is the better deal?

ok that is my assignment.. Any one know what excel formulas i could use. My reading material is not detailed enough for my to perform this byhand.

Related Posts

Why not allow the government to Clinton in the mortgage business going?

Alternative Freddie Mac is one of the largest mortgage lenders in the world. "Freddie Mac, one of the government institutions concerned with the welfare of First Instance in purchase mortgages, ...

READ MORE

I’m a Loan Officer in Orange County California. Any ideas on how to better promote my business?

I work hard to get my clients the best mortgage loans that best fit their needs. I've been having trouble however promiting myself to other real estate agents or home ...

READ MORE

my employer is a business development company/mortgage however…?

Im confused he puts an ad in the paper for mortgage processors and loan officers,but when you come to the office he hires you, then helps set up your own ...

READ MORE

Where can find a grant? to start a business?

Oh men, i studied the latest and hottest business trend in the market...the altimate affiliate marketing....using google adwords. The only problem i have is no capital to lunch a massive ...

READ MORE

I need information on how to obtain a business loan?

My wife and I are both employed full-time. We own a home that has a mortgage of $ 278,000. Our credit is not so good due to the current ...

READ MORE

Business can still get a small business loan today?

The truth is that 99 percent of the health of large banks. According to Jack Palmer News for Crescent, "the vast majority of U.S. banks are well capitalized and operate ...

READ MORE

What are the effects of outstanding business loans on my home mortgage application?

I have debt from my old business and now I am a student. However we deligently paying monthly minimum payment. To purchase a home I am willing to put ...

READ MORE

Do I have any chance of getting a business loan?

My husband and I are thinking about purchasing a small business. We have no business experience. Our only major debt at this time is a mortgage on our home. I ...

READ MORE

Do business loans show on your credit report or keep you from obtaining a mortgage loan?

READ MORE

What catchy slogans are there for the Mortgage Home Loan Business?

I have a Mortgage loan office in Miami, what additional business can I incorporate to my office to help me out with the rent?

READ MORE

Why not allow the government to Clinton in

I’m a Loan Officer in Orange County California.

my employer is a business development company/mortgage however…?

Where can find a grant? to start a

I need information on how to obtain a

Business can still get a small business loan

What are the effects of outstanding business loans

Do I have any chance of getting a

Do business loans show on your credit report

What catchy slogans are there for the Mortgage