Question

In: Finance

A couple has just purchased a home for $311,500.00. They will pay 20% down in cash,...

A couple has just purchased a home for $311,500.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 4.08% APR with monthly compounding. The mortgage has a term of 30 years.

What is the size of the loan taken out by the couple?

What is the monthly payment on the loan?

How much interest is paid on the first payment?

How much interest is paid in the first year?

Solutions

Expert Solution


Payment:

#

Asset Value = A

$311,500.00

Down Payment = DP =

$62,300.00

P = Principal Loan = (A - DP) =

$249,200.00

R = Rate or APR =

4.08%

N = Number of payments =

                  360

PMT = Payment = P x R/12 x (1+R/12)^N / ((1+R/12)^N - 1)

Payment = Payment in Dollars = 320000 x 6%/12 x (1+6%/12)^360 / ((1+6%/12)^360 -1) =

$1,201.24

Alternate Method:

Using financial calculator BA II Plus - Input details:

#

I/Y = Rate/12*100 =

0.340000

FV =

$0

N = Total terms =

                  360

PV =

-$249,200

CPT > PMT = Monthly Payment =

$1,201.24

What is the size of the loan taken out by the couple? $249,200.00

---------------------------

What is the monthly payment on the loan? $1,201.24

---------------

How much interest is paid on the first payment?

Interest = Loan value x Rate/12 = 249200 x 4.08%/12 = $847.28

---------------------------------

How much interest is paid in the first year? $ 10,087.02 (sum of interest column)

Year

Opening balance of loan

Interest

Payment

Amortization of loan

Closing balance

Y

OP

I = OP x Rate

PMT

AM = PMT - I

CB

1

              249,200.00

                     847.28

$1,201.24

                     353.96

              248,846.04

2

              248,846.04

                     846.08

$1,201.24

                     355.16

              248,490.87

3

              248,490.87

                     844.87

$1,201.24

                     356.37

              248,134.50

4

             248,134.50

                     843.66

$1,201.24

                     357.58

              247,776.92

5

              247,776.92

                     842.44

$1,201.24

                     358.80

              247,418.12

6

              247,418.12

                     841.22

$1,201.24

                     360.02

              247,058.10

7

              247,058.10

                     840.00

$1,201.24

                     361.24

              246,696.86

8

              246,696.86

                     838.77

$1,201.24

                     362.47

              246,334.39

9

              246,334.39

                     837.54

$1,201.24

                     363.70

              245,970.68

10

              245,970.68

                     836.30

$1,201.24

                     364.94

              245,605.74

11

              245,605.74

                     835.06

$1,201.24

                     366.18

              245,239.56

12

              245,239.56

                     833.81

$1,201.24

                     367.43

              244,872.13

Total Interest

                10,087.02


Related Solutions

A couple has just purchased a home for $312,100.00. They will pay 20% down in cash,...
A couple has just purchased a home for $312,100.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 5.64% APR with monthly compounding. The mortgage has a term of 30 years. How much interest is paid on the first payment? A couple has just purchased a home for $312,100.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them...
A couple has just purchased a home for $348,400.00. They will pay 20% down in cash,...
A couple has just purchased a home for $348,400.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 5.04% APR with monthly compounding. The mortgage has a term of 30 years. How much interest is paid in the first year?
A couple has just purchased a home for $314,100.00. They will pay 20% down in cash,...
A couple has just purchased a home for $314,100.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 3.72% APR with monthly compounding. The mortgage has a term of 30 years. What is the size of the loan taken out by the couple? A couple has just purchased a home for $313,200.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker...
A couple has just purchased a home for $327,400.00. They will pay 20% down in cash,...
A couple has just purchased a home for $327,400.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 5.64% APR with monthly compounding. The mortgage has a term of 30 years. How much interest is paid in the first year? Answer Format: Currency: Round to: 2 decimal places.
A couple has just purchased a home for $384,100.00. They will pay 20% down in cash,...
A couple has just purchased a home for $384,100.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 5.64% APR with monthly compounding. The mortgage has a term of 30 years. How much interest is paid in the first year?
1. A couple has just purchased a home for $447,300.00. They will pay 20% down in...
1. A couple has just purchased a home for $447,300.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 3.72% APR with monthly compounding. The mortgage has a term of 30 years. How much interest is paid in the first year? --------------------------------------------------------------------------------------------------- 2. A professor has two daughters that he hopes will one day go to college. Currently, in-state students at the local University pay about $22,119.00...
Fifteen years ago a couple purchased a house for $230,000.00 by paying a 20% down payment...
Fifteen years ago a couple purchased a house for $230,000.00 by paying a 20% down payment and financing the remaining balance with a 30-year mortgage at 4.7% compounded monthly. (a) Find the monthly payment for this loan. (b) Find the balance of the loan after 16 years and after 17 years? (c) Find the total amount of interest paid by the couple during the 17th year.
Ms. Towne is buying a home for $350,000 and is putting down 20% cash on the...
Ms. Towne is buying a home for $350,000 and is putting down 20% cash on the purchase. She is financing the rest with a 25 year fixed rate 5.75% mortgage, but is considering a bi-weekly repayment option. How much interest would the bi-weekly option allow her to save and how long would it take her to pay off the loan with this option? a) $45,763; 21.8 years b) $44,330; 21.14 years c) $49,321; 13.27 years d) $37,901; 22.23 years
You want to buy a $188,000 home. You plan to pay 20% as a down payment,...
You want to buy a $188,000 home. You plan to pay 20% as a down payment, and take out a 30 year loan for the rest. a) How much is the loan amount going to be? $ b) What will your monthly payments be if the interest rate is 5%? $ c) What will your monthly payments be if the interest rate is 6%? $
You want to buy a $198,000 home. You plan to pay 20% as a down payment,...
You want to buy a $198,000 home. You plan to pay 20% as a down payment, and take out a 30 year loan for the rest. a) How much is the loan amount going to be? $ b) What will your monthly payments be if the interest rate is 6%? $ c) What will your monthly payments be if the interest rate is 7%? $
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT