Order for purchasing three points to make financial sense

Assignment Help Financial Management

Reference no: EM132011091

Your friend is looking to purchase a house. He has picked out the house, but will need to borrow $300,000 in order to complete the purchase. He has asked you for help in navigating the different loan options.

What would be the monthly payment on a 15-year fixed rate loan with an interest rate of 2.625%?

What would be the monthly payment on a 30-year fixed rate loan with an interest rate of 3.125%?

He wants to pay the loan off in 30 years, so he will choose the 30-year fixed rate loan from above. He is trying to decide if he should buy points. What would his monthly payment be if he purchased three points?

If he buys the points (as described in c. above), what is the NPV? Assume that he stays in the house and keeps the loan for the entire 30 years.

What is the NPV if he only stays in the house for 3 years?

What is the breakeven amount of time (in months) that he would need to keep the loan in order for purchasing three points to make financial sense? (Use Solver or Goalseek in Excel, and don’t forget to account for the difference in loan balance at the end of the breakeven amount of time)

Reference no: EM132011091

Questions Cloud

Calculate the portfolio expected return : Calculate the portfolio expected return. Calculate the standard deviation of the portfolio.

What is one benefit of eating a lunch rich in vitamin d : What is one benefit of eating a lunch rich in Vitamin D and what can you do to ensure you are getting the daily recommended intake of Vitamin D?

Establish a simple hardware asset list for the company : Establish a simple hardware asset list for this company and classify those assets as tier 1,2 or 3 assets. Develop a list of software needed to restore.

Prepare the journal entries from Aug to June : On 15 June 2014 the forfeited shares were reissued to a new shareholder fully paid to $1.80. Prepare the journal entries from 1 Aug 2013 to 20 June 2014

Order for purchasing three points to make financial sense : What is the breakeven amount of time (in months) that he would need to keep the loan in order for purchasing three points to make financial sense?

Reliability of a screening test : Describe how you would investigate the reliability of a screening test and how you would test for both inter-observer and intra-observer variation.

Disorders of cardiac function : Martha had just finished dinner with her husband, and they had just sat down to watch television. She is 72 years old and has had a history of angina.

Discusses current issues regarding hipaa : Find an article that discusses current issues regarding HIPAA, SOX or other regulations that IT departments need to be aware of in regards to setting user.

Important component of a healthy diet : Why is potassium intake an important component of a healthy diet and what can you do to ensure you are getting the daily recommended intake of potassium?

User Account

All Pages