Assume that a family is purchasing a typical house by making a $30,000 down payment and then financing a $280,000 mortgage at an annual interest rate

  1. Assume that a family is purchasing a typical house by making a $30,000 down payment and then financing a $280,000 mortgage at an annual interest rate of 6.25% (a typical rate for a 30-year loan). The size of their monthly payment will depend on the term of the mortgage.

The formula or the Excel function “pmt” can be used to compute these monthly mortgage payments. If using Excel the 3 arguments of function “pmt” are:

Rate (the monthly interest rate):   0.0625/12

Nper (the total number of monthly payments) and

Pv (the mortgage amount)

  1. Find the monthly payments if the $280,000 was financed over 15 years.
  2. Find the monthly payments if the $280,000 was financed over 30 years.
  3. Multiply your answer to part (a) by the number of payments to find how much the family would need to pay in total over the life of the 15-year loan. Subtract the principal amount from this to give the amount of interest paid over the life of the loan.
  4. Multiply your answer to part (b) by the number of payments to find how much the family would need to pay in total over the life of the 30-year loan. Subtract the principal amount from this to give the amount of interest paid over the life of the loan.
  5. A standard rule for lenders is that a family’s house payment should not exceed 28% of their monthly income. For a family making $6500 per month, this would equate to $1820 per month. Assuming monthly costs of $350 for property tax and homeowner’s insurance, this would allow for a $1470 monthly mortgage payment.

The formula  or the Excel function “pv” can be used to compute the mortgage a family could afford.  If using Excel the 3 arguments of function “pv” are:

Rate (the monthly interest rate):   0.0625/12

Nper (the total number of monthly payments) and

Pmt (the monthly mortgage amount)

  1. Assuming that a family wants to make a $1470 monthly payment, give the mortgage that a family could afford at an annual interest rate 6.25% for a 15-year mortgage.
  2. Assuming that a family wants to make a $1470 monthly payment, give the mortgage that a family could afford at an annual interest rate 6.25% for a 30-year mortgage.
  3. Based on your answers to questions 1 and 2, what is the advantage of having a 15-year mortgage, and what is the advantage of having a 30-year mortgage? Which option do you think is wiser? 
  4. Proverbs 22:7 says, “The rich rules over the poor, and the borrower is the slave of the lender.” In light of this verse, and the Bible’s more general teaching on debt, many Christians have counseled that incurring excessive debt is undesirable. As financial expert Dave Ramsey puts it: “If you must take out a mortgage, pretend only 15-year mortgages exist.” Discuss how you would apply the Bible’s warning about borrowing when deciding how to go about purchasing a home. Does the Bible prohibit any kind of borrowing? Does it influence which type of mortgage is more attractive? Or does it not really apply to this type of loan?

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

1Title Student name Faculty name Due dateQuestion 1 Minimum: 2.71

1 Title Student name Faculty name Due date Question 1 Minimum: 2.71 Maximum: 4.25 Question 2 Quartile 1: 3.435 Quartile 2: 3.59 Quartile 3: 3.84 Question 3 Sample mean: 3.58 Median: 3.5900 Standard deviation: 0.310135 Question 4 Confidence Interval Lower Limit: 3.46653 Confidence Interval Upper Limit: 3.6981 Question 5 Null

Need help with finding correlation coefficient. COMPETENCY ASSESSMENT Introduction Assessment Rubric and Minimum Submission RequirementsThis

Need help with finding correlation coefficient.  COMPETENCY ASSESSMENT Introduction Assessment Rubric and Minimum Submission Requirements This competency assessment assesses the following Outcome(s): MM207M3: Determine the relationship between two variables. GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English. It is time to demonstrate what you have

MUST HAVE/ BE FAMILIAR WITH THE SPSS STATISTICS SOFTWARE PROGRAM!!!!!!!PADM 810Quantitative Analysis Report: Structure of

MUST HAVE/ BE FAMILIAR WITH THE SPSS STATISTICS SOFTWARE PROGRAM!!!!!!! PADM 810 Quantitative Analysis Report: Structure of Assignments 1. Use the following structure for your research article: Abstract, Introduction, Literature Review/Theory, Methods, Results, Discussion, and Conclusion. Include a robust discussion section distinct from your conclusion. 2. Give your article a