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 20^th 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 20^th payment goes to principal?v

Solutions

Expert Solution

EXCEL FORMULA:

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

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.

3. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000...

3. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. How much does Ann need to pay monthly? 16. Ann obtains a 30 year Interest Only Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. What will Ann’s monthly payments be?

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...

4. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with annual payments for $135,000...

4. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with annual payments for $135,000 at 5.25%. How much does Ann need to pay annually? 7. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. What will be Ann’s mortgage balance after 20 years of payments (ie after 240 months)?

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...

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

Subjects