Estimate the total interests paid during 30 years

Assignment Help Financial Management

Reference no: EM132014163

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:

(i) Determine the amounts from the relationship between the pay ments and balance;

(ii) Compute the payments/balance 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.

(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 mo rtgage payment and (ii) the total interest payments? Please construct a data table to answer the question.

Reference no: EM132014163

Questions Cloud

What is the present value of this annuity : The interest and discount rates are 2%/year, compounded annually. What is the present value of this annuity?

Experimental technique to satisfy our scientific curiosity : Besides being an experimental technique to satisfy our scientific curiosity, are there any practical benefits to sublimation?

What form does mercury exist when it is produced : In what form does mercury exist when it is produced during the combustion of coal?

What is the value of a three-year payer swap : What's the value of a three-year payer swap with a notional of $1,000,000 and a fixed rate of 6% (annualized with semi-annual compounding) worth?

Estimate the total interests paid during 30 years : Determine the amounts from the relationship between the pay ments and balance;

Determine the influence of concentration : If you want to study the influence of IO3- ion concentration on the rate of the reaction to determine the influence of concentration.

Determine the risk-free rate : Assume these securities are correctly priced. Based on the CAPM, what is the expected return on the market? What is the risk-free rate?

Administration of insulin when treating dka : What are some serious adverse events that may result from the over-zealous administration of insulin when treating DKA?

How much will you need to pay : After 10 years, you win the lottery and want to pay off the rest of what you owe. How much will you need to pay?

User Account

All Pages