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.
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_iL- WWI-law Isa-nmm magnumn1 rd copy em. The @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 nancial infonhationrent, 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 10Year 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 FIN 371 case Study 333 Bush Street - Lease Analysis Tll'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 S (""5751 @575) $1515: (349.501 s59 25 $5925 sans - 41:15 CONFIDENTIAL F'NETLCase Smdy Splmg 2018 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' Dpsning 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 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 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 'FmTrzwn 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 wn'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' EF' 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 ndwrlimwskwil 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: WMmHmmmWlm 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 Immimentn cm Haw (3750000001 5555.045 557' 55151 #5511 5557' 5251 00m ma nial-115410177455 Lumandmmmu 24.750000 110555.750] [109557501 {105557501 110.555.7503 [109557501 [10.555750] {10.555750} 1 muscwa.15m5alm= N51 Residual mm Nalnmal '0151NnC5wFlow 1 (1311500001 F [274037051 RFEF' NEH H331 kFEF' "EH WW www.13- CONFIDENTIAL HN37LCm 51001
