View the step-by-step solution to:

FIN 371 Case Study 333 Bush Street - Overview Due: By 7 pm, Thurs, May 17, 2018. Send via email to both Jim Area and Nancy Gille AND bring a he of...

This is a study case. the yellow is the answer. can you check the answer for me. thanks i need it in 3 hours and if you do it on time i will pay extra $50 to you. 1.png2 (1).png6.png5.png3.png2 (2).png4.png

1.png

FIN 371 Case Study 333 Bush Street - Overview
Due: By 7 pm, Thurs, May 17, 2018. Send via email to both Jim Area and Nancy Gille AND bring a he
of the ‘Q&A' and '10-Year Proforma' worksheets to class. Basic Overview: You work as a financial analyst for Tishman Speyer, the new owner of 333 Bush Str
investment strategy is to make improvements to the buillding and sign long-term leases with high
tenants consistent with a "core" investment. The current vacant space in the building includes 89,0
feet that was vacated following the bankruptcy of lawfirm Sedgwick, LLP in early 2018. The plan is
the investment for approximately 7‘ years. You must evaluate two alternative leasing opportunities, described as follows:
A) Iwncn (www.mtcntv) Is Interested In Ieasmg the entire 89,0 (6 square feet. I hey have submitted a pr- a 5-year term. Proposed annual rent is $751'square foot (full-service) with NO increases, but with three(3)
free rent. Capital expenses would include $75lsquare foot for tenant improvements, and $15 per square f:
lease commission. B) Tishman Speyer also has a proposal from WeWork (www.wework.com) to lease this space at 5870/qu
(full service) annual rent with $1/square foot annual increases for a lease term of ten (10) years, with NO fl
WeWork has asked for a tenant improvement allowance of $1 OOlsquare foot and lease commissions woul
$1 Bisquare foot. Summary of prospective tenant lease terms: — Twutc WeWor tam—_i—L-
WWI-law
Isa-n—m—m
magnum—n1 rd copy em. The

2 (1).png

@4B‘>B77%- FIN 371 Case Study 333 Bush Street - Q & A
Due: By 7 pm, Thurs.,May 17, 2018. Send via email to Jim Arce and Nancy Gille AND bring a hard copy of 'Q&A' and '10-Year Proforma' worksheets to class.
NO LATE WORK WILL BE ACCEPTED. Studenwame |:| Studentml:| QUESTIONS: Using the 10-year lease analysis form provided, which proposed lease has the highest Level Pay? Tenant. Lave. pay. $42.49 To which of these tenants do you recommend leasing the 89,076 square feet of vacant space? Tenant Why? Provide at least 3 non-economic reasons taken into account in making your decision. 1) WeWork provides a longer lease term than Twitch; 2) WeWork doesn't ask for free rent which may serve as a rent
trial; 3) WeWork asks for higher tenant improvement allowance which means WeWork may focus more on tenenat
experience What is one change to the proposed lease terms or investment strategy
that migt cause you to recommend the OTHER prospective tenant? Why? If the lease term of Twitch is changed from 7 years to 5 years, the level pay will be changed to $53.09, which will be
higher than WeWork's $42.49. In this case, I might choose Twitch. What is the unleveraged IRR based on each of the proposed tenant leases? (Enter the
financial infonhation—rent, free rent, tenant improvements and leasing commissions— into
the 10-Year Proformas provided. Assume a purchase price of $375 million and a sale at
end of Year 7 based on residual cap rate of 6.25%. Note: IRR templates are provided at
the bottom of 10—Year Profonhas. IRR: 7.24% Twitch 10.20% WeWork What is the IRR if the investment is leveragedupon acquisition (Year 0) with a 65% LTV loan
based on $375 million purchase price) at 4.5% interest only? IRR: 11.59% Twitch 16.99% WeWork

2 (2).png

FIN 371 case Study 333 Bush Street - Lease Analysis
Tlfllfl'l LHEE ANALYSIS (RENT INCREASE IN SEW]
“an [Easily Dunmissmn'
spam-19 Ely-mas {575.001
515.153 (515 75; {515.00}
(515.75] 515.75) (515.75; (515 75) (51375] (51575: cm;
553 25 Sfiflfi (““5751 @575) $1515:
(349.501 s59 25 $5925 sans
- 41:15 CONFIDENTIAL F‘NETLCase Smdy Splmg 2018

3.png

FIN 371 Case Study 333 Bush Street — Lease Analysis WIWDI‘k LEASE ANALYSIS {RENT INCREASES IN IDJIII]
Mac. V881 annual RIM F3
Armal Ram Inmase
Tarm Fm Rem + Dmmme
Tananl Impmamm
Luasng Gummlsslun‘
Dpsniflng mam
mamuanam m
5200 n
5 700
mm (5100 no)
Luaang Cummissluns (an: no: 0.»an mam ($15 75; 315.75) (515.75) (515.75: (515.75) (515 75) [$15.75) (515.75) 315.75;
ulal Enpandhums m (315.75)
E51575) (51-575) (57575] ($1575) (5575) E5 5 5) (5 5775) (5 5775) ,
$5525 555.25 557.25 559.25 559 25 $60.25
@591 “735 “QB-W- Tmal Cash Flaw PSF 56125 $62.25 ooNnDENmL FIN3?1_Case sum Sprmg 2013

4.png

FIN 371 Case Study
333 Bush Street - Lease Analysis Summary up»: I um Fay Analynll Laval Pa, Fh, 13.15 sauna , , , 95134300 1515,00: 5217,53 Fli. 18-15 59.076 10.0 . . 57‘5.0D 556551320 (5100.00: (515.00] 5235.15 Sprmg 2018
CONFIDENTIAL F‘NSTLCase Study

5.png

FIN 271 case Slaw
333 311571 Street 7 Twihch
:lD Vur Preterm: mu mm» 5.... ma mm MS! 5...,“ 1217.151
mu 1.7055 vur :1 rm 2 rm 5 Yur 5 rm 5 far 5 run 10 var 1:1 'Fm—Trflzwn— 3:5: mm Mus 5m 70011159075171 anuwan Munuvewamw 5m rummlemu
MIR-0159.177551] 5171550155 555: Ram-1| Raw: Expensu ngmbur'iwlcm Raw: Nn Parlmglmarwe Miscvum \nwn‘e
Erlewveemss Reva»: 4599 15120.25: £REF‘ 50151 40:71 55:71 45251 401:1 kREFI 40:71 45151 10ng
7500 5550.700 5550700 5550.700 5.550.750 5550.700 5.550.700 5.550.700 [2 9s) [1.512.5931 5557' £5151 465571 5557' 45,251 45551 455:1 40:71 471151 5550
[1 511 1991.290 1193000) (15 751 [1.570.170 W 27.525593 NEH HEN kFEF‘ fiEF‘ 0W1 kREFI IREF‘ WI EWI
154 593.414 071171 465571 5057' men 45551 1:11er llREF‘ 411m 5550
129 704.215 751.579 792.145 523.532 555.755 591.057 925599 953757 1.002.715 1.042410
020 1 .155 113471 115.575 120.351 123.993 127.713 131.544 135490 159555 143.742 145.054
5353 29.2 .555 «5::- 45151 45:71 5057' 55:51 45551 kREFI 40:71 451:1 hREFI nun-“.11.---“ 05mm; 9550713251091)
Unmiu Jamlunal
550.1015 Murmur: CummunAm
Manuuunm: Fm
ndwrliflmwskfiwil
1man5e
5551 hummus 150 955.715 1015257 1043.745 1.077.115 1109.432 1.142.715 1.175.995 1.212305 1.243575 1.255135 1.324720
217 1.155.530 1222435 1259105 1.295.551 1335.755 1.375551 1.417137 1. 5551 11.0.1541 1.545544 1.555000
251 1.371.744 1412.595 1455.253 1.495.942 1543.910 1.590.227 1.537.934 1.557072 1.737554 1.759.515 1.543.503
103 552.355 579237 595.514 514.511 532.945 551.335 571.494 591.539 712.355 733.750 755.773
053 3 . 99 war- mm #5511 4057' 45551 45551 55ng 4057' mm 1-5ng 050 437.514 450945 454.477 475.411 452.754 507.545 522.773 535455 554510 571.245 555.356
137 .753 750155 791.201 514.937 539.355 554.557 590.504 917219 944735 973.075 1.002.270
553 1212.755 3277041 3341.552 3.409.431 3477.522 3.547.174 3.515.115 1590450 3.754290 3.539.575 3.915.357
Asmimn F005 057 477.553 491.590 505.547 511.545 537.501 553.525 570.235 557342 504953 523.111 541.505
1015‘0W51ir10 bum; 1709 {333700 HFEF' 4W1 457:0 kREF' 41E“ 45551 kITEFI IREF' NEH 517:“ Nu 554mm Foam: M5 ! 5 H 19.901255 3!!!! FREE E!!! El!!! HEP E W IF!!! ‘7!!! ER? FEE! Cami 55115104710
rumlmmvumenu 422 2.302450 «0::- 40151 45:11 4057' 45:51 «51:1 1:0ng upgr- «51:1 40er
rmmlmpr [59.57550 7500 5550.700
Leasing Can-mmum 171 933.191 4527' «51:1 40:11 5057' «02:1 «01:1 1:5ng uncr- 451:: 40er
1min: cum [59.075 an 1550 1.335.140
Cauilnl Rama 013 53.732 55244 55531 91495 94.241 97.055 99.950 102950 105059 109.251 112.529
15:51:47: Wfifi—Mfi—flm—Hflfi—fim—fim—flm—Wfil—flm— Auuuumuum- cash Raw 1555 5555.045 55:71 071171 465571 5057' men 45551 1:11er llREF‘ 471151 5550 IRR IEMI'MTES 9.. Natmuu
hmncuhm . .m- him gamma:
L05!- m Punch" 0 s - Lam Balm: N51 Hts-dual mm Mama-5:151 15:41 run L19: Hm. 041mm
Immimentfin cm Haw (3750000001 5555.045 «557' 55151 #5511 5557' «5251 00m ma finial-115410177455 Lumandmmmu 24.750000 110555.750] [109557501 {105557501 110.555.7503 [109557501 [10.555750] {10.555750} 1 muscwa.15m5alm=
N51 Residual mm Nalfinmal '0151NnC5wFlow 1 (1311500001 F [274037051 RFEF' NEH H331 kFEF‘ “EH WW www.13- CONFIDENTIAL HN37LCm 51001-

6.png

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question