Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need to see excel work and formulas used to solve please 1. ABC Fund has decided to enter into a joint venture with Newtown Development

need to see excel work and formulas used to solve please
image text in transcribed
1. ABC Fund has decided to enter into a joint venture with Newtown Development Inc. to develop and operate an office building that will require an initial investment of $100 million to cover all the development costs (hard and soft costs). There will be no debt financing for the joint ven- -ture. Each party invests its capital at the beginning of the first year and cash flow from opera- tions is projected as follows: Year 1 Year 2 Year 3 Year 4 Year 5 $ 2,000,000 4,000,000 9,000,000 12,000,000 14,000,000 It is expected that the property will be sold at the end of year 5 for $150 million. ABC Fund will invest $45 million and Newtown Development Inc. will invest the remaining $55 million needed for the development costs. The $50 million development costs already include a developer fee to Newtown Development Inc, and the cash flow projec- tions for each year above are net of a property management fee being paid to Newtown Development Inc. ABC Fund will receive a 5 percent operating return that is noncumulative. That is, any short- fall is not carried over to the next year but is paid before Newtown Development Inc. receives any cash from operations. After ABC Fund is paid its preferred return, Newtown Development Inc. will receive a 5 percent operating return on its contributed capital. This is also noncumula- tive. Any remaining cash flow from operations is split 50-50 to each party. When the property is sold, proceeds from salc will be distributed as follows: First, repay the initial capital investment by ABC Fund. Next, repay the initial capital investment by Newtown Development Inc. Next, pay ABC Fund an 11 percent IRR preference on its investment. Thereafter, split all proceeds 50-50

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 Applications And Theory

Authors: Marcia Cornett, Troy Adair, John Nofsinger

5th Edition

1260013987, 9781260013986

More Books

Students also viewed these Finance questions

Question

Describe the ethical issues involved in conducting HRD evaluation

Answered: 1 week ago