Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. BASE CASE Complete the waterfall shown in Exhibit 10 using the benchmarks assumptions outlined in the case. Under these assumptions, calculate the expected return

1. BASE CASE Complete the waterfall shown in Exhibit 10 using the benchmarks assumptions outlined in the case. Under these assumptions, calculate the expected return to Wildcat and its limited partners and compare those returns to the property-level return on Financial Commons if it is sold after three years. Returns to Wildcat should be calculated without including the management fee. In the Excel file, I provide notes for some cells on how to calculate those values. If you find any errors in my cell descriptions, please let me know.

2. For each of the following scenarios, recalculate spreadsheets for Exhibits 9 and 10. With the exception of the changes noted below, keep the benchmark assumptions constant. Each scenario is to be recalculated independently; that is, each scenario is to be treated as a distinct variation from the benchmark. Assume that outside investors will become partners with Wildcat only if they believe they will receive an IRR of at least 20% and Wildcat will only close on the property if it believes it can earn a 50% IRR. Discuss whether or not the deal will proceed. Scenario A After more careful underwriting, the life insurance company offers a reduced LTV of 60% and an interest rate of 7%. Assume a 3-year holding period Scenario B The outside investors are nervous about the economic climate. As a result, they demand the following investor-friendly changes to the waterfall structure. Assume a 3-year holding period.

a. Outside investors will provide only 90% of the required equity

b. Outside investors will receive a 10% preferred return

c. Outside investors will receive a 12% IRR preference (This means that at reversion, after invested capital has been return to the investors and to Wildcat, the outside investors will receive additional cash until they achieve a 12% IRR over the lifetime of the investment. Remaining cash flow will then go through the promote)

d. Cash flows in the promote structure will be split 80/20 rather than 70/30 (both reversion and operational cash flows)

3. Evaluate the benchmark assumptions Zaski made. Would you have made different assumptions? What do you think is the fair market price for Financial Commons? Explain why your answer does or does not differ from $10,400,000 (calculating the going-in cap rate or discussing the projected price appreciation in 3 years may be helpful).

4. If you were an outside investor being approached by Wildcat and were shown the financial projections outlined above, what additional information would you seek before investing?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Jeff Madura

13th Edition

0357130790, 978-0357130797

More Books

Students also viewed these Finance questions

Question

=+a. Test for differences among the true average PAPUFA

Answered: 1 week ago

Question

What is adverse impact? How can it be proved?

Answered: 1 week ago