What would be the monthly mo mortgage payment and the total


Suppose you obtain a home mortgage loan from Wells Fargo Bank. The loan information is as follows: Loan amount: $425,000 Interest rate (p.a.): 3.75% Loan term: 30 years (paid monthly) Start date (of financial payment): May 1, 2017 (1) Construct the amortization schedule for this mortgage loan. Please make sure you show the monthly payment, the pr oportion of interest and princi pal paid, and the ending balance for each scheduled paymen t date. You need to build the amortization table using two methods discussed in class: (6 points) (i) Determine the amounts from t he relationship between the pay ments and balance; (ii) Compute the payments/balanc e with the formulae listed on p ages 234-235 in the textbook. (2) Without considering the time value of money, estimate the t otal interests paid during 30 years. (1 points) (3) Sensitivity analysis: Exami ne the same 30 year $425,000 mor tgage loan. If the mortgage rate per year were 2.50 %, 2.75%, 3.00%, 3.25%, 3.50%, 3.75%, 4.00%, 4.25%, 4.50%, 4.75%, or 5.00%, what would be (i) the monthly mortgage payment and (ii) the total interest payments? Please construct a data table to answer the question.

Request for Solution File

Ask an Expert for Answer!!
Financial Management: What would be the monthly mo mortgage payment and the total
Reference No:- TGS02331114

Expected delivery within 24 Hours