Find the total interest paid by the end of the mortgage

Reference no: EM132339936

Mortgage Amortization Schedule Excel Assignment

1. Excel: Complete the amortization table provided in the Excel document posted in IvyLearn in the homework area by setting the appropriate values for a $180,000, 30-year mortgage at 4.25% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following:

a. How much of the first payment goes towards the principal? How much goes toward the interest?

b. How much of the last payment goes towards the principal? How much goes toward the interest?

c. Find the total interest paid by the end of the mortgage.

d. How much will be owed on the mortgage after making payments for 10 years (hint this is 120 months)?

e. How much interest has been paid total on the mortgage at the end of 10 years?

f. How many months will it take to pay at least half of the principal?

2. Change the spreadsheet from the last question so that the mortgage is for 15 years rather than 30 years.

a. Find the total interest paid by the end of the mortgage.

b. What are some advantages and disadvantages of getting a shorter term mortgage?

Attachment:- Section 11 Mortgages Amortization Schedule.rar

Reference no: EM132339936

Questions Cloud

Conduct an Investigative Interview with an employee : Future Work Skills Assignment - Labor Market. Conduct an Investigative Interview with an employee or manager working in a company or organisation

Explain the facts or statistics that you think would make : Explain the facts or statistics that you think would make this country a good place to build and staff your factory. Your company wants to put a ball-bearing.

What is the total of the finance charges : With a beginning balance of $2500 and no additional charges, there is no grace-period, you will just pay the minimum payment each month for the next year.

Evaluate and design realistic computer network solutions : DN304 Capstone Project Assignment, Abacus Institute Of Studies, New Zealand. Evaluate and design realistic computer network solutions

Find the total interest paid by the end of the mortgage : How much will be owed on the mortgage after making payments for 10 years? Find the total interest paid by the end of the mortgage.

Discuss the implementation challenges you faced : SEN 2120-SOFTWARE ENGINEERING APPROACH TO HUMAN-COMPUTER INTERACTION-Emirates Aviation University-Dubai - United Arab Emirates.

Research different methods of selecting projects : PROJ6000 Principles of Project Management Assignment - Project Selection Methods and Initial Documents, Laureate International Universities, Australia

How is an engine compression check carried out : Discuss the steps you would take to reduce the risk of hazards associated with vehicular movement during engine reparis.How is an engine compression check ?

Briefly describe five types of diversity : Identify and briefly describe five types of diversity presented in Chapter 4 of your text. Which areas of student diversity pose the most challenges for you as.

User Account

All Pages