Question

In: Finance

You have just purchased a new warehouse. To finance the purchase, you've arranged for a 25-year...

You have just purchased a new warehouse. To finance the purchase, you've arranged for a 25-year mortgage for the $1,440,000 purchase price. The monthly payment on this loan will be $10,600. What is the EAR?

Solutions

Expert Solution

Answer : To calculate EAR , we first need to calculate Monthly Rate of Interest :

Using Rate function of Excel :

=RATE(nper,pmt,pv,fv)

where

nper is the number of payments i.e 25 * 12 = 300 (Multiplied by 12 as Monthly payment)

pmt is the periodic payment i.e 10600

pv is the amount borrowed i.e 1,440,000

fv is the future value i.e 0

=RATE(300,10600,-1440000,0)

Monthly Rate is 0.6213% or 0.006213

EAR = [( 1 + Monthly rate)^12 - 1]

= [(1.006213)^12 - 1]

= 1.077158 -1

= 0.077158 or 7.72%


Related Solutions

You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30-year...
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,600,000 purchase price. The monthly payment on this loan will be $11,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 35-year...
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 35-year mortgage for 85percent of the $4,400,000 purchase price. The monthly payment on this loan will be $18,500. what is the apr on this loan? what is the ear on this loan?
You have just arranged for a $1,800,050 mortgage to finance the purchase of a large tract...
You have just arranged for a $1,800,050 mortgage to finance the purchase of a large tract of land. The mortgage has a 8.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? Show Steps.
Assume that you have purchased a new home and arranged for a mortgage in the amount...
Assume that you have purchased a new home and arranged for a mortgage in the amount of $125,000. The loan is at 4.75% over 15 years. a. What is your monthly payment? b. How much of the loan's principal will you pay over the first year of the loan? c. How much total interest will you pay over years 9 through 11? d. What will be your loan balance after 14 years? e. What is the effective rate on your...
You have just purchased a car and, to fund the purchase, you borrowed $25,500. If your...
You have just purchased a car and, to fund the purchase, you borrowed $25,500. If your monthly payments are $360.24 for the next 7 years, what is the APR of the loan?
You have just arranged a six-year bank loan for $150,000 at an interest rate of 9%...
You have just arranged a six-year bank loan for $150,000 at an interest rate of 9% p.a. with interest compounded quarterly. The loan will be repaid in equal quarterly installments and the first payment will be due one quarter from today. Assuming end-of-the-period cash flows, the principal amount repaid to the bank at the end of the first quarter will be closest to: Group of answer choices $3,375. $4,890. $4,782. $3,267.
You just purchased an annuity that will pay you $24,000 a year for 25 years,  starting today....
You just purchased an annuity that will pay you $24,000 a year for 25 years,  starting today. What was the purchase price if the discount rate is 8%? $256,195 $251,409 $245,621 $276,690 $258,319
Michael Jordan has just arranged to purchase an $825,000vacation home in the Bahamas with a...
Michael Jordan has just arranged to purchase an $825,000 vacation home in the Bahamas with a 20% down-payment. The loan has an interest rate of 5.4% (compounded monthly) and a 30-year term. If the value of the home is expected to appreciate 2% per year, what will his equity in the house be in 8 year?
a. You've just been hired at a new job. You expect to work there for 4...
a. You've just been hired at a new job. You expect to work there for 4 years. Your boss offers you a hiring bonus of either $2,739 today, or an additional $22 per month, starting next month, on your salary. If your investments earn 2.75% APR (compounded monthly), how much would you gain or lose by taking the cash-bonus today? b. You purchase an antique car today for $52,394 You expect the price of the car to rise by 4%...
You have just purchased a new home and have taken out a mortgage loan for $300,000...
You have just purchased a new home and have taken out a mortgage loan for $300,000 at an interest rate of 4.00% and a maturity of 30 years. You will make 360 equal monthly payments. What is the amount of your monthly payment? Please fill in the amortization schedule below for the first two months (month1 and 2) of the 360 months that you will be paying on the mortgage. Hint: PVA = Payment [1-(1+r)^-N / r] Please fill in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT