A lender bank has agreed senior debt terms to a client at a loan to value...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A lender bank has agreed senior debt terms to a client at a loan to value ratio of 50% to part finance a value-added real estate investment, which has some initial vacancy and is expected to be fully let in year 4, at which time it will be sold. The clients after senior debt net cash flow is shown below. After Senior Debt only Net Cash Flows Year 0 Year 1 Year 2 Year 3 Year 4 -6,100,000 71,464 113,921 152,251 9,697,462 DSCR (Before Capex) 1.55 1.67 1.79 1.95 You have been asked by the client to look at the potential to increase the debt facility further, by including a lookback mezzanine structure. Current mezzanine providers for this type of asset look for a minimum 10% IRR exclusive of fees, but the facility must be cash flow positive out of operating cash flows, after applying the mezzanine finance structure. You are required to: a) Propose terms you would recommend for the mezzanine piece sufficient to meet the client's minimum required rate of return of 14.50%. b) Show the client's 4 year cash flow after adding in the mezzanine piece and also show the mezzanine provider's 4 year cashflow, ensuring you fully explain all your inputs and calculations. c) If the client now required a minimum geared return of 15% and the mezzanine facility must remain cash flow positive out of operating cash flows, explain how the senior and mezz lending structure might be modified to provide an equitable outcome? A lender bank has agreed senior debt terms to a client at a loan to value ratio of 50% to part finance a value-added real estate investment, which has some initial vacancy and is expected to be fully let in year 4, at which time it will be sold. The clients after senior debt net cash flow is shown below. After Senior Debt only Net Cash Flows Year 0 Year 1 Year 2 Year 3 Year 4 -6,100,000 71,464 113,921 152,251 9,697,462 DSCR (Before Capex) 1.55 1.67 1.79 1.95 You have been asked by the client to look at the potential to increase the debt facility further, by including a lookback mezzanine structure. Current mezzanine providers for this type of asset look for a minimum 10% IRR exclusive of fees, but the facility must be cash flow positive out of operating cash flows, after applying the mezzanine finance structure. You are required to: a) Propose terms you would recommend for the mezzanine piece sufficient to meet the client's minimum required rate of return of 14.50%. b) Show the client's 4 year cash flow after adding in the mezzanine piece and also show the mezzanine provider's 4 year cashflow, ensuring you fully explain all your inputs and calculations. c) If the client now required a minimum geared return of 15% and the mezzanine facility must remain cash flow positive out of operating cash flows, explain how the senior and mezz lending structure might be modified to provide an equitable outcome?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Full costing identifies: a. The price that should be charged for a service b. All indirect costs for a given service or product c. Total direct costs plus an allocated amount of indirect costs d....
-
This case study on project evaluation is applicable for beginning courses in corporate finance or finance strategy. Two alternative investment options are available to evaluate. Challenges are...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Analyze the case study, "Frank Smith Plumbing." Analyze the "Frank Smith Plumbing's Financial Statement" spreadsheet. Compare the cost of the truck to the cash flow records Compile your calculations...
-
Why is it important for strategic planning to consider the lifetime value of the customer?
-
A good source for formation data for compounds is the NIST Chemistry Web Book site. Values of Hf, but not of Gf are reported. Instead, values of absolute standard entropies S are listed for compounds...
-
You must determine whether there is a forecast bias in the forward rate. You apply regression analysis to test the relationship between the actual spot rate and the forward rate forecast (F): The...
-
What can a project manager do to avoid some of the pitfalls of a highly cohesive project team?
-
4) 17R Terminal Angle = sin 0 = csc = cose = sec = tan = cot 0 => 11T Terminal Angle = sin 0 = csc0 => cose = sec= tan e cot 0 => Terminal Angle= sin = csc0 = cos 0 = sec = tan 0 = cot 0 = Radians...
-
Given = 25 and == 4.8, what would be the x-value for the ninety-fifth percentile?
-
After Bernard Inc. completed its first year of operations on December 31, 2015, the following adjusted account balances appeared in the general ledger. Exercises 137 Prepaid Advertising 1,000...
-
Management fees will be paid quarterly, at 2% (annual) of the total limited partner commitment amount, and will be assesed pro-rata. Management fees will be offset by any placement fees paid, until...
-
The following amounts are the totals for each account after the journal entries are complete. Accounts Payable 740.00 Accounts Receivable 4,630.00 Accumulated Depreciation, Computer Equipment 252.00...
-
A capital call totaling $750,000 was issued (notice sent) on 6/1/21 with a due date (effective date) of 6/09/21 What is the GL entry, if any, on6/1/21? - Of the total capital call $750,000 issued on...
-
solve areas in yellow. Both labor variance and parts variance should equal 80,025 MRO Department - 2020 Results Change in Gross Margin 80,025 Revenues (billed out): Budget Actual Fav./(Unfav.) -...
-
Research and find an article related to the use of data and decision-making for organizations in the hospitality and tourism industry.WITH A BRIEF SUMMARY OF THE ARTICLE.
-
President Lee Coone has asked you to continue planning for an integrated corporate NDAS network. Ultimately, this network will link all the offices with the Tampa head office and become the...
-
Jud's Manufacturing Company produces one product, Kebo. Because of wide fluctuations in demand for Kebo, the Assembly Department experiences significant variations in monthly production levels. The...
-
Lorch Company uses budgets in controlling costs. The May 2002 budget report for the company's Packaging Department is as follows. The budget amounts in the report were on the master budget For the...
-
Lakem elder Dutch manufactures expensive watch eases sold as souvenirs. Three ol its sales departments are: Retail Sales, Wholesale Sales, and Outlet Sales. The Retail Sales Department is a profit...
Study smarter with the SolutionInn App