Monthly mortgage payment and total interest payments

Assignment Help Financial Management

Reference no: EM131535561

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.

Reference no: EM131535561

Questions Cloud

What is the net present value of each project : What is the net present value of each project and which should be selected according to this method?

Current prices of three bonds based on the initial ytm : What are the current prices of three bonds based on the initial YTM given?

What would be your moral reasoning : What would be your moral reasoning?

Discounting the free cash flows and the interest tax savings : What is the appropriate rate for use in discounting the free cash flows and the interest tax savings?

Monthly mortgage payment and total interest payments : what would be the monthly mo mortgage payment and the total interest payments?

Should nwt change its credit terms : Next Week’s Technology (NWT) is evaluating whether to change its credit terms from 2/10, net 30 to 3/10, net 30. Should NWT change its credit terms?

Assume all operating costs are paid when inventory : Assume all operating costs are paid when inventory is sold and that all sales are collected at the DSO.

What would his payments be if he borrows under these terms : What would his payments be if he borrows under these terms?

Calculate the net funds available to the parent MNC : Calculate the net funds available to the parent MNC? if. Foreign taxes can be applied as a credit against the? MNC's U.S. tax liability.

User Account

All Pages