Suppose Robert obtained a home mortgage loan from Wells Fargo Bank on September 1, 2018. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose Robert obtained a home mortgage loan from Wells Fargo Bank on September 1, 2018. The loan information is as follows: Loan amount: $350,000 Interest rate (p.a.): 4.86% Loan term: 30 years (paid monthly) Start date: September 1, 2018 First payment date: October 1, 2018. (1) Construct the amortization schedule for this mortgage loan. Please make sure you show the monthly payment, the proportion of interest and principal paid, and the ending balance for each scheduled payment date. (8 points) (2) Without considering the time value of money, estimate the total interests that will be over 30-year loan term. (4 points) (3) Sensitivity analysis: Examine the same 30-year $350,000 mortgage loan. If the mortgage rate per year were 3.00%, 3.50%, 4.00%, 4.50%, 5.00%, 5.50%, 6.00%, 6.50%, and 7.00%, what would be (i) the monthly mortgage payment and (ii) the total interest payments? Please construct a data table to answer the question. (6 points) (4) Draw a chart to show Robert's monthly loan payment, monthly interest payment, monthly principal repayment (3 curves) in one chart. Briefly explain their relationship. (7 points) Suppose Robert obtained a home mortgage loan from Wells Fargo Bank on September 1, 2018. The loan information is as follows: Loan amount: $350,000 Interest rate (p.a.): 4.86% Loan term: 30 years (paid monthly) Start date: September 1, 2018 First payment date: October 1, 2018. (1) Construct the amortization schedule for this mortgage loan. Please make sure you show the monthly payment, the proportion of interest and principal paid, and the ending balance for each scheduled payment date. (8 points) (2) Without considering the time value of money, estimate the total interests that will be over 30-year loan term. (4 points) (3) Sensitivity analysis: Examine the same 30-year $350,000 mortgage loan. If the mortgage rate per year were 3.00%, 3.50%, 4.00%, 4.50%, 5.00%, 5.50%, 6.00%, 6.50%, and 7.00%, what would be (i) the monthly mortgage payment and (ii) the total interest payments? Please construct a data table to answer the question. (6 points) (4) Draw a chart to show Robert's monthly loan payment, monthly interest payment, monthly principal repayment (3 curves) in one chart. Briefly explain their relationship. (7 points)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
You have applied for a job with a local bank. As part of its evaluation process, you must take an examination on time value of money analysis covering the following questions: a. Draw time lines for...
-
Name: 9. 11. Bell: Directions: Evaluate each expression using the order of operations. 1. 17-5-4+2 2. 40-32+8+5--2 Date: 5. 2018-(5+3)+7] 3.35-14+2+8 7.1+(-2-5)+(14-17)-4 25 +8+3 4+3 Unit 1: Algebra...
-
A cylinder with a movable piston contains 3.00 mol of N2 gas (assumed to he have like an ideal gas). (a) The N2 is heated at constant volume until 1557 J of heat have been added. Calculate the change...
-
SkyChefs, Inc., prepares in-flight meals for a number of major airlines. One of the companys products is grilled salmon in dill sauce with baby new potatoes and spring vegetables. During the most...
-
Master Suites Hotels includes the following selected accounts in its general ledger at December 31,2008 : Prepare the liabilities section of Master Suites' balance sheet at December 31, 2008, to show...
-
(a) Use vector components to prove that two vectors commute for both addition and the scalar product. (b) Prove that two vectors anticommute for the vector product; that is, prove that A x B= -B x A.
-
1. [25p] An amortized loan of $75,000 has annual payments for eighteen years, the first occurring exactly one year after the loan is made. The first four payments will be for only half as much as the...
-
Computer Project Exercises In developing the exercises, trade-offs had to be made to enrich the learning experience. One of the major problems students initially encounter is data and detail...
-
You will need to download Assignment Question file (this file) and data file to complete your assignment. All numerical calculations and graphs/plots should be done using EXCEL as much as possible. ...
-
What are the pros and cons of modeling the current process?
-
Define an agenda for the executive workshop and the purpose and outcomes from each agenda item.
-
What is unique about the Innovate phase?
-
What are typical agenda items in an Understand workshop?
-
What is the purpose of the team completing the initial stakeholder interviews?
-
Suppose you currently have $2,000 and plan to purchase a 3-year certificate of deposit (CD) that pays 4% interest compounded annually. How much will you have when the CD matures? How would your...
-
(a) Given a mean free path = 0.4 nm and a mean speed vav = 1.17 105 m/s for the current flow in copper at a temperature of 300 K, calculate the classical value for the resistivity of copper. (b)...
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family. Ivan and Irene have the following investment income, in addition to that reported in Chapter 1: Dividends...
-
Marty is a sales consultant. Marty incurs the following expenses related to entertainment of his clients in 2012: Dues to a country club......................................................$4,500...
-
Consider the stepped shaft made of the same material of density \(ho\) and modulus \(E\), shown in Figure 7.45. Determine the characteristic equation for the natural frequencies of the system as it...
-
Consider the uniform beam shown in Figure 7.46. Solve for the lowest natural frequency of axial motion of the steel beam given the following parameter values: \(E=210 \mathrm{GN} / \mathrm{m}^{2},...
-
Consider the longitudinally vibrating uniform beam shown in Figure 7.48. One end of the beam is fixed and the other end is free with an attached concentrated mass \(M\). Derive the frequency...
Study smarter with the SolutionInn App