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