Many people at some point in life will decide to purchase a home. Most will need...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Many people at some point in life will decide to purchase a home. Most will need to acquire a mortgage for the home purchase. There are several options for mortgages and with so many different choices the mortgage selection process can be confusing. This discussion will focus on how to calculate a monthly payment for a mortgage, the amount of interest over the term of the mortgage, and how to calculate the price of a home a family could afford based on a family budget with a set monthly mortgage payment amount. To offer a glimpse of some aspects of a mortgage this discussion will focus on a fixed-rate mortgage with a 15-and 30-year option. Your discussion thread should include the answers to all four questions below. 1. Assume that a family is purchasing a typical house by making a $30,000 down payment and then financing a $250,000 mortgage at an annual interest rate of 4.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 M = p. (1-(1+7)) nt 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.0425/12 Nper (the total number of monthly payments) and Pv (the mortgage amount) A. Find the monthly payments if the $250,000 was financed over 15 years. B. Find the monthly payments if the $250,000 was financed over 30 years. C. 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. D. 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. 3. A standard rule for lenders is that a family's house payment should not exceed 28% of their monthly income. For a family making $5500 per month, this would equate to $1540 per month. Assuming monthly costs of $250 for property tax and homeowner's insurance, this would allow for a $1290 monthly mortgage payment. The formula M = (2-(15 (solving for P this time) 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.0425/12 Nper (the total number of monthly payments) and Pmt (the monthly mortgage amount) A. Assuming that a family wants to make a $1290 monthly payment, give the mortgage that a family could afford at an annual interest rate 4.25% for a 15-year mortgage. B. Assuming that a family wants to make a $1290 monthly payment, give the mortgage that a family could afford at an annual interest rate 4.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? Many people at some point in life will decide to purchase a home. Most will need to acquire a mortgage for the home purchase. There are several options for mortgages and with so many different choices the mortgage selection process can be confusing. This discussion will focus on how to calculate a monthly payment for a mortgage, the amount of interest over the term of the mortgage, and how to calculate the price of a home a family could afford based on a family budget with a set monthly mortgage payment amount. To offer a glimpse of some aspects of a mortgage this discussion will focus on a fixed-rate mortgage with a 15-and 30-year option. Your discussion thread should include the answers to all four questions below. 1. Assume that a family is purchasing a typical house by making a $30,000 down payment and then financing a $250,000 mortgage at an annual interest rate of 4.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 M = p. (1-(1+7)) nt 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.0425/12 Nper (the total number of monthly payments) and Pv (the mortgage amount) A. Find the monthly payments if the $250,000 was financed over 15 years. B. Find the monthly payments if the $250,000 was financed over 30 years. C. 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. D. 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. 3. A standard rule for lenders is that a family's house payment should not exceed 28% of their monthly income. For a family making $5500 per month, this would equate to $1540 per month. Assuming monthly costs of $250 for property tax and homeowner's insurance, this would allow for a $1290 monthly mortgage payment. The formula M = (2-(15 (solving for P this time) 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.0425/12 Nper (the total number of monthly payments) and Pmt (the monthly mortgage amount) A. Assuming that a family wants to make a $1290 monthly payment, give the mortgage that a family could afford at an annual interest rate 4.25% for a 15-year mortgage. B. Assuming that a family wants to make a $1290 monthly payment, give the mortgage that a family could afford at an annual interest rate 4.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?
Expert Answer:
Answer rating: 100% (QA)
I see that youve presented a multipart question about mortgage calculations and financial decisions related to purchasing a home Lets go through each part step by step For parts 1A and 1B well be usin... View the full answer
Related Book For
Making Hard Decisions with decision tools
ISBN: 978-0538797573
3rd edition
Authors: Robert Clemen, Terence Reilly
Posted Date:
Students also viewed these accounting questions
-
The speed with which consumers decide to purchase a product was investigated in the Journal of Consumer Research (August 2011). The researchers theorized that consumers with last names that begin...
-
At some point in the past, you either bought or wrote an option. The option is near expiration and appears that it will expire in the money. If the option expires in the money, you are obligated to...
-
Portland College is planning to purchase a home for its president in downtown Albuquerque. One property, with a selling price of $780,000, has been found, and the college treasurer is debating on the...
-
Write the acceleration vector a at the point indicated as a sum of tangential and normal components. r(0) = (cos, sin 20), 0 =
-
Distinguish between a fixed-order-quantity system and fixed-time-period system and give an example of each.
-
Write in the product: 2-methyl-3-ethyl-2-hexene 1. 03 2. Zn, HO* ->
-
A marketed asset's price \(x\) is governed by the mean reverting process where \(\eta, \theta\), and \(\sigma\) are positive constants and \(z\) is a Wiener process. (a) Let \(V(x, t)\) be a given...
-
On January 1, 2016, Palo Company acquires 80% of the outstanding common stock of Sheila Company for $700,000. On January 1, 2018, Sheila Company sells 25,000 shares of common stock to the public at...
-
On January 3, 2023, Riverbed Limited purchased 3,900 (39%) of the common shares of Sonja Corp. for $541,300. The following information is provided about the identifiable assets and liabilities of...
-
Blue Angel Investors has a success ratio of 10% with its venture funding. Blue Angel requires a rate of return of 20% for its portfolio of lending, and the average length on its loan is five years....
-
Parent Corp. owns 80% of Sub Corp. and uses the cost method to account for its investment, which it acquired on January 1, 2019. The Financial Statements of Parent Corp. and Sub Corp. for the Year...
-
Two charged objects 1 and 2 are held a distance \(r\) apart. Object 1 has mass \(m\) and charge \(+2 q\), and object 2 has mass \(2 m\) and charge \(+q\). The objects are released from rest. Assume...
-
Sketch the curves using the equations given in Problems 28-51. \(y^{2}-x^{2}=4\)
-
It really does pay to be a CEO of a Fortune 500 firm, according to the AFLCIO. The average S&P 500 chief executive made $13.1 million in 2016, 347 times more than the average U.S. worker did, up from...
-
Your firm is considering the launch of a new product, the XJ5. The upfront development cost is $12 million, and you expect to earn a cash flow of $3.1 million per year for the next five years. Plot...
-
C. Phillips, a sole trader specialising in material for Asian clothing, has the following purchases and sales for March 2017: Mar 1 Bought from Smith Stores: silk 40, cotton 80. All less 25 per cent...
-
What is RAID structure of the OS?
-
Four GWU students have been selected to taste food sold by 3 different food trucks labeled as food truck A, B and C on H & 22nd Streets every Monday for 3-weeks. For each student, food trucks are...
-
When an amateur astronomer considers purchasing or building a telescope to view deep sky objects (galaxies, clusters, nebulae, etc.), the three primary considerations are minimizing cost, having a...
-
Of course, Liedtke is not operating by himself in the Texaco-Pennzoil case; he must report to a board of directors. Table 14.6 gives utility functions for three different directors. Draw graphs of...
-
The point is often made that formal schooling can actually discourage young children from following their natural curiosity. Curiosity is an important element of creativity, and so it may be the case...
-
As wind speed is reduced, what happens to the sediment carried by wind?
-
How are surface processes different from tectonic processes?
-
Why is topsoil essential to conserve and protect? (a) Topsoil holds subsoil in place, preventing landslides. (b) Plants require topsoil to growand plants are vital because they provide food and...
Study smarter with the SolutionInn App