Question

In: Finance

Choose the best option between the following 2 mortgages. A $1,000,000 fully amortizing, fixed rate mortgage...

Choose the best option between the following 2 mortgages. A $1,000,000 fully amortizing, fixed rate mortgage with a 10 year term, monthly payments, an interest rate of 6%, and $12,000 closing costs. Or, a $1,000,000 interest only, fixed rate mortgage with a 10 year term, monthly payments, and interest rate of 6.5%, and $2,000 in closing costs. Please show work.

Solutions

Expert Solution

In the case of the fully amortizing loan, monthly payment is arrived at $11,102.05 using PMT function of Excel. Annual Percentage Rate (APR) of this loan is 6.267569%

In the case of interest only loan, monthly interest payment is $5,416.67 and the final payment is one month interest plus the loan amount. Annual percentage rate is 6.527285%

Since the fully amortizing loan has lower interest cost, the same is the best option.

Calculation as follows:


Related Solutions

"Bob got a fully amortizing 30 year fixed rate mortgage with monthly payments for $1,000,000 at...
"Bob got a fully amortizing 30 year fixed rate mortgage with monthly payments for $1,000,000 at an annual interest rate of 4.5%, compounded monthly. If Bob made the required monthly payment every month, how many dollars in interest will Bob pay in his 125th monthly payment?" "$1,393.91 " "$2,094.63 " "$2,972.23 " "$35,666.72 "
Consider the following pool of mortgages: 100 fully amortizing mortgages Original balance $259,689 Fixed rate interest...
Consider the following pool of mortgages: 100 fully amortizing mortgages Original balance $259,689 Fixed rate interest at 5% Issued for 30 years with monthly payments Assuming there are no prepayments, what do you predict the pool factor will be after 147 payments? Round your answer to two decimal points (e.g. if your answer is 1/3, enter 0.33).
Consider the following pool of mortgages: 100 fully amortizing mortgages Original balance $668,018 Fixed rate interest...
Consider the following pool of mortgages: 100 fully amortizing mortgages Original balance $668,018 Fixed rate interest at 4% Issued for 30 years with monthly payments Assuming there are no prepayments, what do you predict the pool factor will be after 64 payments? Round your answer to two decimal points (e.g. if your answer is 1/3, enter 0.33).
Consider the following pool of mortgages: 100 fully amortizing mortgages Original balance $209,170 Fixed rate interest...
Consider the following pool of mortgages: 100 fully amortizing mortgages Original balance $209,170 Fixed rate interest at 2% Issued for 30 years with monthly payments Assuming there are no prepayments, what do you predict the pool factor will be after 127 payments? Round your answer to two decimal points (e.g. if your answer is 1/3, enter 0.33).
Ann gets a fully amortizing 30-year fixed rate mortgage with quarterly payments for $1,000,000. The interest...
Ann gets a fully amortizing 30-year fixed rate mortgage with quarterly payments for $1,000,000. The interest rate is 4%, compounded quarterly. She prepays the mortgage in 1 quarter (i.e. she makes the 1st payment and immediately prepays the remaining balance). What is Ann’s APR? Notes: a quarter equals 3 months, one year consists of 4 quarters, APR is annual. Modify question above: At the moment when Ann signs the mortgage, she must pay an origination fee that equals 2 points....
The principal component of the payment on a fully-amortizing fixed-rate mortgage is increasing at an increasing...
The principal component of the payment on a fully-amortizing fixed-rate mortgage is increasing at an increasing rate over the term of the loan. Group of answer choices True False
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the the bank the balance, which mortgage has the lowest cost of borrowing (lowest annualized IRR)
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1 for...
Aann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Aann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 30 years, which mortgage has the lowest cost of borrowing
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Ann’s annualized IRR from mortgage A? #2 IRR from mortgage B? I would like to know how to calculate the IRR of this in a BA II
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT