Question

In: Finance

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)?

Solutions

Expert Solution

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?

Finding payment per period:

Asset Value = A

$135,000.00

Down Payment = DP = 0 =

$0.00

P = Principal Loan = (A - DP) =

$135,000.00

R = Rate =

5.25%

N = Numbers of payment =

                     30

PMT = Payment = P x R x (1+R)^N / ((1+R)^N - 1) =

          9,033.79

Formula for calculating payment (working)

PMT = P x R x (1+R)^N / ((1+R)^N - 1)

PMT =135000*5.25%*(1+5.25%)^30/((1+5.25%)^30-1)

PMT = $ 9,033.79 (Rounding to nearest cent or two decimal places)

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)?

Finding outstanding balance at end of the particular time

P = Principal Loan = (A - DP) =

$135,000.00

R = Rate = 5.25%/12 =

0.43750%

n = Total number of payments done =

                   240

PMT = Payment = P x R x (1+R)^N / ((1+R)^N - 1) =

           745.475

FV = Outstanding Balance = (P*(1+R)^n)-(PMT*((1+R)^n-1)/R)

$ 69,481.14

Formula for calculating outstanding balance (working)   

FV = (P*(1+R)^n)-(PMT*((1+R)^n-1)/R)  

FV =(135000*(1+5.25%/12)^240)-(745.475*((1+5.25%/12)^240-1)/(5.25%/12)) = $ 69,481.14 (approx.)


Related Solutions

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 $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?  
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
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.
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...
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. (A) Assuming Ann makes payments for 30 years, what is Ann’s annualized IRR from mortgage A? (B) Assuming Ann makes payments for 30 years, what is Ann’s annualized IRR from mortgage B? (C)...
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 $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 2 years before she sells the house and pays the bank the balance, what is Ann’s annualized IRR from mortgage B?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT