please show work in excel. 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 5100 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 fce 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 sale 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. Use the above assumptions to calculate the cash flows that each party will receive and its expected IRR please show work in excel. 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 5100 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 fce 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 sale 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. Use the above assumptions to calculate the cash flows that each party will receive and its expected IRR