Question

In: Finance

Mr. Smith bought an apartment house with $60,000 cash and a fixed-rate fully-amortizing constant payment mortgage...

  1. Mr. Smith bought an apartment house with $60,000 cash and a fixed-rate fully-amortizing constant payment mortgage (CPM) of $100,000.  The loan was made at an interest rate of 10 percent and requires monthly payments for 25 years.
  1. Complete the following amortization schedule with given information.                                                                                                                              (3 points)

Loan Amount

$ 100,000.00

Annual Interest Rate

10%

Loan Term

25 years

Beginning Balance

Monthly Payment

Interest

Amortization

Ending Balance

Month 1

Month 2

What would be the outstanding balance after 10 years?   

Solutions

Expert Solution

Answer; Part (A)

Current Monthly Installment Amount =

No of Year = 25 Years

No of period = 25 X 12 = 300 monthly payments

Rate = 10% per annum

Monthly rate = 10 % / 12 = .8333%

Principal Amount = $ 100,000

Formula ; Monthly Installment = = P × r × (1 + r)n/((1 + r)^n - 1)

= 100,000 x .83333% [ (1.0083333)^300/ (1.008333)^300 -1]

= 833.33 x[12.05682545/(12.05682545-1)]

= 833.33 X 1.090441873

= $908.70 Per Month or $$909

Answer Part B

Ramaining Amount After 10 years = Formula

Ramaining Amount =

= 100000*(1.0083333)^120 - 908.70*[(1.008333)^120 - 1]/.008333

= 100000*2.707030752 - 908.70*[2.707030752 - 1]/.008333

= 100000*2.707030752 - 908.70*[1.707030752]/.008333

=270703.0752 - 908.70*204.8445096

=270703.0752-186142.2059

= $84560.87 or $84561


Related Solutions

Compare and contrast a constant-payment fixed-rate (CPM) mortgage with a constant-amortizing fixed-rate (CAM) mortgage. Why are...
Compare and contrast a constant-payment fixed-rate (CPM) mortgage with a constant-amortizing fixed-rate (CAM) mortgage. Why are CAMs not popular with consumers? Why did CAMs develop before CPMs?
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
A fixed-rate constant-payment partially-amortizing mortgage is made for $100,000 at 5% for 30 years. The balloon...
A fixed-rate constant-payment partially-amortizing mortgage is made for $100,000 at 5% for 30 years. The balloon payment will be $50,000 at the end of year 30. Calculate the monthly payment. What will the total of payments be for entire 30 years? Of the total, how much will be interest? What would be the outstanding balance after 5 years?
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
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...
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
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT