I need assistance with the attached problems please. The questions are listed in column F and the instructions are as listed below:

You are required to use the textbook problems template in the Resources to complete the problems. This Excel document contains unique details and cells specific to the problems that you must use to derive your solutions. Where numeric solutions are expected, provide full detail of the process used to reach the solution using Excel. Where analysis is expected, use information from the textbook to inform your analysis, not replace it, incorporating creativity, critical thinking, and real-life perspectives. Cite all resource materials used in your analysis, using proper APA format.

UNIT 5: TEXTBOOK PROBLEMS CHAPTER 16: PROBLEM 1 Dividend Dividend Tax Stock Price $6.30 25% $83 Step 1: Calculate the After-Tax Dividend Step 2: Ex-Dividend Price = CHAPTER 16: PROBLEM 4 (a through d) # of shares of stock outstanding Stock Price A. B. C. D. 270,000 $73 CHAPTER 16: PROBLEM 7 Stock Dividend # of shares of stock outstanding 25% 25,000 Market Value Balance Sheet: Cash Fixed Assets Total $145,000 $598,000 $743,000 Debt Equity Total $127,000 $616,000 $743,000 Find the market price of stock by using the equity and # of shares outstanding New shares outstanding = New Stock price = CHAPTER 16: PROBLEM 16a Dividend Payout Ratio Earnings Per Share Adjustment Rate Dividend 1 year from now = $2.05 40% $6.20 0.3 Midnight Hour, Inc.,has declared a $6.30 per share dividend. Suppose capital gaines are not taxed, but dividends are taxed at 25 percent. New IRS regulations requires that taxes be withheld at the time the dividend is paid. Midnight Hour sells for $83 per share, and the stock is about to go ex dividend. What do you think the ex-dividend price will be? Roll Corporation currently has 270,000 shares of stock outstanding that sell for $73 per share. Assuming no market imperfections or tax effects exist, what will the share price be after: a. RC has a five-for-three stock split? b. RC has a 15 percent stock dividend? c. RC has a 42.5 percent stock dividend? d. RC has a four-for-seven reverse stock split? Determine the new number of shares outstanding in parts (a) through (d). The market value balance sheet for Outbox Manufacturing is shown there. Outbox has declared a 25 percent stock dividend. The stock goes ex dividend tomorrow (the chronology for a stock dividend is similar to that for a cash dividend). There are 25,000 shares of stock outstanding. What will the ex-dividend price be? The Sharpe Co. just paid a dividend of $2.05 per share of stock. Its target payout ratio is 40 percent. The company expects to have earnings per share of $6.20 one year from now. If the adjustment rate is .3 in the Lintner model, what is the dividend one year from now