Please solve the problems C and D by using excel and showing all work

Your employer, a mid-sized human resources management company, is considering expan- sion into related fields, including the acquisition of Temp Force Company, an employment agency that supplies word processor operators and computer programmers to businesses with temporary heavy workloads. Your employer is also considering the purchase of Bigger- staff & McDonald (B&M), a privately held company owned by two friends, each with 5 million shares of stock. B&M currently has free cash flow of $24 million, which is expected to grow at a constant rate of 5%. B&M's financial statements report short-term investments of $100 million, debt of $200 million, and preferred stock of $50 million. B&M's weighted average cost of capital (WACC) is 11%. Answer the following questions. c. Use a pie chart to illustrate the sources that comprise a hypothetical company's total value. Using another pie chart, show the claims on a company's value. How is equity a residual claim? d. Suppose the free cash flow at Time 1 is expected to grow at a constant rate of g, forever. If g,