Please show all work including excel pie charts. Your employer, a midsized human resources management company, is considering expansion into related fields, including the acquisition of Temp Force Company, an employment agency that supplies word processor operators and computer programmers to businesses with temporarily heavy workloads. Your employer is also considering the purchase of Biggerstaff & 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\%.$ 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?