Modeling Tests - Free Sample

Thank you! Interested!!

Interested. Thanks!

Interested

Interested as well thank you!

Also interested - thank you!

Also interested - thank you!

Thank you for sharing!

Yo can't dm u, on anon REPE fund test. You should clear properties, you can see the author's name.

Thank you! Very interested please!

Thank you! Very much interested!

Why the fuck is everyone saying interested, r u gonna share the model?

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.

fund is 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.

Interested

+1 SB

Very Interested

Thank you, Interested!

Saved

Thank you interested!!

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.
 

Bump

Interested. Thanks much!

Thanks for sending them over!