Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please with all parts and label answers You are advising a group of investors who are considering the purchase of a shopping center complex. They

Please with all parts and label answers

image text in transcribedimage text in transcribedimage text in transcribed

You are advising a group of investors who are considering the purchase of a shopping center complex. They would like to finance 75 percent of the purchase price. A loan has been offered to them on the following terms: The contract interest rate is 4 percent and will be amortized with monthly payments over 20 years. The loan also will have an equity participation of 40 percent of the cash flow after debt service. The loan has a "lockout" provision that prevents it from being prepaid before year 5. The property is expected to cost $5.5 million. NOl is estimated to be $400,000, including overages, during the first year, and to increase at the rate of 2 percent per year for the next five years. The property is expected to be worth $6.25 million at the end of five years. The improvement represents 80 percent of cost, and depreciation will be over 39 years with no mid-month convention for year 1 to keep it simple. Assume a 35 percent tax bracket for ordinary income, a 25 percent for depreciation recapture, and 20 percent for capital gains taxes and a holding period of five years. Required: a. Compute the BTIRR and ATIRR after five years, taking into account the equity participation. b. What would the BEIR be on such a project? What is the projected cost of the equity participation financing? c. Is there favorable leverage with the proposed loan? Complete this question by entering your answers in the tabs below. Compute the BTIRR and ATIRR after five years, taking into account the equity participation. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Complete this question by entering your answers in the tabs below. What would the BEIR be on such a project? What is the projected cost of the equity participation financing? (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Complete this question by entering your answers in the tabs below. Is there favorable leverage with the proposed loan? You are advising a group of investors who are considering the purchase of a shopping center complex. They would like to finance 75 percent of the purchase price. A loan has been offered to them on the following terms: The contract interest rate is 4 percent and will be amortized with monthly payments over 20 years. The loan also will have an equity participation of 40 percent of the cash flow after debt service. The loan has a "lockout" provision that prevents it from being prepaid before year 5. The property is expected to cost $5.5 million. NOl is estimated to be $400,000, including overages, during the first year, and to increase at the rate of 2 percent per year for the next five years. The property is expected to be worth $6.25 million at the end of five years. The improvement represents 80 percent of cost, and depreciation will be over 39 years with no mid-month convention for year 1 to keep it simple. Assume a 35 percent tax bracket for ordinary income, a 25 percent for depreciation recapture, and 20 percent for capital gains taxes and a holding period of five years. Required: a. Compute the BTIRR and ATIRR after five years, taking into account the equity participation. b. What would the BEIR be on such a project? What is the projected cost of the equity participation financing? c. Is there favorable leverage with the proposed loan? Complete this question by entering your answers in the tabs below. Compute the BTIRR and ATIRR after five years, taking into account the equity participation. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Complete this question by entering your answers in the tabs below. What would the BEIR be on such a project? What is the projected cost of the equity participation financing? (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Complete this question by entering your answers in the tabs below. Is there favorable leverage with the proposed loan

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

Finance For IT Decision Makers

Authors: Michael Blackstaff

3rd Edition

1780171226, 978-1780171227

More Books

Students also viewed these Finance questions