Ten years ago reem and forsan took out a 150000 mortgage to, Ask an Expert

Finance

Ten years ago Reem and Forsan took out a $150,000 mortgage to buy their new house. The mortgage was a 20-year, 10% mortgage with annual payments. Today their bank offers similar mortgages at 8% interest; however, when the young couple went to the bank to inquire about the possibility of refinancing the remainder of their mortgage with a 10-year, 8% mortgage, they were informed that the bank has a $15,000 “exit fee” for the refinancing.

Should they still refinance the mortgage? (Answer: No. The EAR for the new mortgage is 10.98%.)

We offer some hints:

• The remaining mortgage principal at any point is the present value of the future payments on the mortgage. Further hint: Use Excel’s PV function.

• Excel’s Rate function can compute the IRRs of fixed payment loans.

Please show how to do it in Excel and any formulas used.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92664310

Have any Question?Write your Review or question?

Related Questions in Financial Management

As you have read and researched web analytics is used

As you have read and researched, web analytics is used extensively in higher education. Continue to research and source at least 5 different ways how web analytics is used by higher education institutions. You must provi ...

Question spirituality is a fundamental and universal

Question : Spirituality is a fundamental and universal aspect of human existence and is a critical component in working with clients, groups, communities, etc. There is a vast diversity in spiritual beliefs and religious ...

Objectivedemonstrate the ability to perform financial

OBJECTIVE Demonstrate the ability to perform financial calculations and analysis related to the concepts covered in this course. PURPOSE The purpose of this project is to give you practical experi- ence with financial co ...

International financial management assignment -this

International Financial Management Assignment - This assignment consists of two parts, Part A and Part B. PART A - Assignment Question - As a recent graduate of Afin 867 you have been lucky enough to be offered a consult ...

The investment logic for sustainabilitywatch the investment

The Investment Logic for Sustainability Watch the Investment Logic for Sustainability video. Then perform a few internet searches on terms such as the following: Sustainable funds Socially responsible investing ESG Envir ...

Assignment -complete a research topic and prepare a

Assignment - Complete a research topic and prepare a write-up, and a presentation. SECTION A: Financial Analysis and Pricing Select a portfolio of five firms from the industry of your choice. Please then see me for appro ...

Assignment1research online to find 3 articles from news or

Assignment 1. Research online to find 3 articles from news or professional business publications that talk about the improv - business connection. Your search may extend to include the connection of improv &:education, a ...

Assignmentimagine you are the owner of a small business in

Assignment Imagine you are the owner of a small business in your hometown. Briefly describe your company in 3 to 5 sentences. Discuss the following in 525 to 700 words: Define the roles you play as a small business owner ...

Please use referencescase home healthbackgroundthe patient

Please use references, Case : Home HealthBACKGROUND The Patient Protection and Affordable Care Act (ACA) requires that physicians (or certain practitioners working with them) who certify beneficiaries as eligible for Med ...

Exercise benefits us in so many ways including improving

Exercise benefits us in so many ways, including: improving our physical and mental health; reducing our risk of cardiovascular disease; increasing our energy, stamina, strength, and agility; promoting better sleep; impro ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert