Question

In: Finance

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

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE


Related Solutions

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...
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
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 30 years, what is Ann’s IRR from mortgage A? Note: IRR is always annualized. If you’ve found a monthly rate, multiply by 12. In this case, two digits for a monthly rate is not enough to avoid rounding errors in the annual rate...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000.
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000. Mortgage A has a 5.25% 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, what is Ann’s annualized IRR from mortgage A?  
12. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments...
12. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,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 (ie lowest annualized IRR)? Type 1 for A, type 2 for B. 13. Ann is looking for...
You qualify for an $800,000 fully amortizing 30-year fixed rate mortgage with monthly payments. If the...
You qualify for an $800,000 fully amortizing 30-year fixed rate mortgage with monthly payments. If the annual interest rate is 3.63%, compounded monthly, what will the monthly mortgage payment be?
Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000 at...
Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000 at 4.38%. What percent of Ann’s 20th payment goes to interest? If Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000 at 4.38%. What percent of Ann’s 20th payment goes to principal?v
Crystal Ball has a 30 year, fully amortizing fixed rate mortgage, with monthly payments, for a...
Crystal Ball has a 30 year, fully amortizing fixed rate mortgage, with monthly payments, for a $200,000 loan at 7%. In 5 years, interest rates fall and Crystal can get a 25 year, fully amortizing fix rate mortgage with monthly payments at 6%. However, to get this new loan, Crystal needs to pay 2 points and $2,500 in fees. What is the return on investment (from refinancing)? Assume Crystal stays in the property for the next 25 years – the...
Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000 at...
Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000 at 4.38%. What will be Ann’s mortgage balance after 20 years of payments (i.e. after 240 months)? Ann obtains a fully amortizing 30-year Fixed Rate Mortgage with monthly payments for $1,250,000 at 4.38%. What fraction of Ann’s 40th payment goes to interest? Solutions with financial calculation and excel please.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT