Our Services

Get 15% Discount on your First Order

[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

Related Questions

ma

Handout #4 Math 101 Name: _____________________________ Basic Probability & Odds Two dice are rolled. Use the table from our notes to identify the sample space. Then calculate the probability of each event. 1. What is the probability that we roll a sum less than 8? 2. What is the probability

MAT DB V

See attached Unit V Discussion Board Watch  Video 3: The Power of “Yet,”  and evaluate your course progress. Are you meeting your goals for the course? What goals do you have for the remainder of the class? What strategy can you implement to help you achieve those goals? Next, respond

MAT IV JL

See Attached Watch the  video  The Power of Making Mistakes . Describe a situation where you made a mistake in this course. How can you learn from your mistake in order to better understand the course material? What did this mistake teach you? If this was another person describing their

home work

Competency Evaluate hypothesis tests for population parameters from two populations. Project Deliverable tie to Competency  In your fifth assignment, you will continue applying hypothesis testing methods to real-world situations. This assignment will require you to expand your understanding of situations that involve comparing two populations, which is a critical skill

home work

Competency Evaluate hypothesis tests for population parameters from one population. Project Deliverable tie to Competency  In the fourth assignment, you will need to make data-driven decisions by evaluating claims about a single population. You will be tasked with completing several hypothesis tests, which follow a structured process: stating hypotheses, selecting

it is a MATHEMATICS QUESTION

  Three resistors of 2 Ω, 3 Ω and 6 Ω are connected in parallel. This combination is connected in series with a 4 Ω resistor. The whole circuit is connected to a 12 V battery. Find: Total resistance of the circuit   Total current from the battery   Current

home work

Competency Develop a confidence interval for a population parameter. Project Deliverable tie to Competency  In the third assignment, you will construct and interpret confidence intervals, which is a fundamental concept in inferential statistics. By estimating population parameters such as the mean and proportion using sample data, you will gain a

Math

Which inequality is equivalent to –m ≥ 15? CLEAR CHECK m ≥ 15 m ≥ -15 m ≤ -15 m ≤ 15

Home work

Competency Apply the normal distribution, standard normal distribution, and central limit theorem. Project Deliverable tie to Competency  In module 02, you will summarize graphical and numerical methods to represent quantitative data. This includes utilizing the central limit theorem to calculate probabilities for real-world problems. It will also require you to

math 210 wk 9 i need healp

MAT210 – Week 9 Assignment Template Week 9 Assignment Template Making Data Driven Decisions Name:  Case Study:    1. Construct a box-and-whisker plot in Excel for the data set you used in your ALEKS assignment for this week. Paste that below. 1. Evaluate the results of the hypothesis test and

VII Math

See Attached Unit VII Math Journal Throughout this course, you have had access to unit study guides, reference sheets, note-taking guides, instructional videos, and learning aides. Reflect on how you used these resources to help you complete each assignment thus far, and describe how you can use these resources to

mat 210 wk 9

How to construct a box and whisker plot excel? MAT210 – Week 9 Assignment Template Week 9 Assignment Template Making Data Driven Decisions Name:  Case Study:    1. Construct a box-and-whisker plot in Excel for the data set you used in your ALEKS assignment for this week. Paste that below.

mat 210 wk 3

Which scatter plot would be best to use for a study? MAT210 – Week 3 Assignment Template Week 3 Assignment – The Foundation of Data-Driven Decisions Name: [Add your name] Professor Name: [Add your professor’s name] Date: [Add the Date Submitted] Scenario: You would like to determine whether eating before

Unit V DB Math

See attached DB V Math This unit covers different counting methods: the fundamental counting principle, combinations, and permutations. Complete each of the following:   1. Choose one of these topics and explain it to your classmates in your own words. 2. Create an example using the counting method you chose.

MINi PROJECT

2021Fall_IE342_MiniProject2 5 (Instructor: Azadeh Haghighi) Mini Project 2 Directions: In this project, you are going to graphically present, study, analyze and evaluate the distributions of a dataset. Upload your whole package (including any codes, plots, and the report) to the blackboard by the due date. The Data: Collect the size

Compressed Sensing: Das mathematische Wunder, aus Wenigem Alles zu machen

  Das Limit von Nyquist brechen Lange Zeit galt in der Signalverarbeitung ein ehernes Gesetz: das Nyquist-Shannon-Abtasttheorem. Es besagt vereinfacht: Wenn du ein Signal (z.B. Musik oder ein Bild) perfekt aufnehmen willst, musst du es sehr oft messen (abtasten). Wenn du zu wenige Daten hast, verlierst du Information. Doch seit

Dimensional Analysis

Dimensional Analysis is a multi-step conversion process to convert one unit into another. You will use dimensional analysis to create a presentation this week.   Scenario:  A mother has been given a prescription for her child. She fills the prescription at her local pharmacy. When she gets home, she reads