Please when answering the question for a, b, c, and d to use the spreadsheet format which follows:

3. McCaffrey's Inc. has never paid a dividend, and when the firm might begin paying dividends is not known. Its current free cash flow (FCF) is $100,000, and this FCF is expected to grow at a constant 7% rate. The weighted average cost of capital (WACC) is 11%. McCaffrey's currently holds $325,000 of nonoperating marketable securities. Its long-term debt is $1,000,000, but it has never issued preferred stock. McCaffrey's has 50,000 shares of stock outstanding. Calculate the following: a. McCaffrey's value of operations b. The company's total value c. The estimated value of common equity d. The estimated per-share stock price 3a. Calculate McCaffrey's value of operations. 3b. Calculate the company's total value. 3c. Calculate the estimated value of common equity. 3d. Calculate the estimated per-share stock price