29 Jun Question Assume that your neighbor
Question
Assume that your neighbor took a loan of $300,000 five years ago. At that time, she took a 30-year loan for 5.8%. She now wants to consider re-financing her loan. She went to a bank and was told that re-financing her loan for 30 years would cost her $6,500 upfront and re-financing her loan for 15 years would cost her $5,000 upfront. Your neighbor is low on cash and would prefer to add the upfront fees into her new loan.
Your neighbor comes to seek your help with her mortgage dilemma.
Can you use your Time Value of Money skills to help guide your neighbor if she should go for re-financing? You can guide her in terms of helping her understand her current interest expense versus future interest expense, current PMT versus future PMT, how a 15-year loan versus a 30-year loan would affect her finances, etc. Help her understand by giving her different scenarios so she can make a good decision that suits her best. You can get the current rates from any bank
website by searching under Mortgage Rates.
Provide your work using tables/graphs/explanations. Also, attach a PDF of the website you used to obtain the mortgage rates.
Some hints:
1. You need to prepare your own excel amortization tables to support your explanation and
decision. Entering the numbers in the boxes in different websites and using those to get
your answers cannot be accepted and does not serve the purpose of this extra credit
assignment.
2. You would prepare the 3 amortization tables (current loan, new 15-year loan, and new
30-year loan) using monthly compounding just like how we solve using Chapter 4
Amortization Notes.
3. Also, when calculating the PV for the new 15-year and 30-year loans, note that it will not
be $300,000 because the neighbor has already paid off some part of the loan amount in
the previous 5 years. The PV for the new 15-year and 30-year loans will be balance still
remaining on the current loan after 5 years (obtained from Balance Remaining at the end
of Year 5) plus the upfront fees.
4. You also need to provide a clear explanation of your excel work and provide an analysis
for your findings. Your neighbor may not understand what the different amortization
tables mean and how to read, analyze, and apply them. You need to give your
recommendation under different scenarios for your neighbor in terms of when 15-year
would be preferred or when 30-year would be preferred, etc. For example, compare the
PMT under each option as it will directly affect the liquidity of your neighbor, compare
the total interest amounts under each option. Based on what is important for the neighbor,
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.