Question

In: Finance

An institutional lender is willing to make a 10-year constant payment mortgage of $5 million for...

An institutional lender is willing to make a 10-year constant payment mortgage of $5 million for a retail building you plan on purchasing. The interest rate she has agreed to charge is 10% per year, annual loan payments, with 2 points. The lender will charge a 1% origination fee which you additionally plan to borrow in the loan.

a) What is the initial disbursement amount that you will receive? [Hint: must account for fees in initial loan balance]
b) What will be the total loan payment in the first year? Will this payment be the same for the remaining years?
c) What will be the interest payment in the third year?
d) What will be the outstanding loan balance at the end of the seventh year?
e) What is the IRR of the loan?

Solutions

Expert Solution

(a ): Initial disbursement amount= $4,900,000

(b ): Total loan payment in first year (yearly payment)= $821,864.24    (Excluding discount point of $100,000 paid on closing)

The yearly payment of $821,864.24 will continue in the remaining years

(c ): Interest payment in the third year= $438,458.51

(d ): Outstanding balance at the end of seventh year= $2,043,854.73

(e ): IRR of the loan= 10.707945%

Calculations as below:


Related Solutions

Calculating the Payment for a Constant Payment Mortgage (CPM) $100000 Mortgage 5% Interest 20 Years Monthly...
Calculating the Payment for a Constant Payment Mortgage (CPM) $100000 Mortgage 5% Interest 20 Years Monthly Payments If he wants to pay off the loan after 8 years, what would be the outstanding balance on the loan? Present Value Method
In underwriting a new 30-year, monthly payment mortgage loan at5% interest for Jackie, the lender...
In underwriting a new 30-year, monthly payment mortgage loan at 5% interest for Jackie, the lender requires that Jackie meet three ratios to be approved for the loan.First, the payment on her loan plus the monthly cost of homeowner's insurance of $200 plus monthly property taxes of $225 plus monthly home owner association fees of $100 can be no more than 28% of her gross monthly income.Second, the monthly total of the four items above plus her car loan payment...
On the third tab build the full amortization table for a 30 year Constant Payment Mortgage...
On the third tab build the full amortization table for a 30 year Constant Payment Mortgage (CPM) Loan with a 4.5% interest rate compounded monthly. The initial loan amount should be $2,500,000. in excel
Assuming a 5/1 ARM, calculate the monthly mortgage payment on a 30 year $200,000 mortgage with...
Assuming a 5/1 ARM, calculate the monthly mortgage payment on a 30 year $200,000 mortgage with an initial rate of 2.75%, a rate of 4% at the time of the first adjustment, a rate of 5% at second adjustment and a rate of 4% at the third adjustment.
If you make a monthly payment of $425.84 on a 30-year mortgage for $75,000, what is...
If you make a monthly payment of $425.84 on a 30-year mortgage for $75,000, what is the interest rate on your mortgage? You plan to open a savings account and deposit the same amount of money at the beginning of each month. In 10 years, you want to have $25,000 in the account. How much should you deposit if the annual interest rate is 0.5% with quarterly compounding? The Furros Company purchased equipment providing an annual savings of $20,000 over...
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?
Your company is planning to borrow $3 million on a 5-year, 10%, annual payment, fully amortized...
Your company is planning to borrow $3 million on a 5-year, 10%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places
A lender will be having £10 million to lend from December to March next year. Right...
A lender will be having £10 million to lend from December to March next year. Right now, the December Eurodollar futures contract has price 94. If the lender uses 10 December Eurodollar futures to hedge his future lending, does he long or short futures? If the 3-month LIBOR in December turns out to be 1.2% (3-month effective), how much money does the lender get in March from his hedged lending of £10 million?
A lender will be having £10 million to lend from December to March next year. Right...
A lender will be having £10 million to lend from December to March next year. Right now, the December Eurodollar futures contract has price 94. If the lender uses 10 December Eurodollar futures to hedge his future lending, does he long or short futures? If the 3-month LIBOR in December turns out to be 1.2% (3-month effective), how much money does the lender get in March from his hedged lending of £10 million? (im getting a second opinion on this,...
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT