What would the monthly payment be for this mortgage

Assignment Help Financial Management

Reference no: EM131546541

You are thinking of purchasing a house that costs $230,000. You have $20,000 in cash for a down payment, but you need to borrow the rest of the purchase price. The bank is offering a 30- year mortgage that requires monthly payments and has an annual interest rate of 4.55%. What will your monthly payments be if you sign up for this mortgage? Draw the amortization schedule on a monthly basis using Excel. Calculate the total amount of interest paid throughout the life of the loan. Create a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan.

Suppose you have the option to take out a 15-year mortgage with an annual interest rate of 3.95%. What would the monthly payment be for this mortgage? Draw a new amortization schedule in a separate Excel sheet. Calculate the total amount of interest paid throughout the life of the loan. How much would you save if you choose the 15-year over the 30-year mortgage?

Reference no: EM131546541

Questions Cloud

How is rheumatoid different than osteoarthritis : What is TMJ. Why is it prone to problems and how is it treated? How is rheumatoid different than osteoarthritis?

Thinking like a mountain by aldo leopold : A deep chesty bawl echoes from rimrock to rimrock, rolls down the mountain, and fades into the far blackness of the night.

What is the value of the abandonment option : What is the value of the abandonment option? What is Proposal B's differential risk-adjusted NPV? (Again, disregard the abandonment option.)

Create a resume detailing your license and earned degree : Write an introductory Cover Letter of no more than 500 words in which you explain your Professional Objectives, Professional Interests, and Strengths.

What would the monthly payment be for this mortgage : What would the monthly payment be for this mortgage? Calculate the total amount of interest paid throughout the life of the loan.

Explain the socio-cultural barriers : Do your research and explain the socio-cultural barriers faced by these two companies, pepsi & coke - What in your view were the reasons.

What type of demeanor is expected? : What type of demeanor is expected? Are there body language expectations?What are the main ethics rules of the profession?

Effective or equivalent-annual cost of trade credit : What is the effective, or equivalent, annual cost of the trade credit?

Issues of diversity-equity and social justice : One goal you like to set for early childhood field related to issues of diversity, equity, and social justice (any format and any length).

User Account

All Pages