Question

You have just arranged for a $1,500,000 mortgage to finance the purchase of a large tract of land. The mortgage has an APR of 5 percent, and it calls for monthly payments over the next 20 years.

How much interest are you paying at the end of the 20th month?

Please post with step-by-step solution.

Answer #1

The first step is to calculate the monthly payment to be made over the next 20 years. The monthly payment is found using the following equation:-

**Monthly payment = $9,899.34**

**--------------------------------------------------------------------------**

**To find out the interest paid at the end of 20th month,
we have to build the amortization schedule of the
mortgage.**

Excel can be used to build the amortization schedule.

Monthly interest rate = 0.05 12

In the below amortization table, the interest paid each month is found by multiplying the monthly interest rate with the beginning balance.

For example in the 1st month, monthly interest = ( 0.05 12 ) $ 1,500,000 = $ 6,250

The principal amount paid each month is found by subtracting the monthly payment with the interest paid.

In first month , the principal paid = $ 9899.34 - $ 6250 = $ 3649.34

Ending balance = Beginning balance - principal paid each month

Ending balance 1st month = $ 1,500,000 - $ 3649.34 = $1,496,350.66 .

The beginning balance of the 2nd month = The ending balance of the previous month viz. 1st month

The same process is repeated for each month which helps in finding out the interest, principal and ending balance.

In excel the formula can be copied for each cell up to 20 months to obtain the values.

**The interest paid at the end of 20th month = $
5,950**

You have just arranged for a $1,800,150 mortgage to finance the
purchase of a large tract of land. The mortgage has a 9.3% APR
(semiannual), and it calls for monthly payments over the next 30
years. However, the loan has an eight-year balloon payment, meaning
that the loan must be paid off then. How big will the balloon
payment be?

You have just arranged for a $200,000 mortgage to finance the
purchase of a house. The mortgage has an 8 percent quoted rate,
interest is compounded semi-annually and it calls for monthly
payments for the next 20 years. What is the monthly payment?Please
provide step-by-step instructions for solving the problem

Amanda Rice has just arranged to purchase a $530,000 vacation
home in the Bahamas with a 20 percent down payment. The mortgage
has a 5.9 percent APR compounded monthly and calls for equal
monthly payments over the next 30 years. Her first payment will be
due one month from now. However, the mortgage has an eight-year
balloon payment, meaning that the balance of the loan must be paid
off at the end of Year 8. There were no other transaction...

You have just purchased a new warehouse. To finance the
purchase, you have arranged for a 30-year mortgage loan for 80% of
the $3,400,000 purchase price. The monthly payment on this loan
will be $17,500. What is the monthly compounded APR on this loan?
What is the EAR?
I need a proper solution with formula and not financial
calculator.

You have just purchased a new warehouse. To finance the
purchase, you’ve arranged for a 35-year mortgage for 85 percent of
the $4,100,000 purchase price. The monthly payment on this loan
will be $18,200. what is the apr and ear of this loan?

You have just purchased a new warehouse. To finance the
purchase, you’ve arranged for a 30-year mortgage for 80 percent of
the $3,700,000 purchase price. The monthly payment on this loan
will be $17,800.
What is the APR on this loan?
What is the EAR on this loan?

You have just purchased a new warehouse. To finance the
purchase, you've arranged for a 30-year mortgage loan for 80
percent of the $2,800,000 purchase price. The monthly payment on
this loan will be $17,000. a. What is the APR on this loan?
b. What is the EAR?

You have just purchased a new warehouse. To finance the
purchase, you’ve arranged for a 30-year mortgage loan for 80
percent of the $3,400,000 purchase price. The monthly payment on
this loan will be $17,500. What is the APR on this loan? What is
the EAR on this loan?

Audrey Sanborn has just arranged to purchase a $540,000 vacation
home in the Bahamas with a 30 percent down payment. The mortgage
has a 6 percent APR, compounded monthly, and calls for equal
monthly payments over the next 30 years. Her first payment will be
due one month from now. However, the mortgage has an eight-year
balloon payment, meaning that the balance of the loan must be paid
off at the end of Year 8. There were no other transaction...

Bulk Purchases just purchased a new warehouse. To finance the
purchase, the firm arranged for a 25-year mortgage for 80 percent
of the $1,800,000 purchase price. The monthly payment is $10,800.
What is the APR? The EAR?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 2 minutes ago

asked 2 minutes ago

asked 4 minutes ago

asked 10 minutes ago

asked 12 minutes ago

asked 16 minutes ago

asked 24 minutes ago

asked 31 minutes ago

asked 34 minutes ago

asked 38 minutes ago

asked 38 minutes ago