Essay 5 Instructions

.docx
School
Hampton University **We aren't endorsed by this school
Course
ART MISC
Subject
Accounting
Date
Nov 5, 2023
Pages
4
Uploaded by Genius2000 on coursehero.com
Essay5 Instructions: This assignment is due on Tuesday November 7 at 11:59 PM. Essay 5 involves a real-life scenario comparing the terms of mortgage loans. Read the file Finance posted in the Module Financial Mathematics on the Canvas page for the course paying special attention to the section on Mortgages. 1. Find an actual house listing in the Las Cruces area using a real estate locator service on the internet (e.g. Trulia or Zillow). Include a link to the listing that includes its sale price. The link is https://www.zillow.com/homedetails/3407-Mercury-Ln-Las-Cruces-NM-88012/51481103_zpid/ 2. Assuming that a down payment of 20% is made, determine the amount necessary to borrow to purchase this house. 3. Research two banks in the area that offer mortgage loans. Identify the banks and list the rates (APR) that they offer for fixed rate mortgage loans with 30-year duration and with 15-year duration. If they also require an origination fee, given as a percentage of the amount borrowed, list that also. Make sure that the terms of the loans from the two institutions are different. 4. As in the file Finance page 13, list the components of a mortgage loan and give them variable names, assuming that equal monthly payments are made. 5. Using the variables above, write the equation relating them that enables the determination of the equal monthly payment. 6. For each of the two banks you researched for part 1, determine the equal monthly payment for each of the four mortgages you found, i.e. for each of the two banks, find the , monthly payment for a 15 year mortgage and a 30 year mortgage at the interest rates they offer. If you can get access to a calculator and use it for that purpose, do that. If not, contact me before 10 AM on
Monday, November 6 with your data and I will help with the necessary calculations. You can contact me by email to set up a zoom conference if you would like. 7. For each of the 4 loan options, determine the total amount to be paid to the bank and how much interest will have been paid. If any of your options includes an origination fee, this is given as a percentage of the amount borrowed and is simply added on to the amount paid to the bank. For instance, if the amount borrowed is $200,000 and the origination fee is 1.5% (sometimes referred to 1.5 points) then .015x$200,000—$3,000 is added to the amount paid to the bank. 8. Write a couple of sentences explaining which option you think is best for you. Extra Credit For 1 point of extra credit, determine how much the duration of your chosen mortgage is reduced if $400 is added to the monthly payment. You can estimate this, use a calculator with logarithms, or set up the relevant equation and contact me for help. What to use for calculations (what I have calculated) 1. Zillow has 46 photos of this $285000 3 beds, 2 baths, 1506 Square Feet single family home located at 3407 Mercury Ln, Las Cruces, NM 88012 built in 1977. The sale price is $285,000 2. Downpayment of 20% is $57,000. The amount needed to borrow or purchase this house would be $280,000 - $57,000 = $228,000. Borrowed is $228,000. 3.
Wells fargo APR fixed rate mortgage loan 30 years at 7.84% or 15 year at 7.74% 180 months duration Pioneer bank APR fixed rate mortgage loan 30 year at 8.023% per year or 0.6686% per month duration of 360 months. 15 year at 7.075% per year or 0.5896% per month 180 months duration. Original fee 30 years = $3000 Pioneer bank 30 years $1673.40 monthly payment 360 monthly payments origination fee $3000. Wells fargo 30 year monthly interest rate 7.84% monthly payment $1590.62 for 360 months. 15 year monthly payment $2,196.21 for 180 months Use the formula A (1 + (r/12))^12t = P(((r/12)^12t)-1) / ((r/12)) Extra credit Where: A = $228,000 (principal amount from the initial instructions) r = 0.00653 (monthly interest rate)
Page1of 4
Uploaded by Genius2000 on coursehero.com