I need to know how to solve this in excel format. Please show instructions on how to solve it in excel and the formulas that would go in each cell if any. Thanks so much for your help!!!

ABC Fund has decided to enter into a joint venture with Newton Development Inc. to develop and operate an office building that will require an initial investment of $200 million to cover all the development costs. There will be no debt financing for the joint venture. Each part invests its capital at the beginning of the first year and cash flow from operations is projected as follows: Year 1 Year 2 Year 3 Year 4 Year 5 $3,000,000 $5,000,000 $12,000,000 25,000,000 45,000,000 It is expected that the property will sell for $270 million at the end of year 5 ABC Fund will invest $150 million and Newton Development will invest the remaining $50 million. The development costs already include a developer fee to Newton and the cash flow projections for each year above are net of a property management fee being paid to Newton Development Inc. ABC Fund will receive a 5% operating return that is noncumulative. After ABC is paid its preferred return Newton Development Inc. will receive a 5% operating return that is noncumulative on its contributed capital. Remaining cash flows from operation, if any, will be split 50-50 to each party. When the property is sold, proceeds from the sale will be distributed as follows 1. 2. 3. 4. First, repay the initial capital investment by ABC Fund Next, repay the initial capital investment by Newton Development Inc. Next, pay ABC fund a 13 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 expected IRR