Please show in EXCEL

An institutional investor is comparing management fees for two competing real estate investment funds. Both funds expect to begin operations and are accepting capital commitments. When the funds begin acquiring properties, capital calls will be made for capital contributions during the investment period. Fund A will charge a fee of 45 BP on capital committed and 60 BP on capital invested after the investment period ends. Fund B will charge a fee of 50BP on capital committed and 55BP on capital invested after the investment period ends. Both funds expect to have $507,000,000 in capital commitments when the fund commences operations and both project a five-year cycle for startup and acquisitions. Capital flows are expected as follows: Find Fund B Required: a. What will total fees be for Fund (A)? For Fund (B)? b. Would one of the fee structures cause the manager to want to hold the properties longer before selling than the other fee structure? if so, which one? An institutional investor is comparing management fees for two competing real estate investment funds. Both funds expect to begin operations and are accepting capital commitments. When the funds begin acquiring properties, capital calls will be made for capital contributions during the investment period. Fund A will charge a fee of 45 BP on capital committed and 60 BP on capital invested after the investment period ends. Fund B will charge a fee of 50BP on capital committed and 55BP on capital invested after the investment period ends. Both funds expect to have $507,000,000 in capital commitments when the fund commences operations and both project a five-year cycle for startup and acquisitions. Capital flows are expected as follows: Find Fund B Required: a. What will total fees be for Fund (A)? For Fund (B)? b. Would one of the fee structures cause the manager to want to hold the properties longer before selling than the other fee structure? if so, which one