Calculate the total amount of interest paid

Assignment Help Finance Basics
Reference no: EM132664190

You are thinking of purchasing a house that costs $235,000. You have $12,000 in cash for a down payment, but you need to borrow the rest of the purchase price. Assume there are no closing costs. The bank is offering a 30-year mortgage that requires monthly payments and has an annual interest rate of 4.25%. 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. Make 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.55%. 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: EM132664190

Questions Cloud

Discuss role government plays in a global economy : Discuss role government plays in a global economy. Also, look at what policies are currently in place and then discussion what policies should be put in place.
What are potential risks involved with cloud computing : What are some of the potential risks involved with cloud computing? Does the research and model in this article propose a viable solution
Compute Roger State A taxable income : Compute Roger's State A taxable income assuming that State A apportions income based on a three-factor formula, with double-weighted sales factor
Discuss your experience as mentor and as one being mentored : Discuss your experience as a mentor and as one being mentored. If you do not have experience in either of these roles, describe how you would begin a mentoring
Calculate the total amount of interest paid : Suppose you have the option to take out a 15-year mortgage with an annual interest rate of 3.55%. What would the monthly payment
Determine the apportionment factors for A and B : Determine the apportionment factors for A and B assuming that A uses a three-factor apportionment formula under which sales
How the process included multiple perspectives : Discuss a situation where you had to build consensus for a decision. In doing so, be sure to discuss: How the process included multiple perspectives.
How leaders communicate big ideas to drive business results : Decision making and producing results are two responsibilities of any leader. As you continue to develop as a leader, you will be tasked with more situations.
Explain clearly what made the hire expected or unexpected : In your experience, does this quote ring true? Describe an example of a hire you were involved in that supports your position. You may have been the HR.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd