Total amount of interest paid throughout life of loan

Assignment Help Financial Management

Reference no: EM131546571

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: EM131546571

Questions Cloud

Calculate minimum lease payment that would satisfy lessor : Calculate the minimum lease payment that would satisfy the lessor and calculate the NPV.

Biology to organize living creatures : Explain the classification system used in biology to organize living creatures. Pick two organisms from each Kingdom and explain why they are placed.

Describe new diagnostic tool or intervention of diabetes : Based on the summary of research findings identified from the Evidence-Based Project-Paper on Diabetes that describes a new diagnostic tool or intervention.

Personal calorie recommendations : Design and follow a meal plan for two days that meets your personal calorie recommendations, while limiting sodium to 2 grams (2000 milligrams) daily.

Total amount of interest paid throughout life of loan : Calculate the total amount of interest paid throughout the life of the loan.

Contributed to the success of insects : The Earth's largest phylum is Arthropoda, including centipedes, millipedes, crustaceans, and insects. The insects have shown to be a particularly successful.

What issues need to be considered to ensure : When the government considers enacting a new tax, what issues need to be considered to ensure that the tax will be fair to all taxpayers?

Connection between the mother new job : First, how might you determine if there is a connection between the mother's new job and her child's illness?

Choose two theories of the causes of crime : Discuss the ways in which they fit with the crime and the specific demographics associated with the crime.

User Account

All Pages