Question

In: Accounting

Consider a 100,000 sq. ft. building that will be acquired (at price $0) and demolished by...

Consider a 100,000 sq. ft. building that will be acquired (at price $0) and demolished by local government at the end of 15 years.  Assume the building is fully leased building under an absolute net lease structure (all expenses paid by tenant); Consider 2 leases:

      15 year lease at $15/ft./yr.

      5 year lease at $15/ft./yr.

Suppose that $15 is the market rate and that the forecasted rent growth rate is 0% . Also suppose that the discount rate for contractual lease cash flows (corporate bonds) is 7%, regardless of maturity, and that there is no TI at the end of each lease.

a) Under which lease is the building worth more?  Why?

b) What is the value of the building under the first scenario? Suppose you know that the market will pay $11.8 mil.  for the building under the second scenario.  What is the discount rate for speculative lease cash flows? (Hint: year 1-5 cash flows in the second scenario should be discounted at the bond rate, since they are under contract. Find the PV of the speculative cash flows (years 6-15) and then find the discount rate consistent with that PV.)  

c) What are the respective cap rates under the two lease structures?

Solutions

Expert Solution

A.) Under which leasse building worth more as follows:-

First 5 years:-

Lease rent = 100000 * 15 sq. ft. = 1500000

= 1500000 *  Present value of 7% for 5 years

= 1500000 * 4.10 = 6150000

Second for 15 years:-  

Lease rent = 100000 * 15 sq. ft. = 1500000

= 1500000 *  Present value of 7% for 15 years

= 1500000 * 9.108 = 13662000

In case of 15 years building worth more as per above calculations.

B.) 1.) Value of building under first scenario is calculated as above you can see that.

2.) Discount rate for speculative cash flows as follows:-

We will assume here period for 15 years as per hint given under question.

For first 5 years = Discount rate is 7 % for 5 years * 1500000

= 4.1 * 1500000 = 6150000

Now remaining cashflow balance is 5.65 m (11.8 m - 6.15 m)

Now find out discounting rate for next 10 years (i.e. 6 to 15) so that we will get above cash flow i.e. 5.65m.

Hence we have to use trial & error method to find out discounting rate to get cashflow of 5.65 m in next 10 years as follows:-

We assume two rates for discounting = 1.) 9% and 2.) 11%

1.) Discounting rate 9% for 10 years (6-15) i.e. = 4.17

So amount of present value of cash flows = 1500000 * 4.17 = 6255000

( PV of cashflow is more than 5.65 m hence 9 % is not adequate rate)

2.) Now evaluate 11 % rate for 10 years (6-15) hence discounting rate is = 3.495

so amount of present value of cash flows = 1500000 * 3.495 = 5242500

( PV of cashflow is less than 5.65 m hence 11% is not adequate rate)

Now we use formula to find correct discounting rate is as follows :-

= 9% + { (6255000 - 5650000) / 1012500 } * (11-9)

= when we solve above equation we got 10.19% as correct discounting rate.

Note:- Above amount 1012500 came as follows ( add both the amounts) :-

9% = 6255000 - 5650000 = 605000

11% = 5650000 - 5242500 = 407500

  


Related Solutions

Consider the following pro forma for the next 4questionsPotential Gross Income 100,000 sq. ft...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10...
Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $  ...
Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10 per $100 of R.C.) $          (4,000) $    (354,800) Estimated Net...
Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $  ...
Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10 per $100 of R.C.) $          (4,000) $    (354,800) Estimated Net...
Price Bedroom Bathroom Cars SQ FT 298,000 3 2.5 0 1,566 319,900 3 2.5 0 2,000...
Price Bedroom Bathroom Cars SQ FT 298,000 3 2.5 0 1,566 319,900 3 2.5 0 2,000 354,000 3 2 2 0 374,900 4 2.5 0 2,816 385,000 4 2 0 0 389,000 3 2.5 0 2,248 399,000 4 3 0 2,215 415,000 3 2.5 0 3,188 444,900 3 2 0 2,530 450,000 3 2 0 1,967 465,000 4 3 0 2,564 340,000 4 2.5 0 2,293 275,000 3 2.5 2 1,353 425,000 3 2 0 1,834 250,000 3 2.5 0...
Price (thousands of $) Size (sq. ft.) # of Bedrooms # of Baths Distance to Town...
Price (thousands of $) Size (sq. ft.) # of Bedrooms # of Baths Distance to Town Center Garage Dummy (1=garage; 0=no garage) Pool Dummy (1=pool; 0=no pool) 271.8 2100 2 2.5 9 1 0 221.1 2300 3 1.5 18 0 1 266.6 2400 4 2 13 1 0 292.4 2100 4 2 14 1 0 209 1700 2 1.5 8 1 0 270.8 2500 6 2 7 1 0 246.1 2100 4 2 18 1 0 194.4 2300 2 2...
0 Bedroom Bathroom Cars SQ FT 298,000 3 2.5 0 1,566 319,900 3 2.5 0 2,000...
0 Bedroom Bathroom Cars SQ FT 298,000 3 2.5 0 1,566 319,900 3 2.5 0 2,000 354,000 3 2 2 0 374,900 4 2.5 0 2,816 385,000 4 2 0 0 389,000 3 2.5 0 2,248 399,000 4 3 0 2,215 415,000 3 2.5 0 3,188 444,900 3 2 0 2,530 450,000 3 2 0 1,967 465,000 4 3 0 2,564 340,000 4 2.5 0 2,293 275,000 3 2.5 2 1,353 425,000 3 2 0 1,834 250,000 3 2.5 0...
Standard Quantity Standard Price (Rate) Standard Unit Cost Direct materials (cork board) 3.50 sq. ft. $...
Standard Quantity Standard Price (Rate) Standard Unit Cost Direct materials (cork board) 3.50 sq. ft. $ 2.00 per sq. ft. $ 7.00 Direct labor 1 hrs. $ 13.00 per hr. 13.00 Variable manufacturing overhead (based on direct labor hours) 1 hrs. $ 0.60 per hr. 0.60 Fixed manufacturing overhead ($67,500 ÷ 150,000 units) 0.45 Bullseye has the following actual results for the month of September: Number of units produced and sold 130,000 Number of square feet of corkboard used 470,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT