1 answer

This assignment is a little different than the other assignments, because this one is fairly computational....

Question:

This assignment is a little different than the other assignments, because this one is fairly computational. This assignment is one big question with 13 parts – each part builds on the previous part. The assignment is set up so you can see the previous and later parts of the assignment, but can submit one part at a time.

  1. [2 points] Suppose that 15 years ago you bought a home for $500,000, paying 20% as a down payment, and financing the rest at 5% interest for 30 years. How much money did you pay as your down payment?
  2. [2 points] How much money was your existing mortgage (loan) for?
  3. [2 points] What is your current monthly payment on your existing mortgage? Note: Carry at least 4 decimal places during calculations, but round your final answer to the nearest cent.
  4. [2 points] How much total interest will you pay over the life of the existing loan?
  5. [2 points] This year (15 years after you first took out the loan), you check your loan balance. Only part of your payments have been going to pay down the loan; the rest has been going towards interest. You see that you still have $271,536 left to pay on your loan. Your house is now valued at $650,000. How much of the original loan have you paid off? (i.e, how much have you reduced the loan balance by?
  6. [2 points] How much money have you paid to the loan company so far (over the last 15 years)?
  7. [2 points] How much interest have you paid so far (over the last 15 years)?
  8. [2 points] How much equity do you have in your home (equity is value minus remaining debt)?
  9. [2 points] Since interest rates have dropped, you consider refinancing your mortgage at a lower 3% rate. If you took out a new 30 year mortgage at3% for your remaining loan balance, what would your new monthly payments be?
  10. [2 points] How much interest will you pay over the life of the new loan?
  11. [2 points] Notice that if you refinance, you are going to be making payments on your home for another 30 years. In addition to the 15 years you’ve already been paying, that’s 45 years total. How much will you save each month because of the lower monthly payment?
  12. [2 points] How much total interest will you be paying (consider the interest you paid over the first 15 years of your original loan as well as interest on your refinanced loan)?
  13. [1 point] Now the non-computational question: Does it make sense to refinance? (There isn’t a correct answer to this question. Just give your opinion and your reason.)

Answers

1]

Down payment = cost of house * down payment %

Down payment = $500,000 * 20% = $100,000

2]

Mortgage loan amount = cost of house - down payment

Mortgage loan amount = $500,000 - $100,000 = $400,000

3]

Monthly loan payment is calculated using PMT function in Excel :

rate = 5% / 12   (converting annual rate into monthly rate)

nper = 30*12 (30 year loan with 12 monthly payments each year)

pv = 400000 (loan amount)

PMT is calculated to be $2,147.29

А1 f =PMT(5%/12,30*12,400000) : A ($2,147.29)! x B C D E 1

4]

Total interest paid = (monthly payment * total number of payments) - loan amount

Total interest paid = ($2,147.29 * (30*12)) - $400,000

Total interest paid = $373,023.14

.

Similar Solved Questions

1 answer
For the following reaction, 5.40 grams of carbon tetrachloride are mixed with excess methane (CH_4). Assume...
For the following reaction, 5.40 grams of carbon tetrachloride are mixed with excess methane (CH_4). Assume that the percent yield of dichloromethane (CH_2 Cl_2) is 86.4 %. methane (CH_4)(g) + carbon tetrachloride(g)rightarrow dichloromethane (CH_2 Cl_2) What is the theoretical yield of dichlorometh...
1 answer
Have you ever looked at the doctor's perspective in regard to difficult patients? Have your readings...
Have you ever looked at the doctor's perspective in regard to difficult patients? Have your readings convinced you that doctors have as much difficulty with patients as patients have with doctors? Give a detailed response, referring to your readings and viewings. - DO NOT USE SHORT SENTENCES, Wr...
1 answer
Express the function below using window and step functions and compute its Laplace transform. Ag(t) 10-...
Express the function below using window and step functions and compute its Laplace transform. Ag(t) 10- t 0 0 2 4 6 8 10 Click here to view the table of Laplace transforms. Click here to view the table of properties of Laplace transforms. Express g(t) using window and step functions. Choose the corr...
1 answer
A pipe system carries water from a reservoir and discharges it as a free jet, as...
A pipe system carries water from a reservoir and discharges it as a free jet, as shown. The system consists of piping made from 200-mm diameter commercial steel pipe with two 90 deg elbows with Kı=0.4m and an inlet minor loss Kl = 0.05 1) (4 pts) Assuming ideal fluid model within the reservoir,...
1 answer
4) If a vector has components Ay>0, and Ay<0, then the angle that this vector makes...
4) If a vector has components Ay>0, and Ay<0, then the angle that this vector makes with the positivex-axis must be in the range A) 180° to 270° B) 270° to 360° C) 0° to 90° D) 90° to 180° E) cannot be determined without additional information 5) 5) When is the ...
1 answer
Question 7) Astro Consulting had the following trial balance on June 30, 2020: Debit Credit $25,850...
Question 7) Astro Consulting had the following trial balance on June 30, 2020: Debit Credit $25,850 7.000 2.000 2,640 15.000 S 1.000 4,540 5.200 0 Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accum. Depreciation Equip Accounts Payable Uneared Service Revenue Utilities Payable Salari...
1 answer
I want to know how to solve this problem step by step. 31.7.7 Determine if the...
I want to know how to solve this problem step by step. 31.7.7 Determine if the columns of the matrix form a linearly independent set 13 -3 4 273 -1 28 3-19 Select the correct choice below and fill in the answer box to complete your choice 100 50 The columns are not linearly independent because the r...
1 answer
Find the unit rate 400 miles in 5 hours
find the unit rate 400 miles in 5 hours...
1 answer
Figure 158-M5-3.JPG In one experiment you measured the acceleration of a glider that is floating on...
Figure 158-M5-3.JPG In one experiment you measured the acceleration of a glider that is floating on an air track while being pulled by a string routed over a pulley. By measuring the acceleration when the glider is moving towards the pulley and away from the pulley, you were able to determine the fr...
1 answer
QUESTION 1 40 kN ๑30 QUESTION 2 mm. (CLO 1) (3-0 points) The deformation δ./s is...
QUESTION 1 40 kN ๑30 QUESTION 2 mm. (CLO 1) (3-0 points) The deformation δ./s is - 0.530 0 0.038 目-0.053 -0.909 QUESTION 3 The axial load in segment BC iskN. (CLO D (a.o points) 0 40 e 30 70 70 QUESTION 4 mm. (CLO D (3.0 points) The deformation Ssrc is 0.080 -0.126 e 0.020 e-0.101...
1 answer
Styles Examination of the perineum reveals inflamed excoriated tissue from the labia to the rectum. Stool...
Styles Examination of the perineum reveals inflamed excoriated tissue from the labia to the rectum. Stool appears to extrude from the vagina. The excoriation is cleared and the pain is under control with 10mg of morphine q4 hours (6 doses a day). She uses approximately 3 additional doses of 10mg of ...
1 answer
Should you place learners in a clinical setting that has less-than-desirable staff role models? What are...
Should you place learners in a clinical setting that has less-than-desirable staff role models? What are the risks and how can they be mitigated?...
1 answer
How do you simplify #(x^2-4x)/(16-x^2)#?
How do you simplify #(x^2-4x)/(16-x^2)#?...
1 answer
What is the average value of the function #f(x)=18x+8# on the interval #[0,10]#?
What is the average value of the function #f(x)=18x+8# on the interval #[0,10]#?...
1 answer
(a) worked out incorrectly; or (b) worked out correctly but using a method not specified in...
(a) worked out incorrectly; or (b) worked out correctly but using a method not specified in the problem statement; or (c) not solved completely, but the answer is stated with inadequate or no work shown, EVEN IF THE FINAL ANSWER IS CORRECT. 1) Write the first four terms of each sequence. (3 points e...
1 answer
A 25-year-old male service member with blast-induced traumatic brain injury was recently admitted to the ER....
A 25-year-old male service member with blast-induced traumatic brain injury was recently admitted to the ER. This patient suffered from severe fatigue, dehydration, polydipsia, and polyuria. The only abnormal lab value found in the initial screening was a urine specific gravity of 1.002. What disor...
1 answer
Colors Company purchased a piece of machinery for $4,000. The company paid $1,500 at the time...
Colors Company purchased a piece of machinery for $4,000. The company paid $1,500 at the time of the purchase, and agreed to pay the remaining $2,500 one month later. The entry to record this transaction would include which of the following elements? Multiple Choice The Accounts Payable account di...