Global Real Estate Capital Markets Problem 1 [10 points]You want to buy a house for main...

Question

Global Real Estate Capital Markets Problem 1 [10 points] You want to buy a house for main residence and have the following four choices of mortgage with monthly payments. Suppose that your marginal...

Global Real Estate Capital Markets

Problem 1 [10 points]

You want to buy a house for main residence and have the following four choices of mortgage with monthly payments. Suppose that your marginal tax rate is 25% and the market index will
stay 10.5% after year 5.

[5 points]
If you hold the loan for the entire term, what is the

annual

effective cost of each mortgage
before-tax?

[5 points]
If you hold the loan for the entire term, what is the

annual

effective cost of each mortgage
after-tax?

Problem 2 [10 points]

Suppose that you bought a house in Los Angeles, California in 2006Q1 and the house price was $600,000. Your LTV is 95%, so you borrow a fixed rate mortgage (FRM) of $570,000. The loan term is 30 years with interest rate 6% and monthly payments. Assuming the house price dropped 35% in Los Angeles during the period of 2006Q1 to 2009Q1.

[1 points]
What is the value of your house at the end of 2009Q1?

2.
[1 points]
What is your loan balance at the end of 2009Q1 (36 months later)?

3.
[2 points]
Which is the better choice from economic point of view and why?

a. Keep the house and continue to pay mortgage every month

b. Default and walk away

Suppose that you borrowed a price level adjusted mortgage (PLAM) in 2006Q1 instead of borrowing a FRM and assuming that the first loan balance adjustment will occur at the end of 2009Q1 and everything else is equal.

4.
[1 points]
What is your adjusted loan balance at the end of 2009Q1 (36 months later)?

5.
[2 points]
Which is the better choice from economic point of view and why?

a. Keep the house and continue to pay mortgage every month

b. Default and walk away

6.
[3 points]
What is the implication for PLAM to the recent (2007-2010) housing crisis?

Problem 3

[10 points]

You decide to buy a house of $250,000 with loan amount of $200,000. The lender offers the following three SAM choices with $5,000 origination cost for each choice:

(1) $200,000; 15 years; monthly payment; 0% interest rate; 50% of appreciated value of the property in year 10. In addition, if the property value declines in year 10, the lender pays nothing.

(2) $200,000; 15 years; monthly payment; 3% interest rate; 50% of changed value of the property in year 10

(3) $200,000; 15 years; monthly payment; 5% interest rate; 25% of changed value of the property in year 10.

The housing market conditions:

a) Home price will appreciate 50% in total for the next 10 years;

b) Home price will stay the same for the next 10 years

c) Home price will decline 50% in total for the next 10 years.

Questions:
If you hold the loan for only 10 years,
please find out the best choice for each market condition.

Problem 4 [10 points]

ABC Bank originates a pool of containing 100 15-year fixed-rate mortgages with loan amount of $100,000 each. All mortgages in the pool carry a rate of 6% with

annual

payments. Suppose that the servicing fee is 0.5%. ABC Bank would like to sell the pool to investors via Mortgage Pass Through (MPT) security. Suppose that 100,000 shares will be issued and the market interest rate is 5.5%

Questions

[3 points]
Assume that there are no prepayment and no default, how much an investor would like to pay for each share of the MPT security?

[3 points]
What is the price of each share of the MPT if there are a constant annual prepayment rate of 10% and no default?

[3 points]
What is the price of each share of the MPT if there are a constant annual default rate of 10% (assuming the recovering rate is 50%) and no prepayment?

[1 points]
Please briefly discuss your findings

Problem 5 [10 points]

The Green Bank originates a pool of containing 100 30-year fixed-rate mortgages with loan amount of $250,000 each. All mortgages in the pool carry a rate of 6.5% with
monthly payments. The servicing fee is
0.05%
each month. The Green Bank would like to sell the pool to investors via IO/PO Strips. Suppose that they issue 150,000 shares of IO/PO Strips and the market interest rate is 6%.

Questions

[3 points]
Assume that there are no prepayment and no default, how much an investor would like to pay for each share of the IO/PO Strips?

[3 points]
What is the price of each share of the IO/PO Strips if there are a constant prepayment rate of 1.5% every month and no default?

[3 points]
What is the price of each share of the IO/PO Strips if there are a constant default rate of 1.5% every month (assuming the recovering rate is 50%) and no prepayment?

[1 points]
Please briefly discuss your findings.

Problem 6 [10 points]

Questions

1.
[5 points]
Suppose that there are no prepayment and no default, what are the cash flows for Class A, Class B and Class Z bonds? What is the IRR for the issuer?

2.
[5 points]
Suppose that there are 15% prepayment and no default, what are the cash flows for Class A, Class B and Class Z bonds? What is the IRR for the issuer?

Problem 7 [10 points]

Questions

1.
[4 points]
Suppose that there are no prepayment and no default, what are the cash flows for Class A, Class B and Class Z bonds? What is the IRR for the issuer?

2.
[4 points]
Suppose that there are 10% prepayment and no default, what are the cash flows for Class A, Class B and Class Z bonds? What is the IRR for the issuer?

3.
[2 points]
Please briefly discuss your findings.

Problem 8 [15 points]

1.
[5 points]
What is the long-standing real estate risk premium puzzle? What is the real estate mixed assets allocation puzzle? Do these puzzles really exist? Discuss the causes of these puzzles.

2.
[5 points]
Below are Sharpe ratios for both the financial and real estate markets. Briefly discuss their difference and explain why the real estate should have its own Sharpe ratio.

3.
[5 points]
Cheng, Lin and Liu (2017-JRER) develop the mixed-asset portfolio by extending the Modern Portfolio Theory (MPT) as follows,

Briefly
discuss the difference between these two models and explain why the real estate should have its own asset allocation model.

Problem 9 [15 points]

1.
[5 points]
In practice, one of the most important factors to control for credit risk is loan-to-value (LTV) ratio. Is this a good practice? Why?

2.
[5 points]
Bian, Lin and Liu (2018b) derive the following LTV bias for the Interest-Only (IO) mortgage:

Describe what , , , and stand for.

3.
[5 points]
In a depressing market with extremely high time-on-market for real estate sellers, why are transaction prices noisy?

ree6327-final-assignment-2dvgnbea.docx

Answered 3 days AfterJun 14, 2022

Prince · Accepted Answer

Question 4 a
	Particular	Amount
	No. of Shares to be Issued	100,000.00
	Total amount of Loan	$10,000,000.00
	Total Servicing Fees	$50,000.00
	Annual Payments which will be received	$1,029,627.64
	Present Value of Annual Payments	$10,334,970.77
	Present Value of Net Cash Flows	$10,284,970.77
	Price paid by Investor	$102.85
Question 4b
	Loan Schedule
	Year	Opening 
Balance	Payment	Interest	Principal 
Repayment	Balance 
before 
Prepayment	Prepayment	Closing 
Balance	Total 
Cash 
Inflow	Discounting 
Factor	PV
	$1	$10,000,000	$1,029,628	$600,000	$429,628	$9,570,372	$957,037	$8,613,335	$1,986,665	0.9479	$1,883,095
	$2	$8,613,335	$1,029,628	$516,800	$512,828	$8,100,508	$810,051	$7,290,457	$1,839,678	0.8985	$1,652,864
	$3	$7,290,457	$1,029,628	$437,427	$592,200	$6,698,257	$669,826	$6,028,431	$1,699,453	0.8516	$1,447,278
	$4	$6,028,431	$1,029,628	$361,706	$667,922	$5,360,509	$536,051	$4,824,458	$1,565,679	0.8072	$1,263,842
	$5	$4,824,458	$1,029,628	$289,467	$740,160	$4,084,298	$408,430	$3,675,868	$1,438,057	0.7651	$1,100,307
	$6	$3,675,868	$1,029,628	$220,552	$809,076	$2,866,793	$286,679	$2,580,113	$1,316,307	0.7252	$954,646
	$7	$2,580,113	$1,029,628	$154,807	$874,821	$1,705,293	$170,529	$1,534,763	$1,200,157	0.6874	$825,032
	$8	$1,534,763	$1,029,628	$92,086	$937,542	$597,222	$59,722	$537,499	$1,089,350	0.6516	$709,819
	$9	$537,499	$569,749	$32,250	$537,499	$0	$0	$0	$569,749	0.6176	$351,894
	Total PV										$10,188,776
	Net Cash Flow										$10,138,776
	Price										$101
Question 4c
	Particular	Amount
	No. of Shares to be Issued	100,000.00
	Total amount of Loan	$10,000,000.00
	Total Servicing Fees	$50,000.00
	Annual Payments which will be received	$1,029,627.64
	Default	$102,962.76
	Receovery of Default	$51,481.38
	Net Annual Payments received	$978,146.26
	Present Value of Annual Payments	$9,818,222.23
	Present Value of Net Cash Flows	$9,768,222.23
	Price paid by Investor	$97.68
Question 5 a
	Particular	Amount
	No. of Shares to be Issued	150,000.00
	Total amount of Loan	$25,000,000.00
	Total Servicing Fees	$12,500.00
	Monthly Payments which will be received	$158,017.01
	Monthly Payments Net of Servicing Fees	$145,517.01
	Present Value of Annual Payments	$24,271,016.33
	Price paid by Investor	$161.81
Question 5b
	Year	Opening 
Balance	Payment	Interest	Principal 
Repayment	Balance 
before 
Prepayment	Prepayment	Closing 
Balance	Total 
Cash 
Inflow	Discounting 
Factor	PV
	$1	$25,000,000	$158,017	$135,417	$22,600	$24,977,400	$374,661	$24,602,739	$520,178	0.9950	$517,590
	$2	$24,602,739	$158,017	$133,265	$24,752	$24,577,986	$368,670	$24,209,317	$514,187	0.9901	$509,083
	$3	$24,209,317	$158,017	$131,134	$26,883	$24,182,433	$362,737	$23,819,697	$508,254	0.9851	$500,705
	$4	$23,819,697	$158,017	$129,023	$28,994	$23,790,703	$356,861	$23,433,843	$502,378	0.9802	$492,454
	$5	$23,433,843	$158,017	$126,933	$31,084	$23,402,759	$351,041	$23,051,718	$496,558	0.9754	$484,328
	$6	$23,051,718	$158,017	$124,863	$33,154	$23,018,564	$345,278	$22,673,286	$490,795	0.9705	$476,326
	$7	$22,673,286	$158,017	$122,814	$35,203	$22,638,082	$339,571	$22,298,511	$485,088	0.9657	$468,445
	$8	$22,298,511	$158,017	$120,784	$37,233	$22,261,278	$333,919	$21,927,359	$479,436	0.9609	$460,683
	$9	$21,927,359	$158,017	$118,773	$39,244	$21,888,115	$328,322	$21,559,793	$473,839	0.9561	$453,039
	$10	$21,559,793	$158,017	$116,782	$41,235	$21,518,558	$322,778	$21,195,780	$468,295	0.9513	$445,512
	$11	$21,195,780	$158,017	$114,810	$43,207	$21,152,573	$317,289	$20,835,285	$462,806	0.9466	$438,099
	$12	$20,835,285	$158,017	$112,858	$45,159	$20,790,125	$311,852	$20,478,274	$457,369	0.9419	$430,798
	$13	$20,478,274	$158,017	$110,924	$47,093	$20,431,181	$306,468	$20,124,713	$451,985	0.9372	$423,609
	$14	$20,124,713	$158,017	$109,009	$49,008	$20,075,705	$301,136	$19,774,569	$446,653	0.9326	$416,529
	$15	$19,774,569	$158,017	$107,112	$50,905	$19,723,664	$295,855	$19,427,809	$441,372	0.9279	$409,557
	$16	$19,427,809	$158,017	$105,234	$52,783	$19,375,026	$290,625	$19,084,401	$436,142	0.9233	$402,690
	$17	$19,084,401	$158,017	$103,374	$54,643	$19,029,758	$285,446	$18,744,311	$430,963	0.9187	$395,929
	$18	$18,744,311	$158,017	$101,532	$56,485	$18,687,826	$280,317	$18,407,509	$425,834	0.9141	$389,271
	$19	$18,407,509	$158,017	$99,707	$58,310	$18,349,199	$275,

Global Real Estate Capital Markets Problem 1 [10 points] You want to buy a house for main residence and have the following four choices of mortgage with monthly payments. Suppose that your marginal...

Global Real Estate Capital Markets

Answer To: Global Real Estate Capital Markets Problem 1 [10 points] You want to buy a house for main residence...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	31	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	1	2	3