Most Helpful

Modeling Exercise 1

All inputs below should be flexible assumptions

Development Program
* 200,000 SF office building
* Land purchase price: $20M ($100 per FAR)
* Closing Costs: 1% of purchase price
* Hard Costs: $300 psf
* Soft Costs: (excluding TI's, LC's and Debt): 15% of hard costs
* TI's: $60 psf - paid at tenant occupancy
* LC's: $18 psf - paid six months before tenant occupancy

Construction & Lease-up
* 24 Month Construction Period, beginning at land close date
* Costs spent evenly over construction period
* 2 Tenant Lease-up of equal size (one tenant at construction completion; one 6 months after completion)
* Lease up to 95%
* Rent $4.25 NNN
* Free Rent: 3 months free
* Annual rental bumps: 3%
* Annual Operating Expenses during Lease-Up: $16 psf

Debt Assumptions
* 60% LTC
* Rate: 5% all-in interest rate
* All equity drawn first; then debt
* Use available cash flow to offset debt costs, as available

Hold Period:
* 5 years after stabilization
* Exit Cap Rate: 5.5%
* Transaction Fees: 1.5%

Joint Venture Structure
* LP invests 95% of required equity / GP invests 5%
* GP receives a 20% promoted interest over a 12% 
IRR to the LP

Required Output
* Required Project Equity, Net Profit, IRR and ROC (Return on Capital)
* Required LP (after promote) Equity, Net Profit, IRR and ROC (Return on Capital)

 

Best bet is to use a free modeling service (i think someone mentioned Kahr real estate) and learn the concepts there and then apply them to these tests. If all you ever do is look at test prompts + the answer key, you'll never learn anything.

Save these and use them as timed tests of your skills. Keep in mind most of these are administered over a short time period - they're not meant to be complicated at all

 

Instructions:

-        E-mail the responses no later than 4.5 hours after receiving the test.

Case Study:


Certain affiliates of [REPE Fund] are considering the acquisition of a 350,000 SF, Class A office campus in suburban Dallas, TX (the “Property”).  Completed in 2002, the Property is comprised of 5 office buildings, each with 70,000 NRSF.  Only one of the five buildings is currently occupied, leased on a NNN basis to Tech Corp., a major credit rated tenant, with a remaining lease term of 15 years with an annual rent of $1.12 million ($16.00 per SF), escalating at 2.5% annually.


[REPE Fund]’s business plan is to lease the four remaining buildings and sell the property three to five years after the acquisition.  According to a market study prepared by a national research firm, it is likely to take 24 months to complete the lease-up. Today, average market rents are $13.50 per SF (NNN). Typical lease terms are for five ayears with tenant improvement allowances of $25 psf, leasing commissions of $5 psf and lease rates increase 3.0% annually. Local leasing brokers expect tenants to lease an entire building at a time. Assume expenses for the property of $8.0 psf and a property management fee of 3.0% of EGR. Market vacancy is 12.5%.

According to discussions with several local brokers, based on the age and quality of the building, likely tenant profile, and its location, the Property is likely to sell for a 7.50% cap rate and similar stabilized properties in the surrounding submarket generally trade in the $140 to $160 per square foot range.


The negotiated purchase price for the Property is $37.5 million.  In addition, [REPE Fund] is expected to incur closing costs (for legal counsel and third-party consultants) of $500k.  [REPE Fund] has obtained several loan quotes to finance the acquisition of the Property.  The most favorable quote was 65% LTV with 65% of future funding for TI / LC / Cap Ex, fixed rate of 4.50% (actual / 360), five year term, interest only for the first 30 months with a 25 year amortization thereafter.

Please create a monthly cash flow model, which reflects the assumptions and business plan outlined above and calculates the levered and unlevered returns of the proposed investment to [REPE Fund]. Create a summary page for key assumptions, annual cash flows, return metrics (Profit, IRR, Investment Multiple), any other metrics you would use to evaluate an investment, and a sensitivity analysis.

 
[Comment removed by mod team]
 

fund itsts evaluating a 125 unit stabilized apartment building located in a thriving emerging submarket of DC as a potential acquisition. Your task is to put together a 1 page financial model in excel which evaluates the investment opportunity. The key assumptions are stated on the next page. Please make sure your analysis clearly indicates which cells are assumptions vs. formulas in your spreadsheet. Your base case underwriting should solve for a purchase price which results in a 15.0% levered IRR over a 5 year hold period. The cash flows should show how you get from Effective Gross Revenue down to NOI, down to your unlevered and levered cash flows.

Please make sure to calculate:

 Unlevered IRR and Cash-on-Cash Returns

 Levered IRR and Cash-on-Cash Returns

 Equity Multiple

 Going-in Cap Rate and Stabilized Cap Rate

 Purchase Price PSF

 Sale Price PSF

 DSCR

Additionally please include a sensitivity table which evaluates the levered IRR and equity multiple at different exit cap rates and purchase prices. Assume there are no transaction / sales costs as a part of this analysis. You will have 45 minutes to complete the analysis. Please complete as much as you can during that time period.

 

Anonymous Debt Fund - Simple Test

You are an institutional real estate investor who has the opportunity to purchase a 85% leased, 326,642
square feet office building in Irvine, CA. Comparable properties have sold between $270 and $300 per
square foot (PSF), and you think a fair price for this property is $300 PSF.


Based on your underwriting, you estimate that the property’s Net Operating Income (NOI) will be
$6,500,000 in Year 1 and will grow by 6% in Year 2, 5% in Year 3, 4% in Year 4, and 3% thereafter. You
estimate that it will cost $0.75 per square foot per year in capital costs (tenant improvements, leasing
commissions, and other capital costs) to keep the building fully leased. Your plan is to sell the building
after 5 years (assume you can sell the property at a 7.25% cap rate and total sales costs of 2.00% of the
gross price).


Your plan is to leverage the investment with a bank loan. A regional bank has provided you with a quote
for a 65% loan to value (LTV), five-year, 30-year amortization loan at a 3.25% rate with a 1.00%
origination fee.


Questions:
1) What is the proposed investment’s unleveraged IRR?
2) What is the proposed investment’s leveraged IRR?
3) Bonus: What is the Bank’s Year 1 Debt Yield?
4) Bonus: What is the IRR of the bank’s loan?
5) Bonus: Explain why the IRR of the bank’s investment is different, if at all, from the quoted 3.25%
rate.
 

 

Ex porro quam sint recusandae quo asperiores amet. Qui perferendis sunt soluta in. Et doloremque porro maiores excepturi dolorem quasi est.

Enim aut et quam. Dolor quam hic culpa aut.

Molestias est voluptatibus praesentium quo et. Nostrum animi assumenda dolor voluptas recusandae asperiores amet. Corrupti sed consequatur dolorum quis. Aperiam occaecati et et.

Modi nihil quo sit quos alias. Omnis iste est ipsam dolore architecto quia. Sunt reiciendis esse aut voluptas qui ea inventore. Nulla corrupti voluptas enim nobis. Numquam eum et consequuntur voluptas fuga. Quidem saepe sed minus quae.

 

Qui quia rerum ea vero debitis et nisi sed. Voluptas quam culpa et et. Voluptatum omnis deserunt vel atque ullam. Nesciunt eaque nostrum natus consequatur error.

Repellat tempora repellat voluptas tempora consequatur rem. Incidunt dolorum incidunt dolor ratione qui ipsa sunt. A ut perspiciatis sed sint. Non quos fuga eaque nesciunt maiores omnis commodi. Quidem eos molestiae quam autem ea magni praesentium.

Atque soluta nam voluptatem incidunt et rerum sit nihil. Commodi tenetur sunt velit numquam est veniam ut. Voluptate cupiditate repudiandae ut doloremque ratione. Dolorem iusto enim molestias et vitae. Possimus dolores quae voluptas.

Aliquam quasi ut alias distinctio placeat. Minima quidem asperiores accusamus nisi voluptas voluptatem aperiam nobis. Qui saepe maxime laudantium non voluptas est. Iure et aut assumenda perspiciatis. Recusandae eligendi dolorem est inventore quia cupiditate officia expedita.

[Comment removed by mod team]

Career Advancement Opportunities

June 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Perella Weinberg Partners New 98.9%
  • Lazard Freres 01 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

June 2024 Investment Banking

  • Harris Williams & Co. 19 99.4%
  • Lazard Freres 06 98.9%
  • JPMorgan Chase 09 98.3%
  • William Blair 03 97.7%
  • Morgan Stanley 04 97.1%

Professional Growth Opportunities

June 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Goldman Sachs 16 97.7%
  • Moelis & Company 05 97.1%

Total Avg Compensation

June 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (23) $378
  • Associates (95) $261
  • 3rd+ Year Analyst (14) $181
  • 2nd Year Analyst (69) $168
  • Intern/Summer Associate (34) $167
  • 1st Year Analyst (207) $159
  • Intern/Summer Analyst (152) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
bolo up's picture
bolo up
98.8
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”