BUSI 221 MORTGAGE FINANCE REVIEW QUESTIONS REVIEW …
[Pages:23]Mortgage Finance Review Questions
1
BUSI 221 MORTGAGE FINANCE REVIEW QUESTIONS
Detailed solutions are provided at the end of the questions.
REVIEW QUESTION 1
Gordon and Helen have recently purchased a 2,500 square foot home for $300,000. They have requested a loan for $225,000. Real property taxes are estimated at $2,000 per annum.
The loan will be at a rate of 10% per annum, compounded semi-annually with monthly payments to fully amortize the loan over 20 years.
A. If the lender sets a GDSR of 32%, what is the minimum income required by the purchasers to qualify for the desired loan? [$86,546.50]
B. Assume that Gordon and Helen earn $80,000 per annum, Gordon has a car loan of $275 per month and Helen has a boat loan with payments of $500 per quarter. If the lender sets a GDSR of 32% and a TDSR of 40%, what is the maximum allowable loan? Assume all other facts remain as in the original question. [$206,655.83 under GDSR]
REVIEW QUESTION 2
Five years ago, David obtained a mortgage from the Helpful Credit Union. The loan was written for a 5-year term at an interest rate of 13% per annum, compounded semi-annually. Monthly payments of $1,375 were specified, sufficient to amortize the principal over a 20-year period.
The term of the loan is up. All payments were made on schedule. Dave may renew the mortgage for another 5-year term at the current rate of 7.5% per annum, compounded semi-annually.
After considering his overall financial position, Dave decides he would like to make weekly payments. However, the maximum payment he can afford is $225 per week. The credit union is willing to allow this change as loan as the loan is amortized at the current rate over the remaining 15 years.
What immediate balloon payment must Dave make to reduce the outstanding balance to the point where the weekly payments will fully amortize the loan over 15 years? [$4,446.62]
REVIEW QUESTION 3
Colleen has a $120,000 mortgage with ABC Trust Company at an interest rate of 8% per annum, compounded semi-annually, amortized over 25 years with a 4-year term. Monthly payments are rounded up to the next higher dollar.
Colleen has made the first 40 payments on time and for the full amount. She then missed four payments and paid only $500 each on the final four payments.
Calculate the OSB owing at the end of the term. [$118,227.97]
REVIEW QUESTION 4
You are a loan officer for the Superior Insurance Company and are considering a loan secured by a luxury apartment building. You have been provided with an income statement for the building, which shows a rental schedule, which would generate $6,400,000 gross potential rental income per annum, if the units were continuously rented at rates advertised in the schedule. At full occupancy this building can also be expected to generate $230,000 per annum from parking fees
Mortgage Finance Review Questions
2
and $370,000 per annum from membership and usage fees in the Penthouse Club. The vacancy and bad debt loss estimate of 8% applies to each component of gross potential income.
Expense items on the operating statement include $2,800,000 per annum depreciation of the building and equipment, $127,000 per annum to operate the Penthouse club, $880,000 per annum in property taxes, maintenance expenses of $440,000 per annum, utility costs of $362,000 per annum and property management fees of $678,000 per annum.
Your guidelines include a net operating income capitalization rate of 9% per annum, a debt coverage ratio of 1.2 and a maximum loan-to-value ratio of 70%. The loan would require quarterly payments adequate to fully amortize the principal over 20 years at an interest rate of 12% per annum, compounded quarterly.
What is the largest loan you can make? [$24,871,587]
REVIEW QUESTION 5
You have been hired as a consultant to provide your expertise to Mr. and Mrs. Miller regarding mortgage information. The Millers have been shopping for a loan and are confused by the terminology.
(a) The Millers have found three repayment schemes and ask you to briefly define them in simple terms:
interest accrual loan; interest only loan; and constant payment repayment scheme.
(b) The Millers know they require $100,000 to help finance the purchase of their first home. They call upon you, a mortgage finance expert, to calculate the size of the monthly payment and the outstanding balance owing at the end of a three-year term under each of the following scenarios:
(i)
Bank A offers interest accrual loans at an effective annual rate of 12%. [no payment;
OSB = $140,492.80]
(ii)
Credit Union B offers interest only loans at 11.75% per annum, compounded semi-
annually. [payment = $956.02; OSB = $100,000 + $956.02]
(iii) Trust Company C offers a constant payment repayment scheme amortized over 20 years at a rate of 12.5% per annum, compounded monthly. [payment = $1,136.14; OSB = $95,899.05]
REVIEW QUESTION 6
Joanne and Fred recently arranged a $175,000 mortgage with the XYZ Trust Company. The mortgage contract is written at a rate of 10% per annum, compounded semi-annually, with a 25year amortization period, a 5-year term and monthly payments rounded up to the next higher dollar.
(a) Calculate the monthly payment required on this loan. [$1,566]
(b) Calculate the outstanding balance owing at the end of the term and after two years. [$164,435.92; $171,379.96]
Mortgage Finance Review Questions
3
(c) Calculate the interest and principal portions of the 1st, 36th and 60th monthly payments.
Month 1 36 60
Interest $1,428.85 $1,383.69 $1,344.40
Principal $137.15 $182.31 $221.60
(d) Calculate the total interest paid and total principal repaid during the term. [Total interest = $83,395.92; Total principal = $10,564.08]
(e) Suppose that 2 years after the loan is initiated (i.e., 24 payments have been made), the XYZ Trust Co. decides to liquidate their investment. At this point, if the trust company finds an investor who will pay $162,000, determine the following:
(i) What yield will XYZ Trust Co. earn on their investment, expressed, as an annual rate with semi-annual compounding. [7.387689%]
(ii) What yield, expressed as an annual rate with semi-annual compounding, will the investor earn, and assuming the mortgage is held until the end of the term? [12.323743%]
(iii) If the investor demands a return of 15% per annum, compounded semi-annually, on his/her investment, what price would the investor is willing to pay today? How much of a discount, in dollars, has the investor received? [Price = $152,010.38; Discount = $19,369.58]
REVIEW QUESTION 7
Dorothy and Leonard have recently purchased their first home in Langley, a suburb of Vancouver, BC, for $300,000. They require a $285,000 mortgage loan. The total family income is $70,000 per annum and they have no debts outstanding. Net property taxes are estimated to be $2,800 per year.
The ABC Credit Union will provide funds on an insured first mortgage with an interest rate of 6% per annum, compounded semi-annually, amortized over 25 years with monthly payments. ABC requires a 32% gross debt service ratio and a 95% loan-to-value ratio on this insured loan. Assume that a 3.6% premium will be added onto the loan amount.
(a) What is the maximum first mortgage loan that Dorothy and Leonard qualify for? [$255,284.95]
(b) How large of a second mortgage is required in order for the borrowers to obtain the total amount desired? [$39,975.05]
(c) If the lender set a maximum total debt service ratio of 40%, will the borrowers qualify under this constraint? The second mortgage rate will be 8% per annum, compounded semi-annually and payable with monthly payments over a 15-year amortization period. [Yes, max 2nd = $49,218.85 or TDSR is 38.5%]
REVIEW QUESTION 8
On January 1, 2012, Susan Shopper borrowed $95,000 as a mortgage loan. The interest rate on the loan was set at 10.5% per annum, compounded semi-annually, with level quarterly payments over a 15-year amortization period. The term was set for one year.
Mortgage Finance Review Questions
4
At the end of the one-year term, January 1, 2013, Susan prepaid 10% of the outstanding balance and renewed the remaining balance for a 3-year term at a rate of 9.5% per annum, compounded semi-annually. Payments were maintained at the original amount.
On the anniversary of her mortgage, January 1, 2014, she again prepaid 10% of the outstanding balance and increased future payments by 20%.
Due to a recent cash flow problem, Susan did not make the final two payments due (October 1st and January 1st) and the previous two were for $1,000 each (April 1st and July 1st). All other payments were on schedule and for the full amount.
Calculate the amount owed to the lender on January 1, 2016, to fully repay the loan. [$65,323.35]
REVIEW QUESTION 9
A potential borrower is analyzing several mortgage loan alternatives and wants you to calculate the payment obligation(s) under each option and the outstanding balance owing at the end of a two-year period. The loan amount required is $100,000.
OPTIONS
1.
A constant payment repayment scheme at 9% per annum, compounded semi-annually,
amortized over 25 years with monthly payments. [PMT = $827.98; OSB = $97,603.23]
2.
A straight line principal reduction loan at 10% per annum, compounded semi-annually,
repaid over 10 years with semi-annual payments. [1st pmt = $10,000, 2nd pmt = $9,750
3rd pmt = $9,500, 4th pmt = $9,250; OSB = $80,000]
3.
An interest accrual loan at a rate of 12% per annum, compounded semi-annually. [no
pmt; OSB = $126,247.70]
4.
An interest only loan, repaid with quarterly payments at a rate of 12% per annum,
compounded semi-annually. [PMT = $2,956.30; OSB = $100,000 + $2,956.30]
5.
A variable rate loan with the initial rate of 8% per annum, compounded semi-annually,
amortized over 25 years. Payments will be made annually. The interest rate adjustment
will be made annually. Changes in interest rates will be reflected by changes in
payments. The rate prevailing at the end of Year 1 will be 11% per annum, compounded
semi-annually. Payments are to be calculated on the basis on the remaining amortization.
[pmt year 1 = $9,496.24; pmt year 2 = $12,075.73; OSB = $97,739.50]
REVIEW QUESTION 10
J. Seinfeld arranged a $225,000 mortgage loan five years ago at an interest rate of 13.5% per annum, compounded semi-annually, with a 20-year amortization, a 10-year term, and quarterly payments.
Interest rates have declined since the mortgage was arranged. Seinfeld has decided to refinance the loan and is considering two options.
Option 1
Seinfeld can refinance his existing loan over an amortization of 15 years and a 5-year term at an interest rate of 9.75% per annum, compounded semi-annually. The lender is willing to waive the prepayment penalty, but will charge $250 for administration costs. Assume the fee is paid in cash at the time of refinancing. Payments will continue to be made quarterly.
Mortgage Finance Review Questions
5
Option 2
Seinfeld can refinance his existing loan with a new lender over a 15-year amortization and a 5year term at an interest rate of 9% per annum, compounded semi-annually. Payments will be made quarterly. The prepayment penalty charge on the existing loan is 3 months' interest. Additional refinancing costs will total $1,000. Assume the fees will be paid in cash at the time of refinancing.
1)
Calculate the actual cost of refinancing under both options. Express your final solution as
an annual rate with semi-annual compounding.
[Option 1 - 9.78% per annum, compounded semi-annually Option 2 - 10.07% per annum, compounded semi-annually]
2)
On the basis of interest rates, which option should Seinfeld choose?
[Choose Option 1 since the rate is lower]
3)
What other considerations should Seinfeld take into account before making a final
decision?
REVIEW QUESTION 11
Cooperative Credit Union has agreed to lend $150,000 to Bob and Lydia in the form of a shared appreciation mortgage on a purchase price of $200,000. This loan is written at an interest rate of 9.25% per annum, compounded semi-annually with monthly payments over a 20-year amortization and 5-year term. In addition, Bob and Lydia must give the lender 45% of any capital gains realized (after selling costs) upon the sale of the house. Selling costs are estimated to be 8% of the selling price.
If Cooperative has an expected return of 14% per annum, compounded monthly and Bob and Lydia plan to sell the house at the end of the term, what rate of house appreciation does Cooperative expect to accrue? Express your answer as an effective annual rate. [11.18%]
REVIEW QUESTION 12
A lender has recently advanced a participation mortgage for $700,000 at a rate of 12% per annum, compounded monthly. The loan will be repaid with monthly payments over a 20-year amortization and a 5-year term. In addition, the lender will participate by taking 10% of the property's annual gross potential income.
If the lender expects to earn 17% per annum, compounded annually overall, calculate the anticipated gross potential rental income. [$277,451]
Mortgage Finance Review Questions
6
DETAILED SOLUTIONS FOR BUSI 221 REVIEW QUESTIONS
QUESTION 1 SOLUTION
A.
$225,000 = PMT ? a[[240, j12 = 9.797815%]]
PMT = $2,141.24 per month = $25,694.88 per year
Press 10 NOM% 2 P/YR EFF% 12 P/YR NOM% 225000 PV 240 N 0 FV
PMT
Display 10 2 10.25 12 9.797815 225,000 240 0
-2,141.244963
Gross Income = PIT/GDSR
Gross Income= $24,694.88 $2,000 0.32
Gross Income = $86,546.50
B.
GDSR
0.32 PMT $2,000 $80,000
PMT = ($80,000 ? 0.32) - $2,000 PMT = $23,600 per year = $1,966.67 per month
PV = $1,966.67 ? a[[240, j12 = 9.797815%]] PV = $206,655.83
Press 10 NOM% 2 P/YR EFF% 12 P/YR NOM% 1966.67 +/- PMT 240 N 0 FV PV
Display 10 2 10.25 12 9.797815 -1,966.67 240 0 206,655.827589
TDSR
0.40 PMT $2,000 ($275 12) ($500 4) $80,000
PMT = ($80,000 ? 0.40) - $7,300 PMT = $24,700 per year = $2,058.33 per month
PV = $2,058.33 ? a[[240, j12 = 9.797815%]] PV = $216,287.37
Mortgage Finance Review Questions
7
Press 10 NOM% 2 P/YR EFF% 12 P/YR NOM%
2058.33 +/- PMT 240 N 0 FV PV
Display 10 2 10.25 12 9.797815
-2,058.33 240 0 216,287.373886
The maximum loan is $206,655.83 under the GDSR.
QUESTION 2 SOLUTION
Original Loan
PV = $1,375 ? a[[240, j12 = 12.661289%]] PV = $119,822.54 OSB60 = $110,616.15
Press 13 NOM% 2 P/YR EFF% 12 P/YR NOM%
1375 +/- PMT 240 N 0 FV PV 119822.54 PV 60 INPUT AMORT = = =
Display 13 2 13.4225 12 12.661289
-1,375 240 0 119,822.538077 119,822.54 PER 60-60 110,616.151428
New Loan
PV = $225 x a[[780, j52 = 7.36801%]] PV = $106,169.53
Press 7.5 NOM% 2 P/YR EFF% 52 P/YR NOM% 225 +/- PMT 15 x 52 = N 0 FV PV
Display 7.5 2 7.640625 52 7.36801 -225 780 0 106,169.531071
Repay $110,616.15 - $106,169.53 = $4,446.62
Mortgage Finance Review Questions
8
QUESTION 3 SOLUTION
$120,000 = PMT ? a[[300, j12 = 7.869836%]] PMT = $916 per month
Press 8 NOM% 2 P/YR EFF% 12 P/YR NOM% 120000 PV 300 N 0 FV PMT
Display 8 2 8.16 12 7.869836 120,000 300 0 -915.856146
Option 1 FV of loan with no pmts less FV of pmts made
FV of loan with no pmts FV = $120,000(1+ i)48 = $164,228.29
Press 8 NOM% 2 P/YR EFF% 12 P/YR NOM% 120000 PV 48 N 0 PMT
FV
Display 8 2 8.16 12 7.869836 120,000 48 0
-164,228.286049
FV of pmts made
1st 40 pmts:
FV FV
= =
$94116,?73s9[[.4702,(1j1+2im=o)78.869836%]](1+imo)8
FV = $43,980.55
Final 4 pmts: FV = $500 ? s[[4, j12 = 7.869836%]] FV = $2,019.76
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- performance review questions and answers
- employee review questions for managers
- performance review questions for managers
- annual review questions for managers
- chapter 3 review questions answers
- chapter 2 review questions and answers
- performance review questions examples
- openstax psychology review questions answers
- annual review questions and answers
- peer review questions to ask
- self review questions and answers
- employee review questions for employee