Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

Quantative reasoning

  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

Order Now

Related Questions

ANOVA

I need assistance in understanding the statistical formula ANOVA Overview For this week’s assignment you will read a published research study that uses some form of an analysis of variance (ANOVA) and you will examine a graduate program or job posting in the social sciences that uses statistics. Preparation Before

MUST USE EXCEL PLEASE READ AND VIEW ALL BEFORE ACCEPTING

Congratulations! An investor believes in you and your ideas! Not only are they committed to providing you with a generous investment of $10,000, but they’re also offering you a spacious 20×20 office space to establish your business. Moreover, you can breathe easy knowing that the investor has graciously taken upon

Statistics

I need assistance in understanding statistical formats. manifest.json { “jaspArchiveVersion” : “5”, “jaspVersion” : “0.95.1” } analyses.json { “analyses” : [], “meta” : null } index.html Results internal.sqlite

M1

math work needs done. have 50 questions to complete and work has to be shown. file will be added after

Descriptive Statistics

Need help understanding descriptive statistics manifest.json { “jaspArchiveVersion” : “5”, “jaspVersion” : “0.19.3” } analyses.json { “analyses” : [], “meta” : null } index.html Results internal.sqlite

HW11

See attached  This file is too large to display.View in new window

MATHHHH

Forum 4 (Week 5): Fibonacci Sequence (CA Group) The Fibonacci sequence is a famous list of numbers which appears in literature on such diverse topics as art, music, stock market investing techniques, and even The Da Vinci Code. Many see God’s design in nature centered around this sequence of numbers.

Statistic

I need help understanding JASP manifest.json { “jaspArchiveVersion” : “5”, “jaspVersion” : “0.19.3” } analyses.json { “analyses” : [], “meta” : null } index.html Results internal.sqlite

MathW5

Using Excel to Calculate Normal Distribution Areas, Z Scores, and Normal Quantile Plot In this week’s lesson, we will be learning how to use Excel to calculate normal distribution areas, z scores, and normal quantile plot. Resources to consult: See the videos marked 6-1, 6-5  Triola Stats Excel Videos  Assignment

math problem

Let’s have fun with graphs! If possible, sketch a graph of a polynomial that satisfies the following conditions for each of the three problems below. Let “a” be the leading coefficient. If the graph is not possible, say “not possible” and carefully explain why. You must upload a file with

Critical Review

See attached  Critical Review of Published Article  Mastery of statistics involves not only the ability to generate sound statistical results, but also the ability to critically evaluate the statistical analysis of others.  This is the focus of this assignment.  A critique is not a summary or a simple retelling of

Statistic Worksheet Help

Need help understanding the fundamentals of statistics. Overview For this week’s assignment, you’ll apply some of the research methods you read about in Chapters 1 and 2 by analyzing a scenario. You’ll also explore how statistics are used in various fields. Preparation Before you begin this assignment, complete the following:

Math W4

Using Excel to Determine Probabilities for Binomial Distributions In this week’s assignment, we will learn how to use Excel to calculate probabilities for a binomial distribution. · The resource to consult: Section 4.3 Binomial Distribution. · Resource to consult: Section 5-2  Triola Stats.com es13 excel videos  View video and then

STATISTICSwk4

2 By now you are adept at calculating averages and intuitively can estimate whether something is “normal” (a measurement not too far from average) or unusual (pretty far from the average you might expect). This class helps to quantify exactly how far something you measure is from average using the

Mathematical Statistics W3

Using Excel to Calculate Factorials, Permutations, and Combinations In this week’s assignment, we will learn how to use Excel to calculate factorials, permutations and combinations. A resource to Section 4-4 of  Stats Video Collection  Assignment View the video and then complete the following tasks in a blank Excel worksheet.  4-4

MATHHH

Forum 2 (Week 2): Historical Mathematician (CA Group) Choose one Historical Mathematician and discuss the contributions of that man or woman. You could choose to consider: ways in which this person changed the world through mathematics, particular challenges that they faced, ways in which faith and religion impacted his/her life