Please show calculations in excel. Thanks in advance

Consider a firm whose net income for the current year is $195 million, their target equity ratio is 75%, and the expected capital budget is $135 million. What are its distributions to be made to shareholders, according to the residual model? The firm has 80 million shares. Assume for now that the distribution is in the form of a dividend. What is the forecasted dividend payout ratio? What is the forecasted dividend per share. Net Income Target equity ratio Total capital budget Total Dividends $ Payout Ratio What if the expected capital budget rose to $155 million? Total capital budget Total Dividends $ Payout Ratio Suppose the firm has decided to distribute the amount you first calculated above, which it presently is holding in very liquid short-term investments. The firm's value of operations is estimated to be about $1,525million. The firm has $381.25 million in debt (it has no preferred stock). As mentioned previously the firm has 80 million shares of stock outstanding. Assume the firm has not yet made the distribution. What is the firm's intrinsic value of equity? What is its intrinsic per share stock price? Inputs Value of operations Short-term investments Debt Number of shares Now suppose the firm has just made the distribution in the form of dividends. What is the firm's intrinsic value of equity? What is its intrinsic per share stock price? Suppose instead that the firm has just made the distribution in the form of a stock repurchase. Now what is the firm's intrinsic value of equity? How many shares did the firm repurchase? How many shares remained outstanding after the repurchase? What is its intrinsic per share stock price after the repurchase? Consider a firm whose net income for the current year is $195 million, their target equity ratio is 75%, and the expected capital budget is $135 million. What are its distributions to be made to shareholders, according to the residual model? The firm has 80 million shares. Assume for now that the distribution is in the form of a dividend. What is the forecasted dividend payout ratio? What is the forecasted dividend per share. Net Income Target equity ratio Total capital budget Total Dividends $ Payout Ratio What if the expected capital budget rose to $155 million? Total capital budget Total Dividends $ Payout Ratio Suppose the firm has decided to distribute the amount you first calculated above, which it presently is holding in very liquid short-term investments. The firm's value of operations is estimated to be about $1,525million. The firm has $381.25 million in debt (it has no preferred stock). As mentioned previously the firm has 80 million shares of stock outstanding. Assume the firm has not yet made the distribution. What is the firm's intrinsic value of equity? What is its intrinsic per share stock price? Inputs Value of operations Short-term investments Debt Number of shares Now suppose the firm has just made the distribution in the form of dividends. What is the firm's intrinsic value of equity? What is its intrinsic per share stock price? Suppose instead that the firm has just made the distribution in the form of a stock repurchase. Now what is the firm's intrinsic value of equity? How many shares did the firm repurchase? How many shares remained outstanding after the repurchase? What is its intrinsic per share stock price after the repurchase