Required information

Skip to question

[The following information applies to the questions displayed below.]

NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.

In this lab, you will:

Required:

1. Calculate the monthly payment for a 15-year and a 6-year mortgage loan.

2. Calculate the amount of interest that youd pay for a 15-year mortgage loan and a 6-year mortgage loan.

Ask the Question: How much interest do you pay over the life of a 15-year and a 6-year mortgage?

Master the Data: There is no data file for this lab. We will make the needed calculations and input the data as we go.

To compute the mortgage payments, well need to know a few things:

1. The size of the mortgage loan
2. The interest rate
3. The length of the loan (number of months)

Lets suppose you would like to buy a home for $250,000. But like most U.S. citizens, you dont have enough cash on hand to pay for the full house. But were in luck! Signature Bank has agreed to offer you a 30-year mortgage loan, but requires that you pay 20 percent down ($50,000 = 20% of $250,000) to qualify for their mortgage loan of $200,000 in this way:

$250,000	Cost of home
50,000	Required 20% down payment ($50,000 = 20% of $250,000) (The
	cash you need to have available to pay when closing on the home)
$200,000	Amount of the bank loan

Required:

1. What would be the monthly payment for 180 months, 6% annual interest and a $200,000 loan?

multiple choice 1

• $1,199.10

• $3,314.58

• $1,687.71

• $1,064.48

2. What would be the monthly payment for 72 months, 6% annual interest and a $200,000 loan?

multiple choice 2

• $1,199.10

• $1,064.48

• $3,314.58

• $1,687.71

3. For the 180-month mortgage, what is the amount that goes toward paying down principal in monthly payment number 20?

multiple choice 3

• $752.31

• $931.64

• $756.07

• $759.04

4. For the 72-month mortgage, what is the amount of interest expense in monthly payment number 3?

multiple choice 4

• $976.80

• $965.11

• $2,337.78

• $993.11

5. What is the total amount of interest paid over the life of the 180-month mortgage?

multiple choice 5

• $103,788.46

• $303,788.46

• $38,649.59

• $238,649.59

Software needed

• Excel
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

Perform the Analysis: Refer to Lab 1-3 Alternative in the text for instructions and Lab 1-3 steps for each of the lab parts.

Share the Story: Accountants need to know how much of each monthly mortgage (or bond) payment goes toward interest.

rev: 09_21_2020_QC_CS-228676

Upload the Word or PDF document containing your Lab screenshots using the button below.

1. Take a screenshot of the top 20 lines of your 180-month amortization schedule and label it Lab 1-3 Alt Submission 1.
2. Take a screenshot of the top 20 lines of your 72-month amortization schedule and label it Lab 1-3 Alt Submission 2.